Re: Lost connection to MySQL server during query

[stutiredboy]

the application program and mysql server are in the same host
and i have add skip-name-resolv to the my.cnf and
extend the max_allowed_packet from 16M to 32M

our application connected to mysql server from mysql.sock

before the query which cause "lost connection to MySQLserver.."
we only ran some sql that create table(s)

i have read this article 
http://dev.mysql.com/doc/refman/5.1/en/gone-away.html

and can get rid of the problems this article referred

it seems that our problem is similar to this bug:
http://lists.mysql.com/commits/9447
http://bugs.mysql.com/bug.php?id=15752

but, this bug has been fixed in 5.0.25

are there any suggestions ? or any other informaion (s) should i post here?

thanks!

stutiredboy


Claudio Nanni wrote:

Can you provide more details?
network layout, type of client/app used, connectors,etc,etc?
Thanks

Claudio


2009/9/9 stutiredboy >


hi,all:

we met a problem that:

* Lost connection to MySQL server during query
SHOW TABLE STATUS WHERE ENGINE='MyISAM'

*sometimes it works well, sometimes not

our mysql version is 5.0.84

our system is FreeBSD 6.2

thanks

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:  
 http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com





--
Claudio



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Lost connection to MySQL server during query

[Claudio Nanni]

Since it is very unlikely that you lose connection on the socket file,
I guess you are using a PHP app, that uses the mysql driver and the problem
must be in the driver.
I would not look at mysql but at the PHP and PHP2MYSQL layer, mainly at the
later one.

Try different PHP (and driver) versions.


Claudio


2009/9/9 stutiredboy 

> the application program and mysql server are in the same host
> and i have add skip-name-resolv to the my.cnf and
> extend the max_allowed_packet from 16M to 32M
>
> our application connected to mysql server from mysql.sock
>
> before the query which cause "lost connection to MySQLserver.."
> we only ran some sql that create table(s)
>
> i have read this article
> http://dev.mysql.com/doc/refman/5.1/en/gone-away.html
> and can get rid of the problems this article referred
>
> it seems that our problem is similar to this bug:
> http://lists.mysql.com/commits/9447
> http://bugs.mysql.com/bug.php?id=15752
>
> but, this bug has been fixed in 5.0.25
>
> are there any suggestions ? or any other informaion (s) should i post here?
>
> thanks!
>
> stutiredboy
>
>
> Claudio Nanni wrote:
>
>> Can you provide more details?
>> network layout, type of client/app used, connectors,etc,etc?
>> Thanks
>>
>> Claudio
>>
>>
>> 2009/9/9 stutiredboy mailto:stutired...@gmail.com
>> >>
>>
>>hi,all:
>>
>>we met a problem that:
>>
>>* Lost connection to MySQL server during query
>>SHOW TABLE STATUS WHERE ENGINE='MyISAM'
>>
>>*sometimes it works well, sometimes not
>>
>>our mysql version is 5.0.84
>>
>>our system is FreeBSD 6.2
>>
>>thanks
>>
>>--
>>MySQL General Mailing List
>>For list archives: http://lists.mysql.com/mysql
>>To unsubscribe:
>> http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
>>
>>
>>
>>
>> --
>> Claudio
>>
>
>


-- 
Claudio

Re: Lost connection to MySQL server during query

[Claudio Nanni]

Can you provide more details?
network layout, type of client/app used, connectors,etc,etc?
Thanks

Claudio


2009/9/9 stutiredboy 

> hi,all:
>
> we met a problem that:
>
> * Lost connection to MySQL server during query
> SHOW TABLE STATUS WHERE ENGINE='MyISAM'
>
> *sometimes it works well, sometimes not
>
> our mysql version is 5.0.84
>
> our system is FreeBSD 6.2
>
> thanks
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com
>
>


-- 
Claudio

Re: "lost connection to mysql server during query" errors

[Moon's Father]

In my experiences, there're three reasons below.
1. Your network is not stable.
2. Your mysqld's parameter called max_allowed_packet is adjusted too small,
trying to increase it.
3. Your mysqld's parameter called connect_timeout is  adjusted too small,
trying to increase it.
On Thu, Oct 30, 2008 at 1:05 PM, mos <[EMAIL PROTECTED]> wrote:

> At 10:21 PM 10/29/2008, you wrote:
>
>> I've never had a lot of luck tracking down this sort of problem. One
>> thing I've found to be a good first step is to add each server
>> involved to the other server's /etc/hosts file (and restart MySQL so
>> it notices).
>>
>> Don't have much more to offer other than the usual suspects: recent
>> versions, persistent vs. non-persistent connections, etc. A long shot
>> would be to make sure your always talking to the same database server-
>> if you're doing, say, DNS round-robin or load balancing or something,
>> maybe you're getting shunted to a different db server and it's killing
>> the connection... don't know what your setup is. Another long shot in
>> a multi-db-server config would be to make sure they all have different
>> server ID's.
>>
>> Good luck... hopefully someone else has better advice :)
>>
>> Jake
>>
>
> Just a guess, but maybe it's your network card?
>
> I'm using MySQL 5.01 with MyISAM tables and my application will
> occasionally hang for hours in the midst of executing a simple 1 table
> Select statement. I usually end up killing the program. There are no
> processes running on the MySQL server. I think the problem was the number of
> connections the program created. Although there were only at most 10
> simultaneous connections, my program when the query finished executing, it
> threw the connection away and recreated a new one for each query, and MySQL
> reported there were some 10k connections made to the server. I ended up
> using connection pooling and now the number of connections reaches a high of
> around 10 and I haven't had the problem since.
>
> Mike
>
>  On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
>> > We've started seeing mysql errors in the logs, and when i look at the
>> output
>> > of mysql_error() (in php), i get "lost connection to mysql server during
>> > query". Here's an example stack trace:
>> >
>> > 'Can't connect to  database [Lost connection to MySQL server
>> during
>> > query]'
>> >
>> > Similarly, we're seeing stack traces here as well:
>> >
>> > 'Can't connect to  database []'
>> >
>> > I usually only see this mesasge when I don't use a connection for awhile
>> and
>> > it timeouts, but in this case, the connection is only opened for the
>> > duration of a script, which can't be running for more than a second. The
>> > mysql error logs don't show anything, and wait_timeout is set to 28800.
>> >
>> > At first, I thought it was because I was calling mysql_select_db too
>> much,
>> > so I ended up using two mysql connections per page load, but that didn't
>> > seem to change anything. How can we prevent this error from happening,
>> what
>> > else can I do to diagnose this further?  Google brings up some more
>> > discussions about it, but nothing seems related to this, like
>> packetsize.
>> > This is happening when we select two ids from a database.  And SHOW
>> > PROCESSLIST shows that the number of connections aren't even coming
>> close to
>> > max connections.
>> >
>> > Thanks for any advice,
>> > Waynn
>> >
>>
>> --
>> MySQL General Mailing List
>> For list archives: http://lists.mysql.com/mysql
>> To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
>>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
>
>


-- 
I'm a MySQL DBA in china.
More about me just visit here:
http://yueliangdao0608.cublog.cn

Re: "lost connection to mysql server during query" errors

[mos]

At 10:21 PM 10/29/2008, you wrote:

I've never had a lot of luck tracking down this sort of problem. One
thing I've found to be a good first step is to add each server
involved to the other server's /etc/hosts file (and restart MySQL so
it notices).

Don't have much more to offer other than the usual suspects: recent
versions, persistent vs. non-persistent connections, etc. A long shot
would be to make sure your always talking to the same database server-
if you're doing, say, DNS round-robin or load balancing or something,
maybe you're getting shunted to a different db server and it's killing
the connection... don't know what your setup is. Another long shot in
a multi-db-server config would be to make sure they all have different
server ID's.

Good luck... hopefully someone else has better advice :)

Jake


Just a guess, but maybe it's your network card?

I'm using MySQL 5.01 with MyISAM tables and my application will 
occasionally hang for hours in the midst of executing a simple 1 table 
Select statement. I usually end up killing the program. There are no 
processes running on the MySQL server. I think the problem was the number 
of connections the program created. Although there were only at most 10 
simultaneous connections, my program when the query finished executing, it 
threw the connection away and recreated a new one for each query, and MySQL 
reported there were some 10k connections made to the server. I ended up 
using connection pooling and now the number of connections reaches a high 
of around 10 and I haven't had the problem since.


Mike


On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> We've started seeing mysql errors in the logs, and when i look at the 
output

> of mysql_error() (in php), i get "lost connection to mysql server during
> query". Here's an example stack trace:
>
> 'Can't connect to  database [Lost connection to MySQL server during
> query]'
>
> Similarly, we're seeing stack traces here as well:
>
> 'Can't connect to  database []'
>
> I usually only see this mesasge when I don't use a connection for 
awhile and

> it timeouts, but in this case, the connection is only opened for the
> duration of a script, which can't be running for more than a second. The
> mysql error logs don't show anything, and wait_timeout is set to 28800.
>
> At first, I thought it was because I was calling mysql_select_db too much,
> so I ended up using two mysql connections per page load, but that didn't
> seem to change anything. How can we prevent this error from happening, what
> else can I do to diagnose this further?  Google brings up some more
> discussions about it, but nothing seems related to this, like packetsize.
> This is happening when we select two ids from a database.  And SHOW
> PROCESSLIST shows that the number of connections aren't even coming 
close to

> max connections.
>
> Thanks for any advice,
> Waynn
>

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "lost connection to mysql server during query" errors

[Jake Maul]

I've never had a lot of luck tracking down this sort of problem. One
thing I've found to be a good first step is to add each server
involved to the other server's /etc/hosts file (and restart MySQL so
it notices).

Don't have much more to offer other than the usual suspects: recent
versions, persistent vs. non-persistent connections, etc. A long shot
would be to make sure your always talking to the same database server-
if you're doing, say, DNS round-robin or load balancing or something,
maybe you're getting shunted to a different db server and it's killing
the connection... don't know what your setup is. Another long shot in
a multi-db-server config would be to make sure they all have different
server ID's.

Good luck... hopefully someone else has better advice :)

Jake

On Wed, Oct 29, 2008 at 2:47 AM, Waynn Lue <[EMAIL PROTECTED]> wrote:
> We've started seeing mysql errors in the logs, and when i look at the output
> of mysql_error() (in php), i get "lost connection to mysql server during
> query". Here's an example stack trace:
>
> 'Can't connect to  database [Lost connection to MySQL server during
> query]'
>
> Similarly, we're seeing stack traces here as well:
>
> 'Can't connect to  database []'
>
> I usually only see this mesasge when I don't use a connection for awhile and
> it timeouts, but in this case, the connection is only opened for the
> duration of a script, which can't be running for more than a second. The
> mysql error logs don't show anything, and wait_timeout is set to 28800.
>
> At first, I thought it was because I was calling mysql_select_db too much,
> so I ended up using two mysql connections per page load, but that didn't
> seem to change anything. How can we prevent this error from happening, what
> else can I do to diagnose this further?  Google brings up some more
> discussions about it, but nothing seems related to this, like packetsize.
> This is happening when we select two ids from a database.  And SHOW
> PROCESSLIST shows that the number of connections aren't even coming close to
> max connections.
>
> Thanks for any advice,
> Waynn
>

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query

[sheeri kritzer]

Check out:

http://dev.mysql.com/doc/refman/5.0/en/communication-errors.html

http://dev.mysql.com/doc/refman/5.0/en/gone-away.html

(I've noticed this has come up a lot recently on the list. . .)

-Sheeri

On 1/24/06, Jonathan Mangin <[EMAIL PROTECTED]> wrote:
> I got exactly that error message last night when doing a
> numeric comparison on a varchar column.  Oops.
> Kind of misleading, though.
>
>
> - Original Message -
> From: "David Godsey" <[EMAIL PROTECTED]>
> To: "George Law" <[EMAIL PROTECTED]>
> Cc: 
> Sent: Tuesday, January 24, 2006 4:43 PM
> Subject: RE: Lost connection to MySQL server during query
>
>
> > Thanks for the reply.  I'm not using persistend connections though.  It
> > appears that it looses the connection in the middle of the query or in
> > other words, before the procedure returns.  So that means I not getting
> > the data I need.  So for debug purposes, are you saying to do a "check
> > status" from PHP or in the procedure?  From the procedure it wouldn't do
> > any good right?  From PHP it would be after I didn't get the data, so I
> > would have to reconnect and rerun the query.  That won't really work for
> > me either.
> >
> > David Godsey
> > > David,
> > >
> > > Are you using persistent connections?  Sounds like perhaps a persistent
> > > connection is timing out.
> > >
> > > Maybe a quick work around would be to call a "check status" routine (ie
> > > - do a show status), just to see if the connection is still there.  If
> > > this fails, just do a mysql_connect... Before continuing.
> > >
> > > --
> > > George
> > >
> > >
> > > -Original Message-
> > > From: David Godsey [mailto:[EMAIL PROTECTED]
> > > Sent: Tuesday, January 24, 2006 4:09 PM
> > > To: mysql@lists.mysql.com
> > > Subject: Lost connection to MySQL server during query
> > >
> > > I am getting this error when connecting to mysql with PHP:
> > > Lost connection to MySQL server during query
> > >
> > > This happens only when I use this procedure, but it doesn't necessarily
> > > fail when this procedure is called.  The error will happen frequently,
> > > however it is not consistent.  This is my first procedure I've written,
> > > so I'm sure I've done something wrong here.  I assume the error message
> > > means I'm hitting some kind of timeout?
> > >
> > > Any ideas would be welcome.  Thanks.
> > >
> > > create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE)
> > > BEGIN
> > > DECLARE mfid INT UNSIGNED;
> > > DECLARE pid INT UNSIGNED;
> > > DECLARE foffset INT UNSIGNED;
> > > DECLARE flength INT UNSIGNED;
> > > DECLARE vid INT UNSIGNED;
> > > DECLARE rfid INT UNSIGNED;
> > > DECLARE tpid INT UNSIGNED;
> > > DECLARE fdata BLOB;
> > > DECLARE fdata_tmp BLOB;
> > > DECLARE fdata_bigint BIGINT UNSIGNED;
> > > DECLARE fdata_signed INT;
> > > DECLARE fdata_unsigned INT UNSIGNED;
> > > DECLARE fdata_float DOUBLE;
> > > DECLARE data_type VARCHAR(20);
> > > DECLARE byte_order VARCHAR(20);
> > > DECLARE conv_param VARCHAR(255);
> > >
> > > SELECT major_frame_desc_id, parent_id, frame_offset,
> > > frame_length, version_id, top_level_parent_id
> > > FROM MajorFrameDescription
> > > WHERE name=n
> > > INTO mfid,pid,foffset,flength,vid,tpid;
> > >
> > > SELECT attribute_value FROM MajorFrameAttributes
> > > WHERE major_frame_desc_id=mfid AND
> > > attribute_name="NormalizedType"
> > > INTO data_type;
> > >
> > > SELECT attribute_value FROM MajorFrameAttributes
> > > WHERE major_frame_desc_id=mfid AND
> > > attribute_name="ConvParams"
> > > INTO conv_param;
> > >
> > > SELECT attribute_value FROM MajorFrameAttributes
> > > WHERE major_frame_desc_id=mfid AND
> > > attribute_name="ByteO

Re: Lost connection to MySQL server during query

[Jonathan Mangin]

I got exactly that error message last night when doing a
numeric comparison on a varchar column.  Oops.
Kind of misleading, though.


- Original Message - 
From: "David Godsey" <[EMAIL PROTECTED]>
To: "George Law" <[EMAIL PROTECTED]>
Cc: 
Sent: Tuesday, January 24, 2006 4:43 PM
Subject: RE: Lost connection to MySQL server during query


> Thanks for the reply.  I'm not using persistend connections though.  It
> appears that it looses the connection in the middle of the query or in
> other words, before the procedure returns.  So that means I not getting
> the data I need.  So for debug purposes, are you saying to do a "check
> status" from PHP or in the procedure?  From the procedure it wouldn't do
> any good right?  From PHP it would be after I didn't get the data, so I
> would have to reconnect and rerun the query.  That won't really work for
> me either.
>
> David Godsey
> > David,
> >
> > Are you using persistent connections?  Sounds like perhaps a persistent
> > connection is timing out.
> >
> > Maybe a quick work around would be to call a "check status" routine (ie
> > - do a show status), just to see if the connection is still there.  If
> > this fails, just do a mysql_connect... Before continuing.
> >
> > --
> > George
> >
> >
> > -Original Message-
> > From: David Godsey [mailto:[EMAIL PROTECTED]
> > Sent: Tuesday, January 24, 2006 4:09 PM
> > To: mysql@lists.mysql.com
> > Subject: Lost connection to MySQL server during query
> >
> > I am getting this error when connecting to mysql with PHP:
> > Lost connection to MySQL server during query
> >
> > This happens only when I use this procedure, but it doesn't necessarily
> > fail when this procedure is called.  The error will happen frequently,
> > however it is not consistent.  This is my first procedure I've written,
> > so I'm sure I've done something wrong here.  I assume the error message
> > means I'm hitting some kind of timeout?
> >
> > Any ideas would be welcome.  Thanks.
> >
> > create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE)
> > BEGIN
> > DECLARE mfid INT UNSIGNED;
> > DECLARE pid INT UNSIGNED;
> > DECLARE foffset INT UNSIGNED;
> > DECLARE flength INT UNSIGNED;
> > DECLARE vid INT UNSIGNED;
> > DECLARE rfid INT UNSIGNED;
> > DECLARE tpid INT UNSIGNED;
> > DECLARE fdata BLOB;
> > DECLARE fdata_tmp BLOB;
> > DECLARE fdata_bigint BIGINT UNSIGNED;
> > DECLARE fdata_signed INT;
> > DECLARE fdata_unsigned INT UNSIGNED;
> > DECLARE fdata_float DOUBLE;
> > DECLARE data_type VARCHAR(20);
> > DECLARE byte_order VARCHAR(20);
> > DECLARE conv_param VARCHAR(255);
> >
> > SELECT major_frame_desc_id, parent_id, frame_offset,
> > frame_length, version_id, top_level_parent_id
> > FROM MajorFrameDescription
> > WHERE name=n
> > INTO mfid,pid,foffset,flength,vid,tpid;
> >
> > SELECT attribute_value FROM MajorFrameAttributes
> > WHERE major_frame_desc_id=mfid AND
> > attribute_name="NormalizedType"
> > INTO data_type;
> >
> > SELECT attribute_value FROM MajorFrameAttributes
> > WHERE major_frame_desc_id=mfid AND
> > attribute_name="ConvParams"
> > INTO conv_param;
> >
> > SELECT attribute_value FROM MajorFrameAttributes
> > WHERE major_frame_desc_id=mfid AND
> > attribute_name="ByteOrder"
> > INTO byte_order;
> >
> > SELECT MAX(raw_major_frame_id)
> > FROM RawMajorFrames
> > WHERE major_frame_desc_id=tpid
> > INTO rfid;
> >
> > IF rfid >0 THEN
> >
> > SELECT payload_time,
> > SUBSTR(BINARY(frame_data),
> > FLOOR(foffset/8)+1,
> > CEIL((flength + (foffset %8 ))/8))
> > FROM RawMajorFrames
> > WHERE raw_major_frame_id=rfid
> > INTO ptime,fdata;
> >
&

RE: Lost connection to MySQL server during query

[David Godsey]

Thanks for the reply.  I'm not using persistend connections though.  It
appears that it looses the connection in the middle of the query or in
other words, before the procedure returns.  So that means I not getting
the data I need.  So for debug purposes, are you saying to do a "check
status" from PHP or in the procedure?  From the procedure it wouldn't do
any good right?  From PHP it would be after I didn't get the data, so I
would have to reconnect and rerun the query.  That won't really work for
me either.

David Godsey
> David,
>
> Are you using persistent connections?  Sounds like perhaps a persistent
> connection is timing out.
>
> Maybe a quick work around would be to call a "check status" routine (ie
> - do a show status), just to see if the connection is still there.  If
> this fails, just do a mysql_connect... Before continuing.
>
> --
> George
>
>
> -Original Message-
> From: David Godsey [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, January 24, 2006 4:09 PM
> To: mysql@lists.mysql.com
> Subject: Lost connection to MySQL server during query
>
> I am getting this error when connecting to mysql with PHP:
> Lost connection to MySQL server during query
>
> This happens only when I use this procedure, but it doesn't necessarily
> fail when this procedure is called.  The error will happen frequently,
> however it is not consistent.  This is my first procedure I've written,
> so I'm sure I've done something wrong here.  I assume the error message
> means I'm hitting some kind of timeout?
>
> Any ideas would be welcome.  Thanks.
>
> create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE)
> BEGIN
> DECLARE mfid INT UNSIGNED;
> DECLARE pid INT UNSIGNED;
> DECLARE foffset INT UNSIGNED;
> DECLARE flength INT UNSIGNED;
> DECLARE vid INT UNSIGNED;
> DECLARE rfid INT UNSIGNED;
> DECLARE tpid INT UNSIGNED;
> DECLARE fdata BLOB;
> DECLARE fdata_tmp BLOB;
> DECLARE fdata_bigint BIGINT UNSIGNED;
> DECLARE fdata_signed INT;
> DECLARE fdata_unsigned INT UNSIGNED;
> DECLARE fdata_float DOUBLE;
> DECLARE data_type VARCHAR(20);
> DECLARE byte_order VARCHAR(20);
> DECLARE conv_param VARCHAR(255);
>
> SELECT major_frame_desc_id, parent_id, frame_offset,
> frame_length, version_id, top_level_parent_id
> FROM MajorFrameDescription
> WHERE name=n
> INTO mfid,pid,foffset,flength,vid,tpid;
>
> SELECT attribute_value FROM MajorFrameAttributes
> WHERE major_frame_desc_id=mfid AND
> attribute_name="NormalizedType"
> INTO data_type;
>
> SELECT attribute_value FROM MajorFrameAttributes
> WHERE major_frame_desc_id=mfid AND
> attribute_name="ConvParams"
> INTO conv_param;
>
> SELECT attribute_value FROM MajorFrameAttributes
> WHERE major_frame_desc_id=mfid AND
> attribute_name="ByteOrder"
> INTO byte_order;
>
> SELECT MAX(raw_major_frame_id)
> FROM RawMajorFrames
> WHERE major_frame_desc_id=tpid
> INTO rfid;
>
> IF rfid >0 THEN
>
> SELECT payload_time,
> SUBSTR(BINARY(frame_data),
> FLOOR(foffset/8)+1,
> CEIL((flength + (foffset %8 ))/8))
> FROM RawMajorFrames
> WHERE raw_major_frame_id=rfid
> INTO ptime,fdata;
>
> call toBigInt(fdata,fdata_bigint);
> IF (foffset %8) >0 THEN
>SET @mask_off=foffset%8;
> call
> mask_data(fdata,@mask_off,fdata_bigint);
> END IF;
> IF (8-((flength+(foffset%8)) %8)) > 0 THEN
> SELECT (fdata_bigint >>
> (8-((flength+(foffset%8)) %8)))
> INTO
> fdata_bigint;
> END IF;
> CASE data_type
> WHEN "Float"
> THEN
> call
> toFloat(fdata_bigint,fdata_float);
> IF(!ISNULL(conv_param))
> THEN
> call
> polyConv(fdata_float,conv_param,fdata_float);
> END IF;
> SET
> @fdata_converted=fdata_float;
>
> WHEN "Double"
> THEN
> call
> 

RE: Lost connection to MySQL server during query

[George Law]

David,

Are you using persistent connections?  Sounds like perhaps a persistent
connection is timing out.  

Maybe a quick work around would be to call a "check status" routine (ie
- do a show status), just to see if the connection is still there.  If
this fails, just do a mysql_connect... Before continuing.

--
George


-Original Message-
From: David Godsey [mailto:[EMAIL PROTECTED] 
Sent: Tuesday, January 24, 2006 4:09 PM
To: mysql@lists.mysql.com
Subject: Lost connection to MySQL server during query

I am getting this error when connecting to mysql with PHP:
Lost connection to MySQL server during query

This happens only when I use this procedure, but it doesn't necessarily
fail when this procedure is called.  The error will happen frequently,
however it is not consistent.  This is my first procedure I've written,
so I'm sure I've done something wrong here.  I assume the error message
means I'm hitting some kind of timeout?

Any ideas would be welcome.  Thanks.

create procedure getElement (IN n VARCHAR(255),IN ptime DOUBLE)
BEGIN
DECLARE mfid INT UNSIGNED;
DECLARE pid INT UNSIGNED;
DECLARE foffset INT UNSIGNED;
DECLARE flength INT UNSIGNED;
DECLARE vid INT UNSIGNED;
DECLARE rfid INT UNSIGNED;
DECLARE tpid INT UNSIGNED;
DECLARE fdata BLOB;
DECLARE fdata_tmp BLOB;
DECLARE fdata_bigint BIGINT UNSIGNED;
DECLARE fdata_signed INT;
DECLARE fdata_unsigned INT UNSIGNED;
DECLARE fdata_float DOUBLE;
DECLARE data_type VARCHAR(20);
DECLARE byte_order VARCHAR(20);
DECLARE conv_param VARCHAR(255);

SELECT major_frame_desc_id, parent_id, frame_offset,
frame_length, version_id, top_level_parent_id
FROM MajorFrameDescription
WHERE name=n
INTO mfid,pid,foffset,flength,vid,tpid;

SELECT attribute_value FROM MajorFrameAttributes
WHERE major_frame_desc_id=mfid AND
attribute_name="NormalizedType"
INTO data_type;

SELECT attribute_value FROM MajorFrameAttributes
WHERE major_frame_desc_id=mfid AND
attribute_name="ConvParams"
INTO conv_param;

SELECT attribute_value FROM MajorFrameAttributes
WHERE major_frame_desc_id=mfid AND
attribute_name="ByteOrder"
INTO byte_order;

SELECT MAX(raw_major_frame_id)
FROM RawMajorFrames
WHERE major_frame_desc_id=tpid
INTO rfid;

IF rfid >0 THEN

SELECT payload_time,
SUBSTR(BINARY(frame_data),
FLOOR(foffset/8)+1,
CEIL((flength + (foffset %8 ))/8))
FROM RawMajorFrames
WHERE raw_major_frame_id=rfid
INTO ptime,fdata;

call toBigInt(fdata,fdata_bigint);
IF (foffset %8) >0 THEN
   SET @mask_off=foffset%8;
call
mask_data(fdata,@mask_off,fdata_bigint);
END IF;
IF (8-((flength+(foffset%8)) %8)) > 0 THEN
SELECT (fdata_bigint >>
(8-((flength+(foffset%8)) %8)))
INTO
fdata_bigint;
END IF;
CASE data_type
WHEN "Float"
THEN
call
toFloat(fdata_bigint,fdata_float);
IF(!ISNULL(conv_param))
THEN
call
polyConv(fdata_float,conv_param,fdata_float);
END IF;
SET
@fdata_converted=fdata_float;

WHEN "Double"
THEN
call
toFloat(fdata_bigint,fdata_float);
IF(!ISNULL(conv_param))
THEN
call
polyConv(fdata_float,conv_param,fdata_float);
END IF;
SET
@fdata_converted=fdata_float;

WHEN "Signed"
THEN
call
toSigned(fdata_bigint,fdata_signed);
SET
@fdata_converted=fdata_signed;
WHEN "Unsigned"
THEN
 

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Lenz Grimmer]

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

Hi,

On Fri, 23 Sep 2005, Jasper Bryant-Greene wrote:

> Thing is, even though I get that error, the server keeps running and
> accepting other connections and responding to queries fine.

Probably because the mysqld_safe wrapper script has restarted it right
after the crash. Take a look at the server's log files.

> My server log shows absolutely nothing after server startup, no matter how
> many times that stored procedure fails.
> 
> I'm about to recompile with the debug USE flag (I'm on Gentoo) to try to track
> down the problem; once I've done that I'll file a bug.

