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
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: Lo
