2014/1/7
> 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 th
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, a
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
signatu
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 inc
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 wrote:
> From: Singer X.J. Wang
> Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL
egards,
> Javad Bakhshi,
>
>
>
> From: "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 sc
, 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)
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
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
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 4
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:
Sent: Thursday, June 08, 2006 9:04 PM
Subject: ERROR 2013 (HY000): Lost connection to MySQL serve
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 f
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
D
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 conne
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 Vance
> 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 Maili
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.
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:
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:ht
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 initi
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
"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 ve
"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" paramete
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
>
> mysql --host=server --user=com75778 --database=com75778 --pass
> Enter password:
> ERROR 2013: L
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
que
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, 200
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 Li
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 2
CTED]>,<[EMAIL PROTECTED]>
Subject: Re: ERROR 2013:Lost connection to MySQL server
Date: Wed, 2 Jul 2003 00:55:38 +0300
Miguel,
the failing assertion is in dict_load_table():
ut_a(DB_SUCCESS == dict_load_foreigns(table->name));
Are you sure you do not have foreign keys wh
<[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.
>
>
r(10) NOT NULL default '',
FDFECSURT datetime NOT NULL default '-00-00 00:00:00',
FNPEDSALDO decimal(12,2) NOT NULL default '0.00',
FCFOLIOPARAM int(11) NOT NULL default '0',
FDFECIMPFACTURA datetime NOT NULL default '-00-00 00:00:00'
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
ailing.database.mysql
Sent: Wednesday, 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&
Greetings
From: Fred van 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
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
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\bin>mysql -uroot test --local-infile=1
Welcome to the MySQL monitor. Comma
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 quer
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 que
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:
ftp://ftp.suse.com/pub/suse/i386/u
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 s
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
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 15
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 er
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
http://www
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 problem
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 mysq
AIL PROTECTED]>; <[EMAIL PROTECTED]>
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 mig
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 can'
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 hostna
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.
An
: Kurt 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 cur
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 2013
54 matches
Mail list logo
