[MDEV-14578] mysql_install_db --auth-root-authentication-method=socket fails to install unix_socket plugin - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
Affects Version/s: 10.2(EOL)
Fix Version/s: 10.2.16, 10.3.8
Component/s: Scripts & Clients
Labels:
- foundation
- patch
Environment:
ppc64le, SLES-12SP3

Description

mysql_install_db  --basedir=/usr/local/mariadb --defaults-file=~/my.cnf --skip-auth-anonymous-user --auth-root-authentication-method=socket  --auth-root-socket-user=danielgb

> mysqld --defaults-file=~/my.cnf

2017-12-04 23:14:10 0 [Note] mysqld (mysqld 10.3.3-MariaDB) starting as process 239421 ...

2017-12-04 23:14:10 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2017-12-04 23:14:10 0 [Note] InnoDB: Uses event mutexes

2017-12-04 23:14:10 0 [Note] InnoDB: Compressed tables use zlib 1.2.11

...

2017-12-04 23:20:08 0 [Note] mysqld: ready for connections.

Version: '10.3.3-MariaDB'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution

~> mysql -S /tmp/mysql.sock

ERROR 1524 (HY000): Plugin 'unix_socket' is not loaded

Expected result unix_socket loaded already.

Manual checking/installation.

> mysqld --defaults-file=~/my.cnf --skip-grant-tables

...

MariaDB [mysql]> show plugins;

+-------------------------------+----------+--------------------+---------+---------+

| Name                          | Status   | Type               | Library | License |

+-------------------------------+----------+--------------------+---------+---------+

| binlog                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |

| mysql_old_password            | ACTIVE   | AUTHENTICATION     | NULL    | GPL     |

| wsrep                         | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| CSV                           | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| MRG_MyISAM                    | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| CLIENT_STATISTICS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INDEX_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| TABLE_STATISTICS              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| USER_STATISTICS               | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| SQL_SEQUENCE                  | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_MUTEXES                | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL    | BSD     |

| INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL    | BSD     |

| Aria                          | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| SEQUENCE                      | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

| FEEDBACK                      | DISABLED | INFORMATION SCHEMA | NULL    | GPL     |

| user_variables                | ACTIVE   | INFORMATION SCHEMA | NULL    | GPL     |

| partition                     | ACTIVE   | STORAGE ENGINE     | NULL    | GPL     |

+-------------------------------+----------+--------------------+---------+---------+

53 rows in set (0.001 sec)

MariaDB [mysql]> INSTALL PLUGIN unix_socket SONAME 'auth_socket';

Query OK, 0 rows affected (0.001 sec)

Attachments

Issue Links

is blocked by

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")

Closed

relates to

MDEV-14367 /etc/logrotate.d/mysql-server failure - error: 'Plugin 'unix_socket' is not loaded'

Closed

Activity

Ascending order - Click to sort in descending order

View 8 older comments

Daniel Black added a comment - 2018-05-03 09:57

I wrote an IF NOT EXISTS implementation for PLUGINS https://github.com/grooverdan/mariadb-server/commit/dde02a0c6c360f039c037727de0325c1232ab71f .

Its failing with:

CURRENT_TEST: main.plugin_tmp

mysqltest: At line 9: query 'INSTALL PLUGIN IF NOT EXISTS example' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1

For every INSTALL PLUGIN command. It doesn't enter the install: code in sql_yacc.yy. I'm at a loss to why.

Any hints appreciated.

Daniel Black added a comment - 2018-05-03 09:57 I wrote an IF NOT EXISTS implementation for PLUGINS https://github.com/grooverdan/mariadb-server/commit/dde02a0c6c360f039c037727de0325c1232ab71f . Its failing with: CURRENT_TEST: main.plugin_tmp mysqltest: At line 9: query 'INSTALL PLUGIN IF NOT EXISTS example' failed: 1064: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '' at line 1 For every INSTALL PLUGIN command. It doesn't enter the install: code in sql_yacc.yy. I'm at a loss to why. Any hints appreciated.

Daniel Black added a comment - 2018-05-08 00:17

Fixed silly error with INSTALL PLUGIN IF NOT EXISTS logic thanks serg. PR at https://github.com/MariaDB/server/pull/747

Updated PR https://github.com/MariaDB/server/pull/514 to use this. Local tests passed for -DPLUGIN_AUTH_SOCKET=STATIC|NO|DYNAMIC cases. Its idpotent like previously and works on an installed instance.

