)]}'
{"/COMMIT_MSG":[{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"8b31eaf318e30b35e2b74036aed080ecac96b140","unresolved":false,"context_lines":[{"line_number":20,"context_line":"It\u0027s not clear what might have changed in Train. To figure that out"},{"line_number":21,"context_line":"we likely need more verbose mysqld logging enabled in a patch that"},{"line_number":22,"context_line":"hits the failure. But for now it seems useful to try and set"},{"line_number":23,"context_line":"max_allowed_packet to a higher size as a workaround."},{"line_number":24,"context_line":""},{"line_number":25,"context_line":"[1] https://dba.stackexchange.com/questions/19135/mysql-error-reading-communication-packets/19139#19139"},{"line_number":26,"context_line":"[2] http://codesearch.openstack.org/?q\u003dmax_allowed_packet\u0026i\u003dnope\u0026files\u003d\u0026repos\u003d"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":1,"id":"3fa7e38b_51bf63a9","line":23,"updated":"2019-10-09 19:17:29.000000000","message":"Still seeing the aborted connection messages in the mysql logs even with this change:\n\nhttps://zuul.opendev.org/t/openstack/build/b7563893a11d4638a6378adc6b1a9b01/log/controller/logs/mysql/error_log.txt.gz#212\n\nAnd that\u0027s in a non-grenade job. I see mysqld start 3 times there as well and I\u0027m not sure why (why would we start mysqld 3 times in a non-grenade job, I would expect at most 2 times, once for base install and once for restart after config).","commit_id":"2ac912ce2fd5a50983a4db6cd6708e6297525621"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"5a031e9df929fe60164c5cd2d543e60b4a78da7a","unresolved":false,"context_lines":[{"line_number":20,"context_line":"It\u0027s not clear what might have changed in Train. To figure that out"},{"line_number":21,"context_line":"we likely need more verbose mysqld logging enabled in a patch that"},{"line_number":22,"context_line":"hits the failure. But for now it seems useful to try and set"},{"line_number":23,"context_line":"max_allowed_packet to a higher size as a workaround."},{"line_number":24,"context_line":""},{"line_number":25,"context_line":"[1] https://dba.stackexchange.com/questions/19135/mysql-error-reading-communication-packets/19139#19139"},{"line_number":26,"context_line":"[2] http://codesearch.openstack.org/?q\u003dmax_allowed_packet\u0026i\u003dnope\u0026files\u003d\u0026repos\u003d"}],"source_content_type":"text/x-gerrit-commit-message","patch_set":1,"id":"3fa7e38b_110c8ba3","line":23,"in_reply_to":"3fa7e38b_51bf63a9","updated":"2019-10-09 19:19:11.000000000","message":"Here is the install:\n\nhttps://zuul.opendev.org/t/openstack/build/b7563893a11d4638a6378adc6b1a9b01/log/controller/logs/devstacklog.txt.gz#3792\n\n2019-10-08 19:59:20.328 | + functions-common:real_install_package:1321 :   apt_get install mysql-server\n\nAnd the restart:\n\nhttps://zuul.opendev.org/t/openstack/build/b7563893a11d4638a6378adc6b1a9b01/log/controller/logs/devstacklog.txt.gz#14197\n\n2019-10-08 20:07:11.503 | + lib/databases/mysql:configure_database_mysql:133 :   restart_service mysql","commit_id":"2ac912ce2fd5a50983a4db6cd6708e6297525621"}],"lib/databases/mysql":[{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"4399a1e31b7721c9bd0d20ae72402904700cae66","unresolved":false,"context_lines":[{"line_number":110,"context_line":"    # https://dba.stackexchange.com/questions/19135/mysql-error-reading-communication-packets/19139#19139"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld max_allowed_packet 16M"},{"line_number":112,"context_line":""},{"line_number":113,"context_line":"    if [[ \"$DATABASE_QUERY_LOGGING\" \u003d\u003d \"True\" ]]; then"},{"line_number":114,"context_line":"        echo_summary \"Enabling MySQL query logging\""},{"line_number":115,"context_line":"        if is_fedora; then"},{"line_number":116,"context_line":"            slow_log\u003d/var/log/mariadb/mariadb-slow.log"}],"source_content_type":"application/x-shellscript","patch_set":1,"id":"3fa7e38b_366d1298","line":113,"range":{"start_line":113,"start_character":12,"end_line":113,"end_character":34},"updated":"2019-10-08 18:13:31.000000000","message":"I\u0027ll try setting this in a grenade DNM patch to see if we can recreate the failure and get more information.","commit_id":"2ac912ce2fd5a50983a4db6cd6708e6297525621"},{"author":{"_account_id":6873,"name":"Matt Riedemann","email":"mriedem.os@gmail.com","username":"mriedem"},"change_message_id":"d44a78e558ca9e5a40a27052066a225c40034c43","unresolved":false,"context_lines":[{"line_number":110,"context_line":"    # https://dba.stackexchange.com/questions/19135/mysql-error-reading-communication-packets/19139#19139"},{"line_number":111,"context_line":"    iniset -sudo $my_conf mysqld max_allowed_packet 16M"},{"line_number":112,"context_line":""},{"line_number":113,"context_line":"    if [[ \"$DATABASE_QUERY_LOGGING\" \u003d\u003d \"True\" ]]; then"},{"line_number":114,"context_line":"        echo_summary \"Enabling MySQL query logging\""},{"line_number":115,"context_line":"        if is_fedora; then"},{"line_number":116,"context_line":"            slow_log\u003d/var/log/mariadb/mariadb-slow.log"}],"source_content_type":"application/x-shellscript","patch_set":1,"id":"3fa7e38b_3677523d","line":113,"range":{"start_line":113,"start_character":12,"end_line":113,"end_character":34},"in_reply_to":"3fa7e38b_366d1298","updated":"2019-10-08 18:21:43.000000000","message":"https://review.opendev.org/687376","commit_id":"2ac912ce2fd5a50983a4db6cd6708e6297525621"}]}