The mailing list for listmasters using Sympa

["True, James Scott" <address@concealed>]

Hello,

 

Indiana University applied the “patch” for this issue early Sunday July 10^th. We have had no errors due to Signoff Request until this morning. I removed the message from the queue and restarted Sympa. It has been running normally since. The Sympa logs are below. There only thing in the MySQL logs is “Got timeout reading communication packets”. This error occurs when idle threads are killed by wait_timeout. Does Sympa call mysql_close() in scripts when the connection is no longer needed?

 

Any idea when release 6.2.70 will be out?

 

Thanks,

 

Jim True

Email Systems Administrator

Campus Communications Infrastructure

University Information Technology Services

Indiana University

812-855-7519

address@concealed

 

 

 

 

 

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2094 > Sympa::Database::do_prepared_query#360 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#113 Transaction on database Sympa::DatabaseDriver::MySQL <db_host=list-db.uits.indiana.edu;db_name=sympa;db_port=3306;db_user=sympa> was aborted: Turning off AutoCommit failed

Jul 15 02:25:17 list- server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2094 > Sympa::Database::do_prepared_query#361 Unable to get a handle to sympa database

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2094 > Sympa::Database::do_prepared_query#360 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#113 Transaction on database Sympa::DatabaseDriver::MySQL <db_host=list-db.uits.indiana.edu;db_name=sympa;db_port=3306;db_user=sympa> was aborted: Turning off AutoCommit failed

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2094 > Sympa::Database::do_prepared_query#361 Unable to get a handle to sympa database

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2094 > Sympa::Database::do_prepared_query#360 > Sympa::DatabaseDriver::MySQL::connect#58 > Sympa::Database::connect#113 Transaction on database Sympa::DatabaseDriver::MySQL <db_host=list-db.uits.indiana.edu;db_name=sympa;db_port=3306;db_user=sympa> was aborted: Turning off AutoCommit failed

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2094 > Sympa::Database::do_prepared_query#361 Unable to get a handle to sympa database

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2109 Unable to gather information for user: address@concealed

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1561 > Sympa::List::insert_delete_exclusion#1887 > Sympa::List::get_list_member#2109 Unable to gather information for user: address@concealed

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1621 > Sympa::Database::commit#439 DIED: bug in logic. Ask developer at /usr/share/sympa/lib/Sympa/Database.pm line 439.

Jul 15 02:25:17 list-server sympa_msg[3001]: err main::#243 > Sympa::Spindle::spin#95 > Sympa::Spindle::DoCommand::_twist#120 > Sympa::Spindle::spin#95 > Sympa::Request::Handler::signoff::_twist#74 > Sympa::List::delete_list_member#1621 > Sympa::Database::commit#439 DIED: bug in logic. Ask developer at /usr/share/sympa/lib/Sympa/Database.pm line 439.

Jul 15 02:25:17 list-server task_manager[3004]: notice main::sigterm() Signal TERM received, still processing current task

Jul 15 02:25:17 list-server task_manager[3004]: notice main::sigterm() Signal TERM received, still processing current task

Jul 15 02:25:17 list-server task_manager[3004]: notice main:: Task_Manager exited normally due to signal

Jul 15 02:25:17 list-server task_manager[3004]: notice main:: Task_Manager exited normally due to signal

 

 

2022-07-15T02:23:04.063626Z 33677 [Note] Aborted connection 33677 to db: 'sympa' user: 'sympa' host: 'list-server' (Got timeout reading communication packets)

2022-07-15T02:23:27.924353Z 33678 [Note] Aborted connection 33678 to db: 'sympa' user: 'sympa' host: 'list-server' (Got timeout reading communication packets)

2022-07-15T02:27:15.816937Z 33682 [Note] Aborted connection 33682 to db: 'sympa' user: 'sympa' host: 'list-server' (Got timeout reading communication packets)

2022-07-15T02:28:40.091120Z 33681 [Note] Aborted connection 33681 to db: 'sympa' user: 'sympa' host: 'list-server' (Got timeout reading communication packets)