I've seen this happen in Perl DBI when you destroy your database connection
object prior to running the query. I believe that is the intent of the "Mysql
has gone away" message, it refers to your connection object and not the server
itself.
Brian
David Vergin wrote:
> Running MySQL installed from mysql-3_22_27-pc-linux-gnu-i686_tar.gz
> Linux version is Red Hat 6.0
>
> I have not seen this error before:
> DBD::mysql::st execute failed: MySQL server has gone away at
> /home/bmc/cgi-bin/b
> mctool2.pm line 283.
>
> But the server has not gone away. It is serving up data quite happily except
> for this one routine. The docs state: "You can also get these errors if you
> send a query to the server that is incorrect or too large."
>
> Here's the offending routine:
>
> sub max_child_id {
> my ($self, $node_id) = @_;
> my $dbh = $self->{dbh};
> warn "\nin max_child_id Sdbh [$dbh], Snode_id [$node_id]\n\n";
> my $sql = qq{SELECT MAX(NodeID) FROM Cnodes WHERE ParentID="$node_id"};
> warn "\nSsql [" . $sql . "]\n\n";
> my $sth = $dbh->prepare($sql);
> $sth->execute (); # Line 283
> my ($maxID) = $sth->fetchrow_array ();
> $sth->finish;
> return($maxID);
> }
>
> Here's the log:
>
> <log>
> in max_child_id Sdbh [DBI::db=HASH(0x823d4ac)], Snode_id [19001000]
>
> bmctool::data_buffer::max_child_id('bmctool::data_buffer=HASH(0x826aaf8)
> ', 19001000) called at /home/bmc/cgi-bin/bmc2.pl line 365
>
> Ssql [SELECT MAX(NodeID) FROM Cnodes WHERE ParentID="19001000"]
>
> bmctool::data_buffer::max_child_id('bmctool::data_buffer=HASH(0x826aaf8)
> ', 19001000) called at /home/bmc/cgi-bin/bmc2.pl line 365
> DBD::mysql::st execute failed: MySQL server has gone away at
> /home/bmc/cgi-bin/b
> mctool2.pm line 283.
>
> bmctool::data_buffer::max_child_id('bmctool::data_buffer=HASH(0x826aaf8)
> ', 19001000) called at /home/bmc/cgi-bin/bmc2.pl line 365
> [Sun Jun 11 10:31:04 2000] bmc2.pl: DBD::mysql::st execute failed: MySQL
> server
> has gone away at /home/bmc/cgi-bin/bmctool2.pm line 283.
> </log>
>
> The statement:
>
> SELECT MAX(NodeID) FROM Cnodes WHERE ParentID="19001000"
>
> runs fine if cut from the log and pasted into MySQL Administrator for
> Windows and returns the expected result.
>
> As usual... clues, specific rtfm's, theories, debugging techniques,
> suggested tests; gladly received.
>
> TIA
> david
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread2885@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
