Uncaught runner exception with out runner process
The out runner process shutdown with the following error. Any clue?
May 16 17:32:12 2019 (31602) Uncaught runner exception: (pymysql.err.InternalError) (1053, 'Server shutdown in progress') [SQL: 'SELECT anon_1.member_id AS anon_1_member_id, anon_1.member__member_id AS anon_1_member__member_id, anon_1.member_role AS anon_1_member_role, anon_1.member_list_id AS anon_1_member_list_id, anon_1.member_moderation_action AS anon_1_member_moderation_action, anon_1.member_address_id AS anon_1_member_address_id, anon_1.member_preferences_id AS anon_1_member_preferences_id, anon_1.member_user_id AS anon_1_member_user_id \nFROM (SELECT member.id AS member_id, member._member_id AS member__member_id, member.role AS member_role, member.list_id AS member_list_id, member.moderation_action AS member_moderation_action, member.address_id AS member_address_id, member.preferences_id AS member_preferences_id, member.user_id AS member_user_id \nFROM member, address \nWHERE member.list_id = %(list_id_1)s AND member.role = %(role_1)s AND address.email = %(email_1)s AND member.address_id = address.id UNION SELECT member.id AS member_id, member._member_id AS member__member_id, member.role AS member_role, member.list_id AS member_list_id, member.moderation_action AS member_moderation_action, member.address_id AS member_address_id, member.preferences_id AS member_preferences_id, member.user_id AS member_user_id \nFROM member, address, user \nWHERE member.list_id = %(list_id_2)s AND member.role = %(role_2)s AND address.email = %(email_2)s AND member.user_id = user.id AND user._preferred_address_id = address.id) AS anon_1'] [parameters: {'list_id_1': 'listname.list.company.domain', 'role_1': 1, 'email_1': 'usera@company.domain', 'list_id_2': 'listname.list.company.domain', 'role_2': 1, 'email_2': 'usera@company.domain'}] (Background on this error at: http://sqlalche.me/e/2j85)
File "/usr/local/lib/python3.6/site-packages/mailman/core/runner.py", line 173, in _one_iteration
File "/usr/local/lib/python3.6/site-packages/mailman/core/runner.py", line 266, in _process_one_file
File "/usr/local/lib/python3.6/site-packages/mailman/runners/outgoing.py", line 93, in _dispose
On 5/18/19 7:35 AM, Alan So wrote:
The out runner process shutdown with the following error. Any clue?
May 16 17:32:12 2019 (31602) Uncaught runner exception: (pymysql.err.InternalError) (1053, 'Server shutdown in progress') ...
Mailman is running and the MySQL server is being shutdown.
If this occurred during shutdown of the entire server, it is a race condition due to the out runner continuing to process a message while the MySQL server is being shut down.
Upon restart, the out runner may recover the message from the .bak file in its queue.
To avoid this, you could stop Mailman and wait for all Mailman processes to terminate before shutting down/rebooting the server.
Note that if the message in process was shunted, the .bak file was probably removed during the shunting process, so you should unshunt it to finish delivery.
-- Mark Sapiro <mark@msapiro.net> The highway is for gamblers, San Francisco Bay Area, California better use your sense - B. Dylan
participants (2)
-
Alan So -
Mark Sapiro