Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.1.10, 10.0(EOL), 10.1(EOL)
-
None
-
Linux
Description
I tried to upgrade the server 10.0.22 -> 10.1.10.
Old version was shutdown, but new failed to start:
2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch).
|
2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead.
|
2016-01-08 22:25:01 140188123334592 [Note] Server socket created on IP: '::'.
|
2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
|
2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
|
2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dhk.info' failed
|
2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
|
2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
|
2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dth.info' failed
|
2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
|
2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
|
2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dsg.info' failed
|
2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid
|
2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration
|
2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-delivery.info' failed
|
2016-01-08 22:25:01 140188123334592 [Warning] Reading of some Master_info entries failed
|
2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize multi master structures
|
2016-01-08 22:25:01 140188123334592 [ERROR] Aborting
|
I guess I can't use mysql_upgrade when the server is not running.
Attachments
Activity
Field | Original Value | New Value |
---|---|---|
Labels | need_feedback |
Attachment | log.txt [ 41405 ] |
Attachment | mysqld.cnf [ 41406 ] |
Attachment | relay.ls.txt.gz [ 41407 ] |
Attachment | master-info.txt [ 41408 ] |
Labels | need_feedback |
Labels | need_feedback |
Component/s | OTHER [ 10125 ] | |
Fix Version/s | N/A [ 14700 ] | |
Resolution | Incomplete [ 4 ] | |
Status | Open [ 1 ] | Closed [ 6 ] |
Assignee | Elena Stepanova [ elenst ] | |
Resolution | Incomplete [ 4 ] | |
Status | Closed [ 6 ] | Stalled [ 10000 ] |
Labels | need_feedback |
Attachment | master.info.example [ 41992 ] |
Status | Stalled [ 10000 ] | Confirmed [ 10101 ] |
Component/s | Replication [ 10100 ] | |
Component/s | OTHER [ 10125 ] | |
Fix Version/s | 10.0 [ 16000 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Fix Version/s | N/A [ 14700 ] | |
Affects Version/s | 10.0 [ 16000 ] | |
Affects Version/s | 10.1 [ 16100 ] | |
Assignee | Elena Stepanova [ elenst ] | Kristian Nielsen [ knielsen ] |
Environment | Linux, Multi-source replication | Linux |
Description |
I tried to upgrade the server 10.0.22 -> 10.1.10. Old version was shutdown, but new failed to start: {noformat} 2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2016-01-08 22:25:01 140188123334592 [Note] Server socket created on IP: '::'. 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dhk.info' failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dth.info' failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dsg.info' failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-delivery.info' failed 2016-01-08 22:25:01 140188123334592 [Warning] Reading of some Master_info entries failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize multi master structures 2016-01-08 22:25:01 140188123334592 [ERROR] Aborting {noformat} I guess I can't user mysql_upgrade when the server is not running. |
I tried to upgrade the server 10.0.22 -> 10.1.10.
Old version was shutdown, but new failed to start: {noformat} 2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Column last_update in table "mysql"."innodb_table_stats" is INT UNSIGNED NOT NULL but should be BINARY(4) NOT NULL (type mismatch). 2016-01-08 22:25:00 7f8017479700 InnoDB: Error: Fetch of persistent statistics requested for table "mysql"."gtid_slave_pos" but the required system tables mysql.innodb_table_stats and mysql.innodb_index_stats are not present or have unexpected structure. Using transient stats instead. 2016-01-08 22:25:01 140188123334592 [Note] Server socket created on IP: '::'. 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dhk.info' failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dth.info' failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-bob@002dsg.info' failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize master info using_gtid 2016-01-08 22:25:01 140188123334592 [ERROR] Error reading master configuration 2016-01-08 22:25:01 140188123334592 [ERROR] Initialized Master_info from 'master-delivery.info' failed 2016-01-08 22:25:01 140188123334592 [Warning] Reading of some Master_info entries failed 2016-01-08 22:25:01 140188123334592 [ERROR] Failed to initialize multi master structures 2016-01-08 22:25:01 140188123334592 [ERROR] Aborting {noformat} I guess I can't use mysql_upgrade when the server is not running. |
Attachment | MDEV-9383-100grama.sample [ 41993 ] | |
Attachment | MDEV-9383-ck.sample [ 41994 ] | |
Attachment | MDEV-9383-miss60.sample [ 41995 ] |
Summary | Upgrade 10.0.22 -> 10.1.10: unable to start | Server fails to read master.info after upgrade 10.0 -> 10.1 |
Fix Version/s | 10.1.14 [ 21804 ] | |
Fix Version/s | 10.0 [ 16000 ] | |
Fix Version/s | 10.1 [ 16100 ] | |
Resolution | Fixed [ 1 ] | |
Status | Confirmed [ 10101 ] | Closed [ 6 ] |
Workflow | MariaDB v3 [ 73534 ] | MariaDB v4 [ 149983 ] |
--skip-slave-start does not help