Failed to start PS 5.6.33, if you take backup with XB 2.3.5, prepare and restore with 2.4.4

Bug #1635268 reported by Shahriyar Rzayev
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Percona XtraBackup moved to https://jira.percona.com/projects/PXB
Status tracked in 2.4
2.4
Triaged
Medium
Unassigned

Bug Description

The test based on:

http://jenkins.percona.com/view/QA/job/PTB-run-percona-server-5.6-pxb-2.3.5-2.4.4/

Backups are taken using XB 2.3.5 prepared with XB 2.4.4.
Resulted:

2016/10/20 13:18:36.398241080 1037 ERROR : ptb_start_server(1) - server failed to start, with 0 and command ( PATH=/mnt/workspace/PTB-run-percona-server-5.6-pxb-2.3.5-2.4.4/Host/centos7-64/Percona-Server-5.6.33-rel79.0-Linux.x86_64.ssl101/bin:/mnt/workspace/PTB-run-percona-server-5.6-pxb-2.3.5-2.4.4/Host/centos7-64/Percona-Server-5.6.33-rel79.0-Linux.x86_64.ssl101/libexec:/usr/lib64/qt-3.3/bin:/usr/local/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/shahriyar.rzaev/.local/bin:/home/shahriyar.rzaev/bin; mysqld --defaults-file=/mnt/workspace/PTB-run-percona-server-5.6-pxb-2.3.5-2.4.4/Host/centos7-64/mnt/var/ps_5.6.33_sysbench/test-1/mysql.1/my.cnf &> /mnt/workspace/PTB-run-percona-server-5.6-pxb-2.3.5-2.4.4/Host/centos7-64/mnt/var/ps_5.6.33_sysbench/test-1/mysql.1/mysql.log & ) logfile:
2016/10/20 13:18:36.399140172 1037 ERROR : file at /mnt/workspace/PTB-run-percona-server-5.6-pxb-2.3.5-2.4.4/Host/centos7-64/mnt/var/ps_5.6.33_sysbench/test-1/mysql.1/mysql.log
2016-10-20 13:16:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2016-10-20 13:16:36 0 [Note] mysqld (mysqld 5.6.33-79.0-log) starting as process 1322 ...
2016-10-20 13:16:36 1322 [Note] Plugin 'FEDERATED' is disabled.
2016-10-20 13:16:36 1322 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-10-20 13:16:36 1322 [Note] InnoDB: The InnoDB memory heap is disabled
2016-10-20 13:16:36 1322 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2016-10-20 13:16:36 1322 [Note] InnoDB: Memory barrier is not used
2016-10-20 13:16:36 1322 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-10-20 13:16:36 1322 [Note] InnoDB: Using Linux native AIO
2016-10-20 13:16:36 1322 [Note] InnoDB: Using CPU crc32 instructions
2016-10-20 13:16:36 1322 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2016-10-20 13:16:36 1322 [Note] InnoDB: Completed initialization of buffer pool
2016-10-20 13:16:36 1322 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If you are attempting downgrade from MySQL 5.7.9 or later,
InnoDB: please refer to http://dev.mysql.com/doc/refman/5.6/en/upgrading-downgrading.html
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
2016-10-20 13:16:36 1322 [ERROR] Plugin 'InnoDB' init function returned error.
2016-10-20 13:16:36 1322 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-10-20 13:16:36 1322 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-10-20 13:16:36 1322 [ERROR] Aborting

Attached my.cnf and restore.log files

Tags: qa
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :
tags: added: qa
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Same is reproducible also with this config

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

2017-06-13 05:40:09 6197 [Note] Plugin 'FEDERATED' is disabled.
2017-06-13 05:40:09 6197 [Note] InnoDB: Using atomics to ref count buffer pool pages
2017-06-13 05:40:09 6197 [Note] InnoDB: The InnoDB memory heap is disabled
2017-06-13 05:40:09 6197 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2017-06-13 05:40:09 6197 [Note] InnoDB: Memory barrier is not used
2017-06-13 05:40:09 6197 [Note] InnoDB: Compressed tables use zlib 1.2.3
2017-06-13 05:40:09 6197 [Note] InnoDB: Using Linux native AIO
2017-06-13 05:40:09 6197 [Note] InnoDB: Using CPU crc32 instructions
2017-06-13 05:40:09 6197 [Note] InnoDB: Initializing buffer pool, size = 1.0G
2017-06-13 05:40:09 6197 [Note] InnoDB: Completed initialization of buffer pool
2017-06-13 05:40:09 6197 [Note] InnoDB: Opened 10 undo tablespaces
2017-06-13 05:40:09 6197 [Note] InnoDB: Highest supported file format is Barracuda.
InnoDB: No valid checkpoint found.
InnoDB: If you are attempting downgrade from MySQL 5.7.9 or later,
InnoDB: please refer to http://dev.mysql.com/doc/refman/5.6/en/upgrading-downgrading.html
InnoDB: If this error appears when you are creating an InnoDB database,
InnoDB: the problem may be that during an earlier attempt you managed
InnoDB: to create the InnoDB data files, but log file creation failed.
InnoDB: If that is the case, please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/error-creating-innodb.html
2017-06-13 05:40:09 6197 [ERROR] Plugin 'InnoDB' init function returned error.
2017-06-13 05:40:09 6197 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2017-06-13 05:40:09 6197 [ERROR] Unknown/unsupported storage engine: InnoDB
2017-06-13 05:40:09 6197 [ERROR] Aborting

Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :
Revision history for this message
Shahriyar Rzayev (rzayev-sehriyar) wrote :

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXB-768

To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.