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