After an issue with a hosts configuration - and much debugging we decided to trial moving our Openvpms mega app  into containers for production - it has run as a mega app for 10 years or so  - so this wasnt a move we were going to ride cowboy into.

We have been trialing various docker configurations on multiple hosts - one thing I started to notice was Aborted Connections in the mysql logs.
 

I hadnt seent his before - but then I hadnt rebuilt the database in a long while either. 

The errors are occuring on the CREATE scripts atleast twice and once on the ./dataload setup as well 

I havent run the  a test instance with a full sql backup yet to know if it occurs on a full dataset.  
 

The setup was 2 docker containers - one for tomcat and one for mysql.  

The error was similar too:

2022-11-11T09:43:19.846492+10:00 545 [Note] Aborted connection 545 to db: 'test_db' user: 't_openvpms' host: '10.1.3.100' (Got an error reading communication packets)

I have actually gone back and rerun the create  / setup on the production mysql instance and I get exactly

the same errors.

I tested using both the v8 connector and the old v5.x

I enable the general log while testing to get a look at the offending queries.  I was not getting packet errors on the client end .  I have seen that historically when max packet was set too low...the servers had max packets set to 132M so I didnt believe that was the issue.  Which leaves 3 other possibilities

1. The application isnt closing the connections properly
2. The connections are timeing out on the application side. - I wasnt seenting a lot of Waiting connections in net stat to support this...also see the query timings below...unless the applicaton wait time is less than 10ms this isnt the case.

3.  The are network errors causing packet truncation. - given its occuring on multiple hosts both with dockerization and without.  I dont think this is the cause.

I have testing now on multiple hosts with both mysql:5.7 and percona:5.7  I can confirm I can get the same errors.

I have included the general log for one of the aborted connections below 

