Subject: Lost the capacity to get paramters
I installed a new machine with CENTOS 5 64 Bits and DBI 1.604, later svn,
DBD-Sybase 1.08, I execute this perl script
#!/usr/bin/perl
use strict;
use DBI;
my $server = "";
my $db = "minixel";
my $username = "sa&quo
On Sun, Sep 11, 2005 at 03:55:47PM -0400, Sam Tregar wrote:
> On Sun, 11 Sep 2005, Tim Bunce wrote:
>
> > Child process will inherit the parents db connection and $dbh.
> > When the child process exits perl will DESTROY all objects,
> > included the inherited $dbh. That will disconnect the mysql
>
a sample difficult. The
> error I'm getting is this:
>
> DBD::mysql::st execute failed: Lost connection to MySQL server
>during query
>
> This error always occurs in the parent process, and the children never
> encounter an error. Here are the things I've d
On Sun, 11 Sep 2005, Tim Bunce wrote:
> Child process will inherit the parents db connection and $dbh.
> When the child process exits perl will DESTROY all objects,
> included the inherited $dbh. That will disconnect the mysql
> socket connection 'behind the back' of the parent.
>
> You must set
Hello all. I'm trying to solve a bug in a daemon which uses multiple
processes to handle jobs in a queue. The code is bound up in a rather
large Class::DBI app which makes posting a sample difficult. The
error I'm getting is this:
DBD::mysql::st execute failed: Lost connectio
Did you try perldoc DBD::ODBC and look for more_results?
$sth->{odbc_more_results}...
Jeff
> -Original Message-
> From: Mitchell, Louise M [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, August 30, 2005 11:03 AM
> To: Jeff Urlwin; dbi-users@perl.org
> Subject: RE: error
print "err: $DBI::errstr \n";
# }
#else
# {
#print "**row: @row_ary \n";
# }
# }
#}
Thanks for any help,
Louise Mitchell
-Original Message-
From: Jeff Urlwin [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 27, 2005 8:54 AM
To: Mitchell
Try checking your second $sth for more_results. It may be affecting the
outcome.
Regards,
Jeff
> -Original Message-
> From: Mitchell, Louise M [mailto:[EMAIL PROTECTED]
> Sent: Friday, August 26, 2005 4:31 PM
> To: dbi-users@perl.org
> Subject: RE: error string being lo
DBI::errstr\n\n";
print "dropped\n\n";
***
RESULTS BELOW
***
created
test_raiserror1 - usually works
rows:
errstr: [Microsoft][ODBC SQL Server Driver][SQL Server]my error
(SQL-42000)(DBD: Execute immediate failed err=-1)
test_rais
auses Windows clients using the library to die with a
Lost connection to MySQL server during query
error for queries that take more than 30 seconds. This problem is
specific to Windows; clients on other platforms are unaffected.
This sounds similar to your report.
On 8/2/05
that uses
libmysql.lib) to 4.0.16 or above. This is
because the 4.0.15 release had a bug in the Windows client library
that causes Windows clients using the library to die with a
Lost connection to MySQL server during query
error for queries that take more than 30
approximately 8.5 million rows in this table. The computer is
Windows 2000 and perl version is 5.8.3. The message printed when it
times out is: execute failed: Lost connection to MySQL server during
query(2013).
Any help would be much appreciated.
Thanks.
Rob
perl script:
#!c:/perl/bin
I am having a problem which sounds like it may be related to yesterday's
post: "[dbi] error string being lost in DBD::ODBC." From what I can
tell there are a few problems that together keep me from being able to
catch and handle a SQL error (MS SQL Server 2000).
The fatal error
Adam,
Have you tried:
odbc_async_exec
Allow asynchronous execution of queries. Right now,
this causes a spin-loop (with a small "sleep") until
the sql is complete. This is useful, however, if you
want the error handling and asynchronous message
I'm having a problem where the error string from a raiserror (inside a
stored procedure) is disappearing. I've reduced it to the fact that it
only occurs if there is some part of the stored procedure that returns
rows (0 or more).
Here is a code snippet that illustrates the problem:
use DBI;
u
On Wed, 13 Aug 2003, Kalin KOZHUHAROV wrote:
> B. Tolka wrote:
> > In my logs I keep getting error messages like this every few hours. The
> > wait_timout on mysql is 28800.
> >
> > DBD::mysql::st execute failed: Lost connection to MySQL server during query
>
&
B. Tolka wrote:
In my logs I keep getting error messages like this every few hours. The wait_timout on mysql is 28800.
DBD::mysql::st execute failed: Lost connection to MySQL server during query
Are you using fork? Or system or exec?
In other words, are two processes/threads trying to talk to
In my logs I keep getting error messages like this every few hours. The wait_timout on
mysql is 28800.
DBD::mysql::st execute failed: Lost connection to MySQL server during query
Any ideas are appreciated.
Bryan Tolka
On Tue, 10 Sep 2002 14:25:57 -0700 John Gedeon <[EMAIL PROTECTED]> wrote:
> I am installing a bug reporting tool called Resource Tracker (RT for
> short). I finially got all the modules installed however when I try to
> install this tool it fails when it tries to connect to the oracle
> dat
Hi,
I am installing a bug reporting tool called Resource Tracker (RT for
short). I finially got all the modules installed however when I try to
install this tool it fails when it tries to connect to the oracle database.
I have a short script that can connect to the database but not the big
That's either your network (most likely) or some MySQL config, either way,
this is not the list for that. You'd be better off asking on the mysql
list.
Ilya
-Original Message-
From: Ksenia Prokhorovich
To: [EMAIL PROTECTED]
Sent: 4/15/02 11:51 AM
Subject: Need urgent
ile (my $ref = $sth->fetchrow_hashref())
{
..
}
$sth->finish();
..
>From time to time when I run this script, I get the following error :
DBD::mysql::st execute failed: Lost connection
to do with
that, other than if you want to run queries on the database.
HTH
Ilya Sterin
-Original Message-
From: Peter Gibbons
To: [EMAIL PROTECTED]
Sent: 06/04/2001 9:42 AM
Subject: recovering lost data
hello,
i've deleted data from a table via dbi a few days ago:
is this recov
> i've deleted data from a table via dbi a few days ago:
> is this recoverable via dbi, and if so whatwould the example code be?
Anything's recoverable if you've kept backups. But not through DBI (at least
not once its committed, which, after a few days, I assume it is).
hello,
i've deleted data from a table via dbi a few days ago:
is this recoverable via dbi, and if so whatwould the example code be?
regards
Pete
25 matches
Mail list logo