Hi, I'm running MySQL 5.0.19 (Debian sid, package revision 3) on a Dual Opteron250 64 bit machine with 4gb memory.
The problem i'm experiencing is that at certain moments, the connection between my perlscripts and the database gets disconnected: | DBI connect('products','beheerv',...) failed: Lost connection to MySQL | server during query at /var/web/modules/Master.pm line 98 | Master.pm: unable to connect to products db: Lost connection to MySQL | server during query at /var/web/modules/Master.pm line 98. And: | DBD::mysql::st execute failed: Lost connection to MySQL server during | query at /var/web/cron/stats.pl line 673. | DBD::mysql::st fetchrow_hashref failed: fetch() without execute() at | /var/web/cron/stats.pl line 677. I thought the query at that spot would be wrong, but it turns out that this alone is not causing the problem. If i skip over the rest of the perlscript and jump to that line 672 immediately, it works like expected. I'd like to hear how I can debug this. MySQL doesn't seem to log ANYTHING about this issue. All I get is the messages above. I turned on query logging, and it just shows the query that is executed at line 673 of stats.pl: | SELECT theme, cat, subcat, p_ids, | UNIX_TIMESTAMP(insert_time) as insert_time | FROM log_product | WHERE insert_time >= FROM_UNIXTIME('1146348000') | AND insert_time < FROM_UNIXTIME('1146952800'); (this query, when redirected to a textfile returns about 25 megabytes of data, in ~540784 rows) After that no more queries from the same connection ID are logged. But that is expected, as the connection was lost ;) Can anyone shed any light on this issue? Thanks!! Sander. -- | Honk if you love peace and quiet. | 1024D/08CEC94D - 34B3 3314 B146 E13C 70C8 9BDB D463 7E41 08CE C94D -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]