Cannot Upgrade from 5.7 datadir
General
Escalation
General
Escalation
Description
Environment
None
Smart Checklist
Activity
Show:
Lalit Choudhary March 26, 2020 at 8:43 AM
Hi Mattew,
Thank you for the test and report.
Issue no more reproduciable with 8.0.18-9.1.rc
Tested Upgrade from pxc 5.7.28 ---> pxc 8.0.18-9.1.rc with same configuration.
2020-03-26T08:34:36.455564Z 0 [ERROR] [MY-000067] [Server] unknown variable 'ignore-db-dir=xtrabackup_backupfiles'.
2020-03-26T08:34:36.455902Z 0 [ERROR] [MY-010119] [Server] Aborting
ignore-db-dir: Treat directory as nondatabase directory. Removed in MySQL 8.0.0.
after removing ignore-db-dir mysqld service started sucessfully.
Log of wsrep recovery (--wsrep-recover):
INFO: WSREP: Running position recovery with --log_error='/var/lib/mysql/wsrep_recovery_verbose.tAGUxd' --pid-file='/var/lib/mysql/node3-recover.pid'
INFO: WSREP: Recovered position 00000000-0000-0000-0000-000000000000:-1
2020-03-26T08:37:41.620910Z 0 [Warning] [MY-000000] [WSREP] Node is not a cluster node. Disabling pxc_strict_mode
2020-03-26T08:37:41.620971Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18-9) starting as process 6631
2020-03-26T08:37:42.679302Z 4 [System] [MY-000000] [WSREP] PXC upgrade completed successfully
2020-03-26T08:37:42.927551Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-03-26T08:37:42.944586Z 0 [Note] [MY-000000] [WSREP] Initialized wsrep sidno 2
2020-03-26T08:37:42.944610Z 0 [Note] [MY-000000] [WSREP] wsrep_init_schema_and_SR (nil)
2020-03-26T08:37:42.977452Z 0 [Note] [MY-000000] [Galera] Loading provider none initial position: 00000000-0000-0000-0000-000000000000:-1
2020-03-26T08:37:42.977489Z 0 [Note] [MY-000000] [Galera] wsrep_load(): loading provider library 'none'
2020-03-26T08:37:42.977719Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.18-9' socket: '/var/lib/mysql/mysql.sock' port: 3306 Percona XtraDB Cluster (GPL), Release rel9, Revision a34c3d3, WSREP version 26.4.3.
2020-03-26T08:37:43.178392Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/lib/mysql/mysqlx.sock' bind-address: '::' port: 33060Matthew Boehm February 27, 2020 at 3:50 AM
Have AMI that you can use for repeatable test case. Please ping me on Slack for access.
Cannot Reproduce
Details
Assignee
UnassignedUnassignedReporter
Matthew BoehmMatthew BoehmAffects versions
Priority
Medium
Details
Details
Assignee
Unassigned
UnassignedReporter
Matthew Boehm
Matthew BoehmAffects versions
Priority
MediumSmart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Smart Checklist
Open Smart Checklist
Created February 27, 2020 at 3:49 AM
Updated March 26, 2020 at 8:44 AM
Resolved March 26, 2020 at 8:44 AM
Have a 5.7 datadir.
Attempting to start PXC 8.0.15 on CLI with the following config:
[client] user = "root" password = "Perc0na1234#" socket = /var/lib/mysql/mysql.sock[mysqld] user = mysql datadir = /var/lib/mysql socket = /var/lib/mysql/mysql.sock pid-file = /var/lib/mysql/mysqld.pid innodb_buffer_pool_size = 5G server_id = 5 log-bin = mysqld-bin binlog_format = ROW log-slave-updates gtid-mode = ON enforce-gtid-consistency = 1 skip-name-resolve log-error = /var/lib/mysql/error.log slow_query_log = on slow_query_log_file = '/var/lib/mysql/slow.log' log_slow_verbosity = full long_query_time = 0 secure-file-priv = /root/ explicit_defaults_for_timestamp = 1 sysdate-is-now = 1 ignore-db-dir = xtrabackup_backupfiles performance_schema=OFF[root@ip-10-11-36-195 Percona-XtraDB-Cluster_8.0.15.5-27dev.4.2_Linux.x86_64.ssl102]# bin/mysqld --log-error-verbosity=3 --innodb-directories="/var/lib/mysql;/var/lib/mysql/sakila;/var/lib/mysql/imdb;/var/lib/mysql/sysbench"[Warning] [MY-011070] [Server] 'Disabling symbolic links using --skip-symbolic-links (or equivalent) is the default. Consider not using this option as it' is deprecated and will be removed in a future release. [Warning] [MY-000000] [WSREP] Node is not a cluster node. Disabling pxc_strict_mode [Note] [MY-010949] [Server] Basedir set to /usr/local/Percona-XtraDB-Cluster_8.0.15.5-27dev.4.2_Linux.x86_64.ssl102/. [System] [MY-010116] [Server] /usr/local/Percona-XtraDB-Cluster_8.0.15.5-27dev.4.2_Linux.x86_64.ssl102/bin/mysqld (mysqld 8.0.15-5-27dev.4.2) starting as process 30044 [Note] [MY-012366] [InnoDB] Using Linux native AIO [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. [Note] [MY-012932] [InnoDB] PUNCH HOLE support available [Note] [MY-012943] [InnoDB] Mutexes and rw_locks use GCC atomic builtins [Note] [MY-012944] [InnoDB] Uses event mutexes [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.7 [Note] [MY-013251] [InnoDB] Number of pools: 1 [Note] [MY-012951] [InnoDB] Using CPU crc32 instructions [Note] [MY-012203] [InnoDB] Directories to scan './;./;./' [Note] [MY-012204] [InnoDB] Scanning './' [Note] [MY-012208] [InnoDB] Completed space ID check of 80 files. [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 5.000000G, instances = 8, chunk size =128.000000M [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner and LRU manager thread priority can be changed. See the man page of setpriority(). [Note] [MY-011825] [InnoDB] Recovering partial pages from the parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite [Note] [MY-012560] [InnoDB] The log sequence number 12 in the system tablespace does not match the log sequence number 34617448631 in the ib_logfiles! [Note] [MY-012551] [InnoDB] Database was not shutdown normally! [Note] [MY-012552] [InnoDB] Starting crash recovery. [Note] [MY-011825] [InnoDB] Created parallel doublewrite buffer at /var/lib/mysql/xb_doublewrite, size 31457280 bytes [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 34617494210, whereas checkpoint_lsn = 34617448631 [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_BEING_DELETED.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_BEING_DELETED_CACHE.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_CONFIG.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_DELETED.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_DELETED_CACHE.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_0000000000000184_INDEX_1.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_0000000000000184_INDEX_2.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_0000000000000184_INDEX_3.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_0000000000000184_INDEX_4.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_0000000000000184_INDEX_5.ibd) failed! [Note] [MY-012114] [InnoDB] my_realpath(./sakila/FTS_00000000000000e5_0000000000000184_INDEX_6.ibd) failed! [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 34622691328 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 34623638922 [Note] [MY-013083] [InnoDB] Log background threads are being started... [Note] [MY-012532] [InnoDB] Applying a batch of 1318 redo log records ... [Note] [MY-012533] [InnoDB] 10% [Note] [MY-012533] [InnoDB] 20% [Note] [MY-012533] [InnoDB] 30% [Note] [MY-012533] [InnoDB] 40% [Note] [MY-012533] [InnoDB] 50% [Note] [MY-012533] [InnoDB] 60% [Note] [MY-012533] [InnoDB] 70% [Note] [MY-012533] [InnoDB] 80% [Note] [MY-012533] [InnoDB] 90% [Note] [MY-012533] [InnoDB] 100% [Note] [MY-012535] [InnoDB] Apply batch completed! [ERROR] [MY-012179] [InnoDB] Could not find any file associated with the tablespace ID: 4294967293 [ERROR] [MY-012964] [InnoDB] Use --innodb-directories to find the tablespace files. If that fails then use --innodb-force-recovery=1 to ignore this and to permanently lose all changes to the missing tablespace(s) [ERROR] [MY-012930] [InnoDB] Plugin initialization aborted with error Generic error. [Note] [MY-013084] [InnoDB] Log background threads are being closed... [ERROR] [MY-010334] [Server] Failed to initialize DD Storage Engine [ERROR] [MY-010020] [Server] Data Dictionary initialization failed. [ERROR] [MY-010119] [Server] Aborting [Note] [MY-010120] [Server] Binlog end [Note] [MY-010733] [Server] Shutting down plugin 'MyISAM' [Note] [MY-010733] [Server] Shutting down plugin 'CSV' [Note] [MY-010733] [Server] Shutting down plugin 'InnoDB' [System] [MY-010910] [Server] /usr/local/Percona-XtraDB-Cluster_8.0.15.5-27dev.4.2_Linux.x86_64.ssl102/bin/mysqld: Shutdown complete (mysqld 8.0.15-5-27dev.4.2) Percona XtraDB Cluster binary (GPL) 8.0.15-27dev.4.2, Revision f42c652 - UNIV_DEBUG ON.