Details
Major
Description
Having a plugin variable in my.cnf, like query_response_time_stats=ON from the query response time plugin, prevents a mysql upgrade.
# aptitude install mariadb-server-10.0 The following partially installed packages will be configured: mariadb-server mariadb-server-10.0 No packages will be installed, upgraded, or removed. 0 packages upgraded, 0 newly installed, 0 to remove and 33 not upgraded. Need to get 0 B of archives. After unpacking 0 B will be used. Setting up mariadb-server-10.0 (10.0.20+maria-1~wheezy) ... [ ok ] Stopping MariaDB database server: mysqld. dpkg: error processing mariadb-server-10.0 (--configure): subprocess installed post-installation script returned error exit status 7 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.0 (= 10.0.20+maria-1~wheezy); however: Package mariadb-server-10.0 is not configured yet. dpkg: error processing mariadb-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mariadb-server-10.0 mariadb-server E: Sub-process /usr/bin/dpkg returned an error code (1) A package failed to install. Trying to recover: Setting up mariadb-server-10.0 (10.0.20+maria-1~wheezy) ... [ ok ] Stopping MariaDB database server: mysqld. dpkg: error processing mariadb-server-10.0 (--configure): subprocess installed post-installation script returned error exit status 7 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.0 (= 10.0.20+maria-1~wheezy); however: Package mariadb-server-10.0 is not configured yet. dpkg: error processing mariadb-server (--configure): dependency problems - leaving unconfigured Errors were encountered while processing: mariadb-server-10.0 mariadb-server
using:
export DEBIAN_SCRIPT_DEBUG=1
aptitude install mariadb-server-10.0
.... .... .... ++ /bin/echo -e 'USE mysql;\n' 'CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', ' ' dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', ' ' PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\'';' + install_plugins='USE mysql; CREATE TABLE IF NOT EXISTS plugin (name char(64) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', dl char(128) COLLATE utf8_bin NOT NULL DEFAULT '\'''\'', PRIMARY KEY (name)) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin COMMENT='\''MySQL plugins'\'';' + echo 'USE mysql; ALTER TABLE user CHANGE Password Password char(41) character set latin1 collate latin1_bin DEFAULT '\'''\'' NOT NULL;' + /usr/sbin/mysqld --bootstrap --user=mysql --disable-log-bin --skip-grant-tables --default-storage-engine=myisam + logger -p daemon.err -t mysqld_safe -i dpkg: error processing mariadb-server-10.0 (--configure): subprocess installed post-installation script returned error exit status 7 dpkg: dependency problems prevent configuration of mariadb-server: mariadb-server depends on mariadb-server-10.0 (= 10.0.20+maria-1~wheezy); however: Package mariadb-server-10.0 is not configured yet
so failure is where it tried to bootstrap the server.
The error log shows the complaint about an unidentified server variable, understandable when no plugins are loaded.
Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] /usr/sbin/mysqld (mysqld 10.0.20-MariaDB-1~wheezy-log) starting as process 17905 ... Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: Using mutexes to ref count buffer pool pages Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: The InnoDB memory heap is disabled Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: Memory barrier is not used Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: Compressed tables use zlib 1.2.7 Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: Using Linux native AIO Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: Using CPU crc32 instructions Jul 9 06:14:40 media1 mysqld_safe[17874]: 150709 6:14:40 [Note] InnoDB: Initializing buffer pool, size = 8.0G Jul 9 06:14:41 media1 mysqld_safe[17874]: 150709 6:14:41 [Note] InnoDB: Completed initialization of buffer pool Jul 9 06:14:41 media1 mysqld_safe[17874]: 150709 6:14:41 [Note] InnoDB: Highest supported file format is Barracuda. Jul 9 06:14:42 media1 mysqld_safe[17874]: 150709 6:14:42 [Note] InnoDB: 128 rollback segment(s) are active. Jul 9 06:14:42 media1 mysqld_safe[17874]: 150709 6:14:42 [Note] InnoDB: Waiting for purge to start Jul 9 06:14:42 media1 mysqld_safe[17874]: 150709 6:14:42 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.24-72.2 started; log sequence number 1381243811209 Jul 9 06:14:42 media1 mysqld_safe[17874]: 2015-07-09 06:14:42 7fe2f07f8700 InnoDB: Loading buffer pool(s) from /srv/mysql/ib_buffer_pool Jul 9 06:14:42 media1 mysqld_safe[17874]: 2015-07-09 06:14:42 7fe2f07f8700 InnoDB: Buffer pool(s) load completed at 150709 6:14:42 Jul 9 06:14:42 media1 mysqld_safe[17874]: 150709 6:14:42 [ERROR] /usr/sbin/mysqld: unknown variable 'query_response_time_stats=ON' Jul 9 06:14:42 media1 mysqld_safe[17874]: 150709 6:14:42 [ERROR] Aborting Jul 9 06:14:42 media1 mysqld_safe[17874]: Jul 9 06:14:42 media1 mysqld_safe[17874]: 150709 6:14:42 [Note] InnoDB: FTS optimize thread exiting. Jul 9 06:14:42 media1 mysqld_safe[17874]: 150709 6:14:42 [Note] InnoDB: Starting shutdown... Jul 9 06:14:42 media1 mysqld_safe[17874]: 2015-07-09 06:14:42 7fe2f07f8700 InnoDB: Dumping buffer pool(s) to /srv/mysql/ib_buffer_pool Jul 9 06:14:42 media1 mysqld_safe[17874]: 2015-07-09 06:14:42 7fe2f07f8700 InnoDB: Buffer pool(s) dump completed at 150709 6:14:42 Jul 9 06:14:45 media1 mysqld_safe[17874]: 150709 6:14:45 [Note] InnoDB: Shutdown completed; log sequence number 1381243811219 Jul 9 06:14:45 media1 mysqld_safe[17874]: 150709 6:14:45 [Note] /usr/sbin/mysqld: Shutdown complete
Removing the query_response_time_stats=ON from the config file was able to package configure and complete the server upgrade. I also hit this on 10.0.19 on a RHEL server too.
Possible solutions:
a) bootstrap ignores vars it doesn't understand
b) additional mysqld argument to ignore unrecognised vars.
c) moving plugin vars to
-plugins section (probably too ugly)
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
as a limited version of a), could ignore variables beginning with the select name from mysql.plugin name while in --bootstrap mode.
note - this actually prevents upgrades and its very hard from the description of the package failure to trace it back to the original cause.
The (a) solution raises the question why server is not allowed to ignore unknown variables at the first place. If it's considered too dangerous, probably for bootstrap it is too.
The existing workaround with 'loose-' prefix seems more flexible than (b) – it allows to select which unrecognized options can be bypassed, rather than do it unconditionally.
The (c) solution, in addition to very likely human errors, might cause problems, because as I understand bootstrap only ignores plugins from mysql.plugin, while those requested via plugin-load are still loaded, and skipping their variables might be undesirable.
That said, both (a) and (b) are still viable. Assigning to Sergei Golubchik for a decision.