################ 8.0.27 to 8.0.30 upgrade - affected rm -rf 109868/ bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/109868 --log-error-verbosity=3 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/109868 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/109868/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & - bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.27 MySQL Community Server - GPL Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.00 sec) mysql> use test Database changed mysql> CREATE TABLE `table_1` ( -> `id` varchar(50) NOT NULL, -> `field_1` varchar(100) DEFAULT NULL, -> `field_2` varchar(50) DEFAULT NULL, -> `field_3` varchar(300) DEFAULT NULL, -> `field_4` varchar(300) DEFAULT NULL, -> `field_5` varchar(50) DEFAULT NULL, -> `field_6` varchar(50) DEFAULT NULL, -> `field_7` varchar(50) DEFAULT NULL, -> `field_8` text, -> `field_9` varchar(10) DEFAULT NULL, -> `field_10` varchar(50) DEFAULT NULL, -> `field_11` varchar(100) DEFAULT NULL, -> `field_12` varchar(100) DEFAULT NULL, -> `field_13` varchar(150) DEFAULT NULL, -> `field_14` decimal(20,5) DEFAULT NULL, -> `field_15` varchar(30) DEFAULT NULL, `field_27` varchar(50) DEFAULT NULL, -> `field_16` decimal(20,5) DEFAULT NULL, -> `field_17` varchar(10) DEFAULT NULL, -> `field_18` varchar(50) DEFAULT NULL, -> `field_19` varchar(10) DEFAULT NULL, -> `field_20` varchar(50) DEFAULT NULL, -> `field_21` varchar(20) DEFAULT NULL, -> `field_22` varchar(50) DEFAULT NULL, -> `field_23` varchar(50) DEFAULT NULL, -> `field_24` varchar(100) DEFAULT NULL, -> `field_25` varchar(50) DEFAULT NULL, -> `field_26` varchar(100) DEFAULT NULL, -> `field_27` varchar(50) DEFAULT NULL, -> `field_28` varchar(150) DEFAULT NULL, -> `field_29` text, -> `field_30` varchar(10) DEFAULT NULL, -> `field_31` varchar(100) DEFAULT NULL, -> `field_32` varchar(50) DEFAULT NULL, -> `field_33` varchar(200) DEFAULT NULL, -> `field_34` decimal(20,5) DEFAULT NULL, -> `field_35` decimal(20,5) DEFAULT NULL, -> `field_36` varchar(50) DEFAULT NULL, -> `field_37` varchar(50) DEFAULT NULL, -> `field_38` datetime DEFAULT NULL, -> `field_39` datetime DEFAULT NULL, -> `field_40` varchar(50) DEFAULT NULL, -> `field_41` varchar(16) DEFAULT NULL, -> `field_42` varchar(20) DEFAULT NULL, -> `field_43` varchar(100) DEFAULT NULL, `field_55` decimal(20,5) DEFAULT NULL, -> `field_44` varchar(50) DEFAULT NULL, -> `field_45` varchar(100) DEFAULT NULL, -> `field_46` varchar(50) DEFAULT NULL, -> `field_47` varchar(100) DEFAULT NULL, -> `field_48` varchar(50) DEFAULT NULL, -> `field_49` varchar(100) DEFAULT NULL, -> `field_50` varchar(50) DEFAULT NULL, -> `field_51` varchar(100) DEFAULT NULL, -> `field_52` varchar(50) DEFAULT NULL, -> `field_53` varchar(150) DEFAULT NULL, -> `field_54` varchar(100) DEFAULT NULL, -> `field_55` decimal(20,5) DEFAULT NULL, -> `field_56` decimal(20,5) DEFAULT NULL, -> `field_57` decimal(20,5) DEFAULT NULL, -> `field_58` decimal(20,5) DEFAULT NULL, -> `field_59` decimal(20,5) DEFAULT NULL, -> `field_60` decimal(20,5) DEFAULT NULL, -> `field_61` decimal(20,5) DEFAULT NULL, -> `field_62` decimal(20,5) DEFAULT NULL, -> `field_63` decimal(20,5) DEFAULT NULL, -> `field_64` decimal(20,5) DEFAULT NULL, -> `field_65` varchar(50) DEFAULT NULL, -> `field_66` text, -> `field_67` varchar(100) DEFAULT NULL, -> `field_68` datetime DEFAULT NULL, -> `field_69` datetime DEFAULT NULL, -> `field_70` decimal(20,5) DEFAULT NULL, -> `field_71` datetime DEFAULT NULL, `field_83` varchar(100) DEFAULT NULL, -> `field_72` datetime DEFAULT NULL, -> `field_73` varchar(100) DEFAULT NULL, -> `field_74` varchar(20) DEFAULT NULL, -> `field_75` varchar(50) DEFAULT NULL, -> `field_76` varchar(50) DEFAULT NULL, -> `field_77` varchar(50) DEFAULT NULL, -> `field_78` varchar(50) DEFAULT NULL, -> `field_79` varchar(50) DEFAULT NULL, -> `field_80` varchar(50) DEFAULT NULL, -> `field_81` varchar(50) DEFAULT NULL, -> `field_82` varchar(100) DEFAULT NULL, -> `field_83` varchar(100) DEFAULT NULL, -> `field_84` varchar(100) DEFAULT NULL, -> `field_85` varchar(100) DEFAULT NULL, `field_97` varchar(100) DEFAULT NULL, -> `field_86` varchar(100) DEFAULT NULL, -> `field_87` varchar(100) DEFAULT NULL, -> `field_88` varchar(100) DEFAULT NULL, -> `field_89` varchar(100) DEFAULT NULL, -> `field_90` varchar(100) DEFAULT NULL, -> `field_91` varchar(100) DEFAULT NULL, -> `field_92` varchar(100) DEFAULT NULL, -> `field_93` varchar(100) DEFAULT NULL, -> `field_94` varchar(100) DEFAULT NULL, -> `field_95` varchar(100) DEFAULT NULL, -> `field_96` varchar(100) DEFAULT NULL, -> `field_97` varchar(100) DEFAULT NULL, -> `field_98` varchar(100) DEFAULT NULL, -> `field_99` varchar(100) DEFAULT NULL, `field_111` varchar(100) DEFAULT NULL, -> `field_100` varchar(100) DEFAULT NULL, -> `field_101` varchar(100) DEFAULT NULL, -> `field_102` varchar(100) DEFAULT NULL, -> `field_103` varchar(100) DEFAULT NULL, -> `field_104` varchar(100) DEFAULT NULL, -> `field_105` varchar(100) DEFAULT NULL, -> `field_106` varchar(100) DEFAULT NULL, -> `field_107` varchar(200) DEFAULT NULL, -> `field_108` varchar(150) DEFAULT NULL, -> `field_109` varchar(100) DEFAULT NULL, -> `field_110` varchar(100) DEFAULT NULL, -> `field_111` varchar(100) DEFAULT NULL, -> `field_112` varchar(100) DEFAULT NULL, -> `field_113` varchar(100) DEFAULT NULL, -> `field_114` varchar(100) DEFAULT NULL, -> `field_115` varchar(100) DEFAULT NULL, -> `field_116` varchar(100) DEFAULT NULL, -> `field_117` varchar(100) DEFAULT NULL, -> `field_118` varchar(100) DEFAULT NULL, -> `field_119` varchar(60) DEFAULT NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql> ALTER TABLE table_1 -> ADD `field_120` varchar(100) DEFAULT NULL, -> ADD `field_121` varchar(100) DEFAULT NULL, -> ADD `field_122` varchar(100) DEFAULT NULL, -> ADD `field_123` varchar(100) DEFAULT NULL, -> ADD `field_124` varchar(100) DEFAULT NULL, -> ADD `field_125` datetime DEFAULT NULL, -> ADD `field_126` datetime DEFAULT NULL, -> ADD `field_127` varchar(50) DEFAULT NULL, -> ADD `field_128` varchar(400) DEFAULT NULL, -> ADD `field_129` varchar(400) DEFAULT NULL, -> ADD `field_130` varchar(480) DEFAULT NULL, -> ADD `field_131` int DEFAULT NULL, -> ADD `field_132` varchar(255) DEFAULT NULL; Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> shutdown; Query OK, 0 rows affected (0.00 sec) -- In place upgrade to 8.0.30 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-8.0.27/109868 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/export/home/tmp/ushastry/mysql-8.0.27/109868/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.30 MySQL Community Server - GPL Copyright (c) 2000, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> INSERT INTO table_1(`id`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `field_11`, `field_12`, `field_13`, `field_14`, `field_15`, `field_16`, `field_17`, `field_18`, `field_19`, `field_20`, `field_21`, `field_22`, `field_23`, `field_24`, `field_25`, `field_26`, `field_27`, `field_28`, `field_29`, `field_30`, `field_31`, `field_32`, `field_33`, `field_34`, `field_35`, `field_36`, `field_37`, `field_38`, `field_39`, `field_40`, `field_41`, `field_42`, `field_43`, `field_44`, `field_45`, `field_46`, `field_47`, `field_48`, `field_49`, `field_50`, `field_51`, `field_52`, `field_53`, `field_54`, `field_55`, `field_56`, `field_57`, `field_58`, `field_59`, `field_60`, `field_61`, `field_62`, `field_63`, `field_64`, `field_65`, `field_66`, `field_67`, `field_68`, `field_69`, `field_70`, `field_71`, `field_72`, `field_73`, `field_74`, `field_75`, `field_76`, `field_77`, `field_78`, `field_79`, `field_80`, `field_81`, `field_82`, `field_83`, `field_84`, `field_85`, `field_86`, `field_87`, `field_88`, `field_89`, `field_90`, `field_91`, `field_92`, `field_93`, `field_94`, `field_95`, `field_96`, `field_97`, `field_98`, `field_99`, `field_100`, `field_101`, `field_102`, `field_103`, `field_104`, `field_105`, `field_106`, `field_107`, `field_108`, `field_109`, `field_110`, `field_111`, `field_112`, `field_113`, `field_114`, `field_115`, `field_116`, `field_117`, `field_118`, `field_119`, `field_120`, `field_121`, `field_122`, `field_123`, `field_124`, `field_125`, `field_126`, `field_127`, `field_128`, `field_129`, `field_130`, `field_131`, `field_132`) -> VALUES ('abcd1234-1ab2-11ab-a123-1234567a89b0', '123456A78901234', '123456789', 'abcdefghijabcdefghij1', '123456789123456789abc', 'abcdefghijklmn', NULL, 'ab1cd2ef3gh4ij5lmno', 'abc123def.abc123defabc123def-abc123def456-abc123def456ghi-abc123defabc123def123', '12', 'abc123def', 'abc123defabc123defabc123def456', '123456780123456780123456780123', 'abc123defabc123defabc123def140123456200abcdefWPabc123defabc123def', 8.00000, 'abc', NULL, NULL, 'abcdef', 'abc123def', NULL, '12345678', 'abcdefghi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8', 'abc(123456789def)', '123456AB12345678', 'abc123defabc123defabc123defabc123defabc123defabc123def2ABC123abcdef123', 9.00000, 88.00000, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'A12345678912345', '1234abc123defabc123defabc123defabc123def123', NULL, 12345.14000, 12345.13000, 12345.12000, 1234.28000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, NULL, NULL, NULL, '2023-01-01 00:00:00', NULL, NULL, '2023-01-01 00:00:00', '2023-01-01 00:00:00', NULL, 'abc123456', NULL, NULL, '123456789', NULL, 'AB123456DEC-12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ABCD_EF_123456', NULL, NULL, NULL, NULL, NULL); Query OK, 1 row affected (0.00 sec) mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> UPDATE table_1 SET `field_23`='null', `field_24`='null', `field_21`='12345678', `field_22`='abcdefghi', `field_32`='123456AB12345678', `field_33`='abc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyz', `field_30`='12', `field_31`='abc' WHERE `id`='abcd1234-1ab2-11ab-a123-1234567a89b0'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> ROLLBACK; ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) ERROR: Can't connect to the server mysql> bin/mysqld_safe: line 199: 8979 Aborted (core dumped) env MYSQLD_PARENT_PID=8743 nohup /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld --no-defaults --basedir=/export/home/tmp/ushastry/mysql-8.0.30 --datadir=/export/home/tmp/ushastry/mysql-8.0.27/109868 --plugin-dir=/export/home/tmp/ushastry/mysql-8.0.30/lib/plugin --core-file --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv= --local-infile=1 --log-error=/export/home/tmp/ushastry/mysql-8.0.27/109868/log.err --pid-file=support-cluster03.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null >> /export/home/tmp/ushastry/mysql-8.0.27/109868/log.err 2>&1 2023-02-01T05:41:18.466931Z mysqld_safe Number of processes running now: 0 2023-02-01T05:41:18.469671Z mysqld_safe mysqld restarted bin/mysqld_safe: line 199: 9525 Aborted (core dumped) env MYSQLD_PARENT_PID=8743 env MYSQLD_PARENT_PID=8743 nohup /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld --no-defaults --basedir=/export/home/tmp/ushastry/mysql-8.0.30 --datadir=/export/home/tmp/ushastry/mysql-8.0.27/109868 --plugin-dir=/export/home/tmp/ushastry/mysql-8.0.30/lib/plugin --core-file --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv= --local-infile=1 --log-error=/export/home/tmp/ushastry/mysql-8.0.27/109868/log.err --pid-file=support-cluster03.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null >> /export/home/tmp/ushastry/mysql-8.0.27/109868/log.err 2>&1 >> /export/home/tmp/ushastry/mysql-8.0.27/109868/log.err 2>&1 2023-02-01T05:41:19.312022Z mysqld_safe mysqld from pid file /export/home/tmp/ushastry/mysql-8.0.27/109868/support-cluster03.pid ended -bt (gdb) bt #0 0x00007fa00418aaa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000106680f in handle_fatal_signal () #2 #3 0x00007fa0023c6387 in raise () from /lib64/libc.so.6 #4 0x00007fa0023c7a78 in abort () from /lib64/libc.so.6 #5 0x0000000000d25a72 in my_server_abort() [clone .cold.7] () #6 0x0000000001fb8d3a in my_abort() () #7 0x000000000229515c in ut_dbg_assertion_failed(char const*, char const*, unsigned long) () #8 0x00000000022d94b9 in btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*) () #9 0x000000000247c1e7 in row_undo_mod_clust_low(undo_node_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, dtuple_t const**, unsigned char*, que_thr_t*, mtr_t*, unsigned long) () #10 0x000000000247c7b9 in row_undo_mod_clust(undo_node_t*, que_thr_t*) () #11 0x000000000247fef7 in row_undo_mod(undo_node_t*, que_thr_t*) () #12 0x0000000002211ca2 in row_undo_step(que_thr_t*) () #13 0x00000000021b6448 in que_run_threads(que_thr_t*) () #14 0x000000000226c1fe in trx_rollback_or_clean_recovered(bool) () #15 0x000000000226d25b in trx_recovery_rollback_thread() () #16 0x0000000002157a14 in std::thread::_State_impl > >::_M_run() () #17 0x00000000027e42df in execute_native_thread_routine () #18 0x00007fa004185ea5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fa00248eb0d in clone () from /lib64/libc.so.6 (gdb) - bt (gdb) bt #0 0x00007f4466a45aa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000106680f in handle_fatal_signal () #2 #3 0x00007f4464c81387 in raise () from /lib64/libc.so.6 #4 0x00007f4464c82a78 in abort () from /lib64/libc.so.6 #5 0x0000000000d25a72 in my_server_abort() [clone .cold.7] () #6 0x0000000001fb8d3a in my_abort() () #7 0x000000000229515c in ut_dbg_assertion_failed(char const*, char const*, unsigned long) () #8 0x00000000022d94b9 in btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*) () #9 0x000000000247c1e7 in row_undo_mod_clust_low(undo_node_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, dtuple_t const**, unsigned char*, que_thr_t*, mtr_t*, unsigned long) () #10 0x000000000247c7b9 in row_undo_mod_clust(undo_node_t*, que_thr_t*) () #11 0x000000000247fef7 in row_undo_mod(undo_node_t*, que_thr_t*) () #12 0x0000000002211ca2 in row_undo_step(que_thr_t*) () #13 0x00000000021b6448 in que_run_threads(que_thr_t*) () #14 0x000000000226a967 in trx_rollback_to_savepoint_low(trx_t*, trx_savept_t*) () #15 0x000000000226d9d4 in trx_rollback_low(trx_t*) () #16 0x000000000226df70 in trx_rollback_for_mysql(trx_t*) () #17 0x00000000020a754a in innobase_rollback(handlerton*, THD*, bool) () #18 0x000000000116853e in ha_rollback_low(THD*, bool) () #19 0x000000000101a6d5 in trx_coordinator::rollback_in_engines(THD*, bool) () #20 0x0000000001bf7b5f in MYSQL_BIN_LOG::rollback(THD*, bool) () #21 0x000000000116870a in ha_rollback_trans(THD*, bool) () #22 0x000000000101c91e in trans_rollback(THD*) () #23 0x0000000000f01cbb in mysql_execute_command(THD*, bool) () #24 0x0000000000f04163 in dispatch_sql_command(THD*, Parser_state*) () #25 0x0000000000f066f0 in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #26 0x0000000000f076af in do_command(THD*) () #27 0x00000000010574b8 in handle_connection () #28 0x0000000002526cda in pfs_spawn_thread () #29 0x00007f4466a40ea5 in start_thread () from /lib64/libpthread.so.0 #30 0x00007f4464d49b0d in clone () from /lib64/libc.so.6 (gdb) -- Error log 2023-02-01T05:40:51.009213Z 0 [System] [MY-010931] [Server] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld: ready for connections. Version: '8.0.30' socket: '/tmp/mysql.sock' port: 3306 MySQL Community Server - GPL. 2023-02-01T05:41:18.194493Z 9 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:4024:page_zip || optim_err != DB_UNDERFLOW thread 139931445069568 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 05:41:18 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f43e0000c20 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f4454137d40 thread_stack 0x100000 /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1fbe99e] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x106677b] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(my_server_abort()+0x5e) [0x106687e] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(my_abort()+0xa) [0x1fb8d3a] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x229515c] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*)+0x779) [0x22d94b9] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x247c1e7] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x247c7b9] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(row_undo_mod(undo_node_t*, que_thr_t*)+0xca7) [0x247fef7] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(row_undo_step(que_thr_t*)+0x52) [0x2211ca2] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(que_run_threads(que_thr_t*)+0xb48) [0x21b6448] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x226a967] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x226d9d4] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(trx_rollback_for_mysql(trx_t*)+0x260) [0x226df70] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x20a754a] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(ha_rollback_low(THD*, bool)+0x12e) [0x116853e] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(trx_coordinator::rollback_in_engines(THD*, bool)+0x25) [0x101a6d5] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(MYSQL_BIN_LOG::rollback(THD*, bool)+0xcf) [0x1bf7b5f] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(ha_rollback_trans(THD*, bool)+0x7a) [0x116870a] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(trans_rollback(THD*)+0x4e) [0x101c91e] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(mysql_execute_command(THD*, bool)+0x369b) [0xf01cbb] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x403) [0xf04163] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2080) [0xf066f0] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(do_command(THD*)+0x1df) [0xf076af] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x10574b8] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x2526cda] /lib64/libpthread.so.0(+0x7ea5) [0x7f4466a40ea5] /lib64/libc.so.6(clone+0x6d) [0x7f4464d49b0d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f43e01b38c0): ROLLBACK Connection ID (thread ID): 9 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file 2023-02-01T05:41:18.466931Z mysqld_safe Number of processes running now: 0 2023-02-01T05:41:18.469671Z mysqld_safe mysqld restarted 2023-02-01T05:41:18.677285Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2023-02-01T05:41:18.677331Z 0 [Note] [MY-010949] [Server] Basedir set to /export/home/tmp/ushastry/mysql-8.0.30/. 2023-02-01T05:41:18.677356Z 0 [System] [MY-010116] [Server] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld (mysqld 8.0.30) starting as process 9525 2023-02-01T05:41:18.681680Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2023-02-01T05:41:18.681912Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2023-02-01T05:41:18.683613Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-02-01T05:41:18.683651Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2023-02-01T05:41:18.683696Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2023-02-01T05:41:18.683712Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2023-02-01T05:41:18.683720Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2023-02-01T05:41:18.683727Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12 2023-02-01T05:41:18.684868Z 1 [Note] [MY-013251] [InnoDB] Number of pools: 1 2023-02-01T05:41:18.684949Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2023-02-01T05:41:18.685292Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2023-02-01T05:41:18.685324Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2023-02-01T05:41:18.686039Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 5 files. 2023-02-01T05:41:18.686627Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 2023-02-01T05:41:18.692760Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2023-02-01T05:41:18.695893Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2023-02-01T05:41:18.696139Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2023-02-01T05:41:18.696430Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2023-02-01T05:41:18.703783Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2023-02-01T05:41:18.703806Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4 2023-02-01T05:41:18.703825Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2023-02-01T05:41:18.703839Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2023-02-01T05:41:18.796241Z 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 40902293 in redo log file ./#innodb_redo/#ib_redo6. 2023-02-01T05:41:18.796297Z 1 [Note] [MY-012560] [InnoDB] The log sequence number 18412044 in the system tablespace does not match the log sequence number 40902293 in the redo log files! 2023-02-01T05:41:18.796314Z 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally! 2023-02-01T05:41:18.796320Z 1 [Note] [MY-012552] [InnoDB] Starting crash recovery. 2023-02-01T05:41:18.799202Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 40902283, whereas checkpoint_lsn = 40902293 and start_lsn = 40902144 2023-02-01T05:41:18.799219Z 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 40902293 2023-02-01T05:41:18.802592Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2023-02-01T05:41:18.803006Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2023-02-01T05:41:18.803023Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2023-02-01T05:41:18.903200Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2023-02-01T05:41:18.904756Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2023-02-01T05:41:18.908891Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2023-02-01T05:41:18.908927Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 4715 2023-02-01T05:41:18.912756Z 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2023-02-01T05:41:18.912803Z 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 3876 ms. 2023-02-01T05:41:18.912882Z 1 [Note] [MY-013023] [InnoDB] 1 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo 2023-02-01T05:41:18.912888Z 1 [Note] [MY-013024] [InnoDB] Trx id counter is 5121 2023-02-01T05:41:18.913835Z 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2023-02-01T05:41:18.913850Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2023-02-01T05:41:18.913885Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-02-01T05:41:18.946312Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2023-02-01T05:41:18.946472Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2023-02-01T05:41:18.971757Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2023-02-01T05:41:18.971947Z 1 [Note] [MY-012976] [InnoDB] 8.0.30 started; log sequence number 40902303 2023-02-01T05:41:18.972920Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-02-01T05:41:18.984722Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'. 2023-02-01T05:41:19.101532Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2023-02-01T05:41:19.103565Z 1 [Note] [MY-012356] [InnoDB] Scanned 7 tablespaces. Validated 7. 2023-02-01T05:41:19.106504Z 0 [Note] [MY-013014] [InnoDB] Starting in background the rollback of uncommitted transactions 2023-02-01T05:41:19.106545Z 0 [Note] [MY-013011] [InnoDB] Rolling back trx with id 4714, 1 rows to undo 2023-02-01T05:41:19.106720Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:4024:page_zip || optim_err != DB_UNDERFLOW thread 140324221478656 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 05:41:19 UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. Thread pointer: 0x7f9fb800a160 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f9fc75fdcb8 thread_stack 0x100000 /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x1fbe99e] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(print_fatal_signal(int)+0x2eb) [0x106677b] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(my_server_abort()+0x5e) [0x106687e] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(my_abort()+0xa) [0x1fb8d3a] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x229515c] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*)+0x779) [0x22d94b9] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x247c1e7] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x247c7b9] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(row_undo_mod(undo_node_t*, que_thr_t*)+0xca7) [0x247fef7] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(row_undo_step(que_thr_t*)+0x52) [0x2211ca2] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(que_run_threads(que_thr_t*)+0xb48) [0x21b6448] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(trx_rollback_or_clean_recovered(bool)+0x11ee) [0x226c1fe] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(trx_recovery_rollback_thread()+0x1b) [0x226d25b] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld(std::thread::_State_impl > >::_M_run()+0xc4) [0x2157a14] /export/home/tmp/ushastry/mysql-8.0.30/bin/mysqld() [0x27e42df] /lib64/libpthread.so.0(+0x7ea5) [0x7fa004185ea5] /lib64/libc.so.6(clone+0x6d) [0x7fa00248eb0d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 0 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file 2023-02-01T05:41:19.312022Z mysqld_safe mysqld from pid file /export/home/tmp/ushastry/mysql-8.0.27/109868/support-cluster03.pid ended ################ 8.0.27 to 8.0.31 upgrade - affected rm -rf 109868_31/ bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/109868_31 --log-error-verbosity=3 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/109868_31 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/109868_31/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.27 MySQL Community Server - GPL Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.01 sec) mysql> use test Database changed mysql> CREATE TABLE `table_1` ( `id` varchar(50) NOT NULL, `field_1` varchar(100) DEFAULT NULL, `field_2` varchar(50) DEFAULT NULL, `field_3` varchar(300) DEFAULT NULL, `field_4` varchar(300) DEFAULT NULL, `field_5` varchar(50) DEFAULT NULL, `field_6` varchar(50) DEFAULT NULL, `field_7` varchar(50) DEFAULT NULL, `field_8` text, `field_9` varchar(10) DEFAULT NULL, `field_10` varchar(50) DEFAULT NULL, `field_11` varchar(100) DEFAULT NULL, `field_12` varchar(100) DEFAULT NULL, `field_13` varchar(150) DEFAULT NULL, -> `id` varchar(50) NOT NULL, `field_14` decimal(20,5) DEFAULT NULL, `field_15` varchar(30) DEFAULT NULL, `field_16` decimal(20,5) DEFAULT NULL, `field_17` varchar(10) DEFAULT NULL, `field_18` varchar(50) DEFAULT NULL, `field_19` varchar(10) DEFAULT NULL, `field_20` varchar(50) DEFAULT NULL, `field_21` varchar(20) DEFAULT NULL, `field_22` varchar(50) DEFAULT NULL, `field_23` varchar(50) DEFAULT NULL, `field_24` varchar(100) DEFAULT NULL, `field_25` varchar(50) DEFAULT NULL, `field_26` varchar(100) DEFAULT NULL, `field_27` varchar(50) DEFAULT NULL, `field_28` varchar(150) DEFAULT NULL, `field_29` text, `field_30` varchar(10) DEFAULT NULL, `field_31` varchar(100) DEFAULT NULL, `field_32` varchar(50) DEFAULT NULL, `field_33` varchar(200) DEFAULT NULL, `field_34` decimal(20,5) D -> EFAULT NULL, `field_35` decimal(20,5) DEFAULT NULL, `field_36` varchar(50) DEFAULT NULL, `field_37` varchar(50) DEFAULT NULL, `field_38` datetime DEFAULT NULL, `field_39` datetime DEFAULT NULL, `field_40` varchar(50) DEFAULT NULL, `field_1` varchar(100) DEFAULT NULL, -> `field_2` varchar(50) DEFAULT NULL, `field_42` varchar(20) DEFAULT NULL, `field_43` varchar(100) DEFAULT NULL, `field_44` varchar(50) DEFAULT NULL, `field_45` varchar(100) DEFAULT NULL, `field_46` varchar(50) DEFAULT NULL, `field_47` varchar(100) DEFAULT NULL, `field_48` varchar(50) DEFAULT NULL, `field_49` varchar(100) DEFAULT NULL, `field_50` varchar(50) DEFAULT NULL, `field_51` varchar(100) DEFAULT NULL, `field_52` varchar(50) DEFAULT NULL, `field_53` varchar(150) DEFAULT NULL, `field_54` varchar(100) DEFAULT NULL, `field_55` decimal(20,5) DEFAULT NULL, -> `field_3` varchar(300) DEFAULT NULL, -> `field_4` varchar(300) DEFAULT NULL, -> `field_5` varchar(50) DEFAULT NULL, -> `field_6` varchar(50) DEFAULT NULL, -> `field_7` varchar(50) DEFAULT NULL, -> `field_8` text, -> `field_9` varchar(10) DEFAULT NULL, `field_70` decimal(20,5) DEFAULT NULL, `field_71` datetime DEFAULT NULL, `field_72` datetime DEFAULT NULL, `field_73` varchar(100) DEFAULT NULL, `field_74` varchar(20) DEFAULT NULL, `field_75` varchar(50) DEFAULT NULL, `field_76` varchar(50) DEFAULT NULL, `field_77` varchar(50) DEFAULT NULL, `field_78` varchar(50) DEFAULT NULL, `field_79` varchar(50) DEFAULT NULL, `field_80` varchar(50) DEFAULT NULL, `field_81` varchar(50) DEFAULT NULL, `field_82` varchar(100) DEFAULT NULL, -> `field_10` varchar(50) DEFAULT NULL, -> `field_11` varchar(100) DEFAULT NULL, -> `field_12` varchar(100) DEFAULT NULL, -> `field_13` varchar(150) DEFAULT NULL, `field_83` varchar(100) DEFAULT NULL, -> `field_14` decimal(20,5) DEFAULT NULL, -> `field_15` varchar(30) DEFAULT NULL, -> `field_16` decimal(20,5) DEFAULT NULL, `field_84` varchar(100) DEFAULT NULL, `field_85` varchar(100) DEFAULT NULL, `field_86` varchar(100) DEFAULT NULL, `field_87` varchar(100) DEFAULT NULL, `field_88` varchar(100) DEFAULT NULL, `field_89` varchar(100) DEFAULT NULL, `field_90` varchar(100) DEFAULT NULL, `field_91` varchar(100) DEFAULT NULL, `field_92` varchar(100) DEFAULT NULL, `field_93` varchar(100) DEFAULT NULL, `field_94` varchar(100) DEFAULT NULL, `field_95` varchar(100) DEFAULT NULL, `field_96` varchar(100) DEFAULT NULL, `field_97` varchar(100) DEFAULT NULL, `field_98` varchar(100) DEFAULT NULL, `field_99` varchar(100) DEFAULT NULL, `field_100` varchar(100) DEFAULT NULL, `field_101` varchar(100) DEFAULT NULL, `field_102` varchar(100) DEFAULT NULL, `field_103` varchar(100) DEFAULT NULL, `field_104` varchar(100) DEFAULT NULL, `field_105` varchar(100) DEFAULT NULL, `field_106` varchar(100) DEFAULT NULL, `field_107` varchar(200) DEFAULT NULL, `field_108` varchar(150) DEFAULT NULL, `field_109` varchar(100) DEFAULT NULL, -> `field_110` varchar(100) DEFAULT NULL, `field_111` varchar(100) DEFAULT NULL, `field_17` varchar(10) DEFAULT NULL, -> `field_18` varchar(50) DEFAULT NULL, -> `field_19` varchar(10) DEFAULT NULL, -> `field_20` varchar(50) DEFAULT NULL, -> `field_21` varchar(20) DEFAULT NULL, -> `field_22` varchar(50) DEFAULT NULL, -> `field_23` varchar(50) DEFAULT NULL, -> `field_24` varchar(100) DEFAULT NULL, -> `field_25` varchar(50) DEFAULT NULL, -> `field_26` varchar(100) DEFAULT NULL, -> `field_27` varchar(50) DEFAULT NULL, -> `field_28` varchar(150) DEFAULT NULL, -> `field_29` text, -> `field_30` varchar(10) DEFAULT NULL, -> `field_31` varchar(100) DEFAULT NULL, -> `field_32` varchar(50) DEFAULT NULL, -> `field_33` varchar(200) DEFAULT NULL, -> `field_34` decimal(20,5) DEFAULT NULL, -> `field_35` decimal(20,5) DEFAULT NULL, -> `field_36` varchar(50) DEFAULT NULL, -> `field_37` varchar(50) DEFAULT NULL, -> `field_38` datetime DEFAULT NULL, -> `field_39` datetime DEFAULT NULL, -> `field_40` varchar(50) DEFAULT NULL, -> `field_41` varchar(16) DEFAULT NULL, -> `field_42` varchar(20) DEFAULT NULL, -> `field_43` varchar(100) DEFAULT NULL, -> `field_44` varchar(50) DEFAULT NULL, -> `field_45` varchar(100) DEFAULT NULL, -> `field_46` varchar(50) DEFAULT NULL, -> `field_47` varchar(100) DEFAULT NULL, -> `field_48` varchar(50) DEFAULT NULL, -> `field_49` varchar(100) DEFAULT NULL, -> `field_50` varchar(50) DEFAULT NULL, -> `field_51` varchar(100) DEFAULT NULL, -> `field_52` varchar(50) DEFAULT NULL, -> `field_53` varchar(150) DEFAULT NULL, -> `field_54` varchar(100) DEFAULT NULL, -> `field_55` decimal(20,5) DEFAULT NULL, -> `field_56` decimal(20,5) DEFAULT NULL, -> `field_57` decimal(20,5) DEFAULT NULL, -> `field_58` decimal(20,5) DEFAULT NULL, -> `field_59` decimal(20,5) DEFAULT NULL, -> `field_60` decimal(20,5) DEFAULT NULL, -> `field_61` decimal(20,5) DEFAULT NULL, -> `field_62` decimal(20,5) DEFAULT NULL, -> `field_63` decimal(20,5) DEFAULT NULL, -> `field_64` decimal(20,5) DEFAULT NULL, -> `field_65` varchar(50) DEFAULT NULL, -> `field_66` text, -> `field_67` varchar(100) DEFAULT NULL, -> `field_68` datetime DEFAULT NULL, -> `field_69` datetime DEFAULT NULL, -> `field_70` decimal(20,5) DEFAULT NULL, -> `field_71` datetime DEFAULT NULL, -> `field_72` datetime DEFAULT NULL, -> `field_73` varchar(100) DEFAULT NULL, -> `field_74` varchar(20) DEFAULT NULL, -> `field_75` varchar(50) DEFAULT NULL, -> `field_76` varchar(50) DEFAULT NULL, -> `field_77` varchar(50) DEFAULT NULL, -> `field_78` varchar(50) DEFAULT NULL, -> `field_79` varchar(50) DEFAULT NULL, -> `field_80` varchar(50) DEFAULT NULL, -> `field_81` varchar(50) DEFAULT NULL, -> `field_82` varchar(100) DEFAULT NULL, -> `field_83` varchar(100) DEFAULT NULL, -> `field_84` varchar(100) DEFAULT NULL, -> `field_85` varchar(100) DEFAULT NULL, -> `field_86` varchar(100) DEFAULT NULL, -> `field_87` varchar(100) DEFAULT NULL, -> `field_88` varchar(100) DEFAULT NULL, -> `field_89` varchar(100) DEFAULT NULL, -> `field_90` varchar(100) DEFAULT NULL, -> `field_91` varchar(100) DEFAULT NULL, -> `field_92` varchar(100) DEFAULT NULL, -> `field_93` varchar(100) DEFAULT NULL, -> `field_94` varchar(100) DEFAULT NULL, -> `field_95` varchar(100) DEFAULT NULL, -> `field_96` varchar(100) DEFAULT NULL, -> `field_97` varchar(100) DEFAULT NULL, -> `field_98` varchar(100) DEFAULT NULL, -> `field_99` varchar(100) DEFAULT NULL, -> `field_100` varchar(100) DEFAULT NULL, -> `field_101` varchar(100) DEFAULT NULL, -> `field_102` varchar(100) DEFAULT NULL, -> `field_103` varchar(100) DEFAULT NULL, -> `field_104` varchar(100) DEFAULT NULL, -> `field_105` varchar(100) DEFAULT NULL, -> `field_106` varchar(100) DEFAULT NULL, -> `field_107` varchar(200) DEFAULT NULL, -> `field_108` varchar(150) DEFAULT NULL, -> `field_109` varchar(100) DEFAULT NULL, -> `field_110` varchar(100) DEFAULT NULL, -> `field_111` varchar(100) DEFAULT NULL, -> `field_112` varchar(100) DEFAULT NULL, -> `field_113` varchar(100) DEFAULT NULL, -> `field_114` varchar(100) DEFAULT NULL, -> `field_115` varchar(100) DEFAULT NULL, -> `field_116` varchar(100) DEFAULT NULL, -> `field_117` varchar(100) DEFAULT NULL, -> `field_118` varchar(100) DEFAULT NULL, -> `field_119` varchar(60) DEFAULT NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; Query OK, 0 rows affected, 1 warning (0.04 sec) mysql> ALTER TABLE table_1 -> ADD `field_120` varchar(100) DEFAULT NULL, -> ADD `field_121` varchar(100) DEFAULT NULL, -> ADD `field_122` varchar(100) DEFAULT NULL, -> ADD `field_123` varchar(100) DEFAULT NULL, -> ADD `field_124` varchar(100) DEFAULT NULL, -> ADD `field_125` datetime DEFAULT NULL, -> ADD `field_126` datetime DEFAULT NULL, -> ADD `field_127` varchar(50) DEFAULT NULL, -> ADD `field_128` varchar(400) DEFAULT NULL, -> ADD `field_129` varchar(400) DEFAULT NULL, -> ADD `field_130` varchar(480) DEFAULT NULL, -> ADD `field_131` int DEFAULT NULL, -> ADD `field_132` varchar(255) DEFAULT NULL; Query OK, 0 rows affected (0.02 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> shutdown; Query OK, 0 rows affected (0.00 sec) -- In place upgrade to 8.0.31 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-8.0.27/109868_31 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/export/home/tmp/ushastry/mysql-8.0.27/109868_31/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.31 MySQL Community Server - GPL Copyright (c) 2000, 2022, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> INSERT INTO table_1(`id`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `field_11`, `field_12`, `field_13`, `field_14`, `field_15`, `field_16`, `field_17`, `field_18`, `field_19`, `field_20`, `field_21`, `field_22`, `field_23`, `field_24`, `field_25`, `field_26`, `field_27`, `field_28`, `field_29`, `field_30`, `field_31`, `field_32`, `field_33`, `field_34`, `field_35`, `field_36`, `field_37`, `field_38`, `field_39`, `field_40`, `field_41`, `field_42`, `field_43`, `field_44`, `field_45`, `field_46`, `field_47`, `field_48`, `field_49`, `field_50`, `field_51`, `field_52`, `field_53`, `field_54`, `field_55`, `field_56`, `field_57`, `field_58`, `field_59`, `field_60`, `field_61`, `field_62`, `field_63`, `field_64`, `field_65`, `field_66`, `field_67`, `field_68`, `field_69`, `field_70`, `field_71`, `field_72`, `field_73`, `field_74`, `field_75`, `field_76`, `field_77`, `field_78`, `field_79`, `field_80`, `field_81`, `field_82`, `field_83`, `field_84`, `field_85`, `field_86`, `field_87`, `field_88`, `field_89`, `field_90`, `field_91`, `field_92`, `field_93`, `field_94`, `field_95`, `field_96`, `field_97`, `field_98`, `field_99`, `field_100`, `field_101`, `field_102`, `field_103`, `field_104`, `field_105`, `field_106`, `field_107`, `field_108`, `field_109`, `field_110`, `field_111`, `field_112`, `field_113`, `field_114`, `field_115`, `field_116`, `field_117`, `field_118`, `field_119`, `field_120`, `field_121`, `field_122`, `field_123`, `field_124`, `field_125`, `field_126`, `field_127`, `field_128`, `field_129`, `field_130`, `field_131`, `field_132`) -> VALUES ('abcd1234-1ab2-11ab-a123-1234567a89b0', '123456A78901234', '123456789', 'abcdefghijabcdefghij1', '123456789123456789abc', 'abcdefghijklmn', NULL, 'ab1cd2ef3gh4ij5lmno', 'abc123def.abc123defabc123def-abc123def456-abc123def456ghi-abc123defabc123def123', '12', 'abc123def', 'abc123defabc123defabc123def456', '123456780123456780123456780123', 'abc123defabc123defabc123def140123456200abcdefWPabc123defabc123def', 8.00000, 'abc', NULL, NULL, 'abcdef', 'abc123def', NULL, '12345678', 'abcdefghi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8', 'abc(123456789def)', '123456AB12345678', 'abc123defabc123defabc123defabc123defabc123defabc123def2ABC123abcdef123', 9.00000, 88.00000, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'A12345678912345', '1234abc123defabc123defabc123defabc123def123', NULL, 12345.14000, 12345.13000, 12345.12000, 1234.28000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, NULL, NULL, NULL, '2023-01-01 00:00:00', NULL, NULL, '2023-01-01 00:00:00', '2023-01-01 00:00:00', NULL, 'abc123456', NULL, NULL, '123456789', NULL, 'AB123456DEC-12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ABCD_EF_123456', NULL, NULL, NULL, NULL, NULL); Query OK, 1 row affected (0.00 sec) mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> UPDATE table_1 SET `field_23`='null', `field_24`='null', `field_21`='12345678', `field_22`='abcdefghi', `field_32`='123456AB12345678', `field_33`='abc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyz', `field_30`='12', `field_31`='abc' WHERE `id`='abcd1234-1ab2-11ab-a123-1234567a89b0'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> ROLLBACK; ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to reconnect... ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111) ERROR: Can't connect to the server mysql> bin/mysqld_safe: line 199: 17514 Aborted (core dumped) env MYSQLD_PARENT_PID=17274 nohup /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld --no-defaults --basedir=/export/home/tmp/ushastry/mysql-8.0.31 --datadir=/export/home/tmp/ushastry/mysql-8.0.27/109868_31 --plugin-dir=/export/home/tmp/ushastry/mysql-8.0.31/lib/plugin --core-file --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv= --local-infile=1 --log-error=/export/home/tmp/ushastry/mysql-8.0.27/109868_31/log.err --pid-file=support-cluster03.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null >> /export/home/tmp/ushastry/mysql-8.0.27/109868_31/log.err 2>&1 2023-02-01T06:07:50.440150Z mysqld_safe Number of processes running now: 0 2023-02-01T06:07:50.442992Z mysqld_safe mysqld restarted bin/mysqld_safe: line 199: 18404 Aborted (core dumped) env MYSQLD_PARENT_PID=17274 env MYSQLD_PARENT_PID=17274 nohup /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld --no-defaults --basedir=/export/home/tmp/ushastry/mysql-8.0.31 --datadir=/export/home/tmp/ushastry/mysql-8.0.27/109868_31 --plugin-dir=/export/home/tmp/ushastry/mysql-8.0.31/lib/plugin --core-file --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv= --local-infile=1 --log-error=/export/home/tmp/ushastry/mysql-8.0.27/109868_31/log.err --pid-file=support-cluster03.pid --socket=/tmp/mysql.sock --port=3306 < /dev/null >> /export/home/tmp/ushastry/mysql-8.0.27/109868_31/log.err 2>&1 >> /export/home/tmp/ushastry/mysql-8.0.27/109868_31/log.err 2>&1 2023-02-01T06:07:51.281312Z mysqld_safe mysqld from pid file /export/home/tmp/ushastry/mysql-8.0.27/109868_31/support-cluster03.pid ended mysql> -bt (gdb) bt #0 0x00007f6768e2caa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000110a92f in handle_fatal_signal () #2 #3 0x00007f6767068387 in raise () from /lib64/libc.so.6 #4 0x00007f6767069a78 in abort () from /lib64/libc.so.6 #5 0x0000000000db36c8 in my_server_abort() [clone .cold.7] () #6 0x0000000002064eea in my_abort() () #7 0x000000000234221c in ut_dbg_assertion_failed(char const*, char const*, unsigned long) () #8 0x00000000023870d9 in btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*) () #9 0x000000000252e347 in row_undo_mod_clust_low(undo_node_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, dtuple_t const**, unsigned char*, que_thr_t*, mtr_t*, unsigned long) () #10 0x000000000252e919 in row_undo_mod_clust(undo_node_t*, que_thr_t*) () #11 0x0000000002532027 in row_undo_mod(undo_node_t*, que_thr_t*) () #12 0x00000000022be332 in row_undo_step(que_thr_t*) () #13 0x00000000022625e8 in que_run_threads(que_thr_t*) () #14 0x0000000002317767 in trx_rollback_to_savepoint_low(trx_t*, trx_savept_t*) () #15 0x000000000231a864 in trx_rollback_low(trx_t*) () #16 0x000000000231ae00 in trx_rollback_for_mysql(trx_t*) () #17 0x0000000002152d5a in innobase_rollback(handlerton*, THD*, bool) () #18 0x000000000120a64e in ha_rollback_low(THD*, bool) () #19 0x00000000010bdf05 in trx_coordinator::rollback_in_engines(THD*, bool) () #20 0x0000000001ca588f in MYSQL_BIN_LOG::rollback(THD*, bool) () #21 0x000000000120a81a in ha_rollback_trans(THD*, bool) () #22 0x00000000010c01be in trans_rollback(THD*) () #23 0x0000000000fa45e6 in mysql_execute_command(THD*, bool) () #24 0x0000000000fa7fa3 in dispatch_sql_command(THD*, Parser_state*) () #25 0x0000000000faa4f8 in dispatch_command(THD*, COM_DATA const*, enum_server_command) () #26 0x0000000000fab55f in do_command(THD*) () #27 0x00000000010fb0d8 in handle_connection () #28 0x00000000027e7c7a in pfs_spawn_thread () #29 0x00007f6768e27ea5 in start_thread () from /lib64/libpthread.so.0 #30 0x00007f6767130b0d in clone () from /lib64/libc.so.6 (gdb) -bt (gdb) bt #0 0x00007fb12b8d7aa1 in pthread_kill () from /lib64/libpthread.so.0 #1 0x000000000110a92f in handle_fatal_signal () #2 #3 0x00007fb129b13387 in raise () from /lib64/libc.so.6 #4 0x00007fb129b14a78 in abort () from /lib64/libc.so.6 #5 0x0000000000db36c8 in my_server_abort() [clone .cold.7] () #6 0x0000000002064eea in my_abort() () #7 0x000000000234221c in ut_dbg_assertion_failed(char const*, char const*, unsigned long) () #8 0x00000000023870d9 in btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*) () #9 0x000000000252e347 in row_undo_mod_clust_low(undo_node_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, dtuple_t const**, unsigned char*, que_thr_t*, mtr_t*, unsigned long) () #10 0x000000000252e919 in row_undo_mod_clust(undo_node_t*, que_thr_t*) () #11 0x0000000002532027 in row_undo_mod(undo_node_t*, que_thr_t*) () #12 0x00000000022be332 in row_undo_step(que_thr_t*) () #13 0x00000000022625e8 in que_run_threads(que_thr_t*) () #14 0x000000000231908e in trx_rollback_or_clean_recovered(bool) () #15 0x000000000231a0eb in trx_recovery_rollback_thread() () #16 0x0000000002203794 in std::thread::_State_impl > >::_M_run() () #17 0x0000000002a5b21f in execute_native_thread_routine () #18 0x00007fb12b8d2ea5 in start_thread () from /lib64/libpthread.so.0 #19 0x00007fb129bdbb0d in clone () from /lib64/libc.so.6 (gdb) -- error log 2023-02-01T06:07:50.221031Z 9 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:4024:page_zip || optim_err != DB_UNDERFLOW thread 140081704888064 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 2023-02-01T06:07:50Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=53d8f46f67d9f61e2a8d9ba6b79c874d195fcd66 Thread pointer: 0x7f66e0000c40 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7f6750425c80 thread_stack 0x100000 /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x206ab2e] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(print_fatal_signal(int)+0x3c3) [0x110a893] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(my_server_abort()+0x5e) [0x110a99e] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(my_abort()+0xa) [0x2064eea] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x234221c] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*)+0x779) [0x23870d9] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x252e347] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x252e919] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(row_undo_mod(undo_node_t*, que_thr_t*)+0xca7) [0x2532027] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(row_undo_step(que_thr_t*)+0x52) [0x22be332] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(que_run_threads(que_thr_t*)+0xb48) [0x22625e8] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x2317767] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x231a864] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(trx_rollback_for_mysql(trx_t*)+0x260) [0x231ae00] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x2152d5a] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(ha_rollback_low(THD*, bool)+0x12e) [0x120a64e] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(trx_coordinator::rollback_in_engines(THD*, bool)+0x25) [0x10bdf05] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(MYSQL_BIN_LOG::rollback(THD*, bool)+0xcf) [0x1ca588f] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(ha_rollback_trans(THD*, bool)+0x7a) [0x120a81a] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(trans_rollback(THD*)+0x4e) [0x10c01be] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(mysql_execute_command(THD*, bool)+0xf26) [0xfa45e6] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(dispatch_sql_command(THD*, Parser_state*)+0x403) [0xfa7fa3] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(dispatch_command(THD*, COM_DATA const*, enum_server_command)+0x2048) [0xfaa4f8] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(do_command(THD*)+0x1df) [0xfab55f] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x10fb0d8] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x27e7c7a] /lib64/libpthread.so.0(+0x7ea5) [0x7f6768e27ea5] /lib64/libc.so.6(clone+0x6d) [0x7f6767130b0d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (7f66e01b11a0): ROLLBACK Connection ID (thread ID): 9 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file 2023-02-01T06:07:50.440150Z mysqld_safe Number of processes running now: 0 2023-02-01T06:07:50.442992Z mysqld_safe mysqld restarted 2023-02-01T06:07:50.658339Z 0 [Warning] [MY-010097] [Server] Insecure configuration for --secure-file-priv: Current value does not restrict location of generated files. Consider setting it to a valid, non-empty path. 2023-02-01T06:07:50.658387Z 0 [Note] [MY-013932] [Server] BuildID[sha1]=53d8f46f67d9f61e2a8d9ba6b79c874d195fcd66 2023-02-01T06:07:50.658395Z 0 [Note] [MY-010949] [Server] Basedir set to /export/home/tmp/ushastry/mysql-8.0.31/. 2023-02-01T06:07:50.658406Z 0 [System] [MY-010116] [Server] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld (mysqld 8.0.31) starting as process 18404 2023-02-01T06:07:50.663221Z 0 [Note] [MY-012366] [InnoDB] Using Linux native AIO 2023-02-01T06:07:50.663409Z 0 [Note] [MY-010747] [Server] Plugin 'FEDERATED' is disabled. 2023-02-01T06:07:50.663466Z 0 [Note] [MY-010747] [Server] Plugin 'ndbcluster' is disabled. 2023-02-01T06:07:50.663477Z 0 [Note] [MY-010747] [Server] Plugin 'ndbinfo' is disabled. 2023-02-01T06:07:50.663486Z 0 [Note] [MY-010747] [Server] Plugin 'ndb_transid_mysql_connection_map' is disabled. 2023-02-01T06:07:50.665279Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started. 2023-02-01T06:07:50.665319Z 1 [Note] [MY-013546] [InnoDB] Atomic write enabled 2023-02-01T06:07:50.665348Z 1 [Note] [MY-012932] [InnoDB] PUNCH HOLE support available 2023-02-01T06:07:50.665364Z 1 [Note] [MY-012944] [InnoDB] Uses event mutexes 2023-02-01T06:07:50.665369Z 1 [Note] [MY-012945] [InnoDB] GCC builtin __atomic_thread_fence() is used for memory barrier 2023-02-01T06:07:50.665381Z 1 [Note] [MY-012948] [InnoDB] Compressed tables use zlib 1.2.12 2023-02-01T06:07:50.667163Z 1 [Note] [MY-012951] [InnoDB] Using hardware accelerated crc32 and polynomial multiplication. 2023-02-01T06:07:50.667518Z 1 [Note] [MY-012203] [InnoDB] Directories to scan './' 2023-02-01T06:07:50.667549Z 1 [Note] [MY-012204] [InnoDB] Scanning './' 2023-02-01T06:07:50.668207Z 1 [Note] [MY-012208] [InnoDB] Completed space ID check of 5 files. 2023-02-01T06:07:50.668782Z 1 [Note] [MY-012955] [InnoDB] Initializing buffer pool, total size = 128.000000M, instances = 1, chunk size =128.000000M 2023-02-01T06:07:50.675713Z 1 [Note] [MY-012957] [InnoDB] Completed initialization of buffer pool 2023-02-01T06:07:50.678468Z 0 [Note] [MY-011952] [InnoDB] If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). 2023-02-01T06:07:50.678813Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2023-02-01T06:07:50.679077Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2023-02-01T06:07:50.686739Z 1 [Note] [MY-013566] [InnoDB] Double write buffer files: 2 2023-02-01T06:07:50.686771Z 1 [Note] [MY-013565] [InnoDB] Double write buffer pages per instance: 4 2023-02-01T06:07:50.686792Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_0.dblwr' for doublewrite 2023-02-01T06:07:50.686805Z 1 [Note] [MY-013532] [InnoDB] Using './#ib_16384_1.dblwr' for doublewrite 2023-02-01T06:07:50.778134Z 1 [Note] [MY-013883] [InnoDB] The latest found checkpoint is at lsn = 41154543 in redo log file ./#innodb_redo/#ib_redo6. 2023-02-01T06:07:50.778189Z 1 [Note] [MY-012560] [InnoDB] The log sequence number 18375692 in the system tablespace does not match the log sequence number 41154543 in the redo log files! 2023-02-01T06:07:50.778197Z 1 [Note] [MY-012551] [InnoDB] Database was not shutdown normally! 2023-02-01T06:07:50.778202Z 1 [Note] [MY-012552] [InnoDB] Starting crash recovery. 2023-02-01T06:07:50.781193Z 1 [Note] [MY-013086] [InnoDB] Starting to parse redo log at lsn = 41154533, whereas checkpoint_lsn = 41154543 and start_lsn = 41154048 2023-02-01T06:07:50.781207Z 1 [Note] [MY-012550] [InnoDB] Doing recovery: scanned up to log sequence number 41154543 2023-02-01T06:07:50.784575Z 1 [Note] [MY-013083] [InnoDB] Log background threads are being started... 2023-02-01T06:07:50.785136Z 1 [Note] [MY-012532] [InnoDB] Applying a batch of 0 redo log records ... 2023-02-01T06:07:50.785159Z 1 [Note] [MY-012535] [InnoDB] Apply batch completed! 2023-02-01T06:07:50.885363Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_001'. 2023-02-01T06:07:50.886441Z 1 [Note] [MY-013252] [InnoDB] Using undo tablespace './undo_002'. 2023-02-01T06:07:50.887217Z 1 [Note] [MY-012910] [InnoDB] Opened 2 existing undo tablespaces. 2023-02-01T06:07:50.887253Z 1 [Note] [MY-011980] [InnoDB] GTID recovery trx_no: 4757 2023-02-01T06:07:50.891053Z 1 [Note] [MY-013776] [InnoDB] Parallel initialization of rseg complete 2023-02-01T06:07:50.891100Z 1 [Note] [MY-013777] [InnoDB] Time taken to initialize rseg using 4 thread: 3846 ms. 2023-02-01T06:07:50.891180Z 1 [Note] [MY-013023] [InnoDB] 1 transaction(s) which must be rolled back or cleaned up in total 1 row operations to undo 2023-02-01T06:07:50.891187Z 1 [Note] [MY-013024] [InnoDB] Trx id counter is 5121 2023-02-01T06:07:50.892117Z 1 [Note] [MY-012255] [InnoDB] Removed temporary tablespace data file: "ibtmp1" 2023-02-01T06:07:50.892132Z 1 [Note] [MY-012923] [InnoDB] Creating shared tablespace for temporary tables 2023-02-01T06:07:50.892167Z 1 [Note] [MY-012265] [InnoDB] Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... 2023-02-01T06:07:50.924473Z 1 [Note] [MY-012266] [InnoDB] File './ibtmp1' size is now 12 MB. 2023-02-01T06:07:50.924608Z 1 [Note] [MY-013627] [InnoDB] Scanning temp tablespace dir:'./#innodb_temp/' 2023-02-01T06:07:50.951796Z 1 [Note] [MY-013018] [InnoDB] Created 128 and tracked 128 new rollback segment(s) in the temporary tablespace. 128 are now active. 2023-02-01T06:07:50.952008Z 1 [Note] [MY-012976] [InnoDB] 8.0.31 started; log sequence number 41154553 2023-02-01T06:07:50.953036Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended. 2023-02-01T06:07:50.962786Z 1 [Note] [MY-011089] [Server] Data dictionary restarting version '80023'. 2023-02-01T06:07:51.090645Z 1 [Note] [MY-012357] [InnoDB] Reading DD tablespace files 2023-02-01T06:07:51.092912Z 1 [Note] [MY-012356] [InnoDB] Scanned 7 tablespaces. Validated 7. 2023-02-01T06:07:51.096437Z 0 [Note] [MY-013014] [InnoDB] Starting in background the rollback of uncommitted transactions 2023-02-01T06:07:51.096474Z 0 [Note] [MY-013011] [InnoDB] Rolling back trx with id 4756, 1 rows to undo 2023-02-01T06:07:51.096677Z 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0cur.cc:4024:page_zip || optim_err != DB_UNDERFLOW thread 140398030739200 InnoDB: We intentionally generate a memory trap. InnoDB: Submit a detailed bug report to http://bugs.mysql.com. InnoDB: If you get repeated assertion failures or crashes, even InnoDB: immediately after the mysqld startup, there may be InnoDB: corruption in the InnoDB tablespace. Please refer to InnoDB: http://dev.mysql.com/doc/refman/8.0/en/forcing-innodb-recovery.html InnoDB: about forcing recovery. 2023-02-01T06:07:51Z UTC - mysqld got signal 6 ; Most likely, you have hit a bug, but this error can also be caused by malfunctioning hardware. BuildID[sha1]=53d8f46f67d9f61e2a8d9ba6b79c874d195fcd66 Thread pointer: 0x7fb0f000c680 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = 7fb0f6bfcbf8 thread_stack 0x100000 /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(my_print_stacktrace(unsigned char const*, unsigned long)+0x2e) [0x206ab2e] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(print_fatal_signal(int)+0x3c3) [0x110a893] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(my_server_abort()+0x5e) [0x110a99e] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(my_abort()+0xa) [0x2064eea] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(ut_dbg_assertion_failed(char const*, char const*, unsigned long)+0x30c) [0x234221c] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(btr_cur_pessimistic_update(unsigned long, btr_cur_t*, unsigned long**, mem_block_info_t**, mem_block_info_t*, big_rec_t**, upd_t*, unsigned long, que_thr_t*, unsigned long, unsigned long, mtr_t*, btr_pcur_t*)+0x779) [0x23870d9] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x252e347] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x252e919] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(row_undo_mod(undo_node_t*, que_thr_t*)+0xca7) [0x2532027] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(row_undo_step(que_thr_t*)+0x52) [0x22be332] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(que_run_threads(que_thr_t*)+0xb48) [0x22625e8] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(trx_rollback_or_clean_recovered(bool)+0x11ee) [0x231908e] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(trx_recovery_rollback_thread()+0x1b) [0x231a0eb] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld(std::thread::_State_impl > >::_M_run()+0xc4) [0x2203794] /export/home/tmp/ushastry/mysql-8.0.31/bin/mysqld() [0x2a5b21f] /lib64/libpthread.so.0(+0x7ea5) [0x7fb12b8d2ea5] /lib64/libc.so.6(clone+0x6d) [0x7fb129bdbb0d] Trying to get some variables. Some pointers may be invalid and cause the dump to abort. Query (0): Connection ID (thread ID): 0 Status: NOT_KILLED The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains information that should help you find out what is causing the crash. Writing a core file ################ 8.0.27 to 8.0.32 upgrade - not affected rm -rf 109868_32/ bin/mysqld --no-defaults --initialize-insecure --basedir=$PWD --datadir=$PWD/109868_32 --log-error-verbosity=3 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=$PWD/109868_32 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=$PWD/109868_32/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 7 Server version: 8.0.27 MySQL Community Server - GPL Copyright (c) 2000, 2021, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> create database test; Query OK, 1 row affected (0.01 sec) mysql> use test Database changed mysql> CREATE TABLE `table_1` ( `field_14` decimal(20,5) DEFAULT NULL, `field_15` varchar(30) DEFAULT NULL, `field_16` decimal(20,5) DEFAULT NULL, `field_17` varchar(10) DEFAULT NULL, `field_18` varchar(50) DEFAULT NULL, `field_19` varchar(10) DEFAULT NULL, `field_20` varchar(50) DEFAULT NULL, `field_21` varchar(20) DEFAULT NULL, `field_22` varchar(50) DEFAULT NULL, `field_23` varchar(50) DEFAULT NULL, `field_24` varchar(100) DEFAULT NULL, `field_25` varchar(50) DEFAULT NULL, `field_26` varchar(100) DEFAULT NULL, `field_27` varchar(50) DEFAULT NULL, -> `id` varchar(50) NOT NULL, -> `field_1` varchar(100) DEFAULT NULL, -> `field_2` varchar(50) DEFAULT NULL, -> `field_3` varchar(300) DEFAULT NULL, -> `field_4` varchar(300) DEFAULT NULL, -> `field_5` varchar(50) DEFAULT NULL, -> `field_6` varchar(50) DEFAULT NULL, -> `field_7` varchar(50) DEFAULT NULL, -> `field_8` text, -> `field_9` varchar(10) DEFAULT NULL, -> `field_10` varchar(50) DEFAULT NULL, -> `field_11` varchar(100) DEFAULT NULL, -> `field_12` varchar(100) DEFAULT NULL, -> `field_13` varchar(150) DEFAULT NULL, -> `field_14` decimal(20,5) DEFAULT NULL, -> `field_15` varchar(30) DEFAULT NULL, -> `field_16` decimal(20,5) DEFAULT NULL, -> `field_17` varchar(10) DEFAULT NULL, -> `field_18` varchar(50) DEFAULT NULL, `field_28` varchar(150) DEFAULT NULL, `field_29` text, `field_30` varchar(10) DEFAULT NULL, `field_31` varchar(100) DEFAULT NULL, `field_32` varchar(50) DEFAULT NULL, `field_33` varchar(200) DEFAULT NULL, `field_34` decimal(20,5 -> ) DEFAULT NULL, `field_35` decimal(20,5) DEFAULT NULL, `field_36` varchar(50) DEFAULT NULL, `field_37` varchar(50) DEFAULT NULL, `field_38` datetime DEFAULT NULL, `field_39` datetime DEFAULT NULL, `field_40` varchar(50) DEFAULT NULL, `field_41` varchar(16) DEFAULT NULL, `field_19` varchar(10) DEFAULT NULL, `field_42` varchar(20) DEFAULT NULL, `field_43` varchar(100) DEFAULT NULL, `field_44` varchar(50) DEFAULT NULL, `field_45` varchar(100) DEFAULT NULL, `field_46` varchar(50) DEFAULT NULL, `field_47` varchar(100) DEFAULT NULL, `field_48` varchar(50) DEFAULT NULL, `field_49` varchar(100) DEFAULT NULL, `field_50` varchar(50) DEFAULT NULL, `field_51` varchar(100) DEFAULT NULL, `field_52` varchar(50) DEFAULT NULL, `field_53` varchar(150) DEFAULT NULL, `field_54` varchar(100) DEFAULT NULL, `field_55` decimal(20,5) DEFAULT NULL, -> `field_20` varchar(50) DEFAULT NULL, -> `field_21` varchar(20) DEFAULT NULL, `field_56` decimal(20,5) DEFAULT NULL, `field_57` decimal(20,5) DEFAULT NULL, `field_58` decimal(20,5) DEFAULT NULL, `field_59` decimal(20,5) DEFAULT NULL, `field_60` decimal(20,5) DEFAULT NULL, `field_61` decimal(20,5) DEFAULT NULL, `field_62` decimal(20,5) DEFAULT NULL, `field_63` decimal(20,5) DEFAULT NULL, `field_64` decimal(20,5) DEFAULT NULL, `field_65` varchar(50) DEFAULT NULL, `field_66` text, `field_67` varchar(100) DEFAULT NULL, `field_68` datetime DEFAULT NULL, `field_69` datetime DEFAULT NULL, -> `field_22` varchar(50) DEFAULT NULL, -> `field_23` varchar(50) DEFAULT NULL, `field_98` varchar(100) DEFAULT NULL, `field_99` varchar(100) DEFAULT NULL, `field_100` varchar(100) DEFAULT NULL, `field_101` varchar(100) DEFAULT NULL, `field_102` varchar(100) DEFAULT NULL, `field_103` varchar(100) DEFAULT NULL, `field_104` varchar(100) DEFAULT NULL, `field_105` varchar(100) DEFAULT NULL, `field_106` varchar(100) DEFAULT NULL, `field_107` varchar(200) DEFAULT NULL, `field_108` varchar(150) DEFAULT NULL, `field_109` varchar(100) DEFAULT NULL, `field_110` varchar(100) DEFAULT NULL, `field_111` varchar(100) DEFAULT NULL, -> `field_24` varchar(100) DEFAULT NULL, -> `field_25` varchar(50) DEFAULT NULL, -> `field_26` varchar(100) DEFAULT NULL, -> `field_27` varchar(50) DEFAULT NULL, -> `field_28` varchar(150) DEFAULT NULL, -> `field_29` text, -> `field_30` varchar(10) DEFAULT NULL, -> `field_31` varchar(100) DEFAULT NULL, -> `field_32` varchar(50) DEFAULT NULL, -> `field_33` varchar(200) DEFAULT NULL, -> `field_34` decimal(20,5) DEFAULT NULL, -> `field_35` decimal(20,5) DEFAULT NULL, -> `field_36` varchar(50) DEFAULT NULL, -> `field_37` varchar(50) DEFAULT NULL, -> `field_38` datetime DEFAULT NULL, -> `field_39` datetime DEFAULT NULL, -> `field_40` varchar(50) DEFAULT NULL, -> `field_41` varchar(16) DEFAULT NULL, -> `field_42` varchar(20) DEFAULT NULL, -> `field_43` varchar(100) DEFAULT NULL, -> `field_44` varchar(50) DEFAULT NULL, -> `field_45` varchar(100) DEFAULT NULL, -> `field_46` varchar(50) DEFAULT NULL, -> `field_47` varchar(100) DEFAULT NULL, -> `field_48` varchar(50) DEFAULT NULL, -> `field_49` varchar(100) DEFAULT NULL, -> `field_50` varchar(50) DEFAULT NULL, -> `field_51` varchar(100) DEFAULT NULL, -> `field_52` varchar(50) DEFAULT NULL, -> `field_53` varchar(150) DEFAULT NULL, -> `field_54` varchar(100) DEFAULT NULL, -> `field_55` decimal(20,5) DEFAULT NULL, -> `field_56` decimal(20,5) DEFAULT NULL, -> `field_57` decimal(20,5) DEFAULT NULL, -> `field_58` decimal(20,5) DEFAULT NULL, -> `field_59` decimal(20,5) DEFAULT NULL, -> `field_60` decimal(20,5) DEFAULT NULL, -> `field_61` decimal(20,5) DEFAULT NULL, -> `field_62` decimal(20,5) DEFAULT NULL, -> `field_63` decimal(20,5) DEFAULT NULL, -> `field_64` decimal(20,5) DEFAULT NULL, -> `field_65` varchar(50) DEFAULT NULL, -> `field_66` text, -> `field_67` varchar(100) DEFAULT NULL, -> `field_68` datetime DEFAULT NULL, -> `field_69` datetime DEFAULT NULL, -> `field_70` decimal(20,5) DEFAULT NULL, -> `field_71` datetime DEFAULT NULL, -> `field_72` datetime DEFAULT NULL, -> `field_73` varchar(100) DEFAULT NULL, -> `field_74` varchar(20) DEFAULT NULL, -> `field_75` varchar(50) DEFAULT NULL, -> `field_76` varchar(50) DEFAULT NULL, -> `field_77` varchar(50) DEFAULT NULL, -> `field_78` varchar(50) DEFAULT NULL, -> `field_79` varchar(50) DEFAULT NULL, -> `field_80` varchar(50) DEFAULT NULL, -> `field_81` varchar(50) DEFAULT NULL, -> `field_82` varchar(100) DEFAULT NULL, -> `field_83` varchar(100) DEFAULT NULL, -> `field_84` varchar(100) DEFAULT NULL, -> `field_85` varchar(100) DEFAULT NULL, -> `field_86` varchar(100) DEFAULT NULL, -> `field_87` varchar(100) DEFAULT NULL, -> `field_88` varchar(100) DEFAULT NULL, -> `field_89` varchar(100) DEFAULT NULL, -> `field_90` varchar(100) DEFAULT NULL, -> `field_91` varchar(100) DEFAULT NULL, -> `field_92` varchar(100) DEFAULT NULL, -> `field_93` varchar(100) DEFAULT NULL, -> `field_94` varchar(100) DEFAULT NULL, -> `field_95` varchar(100) DEFAULT NULL, -> `field_96` varchar(100) DEFAULT NULL, -> `field_97` varchar(100) DEFAULT NULL, -> `field_98` varchar(100) DEFAULT NULL, -> `field_99` varchar(100) DEFAULT NULL, -> `field_100` varchar(100) DEFAULT NULL, -> `field_101` varchar(100) DEFAULT NULL, -> `field_102` varchar(100) DEFAULT NULL, -> `field_103` varchar(100) DEFAULT NULL, -> `field_104` varchar(100) DEFAULT NULL, -> `field_105` varchar(100) DEFAULT NULL, -> `field_106` varchar(100) DEFAULT NULL, -> `field_107` varchar(200) DEFAULT NULL, -> `field_108` varchar(150) DEFAULT NULL, -> `field_109` varchar(100) DEFAULT NULL, -> `field_110` varchar(100) DEFAULT NULL, -> `field_111` varchar(100) DEFAULT NULL, -> `field_112` varchar(100) DEFAULT NULL, -> `field_113` varchar(100) DEFAULT NULL, -> `field_114` varchar(100) DEFAULT NULL, -> `field_115` varchar(100) DEFAULT NULL, -> `field_116` varchar(100) DEFAULT NULL, -> `field_117` varchar(100) DEFAULT NULL, -> `field_118` varchar(100) DEFAULT NULL, -> `field_119` varchar(60) DEFAULT NULL, -> PRIMARY KEY (`id`) -> ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; Query OK, 0 rows affected, 1 warning (0.03 sec) mysql> ALTER TABLE table_1 -> ADD `field_120` varchar(100) DEFAULT NULL, -> ADD `field_121` varchar(100) DEFAULT NULL, -> ADD `field_122` varchar(100) DEFAULT NULL, -> ADD `field_123` varchar(100) DEFAULT NULL, -> ADD `field_124` varchar(100) DEFAULT NULL, -> ADD `field_125` datetime DEFAULT NULL, -> ADD `field_126` datetime DEFAULT NULL, -> ADD `field_127` varchar(50) DEFAULT NULL, -> ADD `field_128` varchar(400) DEFAULT NULL, -> ADD `field_129` varchar(400) DEFAULT NULL, -> ADD `field_130` varchar(480) DEFAULT NULL, -> ADD `field_131` int DEFAULT NULL, -> ADD `field_132` varchar(255) DEFAULT NULL; Query OK, 0 rows affected (0.03 sec) Records: 0 Duplicates: 0 Warnings: 0 mysql> shutdown; Query OK, 0 rows affected (0.00 sec) -- In place upgrade to 8.0.32 bin/mysqld_safe --no-defaults --mysqld-version='' --basedir=$PWD --datadir=/export/home/tmp/ushastry/mysql-8.0.27/109868_32 --core-file --socket=/tmp/mysql.sock --port=3306 --log-error=/export/home/tmp/ushastry/mysql-8.0.27/109868_32/log.err --mysqlx-port=33330 --mysqlx-socket=/tmp/mysql_x_ushastry.sock --log-error-verbosity=3 --secure-file-priv="" --local-infile=1 2>&1 & bin/mysql -uroot -S /tmp/mysql.sock Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 9 Server version: 8.0.32 MySQL Community Server - GPL Copyright (c) 2000, 2023, Oracle and/or its affiliates. Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may be trademarks of their respective owners. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement. mysql> use test Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> INSERT INTO table_1(`id`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `field_11`, `field_12`, `field_13`, `field_14`, `field_15`, `field_16`, `field_17`, `field_18`, `field_19`, `field_20`, `field_21`, `field_22`, `field_23`, `field_24`, `field_25`, `field_26`, `field_27`, `field_28`, `field_29`, `field_30`, `field_31`, `field_32`, `field_33`, `field_34`, `field_35`, `field_36`, `field_37`, `field_38`, `field_39`, `field_40`, `field_41`, `field_42`, `field_43`, `field_44`, `field_45`, `field_46`, `field_47`, `field_48`, `field_49`, `field_50`, `field_51`, `field_52`, `field_53`, `field_54`, `field_55`, `field_56`, `field_57`, `field_58`, `field_59`, `field_60`, `field_61`, `field_62`, `field_63`, `field_64`, `field_65`, `field_66`, `field_67`, `field_68`, `field_69`, `field_70`, `field_71`, `field_72`, `field_73`, `field_74`, `field_75`, `field_76`, `field_77`, `field_78`, `field_79`, `field_80`, `field_81`, `field_82`, `field_83`, `field_84`, `field_85`, `field_86`, `field_87`, `field_88`, `field_89`, `field_90`, `field_91`, `field_92`, `field_93`, `field_94`, `field_95`, `field_96`, `field_97`, `field_98`, `field_99`, `field_100`, `field_101`, `field_102`, `field_103`, `field_104`, `field_105`, `field_106`, `field_107`, `field_108`, `field_109`, `field_110`, `field_111`, `field_112`, `field_113`, `field_114`, `field_115`, `field_116`, `field_117`, `field_118`, `field_119`, `field_120`, `field_121`, `field_122`, `field_123`, `field_124`, `field_125`, `field_126`, `field_127`, `field_128`, `field_129`, `field_130`, `field_131`, `field_132`) -> VALUES ('abcd1234-1ab2-11ab-a123-1234567a89b0', '123456A78901234', '123456789', 'abcdefghijabcdefghij1', '123456789123456789abc', 'abcdefghijklmn', NULL, 'ab1cd2ef3gh4ij5lmno', 'abc123def.abc123defabc123def-abc123def456-abc123def456ghi-abc123defabc123def123', '12', 'abc123def', 'abc123defabc123defabc123def456', '123456780123456780123456780123', 'abc123defabc123defabc123def140123456200abcdefWPabc123defabc123def', 8.00000, 'abc', NULL, NULL, 'abcdef', 'abc123def', NULL, '12345678', 'abcdefghi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8', 'abc(123456789def)', '123456AB12345678', 'abc123defabc123defabc123defabc123defabc123defabc123def2ABC123abcdef123', 9.00000, 88.00000, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'A12345678912345', '1234abc123defabc123defabc123defabc123def123', NULL, 12345.14000, 12345.13000, 12345.12000, 1234.28000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, NULL, NULL, NULL, '2023-01-01 00:00:00', NULL, NULL, '2023-01-01 00:00:00', '2023-01-01 00:00:00', NULL, 'abc123456', NULL, NULL, '123456789', NULL, 'AB123456DEC-12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ABCD_EF_123456', NULL, NULL, NULL, NULL, NULL); Query OK, 1 row affected (0.01 sec) mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> UPDATE table_1 SET `field_23`='null', `field_24`='null', `field_21`='12345678', `field_22`='abcdefghi', `field_32`='123456AB12345678', `field_33`='abc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyz', `field_30`='12', `field_31`='abc' WHERE `id`='abcd1234-1ab2-11ab-a123-1234567a89b0'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> ROLLBACK; Query OK, 0 rows affected (0.00 sec) mysql> mysql> mysql> -- step 3: insert a record in MySQL 8.0.30, dont't need explicit transction mysql> INSERT INTO table_1(`id`, `field_1`, `field_2`, `field_3`, `field_4`, `field_5`, `field_6`, `field_7`, `field_8`, `field_9`, `field_10`, `field_11`, `field_12`, `field_13`, `field_14`, `field_15`, `field_16`, `field_17`, `field_18`, `field_19`, `field_20`, `field_21`, `field_22`, `field_23`, `field_24`, `field_25`, `field_26`, `field_27`, `field_28`, `field_29`, `field_30`, `field_31`, `field_32`, `field_33`, `field_34`, `field_35`, `field_36`, `field_37`, `field_38`, `field_39`, `field_40`, `field_41`, `field_42`, `field_43`, `field_44`, `field_45`, `field_46`, `field_47`, `field_48`, `field_49`, `field_50`, `field_51`, `field_52`, `field_53`, `field_54`, `field_55`, `field_56`, `field_57`, `field_58`, `field_59`, `field_60`, `field_61`, `field_62`, `field_63`, `field_64`, `field_65`, `field_66`, `field_67`, `field_68`, `field_69`, `field_70`, `field_71`, `field_72`, `field_73`, `field_74`, `field_75`, `field_76`, `field_77`, `field_78`, `field_79`, `field_80`, `field_81`, `field_82`, `field_83`, `field_84`, `field_85`, `field_86`, `field_87`, `field_88`, `field_89`, `field_90`, `field_91`, `field_92`, `field_93`, `field_94`, `field_95`, `field_96`, `field_97`, `field_98`, `field_99`, `field_100`, `field_101`, `field_102`, `field_103`, `field_104`, `field_105`, `field_106`, `field_107`, `field_108`, `field_109`, `field_110`, `field_111`, `field_112`, `field_113`, `field_114`, `field_115`, `field_116`, `field_117`, `field_118`, `field_119`, `field_120`, `field_121`, `field_122`, `field_123`, `field_124`, `field_125`, `field_126`, `field_127`, `field_128`, `field_129`, `field_130`, `field_131`, `field_132`) -> VALUES ('abcd1234-1ab2-11ab-a123-1234567a89b0', '123456A78901234', '123456789', 'abcdefghijabcdefghij1', '123456789123456789abc', 'abcdefghijklmn', NULL, 'ab1cd2ef3gh4ij5lmno', 'abc123def.abc123defabc123def-abc123def456-abc123def456ghi-abc123defabc123def123', '12', 'abc123def', 'abc123defabc123defabc123def456', '123456780123456780123456780123', 'abc123defabc123defabc123def140123456200abcdefWPabc123defabc123def', 8.00000, 'abc', NULL, NULL, 'abcdef', 'abc123def', NULL, '12345678', 'abcdefghi', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '8', 'abc(123456789def)', '123456AB12345678', 'abc123defabc123defabc123defabc123defabc123defabc123def2ABC123abcdef123', 9.00000, 88.00000, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'A12345678912345', '1234abc123defabc123defabc123defabc123def123', NULL, 12345.14000, 12345.13000, 12345.12000, 1234.28000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, 0.00000, NULL, NULL, NULL, '2023-01-01 00:00:00', NULL, NULL, '2023-01-01 00:00:00', '2023-01-01 00:00:00', NULL, 'abc123456', NULL, NULL, '123456789', NULL, 'AB123456DEC-12', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'abc', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 'ABCD_EF_123456', NULL, NULL, NULL, NULL, NULL); ERROR 1062 (23000): Duplicate entry 'abcd1234-1ab2-11ab-a123-1234567a89b0' for key 'table_1.PRIMARY' mysql> mysql> -- step 4: update the record in MySQL 8.0.30, need start a transaction explicit mysql> BEGIN; Query OK, 0 rows affected (0.00 sec) mysql> UPDATE table_1 SET `field_23`='null', `field_24`='null', `field_21`='12345678', `field_22`='abcdefghi', `field_32`='123456AB12345678', `field_33`='abc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyzabc123xyz', `field_30`='12', `field_31`='abc' WHERE `id`='abcd1234-1ab2-11ab-a123-1234567a89b0'; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> ROLLBACK; Query OK, 0 rows affected (0.00 sec) mysql> shutdown; Query OK, 0 rows affected (0.00 sec)