Before you file a bug, please re-test it with 5.0.13 - several SP-releated bugs
have been fixed since 5.0.12 was released.

If it's still repeatable in 5.0.13, please file a bug report at 
http://bugs.mysql.com.

Thanks!

Bye,
LenZ
- -- 
 Lenz Grimmer <[EMAIL PROTECTED]>
 Senior Production Engineer
 MySQL GmbH, http://www.mysql.de/
 Hamburg, Germany
 Are you MySQL certified?  http://www.mysql.com/certification/
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.2 (GNU/Linux)
Comment: For info see http://quantumlab.net/pine_privacy_guard/

iD8DBQFDOOvWSVDhKrJykfIRAh8uAJ4n1NLXykT3Ob65mTK/VT239cQTpACfZaW8
bym5rslnYYYrOeJTZOXvnjw=
=0fJP
-END PGP SIGNATURE-

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Greg 'groggy' Lehey]

On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:
> Jasper Bryant-Greene wrote:
>> I have a stored procedure defined as follows:
>>
>> ...
>>
>> Sometimes when I execute this stored procedure ...  I get the error
>> "Lost connection to MySQL server during query".
>>
>> I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.
>
> This only seems to happen when accessing MySQL from PHP's MySQLi API,
> not when accessing it using the mysql command-line client.
>
> Is this a bug I should report to MySQL or to PHP? I'm not able to test
> other APIs at the moment.

If the server dies, that's a MySQL problem.  Take a look at
http://bugs.mysql.com/ for information on how to report it.  In
particular, the server logs should give some information.

Greg
--
Greg Lehey, Senior Software Engineer
MySQL AB, http://www.mysql.com/
Echunga, South Australia
See complete headers for address and phone numbers.

Are you MySQL certified?  http://www.mysql.com/certification/


pgpjYgw1PlK8L.pgp
Description: PGP signature

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Jasper Bryant-Greene]

Greg 'groggy' Lehey wrote:

On Thursday, 22 September 2005 at 17:06:32 +1200, Jasper Bryant-Greene wrote:


Jasper Bryant-Greene wrote:


Sometimes when I execute this stored procedure ...  I get the error
"Lost connection to MySQL server during query".

I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.


This only seems to happen when accessing MySQL from PHP's MySQLi API,
not when accessing it using the mysql command-line client.

Is this a bug I should report to MySQL or to PHP? I'm not able to test
other APIs at the moment.



If the server dies, that's a MySQL problem.  Take a look at
http://bugs.mysql.com/ for information on how to report it.  In
particular, the server logs should give some information.


Thing is, even though I get that error, the server keeps running and 
accepting other connections and responding to queries fine.


My server log shows absolutely nothing after server startup, no matter 
how many times that stored procedure fails.


I'm about to recompile with the debug USE flag (I'm on Gentoo) to try to 
track down the problem; once I've done that I'll file a bug.


--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Jasper Bryant-Greene]

Jasper Bryant-Greene wrote:

I have a stored procedure defined as follows:

CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;

Sometimes when I execute this stored procedure with, for example:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal 
kind of query.


I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.



This only seems to happen when accessing MySQL from PHP's MySQLi API, 
not when accessing it using the mysql command-line client.


Is this a bug I should report to MySQL or to PHP? I'm not able to test 
other APIs at the moment.


--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Jasper Bryant-Greene]

Daniel wrote:
What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, 
etc.?


PHP MySQLi



Jasper Bryant-Greene wrote:


I have a stored procedure defined as follows:

CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;

Sometimes when I execute this stored procedure with, for example:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal 
kind of query.


I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.



--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Daniel]

What API are you using to call the SP from--PHP mysqli, Perl DBD-mysql, 
etc.?


-Daniel

Jasper Bryant-Greene wrote:


I have a stored procedure defined as follows:

CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;

Sometimes when I execute this stored procedure with, for example:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal 
kind of query.


I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Pooly]

Hi,


2005/9/21, Jasper Bryant-Greene <[EMAIL PROTECTED]>:
> Martijn Tonies wrote:
> >
> >>I have a stored procedure defined as follows:
> >>
> >>CREATE PROCEDURE `album`.`getUser`( IN userID INT )
> >> READS SQL DATA
> >> DETERMINISTIC
> >> SQL SECURITY INVOKER
> >>SELECT * FROM users WHERE id=userID LIMIT 1;
> >>
> >>Sometimes when I execute this stored procedure with, for example:
> >>
> >>CALL getUser(7);
> >>
> >>I get the error "Lost connection to MySQL server during query".
> >>
> >>This only ever happens with stored procedures, never with any normal
> >>kind of query.
> >>
> >>I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.
> >
> >
> > And what is your question?
> 
> Fairly obviously, how do I fix it!? ;)
> 
> > Most probably, a server crash...
> 
> Can you be a little bit more specific please? The MySQL server is
> working absolutely fine for everything else and also continues to
> respond to connections and queries perfectly after getting that error.
> 

I think he means, that you should try the official binaries, and this
still happens, file a bug report because 5.0 is still in Beta stage.

-- 
Pooly
Webzine Rock : http://www.w-fenec.org/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Jasper Bryant-Greene]

Martijn Tonies wrote:



I have a stored procedure defined as follows:

CREATE PROCEDURE `album`.`getUser`( IN userID INT )
READS SQL DATA
DETERMINISTIC
SQL SECURITY INVOKER
SELECT * FROM users WHERE id=userID LIMIT 1;

Sometimes when I execute this stored procedure with, for example:

CALL getUser(7);

I get the error "Lost connection to MySQL server during query".

This only ever happens with stored procedures, never with any normal
kind of query.

I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.



And what is your question?


Fairly obviously, how do I fix it!? ;)


Most probably, a server crash...


Can you be a little bit more specific please? The MySQL server is 
working absolutely fine for everything else and also continues to 
respond to connections and queries perfectly after getting that error.


Thanks

--
Jasper Bryant-Greene
Freelance web developer
http://jasper.bryant-greene.name/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: "Lost connection to MySQL server during query" when calling stored procedure

[Martijn Tonies]

> I have a stored procedure defined as follows:
>
> CREATE PROCEDURE `album`.`getUser`( IN userID INT )
>  READS SQL DATA
>  DETERMINISTIC
>  SQL SECURITY INVOKER
> SELECT * FROM users WHERE id=userID LIMIT 1;
>
> Sometimes when I execute this stored procedure with, for example:
>
> CALL getUser(7);
>
> I get the error "Lost connection to MySQL server during query".
>
> This only ever happens with stored procedures, never with any normal
> kind of query.
>
> I am using MySQL 5.0.12-beta-log on Gentoo Linux x86.

And what is your question?


;-)

Most probably, a server crash...

With regards,

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, Oracle & MS SQL
Server
Upscene Productions
http://www.upscene.com
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query - on long queries

[Dobromir Velev]

Hi,
Can you send some more output from the MySQL error log (normally located 
at /var/lib/mysq/[hostname].err) . Have you tried myisamchk to check the 
tables that are giving the errors? Also you might want to take a look at 
http://dev.mysql.com/doc/mysql/en/gone-away.html

