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

Reply via email to