Hello everyone,

This problem seems to be solved...

> The problem i'm experiencing is that at certain moments, the connection
> between my perlscripts and the database gets disconnected.

[...]

> 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.

It seems to turn out to diskspace problems.  The partition that hosted
/tmp, in which MySQL creates tempfiles during queries was rather full.

But for some strange reason it didn't trigger MySQL to say 'Can't write
to file /tmp/mysql.XXXXXXX: No space left on device.'.

It did that only after the partition was REALLY full. Then I saw the 'No
space left on device' message, and cleared up the partition. And now
this problem has gone away.

Really hard to debug this on a live system, but i thought i'd let you
guys know...

Thanks again for all the hints and help!

Kind regards,
Sander Smeenk.
-- 
| Just remember -- if the world didn't suck, we would all fall off.
| 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]

Reply via email to