Hello all. I am working with MySQL 3.23.58 (Ver 11.18) on a Fedora Core 3 system, Mailman 2.1.6, and the Mysql MemberAdaptor. Today, this system experienced a problem while using the list_lists command line tool which seems to be related to the Mysql MemberAdaptor. The following error was provided:
Fatal error connecting to MySQL database mailman (1040): Too many connections Exception exceptions.AttributeError: "MysqlMemberships instance has no attribute 'cursor'" in <bound method MysqlMemberships.__del__ of <Mailman.MysqlMemberships.MysqlMemberships instance at 0xb7b3884c>> ignored To resolve this problem, I restarted the MySQL server (which resides on the same host as the Mailman and Postfix server). Below is a MySQL 'show processlist' of the processes running (?) when this error was displayed. Could this be an issue with the Mysql MemberAdaptor not releasing connections? (I realize this list does not solely exist to provide support for patches, but I also know there are individuals that have worked with this patch who have frequented the list in the past.) Thank you, -Adrian mysql> SHOW PROCESSLIST; +-------+-----------+-----------+---------+---------+---------+-------+------------------+ | Id | User | Host | db | Command | Time | State | Info | +-------+-----------+-----------+---------+---------+---------+-------+------------------+ | 14504 | mailmandb | localhost | mailman | Sleep | 1513375 | | NULL | | 14508 | mailmandb | localhost | mailman | Sleep | 1920366 | | NULL | | 14545 | mailmandb | localhost | mailman | Sleep | 196702 | | NULL | | 14546 | mailmandb | localhost | mailman | Sleep | 196704 | | NULL | | 14547 | mailmandb | localhost | mailman | Sleep | 196700 | | NULL | | 14551 | mailmandb | localhost | mailman | Sleep | 1430519 | | NULL | | 14552 | mailmandb | localhost | mailman | Sleep | 1430521 | | NULL | | 14553 | mailmandb | localhost | mailman | Sleep | 1430518 | | NULL | | 14554 | mailmandb | localhost | mailman | Sleep | 38720 | | NULL | | 14555 | mailmandb | localhost | mailman | Sleep | 38720 | | NULL | | 14556 | mailmandb | localhost | mailman | Sleep | 38719 | | NULL | | 14557 | mailmandb | localhost | mailman | Sleep | 38705 | | NULL | | 14558 | mailmandb | localhost | mailman | Sleep | 38704 | | NULL | | 14559 | mailmandb | localhost | mailman | Sleep | 38703 | | NULL | | 14759 | mailmandb | localhost | mailman | Sleep | 1741488 | | NULL | | 14858 | mailmandb | localhost | mailman | Sleep | 18618 | | NULL | | 14907 | mailmandb | localhost | mailman | Sleep | 1809176 | | NULL | | 15012 | mailmandb | localhost | mailman | Sleep | 1789990 | | NULL | | 15013 | mailmandb | localhost | mailman | Sleep | 63692 | | NULL | | 15033 | mailmandb | localhost | mailman | Sleep | 64803 | | NULL | | 15034 | mailmandb | localhost | mailman | Sleep | 64802 | | NULL | | 15042 | mailmandb | localhost | mailman | Sleep | 1779391 | | NULL | | 15095 | mailmandb | localhost | mailman | Sleep | 1787571 | | NULL | | 15096 | mailmandb | localhost | mailman | Sleep | 58763 | | NULL | | 15116 | mailmandb | localhost | mailman | Sleep | 62932 | | NULL | | 15117 | mailmandb | localhost | mailman | Sleep | 62931 | | NULL | | 15128 | mailmandb | localhost | mailman | Sleep | 1787008 | | NULL | | 15130 | mailmandb | localhost | mailman | Sleep | 64207 | | NULL | | 15177 | mailmandb | localhost | mailman | Sleep | 64724 | | NULL | | 15178 | mailmandb | localhost | mailman | Sleep | 64724 | | NULL | | 15198 | mailmandb | localhost | mailman | Sleep | 1785738 | | NULL | | 15199 | mailmandb | localhost | mailman | Sleep | 63444 | | NULL | | 15259 | mailmandb | localhost | mailman | Sleep | 1292509 | | NULL | | 15260 | mailmandb | localhost | mailman | Sleep | 81444 | | NULL | | 15261 | mailmandb | localhost | mailman | Sleep | 81443 | | NULL | | 15262 | mailmandb | localhost | mailman | Sleep | 1782744 | | NULL | | 15263 | mailmandb | localhost | mailman | Sleep | 1782743 | | NULL | | 15264 | mailmandb | localhost | mailman | Sleep | 1782742 | | NULL | | 15265 | mailmandb | localhost | mailman | Sleep | 64804 | | NULL | | 15516 | mailmandb | localhost | mailman | Sleep | 898199 | | NULL | | 15658 | mailmandb | localhost | mailman | Sleep | 1080278 | | NULL | | 15659 | mailmandb | localhost | mailman | Sleep | 173981 | | NULL | | 15660 | mailmandb | localhost | mailman | Sleep | 304728 | | NULL | | 15661 | mailmandb | localhost | mailman | Sleep | 173980 | | NULL | | 15662 | mailmandb | localhost | mailman | Sleep | 1513762 | | NULL | | 15663 | mailmandb | localhost | mailman | Sleep | 1513755 | | NULL | | 15664 | mailmandb | localhost | mailman | Sleep | 304427 | | NULL | | 15665 | mailmandb | localhost | mailman | Sleep | 1513757 | | NULL | | 15666 | mailmandb | localhost | mailman | Sleep | 1513753 | | NULL | | 15667 | mailmandb | localhost | mailman | Sleep | 281688 | | NULL | | 15668 | mailmandb | localhost | mailman | Sleep | 1466194 | | NULL | | 15669 | mailmandb | localhost | mailman | Sleep | 1081178 | | NULL | | 15670 | mailmandb | localhost | mailman | Sleep | 304428 | | NULL | | 15671 | mailmandb | localhost | mailman | Sleep | 173983 | | NULL | | 15709 | mailmandb | localhost | mailman | Sleep | 47519 | | NULL | | 15710 | mailmandb | localhost | mailman | Sleep | 47519 | | NULL | | 15711 | mailmandb | localhost | mailman | Sleep | 47518 | | NULL | | 19847 | mailmandb | localhost | mailman | Sleep | 51998 | | NULL | | 19848 | mailmandb | localhost | mailman | Sleep | 51997 | | NULL | | 19849 | mailmandb | localhost | mailman | Sleep | 51996 | | NULL | | 20164 | mailmandb | localhost | mailman | Sleep | 684161 | | NULL | | 21367 | mailmandb | localhost | mailman | Sleep | 52922 | | NULL | | 21368 | mailmandb | localhost | mailman | Sleep | 52921 | | NULL | | 22439 | mailmandb | localhost | mailman | Sleep | 64749 | | NULL | | 22440 | mailmandb | localhost | mailman | Sleep | 65439 | | NULL | | 22441 | mailmandb | localhost | mailman | Sleep | 64725 | | NULL | | 22453 | mailmandb | localhost | mailman | Sleep | 64208 | | NULL | | 22454 | mailmandb | localhost | mailman | Sleep | 62933 | | NULL | | 22455 | mailmandb | localhost | mailman | Sleep | 58764 | | NULL | | 22456 | mailmandb | localhost | mailman | Sleep | 63693 | | NULL | | 22457 | mailmandb | localhost | mailman | Sleep | 63445 | | NULL | | 22463 | mailmandb | localhost | mailman | Sleep | 62560 | | NULL | | 22464 | mailmandb | localhost | mailman | Sleep | 62562 | | NULL | | 22465 | mailmandb | localhost | mailman | Sleep | 62559 | | NULL | | 22576 | root | localhost | NULL | Query | 0 | NULL | SHOW PROCESSLIST | +-------+-----------+-----------+---------+---------+---------+-------+------------------+ 75 rows in set (0.00 sec) _______________________________________________ Mailman-Developers mailing list Mailman-Developers@python.org http://mail.python.org/mailman/listinfo/mailman-developers Mailman FAQ: http://www.python.org/cgi-bin/faqw-mm.py Searchable Archives: http://www.mail-archive.com/mailman-users%40python.org/ Unsubscribe: http://mail.python.org/mailman/options/mailman-developers/archive%40jab.org Security Policy: http://www.python.org/cgi-bin/faqw-mm.py?req=show&file=faq01.027.htp
