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 seems it get stuck in this query: explain SELECT LOGFILE_GROUP_NAME, FILE_NAME, TOTAL_EXTENTS, INITIAL_SIZE, ENGINE, EXTRA FROM INFORMATION_SCHEMA.FILES WHERE FILE _TYPE = 'UNDO LOG' AND FILE_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IS NOT NULL AND LOGFILE_GROUP_NAME IN (SELECT DISTINCT LOGFILE_GROUP _NAME FROM INFORMATION_SCHEMA.FILES WHERE FILE_TYPE = 'DATAFILE' AND TABLESPACE_NAME IN (SELECT DISTINCT TABLESPACE_NAME FROM INFORMATIO N_SCHEMA.PARTITIONS WHERE TABLE_SCHEMA IN ('kpc'))) GROUP BY LOGFILE_GROUP_NAME, FILE_NAME, ENGINE, TOTAL_EXTENTS, INITIAL_SIZE ORDER BY LOGFILE_GROUP_NAME; +----+-------------+-------------+------------+--------+---------------------+---------------------+---------+-------------------------- ----+-------+----------+---------------------------------------------------------------+ | id | select_type | table | partitions | type | possible_keys | key | key_len | ref | rows | filtered | Extra | +----+-------------+-------------+------------+--------+---------------------+---------------------+---------+-------------------------- ----+-------+----------+---------------------------------------------------------------+ | 1 | SIMPLE | cat | NULL | index | PRIMARY | name | 194 | NULL | 1 | 100.00 | Using index; Using temporary; Using filesort; Start temporary | | 1 | SIMPLE | sch | NULL | eq_ref | PRIMARY,catalog_id | catalog_id | 202 | mysql.cat.id,const | 1 | 100.00 | Using index | | 1 | SIMPLE | tbl | NULL | ref | schema_id | schema_id | 8 | mysql.sch.id | 78 | 100.00 | Using where | | 1 | SIMPLE | part | NULL | ref | table_id,table_id_2 | table_id | 8 | mysql.tbl.id | 597 | 10.00 | Using where | | 1 | SIMPLE | part_ts | NULL | eq_ref | PRIMARY | PRIMARY | 8 | mysql.part.tablespace_id | 1 | 100.00 | NULL | | 1 | SIMPLE | ts | NULL | ALL | PRIMARY | NULL | NULL | NULL | 12605 | 100.00 | Using join buffer (Block Nested Loop) | | 1 | SIMPLE | tsf | NULL | ref | tablespace_id | tablespace_id | 8 | mysql.ts.id | 1 | 100.00 | Using where | | 1 | SIMPLE | sub_part | NULL | ref | parent_partition_id | parent_partition_id | 9 | mysql.part.id | 13152 | 100.00 | NULL | | 1 | SIMPLE | sub_part_ts | NULL | eq_ref | PRIMARY | PRIMARY | 8 | mysql.sub_part.tablespace _id | 1 | 100.00 | Using where | | 1 | SIMPLE | ts | NULL | eq_ref | PRIMARY,name | name | 779 | func | 1 | 100.00 | Using where | | 1 | SIMPLE | tsf | NULL | ref | tablespace_id | tablespace_id | 8 | mysql.ts.id | 1 | 100.00 | Using where; End temporary | +----+-------------+-------------+------------+--------+---------------------+---------------------+---------+-------------------------- ----+-------+----------+---------------------------------------------------------------+ The probelm seems to happen only when i dump the whole database, single tables are ok. re, wh -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql