[MDEV-19933] Server loses a part of configuration and some plugins are not activated due to pre-installed mysql-common Created: 2019-07-02  Updated: 2021-02-04  Resolved: 2020-06-14

Status: Closed
Project: MariaDB Server
Component/s: Configuration, Packaging, Platform Debian
Affects Version/s: 10.2, 10.3, 10.4
Fix Version/s: 10.5.4

Type: Bug Priority: Major
Reporter: Elena Stepanova Assignee: Otto Kekäläinen
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
PartOf
is part of MDEV-6284 Merge downstream Debian/Ubuntu packag... Closed
Relates
relates to MDEV-23061 Extra engines enabled through config ... Stalled

 Description   

Modern Debians/Ubuntus, e.g. Stretch or Bionic, have MySQL's mysql-common installed either right from the start with the system installation, or fairly quickly with some commonly used packages as a dependency:

ii  mysql-common                          5.8+1.0.4                         all          MySQL database common files, e.g. /etc/mysql/my.cnf

It installs my.cnf:

drwxr-xr-x 2 root root 4096 May 15  2018 conf.d
 
lrwxrwxrwx 1 root root   24 May 15  2018 my.cnf -> /etc/alternatives/my.cnf
 
-rw-r--r-- 1 root root  839 Aug  3  2016 my.cnf.fallback

The config is empty, it only includes conf.d:

!includedir /etc/mysql/conf.d/

When MariaDB (of any existing version) is installed, it doesn't override existing my.cnf, so whatever legacy stuff MariaDB usually has in it, doesn't get activated. It is not a big problem. However, it also means that the cnf file doesn't include mariadb.cnf, and thus doesn't include mariadb.conf.d, where some of separately packaged plugins install their config files. So, for example, when mariadb-plugin-cracklib-password-check or mariadb-plugin-rocksdb are installed, they don't get activated.

 Comments   
Comment by Sergei Golubchik [ 2019-10-30 ]

otto, using separate paths for mariadb configs came from downstream Debian packaging, as far as I remember. It was likely your decision in the first place.

What do you think we should do in this MDEV?

Comment by Otto Kekäläinen [ 2019-10-30 ]

Sure, I'll look into this in the near future

The config layout in Debian was jointly designed by different stakeholders so that MySQL and MariaDB could co-exists without upsetting anybody. The underlying problem here is the delay in closing the delta between official Debian packaging and MariaDB packaging. Now with unix socket authentication by default since MariaDB 10.4 and few other issues solved I expect the delta to be closed this year in time for 10.5 release.

Also, the fix needs to go into the mysql-common package in Debian (and Ubuntu) so, delivering it can take some time..

Comment by Otto Kekäläinen [ 2020-03-14 ]

I still have this on my TODO but the other Debian packaging merging needs to happen first so the smaller remaining details are easier to sort out.

Comment by Otto Kekäläinen [ 2020-04-23 ]

WIP in https://github.com/MariaDB/server/pull/1504

Comment by Otto Kekäläinen [ 2020-05-19 ]

Just for clarity, this is how I was able to reproduce this and the intermediate steps involved:

# Start Ubuntu Bionic, default repos only
 
apt install mysql-common
 
 
 
find /etc/mysql -ls
 
   256266      4 drwxr-xr-x   3 root     root         4096 May 19 15:05 /etc/mysql
 
   256330      4 drwxr-xr-x   2 root     root         4096 May 19 15:05 /etc/mysql/conf.d
 
   256332      4 -rw-r--r--   1 root     root           55 Aug  3  2016 /etc/mysql/conf.d/mysqldump.cnf
 
   256331      4 -rw-r--r--   1 root     root            8 Aug  3  2016 /etc/mysql/conf.d/mysql.cnf
 
   256046      0 lrwxrwxrwx   1 root     root           24 May 19 15:05 /etc/mysql/my.cnf -> /etc/alternatives/my.cnf
 
   256333      4 -rw-r--r--   1 root     root          839 Aug  3  2016 /etc/mysql/my.cnf.fallback
 
 
 
# Enable mariadb.org repository
 
apt install mariadb-server # does not pull in mysql-common
 
 
 
find /etc/mysql -ls
 
   256266      4 drwxr-xr-x   4 root     root         4096 May 19 15:06 /etc/mysql
 
   256330      4 drwxr-xr-x   2 root     root         4096 May 19 15:06 /etc/mysql/conf.d
 
   281171      4 -rw-r--r--   1 root     root           36 May 11 14:34 /etc/mysql/conf.d/mysqld_safe_syslog.cnf
 
   256332      4 -rw-r--r--   1 root     root           55 Aug  3  2016 /etc/mysql/conf.d/mysqldump.cnf
 
   256331      4 -rw-r--r--   1 root     root            8 Aug  3  2016 /etc/mysql/conf.d/mysql.cnf
 
   256046      0 lrwxrwxrwx   1 root     root           24 May 19 15:05 /etc/mysql/my.cnf -> /etc/alternatives/my.cnf
 
   281437      4 -rwxr-xr-x   1 root     root         1620 May 11 14:34 /etc/mysql/debian-start
 
   256333      4 -rw-r--r--   1 root     root          839 Aug  3  2016 /etc/mysql/my.cnf.fallback
 
   281479      4 -rw-------   1 root     root           60 May 19 15:06 /etc/mysql/debian.cnf
 
   256350      4 -rw-r--r--   1 root     root          527 May 11 14:34 /etc/mysql/mariadb.cnf
 
   256351      4 drwxr-xr-x   2 root     root         4096 May 11 14:37 /etc/mysql/mariadb.conf.d
 
 
 
apt install mysql-common # does not overwrite /etc/my.cnf
 
 
 
find /etc/mysql -ls
 
   256266      4 drwxr-xr-x   4 root     root         4096 May 19 15:07 /etc/mysql
 
   256330      4 drwxr-xr-x   2 root     root         4096 May 19 15:06 /etc/mysql/conf.d
 
   281171      4 -rw-r--r--   1 root     root           36 May 11 14:34 /etc/mysql/conf.d/mysqld_safe_syslog.cnf
 
   256332      4 -rw-r--r--   1 root     root           55 Aug  3  2016 /etc/mysql/conf.d/mysqldump.cnf
 
   256331      4 -rw-r--r--   1 root     root            8 Aug  3  2016 /etc/mysql/conf.d/mysql.cnf
 
   281565      8 -rw-r--r--   1 root     root         5170 May 11 14:34 /etc/mysql/my.cnf.dpkg-new
 
   256046      0 lrwxrwxrwx   1 root     root           24 May 19 15:05 /etc/mysql/my.cnf -> /etc/alternatives/my.cnf
 
   281437      4 -rwxr-xr-x   1 root     root         1620 May 11 14:34 /etc/mysql/debian-start
 
   256333      4 -rw-r--r--   1 root     root          839 Aug  3  2016 /etc/mysql/my.cnf.fallback
 
   281479      4 -rw-------   1 root     root           60 May 19 15:06 /etc/mysql/debian.cnf
 
   256350      4 -rw-r--r--   1 root     root          527 May 11 14:34 /etc/mysql/mariadb.cnf
 
   256351      4 drwxr-xr-x   2 root     root         4096 May 11 14:37 /etc/mysql/mariadb.conf.d

So our `my.cnf` ends up in `/etc/mysql/my.cnf.dpkg-new` and thus my.cnf stays wrong and does not load MariaDB parts.

Result:

mysql -uroot -prootpass --skip-column-names -e 'select plugin_name, plugin_status, plugin_type, plugin_library, plugin_license from information_schema.all_plugins where plugin_name not in ('\''SPIDER'\'') order by plugin_name, plugin_library'
 
+-------------------------------+---------------+---------------------+--------------------------+-----+
 
| ARCHIVE                       | NOT INSTALLED | STORAGE ENGINE      | ha_archive.so            | GPL |
 
| Aria                          | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| binlog                        | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| BLACKHOLE                     | NOT INSTALLED | STORAGE ENGINE      | ha_blackhole.so          | GPL |
 
| CLIENT_STATISTICS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| CSV                           | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| DISKS                         | NOT INSTALLED | INFORMATION SCHEMA  | disks.so                 | GPL |
 
| ed25519                       | NOT INSTALLED | AUTHENTICATION      | auth_ed25519.so          | GPL |
 
| FEDERATED                     | NOT INSTALLED | STORAGE ENGINE      | ha_federated.so          | GPL |
 
| FEDERATED                     | NOT INSTALLED | STORAGE ENGINE      | ha_federatedx.so         | GPL |
 
| FEEDBACK                      | DISABLED      | INFORMATION SCHEMA  | NULL                     | GPL |
 
| file_key_management           | NOT INSTALLED | ENCRYPTION          | file_key_management.so   | GPL |
 
| GEOMETRY_COLUMNS              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| handlersocket                 | NOT INSTALLED | DAEMON              | handlersocket.so         | BSD |
 
| INDEX_STATISTICS              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| inet6                         | ACTIVE        | DATA TYPE           | NULL                     | GPL |
 
| inet6_aton                    | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| inet6_ntoa                    | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| inet_aton                     | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| inet_ntoa                     | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| InnoDB                        | ACTIVE        | STORAGE ENGINE      | 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_CMP                    | 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_CMP_RESET              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_BEING_DELETED       | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_CONFIG              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_DELETED             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_INDEX_CACHE         | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_INDEX_TABLE         | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_LOCKS                  | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_LOCK_WAITS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_METRICS                | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_MUTEXES                | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_COLUMNS            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_DATAFILES          | 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_INDEXES            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_TABLES             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_TABLESPACES        | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_TABLESTATS         | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_VIRTUAL            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE        | INFORMATION SCHEMA  | NULL                     | BSD |
 
