Re: ERROR 2013 at line 1960: Lost connection to MySQL server during query on Linux SMP

[Jim Faucette]

Sorry if I missed your table structure. Does it include a bigint?

  jim... 

sinisa@stripped wrote:
> 
> Van writes:
>  > sinisa@stripped wrote:
>  > >
>  > > Van writes:
>  > >  > sinisa@stripped wrote:
>  > >  > >
>  > >  > > Van writes:
>  > >  > >  > While this appears to be a bug in mysqldump, doing a
> 'select into
>  > >  > >  > outfile'  ftp-ing the file to the server, creating the
> table schemas, and
>  > >  > >  > finally load data infile, successfully brings the table
> over.
>  > >  > >  > Regards,
>  > >  > >  > Van
>  > >  > >  >
> =========================================================================
>  > >  > >  > Linux rocks!!!   http://www.dedserius.com
>  > >  > >  >
> =========================================================================
>  > >  > >  >
>  > >  > >  >
>  > >  > >  >
>  > >  > >  >
>  > >  > >
>  > >  > > Hi!
>  > >  > >
>  > >  > > One question only. Have you found out with which server was
> connection
>  > >  > > broken, the onde doing backup or restore ??
>  > >  > >
>  > >  > > Last but not  least, newer versions of MySQL do require
>  > >  > > glibc. Especially because pthreads !!
>  > >  > >
>  > >  > > Sinisa
>  > >  > >
>  > >  > Sinisa,
>  > >  > Thanks for the reply.  The server daemon on the machine doing the
> insert
>  > >  > from the mysqldump is the one that dies.  In other words:
>  > >  > Sedona has the master cdarchive database of 110,000 some rows. 
> Dbase
>  > >  > size is about 50Mbytes.
>  > >  > Scottsdale has an empty cdarchive database with no tables:
>  > >  >
>  > >  > scottsdale:~$ mysqldump -hsedona -C cdarchive | \
>  > >  > > mysql cdarchive -C -q
>  > >  > ERROR 2013 at line 1960: Lost connection to MySQL server during
> query
>  > >  >
>  > >  > If you'd like me to try it in the other direction, I can do so. 
> But,
>  > >  > it's interesting to note the directy mysqldump failed, as did a
> text
>  > >  > file mysqldump-ftp.to.client-cat.dumpfile.into.client.dbase ....
>  > >  >
>  > >  > Regards,
>  > >  > Van
>  > >  >
>  > >  >
>  > >
>  > > What is a difference if you do not use compression. Compression makes
>  > > no sense as it is used between local client / server, and not from
>  > > mysqldump to mysql !!!
>  > >
>  > > In that case,it is a falty zlib.
>  > >
>  > > Last but not least, what is difference il vars, specifically in
>  > > max_alowed packet ???
>  > Sinisa,
>  >
>  > There are 100:
>  > scottsdale:/usr/local/apache/logs# mysqladmin variables | grep max
>  > max_allowed_packet         | 1048576                         | |
>  > max_connections            | 100                             |
>  > max_connect_errors         | 10                              | |
>  > max_delayed_insert_threads | 20                              |
>  > max_join_size              | 4294967295                      | |
>  > max_sort_length            | 1024                            |
>  >
>  > Is there a way I can check how many connections I've got at any point in
>  > time?
>  > The only thing I could think to do would be:
>  > scottsdale:/usr/local/apache/logs# while true
>  > > do
>  > > mysqladmin extended | grep ax
>  > > done
>  >
>  > Is there a utility I'm missing?
>  >
>  > Thanks,
>  > Van
>  > --
>  > =========================================================================
>  > Linux rocks!!!   http://www.dedserius.com
>  > =========================================================================
>  >
> 
> You have all utilities.
> 
> Check out if it works without compression.
> 
> List vars for both machines if not using compression does not help.
> 
> Sinisa