Bill Adams wrote: > Spoiler: You may be right about the bad libs...
[snip] > *** OMG *** > But haha I cannot believe this, I was just looking at the libraries linked by > mysqld with ldd and it is using the informix libpthread.so. Hmm, crap. *me > slaps head* Small Update: o If there is no call to 'flush tables', even a small data load will cause myisamcheck to report "warning: 1 clients is using or hasn't closed the table properly" when I know there is no client accessing it. In this case myisamcheck does fix the problem. o If I call 'flush tables' even at the program exit, I do not get the warning. o Using the statically linked 4.0 binary from mysql.com had no effect on the results. o Upgrading DBI to the latest version had no effect on the results. o Upgrading to the latest msql-mysql-moudles did not effect the results. I was playing around with the 'flush tables' and managed to quickly corrupt a table without any flush call. I saved a copy of the table if the mysql folks should want to take a look for some unknown reason. [bill@host ~/dev]$ /usr/local/mysql-4.0/bin/myisamchk -e ../bad-tables/pcm_test_site_200105.MYI Checking MyISAM file: ../bad-tables/pcm_test_site_200105.MYI Data records: 58923 Deleted blocks: 0 /usr/local/mysql-4.0/bin/myisamchk: warning: 1 clients is using or hasn't closed the table properly - check file-size - check key delete-chain - check record delete-chain - check index reference - check data record references index: 1 - check records and index references /usr/local/mysql-4.0/bin/myisamchk: error: Record-count is not ok; is 58328 Should be: 58923 /usr/local/mysql-4.0/bin/myisamchk: warning: Found 595 deleted blocks Should be: 0 MyISAM-table '../bad-tables/pcm_test_site_200105.MYI' is corrupted Fix it using switch "-r" or "-o" But running myisamchk without the -e just gives the 'clients using' warning. Also, '-r' will repair the table in this case and adding the flush back in seems to prevent the error from happening. Well, it is almost beer o'clock. I will try this on other machines on Monday. --Bill --------------------------------------------------------------------- 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