OK, extracting one SUB_NAME and CLIENT_ID combo, something else looks wrong here:
Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25026\, XID = NULL WHERE CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' Query,UPDATE ACTIVEMQ_ACKS SET LAST_ACKED_ID=25027\, XID = NULL WHERE CONTAINER='topic://testTopic' AND CLIENT_ID='AP8DA27' AND SUB_NAME='test3' Notice that the ACK ID 25026 is updated, then 25027, and then both again. Perhaps I'm misreading the Ops pasted content. -- View this message in context: http://activemq.2283324.n4.nabble.com/Too-many-updates-in-MySQL-tp4700512p4700740.html Sent from the ActiveMQ - Dev mailing list archive at Nabble.com.
