Message archiving fails on Postgres

Details

  • Type: Bug Bug
  • Status: Closed Closed
  • Priority: Critical 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.

Activity

Ascending order - Click to sort in descending order
Hide
Permalink
Gaston Dombiak added a comment -

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.

Show
Gaston Dombiak added a comment - 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.
Hide
Permalink
Gaston Dombiak added a comment -

The issue was also affecting DB2.

Show
Gaston Dombiak added a comment - The issue was also affecting DB2.

People

  • Assignee:
    Matt Tucker
    Reporter:
    Matt Tucker
Vote (1)
Watch (1)

Dates

  • Created:
    Updated:
    Resolved: