CURRENT_TEST: innodb.innodb-multiple-tablespaces
|
mysqltest: At line 276: query 'DROP TABLE ynw' failed: 2013: Lost connection to MySQL server during query
|
The result from queries just before the failure was:
|
< snip >
|
---- MYSQL_TMP_DIR/new_dir/test
|
nwy.ibd
|
nyw.ibd
|
nyy.ibd
|
wny.ibd
|
www.ibd
|
ynw.ibd
|
yny.ibd
|
yyy.ibd
|
#
|
# Restart the server and DROP the tablespaces.
|
#
|
DROP TABLE yyy;
|
DROP TABLE nyy;
|
DROP TABLE yny;
|
DROP TABLE yyn;
|
DROP TABLE nyw;
|
DROP TABLE nwy;
|
DROP TABLE wny;
|
DROP TABLE ynw;
|
|
More results from queries before failure can be found in /home/alice/aliska/10.2/mysql-test/var/log/innodb-multiple-tablespaces.log
|
|
|
Server [mysqld.1 - pid: 31526, winpid: 31526, exit: 256] failed during test run
|
Server log from this test:
|
----------SERVER LOG START-----------
|
2017-11-14 14:37:34 140062716626752 [Note] /home/alice/aliska/10.2/sql/mysqld (mysqld 10.2.10-MariaDB-debug-log) starting as process 31448 ...
|
2017-11-14 14:37:34 140062716626752 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162)
|
2017-11-14 14:37:34 140062716626752 [Note] Plugin 'partition' is disabled.
|
2017-11-14 14:37:34 140062716626752 [Note] Plugin 'SEQUENCE' is disabled.
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Uses event mutexes
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Using Linux native AIO
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Number of pools: 1
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Using SSE2 crc32 instructions
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Completed initialization of buffer pool
|
2017-11-14 14:37:34 140062373181184 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2017-11-14 14:37:34 140062716626752 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-11-14 14:37:35 140062716626752 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2017-11-14 14:37:35 140062716626752 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2017-11-14 14:37:35 140062716626752 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2017-11-14 14:37:35 140062716626752 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2017-11-14 14:37:35 140062716626752 [Note] InnoDB: Waiting for purge to start
|
2017-11-14 14:37:35 140062716626752 [Note] InnoDB: 5.7.20 started; log sequence number 1633766
|
2017-11-14 14:37:35 140062079567616 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_auto_qiIB/mysqld.1/data/ib_buffer_pool
|
2017-11-14 14:37:35 140062079567616 [Note] InnoDB: Buffer pool(s) load completed at 171114 14:37:35
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_MUTEXES' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_CMP' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'FEEDBACK' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'user_variables' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
|
2017-11-14 14:37:35 140062716626752 [Warning] /home/alice/aliska/10.2/sql/mysqld: unknown option '--loose-pam-debug'
|
2017-11-14 14:37:35 140062716626752 [Note] Server socket created on IP: '127.0.0.1'.
|
2017-11-14 14:37:35 140062716626752 [Note] Reading of all Master_info entries succeded
|
2017-11-14 14:37:35 140062716626752 [Note] Added new Master_info '' to hash table
|
2017-11-14 14:37:35 140062716626752 [Note] /home/alice/aliska/10.2/sql/mysqld: ready for connections.
|
Version: '10.2.10-MariaDB-debug-log' socket: '/home/alice/aliska/10.2/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
2017-11-14 14:37:35 140062579476224 [Note] /home/alice/aliska/10.2/sql/mysqld (root[root] @ localhost []): Normal shutdown
|
|
2017-11-14 14:37:35 140062322824960 [Note] InnoDB: FTS optimize thread exiting.
|
2017-11-14 14:37:35 140062579476224 [Note] Event Scheduler: Purging the queue. 0 events
|
2017-11-14 14:37:35 140062579476224 [Note] InnoDB: Starting shutdown...
|
2017-11-14 14:37:35 140062079567616 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/var_auto_qiIB/mysqld.1/data/ib_buffer_pool
|
2017-11-14 14:37:35 140062079567616 [Note] InnoDB: Instance 0, restricted to 128 pages due to innodb_buf_pool_dump_pct=25
|
2017-11-14 14:37:35 140062079567616 [Note] InnoDB: Buffer pool(s) dump completed at 171114 14:37:35
|
2017-11-14 14:37:37 140062579476224 [Note] InnoDB: Shutdown completed; log sequence number 1691809
|
2017-11-14 14:37:37 140062579476224 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2017-11-14 14:37:37 140062579476224 [Note] Debug sync points hit: 2780
|
2017-11-14 14:37:37 140062579476224 [Note] Debug sync points executed: 0
|
2017-11-14 14:37:37 140062579476224 [Note] Debug sync points max active per thread: 0
|
2017-11-14 14:37:37 140062579476224 [Note] /home/alice/aliska/10.2/sql/mysqld: Shutdown complete
|
|
2017-11-14 14:37:37 140699182241600 [Note] /home/alice/aliska/10.2/sql/mysqld (mysqld 10.2.10-MariaDB-debug-log) starting as process 31495 ...
|
2017-11-14 14:37:37 140699182241600 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162)
|
2017-11-14 14:37:37 140699182241600 [Note] Plugin 'partition' is disabled.
|
2017-11-14 14:37:37 140699182241600 [Note] Plugin 'SEQUENCE' is disabled.
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Uses event mutexes
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Using Linux native AIO
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Number of pools: 1
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Using SSE2 crc32 instructions
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Completed initialization of buffer pool
|
2017-11-14 14:37:37 140698917508864 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2017-11-14 14:37:37 140699182241600 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nnn.ibd' OS error: 71
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Cannot open datafile for read-only: './test/nnn.ibd' OS error: 71
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Could not find a valid tablespace file for `test/nnn`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:38 140699182241600 [Warning] InnoDB: Ignoring tablespace for `test`.`nnn` because it could not be opened.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nwy.ibd' (id=4, flags=0x21); dictionary contains id=9, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/nwy` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nwy.ibd, Space ID=9, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nwy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: The InnoDB data dictionary table SYS_DATAFILES for tablespace ID 9 was updated to use file /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nwy.ibd.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nyw.ibd' (id=4, flags=0x21); dictionary contains id=8, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/nyw` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nyw.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nyw.ibd, Space ID=8, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/nyy` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Will not open tablespace `test/nyy`
|
2017-11-14 14:37:38 140699182241600 [Warning] InnoDB: Ignoring tablespace for `test`.`nyy` because it could not be opened.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/wny.ibd' OS error: 71
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load './test/wny.ibd' (id=4, flags=0x21); dictionary contains id=10, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/wny` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Default location: ./test/wny.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/wny.ibd, Space ID=10, Flags=33
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: The InnoDB data dictionary table SYS_DATAFILES for tablespace ID 10 was updated to use file /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/wny.ibd.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load './test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Could not find a valid tablespace file for `test/www`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:38 140699182241600 [Warning] InnoDB: Ignoring tablespace for `test`.`www` because it could not be opened.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load './test/wyn.ibd' (id=4, flags=0x21); dictionary contains id=12, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/wyn` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Default location: ./test/wyn.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/wyn.ibd, Space ID=12, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/ynw.ibd' OS error: 71
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/ynw.ibd' (id=4, flags=0x21); dictionary contains id=11, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/ynw` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Default location: ./test/ynw.ibd, Space ID=11, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/ynw.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: The InnoDB data dictionary table SYS_DATAFILES for tablespace ID 11 was updated to use file ./test/ynw.ibd.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yny.ibd' OS error: 71
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/yny` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Default location: ./test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Will not open tablespace `test/yny`
|
2017-11-14 14:37:38 140699182241600 [Warning] InnoDB: Ignoring tablespace for `test`.`yny` because it could not be opened.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/ywn.ibd' (id=4, flags=0x21); dictionary contains id=13, flags=0x21
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/ywn` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Default location: ./test/ywn.ibd, Space ID=13, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/ywn.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: The InnoDB data dictionary table SYS_DATAFILES for tablespace ID 13 was updated to use file ./test/ywn.ibd.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/yyn` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Default location: ./test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Will not open tablespace `test/yyn`
|
2017-11-14 14:37:38 140699182241600 [Warning] InnoDB: Ignoring tablespace for `test`.`yyn` because it could not be opened.
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: A tablespace for `test/yyy` has been found in multiple places;
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Default location: ./test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699182241600 [ERROR] InnoDB: Will not open tablespace `test/yyy`
|
2017-11-14 14:37:38 140699182241600 [Warning] InnoDB: Ignoring tablespace for `test`.`yyy` because it could not be opened.
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: Waiting for purge to start
|
2017-11-14 14:37:38 140699182241600 [Note] InnoDB: 5.7.20 started; log sequence number 1691809
|
2017-11-14 14:37:38 140698607142656 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_auto_qiIB/mysqld.1/data/ib_buffer_pool
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_MUTEXES' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_CMP' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'FEEDBACK' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'user_variables' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2017-11-14 14:37:38 140698607142656 [Note] InnoDB: Buffer pool(s) load completed at 171114 14:37:38
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
|
2017-11-14 14:37:38 140699182241600 [Warning] /home/alice/aliska/10.2/sql/mysqld: unknown option '--loose-pam-debug'
|
2017-11-14 14:37:38 140699182241600 [Note] Server socket created on IP: '127.0.0.1'.
|
2017-11-14 14:37:38 140699182241600 [Note] Reading of all Master_info entries succeded
|
2017-11-14 14:37:38 140699182241600 [Note] Added new Master_info '' to hash table
|
2017-11-14 14:37:38 140699182241600 [Note] /home/alice/aliska/10.2/sql/mysqld: ready for connections.
|
Version: '10.2.10-MariaDB-debug-log' socket: '/home/alice/aliska/10.2/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Failed to find tablespace for table `test`.`yyy` in the cache. Attempting to load the tablespace with space id 4
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: A tablespace for `test/yyy` has been found in multiple places;
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Default location: ./test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Will not open tablespace `test/yyy`
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Failed to find tablespace for table `test`.`nyy` in the cache. Attempting to load the tablespace with space id 5
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: A tablespace for `test/nyy` has been found in multiple places;
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Will not open tablespace `test/nyy`
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Failed to find tablespace for table `test`.`yny` in the cache. Attempting to load the tablespace with space id 6
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yny.ibd' OS error: 71
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: A tablespace for `test/yny` has been found in multiple places;
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Default location: ./test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Will not open tablespace `test/yny`
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Failed to find tablespace for table `test`.`yyn` in the cache. Attempting to load the tablespace with space id 7
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: A tablespace for `test/yyn` has been found in multiple places;
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Default location: ./test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Will not open tablespace `test/yyn`
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Failed to find tablespace for table `test`.`nnn` in the cache. Attempting to load the tablespace with space id 14
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nnn.ibd' OS error: 71
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Cannot open datafile for read-only: './test/nnn.ibd' OS error: 71
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Could not find a valid tablespace file for `test/nnn`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Failed to find tablespace for table `test`.`www` in the cache. Attempting to load the tablespace with space id 15
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Refusing to load './test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:38 140699036579584 [ERROR] InnoDB: Could not find a valid tablespace file for `test/www`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:38 140699036276480 [Note] /home/alice/aliska/10.2/sql/mysqld (root[root] @ localhost []): Normal shutdown
|
|
2017-11-14 14:37:38 140698724574976 [Note] InnoDB: FTS optimize thread exiting.
|
2017-11-14 14:37:38 140699036276480 [Note] Event Scheduler: Purging the queue. 0 events
|
2017-11-14 14:37:38 140699036276480 [Note] InnoDB: Starting shutdown...
|
2017-11-14 14:37:38 140698607142656 [Note] InnoDB: Dumping buffer pool(s) to /dev/shm/var_auto_qiIB/mysqld.1/data/ib_buffer_pool
|
2017-11-14 14:37:38 140698607142656 [Note] InnoDB: Instance 0, restricted to 128 pages due to innodb_buf_pool_dump_pct=25
|
2017-11-14 14:37:38 140698607142656 [Note] InnoDB: Buffer pool(s) dump completed at 171114 14:37:38
|
2017-11-14 14:37:39 140699036276480 [Note] InnoDB: Shutdown completed; log sequence number 1696070
|
2017-11-14 14:37:39 140699036276480 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
|
2017-11-14 14:37:39 140699036276480 [Note] Debug sync points hit: 702
|
2017-11-14 14:37:39 140699036276480 [Note] Debug sync points executed: 0
|
2017-11-14 14:37:39 140699036276480 [Note] Debug sync points max active per thread: 0
|
2017-11-14 14:37:39 140699036276480 [Note] /home/alice/aliska/10.2/sql/mysqld: Shutdown complete
|
|
2017-11-14 14:37:40 140080553346880 [Note] /home/alice/aliska/10.2/sql/mysqld (mysqld 10.2.10-MariaDB-debug-log) starting as process 31527 ...
|
2017-11-14 14:37:40 140080553346880 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4162)
|
2017-11-14 14:37:40 140080553346880 [Note] Plugin 'partition' is disabled.
|
2017-11-14 14:37:40 140080553346880 [Note] Plugin 'SEQUENCE' is disabled.
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: !!!!!!!! UNIV_DEBUG switched on !!!!!!!!!
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Uses event mutexes
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Compressed tables use zlib 1.2.8
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Using Linux native AIO
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Number of pools: 1
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Using SSE2 crc32 instructions
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Initializing buffer pool, total size = 8M, instances = 1, chunk size = 8M
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Completed initialization of buffer pool
|
2017-11-14 14:37:40 140080215746304 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
|
2017-11-14 14:37:40 140080553346880 [Note] InnoDB: Highest supported file format is Barracuda.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nnn.ibd' OS error: 71
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Cannot open datafile for read-only: './test/nnn.ibd' OS error: 71
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Could not find a valid tablespace file for `test/nnn`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:41 140080553346880 [Warning] InnoDB: Ignoring tablespace for `test`.`nnn` because it could not be opened.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: A tablespace for `test/nyy` has been found in multiple places;
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Will not open tablespace `test/nyy`
|
2017-11-14 14:37:41 140080553346880 [Warning] InnoDB: Ignoring tablespace for `test`.`nyy` because it could not be opened.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Refusing to load './test/wny.ibd' (id=4, flags=0x21); dictionary contains id=10, flags=0x21
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: A tablespace for `test/wny` has been found in multiple places;
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Default location: ./test/wny.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/wny.ibd, Space ID=10, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Refusing to load './test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Refusing to load '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/www.ibd' (id=4, flags=0x21); dictionary contains id=15, flags=0x21
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Could not find a valid tablespace file for `test/www`. Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:41 140080553346880 [Warning] InnoDB: Ignoring tablespace for `test`.`www` because it could not be opened.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Refusing to load './test/wyn.ibd' (id=4, flags=0x21); dictionary contains id=12, flags=0x21
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: A tablespace for `test/wyn` has been found in multiple places;
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Default location: ./test/wyn.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/wyn.ibd, Space ID=12, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yny.ibd' OS error: 71
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: A tablespace for `test/yny` has been found in multiple places;
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Default location: ./test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Will not open tablespace `test/yny`
|
2017-11-14 14:37:41 140080553346880 [Warning] InnoDB: Ignoring tablespace for `test`.`yny` because it could not be opened.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: A tablespace for `test/yyn` has been found in multiple places;
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Default location: ./test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Will not open tablespace `test/yyn`
|
2017-11-14 14:37:41 140080553346880 [Warning] InnoDB: Ignoring tablespace for `test`.`yyn` because it could not be opened.
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: A tablespace for `test/yyy` has been found in multiple places;
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Default location: ./test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080553346880 [ERROR] InnoDB: Will not open tablespace `test/yyy`
|
2017-11-14 14:37:41 140080553346880 [Warning] InnoDB: Ignoring tablespace for `test`.`yyy` because it could not be opened.
|
2017-11-14 14:37:41 140080553346880 [Note] InnoDB: 128 out of 128 rollback segments are active.
|
2017-11-14 14:37:41 140080553346880 [Note] InnoDB: Creating shared tablespace for temporary tables
|
2017-11-14 14:37:41 140080553346880 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
|
2017-11-14 14:37:41 140080553346880 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
|
2017-11-14 14:37:41 140080553346880 [Note] InnoDB: Waiting for purge to start
|
2017-11-14 14:37:41 140080553346880 [Note] InnoDB: 5.7.20 started; log sequence number 1696070
|
2017-11-14 14:37:41 140080047957760 [Note] InnoDB: Loading buffer pool(s) from /dev/shm/var_auto_qiIB/mysqld.1/data/ib_buffer_pool
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_MUTEXES' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_CMP' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'FEEDBACK' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'user_variables' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
|
2017-11-14 14:37:41 140080047957760 [Note] InnoDB: Buffer pool(s) load completed at 171114 14:37:41
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
|
2017-11-14 14:37:41 140080553346880 [Warning] /home/alice/aliska/10.2/sql/mysqld: unknown option '--loose-pam-debug'
|
2017-11-14 14:37:41 140080553346880 [Note] Server socket created on IP: '127.0.0.1'.
|
2017-11-14 14:37:41 140080553346880 [Note] Reading of all Master_info entries succeded
|
2017-11-14 14:37:41 140080553346880 [Note] Added new Master_info '' to hash table
|
2017-11-14 14:37:41 140080553346880 [Note] /home/alice/aliska/10.2/sql/mysqld: ready for connections.
|
Version: '10.2.10-MariaDB-debug-log' socket: '/home/alice/aliska/10.2/mysql-test/var/tmp/mysqld.1.sock' port: 16000 Source distribution
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Failed to find tablespace for table `test`.`yyy` in the cache. Attempting to load the tablespace with space id 4
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: A tablespace for `test/yyy` has been found in multiple places;
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Default location: ./test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyy.ibd, Space ID=4, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Will not open tablespace `test/yyy`
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Table test/yyy in the InnoDB data dictionary has tablespace id 4, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Deleting /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyy.ibd
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Removed datafile /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyy.ibd for table test/yyy
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Failed to find tablespace for table `test`.`nyy` in the cache. Attempting to load the tablespace with space id 5
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: A tablespace for `test/nyy` has been found in multiple places;
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Dictionary location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nyy.ibd, Space ID=5, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Will not open tablespace `test/nyy`
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Table test/nyy in the InnoDB data dictionary has tablespace id 5, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Deleting /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nyy.ibd
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Removed datafile /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/nyy.ibd for table test/nyy
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Failed to find tablespace for table `test`.`yny` in the cache. Attempting to load the tablespace with space id 6
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Operating system error number 2 in a file operation.
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: The error means the system cannot find the path specified.
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Cannot open datafile for read-only: '/home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yny.ibd' OS error: 71
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: A tablespace for `test/yny` has been found in multiple places;
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Default location: ./test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/new_dir/test/yny.ibd, Space ID=6, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Will not open tablespace `test/yny`
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Table test/yny in the InnoDB data dictionary has tablespace id 6, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Deleting /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yny.ibd
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Removed datafile /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yny.ibd for table test/yny
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Failed to find tablespace for table `test`.`yyn` in the cache. Attempting to load the tablespace with space id 7
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: A tablespace for `test/yyn` has been found in multiple places;
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Default location: ./test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Remote location: /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyn.ibd, Space ID=7, Flags=33
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Will not open tablespace `test/yyn`
|
2017-11-14 14:37:41 140080298579712 [ERROR] InnoDB: Table test/yyn in the InnoDB data dictionary has tablespace id 7, but tablespace with that id or name does not exist. Have you deleted or moved .ibd files?
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Please refer to http://dev.mysql.com/doc/refman/5.7/en/innodb-troubleshooting-datadict.html for how to resolve the issue.
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Deleting /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyn.ibd
|
2017-11-14 14:37:41 140080298579712 [Note] InnoDB: Removed datafile /home/alice/aliska/10.2/mysql-test/var/tmp/alt_dir/test/yyn.ibd for table test/yyn
|
2017-11-14 14:37:41 0x7f66fc6fd700 InnoDB: Assertion failure in file /home/alice/aliska/10.2/storage/innobase/row/row0mysql.cc line 4038
|
InnoDB: Failing assertion: table->data_dir_path
|
InnoDB: We intentionally generate a memory trap.
|
InnoDB: Submit a detailed bug report to https://jira.mariadb.org/
|
InnoDB: If you get repeated assertion failures or crashes, even
|
InnoDB: immediately after the mysqld startup, there may be
|
InnoDB: corruption in the InnoDB tablespace. Please refer to
|
InnoDB: http://dev.mysql.com/doc/refman/5.7/en/forcing-innodb-recovery.html
|
InnoDB: about forcing recovery.
|
171114 14:37:41 [ERROR] mysqld got signal 6 ;
|
This could be because you hit a bug. It is also possible that this binary
|
or one of the libraries it was linked against is corrupt, improperly built,
|
or misconfigured. This error can also be caused by malfunctioning hardware.
|
|
To report this bug, see https://mariadb.com/kb/en/reporting-bugs
|
|
We will try our best to scrape up some info that will hopefully help
|
diagnose the problem, but since we have already crashed,
|
something is definitely wrong and this may fail.
|
|
Server version: 10.2.10-MariaDB-debug-log
|
key_buffer_size=1048576
|
read_buffer_size=131072
|
max_used_connections=1
|
max_threads=153
|
thread_count=7
|
It is possible that mysqld could use up to
|
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 63152 K bytes of memory
|
Hope that's ok; if not, decrease some variables in the equation.
|
|
Thread pointer: 0x7f66b8000a98
|
Attempting backtrace. You can use the following information to find out
|
where mysqld died. If you see no messages after this, something went
|
terribly wrong...
|
stack_bottom = 0x7f66fc6fce70 thread_stack 0x49000
|
/home/alice/aliska/10.2/sql/mysqld(my_print_stacktrace+0x38)[0x558f4936a4df]
|
/home/alice/aliska/10.2/sql/mysqld(handle_fatal_signal+0x3a3)[0x558f48bfbd62]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x11390)[0x7f670a6ec390]
|
/lib/x86_64-linux-gnu/libc.so.6(gsignal+0x38)[0x7f6709aa5428]
|
/lib/x86_64-linux-gnu/libc.so.6(abort+0x16a)[0x7f6709aa702a]
|
mysys/stacktrace.c:267(my_print_stacktrace)[0x558f490664df]
|
row/row0mysql.cc:4041(row_drop_table_for_mysql(char const*, trx_t*, bool, unsigned long, bool))[0x558f48f96411]
|
handler/ha_innodb.cc:13672(ha_innobase::delete_table(char const*))[0x558f48e5bbd4]
|
sql/handler.cc:4336(handler::ha_delete_table(char const*))[0x558f48c07168]
|
sql/handler.cc:2350(ha_delete_table(THD*, handlerton*, char const*, char const*, char const*, bool))[0x558f48c01b45]
|
sql/sql_table.cc:2467(mysql_rm_table_no_locks(THD*, TABLE_LIST*, bool, bool, bool, bool, bool))[0x558f48a4e3e5]
|
sql/sql_table.cc:2086(mysql_rm_table(THD*, TABLE_LIST*, char, char))[0x558f48a4d600]
|
sql/sql_parse.cc:4731(mysql_execute_command(THD*))[0x558f489910ff]
|
sql/sql_parse.cc:7861(mysql_parse(THD*, char*, unsigned int, Parser_state*, bool, bool))[0x558f4899aee5]
|
sql/sql_parse.cc:1807(dispatch_command(enum_server_command, THD*, char*, unsigned int, bool, bool))[0x558f48988bb2]
|
sql/sql_parse.cc:1360(do_command(THD*))[0x558f48987509]
|
sql/sql_connect.cc:1354(do_handle_one_connection(CONNECT*))[0x558f48ad497e]
|
sql/sql_connect.cc:1261(handle_one_connection)[0x558f48ad46fe]
|
perfschema/pfs.cc:1865(pfs_spawn_thread)[0x558f48e30256]
|
/lib/x86_64-linux-gnu/libpthread.so.0(+0x76ba)[0x7f670a6e26ba]
|
/lib/x86_64-linux-gnu/libc.so.6(clone+0x6d)[0x7f6709b773dd]
|
|
Trying to get some variables.
|
Some pointers may be invalid and cause the dump to abort.
|
Query (0x7f66b8019f20): DROP TABLE ynw
|
Connection ID (thread ID): 8
|
Status: NOT_KILLED
|
|
Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,index_condition_pushdown=on,derived_merge=on,derived_with_keys=on,firstmatch=on,loosescan=on,materialization=on,in_to_exists=on,semijoin=on,partial_match_rowid_merge=on,partial_match_table_scan=on,subquery_cache=on,mrr=off,mrr_cost_based=off,mrr_sort_keys=off,outer_join_with_cache=on,semijoin_with_cache=on,join_cache_incremental=on,join_cache_hashed=on,join_cache_bka=on,optimize_join_buffer_size=off,table_elimination=on,extended_keys=on,exists_to_in=on,orderby_uses_equalities=on,condition_pushdown_for_derived=on
|
|
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
|
information that should help you find out what is causing the crash.
|
Writing a core file
|
----------SERVER LOG END-------------
|