Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 3.0.0
-
Fix Version/s: 3.0.1
-
Component/s: None
-
Labels:None
-
Acceptance Test - Add?:No
Description
Message archiving fails under Postgres with batch insert errors.
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.