On Wednesday 01 June 2005 12:04, Amir Shay wrote:
> Hello,
>
> Each time we run long queries (over around 5 seconds) the mySQL server
> fails and restarts (you can see it in the error log that starts with
> "Database page corruption on disk or a fail.." and then there is a
> dump...) and the query return with "Lost connection to MySQL server
> during query..."
>
> Using Linux 9 with mySQL 4.1.11-standard the tables are InnoDB
>
> The error is happening from everywhere: mysql command line, Query
> browser, from local and remote computers, running selects, insert and
> even check table, EMS client . Java (see below the log)
>
> The problem is probably not in the network parameters, see list of the
> variables below
>
> The database is quit big around 5 GB
>
> After the error the server restart automatically and continue to run for
> the short queries
>
> We found one place where long queries work - when we run from the query
> browser the same "select * from . However running
> from the same place "check table..." reproduce the error !. Again
> running the same "select * from " from all the other
> palaces cause the server to fall
>
>
> Amir
>
>
> Server parameters
>
> 'back_log', '50'
> 'basedir', '/'
> 'binlog_cache_size', '32768'
> 'bulk_insert_buffer_size', '8388608'
> 'character_set_client', 'utf8'
> 'character_set_connection', 'utf8'
> 'character_set_database', 'hebrew'
> 'character_set_results', 'utf8'
> 'character_set_server', 'hebrew'
> 'character_set_system', 'utf8'
> 'character_sets_dir', '/usr/share/mysql/charsets/'
> 'collation_connection', 'utf8_general_ci'
> 'collation_database', 'hebrew_general_ci'
> 'collation_server', 'hebrew_general_ci'
> 'concurrent_insert', 'ON'
> 'connect_timeout', '100'
> 'datadir', '/var/lib/mysql/'
> 'date_format', '%Y-%m-%d'
> 'datetime_format', '%Y-%m-%d %H:%i:%s'
> 'default_week_format', '0'
> 'delay_key_write', 'ON'
> 'delayed_insert_limit', '100'
> 'delayed_insert_timeout', '300'
> 'delayed_queue_size', '1000'
> 'expire_logs_days', '0'
> 'flush', 'OFF'
> 'flush_time', '0'
> 'ft_boolean_syntax', '+ -><()~*:""&|'
> 'ft_max_word_len', '84'
> 'ft_min_word_len', '4'
> 'ft_query_expansion_limit', '20'
> 'ft_stopword_file', '(built-in)'
> 'group_concat_max_len', '1024'
> 'have_archive', 'NO'
> 'have_bdb', 'NO'
> 'have_blackhole_engine', 'NO'
> 'have_compress', 'YES'
> 'have_crypt', 'YES'
> 'have_csv', 'NO'
> 'have_example_engine', 'NO'
> 'have_geometry', 'YES'
> 'have_innodb', 'YES'
> 'have_isam', 'NO'
> 'have_ndbcluster', 'NO'
> 'have_openssl', 'NO'
> 'have_query_cache', 'YES'
> 'have_raid', 'NO'
> 'have_rtree_keys', 'YES'
> 'have_symlink', 'YES'
> 'init_connect', ''
> 'init_file', ''
> 'init_slave', ''
> 'innodb_additional_mem_pool_size', '14680064'
> 'innodb_autoextend_increment', '8'
> 'innodb_buffer_pool_awe_mem_mb', '0'
> 'innodb_buffer_pool_size', '1073741824'
> 'innodb_data_file_path', 'ibdata1:10M:autoextend'
> 'innodb_data_home_dir', '/var/lib/mysql'
> 'innodb_fast_shutdown', 'ON'
> 'innodb_file_io_threads', '4'
> 'innodb_file_per_table', 'OFF'
> 'innodb_flush_log_at_trx_commit', '1'
> 'innodb_flush_method', ''
> 'innodb_force_recovery', '0'
> 'innodb_lock_wait_timeout', '50'
> 'innodb_locks_unsafe_for_binlog', 'OFF'
> 'innodb_log_arch_dir', ''
> 'innodb_log_archive', 'OFF'
> 'innodb_log_buffer_size', '1048576'
> 'innodb_log_file_size', '5242880'
> 'innodb_log_files_in_group', '2'
> 'innodb_log_group_home_dir', './'
> 'innodb_max_dirty_pages_pct', '90'
> 'innodb_max_purge_lag', '0'
> 'innodb_mirrored_log_groups', '1'
> 'innodb_open_files', '300'
> 'innodb_table_locks', 'ON'
> 'innodb_thread_concurrency', '8'
> 'interactive_timeout', '100'
> 'join_buffer_size', '131072'
> 'key_buffer_size', '8388600'
> 'key_cache_age_threshold', '300'
> 'key_cache_block_size', '1024'
> 'key_cache_division_limit', '100'
> 'language', '/usr/share/mysql/english/'
> 'large_files_support', 'ON'
> 'license', 'GPL'
> 'local_infile', 'ON'
> 'locked_in_memory', 'OFF'
>
> 'long_query_time', '10'
> 'low_priority_updates', 'OFF'
> 'lower_case_file_system', 'OFF'
> 'lower_case_table_names', '1'
> 'max_allowed_packet', '1047552'
> 'max_binlog_cache_size', '4294967295'
> 'max_binlog_size', '1073741824'
> 'max_connect_errors', '10'
> 'max_connections', '100'
> 'max_delayed_threads', '20'
> 'max_error_count', '64'
> 'max_heap_table_size', '16777216'
> 'max_insert_delayed_threads', '20'
> 'max_join_size', '4294967295'
> 'max_length_for_sort_data', '1024'
> 'max_relay_log_size', '0'
> 'max_seeks_for_key', '4294967295'
> 'max_sort_length', '1024'
> 'max_tmp_tables', '32'
> 'max_user_connections', '0'
> 'max_write_lock_count', '4294967295'
>
> 'net_buffer_length', '16384'
> 'net_read_timeout', '30'
> 'net_retry

Re: Lost connection to MySQL server during query problem

[Gleb Paharenko]

Hello.



You should solve the issue with server crashes. I'm not familiar with JDBC,

and if changing the values of parameters with SET statement doesn't work

with JDBC, probably somebody clever on the list could help you. You may

forward your message to:



  http://lists.mysql.com/java









>Yes the server dies during the queries from JDBC.

> 

>   Regarding the client parameters, what if the client doesn't have mySQL

>   installed?

>

>Amir







  

"Amir Shay" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query problem

[Amir Shay]

 
Hi,
 
Yes the server dies during the queries from JDBC.
 
Regarding the client parameters, what if the client doesn't have mySQL
installed?
 
Amir
 
 
Hello.
 
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from JDBC (check
the error log)?
Sometimes you should increase interactive_timeout as well. A lot of
variables usually
could be changed using SET statement. See:
  http://dev.mysql.com/doc/mysql/en/system-variables.html
 
 
>Sometimes when querying mySQL 4.1.11 on Linux machine I get the error
>"Lost connection to MySQL server during query". Here are the symptoms
> 
> 
> 
> 1.When running the query from the server it returns OK
> 2.When running the query from another machine using the mySQL
> query browser it returns OK
> 3.When running the query from another machine from Java using
> mySQL JDBC it fails with " Lost connection to..."
> 4.When running the query from another machine using software like
> EMS it fails with " Lost connection to..."
> 5.The error is always after 4.7 seconds and only in "heavy"
> queries (not only SELECT, even DELETES )
> 
> The problem is probably not in the communication parameters, like
> max_allowed_packet or connection_timeout on the server because I
> increased then 
> 
> 
>   Does anyone know how can I control those parameters from JDBC?
> 
 
 
"Amir Shay" <[EMAIL PROTECTED]> wrote:
 
 
-- 
For technical support contracts, goto
https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com

 

Re: Lost connection to MySQL server during query problem

[Gleb Paharenko]

Hello.



Does SHOW STATUS executed from JDBC client return increased values of

this parameters? Could your server die during queries from JDBC (check the 
error log)? Sometimes you should increase interactive_timeout as well. A lot of 
variables usually could be changed using SET statement. See:

  http://dev.mysql.com/doc/mysql/en/system-variables.html





>Sometimes when querying mySQL 4.1.11 on Linux machine I get the error

>"Lost connection to MySQL server during query". Here are the symptoms

>

> 

>

> 1.When running the query from the server it returns OK

> 2.When running the query from another machine using the mySQL

> query browser it returns OK

> 3.When running the query from another machine from Java using

> mySQL JDBC it fails with " Lost connection to..."

> 4.When running the query from another machine using software like

> EMS it fails with " Lost connection to..."

> 5.The error is always after 4.7 seconds and only in "heavy"

> queries (not only SELECT, even DELETES )

>

> The problem is probably not in the communication parameters, like

> max_allowed_packet or connection_timeout on the server because I

> increased then 

>

>

>   Does anyone know how can I control those parameters from JDBC?

>





"Amir Shay" <[EMAIL PROTECTED]> wrote:



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to Mysql server during query using a group by clause and sub query

[Ware Adams]

On May 19, 2005, at 12:51 AM, Dan Rossi wrote:
Hi there, I am having issues with this funny error message. I am  
trying to do a sub query and then a group by clause on a date.  
However i keep getting this annoying message for some reason.  
Happens via terminal aswell as my sql gui.  Here is the query I am  
trying to do

select (select count(discrepancy_originID) FROM report_log WHERE  
discrepancy_originID=1) as total FROM report_log GROUP BY MONTH  
(tx_date)

let me know, if i take the sub query out its ok ?
Is your server crashing during the query?  Check the .err file which  
should be in the data directory for restarts.

--Ware
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query & bind-address

[Egor Egorov]

Marten Lehmann <[EMAIL PROTECTED]> wrote:

> Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).

OKay, here's the problem - a self-built MySQL. Unfortunately, due to 
some glibc bugs it's not really possible to build a stable MySQL 
under linux using stock glibc...

And the problems are like the one you are experiencing. 

I'd suggest you to download and install MySQL binary RPMs from www.mysql.com.

I'm sure, the problem will disappear. 





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query & bind-address

[Marten Lehmann]

Hello,
Tell us the OS, the MySQL server and client version and the build information
(custom or binary downloaded from MySQL.com).
Redhat Enterprise Linux 3, self-build mysql 4.0.20 (server and client).
This *might* be a problem of resolver in glibc.
I don't see a reason why it should be a resolver problem? The error 
messages says "lost connection _during_ query", this means that the 
connection is already established, so obviously the resolver already did 
it's job to find out the ip-address of the mysql-server. And anyway: I 
used bind-address before and it worked. I just don't understand why it 
doesn't work again now. Mysql itself is starting correctly and the 
server log doesn't show anything. But the clients are losing the connection.

Regards
Marten
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query & bind-address

[Egor Egorov]

Marten Lehmann <[EMAIL PROTECTED]> wrote:

> I'm experiencing a strange thing: When bind is running without 
> "bind-address" everything works fine. But when I'm doing a "bind-address 
> = ..." the clients get "Lost connection to MySQL server during query". I 
> don't understand this, because ot worked once before and the ip-address 
> the clients are connection to is the same as the one mentioned at 
> "bind-address=...". Do you have any ideas for that?

Tell us the OS, the MySQL server and client version and the build information
(custom or binary downloaded from MySQL.com).

This *might* be a problem of resolver in glibc.





-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query - pls help

[Matt W]

Hi Vanessa,

I don't think I saw a reply to this...

You can just reconnect to MySQL if you get this error. :-) Trying to
send the query a second or third time may also make the client try to
reconnect again.


Hope that helps.


Matt


- Original Message -
From: "Kiky"
Sent: Friday, December 05, 2003 12:14 AM
Subject: Lost connection to MySQL server during query - pls help


Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"

I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win
XP Pro.
They turn out to have the same error.

My problem is:
I have a Java program which is actually a thread to send emails, so it
keeps running all the time.
When it's time to send emails, it will access MySQL database.
Based on my wait_timeout in mysql, I think the connection closes after 8
hrs.
If it's the time to send emails, and mysql has already closed the
connection, the first connection attemp will throw an error
"Error 2013 - Lost connection to MySQL server during query"

* Is there a way that I can avoid this error? Or to make the connection
keeps open all the the time?

Any help / suggestions will be very much appreciated :)

Thank you in advance.

Rgds,
Vanessa


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query - pls help

[Kiky]

Thank you so much guys, for your attention and help.
I'm upgrading my MySQL to 4.0.16 as suggested.

Rgds,
Vanessa

- Original Message -
From: "Paul DuBois" <[EMAIL PROTECTED]>
To: "Jay Blanchard" <[EMAIL PROTECTED]>; "miguel
solorzano" <[EMAIL PROTECTED]>; "Kiky" <[EMAIL PROTECTED]>;
<[EMAIL PROTECTED]>
Sent: Saturday, December 06, 2003 12:56 AM
Subject: RE: Lost connection to MySQL server during query - pls help


> At 10:44 -0600 12/5/03, Jay Blanchard wrote:
> >[snip]
> >Please upgrade you MySQL Windows client to 4.0.16 there is a bug
> >with net_read_timeout and net_write_timeout on 4.0.15 that
> >disconnect when the query takes more than 30 secons.
> >[/snip]
> >
> >Can you elaborate on this, we have not seen this problem
>
> See the "Bugs fixed" section of:
>
> http://www.mysql.com/doc/en/News-4.0.16.html
>
> --
> Paul DuBois, Senior Technical Writer
> Madison, Wisconsin, USA
> MySQL AB, www.mysql.com
>
> Are you MySQL certified?  http://www.mysql.com/certification/
>
>


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Lost connection to MySQL server during query - pls help

[Paul DuBois]

At 10:44 -0600 12/5/03, Jay Blanchard wrote:
[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]
Can you elaborate on this, we have not seen this problem
See the "Bugs fixed" section of:

http://www.mysql.com/doc/en/News-4.0.16.html

--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified?  http://www.mysql.com/certification/

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query - pls help

[Egor Egorov]

"Kiky" <[EMAIL PROTECTED]> wrote:
> I have a problem with 
> "Error 2013 - Lost connection to MySQL server during query"
> 
> I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win XP Pro.
> They turn out to have the same error.
> 
> My problem is:
> I have a Java program which is actually a thread to send emails, so it keeps running 
> all the time.
> When it's time to send emails, it will access MySQL database.
> Based on my wait_timeout in mysql, I think the connection closes after 8 hrs.
> If it's the time to send emails, and mysql has already closed the connection, the 
> first connection attemp will throw an error
> "Error 2013 - Lost connection to MySQL server during query"
> 
> * Is there a way that I can avoid this error? Or to make the connection keeps open 
> all the the time?
> 

You can increase value of wait_timeout variable.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Lost connection to MySQL server during query - pls help

[Jay Blanchard]

[snip]
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
[/snip]

Can you elaborate on this, we have not seen this problem

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query - pls help

[miguel solorzano]

At 14:14 5/12/2003 +0800, Kiky wrote:

Hi Guys,
I have a problem with
"Error 2013 - Lost connection to MySQL server during query"
I'm using mysql 3.23.41 under Linux Mandrake, and mysql 4.0.15 under Win 
XP Pro.
They turn out to have the same error.
Please upgrade you MySQL Windows client to 4.0.16 there is a bug
with net_read_timeout and net_write_timeout on 4.0.15 that
disconnect when the query takes more than 30 secons.
--
Regards,
For technical support contracts, visit https://order.mysql.com/
Are you MySQL certified?, http://www.mysql.com/certification/
Miguel Angel Solórzano <[EMAIL PROTECTED]>
São Paulo - Brazil

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.547 / Virus Database: 340 - Release Date: 2/12/2003

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost Connection to MySQL server during query

[Matt W]

Hi Donald,

Is the script possibly sending a query larger than max_allowed_packet
(1MB default)? Have you read http://www.mysql.com/doc/en/Gone_away.html
?


Matt


- Original Message -
From: "Donald Tyler" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, September 09, 2003 10:36 AM
Subject: Lost Connection to MySQL server during query


> I have a script that is processing data from a single table and
splitting it
> into smaller normalized tables.
>
>
>
> The script takes anywhere between 5-10 minutes to complete, and as it
runs
> it constantly outputs a report on its progress.
>
>
>
> The script seems to run fine the first time I run it, but with
subsequent
> runs (To see if it incorrectly creates duplicates of records etc),
after a
> couple of minutes the script ends with an error message saying "Lost
> connection to MySQL server during query".
>
>
>
> During the first run, the script is mostly just chopping up the data
and
> placing it in the new tables, and doing a little comparing. But during
> subsequent runs, all of the records in the new tables should already
exist,
> so the script see's this, and instead of creating new records, it
compares
> them to see if its correct.
>
>
>
> Does anyone have any idea why it would be losing connection all the
time?
>
>
>
> This is just being run on a test server at the moment. Being used as
the
> server and also the client, configured as follows:
>
>
>
> Windows XP Tablet Edition
>
> PHP 4.3.3
>
> PHP Extensions:   XmlRPC
>
> MySQL 4.0.14
>
> Apache 2.0.47
>
>
>
> Please help, this has been making my life hell for a week now!
>
>
>
> Thanks
>
>
>
>
>
> Donald


-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: Lost connection to MySQL server during query

[Dathan Vance Pattishall]

