[Mailman-Developers] Mysql MemberAdaptor and Mailman 2.1.6
Adrian Wells
adrian at whatifnet.com
Fri Jan 13 14:54:37 CET 2006
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)
More information about the Mailman-Developers
mailing list