[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

Daniel Black created issue - 2017-12-05 05:58

Elena Stepanova added a comment - 2017-12-11 23:14

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.

Elena Stepanova added a comment - 2017-12-11 23:14 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.

Elena Stepanova made changes - 2017-12-11 23:16

Field	Original Value	New Value
Fix Version/s		10.3 [ 22126 ]
Affects Version/s		10.2 [ 14601 ]
Affects Version/s	10.3.3 [ 22644 ]
Assignee		Kristian Nielsen [ knielsen ]
Description	{noformat} 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 {noformat} Expected result unix_socket loaded already. Manual checking/installation. {noformat} > 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) {noformat}	{noformat} 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 {noformat} Expected result unix_socket loaded already. Manual checking/installation. {noformat} > 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) {noformat}

Elena Stepanova made changes - 2017-12-11 23:16

Status

Open [ 1 ]

Confirmed [ 10101 ]

Kristian Nielsen added a comment - 2017-12-14 17:49

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.

Kristian Nielsen added a comment - 2017-12-14 17:49 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.

Daniel Black made changes - 2017-12-14 23:21

Labels

foundation patch

Daniel Black added a comment - 2017-12-14 23:32 - edited

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

Daniel Black added a comment - 2017-12-14 23:32 - edited 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

Sergei Golubchik made changes - 2017-12-15 10:34

Assignee

Kristian Nielsen [ knielsen ]

Sergey Vojtovich [ svoj ]

Daniel Black made changes - 2018-02-26 07:38

Link

This issue relates to ~~MDEV-14367~~ [ ~~MDEV-14367~~ ]

Sergey Vojtovich made changes - 2018-03-23 16:22

Assignee

Sergey Vojtovich [ svoj ]

Vicentiu Ciorbaru [ cvicentiu ]

Sergey Vojtovich made changes - 2018-04-10 12:48

Priority

Major [ 3 ]

Critical [ 2 ]

Sergey Vojtovich added a comment - 2018-04-10 12:48

Overdue PR.

Sergey Vojtovich added a comment - 2018-04-10 12:48 Overdue PR.

Sergei Golubchik made changes - 2018-04-18 09:24

Assignee

Vicentiu Ciorbaru [ cvicentiu ]

Sergei Golubchik [ serg ]

Sergei Golubchik made changes - 2018-04-18 09:24

Status

Confirmed [ 10101 ]

In Review [ 10002 ]

Sergei Golubchik added a comment - 2018-04-24 14:03

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?

Sergei Golubchik added a comment - 2018-04-24 14:03 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?

Sergei Golubchik made changes - 2018-04-24 14:03

Labels

foundation patch

foundation need_feedback patch

Daniel Black added a comment - 2018-04-30 03:23

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.

Daniel Black added a comment - 2018-04-30 03:23 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.

Daniel Black made changes - 2018-04-30 03:24

Labels

foundation need_feedback patch

foundation patch

Sergei Golubchik added a comment - 2018-04-30 15:22

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.

Sergei Golubchik added a comment - 2018-04-30 15:22 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.

Sergei Golubchik made changes - 2018-04-30 15:23

Labels

foundation patch

foundation need_feedback patch

Daniel Black added a comment - 2018-05-01 01:57 - edited

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 |

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

Daniel Black added a comment - 2018-05-01 01:57 - edited 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 | +----------------------------------------------------------+

Daniel Black made changes - 2018-05-01 01:57

Labels

foundation need_feedback patch

foundation patch

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?

Sergei Golubchik made changes - 2018-05-17 16:09

Fix Version/s

10.2 [ 14601 ]

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 made changes - 2018-05-23 04:01

Link

This issue is blocked by ~~MDEV-16255~~ [ ~~MDEV-16255~~ ]

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.

Sergei Golubchik made changes - 2018-06-21 07:14

Fix Version/s		10.2.16 [ 23110 ]
Fix Version/s		10.3.8 [ 23113 ]
Fix Version/s	10.2 [ 14601 ]
Fix Version/s	10.3 [ 22126 ]
Resolution		Fixed [ 1 ]
Status	In Review [ 10002 ]	Closed [ 6 ]

Sergei Golubchik made changes - 2021-12-06 21:46

Workflow

MariaDB v3 [ 84302 ]

MariaDB v4 [ 153300 ]

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

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration