Hi: I am finding that my perl code generates warnings by myisamchk whenever it executes an INSERT command, but *NOT* a SELECT command. I just upgraded this perl application (which had no problems before), to: MySQL-3.23.48-1 perl-DBD-MySQL-1.2216-4 perl-DBI-1.18-1
If I connect to the database and issue a 'check table rxList', then problem clears up... (due to the counter being zeroed). Has anyone else seen this behaviour with MySQL? Debug info below. Thanks Keith myisamchk -e reports: Checking MyISAM file: /var/lib/mysql/DEV_MED/rxList.MYI Data records: 7109 Deleted blocks: 0 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 MyISAM-table '/var/lib/mysql/DEV_MED/rxList.MYI' is usable but should be fixed DBI->trace(2) reports: DBI 1.18-nothread dispatch trace level set to 2 -> DBI->connect(DBI:mysql:DEV_MED:localhost:3306, DEV, ****) -> DBI->install_driver(mysql) for perl=5.006 pid=27365 ruid=500 euid=500 install_driver: DBD::mysql version 2.0416 loaded from /usr/lib/perl5/site_perl/5.6.0/i386-linux/DBD/mysql.pm <- install_driver= DBI::dr=HASH(0x8265670) -> connect for DBD::mysql::dr (DBI::dr=HASH(0x8265670)~0x82afb6c 'DEV_MED:localhost:3306' 'DEV' **** HASH(0x80f6460)) imp_dbh->connect: dsn = DEV_MED:localhost:3306, uid = DEV, pwd = test imp_dbh->MyLogin: dbname = DEV_MED, uid = DEV, pwd = test,host = localhost, port = 3306 imp_dbh->MyConnect: host = localhost, port = 3306, uid = DEV, pwd = test imp_dbh->MyConnect: client_flags = 0 <- connect= DBI::db=HASH(0x82afba8) at DBI.pm line 416. -> STORE for DBD::mysql::db (DBI::db=HASH(0x82afc20)~INNER 'PrintError' 1) <- STORE= 1 at DBI.pm line 441. -> STORE for DBD::mysql::db (DBI::db=HASH(0x82afc20)~INNER 'AutoCommit' 1) <- STORE= 1 at DBI.pm line 441. <- connect= DBI::db=HASH(0x82afba8) -> quote for DBD::mysql::db (DBI::db=HASH(0x82afba8)~0x82afc20 'first') <- quote= ''first'' at dbtest.pl line 35. -> quote for DBD::mysql::db (DBI::db=HASH(0x82afba8)~0x82afc20 'last') <- quote= ''last'' at dbtest.pl line 36. -> quote for DBD::mysql::db (DBI::db=HASH(0x82afba8)~0x82afc20 'email') <- quote= ''email'' at dbtest.pl line 37. doing INSERT -> do for DBD::mysql::db (DBI::db=HASH(0x82afba8)~0x82afc20 'INSERT INTO rxList (first, last, email) VALUES('first', 'last', 'email')') <- do= 1 at dbtest.pl line 40. -> disconnect for DBD::mysql::db (DBI::db=HASH(0x82afba8)~0x82afc20) imp_dbh->svsock: 82b1cb4 <- disconnect= 1 at dbtest.pl line 42. -> DESTROY for DBD::mysql::db (DBI::db=HASH(0x82afc20)~INNER) <- DESTROY= undef. -- DBI::END -> disconnect_all for DBD::mysql::dr (DBI::dr=HASH(0x8265670)~0x82afb6c) <- disconnect_all= '' at DBI.pm line 458. -> DESTROY in DBD::_::common for DBD::mysql::dr (DBI::dr=HASH(0x82afb6c)~INNER) <- DESTROY= undef during global destruction. --------------------------------------------------------------------- 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