[MDEV-16255] reading information_schema.plugins during --bootstrap - mtr error: mysql-test/var/tmp/#sql_4d64_0.MYI' (errno: 2 "No such file or directory") Created: 2018-05-23  Updated: 2018-05-23  Resolved: 2018-05-23

Status: Closed
Project: MariaDB Server
Component/s: Information Schema
Affects Version/s: None
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Daniel Black Assignee: Unassigned
Resolution: Duplicate Votes: 0
Labels: bootstrap

Issue Links:
Blocks
blocks MDEV-14578 mysql_install_db --auth-root-authenti... Closed

 Description   

Add the following to scripts/mysql_system_tables.sql, (after the plugin table created) causes mtr to fail.

SET @auth_socket_installed=(SELECT COUNT(*) FROM information_schema.plugins where plugin_name='unix_socket');

result:

10.2-6e63db265f9c81518a144a0d4e89ea0ce09b3bd3

 
build-mariadb-server-10.2]$ mysql-test/mtr --mem  main.select
 
 
 
Logging: /home/dan/repos/mariadb-server-10.2/mysql-test/mysql-test-run.pl  --mem main.select
 
vardir: /home/dan/repos/build-mariadb-server-10.2/mysql-test/var
 
Checking leftover processes...
 
Removing old var directory...
 
Creating var directory '/home/dan/repos/build-mariadb-server-10.2/mysql-test/var'...
 
 - symlinking 'var' to '/dev/shm/var_auto_fnCD'
 
Checking supported features...
 
MariaDB Version 10.2.16-MariaDB
 
 - SSL connections supported
 
Collecting tests...
 
Installing system database...
 
mysql-test-run: *** ERROR: Error executing mysqld --bootstrap
 
Could not install system database from /home/dan/repos/build-mariadb-server-10.2/mysql-test/var/log/bootstrap.sql
 
The /home/dan/repos/build-mariadb-server-10.2/mysql-test/var/log/bootstrap.log file contains:
 
/home/dan/repos/build-mariadb-server-10.2/sql/mysqld --no-defaults --disable-getopt-prefix-matching --bootstrap --basedir=/home/dan/repos/mariadb-server-10.2 --datadir=/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/install.db --plugin-dir=/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/plugins --default-storage-engine=myisam --loose-skip-plugin-aria --loose-skip-plugin-feedback --loose-skip-plugin-innodb --loose-skip-plugin-innodb-buffer-page --loose-skip-plugin-innodb-buffer-page-lru --loose-skip-plugin-innodb-buffer-pool-stats --loose-skip-plugin-innodb-cmp --loose-skip-plugin-innodb-cmp-per-index --loose-skip-plugin-innodb-cmp-per-index-reset --loose-skip-plugin-innodb-cmp-reset --loose-skip-plugin-innodb-cmpmem --loose-skip-plugin-innodb-cmpmem-reset --loose-skip-plugin-innodb-ft-being-deleted --loose-skip-plugin-innodb-ft-config --loose-skip-plugin-innodb-ft-default-stopword --loose-skip-plugin-innodb-ft-deleted --loose-skip-plugin-innodb-ft-index-cache --loose-skip-plugin-innodb-ft-index-table --loose-skip-plugin-innodb-lock-waits --loose-skip-plugin-innodb-locks --loose-skip-plugin-innodb-metrics --loose-skip-plugin-innodb-mutexes --loose-skip-plugin-innodb-sys-columns --loose-skip-plugin-innodb-sys-datafiles --loose-skip-plugin-innodb-sys-fields --loose-skip-plugin-innodb-sys-foreign --loose-skip-plugin-innodb-sys-foreign-cols --loose-skip-plugin-innodb-sys-indexes --loose-skip-plugin-innodb-sys-semaphore-waits --loose-skip-plugin-innodb-sys-tables --loose-skip-plugin-innodb-sys-tablespaces --loose-skip-plugin-innodb-sys-tablestats --loose-skip-plugin-innodb-sys-virtual --loose-skip-plugin-innodb-tablespaces-encryption --loose-skip-plugin-innodb-tablespaces-scrubbing --loose-skip-plugin-innodb-trx --loose-skip-plugin-partition --loose-skip-plugin-sequence --loose-skip-plugin-user-variables --loose-innodb --loose-innodb-log-file-size=5M --disable-sync-frm --tmpdir=/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/tmp/ --core-file --console --lc-messages-dir=/home/dan/repos/build-mariadb-server-10.2/sql/share/ --character-sets-dir=/home/dan/repos/mariadb-server-10.2/sql/share/charsets
 
2018-05-23 13:52:45 139701921904448 [Note] /home/dan/repos/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.16-MariaDB) starting as process 19812 ...
 
2018-05-23 13:52:45 139701921904448 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)
 
2018-05-23 13:52:45 139701921904448 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'SEQUENCE' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'partition' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Uses event mutexes
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Compressed tables use zlib 1.2.11
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Using Linux native AIO
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Number of pools: 1
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Using SSE2 crc32 instructions
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Completed initialization of buffer pool
 
