docker run -it --name lp1734116 --entrypoint=/bin/bash percona:5.6
mysql_install_db
chown mysql:mysql /var/lib/mysql
add user=mysql and innodb_track_changed_pages=ON to [mysqld] section
mysqld & (5.6.37-82.2 started)
use test
create table t(c int) engine=innodb;
insert into t values (1);
set global innodb_fast_shutdown=0;
mysqladmin shutdown
apt-get update
apt-get install -y percona-server-server-5.7
apt-get install -y percona-server-5.7-dbg
mysqld --version
mysqld Ver 5.7.19-17 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release '17', Revision 'e19a6b7b73f')
Or just use mysql.tar.gz as datadir and start mysql 5.7 with --innodb-track-changed_pages=1
Same stack trace:
0x0000000000f9b843 in log_online_follow_redo_log ()
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/storage/innobase/log/log0online.cc:1288
1288 log_bmp_sys->end_lsn = log_sys->last_checkpoint_lsn;
(gdb) bt
#0 0x0000000000f9b843 in log_online_follow_redo_log ()
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/storage/innobase/log/log0online.cc:1288
#1 0x000000000108793e in innobase_start_or_create_for_mysql ()
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/storage/innobase/srv/srv0start.cc:2481
#2 0x0000000000f3be19 in innobase_init (p=<optimized out>)
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/storage/innobase/handler/ha_innodb.cc:4353
#3 0x00000000007fc011 in ha_initialize_handlerton (plugin=0x1ff4718)
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/sql/handler.cc:871
#4 0x0000000000c895f6 in plugin_initialize (plugin=plugin@entry=0x1ff4718)
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/sql/sql_plugin.cc:1223
#5 0x0000000000c913b8 in plugin_init (argc=argc@entry=0x1dc8200 <remaining_argc>, argv=0x1ea9f10, flags=flags@entry=0)
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/sql/sql_plugin.cc:1565
#6 0x00000000007932a6 in init_server_components () at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/sql/mysqld.cc:4296
#7 0x0000000000794a49 in mysqld_main (argc=16, argv=0x1ea9f10)
at /mnt/workspace/percona-server-5.7-debian-binary-rocks/label_exp/debian-jessie-64bit/percona-server-5.7-5.7.19-17/sql/mysqld.cc:5001
#8 0x00007ffff5b40b45 in __libc_start_main (main=0x7716e0 <main(int, char**)>, argc=1, argv=0x7fffffffec48, init=<optimized out>, fini=<optimized out>, rtld_fini=<optimized out>,
stack_end=0x7fffffffec38) at libc-start.c:287
#9 0x000000000078afb4 in _start ()
(gdb) p log_bmp_sys
$1 = (log_bitmap_struct *) 0x0
(gdb) list
1283 return true;
1284 }
1285
1286 /* Grab the LSN of the last checkpoint, we will parse up to it */
1287 log_mutex_enter();
1288 log_bmp_sys->end_lsn = log_sys->last_checkpoint_lsn;
1289 log_mutex_exit();
1290
1291 if (log_bmp_sys->end_lsn == log_bmp_sys->start_lsn) {
1292 mutex_exit(&log_bmp_sys_mutex);
docker run -it --name lp1734116 --entrypoint= /bin/bash percona:5.6 track_changed_ pages=ON to [mysqld] section fast_shutdown= 0; server- server- 5.7 server- 5.7-dbg
mysql_install_db
chown mysql:mysql /var/lib/mysql
add user=mysql and innodb_
mysqld & (5.6.37-82.2 started)
use test
create table t(c int) engine=innodb;
insert into t values (1);
set global innodb_
mysqladmin shutdown
apt-get update
apt-get install -y percona-
apt-get install -y percona-
mysqld --version
mysqld Ver 5.7.19-17 for debian-linux-gnu on x86_64 (Percona Server (GPL), Release '17', Revision 'e19a6b7b73f')
Or just use mysql.tar.gz as datadir and start mysql 5.7 with --innodb- track-changed_ pages=1
Same stack trace: follow_ redo_log () percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/storage/ innobase/ log/log0online. cc:1288 sys->end_ lsn = log_sys- >last_checkpoin t_lsn; follow_ redo_log () percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/storage/ innobase/ log/log0online. cc:1288 start_or_ create_ for_mysql () percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/storage/ innobase/ srv/srv0start. cc:2481 percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/storage/ innobase/ handler/ ha_innodb. cc:4353 handlerton (plugin=0x1ff4718) percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/sql/ handler. cc:871 plugin@ entry=0x1ff4718 ) percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/sql/ sql_plugin. cc:1223 entry=0x1dc8200 <remaining_argc>, argv=0x1ea9f10, flags=flags@ entry=0) percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/sql/ sql_plugin. cc:1565 components () at /mnt/workspace/ percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/sql/ mysqld. cc:4296 percona- server- 5.7-debian- binary- rocks/label_ exp/debian- jessie- 64bit/percona- server- 5.7-5.7. 19-17/sql/ mysqld. cc:5001 ec48, init=<optimized out>, fini=<optimized out>, rtld_fini= <optimized out>, end=0x7fffffffe c38) at libc-start.c:287 sys->end_ lsn = log_sys- >last_checkpoin t_lsn; sys->end_ lsn == log_bmp_ sys->start_ lsn) { &log_bmp_ sys_mutex) ;
0x0000000000f9b843 in log_online_
at /mnt/workspace/
1288 log_bmp_
(gdb) bt
#0 0x0000000000f9b843 in log_online_
at /mnt/workspace/
#1 0x000000000108793e in innobase_
at /mnt/workspace/
#2 0x0000000000f3be19 in innobase_init (p=<optimized out>)
at /mnt/workspace/
#3 0x00000000007fc011 in ha_initialize_
at /mnt/workspace/
#4 0x0000000000c895f6 in plugin_initialize (plugin=
at /mnt/workspace/
#5 0x0000000000c913b8 in plugin_init (argc=argc@
at /mnt/workspace/
#6 0x00000000007932a6 in init_server_
#7 0x0000000000794a49 in mysqld_main (argc=16, argv=0x1ea9f10)
at /mnt/workspace/
#8 0x00007ffff5b40b45 in __libc_start_main (main=0x7716e0 <main(int, char**)>, argc=1, argv=0x7fffffff
stack_
#9 0x000000000078afb4 in _start ()
(gdb) p log_bmp_sys
$1 = (log_bitmap_struct *) 0x0
(gdb) list
1283 return true;
1284 }
1285
1286 /* Grab the LSN of the last checkpoint, we will parse up to it */
1287 log_mutex_enter();
1288 log_bmp_
1289 log_mutex_exit();
1290
1291 if (log_bmp_
1292 mutex_exit(