sudo cat /var/log/mysql/general.log |grep -e '533 Query'
2022-11-11T09:04:30.399859+10:00 533 Query /* mysql-connector-java-8.0.27 (Revision: e920b979015ae7117d60d72bcc8f077a839cd791) */SELECT @@session.auto_inc
rement_increment AS auto_increment_increment, @@character_set_client AS character_set_client, @@character_set_connection AS character_set_connection, @@character_set_re
sults AS character_set_results, @@character_set_server AS character_set_server, @@collation_server AS collation_server, @@collation_connection AS collation_connection,
@@init_connect AS init_connect, @@interactive_timeout AS interactive_timeout, @@license AS license, @@lower_case_table_names AS lower_case_table_names, @@max_allowed_pa
cket AS max_allowed_packet, @@net_write_timeout AS net_write_timeout, @@performance_schema AS performance_schema, @@query_cache_size AS query_cache_size, @@query_cache_
type AS query_cache_type, @@sql_mode AS sql_mode, @@system_time_zone AS system_time_zone, @@time_zone AS time_zone, @@transaction_isolation AS transaction_isolation, @@
wait_timeout AS wait_timeout
2022-11-11T09:04:30.400159+10:00 533 Query SHOW WARNINGS
2022-11-11T09:04:30.400452+10:00 533 Query SET character_set_results = NULL
2022-11-11T09:04:30.400613+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.415341+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.417503+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.417947+10:00 533 Query commit
2022-11-11T09:04:30.418064+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.418171+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.418282+10:00 533 Query commit
2022-11-11T09:04:30.418382+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.472350+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.477763+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.477955+10:00 533 Query commit
2022-11-11T09:04:30.478064+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.478169+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.478270+10:00 533 Query commit
2022-11-11T09:04:30.478368+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.478561+10:00 533 Query USE `test_db`
2022-11-11T09:04:30.481765+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.483475+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.483926+10:00 533 Query SELECT COUNT(*) FROM information_schema.schemata WHERE schema_name='test_db'
2022-11-11T09:04:30.484465+10:00 533 Query commit
2022-11-11T09:04:30.484581+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.486194+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.486354+10:00 533 Query commit
2022-11-11T09:04:30.486460+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.486565+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.486667+10:00 533 Query commit
2022-11-11T09:04:30.487405+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.487532+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.487635+10:00 533 Query commit
2022-11-11T09:04:30.487737+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.488251+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.489211+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.489981+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.490545+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.492098+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.495641+10:00 533 Query SELECT @@session.transaction_read_only
2022-11-11T09:04:30.495939+10:00 533 Query CREATE TABLE `test_db`.`schema_version` (
2022-11-11T09:04:30.617709+10:00 533 Query SHOW WARNINGS
2022-11-11T09:04:30.618069+10:00 533 Query SELECT @@session.transaction_read_only
2022-11-11T09:04:30.618260+10:00 533 Query CREATE INDEX `schema_version_s_idx` ON `test_db`.`schema_version` (`success`)
2022-11-11T09:04:30.722057+10:00 533 Query SHOW WARNINGS
2022-11-11T09:04:30.722565+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.724954+10:00 533 Query SELECT MAX(`installed_rank`) FROM `test_db`.`schema_version`
2022-11-11T09:04:30.726426+10:00 533 Query INSERT INTO `test_db`.`schema_version` (`installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`ins
talled_by`,`execution_time`,`success`) VALUES (1, '2.3.0.1', 'OVPMS-2626', 'BASELINE', 'OVPMS-2626', null, SUBSTRING_INDEX(USER(),'@',1), 0, 1)
2022-11-11T09:04:30.726776+10:00 533 Query commit
2022-11-11T09:04:30.750346+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.751030+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.751147+10:00 533 Query commit
2022-11-11T09:04:30.751240+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.751335+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.751427+10:00 533 Query commit
2022-11-11T09:04:30.751516+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.751609+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.751697+10:00 533 Query commit
2022-11-11T09:04:30.751786+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.751914+10:00 533 Query USE `test_db`
2022-11-11T09:04:30.758171+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.760105+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.760830+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:30.762386+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:30.762916+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.763017+10:00 533 Query commit
2022-11-11T09:04:30.763107+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.763197+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.763283+10:00 533 Query commit
2022-11-11T09:04:30.763382+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.763472+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.763558+10:00 533 Query commit
2022-11-11T09:04:30.763643+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.763733+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.763838+10:00 533 Query commit
2022-11-11T09:04:30.763926+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.793454+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.794375+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.795561+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:30.797401+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.797525+10:00 533 Query commit
2022-11-11T09:04:30.797621+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.797710+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.797794+10:00 533 Query commit
2022-11-11T09:04:30.797881+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.797969+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.798053+10:00 533 Query commit
2022-11-11T09:04:30.798137+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.798224+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.798306+10:00 533 Query commit
2022-11-11T09:04:30.798389+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.798496+10:00 533 Query USE `test_db`
2022-11-11T09:04:30.800038+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.800970+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.801587+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:30.802281+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:30.802774+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.802872+10:00 533 Query commit
2022-11-11T09:04:30.802960+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.803047+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.803133+10:00 533 Query commit
2022-11-11T09:04:30.803216+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.803303+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.803385+10:00 533 Query commit
2022-11-11T09:04:30.803467+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.803553+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.803634+10:00 533 Query commit
2022-11-11T09:04:30.803715+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.803800+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.803882+10:00 533 Query commit
2022-11-11T09:04:30.803964+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.830003+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.830883+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.831528+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:30.832819+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.832933+10:00 533 Query commit
2022-11-11T09:04:30.833022+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.833112+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.833197+10:00 533 Query commit
2022-11-11T09:04:30.833284+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.833384+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.833486+10:00 533 Query commit
2022-11-11T09:04:30.833569+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.833667+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.833755+10:00 533 Query commit
2022-11-11T09:04:30.833844+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.833931+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.834019+10:00 533 Query commit
2022-11-11T09:04:30.834102+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.834206+10:00 533 Query USE `test_db`
2022-11-11T09:04:30.835805+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.838220+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.838790+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:30.839502+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:30.839970+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.840069+10:00 533 Query commit
2022-11-11T09:04:30.840159+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.840250+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.840336+10:00 533 Query commit
2022-11-11T09:04:30.840424+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.840514+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.840598+10:00 533 Query commit
2022-11-11T09:04:30.840683+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.840773+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.840861+10:00 533 Query commit
2022-11-11T09:04:30.840946+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.841034+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.841119+10:00 533 Query commit
2022-11-11T09:04:30.841203+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.841292+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.841394+10:00 533 Query commit
2022-11-11T09:04:30.841482+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.870678+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.871690+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.872342+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:30.873638+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.873762+10:00 533 Query commit
2022-11-11T09:04:30.873850+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.873938+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.874019+10:00 533 Query commit
2022-11-11T09:04:30.874100+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.874187+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.874267+10:00 533 Query commit
2022-11-11T09:04:30.874347+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.874432+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.874514+10:00 533 Query commit
2022-11-11T09:04:30.874594+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.874678+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.874758+10:00 533 Query commit
2022-11-11T09:04:30.874837+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.874924+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.875003+10:00 533 Query commit
2022-11-11T09:04:30.875083+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.875194+10:00 533 Query USE `test_db`
2022-11-11T09:04:30.876904+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.877789+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.878412+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:30.879155+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:30.879653+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.879751+10:00 533 Query commit
2022-11-11T09:04:30.879854+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.879942+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.880025+10:00 533 Query commit
2022-11-11T09:04:30.880106+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.880192+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.880272+10:00 533 Query commit
2022-11-11T09:04:30.880354+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.880443+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.880524+10:00 533 Query commit
2022-11-11T09:04:30.880609+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.880695+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.880776+10:00 533 Query commit
2022-11-11T09:04:30.880858+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.880946+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.881027+10:00 533 Query commit
2022-11-11T09:04:30.881109+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.881194+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.881275+10:00 533 Query commit
2022-11-11T09:04:30.881370+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.926704+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.927793+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:30.928716+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:30.930723+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.930868+10:00 533 Query commit
2022-11-11T09:04:30.930966+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.931064+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.931156+10:00 533 Query commit
2022-11-11T09:04:30.931251+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.931346+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.931437+10:00 533 Query commit
2022-11-11T09:04:30.931528+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.931627+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.931717+10:00 533 Query commit
2022-11-11T09:04:30.931808+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.931903+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.931993+10:00 533 Query commit
2022-11-11T09:04:30.932092+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.932186+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.932280+10:00 533 Query commit
2022-11-11T09:04:30.932371+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.932469+10:00 533 Query SET autocommit=0
2022-11-11T09:04:30.932560+10:00 533 Query commit
2022-11-11T09:04:30.932654+10:00 533 Query SET autocommit=1
2022-11-11T09:04:30.932780+10:00 533 Query USE `test_db`
2022-11-11T09:04:31.072260+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.073117+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.075084+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:31.076443+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:31.077080+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.077194+10:00 533 Query commit
2022-11-11T09:04:31.077293+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.077405+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.077501+10:00 533 Query commit
2022-11-11T09:04:31.077593+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.077688+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.077779+10:00 533 Query commit
2022-11-11T09:04:31.077871+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.077966+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.078056+10:00 533 Query commit
2022-11-11T09:04:31.078147+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.078242+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.078351+10:00 533 Query commit
2022-11-11T09:04:31.078634+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.078737+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.078830+10:00 533 Query commit
2022-11-11T09:04:31.078933+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.079028+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.079123+10:00 533 Query commit
2022-11-11T09:04:31.079214+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.079309+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.079402+10:00 533 Query commit
2022-11-11T09:04:31.079907+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.115427+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.116292+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.117470+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:31.121845+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.122008+10:00 533 Query commit
2022-11-11T09:04:31.122106+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.122203+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.122295+10:00 533 Query commit
2022-11-11T09:04:31.122386+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.122482+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.122573+10:00 533 Query commit
2022-11-11T09:04:31.122665+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.122760+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.122851+10:00 533 Query commit
2022-11-11T09:04:31.122942+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.123037+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.123128+10:00 533 Query commit
2022-11-11T09:04:31.123219+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.123314+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.123418+10:00 533 Query commit
2022-11-11T09:04:31.123515+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.123610+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.123701+10:00 533 Query commit
2022-11-11T09:04:31.123791+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.123885+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.123977+10:00 533 Query commit
2022-11-11T09:04:31.124067+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.124189+10:00 533 Query USE `test_db`
2022-11-11T09:04:31.127859+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.128589+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.129050+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:31.129691+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:31.130092+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.130192+10:00 533 Query commit
2022-11-11T09:04:31.130283+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.130373+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.130459+10:00 533 Query commit
2022-11-11T09:04:31.130545+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.130638+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.130722+10:00 533 Query commit
2022-11-11T09:04:31.130807+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.130897+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.130982+10:00 533 Query commit
2022-11-11T09:04:31.131067+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.131160+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.131250+10:00 533 Query commit
2022-11-11T09:04:31.131335+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.131423+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.131508+10:00 533 Query commit
2022-11-11T09:04:31.131593+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.131681+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.131780+10:00 533 Query commit
2022-11-11T09:04:31.131865+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.131953+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.132038+10:00 533 Query commit
2022-11-11T09:04:31.132124+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.132212+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.132297+10:00 533 Query commit
2022-11-11T09:04:31.132381+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.164723+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.165987+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.166647+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:31.169061+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.169212+10:00 533 Query commit
2022-11-11T09:04:31.169304+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.169410+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.169608+10:00 533 Query commit
2022-11-11T09:04:31.169698+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.169787+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.169872+10:00 533 Query commit
2022-11-11T09:04:31.169960+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.170049+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.170134+10:00 533 Query commit
2022-11-11T09:04:31.170221+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.170311+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.170395+10:00 533 Query commit
2022-11-11T09:04:31.170481+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.170570+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.170654+10:00 533 Query commit
2022-11-11T09:04:31.170739+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.170828+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.170912+10:00 533 Query commit
2022-11-11T09:04:31.170997+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.171086+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.171170+10:00 533 Query commit
2022-11-11T09:04:31.171255+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.171343+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.171428+10:00 533 Query commit
2022-11-11T09:04:31.171512+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.171628+10:00 533 Query USE `test_db`
2022-11-11T09:04:31.173139+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.175152+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.177513+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:31.178700+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:31.179171+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.179274+10:00 533 Query commit
2022-11-11T09:04:31.179372+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.179461+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.179547+10:00 533 Query commit
2022-11-11T09:04:31.179633+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.179722+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.179806+10:00 533 Query commit
2022-11-11T09:04:31.179893+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.179981+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.180064+10:00 533 Query commit
2022-11-11T09:04:31.180148+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.180236+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.180319+10:00 533 Query commit
2022-11-11T09:04:31.180404+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.180494+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.180580+10:00 533 Query commit
2022-11-11T09:04:31.180666+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.180756+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.180858+10:00 533 Query commit
2022-11-11T09:04:31.180943+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.181031+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.181116+10:00 533 Query commit
2022-11-11T09:04:31.181200+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.181287+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.181385+10:00 533 Query commit
2022-11-11T09:04:31.181479+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.181571+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.181656+10:00 533 Query commit
2022-11-11T09:04:31.181741+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.202784+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.203536+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.204334+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:31.207104+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.207254+10:00 533 Query commit
2022-11-11T09:04:31.207347+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.207437+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.207524+10:00 533 Query commit
2022-11-11T09:04:31.207609+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.207708+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.207793+10:00 533 Query commit
2022-11-11T09:04:31.207881+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.207970+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.208055+10:00 533 Query commit
2022-11-11T09:04:31.208147+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.208246+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.208338+10:00 533 Query commit
2022-11-11T09:04:31.208433+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.208538+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.208633+10:00 533 Query commit
2022-11-11T09:04:31.208728+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.208828+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.208921+10:00 533 Query commit
2022-11-11T09:04:31.209007+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.209101+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.209186+10:00 533 Query commit
2022-11-11T09:04:31.209270+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.209379+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.209468+10:00 533 Query commit
2022-11-11T09:04:31.209553+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.209643+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.209727+10:00 533 Query commit
2022-11-11T09:04:31.209813+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.209943+10:00 533 Query USE `test_db`
2022-11-11T09:04:31.212974+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.214293+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.215178+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:04:31.216011+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:04:31.218210+10:00 533 Query SELECT COUNT(*) FROM information_schema.schemata WHERE schema_name='test_db'
2022-11-11T09:04:31.219071+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.219203+10:00 533 Query commit
2022-11-11T09:04:31.219298+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.219394+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.219489+10:00 533 Query commit
2022-11-11T09:04:31.219574+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.219663+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.219996+10:00 533 Query commit
2022-11-11T09:04:31.220087+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.220178+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.220264+10:00 533 Query commit
2022-11-11T09:04:31.220366+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.220455+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.220539+10:00 533 Query commit
2022-11-11T09:04:31.220623+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.220710+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.220794+10:00 533 Query commit
2022-11-11T09:04:31.220878+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.220968+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.221055+10:00 533 Query commit
2022-11-11T09:04:31.221142+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.221229+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.221313+10:00 533 Query commit
2022-11-11T09:04:31.221413+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.221504+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.221588+10:00 533 Query commit
2022-11-11T09:04:31.221671+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.221759+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.221842+10:00 533 Query commit
2022-11-11T09:04:31.221926+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.222014+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.222097+10:00 533 Query commit
2022-11-11T09:04:31.222180+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.222837+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.244605+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.246477+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.247186+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:04:31.249330+10:00 533 Query commit
2022-11-11T09:04:31.249511+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.250539+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.250671+10:00 533 Query commit
2022-11-11T09:04:31.250762+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.250853+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.250941+10:00 533 Query commit
2022-11-11T09:04:31.251027+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.251120+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.251206+10:00 533 Query commit
2022-11-11T09:04:31.252891+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.253040+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.253133+10:00 533 Query commit
2022-11-11T09:04:31.253217+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.253303+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.253405+10:00 533 Query commit
2022-11-11T09:04:31.253490+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.253580+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.253866+10:00 533 Query commit
2022-11-11T09:04:31.254050+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.254140+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.254252+10:00 533 Query commit
2022-11-11T09:04:31.254337+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.254423+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.254507+10:00 533 Query commit
2022-11-11T09:04:31.254590+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.254676+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.254760+10:00 533 Query commit
2022-11-11T09:04:31.254843+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.254929+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.255013+10:00 533 Query commit
2022-11-11T09:04:31.255095+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.255182+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.255265+10:00 533 Query commit
2022-11-11T09:04:31.255347+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.255473+10:00 533 Query USE `test_db`
2022-11-11T09:04:31.255590+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.255877+10:00 533 Query SELECT COUNT(*) FROM information_schema.schemata WHERE schema_name='test_db'
2022-11-11T09:04:31.256307+10:00 533 Query commit
2022-11-11T09:04:31.256396+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.256590+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.259684+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.259868+10:00 533 Query commit
2022-11-11T09:04:31.259965+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.260057+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.260144+10:00 533 Query commit
2022-11-11T09:04:31.260228+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.260315+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.260399+10:00 533 Query commit
2022-11-11T09:04:31.260486+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.260573+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.260677+10:00 533 Query commit
2022-11-11T09:04:31.260762+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.260852+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.260936+10:00 533 Query commit
2022-11-11T09:04:31.261019+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.261106+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.261191+10:00 533 Query commit
2022-11-11T09:04:31.261273+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.261377+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.261466+10:00 533 Query commit
2022-11-11T09:04:31.261549+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.261635+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.261719+10:00 533 Query commit
2022-11-11T09:04:31.261801+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.261886+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.261969+10:00 533 Query commit
2022-11-11T09:04:31.262051+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.262136+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.262219+10:00 533 Query commit
2022-11-11T09:04:31.262301+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.262387+10:00 533 Query SET autocommit=0
2022-11-11T09:04:31.262470+10:00 533 Query commit
2022-11-11T09:04:31.262552+10:00 533 Query SET autocommit=1
2022-11-11T09:04:31.263319+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.266356+10:00 533 Query SELECT GET_LOCK('Flyway-619724031',100000)
2022-11-11T09:04:31.266890+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.267482+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:04:31.268551+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > 1 ORDER BY `installed_rank`
2022-11-11T09:04:31.270196+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.088623+10:00 533 Query commit
2022-11-11T09:05:08.088742+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.089192+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.090967+10:00 533 Query SELECT MAX(`installed_rank`) FROM `test_db`.`schema_version`
2022-11-11T09:05:08.091865+10:00 533 Query INSERT INTO `test_db`.`schema_version` (`installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`ins
talled_by`,`execution_time`,`success`) VALUES (2, null, 'ArchetypeLoader', 'JDBC', 'org.openvpms.db.migration.R__ArchetypeLoader', 2032776789, SUBSTRING_INDEX(USER(),'@
',1), 36819, 1)
2022-11-11T09:05:08.122752+10:00 533 Query SELECT RELEASE_LOCK('Flyway-619724031')
2022-11-11T09:05:08.123166+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.126476+10:00 533 Query SELECT GET_LOCK('Flyway-619724031',100000)
2022-11-11T09:05:08.126902+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.128111+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.128836+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > 1 ORDER BY `installed_rank`
2022-11-11T09:05:08.131189+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.132139+10:00 533 Query commit
2022-11-11T09:05:08.132239+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.132461+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.133117+10:00 533 Query SELECT MAX(`installed_rank`) FROM `test_db`.`schema_version`
2022-11-11T09:05:08.140705+10:00 533 Query INSERT INTO `test_db`.`schema_version` (`installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`ins
talled_by`,`execution_time`,`success`) VALUES (3, null, 'PluginLoader', 'JDBC', 'org.openvpms.db.migration.R__PluginLoader', 286823880, SUBSTRING_INDEX(USER(),'@',1), 1
, 1)
2022-11-11T09:05:08.167865+10:00 533 Query SELECT RELEASE_LOCK('Flyway-619724031')
2022-11-11T09:05:08.168216+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.168997+10:00 533 Query SELECT GET_LOCK('Flyway-619724031',100000)
2022-11-11T09:05:08.169249+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.169731+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.170215+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > 2 ORDER BY `installed_rank`
2022-11-11T09:05:08.171536+10:00 533 Query SELECT RELEASE_LOCK('Flyway-619724031')
2022-11-11T09:05:08.173015+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.173163+10:00 533 Query commit
2022-11-11T09:05:08.173251+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.173371+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.173461+10:00 533 Query commit
2022-11-11T09:05:08.173544+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.173632+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.173716+10:00 533 Query commit
2022-11-11T09:05:08.173800+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.173888+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.173971+10:00 533 Query commit
2022-11-11T09:05:08.174055+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.174142+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.174227+10:00 533 Query commit
2022-11-11T09:05:08.174311+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.174397+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.174480+10:00 533 Query commit
2022-11-11T09:05:08.174561+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.174647+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.174732+10:00 533 Query commit
2022-11-11T09:05:08.174849+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.174943+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.175026+10:00 533 Query commit
2022-11-11T09:05:08.175107+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.175194+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.175276+10:00 533 Query commit
2022-11-11T09:05:08.175358+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.175444+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.175525+10:00 533 Query commit
2022-11-11T09:05:08.175606+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.175712+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.175794+10:00 533 Query commit
2022-11-11T09:05:08.175875+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.176006+10:00 533 Query USE `test_db`
2022-11-11T09:05:08.177427+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.178068+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.178464+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db`
2022-11-11T09:05:08.179023+10:00 533 Query SHOW FULL COLUMNS FROM `schema_version` FROM `test_db` LIKE 'version_rank'
2022-11-11T09:05:08.179348+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.179446+10:00 533 Query commit
2022-11-11T09:05:08.179534+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.179621+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.179703+10:00 533 Query commit
2022-11-11T09:05:08.179784+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.179868+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.179949+10:00 533 Query commit
2022-11-11T09:05:08.180030+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.180114+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.180195+10:00 533 Query commit
2022-11-11T09:05:08.180275+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.180359+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.180440+10:00 533 Query commit
2022-11-11T09:05:08.180522+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.189216+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.189402+10:00 533 Query commit
2022-11-11T09:05:08.189519+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.189614+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.189694+10:00 533 Query commit
2022-11-11T09:05:08.189772+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.189854+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.189933+10:00 533 Query commit
2022-11-11T09:05:08.190010+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.190091+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.190169+10:00 533 Query commit
2022-11-11T09:05:08.190245+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.190326+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.190404+10:00 533 Query commit
2022-11-11T09:05:08.190480+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.190561+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.190638+10:00 533 Query commit
2022-11-11T09:05:08.190729+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.190810+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.190887+10:00 533 Query commit
2022-11-11T09:05:08.190964+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.207038+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.207920+10:00 533 Query SHOW FULL TABLES FROM `test_db` LIKE 'schema_version'
2022-11-11T09:05:08.210473+10:00 533 Query SELECT `installed_rank`,`version`,`description`,`type`,`script`,`checksum`,`installed_on`,`installed_by`,`execut
ion_time`,`success` FROM `test_db`.`schema_version` WHERE `installed_rank` > -1 ORDER BY `installed_rank`
2022-11-11T09:05:08.211657+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.211763+10:00 533 Query commit
2022-11-11T09:05:08.211845+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.211928+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.212009+10:00 533 Query commit
2022-11-11T09:05:08.212086+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.212167+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.212244+10:00 533 Query commit
2022-11-11T09:05:08.212320+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.212401+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.212478+10:00 533 Query commit
2022-11-11T09:05:08.212554+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.212635+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.212711+10:00 533 Query commit
2022-11-11T09:05:08.212789+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.212870+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.212948+10:00 533 Query commit
2022-11-11T09:05:08.213025+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.213107+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.213186+10:00 533 Query commit
2022-11-11T09:05:08.213264+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.213345+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.213440+10:00 533 Query commit
2022-11-11T09:05:08.213522+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.213604+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.213683+10:00 533 Query commit
2022-11-11T09:05:08.213759+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.213840+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.213917+10:00 533 Query commit
2022-11-11T09:05:08.213992+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.214073+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.214150+10:00 533 Query commit
2022-11-11T09:05:08.214228+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.214309+10:00 533 Query SET autocommit=0
2022-11-11T09:05:08.214386+10:00 533 Query commit
2022-11-11T09:05:08.214462+10:00 533 Query SET autocommit=1
2022-11-11T09:05:08.214566+10:00 533 Query USE `test_db`

The timing of the error and the time the last command was sent was interesting

2022-11-11T09:05:08.275142+10:00 533 [Note] Aborted connection 533 to db: 'test_db' user: 't_openvpms' host: '10.1.3.100' (Got an error reading communication packets) ​

Any advice ? Any ideas 

Addendum: this has been replicated in docker containers on atleast 2 hosts as well as on native linux no dockerization (current production server)  That mysql my.cnf is the same across all hosts. We replicated the my.conf from the production server into the docker containers.