2018-05-23 13:52:45 139701401270016 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: File './ibdata1' size is now 12 MB.
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting log file ./ib_logfile101 size to 5242880 bytes
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting log file ./ib_logfile1 size to 5242880 bytes
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: New log files created, LSN=45790
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Doublewrite buffer not found: creating new
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Doublewrite buffer created
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: 128 out of 128 rollback segments are active.
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating foreign key constraint system tables.
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating tablespace and datafile system tables.
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating sys_virtual system tables.
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Creating shared tablespace for temporary tables
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: Waiting for purge to start
 
2018-05-23 13:52:45 139701921904448 [Note] InnoDB: 5.7.22 started; log sequence number 0
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'Aria' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_LOCKS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_MUTEXES' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMPMEM' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_DELETED' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'FEEDBACK' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'user_variables' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_TRX' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_METRICS' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.
 
2018-05-23 13:52:45 139701921904448 [Note] Plugin 'INNODB_SYS_SEMAPHORE_WAITS' is disabled.
 
ERROR: 1017  Can't find file: '/home/dan/repos/build-mariadb-server-10.2/mysql-test/var/tmp/#sql_4d64_0.MYI' (errno: 2 "No such file or directory")
 
2018-05-23 13:52:45 139701921904448 [ERROR] Aborting

5.5-6a04c2a1aa60e67c07d4e6ada63f65cc3b26a5a9

 
build-mariadb-server-5.5]$ mysql-test/mtr  --mem main.select
 
Logging: /home/dan/repos/mariadb-server-5.5/mysql-test/mysql-test-run.pl  --mem main.select
 
vardir: /home/dan/repos/build-mariadb-server-5.5/mysql-test/var
 
Checking leftover processes...
 
Removing old var directory...
 
Creating var directory '/home/dan/repos/build-mariadb-server-5.5/mysql-test/var'...
 
 - symlinking 'var' to '/dev/shm/var_auto_K7Rs'
 
Checking supported features...
 
MariaDB Version 5.5.61-MariaDB
 
Installing system database...
 
mysql-test-run: *** ERROR: Error executing mysqld --bootstrap
 
Could not install system database from /home/dan/repos/build-mariadb-server-5.5/mysql-test/var/tmp/bootstrap.sql
 
see /home/dan/repos/build-mariadb-server-5.5/mysql-test/var/log/bootstrap.log for errors
 
 
 
build-mariadb-server-5.5]$ cat /home/dan/repos/build-mariadb-server-5.5/mysql-test/var/log/bootstrap.log
 
/home/dan/repos/build-mariadb-server-5.5/sql/mysqld --no-defaults --bootstrap --basedir=/home/dan/repos/mariadb-server-5.5 --datadir=/home/dan/repos/build-mariadb-server-5.5/mysql-test/var/install.db --default-storage-engine=myisam --skip-aria --skip-innodb --skip-innodb-buffer-page --skip-innodb-buffer-page-lru --skip-innodb-buffer-pool-pages --skip-innodb-buffer-pool-pages-blob --skip-innodb-buffer-pool-pages-index --skip-innodb-buffer-pool-stats --skip-innodb-changed-pages --skip-innodb-cmp --skip-innodb-cmp-reset --skip-innodb-cmpmem --skip-innodb-cmpmem-reset --skip-innodb-index-stats --skip-innodb-lock-waits --skip-innodb-locks --skip-innodb-rseg --skip-innodb-sys-columns --skip-innodb-sys-fields --skip-innodb-sys-foreign --skip-innodb-sys-foreign-cols --skip-innodb-sys-indexes --skip-innodb-sys-stats --skip-innodb-sys-tables --skip-innodb-sys-tablestats --skip-innodb-table-stats --skip-innodb-trx --skip-innodb-undo-logs --skip-partition --skip-xtradb-admin-command --disable-sync-frm --tmpdir=/home/dan/repos/build-mariadb-server-5.5/mysql-test/var/tmp/ --core-file --lc-messages-dir=/home/dan/repos/build-mariadb-server-5.5/sql/share/ --character-sets-dir=/home/dan/repos/mariadb-server-5.5/sql/share/charsets
 
180523 13:58:31 [Note] /home/dan/repos/build-mariadb-server-5.5/sql/mysqld (mysqld 5.5.61-MariaDB) starting as process 19877 ...
 
180523 13:58:31 [Note] Plugin 'Aria' is disabled.
 
180523 13:58:31 [Note] Plugin 'InnoDB' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_RSEG' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_UNDO_LOGS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_TRX' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_CMP' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_CMP_RESET' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_CMPMEM' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_SYS_STATS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_TABLE_STATS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_INDEX_STATS' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_PAGES' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_PAGES_INDEX' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_PAGES_BLOB' is disabled.
 
180523 13:58:31 [Note] Plugin 'XTRADB_ADMIN_COMMAND' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_CHANGED_PAGES' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.
 
180523 13:58:31 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.
 
180523 13:58:31 [Note] Plugin 'partition' is disabled.
 
ERROR: 1017  Can't find file: '/home/dan/repos/build-mariadb-server-5.5/mysql-test/var/tmp/#sql_4da5_0' (errno: 20)
 
180523 13:58:31 [ERROR] Aborting
 
 
 
180523 13:58:31 [Note] /home/dan/repos/build-mariadb-server-5.5/sql/mysqld: Shutdown complete



 Comments   
Comment by Daniel Black [ 2018-05-23 ]

dup of MDEV-8025 probably

Generated at Thu Feb 08 08:27:32 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.