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
