Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

Message archiving fails on Postgres

Description

Message archiving fails under Postgres with batch insert errors.

Environment

None

Activity

Show:

Gaston Dombiak July 13, 2006 at 10:47 AM

The issue was also affecting DB2.

Gaston Dombiak July 13, 2006 at 9:55 AM

The problem was being triggered by this exception:

org.postgresql.util.PSQLException: ERROR: integer out of range
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1512)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1297)
at org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:347)
at org.postgresql.jdbc2.AbstractJdbc2Statement.executeBatch(AbstractJdbc2Statement.java:2540)
at com.jivesoftware.wildfire.enterprise.archive.ConversationManager$ArchivingTask.run(ConversationManager.java:515)

The root problem is that we are storing dates as INTEGERs that is a 4 bytes field. Therefore we can only store values in the range of -2147483648 to +2147483647.

Fixed

Details

Assignee

Reporter

Fix versions

Affects versions

Priority

Created July 7, 2006 at 1:41 AM
Updated July 13, 2006 at 10:47 AM
Resolved July 13, 2006 at 10:47 AM