psycopg2.OperationalError: SSL connection has been closed unexpectedly
In just the last couple of days, I've seen five shunted messages, two on mpo and three on lm3o all with the above error. I see tracebacks like
Feb 21 17:34:37 2017 (25854) LMTP message parsing
Traceback (most recent call last):
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
psycopg2.OperationalError: SSL connection has been closed unexpectedly
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/runners/lmtp.py", line 130, in process_message
listnames = set(getUtility(IListManager).names)
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/model/listmanager.py", line 107, in names
MailingList.list_name):
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 1199, in values
return iter(q)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2736, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/util/compat.py", line 200, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/util/compat.py", line 183, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL connection has been closed unexpectedly
[SQL: 'SELECT mailinglist.mail_host AS mailinglist_mail_host, mailinglist.list_name AS mailinglist_list_name \nFROM mailinglist']
and
Feb 21 17:43:03 2017 (25846) Uncaught runner exception: (psycopg2.OperationalError) SSL connection has been closed unexpectedly
[SQL: 'SELECT mailinglist.list_id AS mailinglist_list_id, mailinglist.preferred_language AS mailinglist_preferred_language, mailinglist.id AS mailinglist_id, mailinglist.list_name AS mailinglist_list_name, mailinglist.mail_host AS mailinglist_mail_host, mailinglist.allow_list_posts AS mailinglist_allow_list_posts, mailinglist.include_rfc2369_headers AS mailinglist_include_rfc2369_headers, mailinglist.advertised AS mailinglist_advertised, mailinglist.anonymous_list AS mailinglist_anonymous_list, mailinglist.created_at AS mailinglist_created_at, mailinglist.next_request_id AS mailinglist_next_request_id, mailinglist.next_digest_number AS mailinglist_next_digest_number, mailinglist.digest_last_sent_at AS mailinglist_digest_last_sent_at, mailinglist.volume AS mailinglist_volume, mailinglist.last_post_at AS mailinglist_last_post_at, mailinglist.accept_these_nonmembers AS mailinglist_accept_these_nonmembers, mailinglist.admin_immed_notify AS mailinglist_admin_immed_notify, mailinglist.admin_notify_mchanges AS mailinglist_admin_notify_mchanges, mailinglist.administrivia AS mailinglist_administrivia, mailinglist.archive_policy AS mailinglist_archive_policy, mailinglist.autoresponse_grace_period AS mailinglist_autoresponse_grace_period, mailinglist.autorespond_owner AS mailinglist_autorespond_owner, mailinglist.autoresponse_owner_text AS mailinglist_autoresponse_owner_text, mailinglist.autorespond_postings AS mailinglist_autorespond_postings, mailinglist.autoresponse_postings_text AS mailinglist_autoresponse_postings_text, mailinglist.autorespond_requests AS mailinglist_autorespond_requests, mailinglist.autoresponse_request_text AS mailinglist_autoresponse_request_text, mailinglist.filter_action AS mailinglist_filter_action, mailinglist.filter_content AS mailinglist_filter_content, mailinglist.collapse_alternatives AS mailinglist_collapse_alternatives, mailinglist.convert_html_to_plaintext AS mailinglist_convert_html_to_plaintext, mailinglist.bounce_info_stale_after AS mailinglist_bounce_info_stale_after, mailinglist.bounce_matching_headers AS mailinglist_bounce_matching_headers, mailinglist.bounce_notify_owner_on_disable AS mailinglist_bounce_notify_owner_on_disable, mailinglist.bounce_notify_owner_on_removal AS mailinglist_bounce_notify_owner_on_removal, mailinglist.bounce_score_threshold AS mailinglist_bounce_score_threshold, mailinglist.bounce_you_are_disabled_warnings AS mailinglist_bounce_you_are_disabled_warnings, mailinglist.bounce_you_are_disabled_warnings_interval AS mailinglist_bounce_you_are_disabled_warnings_interval, mailinglist.forward_unrecognized_bounces_to AS mailinglist_forward_unrecognized_bounces_to, mailinglist.process_bounces AS mailinglist_process_bounces, mailinglist.dmarc_mitigate_action AS mailinglist_dmarc_mitigate_action, mailinglist.dmarc_mitigate_unconditionally AS mailinglist_dmarc_mitigate_unconditionally, mailinglist.dmarc_moderation_notice AS mailinglist_dmarc_moderation_notice, mailinglist.dmarc_wrapped_message_text AS mailinglist_dmarc_wrapped_message_text, mailinglist.default_member_action AS mailinglist_default_member_action, mailinglist.default_nonmember_action AS mailinglist_default_nonmember_action, mailinglist.description AS mailinglist_description, mailinglist.digests_enabled AS mailinglist_digests_enabled, mailinglist.digest_is_default AS mailinglist_digest_is_default, mailinglist.digest_send_periodic AS mailinglist_digest_send_periodic, mailinglist.digest_size_threshold AS mailinglist_digest_size_threshold, mailinglist.digest_volume_frequency AS mailinglist_digest_volume_frequency, mailinglist.discard_these_nonmembers AS mailinglist_discard_these_nonmembers, mailinglist.emergency AS mailinglist_emergency, mailinglist.encode_ascii_prefixes AS mailinglist_encode_ascii_prefixes, mailinglist.first_strip_reply_to AS mailinglist_first_strip_reply_to, mailinglist.forward_auto_discards AS mailinglist_forward_auto_discards, mailinglist.gateway_to_mail AS mailinglist_gateway_to_mail, mailinglist.gateway_to_news AS mailinglist_gateway_to_news, mailinglist.hold_these_nonmembers AS mailinglist_hold_these_nonmembers, mailinglist.info AS mailinglist_info, mailinglist.linked_newsgroup AS mailinglist_linked_newsgroup, mailinglist.max_days_to_hold AS mailinglist_max_days_to_hold, mailinglist.max_message_size AS mailinglist_max_message_size, mailinglist.max_num_recipients AS mailinglist_max_num_recipients, mailinglist.member_moderation_notice AS mailinglist_member_moderation_notice, mailinglist.mime_is_default_digest AS mailinglist_mime_is_default_digest, mailinglist.moderator_password AS mailinglist_moderator_password, mailinglist.newsgroup_moderation AS mailinglist_newsgroup_moderation, mailinglist.nntp_prefix_subject_too AS mailinglist_nntp_prefix_subject_too, mailinglist.nonmember_rejection_notice AS mailinglist_nonmember_rejection_notice, mailinglist.obscure_addresses AS mailinglist_obscure_addresses, mailinglist.owner_chain AS mailinglist_owner_chain, mailinglist.owner_pipeline AS mailinglist_owner_pipeline, mailinglist.personalize AS mailinglist_personalize, mailinglist.post_id AS mailinglist_post_id, mailinglist.posting_chain AS mailinglist_posting_chain, mailinglist.posting_pipeline AS mailinglist_posting_pipeline, mailinglist.display_name AS mailinglist_display_name, mailinglist.reject_these_nonmembers AS mailinglist_reject_these_nonmembers, mailinglist.reply_goes_to_list AS mailinglist_reply_goes_to_list, mailinglist.reply_to_address AS mailinglist_reply_to_address, mailinglist.require_explicit_destination AS mailinglist_require_explicit_destination, mailinglist.respond_to_post_requests AS mailinglist_respond_to_post_requests, mailinglist.scrub_nondigest AS mailinglist_scrub_nondigest, mailinglist.send_goodbye_message AS mailinglist_send_goodbye_message, mailinglist.send_welcome_message AS mailinglist_send_welcome_message, mailinglist.subject_prefix AS mailinglist_subject_prefix, mailinglist.subscription_policy AS mailinglist_subscription_policy, mailinglist.topics AS mailinglist_topics, mailinglist.topics_bodylines_limit AS mailinglist_topics_bodylines_limit, mailinglist.topics_enabled AS mailinglist_topics_enabled, mailinglist.unsubscription_policy AS mailinglist_unsubscription_policy \nFROM mailinglist \nWHERE mailinglist.list_id = %(list_id_1)s \n LIMIT %(param_1)s'] [parameters: {'list_id_1': 'test2.mailman3.org', 'param_1': 1}]
Feb 21 17:43:03 2017 (25846) Traceback (most recent call last):
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
psycopg2.OperationalError: SSL connection has been closed unexpectedly
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/core/runner.py", line 171, in _one_iteration
self._process_one_file(msg, msgdata)
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/core/runner.py", line 237, in _process_one_file
mlist = list_manager.get_by_list_id(list_id)
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/database/transaction.py", line 85, in wrapper
return function(args[0], config.db.store, *args[1:], **kws)
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/model/listmanager.py", line 71, in get_by_list_id
return store.query(MailingList).filter_by(_list_id=list_id).first()
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2634, in first
ret = list(self[0:1])
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2457, in __getitem__
return list(res)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2736, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/util/compat.py", line 200, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/util/compat.py", line 183, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL connection has been closed unexpectedly
[SQL: 'SELECT mailinglist.list_id AS mailinglist_list_id, mailinglist.preferred_language AS mailinglist_preferred_language, mailinglist.id AS mailinglist_id, mailinglist.list_name AS mailinglist_list_name, mailinglist.mail_host AS mailinglist_mail_host, mailinglist.allow_list_posts AS mailinglist_allow_list_posts, mailinglist.include_rfc2369_headers AS mailinglist_include_rfc2369_headers, mailinglist.advertised AS mailinglist_advertised, mailinglist.anonymous_list AS mailinglist_anonymous_list, mailinglist.created_at AS mailinglist_created_at, mailinglist.next_request_id AS mailinglist_next_request_id, mailinglist.next_digest_number AS mailinglist_next_digest_number, mailinglist.digest_last_sent_at AS mailinglist_digest_last_sent_at, mailinglist.volume AS mailinglist_volume, mailinglist.last_post_at AS mailinglist_last_post_at, mailinglist.accept_these_nonmembers AS mailinglist_accept_these_nonmembers, mailinglist.admin_immed_notify AS mailinglist_admin_immed_notify, mailinglist.admin_notify_mchanges AS mailinglist_admin_notify_mchanges, mailinglist.administrivia AS mailinglist_administrivia, mailinglist.archive_policy AS mailinglist_archive_policy, mailinglist.autoresponse_grace_period AS mailinglist_autoresponse_grace_period, mailinglist.autorespond_owner AS mailinglist_autorespond_owner, mailinglist.autoresponse_owner_text AS mailinglist_autoresponse_owner_text, mailinglist.autorespond_postings AS mailinglist_autorespond_postings, mailinglist.autoresponse_postings_text AS mailinglist_autoresponse_postings_text, mailinglist.autorespond_requests AS mailinglist_autorespond_requests, mailinglist.autoresponse_request_text AS mailinglist_autoresponse_request_text, mailinglist.filter_action AS mailinglist_filter_action, mailinglist.filter_content AS mailinglist_filter_content, mailinglist.collapse_alternatives AS mailinglist_collapse_alternatives, mailinglist.convert_html_to_plaintext AS mailinglist_convert_html_to_plaintext, mailinglist.bounce_info_stale_after AS mailinglist_bounce_info_stale_after, mailinglist.bounce_matching_headers AS mailinglist_bounce_matching_headers, mailinglist.bounce_notify_owner_on_disable AS mailinglist_bounce_notify_owner_on_disable, mailinglist.bounce_notify_owner_on_removal AS mailinglist_bounce_notify_owner_on_removal, mailinglist.bounce_score_threshold AS mailinglist_bounce_score_threshold, mailinglist.bounce_you_are_disabled_warnings AS mailinglist_bounce_you_are_disabled_warnings, mailinglist.bounce_you_are_disabled_warnings_interval AS mailinglist_bounce_you_are_disabled_warnings_interval, mailinglist.forward_unrecognized_bounces_to AS mailinglist_forward_unrecognized_bounces_to, mailinglist.process_bounces AS mailinglist_process_bounces, mailinglist.dmarc_mitigate_action AS mailinglist_dmarc_mitigate_action, mailinglist.dmarc_mitigate_unconditionally AS mailinglist_dmarc_mitigate_unconditionally, mailinglist.dmarc_moderation_notice AS mailinglist_dmarc_moderation_notice, mailinglist.dmarc_wrapped_message_text AS mailinglist_dmarc_wrapped_message_text, mailinglist.default_member_action AS mailinglist_default_member_action, mailinglist.default_nonmember_action AS mailinglist_default_nonmember_action, mailinglist.description AS mailinglist_description, mailinglist.digests_enabled AS mailinglist_digests_enabled, mailinglist.digest_is_default AS mailinglist_digest_is_default, mailinglist.digest_send_periodic AS mailinglist_digest_send_periodic, mailinglist.digest_size_threshold AS mailinglist_digest_size_threshold, mailinglist.digest_volume_frequency AS mailinglist_digest_volume_frequency, mailinglist.discard_these_nonmembers AS mailinglist_discard_these_nonmembers, mailinglist.emergency AS mailinglist_emergency, mailinglist.encode_ascii_prefixes AS mailinglist_encode_ascii_prefixes, mailinglist.first_strip_reply_to AS mailinglist_first_strip_reply_to, mailinglist.forward_auto_discards AS mailinglist_forward_auto_discards, mailinglist.gateway_to_mail AS mailinglist_gateway_to_mail, mailinglist.gateway_to_news AS mailinglist_gateway_to_news, mailinglist.hold_these_nonmembers AS mailinglist_hold_these_nonmembers, mailinglist.info AS mailinglist_info, mailinglist.linked_newsgroup AS mailinglist_linked_newsgroup, mailinglist.max_days_to_hold AS mailinglist_max_days_to_hold, mailinglist.max_message_size AS mailinglist_max_message_size, mailinglist.max_num_recipients AS mailinglist_max_num_recipients, mailinglist.member_moderation_notice AS mailinglist_member_moderation_notice, mailinglist.mime_is_default_digest AS mailinglist_mime_is_default_digest, mailinglist.moderator_password AS mailinglist_moderator_password, mailinglist.newsgroup_moderation AS mailinglist_newsgroup_moderation, mailinglist.nntp_prefix_subject_too AS mailinglist_nntp_prefix_subject_too, mailinglist.nonmember_rejection_notice AS mailinglist_nonmember_rejection_notice, mailinglist.obscure_addresses AS mailinglist_obscure_addresses, mailinglist.owner_chain AS mailinglist_owner_chain, mailinglist.owner_pipeline AS mailinglist_owner_pipeline, mailinglist.personalize AS mailinglist_personalize, mailinglist.post_id AS mailinglist_post_id, mailinglist.posting_chain AS mailinglist_posting_chain, mailinglist.posting_pipeline AS mailinglist_posting_pipeline, mailinglist.display_name AS mailinglist_display_name, mailinglist.reject_these_nonmembers AS mailinglist_reject_these_nonmembers, mailinglist.reply_goes_to_list AS mailinglist_reply_goes_to_list, mailinglist.reply_to_address AS mailinglist_reply_to_address, mailinglist.require_explicit_destination AS mailinglist_require_explicit_destination, mailinglist.respond_to_post_requests AS mailinglist_respond_to_post_requests, mailinglist.scrub_nondigest AS mailinglist_scrub_nondigest, mailinglist.send_goodbye_message AS mailinglist_send_goodbye_message, mailinglist.send_welcome_message AS mailinglist_send_welcome_message, mailinglist.subject_prefix AS mailinglist_subject_prefix, mailinglist.subscription_policy AS mailinglist_subscription_policy, mailinglist.topics AS mailinglist_topics, mailinglist.topics_bodylines_limit AS mailinglist_topics_bodylines_limit, mailinglist.topics_enabled AS mailinglist_topics_enabled, mailinglist.unsubscription_policy AS mailinglist_unsubscription_policy \nFROM mailinglist \nWHERE mailinglist.list_id = %(list_id_1)s \n LIMIT %(param_1)s'] [parameters: {'list_id_1': 'test2.mailman3.org', 'param_1': 1}]
Feb 21 17:43:03 2017 (25846) SHUNTING: 1487698983.1167924+bf0d5e2d73afc997b7405e336f2525e8b3f05f72
and
Feb 21 20:40:15 2017 (25846) HOLD: mailman-users@mailman3.org post from kristen.warren@elevation-webmail.com held, message-id=<nlt-16912171-c0d2-46f6-bbd5-e51527628a77@nlt-us.perfora.net>: The message is not from a list member
Feb 21 20:40:15 2017 (25855) Uncaught runner exception: (psycopg2.OperationalError) SSL connection has been closed unexpectedly
[SQL: 'SELECT mailinglist.list_id AS mailinglist_list_id, mailinglist.preferred_language AS mailinglist_preferred_language, mailinglist.id AS mailinglist_id, mailinglist.list_name AS mailinglist_list_name, mailinglist.mail_host AS mailinglist_mail_host, mailinglist.allow_list_posts AS mailinglist_allow_list_posts, mailinglist.include_rfc2369_headers AS mailinglist_include_rfc2369_headers, mailinglist.advertised AS mailinglist_advertised, mailinglist.anonymous_list AS mailinglist_anonymous_list, mailinglist.created_at AS mailinglist_created_at, mailinglist.next_request_id AS mailinglist_next_request_id, mailinglist.next_digest_number AS mailinglist_next_digest_number, mailinglist.digest_last_sent_at AS mailinglist_digest_last_sent_at, mailinglist.volume AS mailinglist_volume, mailinglist.last_post_at AS mailinglist_last_post_at, mailinglist.accept_these_nonmembers AS mailinglist_accept_these_nonmembers, mailinglist.admin_immed_notify AS mailinglist_admin_immed_notify, mailinglist.admin_notify_mchanges AS mailinglist_admin_notify_mchanges, mailinglist.administrivia AS mailinglist_administrivia, mailinglist.archive_policy AS mailinglist_archive_policy, mailinglist.autoresponse_grace_period AS mailinglist_autoresponse_grace_period, mailinglist.autorespond_owner AS mailinglist_autorespond_owner, mailinglist.autoresponse_owner_text AS mailinglist_autoresponse_owner_text, mailinglist.autorespond_postings AS mailinglist_autorespond_postings, mailinglist.autoresponse_postings_text AS mailinglist_autoresponse_postings_text, mailinglist.autorespond_requests AS mailinglist_autorespond_requests, mailinglist.autoresponse_request_text AS mailinglist_autoresponse_request_text, mailinglist.filter_action AS mailinglist_filter_action, mailinglist.filter_content AS mailinglist_filter_content, mailinglist.collapse_alternatives AS mailinglist_collapse_alternatives, mailinglist.convert_html_to_plaintext AS mailinglist_convert_html_to_plaintext, mailinglist.bounce_info_stale_after AS mailinglist_bounce_info_stale_after, mailinglist.bounce_matching_headers AS mailinglist_bounce_matching_headers, mailinglist.bounce_notify_owner_on_disable AS mailinglist_bounce_notify_owner_on_disable, mailinglist.bounce_notify_owner_on_removal AS mailinglist_bounce_notify_owner_on_removal, mailinglist.bounce_score_threshold AS mailinglist_bounce_score_threshold, mailinglist.bounce_you_are_disabled_warnings AS mailinglist_bounce_you_are_disabled_warnings, mailinglist.bounce_you_are_disabled_warnings_interval AS mailinglist_bounce_you_are_disabled_warnings_interval, mailinglist.forward_unrecognized_bounces_to AS mailinglist_forward_unrecognized_bounces_to, mailinglist.process_bounces AS mailinglist_process_bounces, mailinglist.dmarc_mitigate_action AS mailinglist_dmarc_mitigate_action, mailinglist.dmarc_mitigate_unconditionally AS mailinglist_dmarc_mitigate_unconditionally, mailinglist.dmarc_moderation_notice AS mailinglist_dmarc_moderation_notice, mailinglist.dmarc_wrapped_message_text AS mailinglist_dmarc_wrapped_message_text, mailinglist.default_member_action AS mailinglist_default_member_action, mailinglist.default_nonmember_action AS mailinglist_default_nonmember_action, mailinglist.description AS mailinglist_description, mailinglist.digests_enabled AS mailinglist_digests_enabled, mailinglist.digest_is_default AS mailinglist_digest_is_default, mailinglist.digest_send_periodic AS mailinglist_digest_send_periodic, mailinglist.digest_size_threshold AS mailinglist_digest_size_threshold, mailinglist.digest_volume_frequency AS mailinglist_digest_volume_frequency, mailinglist.discard_these_nonmembers AS mailinglist_discard_these_nonmembers, mailinglist.emergency AS mailinglist_emergency, mailinglist.encode_ascii_prefixes AS mailinglist_encode_ascii_prefixes, mailinglist.first_strip_reply_to AS mailinglist_first_strip_reply_to, mailinglist.forward_auto_discards AS mailinglist_forward_auto_discards, mailinglist.gateway_to_mail AS mailinglist_gateway_to_mail, mailinglist.gateway_to_news AS mailinglist_gateway_to_news, mailinglist.hold_these_nonmembers AS mailinglist_hold_these_nonmembers, mailinglist.info AS mailinglist_info, mailinglist.linked_newsgroup AS mailinglist_linked_newsgroup, mailinglist.max_days_to_hold AS mailinglist_max_days_to_hold, mailinglist.max_message_size AS mailinglist_max_message_size, mailinglist.max_num_recipients AS mailinglist_max_num_recipients, mailinglist.member_moderation_notice AS mailinglist_member_moderation_notice, mailinglist.mime_is_default_digest AS mailinglist_mime_is_default_digest, mailinglist.moderator_password AS mailinglist_moderator_password, mailinglist.newsgroup_moderation AS mailinglist_newsgroup_moderation, mailinglist.nntp_prefix_subject_too AS mailinglist_nntp_prefix_subject_too, mailinglist.nonmember_rejection_notice AS mailinglist_nonmember_rejection_notice, mailinglist.obscure_addresses AS mailinglist_obscure_addresses, mailinglist.owner_chain AS mailinglist_owner_chain, mailinglist.owner_pipeline AS mailinglist_owner_pipeline, mailinglist.personalize AS mailinglist_personalize, mailinglist.post_id AS mailinglist_post_id, mailinglist.posting_chain AS mailinglist_posting_chain, mailinglist.posting_pipeline AS mailinglist_posting_pipeline, mailinglist.display_name AS mailinglist_display_name, mailinglist.reject_these_nonmembers AS mailinglist_reject_these_nonmembers, mailinglist.reply_goes_to_list AS mailinglist_reply_goes_to_list, mailinglist.reply_to_address AS mailinglist_reply_to_address, mailinglist.require_explicit_destination AS mailinglist_require_explicit_destination, mailinglist.respond_to_post_requests AS mailinglist_respond_to_post_requests, mailinglist.scrub_nondigest AS mailinglist_scrub_nondigest, mailinglist.send_goodbye_message AS mailinglist_send_goodbye_message, mailinglist.send_welcome_message AS mailinglist_send_welcome_message, mailinglist.subject_prefix AS mailinglist_subject_prefix, mailinglist.subscription_policy AS mailinglist_subscription_policy, mailinglist.topics AS mailinglist_topics, mailinglist.topics_bodylines_limit AS mailinglist_topics_bodylines_limit, mailinglist.topics_enabled AS mailinglist_topics_enabled, mailinglist.unsubscription_policy AS mailinglist_unsubscription_policy \nFROM mailinglist \nWHERE mailinglist.list_id = %(list_id_1)s \n LIMIT %(param_1)s'] [parameters: {'list_id_1': 'mailman-users.mailman3.org', 'param_1': 1}]
Feb 21 20:40:15 2017 (25855) Traceback (most recent call last):
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
psycopg2.OperationalError: SSL connection has been closed unexpectedly
The above exception was the direct cause of the following exception:
Traceback (most recent call last):
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/core/runner.py", line 171, in _one_iteration
self._process_one_file(msg, msgdata)
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/core/runner.py", line 237, in _process_one_file
mlist = list_manager.get_by_list_id(list_id)
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/database/transaction.py", line 85, in wrapper
return function(args[0], config.db.store, *args[1:], **kws)
File "/usr/local/lib/python3.4/dist-packages/mailman-3.1.0b4-py3.4.egg/mailman/model/listmanager.py", line 71, in get_by_list_id
return store.query(MailingList).filter_by(_list_id=list_id).first()
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2634, in first
ret = list(self[0:1])
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2457, in __getitem__
return list(res)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2736, in __iter__
return self._execute_and_instances(context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/orm/query.py", line 2751, in _execute_and_instances
result = conn.execute(querycontext.statement, self._params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 914, in execute
return meth(self, multiparams, params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/sql/elements.py", line 323, in _execute_on_connection
return connection._execute_clauseelement(self, multiparams, params)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1010, in _execute_clauseelement
compiled_sql, distilled_params
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1146, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1341, in _handle_dbapi_exception
exc_info
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/util/compat.py", line 200, in raise_from_cause
reraise(type(exception), exception, tb=exc_tb, cause=cause)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/util/compat.py", line 183, in reraise
raise value.with_traceback(tb)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/base.py", line 1139, in _execute_context
context)
File "/usr/local/lib/python3.4/dist-packages/SQLAlchemy-1.0.12-py3.4-linux-x86_64.egg/sqlalchemy/engine/default.py", line 450, in do_execute
cursor.execute(statement, parameters)
sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) SSL connection has been closed unexpectedly
[SQL: 'SELECT mailinglist.list_id AS mailinglist_list_id, mailinglist.preferred_language AS mailinglist_preferred_language, mailinglist.id AS mailinglist_id, mailinglist.list_name AS mailinglist_list_name, mailinglist.mail_host AS mailinglist_mail_host, mailinglist.allow_list_posts AS mailinglist_allow_list_posts, mailinglist.include_rfc2369_headers AS mailinglist_include_rfc2369_headers, mailinglist.advertised AS mailinglist_advertised, mailinglist.anonymous_list AS mailinglist_anonymous_list, mailinglist.created_at AS mailinglist_created_at, mailinglist.next_request_id AS mailinglist_next_request_id, mailinglist.next_digest_number AS mailinglist_next_digest_number, mailinglist.digest_last_sent_at AS mailinglist_digest_last_sent_at, mailinglist.volume AS mailinglist_volume, mailinglist.last_post_at AS mailinglist_last_post_at, mailinglist.accept_these_nonmembers AS mailinglist_accept_these_nonmembers, mailinglist.admin_immed_notify AS mailinglist_admin_immed_notify, mailinglist.admin_notify_mchanges AS mailinglist_admin_notify_mchanges, mailinglist.administrivia AS mailinglist_administrivia, mailinglist.archive_policy AS mailinglist_archive_policy, mailinglist.autoresponse_grace_period AS mailinglist_autoresponse_grace_period, mailinglist.autorespond_owner AS mailinglist_autorespond_owner, mailinglist.autoresponse_owner_text AS mailinglist_autoresponse_owner_text, mailinglist.autorespond_postings AS mailinglist_autorespond_postings, mailinglist.autoresponse_postings_text AS mailinglist_autoresponse_postings_text, mailinglist.autorespond_requests AS mailinglist_autorespond_requests, mailinglist.autoresponse_request_text AS mailinglist_autoresponse_request_text, mailinglist.filter_action AS mailinglist_filter_action, mailinglist.filter_content AS mailinglist_filter_content, mailinglist.collapse_alternatives AS mailinglist_collapse_alternatives, mailinglist.convert_html_to_plaintext AS mailinglist_convert_html_to_plaintext, mailinglist.bounce_info_stale_after AS mailinglist_bounce_info_stale_after, mailinglist.bounce_matching_headers AS mailinglist_bounce_matching_headers, mailinglist.bounce_notify_owner_on_disable AS mailinglist_bounce_notify_owner_on_disable, mailinglist.bounce_notify_owner_on_removal AS mailinglist_bounce_notify_owner_on_removal, mailinglist.bounce_score_threshold AS mailinglist_bounce_score_threshold, mailinglist.bounce_you_are_disabled_warnings AS mailinglist_bounce_you_are_disabled_warnings, mailinglist.bounce_you_are_disabled_warnings_interval AS mailinglist_bounce_you_are_disabled_warnings_interval, mailinglist.forward_unrecognized_bounces_to AS mailinglist_forward_unrecognized_bounces_to, mailinglist.process_bounces AS mailinglist_process_bounces, mailinglist.dmarc_mitigate_action AS mailinglist_dmarc_mitigate_action, mailinglist.dmarc_mitigate_unconditionally AS mailinglist_dmarc_mitigate_unconditionally, mailinglist.dmarc_moderation_notice AS mailinglist_dmarc_moderation_notice, mailinglist.dmarc_wrapped_message_text AS mailinglist_dmarc_wrapped_message_text, mailinglist.default_member_action AS mailinglist_default_member_action, mailinglist.default_nonmember_action AS mailinglist_default_nonmember_action, mailinglist.description AS mailinglist_description, mailinglist.digests_enabled AS mailinglist_digests_enabled, mailinglist.digest_is_default AS mailinglist_digest_is_default, mailinglist.digest_send_periodic AS mailinglist_digest_send_periodic, mailinglist.digest_size_threshold AS mailinglist_digest_size_threshold, mailinglist.digest_volume_frequency AS mailinglist_digest_volume_frequency, mailinglist.discard_these_nonmembers AS mailinglist_discard_these_nonmembers, mailinglist.emergency AS mailinglist_emergency, mailinglist.encode_ascii_prefixes AS mailinglist_encode_ascii_prefixes, mailinglist.first_strip_reply_to AS mailinglist_first_strip_reply_to, mailinglist.forward_auto_discards AS mailinglist_forward_auto_discards, mailinglist.gateway_to_mail AS mailinglist_gateway_to_mail, mailinglist.gateway_to_news AS mailinglist_gateway_to_news, mailinglist.hold_these_nonmembers AS mailinglist_hold_these_nonmembers, mailinglist.info AS mailinglist_info, mailinglist.linked_newsgroup AS mailinglist_linked_newsgroup, mailinglist.max_days_to_hold AS mailinglist_max_days_to_hold, mailinglist.max_message_size AS mailinglist_max_message_size, mailinglist.max_num_recipients AS mailinglist_max_num_recipients, mailinglist.member_moderation_notice AS mailinglist_member_moderation_notice, mailinglist.mime_is_default_digest AS mailinglist_mime_is_default_digest, mailinglist.moderator_password AS mailinglist_moderator_password, mailinglist.newsgroup_moderation AS mailinglist_newsgroup_moderation, mailinglist.nntp_prefix_subject_too AS mailinglist_nntp_prefix_subject_too, mailinglist.nonmember_rejection_notice AS mailinglist_nonmember_rejection_notice, mailinglist.obscure_addresses AS mailinglist_obscure_addresses, mailinglist.owner_chain AS mailinglist_owner_chain, mailinglist.owner_pipeline AS mailinglist_owner_pipeline, mailinglist.personalize AS mailinglist_personalize, mailinglist.post_id AS mailinglist_post_id, mailinglist.posting_chain AS mailinglist_posting_chain, mailinglist.posting_pipeline AS mailinglist_posting_pipeline, mailinglist.display_name AS mailinglist_display_name, mailinglist.reject_these_nonmembers AS mailinglist_reject_these_nonmembers, mailinglist.reply_goes_to_list AS mailinglist_reply_goes_to_list, mailinglist.reply_to_address AS mailinglist_reply_to_address, mailinglist.require_explicit_destination AS mailinglist_require_explicit_destination, mailinglist.respond_to_post_requests AS mailinglist_respond_to_post_requests, mailinglist.scrub_nondigest AS mailinglist_scrub_nondigest, mailinglist.send_goodbye_message AS mailinglist_send_goodbye_message, mailinglist.send_welcome_message AS mailinglist_send_welcome_message, mailinglist.subject_prefix AS mailinglist_subject_prefix, mailinglist.subscription_policy AS mailinglist_subscription_policy, mailinglist.topics AS mailinglist_topics, mailinglist.topics_bodylines_limit AS mailinglist_topics_bodylines_limit, mailinglist.topics_enabled AS mailinglist_topics_enabled, mailinglist.unsubscription_policy AS mailinglist_unsubscription_policy \nFROM mailinglist \nWHERE mailinglist.list_id = %(list_id_1)s \n LIMIT %(param_1)s'] [parameters: {'list_id_1': 'mailman-users.mailman3.org', 'param_1': 1}]
Feb 21 20:40:15 2017 (25855) SHUNTING: 1487709615.6450088+26e420a287517d9447ec283883c46d4cb25d8b86
There was a postgresql upgrade to 9.3:amd64 9.3.16-0ubuntu0.14.04 automagically installed on both servers on Monday (20 Feb) which seems a likely culprit. Has anyone else seen issues with this upgrade?