Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
5.5(EOL), 10.0(EOL), 10.1(EOL)
-
debian wheezy x86_64 with QUERY_RESPONSE_TIME plugin installed
-
10.1.9-1, 10.1.9-2
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)
Attachments
Issue Links
- relates to
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
-
-
- Closed
-
- links to
(1 links to)