Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Duplicate
-
None
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
|
Attachments
Issue Links
- blocks
-
MDEV-14578 mysql_install_db --auth-root-authentication-method=socket fails to install unix_socket plugin
- Closed