[MDEV-14578] mysql_install_db --auth-root-authentication-method=socket fails to install unix_socket plugin Created: 2017-12-05  Updated: 2018-06-21  Resolved: 2018-06-21

Status: Closed
Project: MariaDB Server
Component/s: Scripts & Clients
Affects Version/s: 10.2
Fix Version/s: 10.2.16, 10.3.8

Type: Bug Priority: Critical
Reporter: Daniel Black Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: foundation, patch
Environment:

ppc64le, SLES-12SP3

Issue Links:
Blocks
is blocked by MDEV-16255 reading information_schema.plugins du... Closed
Relates
relates to MDEV-14367 /etc/logrotate.d/mysql-server failure... Closed

 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)



 Comments   
Comment by Elena Stepanova [ 2017-12-11 ]

Technically, the help says "this requires the unix socket authentication plugin", it doesn't say it would install one.
However, since I don't know what was the initial idea behind the functionality, I'm passing it over to Kristian who added it.

Comment by Kristian Nielsen [ 2017-12-14 ]

This is primarily used by Debian packaging. (I did not add the functionality, merely cleaned up the (somewhat broken) Debian implementation and upstreamed it).

I'm not sure how Debian installs the unix socket plugin, but at least it needs to be kept in mind to stay compatible with the Debian packaging.

Comment by Daniel Black [ 2017-12-14 ]

Added quick patch on github. Tested with out of tree build for --auth-root-authentication-method=normal and socket.

I couldn't see how Debian installs the plugin.

debian/mariadb-server-10.3.postinst needs to be updated to use this functionality.

Also noted debian/additions/debian-start.inc.sh needs to check that plugin='' for its insecure root checks too. Note: otto

PS: was "unix sucket auth" intentional ref: scripts/mysql_system_tables_data.sql

Comment by Sergey Vojtovich [ 2018-04-10 ]

Overdue PR.

Comment by Sergei Golubchik [ 2018-04-24 ]

Our debian packages don't install it.

But upstream debian builds with -DPLUGIN_AUTH_SOCKET=STATIC.

Can your patch handle it or it'll break on upstream debian?

Comment by Daniel Black [ 2018-04-30 ]

Thanks for the hint.

https://github.com/MariaDB/server/pull/514/ updated to handle ERROR: 1968 Plugin 'unix_socket' already installed.

An INSTALL PLUGIN [IF NOT INSTALLED] syntax would of been nice, but alas reverted to a stored procedure.

Not installed case:

$ cmake -DPLUGIN_AUTH_SOCKET=NO ../mariadb-server-10.3/
 
...
 
 
 
$ scripts/mysql_install_db --datadir=/tmp/mysqldatadir-auth-none --auth-root-socket-user=dan --auth-root-authentication-method=socket --builddir=.  --srcdir=../mariadb-server-10.3
 
Installing MariaDB/MySQL system tables in '/tmp/mysqldatadir-auth-none' ...
 
ERROR: 1126  Can't open shared library '/home/dan/repos/build-mariadb-server-10.3/plugin/auth_socket/auth_socket.so' (errno: 2, cannot open shared object file: No such file or directory)
 
2018-04-30 10:57:56 0 [ERROR] Aborting

Unlike scripts/maria_add_gis_sp.sql.in I haven't done a bootstrap/nonbootstrap case (to account for differences in mysqld/mysql regarding DELIMITER). AFAIK only maria_add_gis_sp_bootstrap.sql is used.

Comment by Sergei Golubchik [ 2018-04-30 ]

Okay. I think it's fine to install unix_socket in the script, if this very script makes some user to use it. A good idea, even.

I don't quite like the rather eclectic style you use.
Stored procedure with condition handler, prepared statement and IF(@auth_root_socket, ...) ?

I'd rather remove them all. Like (totally untested):

IF exists(select 1 from information_schema.plugins where plugin_name='unix_socket' and @auth_root_socket is not null) THEN
 
  install soname auth_socket;
 
END IF

Although INSTALL PLUGIN IF NOT EXISTS would be cool, I agree.

Comment by Daniel Black [ 2018-05-01 ]

EDIT: not ready - MTR failure - https://travis-ci.org/grooverdan/mariadb-server/jobs/373309168#L6326 / and not idempotent (duplicate run hits 'ERROR: 1062 Duplicate entry 'unix_socket' for key 'PRIMARY'')

Forgot about information schema providing plugins. I was feeling pretty ghastly about the stored procedure too.

Tested corrected variant: https://github.com/MariaDB/server/pull/514/

    MDEV-14578: mysql_install_db install unix_socket plugin when --auth-root-authentication-method=socket
 
    
    $ cmake -DPLUGIN_AUTH_SOCKET=STATIC ../mariadb-server-10.3/
 
    
    $ scripts/mysql_install_db --datadir=/tmp/mysqldatadir-auth-static --auth-root-socket-user=dan --auth-root-authentication-method=socket --builddir=.  --srcdir=../mariadb-server-10.3
 
    Installing MariaDB/MySQL system tables in '/tmp/mysqldatadir-auth-static' ...
 
    OK
 
    
    $ client/mysql -S /tmp/mysql.sock -e 'show create user dan@localhost'
 
    +----------------------------------------------------------+
 
    | CREATE USER for dan@localhost                            |
 
    +----------------------------------------------------------+
 
    | CREATE USER 'dan'@'localhost' IDENTIFIED VIA unix_socket |
 
    +----------------------------------------------------------+
 
    
    $ cmake -DPLUGIN_AUTH_SOCKET=NO ../mariadb-server-10.3/
 
    $ scripts/mysql_install_db --datadir=/tmp/mysqldatadir-auth-none --auth-root-socket-user=dan --auth-root-authentication-method=socket --builddir=.  --srcdir=../mariadb-server-10.3
 
    Installing MariaDB/MySQL system tables in '/tmp/mysqldatadir-auth-none' ...
 
    ERROR: 1126  Can't open shared library '.../plugin/auth_socket/auth_socket.so' (errno: 2, cannot open shared object file: No such file or directory)
 
    2018-05-01 11:38:56 0 [ERROR] Aborting
 
    
    $ scripts/mysql_install_db --datadir=/tmp/mysqldatadir-auth-dyn --auth-root-socket-user=dan --auth-root-authentication-method=socket --builddir=.  --srcdir=../mariadb-server-10.3
 
    Installing MariaDB/MySQL system tables in '/tmp/mysqldatadir-auth-dyn' ...
 
    OK
 
    $ ./sql/mysqld  --datadir=/tmp/mysqldatadir-auth-dyn  --lc-messages-dir=${PWD}/sql/share --plugin-dir=./plugin/auth_socket/
 
    $ client/mysql -S /tmp/mysql.sock -e 'show create user dan@localhost'
 
    +----------------------------------------------------------+
 
    | CREATE USER for dan@localhost                            |
 
    +----------------------------------------------------------+
 
    | CREATE USER 'dan'@'localhost' IDENTIFIED VIA unix_socket |
 
    +----------------------------------------------------------+

Comment by Daniel Black [ 2018-05-03 ]

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.

Comment by Daniel Black [ 2018-05-08 ]

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.

Comment by Sergei Golubchik [ 2018-05-17 ]

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?

Comment by Daniel Black [ 2018-05-18 ]

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.

Comment by Daniel Black [ 2018-05-23 ]

resolved MTR issue in latest PR.

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