Hi, Victoria Reznichenko wrote:
VR> Martin, VR> Wednesday, April 03, 2002, 5:45:00 PM, you wrote: VR> VR> MM> would anyone please explain me what are these error messages? VR> VR> MM> 020327 12:29:26 mysqld started VR> MM> 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98 VR> MM> /usr/local/mysql/bin/mysqld: ready for connections VR> MM> /usr/local/mysql/bin/mysqld: ready for connections VR> MM> 020327 12:29:26 Error in accept: Invalid argument VR> MM> 020327 12:29:26 Error in accept: Invalid argument VR> MM> [There're plenty of those "Error in accept messages".] VR> VR> # perror 98 VR> Error code 98: Address already in use VR> Is your mysql server box behind a firewall? Perhaps firewall to keep VR> out MySQL server. No firewall between those machines. I was told later by people the machine had load 20 so probably safe_mysqld restarted mysqld and it retried to start mysqld twice at the same time. I don't know why that happened so quickly, all within one second. VR> VR> [...] VR> VR> MM> Actually there's a hit in old docs in Solaris section(maybe I missed that VR> MM> in current docs?): VR> MM> http://www.google.de/search?q=cache:XowJDknOOI4C:theoryx5.uwinnipeg.ca/mysql/manual_4.html+mysql+Error+in+accept:+Invalid+argument&hl=de VR> MM> If too many processes try to connect very rapidly to mysqld, you will see this VR> error in the MySQL log: VR> MM> Error in accept: Protocol error VR> MM> You might try starting the server with the --set-variable back_log=50 option VR> as a workaround for this. VR> VR> How does 'Error in accept: Protocol error' belong to error that you VR> received? Probably no relation, that was just the only Google hit I had. Maybe few words in the offcial documentation about this kind of errors? Possible causes, solutions? VR> MM> ERROR 1036 at line 46: Table 'intergenome' is read only VR> MM> Failed to dump Synechocystis_PCC6803.intergenome VR> MM> ERROR 1062 at line 46: Duplicate entry '0' for key 1 VR> MM> Failed to dump Tmaritima.intergenome VR> VR> Looks like you have corrupted indexes. And speaking about 'table is VR> read-only' it means that you have no permissions to write ih those VR> files, but it can make problems in dump ... Unfortunately none of them are true, but Michael is looking into this already. Thanks. -- Martin Mokrejs <[EMAIL PROTECTED]> PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics <http://mips.gsf.de> GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax: +49-89-3187 3585 --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php