In logs, below error is reported 2018-10-10 00:16:19,766 ERROR [Timer-Driven Process Thread-1] o.a.n.c.m.processors.CaptureChangeMySQL CaptureChangeMySQL[id=3c3f6e89-8401-3a67-a49d-3af14abf13dc] Error in getting DDL Table info create table .... : com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: No operations allowed after connection closed.
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: The last packet successfully received from the server was 58,006,344 milliseconds ago. The last packet sent successfully to the server was 58,006,345 milliseconds ago. is longer than the server configured value of 'wait_timeout'. You should consider either expiring and/or testing connection validity before use in your application, increasing the server configured values for client timeouts, or using the Connector/J connection property 'autoReconnect=true' to avoid this problem. It happened because the connection got stale / dead after 8 hours. How to keep alive CaptureChangeMySQL processor connection with DB ? One way would be increasing 'wait_timeout' to high value but the error can still occur post that time. How to keep alive connection forever unless processor is stopped? On Wed, Oct 10, 2018 at 4:41 PM Anand Dev <[email protected]> wrote: > When I start the CaptureChangeMySQL processor, it worked fine till the > point when DDL event occured for Creating a table. > > Processor captured the CREATE table event successfully. > Next, when record was inserted in the newly created table, it threw below > error and stopped capturing further events. > > ERROR > =============== > Binlog connector communications failure: could not find next log; the > first event 'bin_5101.000013' at 921485, the last event read from > '/u01/mysql/5101/var/log/binlogs/bin_5101.000013' at 921565, the last byte > read from '/u01/mysql/5101/var/log/binlogs/bin_5101.000013' at 921565 > > com.github.shyiko.mysql.binlog.network.ServerException: could not find > next log; the first event 'bin_5101.000013' at 921485, the last event read > from '/u01/mysql/5101/var/log/binlogs/bin_5101.000013' at 921565, the last > byte read from '/u01/mysql/5101/var/log/binlogs/bin_5101.000013' at 921565 > ================ > > Can someone suggest what's going wrong here? >
