work0 mysql does not make rpkid happy

[sraustein]

work0.psg.com:/root# psg mysq mysql 33965 0.0 0.0 14504 1476 ?? Is 14Oct12 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var mysql 34048 0.0 0.8 167900 33780 ?? I 14Oct12 350:42.74 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql

Oct 28 05:34:20 work0 rpkid[55792]: : Error on HTTP client connection localhost:4403 <class 'rpki.exceptions.HTTPRequestFailed'> HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away') Oct 28 05:34:20 work0 rpkid[55792]: : Closing due to error Oct 28 05:34:20 work0 rpkid[55792]: : Returning exception HTTPRequestFailed("HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away')",) to caller: HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away') Oct 28 05:34:20 work0 rpkid[55792]: Could not fetch Ghostbuster record requests for labuser00, skipping: HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away')

work0.psg.com:/root# /usr/local/etc/rc.d/mysql-server restart Stopping mysql. Waiting for PIDS: 34048. Starting mysql. work0.psg.com:/root# psg mysq mysql 71403 4.3 0.6 103608 24408 ?? S 5:35AM 0:00.09 /usr/local/libexec/mysqld --defaults-extra-file=/var/db/mysql mysql 71348 0.1 0.0 14504 2000 ?? Ss 5:35AM 0:00.01 /bin/sh /usr/local/bin/mysqld_safe --defaults-extra-file=/var

Oct 28 05:36:21 work0 rpkid[55792]: : Returning exception HTTPRequestFailed("HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away')",) to caller: HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away') Oct 28 05:36:21 work0 rpkid[55792]: Could not fetch ROA requests for labuser00, skipping: HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away') Oct 28 05:36:21 work0 rpkid[55792]: : Error on HTTP client connection localhost:4403 <class 'rpki.exceptions.HTTPRequestFailed'> HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away') Oct 28 05:36:21 work0 rpkid[55792]: : Closing due to error Oct 28 05:36:21 work0 rpkid[55792]: : Returning exception HTTPRequestFailed("HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away')",) to caller: HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away') Oct 28 05:36:21 work0 rpkid[55792]: Could not fetch Ghostbuster record requests for labuser00, skipping: HTTP request failed with status 500, reason Unhandled exception OperationalError: (2006, 'MySQL server has gone away')

Trac ticket #297 component rpkid priority major, owner sra, created by randy on 2012-10-28T05:38:21Z, last modified 2012-10-28T15:15:12Z

[sraustein]

Fixed on development branch in [4632].

For old (current /trunk) code, workaround is to restart rpkid once mysqld is back up.

Trac comment by sra on 2012-10-28T15:15:12Z

[sraustein]

Closed with resolution duplicate