Mailinglisten-Archive |
Gestern ist mir unser NT mysql Server zig-fach abgestürzt. Das Problem: veschiedene clients (in diesem Fall: Java-Servlets) greifen gleichzeitig von verschiedenen Rechnern aus unter ein und demselben User auf verschiedene Datenbanken zu. In unterschiedlich kurzen Abständen (2 Minuten bis 15 Minuten) bricht mysqld die Verbindung zu einem - jedesmal einem anderen - Client ab. Sobald dies aufgetreten ist, können auch die anderen Clients nicht mehr zugreifen, es hilft nur noch ein Neustart des mysqld. Unten ein kleiner Auszug aus dem Log. Die Erklärungen in der Doku sind nicht wirklich hilfreich, auch das Archiv dieser Liste und das der englischen Liste (geocrawler) brachte keine Erkenntnisse. Wir kommunizieren über TCP/IP, das Netz ist in Ordnung (zumindest haben unsere anderen DB Server (DB2, Oracle) nie Probleme mit Paketgrößen, Timeouts etc), außerdem treten die Probleme auch über localhost auf, das bedeutt, dass es nicht an irgeneinem hub oder switch liegt. Laut Statusanzeige wurden nie mehr connections gleichzeitig verwendet als in den MAx variable angezeigt (max steht auf 100), alle Timeouts haben wir massiv hochgesetzt. Umgebung: mysqld-max-nt 3.23.39 alle benutzten Tabellen waren vom Typ BDB. Wir habe jetzt auf InnoDB umgestellt, das sieht stabiler aus Bin für jeden Hinweis dankbar, Gruß, Rüdiger Hier das Log: mysqld-max-nt.exe: ready for connections 010809 15:08:35 Aborted connection 5 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 15:08:35 Aborted connection 7 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 15:47:08 Aborted connection 11 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 16:05:25 Aborted connection 13 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 16:05:25 Aborted connection 8 to db: 'WORKFLOW' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 16:05:25 Aborted connection 23 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 16:05:25 Aborted connection 10 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 16:05:25 Aborted connection 14 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 16:56:25 Aborted connection 36 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.14' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 18:30:12 Aborted connection 30 to db: 'META' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 46 to db: 'ENOMIC_USER_DB' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 26 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 25 to db: 'CMS_EXT' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 47 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 60 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 50 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 62 to db: 'CMS_EXT' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 52 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 49 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 51 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 19:12:48 Aborted connection 63 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 20:07:55 Aborted connection 67 to db: 'CMS_EXT' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 20:07:55 Aborted connection 68 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 20:07:55 Aborted connection 65 to db: 'CMS_EXT' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010809 20:07:55 Aborted connection 66 to db: 'WORKFLOW' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010810 7:05:41 Aborted connection 88 to db: 'unconnected' user: 'ODBC' host: `localhost' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010810 7:05:41 mysqld-max-nt.exe: Normal shutdown 010810 7:05:42 mysqld-max-nt.exe: Forcing close of thread 87 user: 'intermed' 010810 7:05:42 mysqld-max-nt.exe: Forcing close of thread 86 user: 'intermed' 010810 7:05:42 mysqld-max-nt.exe: Forcing close of thread 85 user: 'intermed' 010810 7:05:42 mysqld-max-nt.exe: Forcing close of thread 2 user: 'intermed' 010810 7:05:42 Aborted connection 86 to db: 'CMS_EXT' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010810 7:05:42 Aborted connection 2 to db: 'mysql' user: 'intermed' host: `cms' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010810 7:05:42 Aborted connection 87 to db: 'ENOMIC_USER_DB' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html 010810 7:05:42 Aborted connection 85 to db: 'ENOMIC_USER_DB' user: 'intermed' host: `192.168.231.6' (Unknown error) - see http://www.mysql.com/doc/C/o/Communication_errors.html --- !!NEU!! Fragen und Antworten zu MySQL und dieser Liste unter -->> http://www.4t2.com/mysql
php::bar PHP Wiki - Listenarchive