Problem with connecting to MySQL8.0 (ActiveMQ 5.15.5)

[朱慧宁 <bu...@126.com>]

Hello team,
    My activeMQ cluster running on master-slave mode.Two nodes try aquiring mysql lock to become master.I upgrade the MySQL from 5.7 to 8.0，and noticed that it will crash every 4-5 days.It will goes will shortly after i restart the service.
The error log is like:
 


It seems that the problem lies in the database link.Mysql config in activemq.xml is below:

       <persistenceAdapter>


          <!-- <kahaDB directory="${activemq.base}/data/kahadb"/>useDatabaseLock="true" createTablesOnStartup="false"   -->


               <jdbcPersistenceAdapter dataDirectory="${activemq.base}/data" dataSource="#mysql-ds" useDatabaseLock="true" createTablesOnStartup="false"/>


       </persistenceAdapter>




And i replace jars in ${activemq_home}/lib: