activemq-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Yves Sandfort (JIRA)" <j...@apache.org>
Subject [jira] Created: (AMQ-1762) Field Type for ID column on table activemq_msgs should be increased from integer to bigint for postgres
Date Tue, 03 Jun 2008 08:36:00 GMT
Field Type for ID column on table activemq_msgs should be increased from integer to bigint
for postgres
-------------------------------------------------------------------------------------------------------

                 Key: AMQ-1762
                 URL: https://issues.apache.org/activemq/browse/AMQ-1762
             Project: ActiveMQ
          Issue Type: Bug
          Components: Message Store
    Affects Versions: 5.1.0
         Environment: Linux, with Postgres/EnterpriseDB
            Reporter: Yves Sandfort


As the postgres size for an int is limited to: 2147483647 you can easily reach that number
on a loaded ActiveMQ server within weeks. This is very hard to nail issue, as you get an exception
like: Batch entry 0 INSERT INTO ACTIVEMQ_MSGS(ID, MSGID_PROD, MSGID_SEQ, CONTAINER, EXPIRATION,
MSG) VALUES (2152101302, ID:cnmacoll2.ms.de.cdip.net-2970-1212478745177-0:1397:1:1, 1, queue://CNMACollector_1000474_1000474,
0, <stream of 820 bytes>) was aborted.

Which gives you no clue about the real issue, so we searched for all kinds of issues around.


However we figured out it was the ID column.

Not sure if this happens on other plattforms too, but at least on all PostgreSQL versions.

While checking this, someone should make sure that not the ID inside the java code will be
the next issue.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.


Mime
View raw message