-->-Original Message-
-->From: Alec Smith [mailto:[EMAIL PROTECTED] On Behalf Of Alec
-->Smith
-->Sent: Friday, June 06, 2003 11:24 AM
-->To: [EMAIL PROTECTED]
-->Subject: Lost connection to MySQL server during query
-->
-->Hi -
-->
-->[Perhaps not exactly the right list, but [EMAIL PROTECTED] doesn't
-->seem to be too active, so I'm hoping someone here might be able to
offer
-->some insight.]
-->
-->I'm getting the below error when trying to connect to a MySQL 4.0.12
-->server on RedHat 9 using a Perl script:
-->
-->DBI connect('mailers:192.168.50.201','admin',...)
-->failed: Lost connection to MySQL server during query at ./dialer line
24
-->Can't call method "prepare" on an undefined value at ./dialer line
28.
-->
-->The client machines are RH9 also, using the 3.23.56 libraries and
clients
-->shipped with RedHat. Perl on RH9 is 5.8.0.
-->
-->Any ideas where to start?

Does your script run for a long time?
Look for a variable in my.cnf called wait_timeout it might be set pretty
low. Do a $DBI->ping in your loop to test your connection and reconnect
if not connected -OR- set wait_timeout really high.
-->
-->Thanks,
-->Alec
-->
-->--
-->MySQL General Mailing List
-->For list archives: http://lists.mysql.com/mysql
-->To unsubscribe:
-->http://lists.mysql.com/[EMAIL PROTECTED]




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Lost connection to MySQL server during query

[KH Chiu]

Assume the ip address of your remote machine is 192.168.0.88

You should perform a

nslookup 192.168.0.88

on your LOCAL machine that hold the mysqld

If it cannot resolve into a symbolic name then you will get into trouble.

Add an entry to /etc/hosts or your DNS will solve the problem.

Regards,

> Hi All
> I just installed a RedHat Linux 8.0 box with
> mysql-server-3.23.52-3
> mysql-3.23.52-3
> mysql-devel-3.23.52-3
> 
> Changed the password for root using mysqladmin
> logged in using a mysql client (locally)
> and
> mysql> GRANT ALL ON *.* TO araheja@'%' IDENTIFIED BY 'amanraheja';
> 
> I DID THE SAME STEPS ON ANOTHER BOX WITH Linux Slackware box with mysql
> 3.23.39
> 
> When I try to login using a remote client in both the servers, 
> Slackware box allows me but RedHat BOX gives me the following error
> 
> "Lost connection to MySQL server during query"
> 
> I also downloaded and installed
> mysql-server-3.23.54a-1
> mysql-3.23.54a-1
> mysql-devel-3.23.54a-1
> 
> Still the same problem.
> Any suggestions?
> 
> Thank you in advance
> Regards
> 
> --
> Aman Raheja
> AGF Inc.
> 
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
> 
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail 
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php


--
Yours,
KH Chiu
C&A Computer Consultants Ltd.
Tel: 3104 2070 Fax: 3010 0896
Email: [EMAIL PROTECTED]
Website: www.caconsultant.com


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Lost connection to MySQL server during query

[Egor Egorov]

On Thursday 16 January 2003 00:32, Gustavo A. Baratto wrote:

> This old bug reappeared after the upgrading mysql from version 3.23.54a
> (rpm provided by mysql.com) to version 4.0.8-gamma (binary provided by
> mysql.com as well).
>
> Using redhat 7.1 glibc 2.2.4-31 (which is supposed to fix this problem)
> This server has glibc 2.2.4-31 installed for quite a while, and mysql
> 3.23.54a was working just fine with it.
>
> Mysql 4.0.8 stopped crashing when I added --skip-name-resolve in the
> mysql startup... but some tables are getting corrupted very often, and I
> can't find a reason. It doesn't the tables are getting corrupted because
> of mysql is crashing, because bin-log index is not increasing, and there
> is nothing in the logs saying it was restarted.
>
> This is one example of check table:
> 
> alpgrafik_com_1.kent_session_info warning Not used space is supposed to
> be: 30612 but is: 30404
> alpgrafik_com_1.kent_session_info error   record delete-link-chain corrupted
> alpgrafik_com_1.kent_session_info error   Corrupt
> ---
>
> I searched for delete-link-chain on google but I didn't have much luck
>
> Not all clients (eg, php) have been upgraded to version 4, but the mysql
> docs say there shouldn't be a problem if we are not using the new features.
>
> Ideias?

Please, upgrade to the version 4.0.9.
There was a bug in 4.0.8 when MySQL crashes if he can't resolve remote 
hostname. 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query at ... After upgrade to 3.23.54

[Gustavo A. Baratto]

You can use --skip-name-resolve when starting mysqld, but this is not a real
solution.
Even doing that,'I'm still having some odd problems I never had before, like
table corruption (I'm on 4.0.8 though)


- Original Message -
From: "Patrick de Kievit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, January 15, 2003 2:34 PM
Subject: Lost connection to MySQL server during query at ... After upgrade
to 3.23.54


> Hi all,
>
> Pure randomly my server tells me the its
>
> Lost connection to MySQL server during query at ...
>
> This all happened after my upgrade to version 3.23.54. I searched google
> and read some threads here.
>
> A possible solution is to DOWNGRADE some libc files? Tell me is this the
> only solution ? Is there a patch ?
>
> Thanks,
>
> Patrick
>
>
>
>
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Mark]

- Original Message -
From: "Victoria Reznichenko" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, November 26, 2002 4:44 PM
Subject: re: Lost connection to MySQL server during query


> Mark,
> Tuesday, November 26, 2002, 7:32:15 AM, you wrote:
>
> M> Yes, again. :( Although reluctantly, I finally decided to upgrade
> M> to 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these
> M> annoying errors. Alas, 6 out of 10 times when I start a MySQL
> M> application, I get an error like this:
>
> M> DBD::mysql::st execute failed: Lost connection to MySQL server
> M> during query at /usr/libdata/perl/5.00503/News/MySQL/User.pm
> M> line 209.
>
> M> The log is very non-telling; it mostly bales at something entirely
> trivial;
>
> Check that max_allowed_packet is big enough:
>   http://www.mysql.com/doc/en/Gone_away.html


Max_allowed_packet is not in issue here (set at 1M). This query only returns
30 newsgroups or so. Besides, the connection to MySQL does not always get
lost here; sometimes a bit later, sometimes a bit earlier, and sometimes not
at all.

> Do you get the same result if you execute this query from
> command-line?

The problem only occurs after my news server called an external check-table
program, which does an extended check on all tables within its scope. This
only happens when the news server was not shutdown properly.

Before you ask, no, there are no errors in the tables (nor have there, as
far as I know, ever been). And besides, like I said, my program does not
always lose the connection; just 6 out of 10 times after it ran the rather
intense extended table check program.

The two seem related; but I cannot figure out how. It seems as if the huge
activity on the tables prior to my news server doing its regular startup
(after it just called the table-check program), has an effect on the
stability of the new connection I am trying to make. Although, for the life
of me, I cannot figure out how (the table-check program logs into MySQL as a
special "maintenance" user).

When the connection gets losts, I restart the news server a few times; and
once the connection holds, it remains running smoothly. As it should, since
the tables contain no errors.

I even set a ridiculously high connection timeout value in /etc/my.cnf:

set-variable = connect_timeout=15

But that makes no difference.

- Mark


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Lost connection to MySQL server during query

[Victoria Reznichenko]

Mark,
Tuesday, November 26, 2002, 7:32:15 AM, you wrote:

M> Yes, again. :( Although reluctantly, I finally decided to upgrade to
M> 3.23.53a (on FreeBSD 4.7R), in the hope to get rid of these annoying errors.
M> Alas, 6 out of 10 times when I start a MySQL application, I get an error
M> like this:

M> DBD::mysql::st execute failed: Lost connection to MySQL server during query
M> at /usr/libdata/perl/5.00503/News/MySQL/User.pm line 209.

M> The log is very non-telling; it mostly bales at something entirely trivial;

M> 
M> 021126  6:15:34   4 Connect news@localhost on xovers
M>   4 Query   SELECT domain_id FROM smtp.cwdomains
M> 021126  6:15:35   4 Query   SELECT newsgroup FROM newsgroups WHERE
M> local <> 'y'
M>  4 Quit
M> 

M> The program connects via /tmp/mysql.sock from localhost; so there is no real
M> connection or DNS problem. It just loses the connection. :(

M> Can someone please tell me how to end this problem? I checked the databases
M> a zillion times, and they appear fully intact. I am gravely at a loss here.
M> :(

Check that max_allowed_packet is big enough:
  http://www.mysql.com/doc/en/Gone_away.html

Do you get the same result if you execute this query from
command-line?

What does table 'newsgroups' look like? (table stucture)



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost Connection to MySQL Server during query

[Eric Frazier]

Hi,

Isn't it time to add a manual section like this one
http://www.mysql.com/doc/en/Communication_errors.html  on the Lost
Connection to MySQL Server during query? These emails come in at a regualr
rate, they seem to vary in cause somewhat, and I still have not solved my
own problem with this error message which sounds a bit like his problem.

Thanks,

Eric 



At 11:47 AM 11/2/02 -0500, AuctionWare Admin wrote:
>Hello all,
>
>I have came across a pretty peculiar problem and am hoping someone can help 
>me out.
>Each time I try to connect to a MySQL server on my network, I receive the 
>following error:
>
>Lost Connection to MySQL Server during query
>
>It isn't just one server that is giving me this problem, it is my 
>production server as well as my 3 test servers.  Connecting from the 
>localhost is working fine, but connecting from a different machine, no 
>matter which machine it is, is giving me this error.  It was working fine 
>one day, and all of a sudden this started happening.  I have searched the 
>internet for hours and hours for a solution, but have come up only with the 
>packet size being too big in a query and the server is closing the 
>connection.  This is not the case however, as I am not even issuing a 
>query, I am getting this error just trying to log in !
>
>Any ideas?  Thank you in advance for your help,
>Scott Meesseman
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>

(250) 655 - 9513 (PST Time Zone)

"Inquiry is fatal to certainty." -- Will Durant 





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost Connection to MySQL Server during query

[Mark Matthews]

AuctionWare Admin wrote:

Hello all,

I have came across a pretty peculiar problem and am hoping someone can 
help me out.
Each time I try to connect to a MySQL server on my network, I receive 
the following error:

Lost Connection to MySQL Server during query

It isn't just one server that is giving me this problem, it is my 
production server as well as my 3 test servers.  Connecting from the 
localhost is working fine, but connecting from a different machine, no 
matter which machine it is, is giving me this error.  It was working 
fine one day, and all of a sudden this started happening.  I have 
searched the internet for hours and hours for a solution, but have come 
up only with the packet size being too big in a query and the server is 
closing the connection.  This is not the case however, as I am not even 
issuing a query, I am getting this error just trying to log in !

Any ideas?  Thank you in advance for your help,
Scott Meesseman

Do you run RedHat Linux? If so, search the archives for RedHat and 
GLIBC. RedHat shipped in their latest up2date with a GLIBC which breaks 
remote connections for MySQL.

You can read about it at:

https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128

You can either downgrade your GLIBC version, install the patched one 
listed on the bugzilla page, or use the 3.23.53a binaries from MySQL 
which are not affected by this GLIBC problem.

	-Mark

--
For technical support contracts, visit https://order.mysql.com/?ref=mmma

   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /  Mark Matthews <[EMAIL PROTECTED]>
 / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java
/_/  /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA
   <___/ www.mysql.com


-
Before posting, please check:
  http://www.mysql.com/manual.php   (the manual)
  http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: Lost connection to MySQL server during query

[Egor Egorov]

Frederic,
Thursday, October 31, 2002, 12:02:51 AM, you wrote:

FT> Yes, I use RedHat, and have try to find info on the mailing list and google,
FT> without any luck.

Here is some info:
 http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:122632


FT> - Original Message -
FT> From: "Egor Egorov" <[EMAIL PROTECTED]>
FT> To: <[EMAIL PROTECTED]>
FT> Sent: Wednesday, October 30, 2002 5:09 AM
FT> Subject: re: Lost connection to MySQL server during query


>> Frederic,
>> Tuesday, October 29, 2002, 11:49:19 PM, you wrote:
>>
>> FT> What are the possible causes for this error message ?
>>
>> The possible source of error is the glibc provided by RedHat. Do you use
>> RedHat? If so, check the mailing list archives, there were a lot of
>> possible error descriptions during last 3-4 weeks ..
>>
>> FT> This problem occured right after I restarted mysqld on my machine. I
FT> can
>> FT> access mysql on localhost without any failure, either in command mode,
>> FT> telnet or via httpd with PHP, but connection via PHP on remote machine
>> FT> fails.
>>
>> FT> Here's what I see if I try to telnet, seams like the service is simply
>> FT> dropping the connection.
>>
>>
>> FT> [root@intranet CAMusage]# telnet 10.0.6.2 3306
>> FT> Trying 10.0.6.2...
>> FT> Connected to 10.0.6.2.
>> FT> Escape character is '^]'.
>> FT> Connection closed by foreign host.
>>
>>
>> FT> Here's what I see in mysqld.log :
>>
>>
>> FT> Number of processes running now: 1
>> FT> mysqld process hanging, pid 30546 - killed
>> FT> 021029 16:46:23  mysqld restarted
>> FT> /usr/libexec/mysqld: ready for connections
>>
>>
>> FT> ... and in queries.log :
>>
>> FT> /usr/libexec/mysqld, Version: 3.23.41-log, started with:
>> FT> Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
>> FT> Time Id CommandArgument



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Frederic Trudeau]

Yes, I use RedHat, and have try to find info on the mailing list and google,
without any luck.


---
Frederic Trudeau
Consultant, PHP Coder, Development
[EMAIL PROTECTED]


- Original Message -
From: "Egor Egorov" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 30, 2002 5:09 AM
Subject: re: Lost connection to MySQL server during query


> Frederic,
> Tuesday, October 29, 2002, 11:49:19 PM, you wrote:
>
> FT> What are the possible causes for this error message ?
>
> The possible source of error is the glibc provided by RedHat. Do you use
> RedHat? If so, check the mailing list archives, there were a lot of
> possible error descriptions during last 3-4 weeks ..
>
> FT> This problem occured right after I restarted mysqld on my machine. I
can
> FT> access mysql on localhost without any failure, either in command mode,
> FT> telnet or via httpd with PHP, but connection via PHP on remote machine
> FT> fails.
>
> FT> Here's what I see if I try to telnet, seams like the service is simply
> FT> dropping the connection.
>
>
> FT> [root@intranet CAMusage]# telnet 10.0.6.2 3306
> FT> Trying 10.0.6.2...
> FT> Connected to 10.0.6.2.
> FT> Escape character is '^]'.
> FT> Connection closed by foreign host.
>
>
> FT> Here's what I see in mysqld.log :
>
>
> FT> Number of processes running now: 1
> FT> mysqld process hanging, pid 30546 - killed
> FT> 021029 16:46:23  mysqld restarted
> FT> /usr/libexec/mysqld: ready for connections
>
>
> FT> ... and in queries.log :
>
> FT> /usr/libexec/mysqld, Version: 3.23.41-log, started with:
> FT> Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
> FT> Time Id CommandArgument
>
>
> FT> Any help would be very appreciate.
>
>
>
> --
> For technical support contracts, goto https://order.mysql.com/?ref=ensita
> This email is sponsored by Ensita.net http://www.ensita.net/
>__  ___ ___   __
>   /  |/  /_ __/ __/ __ \/ /Egor Egorov
>  / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
> /_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
><___/   www.mysql.com
>
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Lost connection to MySQL server during query

[Egor Egorov]

Frederic,
Tuesday, October 29, 2002, 11:49:19 PM, you wrote:

FT> What are the possible causes for this error message ?

The possible source of error is the glibc provided by RedHat. Do you use
RedHat? If so, check the mailing list archives, there were a lot of
possible error descriptions during last 3-4 weeks ..

FT> This problem occured right after I restarted mysqld on my machine. I can
FT> access mysql on localhost without any failure, either in command mode,
FT> telnet or via httpd with PHP, but connection via PHP on remote machine
FT> fails.

FT> Here's what I see if I try to telnet, seams like the service is simply
FT> dropping the connection.


FT> [root@intranet CAMusage]# telnet 10.0.6.2 3306
FT> Trying 10.0.6.2...
FT> Connected to 10.0.6.2.
FT> Escape character is '^]'.
FT> Connection closed by foreign host.


FT> Here's what I see in mysqld.log :


FT> Number of processes running now: 1
FT> mysqld process hanging, pid 30546 - killed
FT> 021029 16:46:23  mysqld restarted
FT> /usr/libexec/mysqld: ready for connections


FT> ... and in queries.log :

FT> /usr/libexec/mysqld, Version: 3.23.41-log, started with:
FT> Tcp port: 3306  Unix socket: /var/lib/mysql/mysql.sock
FT> Time Id CommandArgument


FT> Any help would be very appreciate.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Re: Lost connection to MySQL server during query

[Egor Egorov]

Hello Graham,

Tuesday, October 15, 2002, 12:03:34 PM, you wrote:

>> 1. replace Red Hat's rpms with MySQL binary release, download it from
>> http://www.mysql.com/
>> 2. run myisamchk on all files.
>> 3. run MySQL and enjoy the reliability since then :-)

GM> Why do Linux distributions ship broken MySQL packages? The newly
GM> released SuSE 8.1 shows similar problems, connecting from the local
GM> system works fine but the server crashes (and is restarted by
GM> safe_mysqld) as soon as a remote user attempts to connect. As has
GM> already been noted, after installing the "official" MySQL RPMs
GM> everything works.

This is a common problem with non-MySQL builds. Why?

First, because compiling MySQL is a very careful job to do, you don't
have to miss a single point in instructions. Say, compiling with wrong
options will give you a binary that will not be able to resolve
hostnames, load data more than 2gb, work with more than a couple of
hundreds of connections and so on.

Second, because the only stable GNU C compiler today is gcc 2.95. It's
true that MySQL cannot be compiled correctly with gcc 2.96 and 3.xx.

Third, because making a correct glibc binary is very, very hard goal
to accomplish. Not to speak about other binaries, but, say, MySQL
works with threads, and the thread stack in glibc should be around 256k
for MySQL can handle hundreds of connections. In other case, MySQL will
just crash after Nth connection. By default, the stack is 2mb in
glibc. This is causing crashes, too.

There are a lot of many other reasons.

That's (in short) why MySQL official binaries are compiled statically
and works well.



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ma02-010c
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Graham Murray]

Egor Egorov <[EMAIL PROTECTED]> writes:

> 1. replace Red Hat's rpms with MySQL binary release, download it from
> http://www.mysql.com/
> 2. run myisamchk on all files.
> 3. run MySQL and enjoy the reliability since then :-)

Why do Linux distributions ship broken MySQL packages? The newly
released SuSE 8.1 shows similar problems, connecting from the local
system works fine but the server crashes (and is restarted by
safe_mysqld) as soon as a remote user attempts to connect. As has
already been noted, after installing the "official" MySQL RPMs
everything works.

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Lost connection to MySQL server during query

[Egor Egorov]

Hello Me-Selfe,

Saturday, October 12, 2002, 2:25:23 AM, you wrote:

MS> After a reboot, the database server running Redhat 7.2 and mySQL
MS> 3.23.41-1 started acting funny. When I try to telnet to port 3306 of the
MS> server, nothing happens and when i check in the log file for mysql, i
MS> get something like: 

MS> Number of processes running now: 1
MS> mysqld process hanging, pid 11437 - killed
MS> 021012 01:24:09  mysqld restarted
MS> /usr/libexec/mysqld: ready for connections
MS> (It looks like mysql crash when i connect)

MS> At the start, i had no clue what was going on, i checked all the tables
MS> with myisamchk. No errors found.

What I would suggest you is:

1. replace Red Hat's rpms with MySQL binary release, download it from
http://www.mysql.com/
2. run myisamchk on all files.
3. run MySQL and enjoy the reliability since then :-)



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Lost connection to MySQL server during query