Daniel Black added a comment - 2018-05-08 00:17 Fixed silly error with INSTALL PLUGIN IF NOT EXISTS logic thanks serg . PR at https://github.com/MariaDB/server/pull/747 Updated PR https://github.com/MariaDB/server/pull/514 to use this. Local tests passed for -DPLUGIN_AUTH_SOCKET=STATIC|NO|DYNAMIC cases. Its idpotent like previously and works on an installed instance.

Sergei Golubchik added a comment - 2018-05-17 16:08

I'd rather push INSTALL PLUGIN IF NOT EXISTS separately to 10.4 and just fixed the mysql_install_db in 10.2. Does that sound ok?

Sergei Golubchik added a comment - 2018-05-17 16:08 I'd rather push INSTALL PLUGIN IF NOT EXISTS separately to 10.4 and just fixed the mysql_install_db in 10.2. Does that sound ok?

Daniel Black added a comment - 2018-05-18 06:21 - edited

Have done the INSTALL PLUGIN IF NOT EXIST separately against 10.4 with warnings: https://github.com/MariaDB/server/pull/757

10.2 version https://github.com/MariaDB/server/pull/760 while successful in the way it was run in the commit messages hit the following during mtr:

build-mariadb-server-10.2]$ mysql-test/mtr --mem --parallel=10

Logging: /home/dan/repos/mariadb-server-10.2/mysql-test/mysql-test-run.pl  --mem --parallel=10

vardir: /home/dan/repos/build-mariadb-server-10.2/mysql-test/var

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_eD5E'

Checking supported features...

MariaDB Version 10.2.15-MariaDB

 - SSL connections supported

Using suites: main-,archive-,binlog-,binlog_encryption-,csv-,encryption-,federated-,funcs_1-,funcs_2-,gcol-,handler-,heap-,innodb-,innodb_fts-,innodb_gis-,innodb_zip-,json-,maria-,mariabackup-,multi_source-,optimizer_unfixed_bugs-,parts-,percona-,perfschema-,plugins-,roles-,rpl-,sys_vars-,unit-,vcol-,wsrep-,galera-,connect,mroonga/storage,mroonga/wrapper,rocksdb_rpl,rocksdb_sys_vars,rocksdb,sequence,sql_discovery,tokudb_parts,tokudb_mariadb,tokudb_sys_vars,tokudb_add_index,tokudb_bugs,tokudb_alter_table,tokudb,disks,metadata_lock_info,query_response_time,user_variables

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-18 16:14:09 140435135702848 [Note] /home/dan/repos/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.15-MariaDB) starting as process 18256 ...

2018-05-18 16:14:09 140435135702848 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182)

2018-05-18 16:14:09 140435135702848 [Warning] Changed limits: max_open_files: 1024  max_connections: 151 (was 151)  table_cache: 421 (was 2000)

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'SEQUENCE' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'partition' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Uses event mutexes

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Compressed tables use zlib 1.2.11

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Using Linux native AIO

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Number of pools: 1

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Using SSE2 crc32 instructions

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Completed initialization of buffer pool

2018-05-18 16:14:09 140434613597952 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority().

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created!

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ...

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: File './ibdata1' size is now 12 MB.

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting log file ./ib_logfile101 size to 5242880 bytes

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting log file ./ib_logfile1 size to 5242880 bytes

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: New log files created, LSN=45790

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Doublewrite buffer not found: creating new

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Doublewrite buffer created

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: 128 out of 128 rollback segments are active.

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating foreign key constraint system tables.

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating tablespace and datafile system tables.

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating sys_virtual system tables.

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating shared tablespace for temporary tables

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: File './ibtmp1' size is now 12 MB.

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Waiting for purge to start

2018-05-18 16:14:09 140435135702848 [Note] InnoDB: 5.7.22 started; log sequence number 0

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'Aria' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_LOCKS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_MUTEXES' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMPMEM' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_DELETED' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP_RESET' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'FEEDBACK' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'user_variables' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_TRX' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_TABLES' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_CONFIG' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_METRICS' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled.

2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled.