| INNODB_TRX                    | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| is_ipv4                       | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| is_ipv4_compat                | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| is_ipv4_mapped                | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| is_ipv6                       | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| LOCALES                       | NOT INSTALLED | INFORMATION SCHEMA  | locales.so               | BSD |
 
| MEMORY                        | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| METADATA_LOCK_INFO            | NOT INSTALLED | INFORMATION SCHEMA  | metadata_lock_info.so    | GPL |
 
| MRG_MyISAM                    | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| MyISAM                        | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| mysql_native_password         | ACTIVE        | AUTHENTICATION      | NULL                     | GPL |
 
| mysql_old_password            | ACTIVE        | AUTHENTICATION      | NULL                     | GPL |
 
| pam                           | NOT INSTALLED | AUTHENTICATION      | auth_pam.so              | GPL |
 
| pam                           | NOT INSTALLED | AUTHENTICATION      | auth_pam_v1.so           | GPL |
 
| partition                     | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| PERFORMANCE_SCHEMA            | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| QUERY_CACHE_INFO              | NOT INSTALLED | INFORMATION SCHEMA  | query_cache_info.so      | BSD |
 
| QUERY_RESPONSE_TIME           | NOT INSTALLED | INFORMATION SCHEMA  | query_response_time.so   | GPL |
 
| QUERY_RESPONSE_TIME_AUDIT     | NOT INSTALLED | AUDIT               | query_response_time.so   | GPL |
 
| SEQUENCE                      | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| SERVER_AUDIT                  | NOT INSTALLED | AUDIT               | server_audit.so          | GPL |
 
| simple_password_check         | NOT INSTALLED | PASSWORD VALIDATION | simple_password_check.so | GPL |
 
| SPATIAL_REF_SYS               | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| SPHINX                        | NOT INSTALLED | STORAGE ENGINE      | ha_sphinx.so             | GPL |
 
| SQL_ERROR_LOG                 | NOT INSTALLED | AUDIT               | sql_errlog.so            | GPL |
 
| SQL_SEQUENCE                  | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| TABLE_STATISTICS              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_GROUPS            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_QUEUES            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_STATS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_WAITS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| unix_socket                   | ACTIVE        | AUTHENTICATION      | NULL                     | GPL |
 
| USER_STATISTICS               | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| user_variables                | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| wsrep                         | ACTIVE        | REPLICATION         | NULL                     | GPL |
 
| WSREP_MEMBERSHIP              | NOT INSTALLED | INFORMATION SCHEMA  | wsrep_info.so            | GPL |
 
| WSREP_STATUS                  | NOT INSTALLED | INFORMATION SCHEMA  | wsrep_info.so            | GPL |
 
+-------------------------------+---------------+---------------------+--------------------------+-----+
 
 
 
cd /etc/mysql
 
mv my.cnf.dpkg-new my.cnf
 
systemctl restart mariadb
 
mysql -uroot -prootpass --skip-column-names -e 'select plugin_name, plugin_status, plugin_type, plugin_library, plugin_license from information_schema.all_plugins where plugin_name not in ('\''SPIDER'\'') order by plugin_name, plugin_library'
 
+-------------------------------+---------------+---------------------+--------------------------+-----+
 
| ARCHIVE                       | NOT INSTALLED | STORAGE ENGINE      | ha_archive.so            | GPL |
 
| Aria                          | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| binlog                        | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| BLACKHOLE                     | NOT INSTALLED | STORAGE ENGINE      | ha_blackhole.so          | GPL |
 
| CLIENT_STATISTICS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| CSV                           | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| DISKS                         | NOT INSTALLED | INFORMATION SCHEMA  | disks.so                 | GPL |
 
| ed25519                       | NOT INSTALLED | AUTHENTICATION      | auth_ed25519.so          | GPL |
 
| FEDERATED                     | NOT INSTALLED | STORAGE ENGINE      | ha_federated.so          | GPL |
 
| FEDERATED                     | NOT INSTALLED | STORAGE ENGINE      | ha_federatedx.so         | GPL |
 
| FEEDBACK                      | DISABLED      | INFORMATION SCHEMA  | NULL                     | GPL |
 
| file_key_management           | NOT INSTALLED | ENCRYPTION          | file_key_management.so   | GPL |
 
| GEOMETRY_COLUMNS              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| handlersocket                 | NOT INSTALLED | DAEMON              | handlersocket.so         | BSD |
 
| INDEX_STATISTICS              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| inet6                         | ACTIVE        | DATA TYPE           | NULL                     | GPL |
 
| inet6_aton                    | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| inet6_ntoa                    | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| inet_aton                     | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| inet_ntoa                     | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| InnoDB                        | ACTIVE        | STORAGE ENGINE      | 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_CMP                    | 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_CMP_RESET              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_BEING_DELETED       | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_CONFIG              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_DEFAULT_STOPWORD    | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_DELETED             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_INDEX_CACHE         | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_FT_INDEX_TABLE         | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_LOCKS                  | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_LOCK_WAITS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_METRICS                | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_MUTEXES                | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_COLUMNS            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_DATAFILES          | 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_INDEXES            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_SEMAPHORE_WAITS    | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_TABLES             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_TABLESPACES        | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_TABLESTATS         | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_SYS_VIRTUAL            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| INNODB_TABLESPACES_ENCRYPTION | ACTIVE        | INFORMATION SCHEMA  | NULL                     | BSD |
 
| INNODB_TRX                    | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| is_ipv4                       | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| is_ipv4_compat                | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| is_ipv4_mapped                | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| is_ipv6                       | ACTIVE        | FUNCTION            | NULL                     | GPL |
 
| LOCALES                       | NOT INSTALLED | INFORMATION SCHEMA  | locales.so               | BSD |
 
| MEMORY                        | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| METADATA_LOCK_INFO            | NOT INSTALLED | INFORMATION SCHEMA  | metadata_lock_info.so    | GPL |
 
| MRG_MyISAM                    | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| MyISAM                        | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| mysql_native_password         | ACTIVE        | AUTHENTICATION      | NULL                     | GPL |
 
| mysql_old_password            | ACTIVE        | AUTHENTICATION      | NULL                     | GPL |
 
| pam                           | NOT INSTALLED | AUTHENTICATION      | auth_pam.so              | GPL |
 
| pam                           | NOT INSTALLED | AUTHENTICATION      | auth_pam_v1.so           | GPL |
 
| partition                     | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| PERFORMANCE_SCHEMA            | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| QUERY_CACHE_INFO              | NOT INSTALLED | INFORMATION SCHEMA  | query_cache_info.so      | BSD |
 
| QUERY_RESPONSE_TIME           | NOT INSTALLED | INFORMATION SCHEMA  | query_response_time.so   | GPL |
 
| QUERY_RESPONSE_TIME_AUDIT     | NOT INSTALLED | AUDIT               | query_response_time.so   | GPL |
 
| SEQUENCE                      | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| SERVER_AUDIT                  | NOT INSTALLED | AUDIT               | server_audit.so          | GPL |
 
| simple_password_check         | NOT INSTALLED | PASSWORD VALIDATION | simple_password_check.so | GPL |
 
| SPATIAL_REF_SYS               | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| SPHINX                        | NOT INSTALLED | STORAGE ENGINE      | ha_sphinx.so             | GPL |
 
| SQL_ERROR_LOG                 | NOT INSTALLED | AUDIT               | sql_errlog.so            | GPL |
 
| SQL_SEQUENCE                  | ACTIVE        | STORAGE ENGINE      | NULL                     | GPL |
 
| TABLE_STATISTICS              | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_GROUPS            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_QUEUES            | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_STATS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| THREAD_POOL_WAITS             | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| unix_socket                   | ACTIVE        | AUTHENTICATION      | NULL                     | GPL |
 
| USER_STATISTICS               | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| user_variables                | ACTIVE        | INFORMATION SCHEMA  | NULL                     | GPL |
 
| wsrep                         | ACTIVE        | REPLICATION         | NULL                     | GPL |
 
| WSREP_MEMBERSHIP              | NOT INSTALLED | INFORMATION SCHEMA  | wsrep_info.so            | GPL |
 
| WSREP_STATUS                  | NOT INSTALLED | INFORMATION SCHEMA  | wsrep_info.so            | GPL |
 
+-------------------------------+---------------+---------------------+--------------------------+-----+

Comment by Otto Kekäläinen [ 2020-05-19 ]

Final fix ready at https://github.com/MariaDB/server/pull/1504/commits

Comment by Otto Kekäläinen [ 2020-06-12 ]

This was fixed for 10.5 in https://github.com/MariaDB/server/commit/680a13957c0fea0a69b35e54922df1bce0c5226d and https://github.com/MariaDB/server/commit/7c2079f600bacbd4d24762159550b3d40ad856c1 (double merge, I don't know how it happened).

I suspect this is such a big change, that we should not strive to backport it to earlier releases?

Comment by Sergei Golubchik [ 2020-06-13 ]

I think you're right let's not backport it. At least not now.

Comment by Otto Kekäläinen [ 2020-06-14 ]

Thus, this is now closed via 680a13957c0fea0a69b35e54922df1bce0c5226d and 7c2079f600bacbd4d24762159550b3d40ad856c1. Re-open if backporting is requested (for good reasons).

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