We're updating the issue view to help you get more done. 

Message archiving fails on Postgres

Description

Message archiving fails under Postgres with batch insert errors.

Environment

None

Acceptance Test - Entry

None

Activity

Show:
Gaston Dombiak
July 13, 2006, 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.

Gaston Dombiak
July 13, 2006, 10:47 AM

The issue was also affecting DB2.

Assignee

MattM

Reporter

MattM

Labels

None

Expected Effort

None

Ignite Forum URL

None

Fix versions

Affects versions

Priority

Critical
Configure