2018-05-18 16:14:09 140435135702848 [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_4750_0.MYI' (errno: 2 "No such file or directory")

2018-05-18 16:14:09 140435135702848 [ERROR] Aborting

I haven't looked into the cause of this however it seem quite far away from any code I've touched.

Daniel Black added a comment - 2018-05-18 06:21 - edited Have done the INSTALL PLUGIN IF NOT EXIST separately against 10.4 with warnings: https://github.com/MariaDB/server/pull/757 10.2 version https://github.com/MariaDB/server/pull/760 while successful in the way it was run in the commit messages hit the following during mtr: build-mariadb-server-10.2]$ mysql-test/mtr --mem --parallel=10 Logging: /home/dan/repos/mariadb-server-10.2/mysql-test/mysql-test-run.pl --mem --parallel=10 vardir: /home/dan/repos/build-mariadb-server-10.2/mysql-test/var 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_eD5E' Checking supported features... MariaDB Version 10.2.15-MariaDB - SSL connections supported Using suites: main-,archive-,binlog-,binlog_encryption-,csv-,encryption-,federated-,funcs_1-,funcs_2-,gcol-,handler-,heap-,innodb-,innodb_fts-,innodb_gis-,innodb_zip-,json-,maria-,mariabackup-,multi_source-,optimizer_unfixed_bugs-,parts-,percona-,perfschema-,plugins-,roles-,rpl-,sys_vars-,unit-,vcol-,wsrep-,galera-,connect,mroonga/storage,mroonga/wrapper,rocksdb_rpl,rocksdb_sys_vars,rocksdb,sequence,sql_discovery,tokudb_parts,tokudb_mariadb,tokudb_sys_vars,tokudb_add_index,tokudb_bugs,tokudb_alter_table,tokudb,disks,metadata_lock_info,query_response_time,user_variables 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-18 16:14:09 140435135702848 [Note] /home/dan/repos/build-mariadb-server-10.2/sql/mysqld (mysqld 10.2.15-MariaDB) starting as process 18256 ... 2018-05-18 16:14:09 140435135702848 [Warning] Could not increase number of max_open_files to more than 1024 (request: 4182) 2018-05-18 16:14:09 140435135702848 [Warning] Changed limits: max_open_files: 1024 max_connections: 151 (was 151) table_cache: 421 (was 2000) 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'SEQUENCE' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'partition' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Uses event mutexes 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Compressed tables use zlib 1.2.11 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Using Linux native AIO 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Number of pools: 1 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Using SSE2 crc32 instructions 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Completed initialization of buffer pool 2018-05-18 16:14:09 140434613597952 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: The first innodb_system data file 'ibdata1' did not exist. A new tablespace will be created! 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting file './ibdata1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: File './ibdata1' size is now 12 MB. 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting log file ./ib_logfile101 size to 5242880 bytes 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting log file ./ib_logfile1 size to 5242880 bytes 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: New log files created, LSN=45790 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Doublewrite buffer not found: creating new 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Doublewrite buffer created 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: 128 out of 128 rollback segments are active. 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating foreign key constraint system tables. 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating tablespace and datafile system tables. 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating sys_virtual system tables. 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Creating shared tablespace for temporary tables 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: File './ibtmp1' size is now 12 MB. 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: Waiting for purge to start 2018-05-18 16:14:09 140435135702848 [Note] InnoDB: 5.7.22 started; log sequence number 0 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'Aria' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_DATAFILES' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_TABLESTATS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_LOCKS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_MUTEXES' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMPMEM' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP_PER_INDEX' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_DELETED' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP_RESET' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_LOCK_WAITS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_TABLESPACES_ENCRYPTION' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_BUFFER_PAGE_LRU' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_FIELDS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMPMEM_RESET' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'FEEDBACK' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_COLUMNS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_INDEX_TABLE' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_CMP_PER_INDEX_RESET' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'user_variables' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_INDEX_CACHE' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_FOREIGN_COLS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_BEING_DELETED' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_BUFFER_POOL_STATS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_TRX' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_FOREIGN' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_TABLES' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_DEFAULT_STOPWORD' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_FT_CONFIG' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_BUFFER_PAGE' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_TABLESPACES' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_METRICS' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_INDEXES' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_SYS_VIRTUAL' is disabled. 2018-05-18 16:14:09 140435135702848 [Note] Plugin 'INNODB_TABLESPACES_SCRUBBING' is disabled. 2018-05-18 16:14:09 140435135702848 [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_4750_0.MYI' (errno: 2 "No such file or directory") 2018-05-18 16:14:09 140435135702848 [ERROR] Aborting I haven't looked into the cause of this however it seem quite far away from any code I've touched.

Daniel Black added a comment - 2018-05-23 05:24

resolved MTR issue in latest PR.

Daniel Black added a comment - 2018-05-23 05:24 resolved MTR issue in latest PR.

People

Assignee:: Sergei Golubchik

Reporter:: Daniel Black

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 2017-12-05 05:58

Updated:: 2018-06-21 08:15

Resolved:: 2018-06-21 07:14

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server