Re: mysql V 8.0.12 and mysqdump
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben: > > > 2019/02/08 10:32 ... Walter Harms: > > Hello list, > > i run into an unexpected problem with mysqldump: > > > > mysqldump --version > > mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) > > > > > > when i try it results in: > > mysqldump: Error: 'Lost connection to MySQL server during query' when trying > > to > > dump tablespaces > > mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL > > server has gone away (2006) > > I regulary hav this problem with the command-line client (mysql.exe) and > when I asked R H gave this answer (and with the command-line client it > is much less imporant): > > Forwarded Message I found a solution with this (to set for mysqld in my.cnf): wait_timeout = 31536000 It sets the time out very high and mysqldump can now complet the query. personaly i would say this is not a propper solution as it does not solve the problem of an sql statement taking 15min to complet. re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql V 8.0.12 and mysqdump
> Halaasz Saandor hat am 9. Februar 2019 um 10:01 geschrieben: > > > 2019/02/08 10:32 ... Walter Harms: > > Hello list, > > i run into an unexpected problem with mysqldump: > > > > mysqldump --version > > mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) > > > > > > when i try it results in: > > mysqldump: Error: 'Lost connection to MySQL server during query' when trying > > to > > dump tablespaces > > mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL > > server has gone away (2006) > > I regulary hav this problem with the command-line client (mysql.exe) and > when I asked R H gave this answer (and with the command-line client it > is much less imporant): > > Forwarded Message > Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during > query > Date: Mon, 06 Jan 2014 17:07:45 +0100 > From: Reindl Harald > > > 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 > I do not thing so, it is onvoius that the sql statement i postet is rediciusly slow, causing mysqldump to terminate the connection. What anoys me most is the fact that the result is empty. So i could remove it from the code, but i have no idea about the consequences. NTL i will try max_allowed_packet and see what will happen. re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql V 8.0.12 and mysqdump
2019/02/08 10:32 ... Walter Harms: Hello list, i run into an unexpected problem with mysqldump: mysqldump --version mysqldump Ver 8.0.12 for Linux on x86_64 (MySQL Community Server - GPL) when i try it results in: mysqldump: Error: 'Lost connection to MySQL server during query' when trying to dump tablespaces mysqldump: Couldn't execute 'SHOW VARIABLES LIKE 'ndbinfo\_version'': MySQL server has gone away (2006) I regulary hav this problem with the command-line client (mysql.exe) and when I asked R H gave this answer (and with the command-line client it is much less imporant): Forwarded Message Subject: Re: ERROR 2013 (HY000): Lost connection to MySQL server during query Date: Mon, 06 Jan 2014 17:07:45 +0100 From: Reindl Harald 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql