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 th
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> What is happening is that when you start you perl script which
> contains a lot of queries, you are first establishing a connection to
> MySQL, and then you are running some queries, and somewhere in between
> you are losing connection to the server,
Quoting sheeri kritzer ([EMAIL PROTECTED]):
> Do a "show status like 'uptime'" after the script runs. See if the
> server crashed (if so, uptime will be low) -- if the server crashed
> you might get that error.
The server itself does not crash. Uptime shows that, besides the fact
that this would
On 5/5/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> >Can anyone shed any light on this issue?
> This might shed more light into your problem
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But still, the query returns th
Do a "show status like 'uptime'" after the script runs. See if the
server crashed (if so, uptime will be low) -- if the server crashed
you might get that error.
show variables like "%connections" should show you how many
connections you can have per user and total. That shouldn't be the
problem
Quoting Kishore Jalleda ([EMAIL PROTECTED]):
> >Can anyone shed any light on this issue?
> This might shed more light into your problem
> http://dev.mysql.com/doc/refman/5.0/en/gone-away.html
I've read that :)
But still, the query returns the same data, if I run it alone, or in the
complete sta
On 5/5/06, Sander Smeenk <[EMAIL PROTECTED]> wrote:
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 disconnecte
