Heute (am 08.12.2005) schrieb Mark Martinec, > Jim,
>> Dec 6 22:25:21 server2 amavis[2335]: (02335-05) NOTICE: >> reconnecting in response to: sql execute: sts=2013, >> DBD::mysql::st execute failed: Lost connection to MySQL server >> during query at (eval 39) line 127, <GEN77> line 5. Dec 6 > Most likely nothing is wrong. MySQL server times out a long-lasting > session, thinking that it may have been stale or forgotten. > Amavisd recovers gracefully and reconnects, no harm is done. Thanks, but the errors are away. I use mysql 4.0.24 and phpMyAdmin told me by creating (for example): --snip CREATE TABLE users ( id INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY, priority integer NOT NULL DEFAULT '7', policy_id integer unsigned NOT NULL DEFAULT '1', email varchar(255) NOT NULL, fullname varchar(255) DEFAULT NULL, local char(1), KEY email (email) ); CREATE UNIQUE INDEX users_idx_email ON users (email); --snap UNIQUE and INDEX keys should not both be set for column `email` And now I`ve creating the table without the last column (CREATE UNIQUE INDEX users_idx_email ON users (email);). And all work fine. AND - I`ve tuning mysql in my.cnf. ;) Another question again. Sorry. What mean "priority" in the table mailaddr, users? > Mark -- Viele Grüße, Kind regards, Jim Knuth [EMAIL PROTECTED] ICQ #277289867 - VoIP: +49 (0) 32 22 12 04 467 PGP: Key ID: 0x1F78066F ---------- Zufalls-Zitat ---------- Sei doch mal ruhig, ich sehe was! ---------- Der Text hat nichts mit dem Empfänger der Mail zu tun ---------- Virus free. Checked by NOD32 Version 1.1315 Build 6423 07.12.2005 ------------------------------------------------------- This SF.net email is sponsored by: Splunk Inc. Do you grep through log files for problems? Stop! Download the new AJAX search engine that makes searching your log files as easy as surfing the web. DOWNLOAD SPLUNK! http://ads.osdn.com/?ad_idv37&alloc_id865&op=click _______________________________________________ AMaViS-user mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/amavis-user AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3 AMaViS-HowTos:http://www.amavis.org/howto/
