2014/1/7 h...@tbbs.net
2014/01/06 17:07 +0100, Reindl Harald
what about look in the servers logfiles
most likely max_allowed_packet laughable low
Is this then, too, likly when the server and the client are the same
machine?
I left this out, that it only then happens when the client has
2014/01/06 17:07 +0100, Reindl Harald
what about look in the servers logfiles
most likely max_allowed_packet laughable low
Is this then, too, likly when the server and the client are the same machine?
I left this out, that it only then happens when the client has been idle, and
right
Am 06.01.2014 15:36, schrieb h...@tbbs.net:
Now that I installed 5.6.14 on our Vista machine, when using mysql I often
see that error-message, which under 5.5.8 I never saw. What is going on?
what about look in the servers logfiles
most likely max_allowed_packet laughable low
On 11/19/2012 10:27 AM, walter harms wrote:
hi List,
i get occasionally the following error:
ERROR 2013 (HY000): Lost connection to MySQL server at 'sending authentication
information', system error: 32
$ perror 32
OS error code 32: Broken pipe
Just to start.
If you want help you should
If you did not work directly on mysql server (login
by mysql command), please try this.
Using script (PHP, ...) may lose connection, as my experience.
Best
--- On Mon, 3/5/12, Singer X.J. Wang w...@singerwang.com wrote:
From: Singer X.J. Wang w...@singerwang.com
Subject: Re: ERROR 2013
1, 2012 11:09 AM
Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query
Il 01/03/2012 11:03, javad bakhshi ha scritto:
Hi,
I am trying to load data into my table from a very large file but after some
time I get this error:
ERROR 2013 (HY000): Lost connection
,
From: mail...@securitylabs.it mail...@securitylabs.it
To: mysql@lists.mysql.com
Sent: Thursday, March 1, 2012 11:09 AM
Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during
query
Il 01/03/2012 11:03, javad bakhshi ha scritto:
Hi,
I am trying to load
Il 01/03/2012 11:03, javad bakhshi ha scritto:
Hi,
I am trying to load data into my table from a very large file but after some
time I get this error:
ERROR 2013 (HY000): Lost connection to MySQL server during query
My file size is around 4G and I have 220M lines in my file which have to be
Rajesh Mehrotra wrote:
Hi,
We copied over a test copy of a multi-GB database to a new Sun V440 box
running Solaris 10 (64-bit) with a 64-bit MySQL install. When trying to
connect to the database, we consistently get Error 2013.
Any pointers?
Check the server's error log and see if there's
I left out URL to source compilation procedure and flags in original
message. Here it is:
http://homepage.mac.com/kelleherk/iblog/C711669388/E20061121141451/
index.html
ANy advice would be really appreciated.
Regards, Kieran
On Dec 20, 2006, at 3:08 PM, Kieran Kelleher wrote:
I have MySQL
Replying to myself again...
OK, some more light on the subject. I did a complete dump of the
master and reloaded the slave thinking maybe I had corrupt tables or
something. Having started the slave with skip-start-slave, I found
that I could stop mysqld on command line using mysqladmin
Hello
That version is quite old and is an alpha version. I think you can download a
release for production use.
Gu Lei
- Original Message -
From: murthy gandikota [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Thursday, June 08, 2006 9:04 PM
Subject: ERROR 2013 (HY000): Lost
Marten,
can you email the complete .err log from the server to
[EMAIL PROTECTED]
I am interested in what caused the very first crash in the server. Now your
database seems to be seriously corrupt, since the log sequence number in the
log files is only 14 MB, while it is = 153 MB in a data
Hello,
Thanks to all who applied but I was able to get access to the log file
today. The server was shutting down and it seemed to be a performance
problem.
I increased the RAM in the server and adjusted the Innodb settings to
take advantage of this.
Now everything is much better.
Michael
Michael Gale wrote:
Hello,
Earlier today I tried to make some table alterations on a mysql server
(4.0.24) and kept on receiving this error:
ERROR 2013: Lost connection to MySQL server during query
I would login to the server, either through the socket or using the
IP. Then connect to a
http://dev.mysql.com/doc/mysql/en/Error-handling.html
I would look at your wait_timeout settings, if the mysqldump slept for
greater then this setting then this could be the cause of your error.
Why would the connection sleep? It has to flush the buffer to disk or
STDOUT.
DVP
Dathan
I am running Debian sarge with MySQL 4.0.20. My problem is I can
connect from localhost, but when I try to connect from other host this
error comes up:
ERROR 2013: Lost connection to MySQL server during query
Sorry I found the answer. I have ALL:ALL in hosts.deny
--
MySQL General Mailing
Ok, it seems I fixed my problem before anybody was available to help me.
The error was due to bad code -- the program was trying to send multiple
queries through the same connection. Even though it was compiled as
thread safe, you still have to find some way to prevent concurrent
queries on
Mauricio Pellegrini [EMAIL PROTECTED] wrote:
I'm using MySql 4.0.18 on Linux (SuSE 8.2)
and I'm getting this error
ERROR 2013: Lost connection to MySQL server during query
a few seconds after launching
the following command
LOAD DATA LOCAL INFILE '/root/hc.txt' into
This is just a shot in the dark, but I recall getting similar behavior
(error...lost connection...reconnect) when I was trying to LOAD DATA that
happened to violate foreign key constraints in my InnoDB tables.
Hope that helps.
---
Fyodor Golos
Stockworm, Inc.
-Original Message-
From:
What is your max packet size? Are you able to determine where the `error`
occurs in the process? During the load of the temporary table? During the query
of the temp table?
On Wed, 07 Apr 2004, Ginger Cheng wrote:
Hello, MySQL gurus,
I have been trying to output the result of some large
Hi,
The max packet site is 1048576. But I don't think it is a problem cuz I
have successfully outputted the result of this query before. I checked
mysqld.log. This is the tail I think might related to the problem:
Number of processes running now: 0
040406 22:22:01 mysqld restarted
Cannot
I think this is the problem (cited from mysqld.log)
Some pointers may be invalid and cause the dump to abort...
followed by my query to create the tmp table
But I am not sure how to fix it.
ginger
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Bungarz, Kai [EMAIL PROTECTED] wrote:
When i'm using mysql client, version 12.21 - Distrib: 4.0.15 / windows,
for queries or loading data, i always get an error 2013 (lost
connection...)=20
after 30 seconds and the connection breaks down.
This doesn't happen, when i use the older version
Bungarz, Kai [EMAIL PROTECTED] wrote:
Hi!
I get error 2013: Lost connection to mysql server during query, while
loading
data into a table using load data infile...
This happens only, when load data needs much time and files are
rather
big.
Is there any time_out parameter i have to
Alexander K?ppe [EMAIL PROTECTED] wrote:
Hi,
I have trouble to connect from a remote host to the mysql-server.
On localhost works all right.
But when I want to establish a connection with
pre
mysql --host=server --user=com75778 --database=com75778 --pass
Enter password:
ERROR 2013: Lost
Check the connection timeout parameter. Increase it if it's low and try..
W. Bauer [EMAIL PROTECTED] 10/16/2003 6:20:44 PM
Dear all
When I run a query on a table with about 22 Mio records and three columns of
type bigint, I get a Error 2013 Lost connection to MySQL server during
query. If I
Hi,
On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
I have the following problem, when I try to connect to my DB servicios
I get connected succesfully, but when I try to access certain tables I get
the error
ERROR 2013: Lost connection to MySQL server during query but only with
Engen [EMAIL PROTECTED]
To: Miguel Perez [EMAIL PROTECTED]
CC: [EMAIL PROTECTED]
Subject: Re: ERROR 2013:Lost connection to MySQL server
Date: Tue, 1 Jul 2003 21:23:41 +0200
Hi,
On Tue, Jul 01, 2003 at 02:13:23PM -0500, Miguel Perez wrote:
I have the following problem, when I try to connect to my DB
, July 02, 2003 12:11 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server
The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
The wierd thing is that I could access those tables but just after I
rebooted my PC
I couldn't access the 2 tables.
The log files has the following
On Tue, Jul 01, 2003 at 04:09:26PM -0500, Miguel Perez wrote:
The OS I'm using is Red Hat 7.3, and the mysql version is 4.0
The wierd thing is that I could access those tables but just after I
rebooted my PC
I couldn't access the 2 tables.
The log files has the following:
030701
PROTECTED]
To: [EMAIL PROTECTED]
Subject: Re: ERROR 2013:Lost connection to MySQL server
Date: Wed, 2 Jul 2003 00:35:09 +0300
Miguel,
what exact MySQL version you are running?
Have you created FOREIGN KEY constraints to those tables?
Have you downgraded to a lower MySQL version?
Regards,
Heikki
PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 12:47 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server
I am running the 4.0.12 version
For those tables I don't have FOREIGN KEYS here is the table desc.
CREATE TABLE CLIENTE (
FINGCIOID smallint(6) NOT NULL default '0
Message -
From: Miguel Perez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 12:47 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server
I am running the 4.0.12 version
For those tables I don't have FOREIGN KEYS here is the table desc.
CREATE
Miguel,
best to upgrade to 4.0.13 because it has better diagnostics.
Regards,
Heikki
- Original Message -
From: Miguel Perez [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 1:03 AM
Subject: Re: ERROR 2013:Lost connection to MySQL server
On Wed, Jul 02, 2003 at 12:55:38AM +0300, Heikki Tuuri wrote:
...
4.0.13 has better diagnostics. Please upgrade to it if you are not using
MySQL replication.
Is there something wrong with 4.0.13's replication, or does it not
replicate properly with 4.0.12?
--Pete
--
MySQL General Mailing
Pete,
INSERT ... SELECT ... does not replicate properly with AUTO_INCREMENTs.
Regards,
Heikki
- Original Message -
From: Pete Harlan [EMAIL PROTECTED]
To: Heikki Tuuri [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 1:10 AM
Subject: Re: ERROR 2013:Lost
At 03:57 PM 6/20/2003 -0300, Dyego Souza do Carmo wrote:
Hi,
I wasn't able for to repeat with the last bk tree 4.0 on Linux
and Windows. The query was performed from a Linux machine and
also from a Windows machine.
c:\mysql\binmysql -uroot test --local-infile=1
Welcome to the MySQL monitor.
Now, it's working fine !
Thanks a lot
Nivaldo
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Tuesday, March 04, 2003 12:12 AM
Subject: Re: Error 2013 - Lost connection to MySQL server during query
Suporte schrieb:
Hi
Suporte schrieb:
Hi
I installed MySQL on a server running RedHat 8.0 and it's working fine. But
when I try to connect to MySQL from a remote station, using MySQL Control
Center, or even using the command-line mysql, I get the message:
Error 2013 - Lost connection to MySQL server during query
Heinz
great hint - poor success
actually installed is 2.2.93
if i force it in maybe mysql functions - other thing will fail in bulk.
kr mr
Stefan Hinz [EMAIL PROTECTED] 02/12/03 15:41 PM
Markus,
If you're lucky, you might be able to use this RPM:
mazin,
Friday, November 08, 2002, 5:50:55 PM, you wrote:
m I have been facing this problem since from many months.
m The problem is that when i try to connect mysql from the remote place using
m mysqld -h 192.168.1.1 -u temp -p
m it ends up with the error ERROR 2013: Lost connection to MySQL
Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0.
The problem seems to be the version of RedHat. We have now installed the
same version of MySql on RedHat 7.3 and it seems to work fine. Can you
give me a confirmation of this problem?
Thanks
Davide
On Fri, 2002-10-25 at
Davide,
Monday, October 28, 2002, 9:56:46 AM, you wrote:
DP Thanks for your help, we have installed MySQL 2.23.53a on Red Hat 8.0.
DP The problem seems to be the version of RedHat. We have now installed the
DP same version of MySql on RedHat 7.3 and it seems to work fine. Can you
DP give me a
Davide,
Friday, October 25, 2002, 11:57:23 AM, you wrote:
DP I'm new to MySQL. I am trying to set replication in MySQL but i get the
DP error in the subject.
DP Can you help me please?
Can you be more detailed?
What OS? What versions of MySQL servers? What did you done before you got
this
are you getting this problem with an API like php or perl cgi.. or is
this command line. i was having a similar problem, but i couldn't
access anything. i was trying to remotely connect to the mysql via
command line and it would boot me. even on the server itself if i
included the '-h
Hi,
I know there is more than one reason that this error can occur, but I have
not seen a good guide to debuging.
It might help, if you are using DBI to do a trace to a log file. I have
this happen every once in a while, but can't track it down because it is
one query out of hundreds and I
]
Sent: Friday, October 18, 2002 6:37 PM
Subject: Re: ERROR 2013: Lost connection to MySQL server during query
Hi,
I know there is more than one reason that this error can occur, but I have
not seen a good guide to debuging.
It might help, if you are using DBI to do a trace to a log file. I
Thanks for the reply.
-rw-rw 1 mysql mysql 12766 Oct 10 12:16 bob-bin.072
-rw-rw 1 mysql mysql 506213 Oct 15 09:11 bob-bin.073
-rw-rw 1 mysql mysql 40391597 Oct 17 12:52 bob-bin.074
-rw-rw 1 mysql mysql 98 Oct 17 12:53 bob-bin.075
-rw-rw 1
Hi, This is the same error that I am getting, except that in my case the
server does not die, I just cant connect from another machine. All I get is
this error, which seems to be because the server is not responding to the
3306 port. or something like that.
I don't know if this is the same
I had similar problem in my case.
The solution was that maybe you are accessing the column which has data
which is greater then the specified in Max_data_allowed in my.cnf.
Change it to something more and I hope that the problem is solved ?
Insane
SQLyog - The Definative GUI For MySQL
Hi,
Here's a bit of a followup:
I've narrowed my problem down to one of our servers, the one running mySQL
3.22.27.
The server is listening to port 3306, but is taking a very long time to
respond to requests sent to that port. It seems to hang but it eventually
responds after a few minutes.
I had a similar problem recently. Try checking the /etc/hosts file to see if
the hosts/IPs are matching the current config.
Regards,
Milos Rackov
-Original Message-
From: Kurt Hansen [mailto:[EMAIL PROTECTED]]
Sent: Monday, July 09, 2001 4:58 PM
To: [EMAIL PROTECTED]
Subject: ERROR
Hansen [EMAIL PROTECTED]; [EMAIL PROTECTED]
Sent: Monday, July 09, 2001 8:59 AM
Subject: RE: ERROR 2013: Lost connection to MySQL server during query
I had a similar problem recently. Try checking the /etc/hosts file to see
if
the hosts/IPs are matching the current config.
Regards,
Milos
54 matches
Mail list logo