Dear All, I am running:
apache 2.2.3 / mod_perl / DBI v1.54, DBD::mysql v4.004 / Apache::DBI I am connecting to 2 MySQL databases: 1 on the local machine through a domain socket 1 over the LAN. 100% of the queries to the LAN connected db work fine 80% of the queries to the local db work fine. But the remaining 20% generate really bizarre errors - eg: [Fri May 04 01:44:04 2007] [error] [client 10.3.10.2] DBD driver has not implemented the AutoCommit attribute at /usr/lib/perl5/site_perl/5.8.8/Apache/DBI.pm line 277.\n DBD::mysql::db selectrow_array failed: Lost connection to MySQL server during query at /usr/lib/perl5/site_perl/Object/Root.pm line 954. The errors only ever happen with the local (socket) database. If I connect to this database through 127.0.0.1, then I never see the problem. The errors also don't happen if I disable Apache::DBI Does anybody have any idea why this is happening? Turning on Apache::DBI debugging doesn't print anything useful. Many thanks, Chris Allen, ps. This problem is 100% reproducible. I just don't know where to start looking...
