[AMQNET-803] No SQL Statement DELETE FROM ACTIVEMQ_MSGS WHERE ID= for some messages in SQL Log

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: OpenWire-1.8.0
• Component/s: OpenWire

Environment

ActiveMQ 5.16.1 - 

Logger Config:

log4j.rootLogger=DEBUG, console, logfile
log4j.logger.org.apache.activemq=TRACE
log4j.logger.org.apache.activemq.spring=WARN
log4j.logger.org.apache.activemq.web.handler=WARN
log4j.logger.org.springframework=WARN
log4j.logger.org.apache.xbean=WARN
log4j.logger.org.apache.camel=DEBUG
log4j.logger.org.eclipse.jetty=WARN

<bean id="mysql-ds" class="org.apache.commons.dbcp2.BasicDataSource" destroy-method="close">
                <property name="driverClassName" value="com.mysql.jdbc.Driver"/>

• MySQL 8.0.21 galera cluster 3 Nodes
•  

• Assignee: Unassigned
• Reporter: Andre
• Created: 27/Sep/22 14:25
• Updated: 27/Sep/22 14:25

Description

After MessageAck in ActiveMQ  we see DELETE FROM ACTIVEMQ_MSGS WHERE ID= "MsgNR" in SQL server Logs

but for some messages there is no 

SQL Statement DELETE FROM ACTIVEMQ_MSGS WHERE ID="MsgNR"  in SQL Log.

The message stay in the DB.

How to activate SQL Statement logging to see the Cleaning up "DELETE FROM ACTIVEMQ_MSGS WHERE ID= "MsgNR"  in ActiveMQ logs?