Web lists-archives.com

mysql V 8.0.12 and mysqdump




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