[swati sandhya]

Hi,

How did you solve the problem, Lost connection to
MySQL server during query, please let me know this i
am facing the same problem.

thanks,
swati
--- Vernon Webb <[EMAIL PROTECTED]> wrote:
> Sorry all!
> 
> I have resolved the issue. 
> 
> -- Forwarded Message ---
> From: "Vernon Webb" <[EMAIL PROTECTED]>
> To: "MySQL List" <[EMAIL PROTECTED]>
> Sent: Sun, 13 Oct 2002 17:18:16 -0500
> Subject: Lost connection to MySQL server during
> query 
> 
> After spending the entire day trying to figure out
> what the you-know-what 
> has happended to MySQL on my box, and after
> throughly messing things up and 
> fixing them again it has come down to a final error
> message when trying to 
> access some databases (some mind you, not all):
> 
> Lost connection to MySQL server during query 
> 
> Anyone have any idea what this is all about?
> 
> Thanks
> 
> -- 
> This message has been scanned for viruses and
> dangerous content by Webb Solutions' MailScanner,
> and is believed to be clean.
> 
> 
>
-
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list
> archive)
> 
> To request this thread, e-mail
> <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
>
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try:
> http://lists.mysql.com/php/unsubscribe.php
> 


__
Do you Yahoo!?
Faith Hill - Exclusive Performances, Videos & More
http://faith.yahoo.com

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Lost connection to MySQL server during query

[Vernon Webb]

Somehow MySQL got broke and by removing MySQL and reinstalling it, removing 
the /var/lib/mysql folder and restaring MySQL put me back at the where it 
was once I first configured MySQL. 

Then I copied the database folders back to the folder, but I had changed the 
password and forgot to change it in my web pages on the server that actually 
accessed those databses.


-- 
This message has been scanned for viruses and
dangerous content by Webb Solutions' MailScanner,
and is believed to be clean.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Lost connection to MySQL server during query

[Paul DuBois]

At 17:29 -0500 10/13/02, Vernon Webb wrote:
>Sorry all!
>
>I have resolved the issue.

Don't leave us hanging.  How?

>
>-- Forwarded Message ---
>From: "Vernon Webb" <[EMAIL PROTECTED]>
>To: "MySQL List" <[EMAIL PROTECTED]>
>Sent: Sun, 13 Oct 2002 17:18:16 -0500
>Subject: Lost connection to MySQL server during query
>
>After spending the entire day trying to figure out what the you-know-what
>has happended to MySQL on my box, and after throughly messing things up and
>fixing them again it has come down to a final error message when trying to
>access some databases (some mind you, not all):
>
>Lost connection to MySQL server during query
>
>Anyone have any idea what this is all about?
>
>Thanks


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

RE: Lost connection to MySQL server during query

[Vernon Webb]

Sorry all!

I have resolved the issue. 

-- Forwarded Message ---
From: "Vernon Webb" <[EMAIL PROTECTED]>
To: "MySQL List" <[EMAIL PROTECTED]>
Sent: Sun, 13 Oct 2002 17:18:16 -0500
Subject: Lost connection to MySQL server during query 

After spending the entire day trying to figure out what the you-know-what 
has happended to MySQL on my box, and after throughly messing things up and 
fixing them again it has come down to a final error message when trying to 
access some databases (some mind you, not all):

Lost connection to MySQL server during query 

Anyone have any idea what this is all about?

Thanks

-- 
This message has been scanned for viruses and
dangerous content by Webb Solutions' MailScanner,
and is believed to be clean.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Gerald R. Jensen]

Network problems ... something is breaking TCP/IP.

- Original Message -
From: "Yanglong Zhu" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Saturday, October 12, 2002 4:57 AM
Subject: Lost connection to MySQL server during query



Hi there,

This is an error message from MySQL when I try to connect to my remote
MySQL server. Does anyone know what this message mean. I'm completely
puzzled.

I used to make the same connection with the exactly the same command
routinely get connected easily. But all in a sudden,  I cannot make the
connection at all. I looked on the localhost. I can login on the
localhost just fine. I simply can login from another machine. I did not
upgrade the MySQL in the mean time. What could be the reason??

Please help.


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail
<[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Yanglong Zhu]

Gerald R. Jensen wrote:

>Connection type, network configuration, operating system, ODBC
>configuration, etc. can be factors. You haven't shared any of that
>information, so it is hard to speculate.
>
Sorry, I'm on a University wide LAN, running mysql 3.23.49 on RH7.3 . I 
don't think I'm using ODBC, but I'm a bit vague on this.

>
>- Original Message -
>From: "Yanglong Zhu" <[EMAIL PROTECTED]>
>To: "Gerald R. Jensen" <[EMAIL PROTECTED]>
>Cc: <[EMAIL PROTECTED]>
>Sent: Saturday, October 12, 2002 2:54 PM
>Subject: Re: Lost connection to MySQL server during query
>
>
>Gerald R. Jensen wrote:
>
>  
>
>>Network problems ... something is breaking TCP/IP.
>>
>>
>>
>Gerald,  I can view the webpages on the server, though. Doesn't it use
>the same TCP/IP?
>
>  
>
>>- Original Message -
>>From: "Yanglong Zhu" <[EMAIL PROTECTED]>
>>To: <[EMAIL PROTECTED]>
>>Sent: Saturday, October 12, 2002 4:57 AM
>>Subject: Lost connection to MySQL server during query
>>
>>
>>
>>Hi there,
>>
>>This is an error message from MySQL when I try to connect to my remote
>>MySQL server. Does anyone know what this message mean. I'm completely
>>puzzled.
>>
>>I used to make the same connection with the exactly the same command
>>routinely get connected easily. But all in a sudden,  I cannot make the
>>connection at all. I looked on the localhost. I can login on the
>>localhost just fine. I simply can not login from another machine. I did not
>>upgrade the MySQL in the mean time. What could be the reason??
>>
>>Please help.
>>
>>
>>-
>>Before posting, please check:
>>  http://www.mysql.com/manual.php   (the manual)
>>  http://lists.mysql.com/   (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail
>><[EMAIL PROTECTED]>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>>
>>
>>-
>>Before posting, please check:
>>  http://www.mysql.com/manual.php   (the manual)
>>  http://lists.mysql.com/   (the list archive)
>>
>>To request this thread, e-mail <[EMAIL PROTECTED]>
>>To unsubscribe, e-mail
>>
>>
><[EMAIL PROTECTED]>
>  
>
>>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>>
>>
>>
>>
>>
>>
>
>
>
>
>
>
>
>  
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Gerald R. Jensen]

Connection type, network configuration, operating system, ODBC
configuration, etc. can be factors. You haven't shared any of that
information, so it is hard to speculate.

- Original Message -
From: "Yanglong Zhu" <[EMAIL PROTECTED]>
To: "Gerald R. Jensen" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Saturday, October 12, 2002 2:54 PM
Subject: Re: Lost connection to MySQL server during query


Gerald R. Jensen wrote:

>Network problems ... something is breaking TCP/IP.
>
Gerald,  I can view the webpages on the server, though. Doesn't it use
the same TCP/IP?

>
>- Original Message -
>From: "Yanglong Zhu" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, October 12, 2002 4:57 AM
>Subject: Lost connection to MySQL server during query
>
>
>
>Hi there,
>
>This is an error message from MySQL when I try to connect to my remote
>MySQL server. Does anyone know what this message mean. I'm completely
>puzzled.
>
>I used to make the same connection with the exactly the same command
>routinely get connected easily. But all in a sudden,  I cannot make the
>connection at all. I looked on the localhost. I can login on the
>localhost just fine. I simply can login from another machine. I did not
>upgrade the MySQL in the mean time. What could be the reason??
>
>Please help.
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
<[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>







-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Yanglong Zhu]

Gerald R. Jensen wrote:

>Network problems ... something is breaking TCP/IP.
>
Gerald,  I can view the webpages on the server, though. Doesn't it use 
the same TCP/IP?

>
>- Original Message -
>From: "Yanglong Zhu" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
>Sent: Saturday, October 12, 2002 4:57 AM
>Subject: Lost connection to MySQL server during query
>
>
>
>Hi there,
>
>This is an error message from MySQL when I try to connect to my remote
>MySQL server. Does anyone know what this message mean. I'm completely
>puzzled.
>
>I used to make the same connection with the exactly the same command
>routinely get connected easily. But all in a sudden,  I cannot make the
>connection at all. I looked on the localhost. I can login on the
>localhost just fine. I simply can login from another machine. I did not
>upgrade the MySQL in the mean time. What could be the reason??
>
>Please help.
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail
><[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>
>
>-
>Before posting, please check:
>   http://www.mysql.com/manual.php   (the manual)
>   http://lists.mysql.com/   (the list archive)
>
>To request this thread, e-mail <[EMAIL PROTECTED]>
>To unsubscribe, e-mail <[EMAIL PROTECTED]>
>Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>  
>




-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

re: Lost Connection to MySQL Server During Query

[Victoria Reznichenko]

Graphfixz,
Tuesday, October 01, 2002, 5:14:13 PM, you wrote:

G> I am getting the following error:

G> [TCX][MyODBC] Lost Connection to MySQL Server During Query

G> My code is simply dumping an IP Address to the database... at the most 10
G> lines of code. Any ideas what is causing this error? I have searched on line
G> and have not found much help.

You can get this error if the dump is bigger than max_allowed_packet:
  http://www.mysql.com/doc/en/Gone_away.html


-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___ ___   __
  /  |/  /_ __/ __/ __ \/ /Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
   <___/   www.mysql.com





-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Steve Mertz]

Ah! Thanks, this gave me the clue.  I had to up the limit of openfiles

(csh/OpenBSD) limit openfiles 1024 (from 64) and it works like a
charm now.  Thanks!


- Original Message -
From: "Gelu Gogancea" <[EMAIL PROTECTED]>
To: "Steve Mertz" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 4:31 PM
Subject: Re: Lost connection to MySQL server during query


> Hi,
>
> My opinion:
> This can be a very good reason to kill the socket(is a file too) which is
> open during query.
> This error show you that you have too many open files in the system.I
tested
> something like this(Linux - Red Hat 7.2) some time ago and after 2000
(this
> mean sockets) clients connected this error occured.
>
> Regards,
>
> Gelu
> _
> G.NET SOFTWARE COMPANY
>
> Permanent e-mail address : [EMAIL PROTECTED]
>   [EMAIL PROTECTED]
> - Original Message -
> From: "Steve Mertz" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 09, 2002 11:49 PM
> Subject: Re: Lost connection to MySQL server during query
>
>
> > No, nothing other than the startup and shutdown messages.
> >
> > And every once and a while:
> > 020708 21:00:46  Error in accept: Bad file descriptor
> >
> > But this doesn't happen all the time after restarting the database and I
> > still
> > have problems so I don't think that this is related.
> >
> > Thanks!
> > -- Steve
> >
> >
> >
> > - Original Message -
> > From: "Michael Bacarella" <[EMAIL PROTECTED]>
> > To: "Steve Mertz" <[EMAIL PROTECTED]>
> > Cc: <[EMAIL PROTECTED]>
> > Sent: Tuesday, July 09, 2002 3:43 PM
> > Subject: Re: Lost connection to MySQL server during query
> >
> >
> > > Is there anything in the error log?
> > >
> > > See mysql/data/hostname.err
> > >
> > > -M
> > >
> > > On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
> > > > I keep getting "Lost connection to MySQL server during query"
> > > >
> > > > marcos:mysql-3.23.51 {117} mysqladmin version
> > > > mysqladmin: connect to server at 'localhost' failed
> > > > error: 'Lost connection to MySQL server during query'
> > > >
> > > > Server timeout is set for 8 hours (default) and I have been trying
> > > > to hit the server all within a couple of minutes.
> > > >
> > > > Sometimes it works, sometimes it doesn't. (below is a repeat of the
> > > > command 2 minutes after the first one was issued.)
> > > >
> > > >
> > > > marcos:mysql-3.23.51 {120} !!
> > > > mysqladmin version
> > > > mysqladmin  Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
> > > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> > > > This software comes with ABSOLUTELY NO WARRANTY. This is free
> software,
> > > > and you are welcome to modify and redistribute it under the GPL
> license
> > > >
> > > > Server version  3.23.51-log
> > > > Protocol version10
> > > > Connection  Localhost via UNIX socket
> > > > UNIX socket /tmp/mysql.sock
> > > > Uptime: 10 min 57 sec
> > > >
> > > > Threads: 2  Questions: 108  Slow queries: 0  Opens: 34  Flush
tables:
> 1
> > > > Open tables: 28 Queries per second avg: 0.164
> > > >
> > > > marcos:mysql-3.23.51 {121} uname -a
> > > > OpenBSD marcos 3.1 marcos#5 i386
> > > >
> > > > What should I start looking for?  (below is "mysqladmin variables")
> > >
> > >
> >
> >
> >
> > -
> > Before posting, please check:
> >http://www.mysql.com/manual.php   (the manual)
> >http://lists.mysql.com/   (the list archive)
> >
> > To request this thread, e-mail <[EMAIL PROTECTED]>
> > To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
> >
> >
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Gelu Gogancea]

Hi,

My opinion:
This can be a very good reason to kill the socket(is a file too) which is
open during query.
This error show you that you have too many open files in the system.I tested
something like this(Linux - Red Hat 7.2) some time ago and after 2000 (this
mean sockets) clients connected this error occured.

Regards,

Gelu
_
G.NET SOFTWARE COMPANY

Permanent e-mail address : [EMAIL PROTECTED]
  [EMAIL PROTECTED]
- Original Message -
From: "Steve Mertz" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 11:49 PM
Subject: Re: Lost connection to MySQL server during query


> No, nothing other than the startup and shutdown messages.
>
> And every once and a while:
> 020708 21:00:46  Error in accept: Bad file descriptor
>
> But this doesn't happen all the time after restarting the database and I
> still
> have problems so I don't think that this is related.
>
> Thanks!
> -- Steve
>
>
>
> - Original Message -
> From: "Michael Bacarella" <[EMAIL PROTECTED]>
> To: "Steve Mertz" <[EMAIL PROTECTED]>
> Cc: <[EMAIL PROTECTED]>
> Sent: Tuesday, July 09, 2002 3:43 PM
> Subject: Re: Lost connection to MySQL server during query
>
>
> > Is there anything in the error log?
> >
> > See mysql/data/hostname.err
> >
> > -M
> >
> > On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
> > > I keep getting "Lost connection to MySQL server during query"
> > >
> > > marcos:mysql-3.23.51 {117} mysqladmin version
> > > mysqladmin: connect to server at 'localhost' failed
> > > error: 'Lost connection to MySQL server during query'
> > >
> > > Server timeout is set for 8 hours (default) and I have been trying
> > > to hit the server all within a couple of minutes.
> > >
> > > Sometimes it works, sometimes it doesn't. (below is a repeat of the
> > > command 2 minutes after the first one was issued.)
> > >
> > >
> > > marcos:mysql-3.23.51 {120} !!
> > > mysqladmin version
> > > mysqladmin  Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
> > > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> > > This software comes with ABSOLUTELY NO WARRANTY. This is free
software,
> > > and you are welcome to modify and redistribute it under the GPL
license
> > >
> > > Server version  3.23.51-log
> > > Protocol version10
> > > Connection  Localhost via UNIX socket
> > > UNIX socket /tmp/mysql.sock
> > > Uptime: 10 min 57 sec
> > >
> > > Threads: 2  Questions: 108  Slow queries: 0  Opens: 34  Flush tables:
1
> > > Open tables: 28 Queries per second avg: 0.164
> > >
> > > marcos:mysql-3.23.51 {121} uname -a
> > > OpenBSD marcos 3.1 marcos#5 i386
> > >
> > > What should I start looking for?  (below is "mysqladmin variables")
> >
> >
>
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Steve Mertz]

No, nothing other than the startup and shutdown messages.

And every once and a while:
020708 21:00:46  Error in accept: Bad file descriptor

But this doesn't happen all the time after restarting the database and I
still
have problems so I don't think that this is related.

Thanks!
-- Steve



- Original Message -
From: "Michael Bacarella" <[EMAIL PROTECTED]>
To: "Steve Mertz" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Tuesday, July 09, 2002 3:43 PM
Subject: Re: Lost connection to MySQL server during query


> Is there anything in the error log?
>
> See mysql/data/hostname.err
>
> -M
>
> On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
> > I keep getting "Lost connection to MySQL server during query"
> >
> > marcos:mysql-3.23.51 {117} mysqladmin version
> > mysqladmin: connect to server at 'localhost' failed
> > error: 'Lost connection to MySQL server during query'
> >
> > Server timeout is set for 8 hours (default) and I have been trying
> > to hit the server all within a couple of minutes.
> >
> > Sometimes it works, sometimes it doesn't. (below is a repeat of the
> > command 2 minutes after the first one was issued.)
> >
> >
> > marcos:mysql-3.23.51 {120} !!
> > mysqladmin version
> > mysqladmin  Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
> > Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> > This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> > and you are welcome to modify and redistribute it under the GPL license
> >
> > Server version  3.23.51-log
> > Protocol version10
> > Connection  Localhost via UNIX socket
> > UNIX socket /tmp/mysql.sock
> > Uptime: 10 min 57 sec
> >
> > Threads: 2  Questions: 108  Slow queries: 0  Opens: 34  Flush tables: 1
> > Open tables: 28 Queries per second avg: 0.164
> >
> > marcos:mysql-3.23.51 {121} uname -a
> > OpenBSD marcos 3.1 marcos#5 i386
> >
> > What should I start looking for?  (below is "mysqladmin variables")
>
>



-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost connection to MySQL server during query

[Michael Bacarella]

Is there anything in the error log?

See mysql/data/hostname.err

-M

On Tue, Jul 09, 2002 at 03:26:17PM -0500, Steve Mertz wrote:
> I keep getting "Lost connection to MySQL server during query"
> 
> marcos:mysql-3.23.51 {117} mysqladmin version
> mysqladmin: connect to server at 'localhost' failed
> error: 'Lost connection to MySQL server during query'
> 
> Server timeout is set for 8 hours (default) and I have been trying
> to hit the server all within a couple of minutes.
> 
> Sometimes it works, sometimes it doesn't. (below is a repeat of the
> command 2 minutes after the first one was issued.)
> 
> 
> marcos:mysql-3.23.51 {120} !!
> mysqladmin version
> mysqladmin  Ver 8.23 Distrib 3.23.51, for unknown-openbsd3.1 on i386
> Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
> This software comes with ABSOLUTELY NO WARRANTY. This is free software,
> and you are welcome to modify and redistribute it under the GPL license
> 
> Server version  3.23.51-log
> Protocol version10
> Connection  Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 10 min 57 sec
> 
> Threads: 2  Questions: 108  Slow queries: 0  Opens: 34  Flush tables: 1
> Open tables: 28 Queries per second avg: 0.164
> 
> marcos:mysql-3.23.51 {121} uname -a
> OpenBSD marcos 3.1 marcos#5 i386
> 
> What should I start looking for?  (below is "mysqladmin variables")

-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost Connection to mysql server during query

[Anil Garg]

Hi,
Thanx for your mail
You are rightin my case the mysqld is getting restarted.
But, whey is mysqld getting restarted and giving the Lost Connection error.
How can i avoid that??
Thanx
anil
- Original Message -
From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]>
To: "Anil Garg" <[EMAIL PROTECTED]>
Sent: Saturday, June 29, 2002 9:04 AM
Subject: Re: Lost Connection to mysql server during query


> Pada Thu, 27 Jun 2002 10:59:48 -0400
> "Anil Garg" <[EMAIL PROTECTED]> menulis :
>
> > Now when i try to insert by using the following query:
> >
> > INSERT INTO 1_polls VALUES (1,'This web site
is...',1,1,7,20011223105127);
> >
> > It gives  the error:
> > Error 2013 at line 235: Lost connection to MySQL server during query
> >
> > If i decrease the lenght of time stamp in the INSERT query
> >
> > INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,2001122);
> >
> >  it works fine.
> >
> > Can anyone help me by telling wots going wrong here!!
>
> Have you retry the first query again ?
>
> Usually, Lost Connection  happens because your query process has been
killed by someone else (or even the system - maybe something related to
query timeout values) or the mysqld was restarted.
>
> --
> People disagree with me.  I just ignore them.
> -- Linus Torvalds, regarding the use of C++ for the Linux kernel


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Re: Lost Connection to mysql server during query

[Mikhail Entaltsev]

I just tried to do this on my MySQL server (version 3.23.51-max-log). It
works fine.

Mikhail.


- Original Message -
From: "Anil Garg" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, June 27, 2002 4:59 PM
Subject: Lost Connection to mysql server during query


> Hi,
> Here is a strange problem!!
>
> I created a table by the following qurey:
> CREATE TABLE 1_polls (
>   id int(11) unsigned NOT NULL auto_increment,
>   question varchar(128) NOT NULL default '',
>   active tinyint(1) unsigned NOT NULL default '1',
>   sortorder int(11) NOT NULL default '0',
>   module_id int(11) NOT NULL default '0',
>   last_access timestamp(14) NOT NULL,
>   PRIMARY KEY  (id)
> ) TYPE=MyISAM;
>
> Now when i try to insert by using the following query:
>
> INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,20011223105127);
>
> It gives  the error:
> Error 2013 at line 235: Lost connection to MySQL server during query
>
> If i decrease the lenght of time stamp in the INSERT query
>
> INSERT INTO 1_polls VALUES (1,'This web site is...',1,1,7,2001122);
>
>  it works fine.
>
> Can anyone help me by telling wots going wrong here!!
>
> thanx
> anil
>
>
> -
> Before posting, please check:
>http://www.mysql.com/manual.php   (the manual)
>http://lists.mysql.com/   (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail
<[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>


-
Before posting, please check:
   http://www.mysql.com/manual.php   (the manual)
   http://lists.mysql.com/   (the list archive)

To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php