Hi, would anyone please explain me what are these error messages? 020327 12:29:26 mysqld started 020327 12:29:26 Warning: listen() on TCP/IP failed with error 98 /usr/local/mysql/bin/mysqld: ready for connections /usr/local/mysql/bin/mysqld: ready for connections 020327 12:29:26 Error in accept: Invalid argument 020327 12:29:26 Error in accept: Invalid argument [There're plenty of those "Error in accept messages".]
Looking into official searchable documnetation gives me no hits. Google search returns old thread from mysql archives - suggestion was to recompile because the binaries were compiled on other box with different. As I use official binaries ... :( Actually there's a hit in old docs in Solaris section(maybe I missed that in current docs?): http://www.google.de/search?q=cache:XowJDknOOI4C:theoryx5.uwinnipeg.ca/mysql/manual_4.html+mysql+Error+in+accept:+Invalid+argument&hl=de If too many processes try to connect very rapidly to mysqld, you will see this error in the MySQL log: Error in accept: Protocol error You might try starting the server with the --set-variable back_log=50 option as a workaround for this. That might be a solution, but the cause for my error is "Invalid argument"! And what about the error 98? I can't say much what happened, I's dumping large MyISAM tables to this servers during easters and this is what I've found(but might be totally unrelated): ERROR 1062 at line 46: Duplicate entry '0' for key 1 Failed to dump Mthermoautotrophicum.intergenome ERROR 1062 at line 46: Duplicate entry '0' for key 1 Failed to dump Pyrococcus_abyssi_GE5.intergenome ERROR 1062 at line 46: Duplicate entry '0' for key 1 Failed to dump Pyrococcus_horikoshii_OT3.intergenome ERROR 1062 at line 46: Duplicate entry '0' for key 1 Failed to dump Rprowazekii.intergenome ERROR 1062 at line 46: Duplicate entry '0' for key 1 Failed to dump Sulfolobus_solfataricus_P2.intergenome ERROR 1036 at line 46: Table 'intergenome' is read only Failed to dump Synechocystis.intergenome ERROR 1036 at line 46: Table 'intergenome' is read only Failed to dump Synechocystis_PCC6803.intergenome ERROR 1062 at line 46: Duplicate entry '0' for key 1 Failed to dump Tmaritima.intergenome Actually this problem I've already seen once, but forgot to report. ;) There're couple of interresting things: 1. I'm using `--add-drop-table' argument to dump each table using mysqldump. 2. Source tables aren't compressed. MyISAM file: /data/mysql/Sulfolobus_solfataricus_P2/intergenome.MYI Record format: Packed Character set: latin1 (8) File-version: 1 Creation time: 2002-01-25 9:52:45 Status: changed Data records: 976106 Deleted blocks: 0 Datafile parts: 1952210 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 Datafile length: 235019464 Keyfile length: 66795520 Max datafile length: 4294967294 Max keyfile length: 4398046510079 Recordlength: 1019 table description: Key Start Len Index Type Rec/key Root Blocksize 1 2 3 unique uint24 1 59776000 1024 2 211 255 multip. char packed stripped 0 12270592 2048 3 753 255 multip. char packed stripped 0 7548928 2048 4 111 100 multip. char packed stripped 0 39867392 1024 5 5 3 multip. uint24 0 59780096 1024 6 8 3 multip. uint24 0 59784192 1024 MyISAM file: /data/mysql/Synechocystis/intergenome.MYI Record format: Packed Character set: latin1 (8) File-version: 1 Creation time: 2002-01-26 1:28:24 Status: changed Data records: 1138312 Deleted blocks: 0 Datafile parts: 1518104 Deleted data: 0 Datafile pointer (bytes): 4 Keyfile pointer (bytes): 4 Datafile length: 241362564 Keyfile length: 77243392 Max datafile length: 4294967294 Max keyfile length: 4398046510079 Recordlength: 1019 table description: Key Start Len Index Type Rec/key Root Blocksize 1 2 3 unique uint24 1 61722624 1024 2 211 255 multip. char packed stripped 0 10539008 2048 3 753 255 multip. char packed stripped 0 8295424 2048 4 111 100 multip. char packed stripped 0 44457984 1024 5 5 3 multip. uint24 0 61726720 1024 6 8 3 multip. uint24 0 61730816 1024 3. On the target I do compress tables, but they should be dropped first if present. So, it's not clear to me what cause the problem that entry for key 0 is duplicated. CHECK TABLE on source machine says tables are fine. Any ideas? Please Cc: me in replies. Thanks. Linux 2.4.19-pre1 SMP 1GB RAM, official binaries mysql-3.23.49a, linux-i386. -- Martin Mokrejs - 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
