Issues
- Rollback causes MySQL to crash and restartPS-8892Resolved issue: PS-8892
- Percona Server for MySQL 5.7/8.0 + mysql:metrics on Ubuntu leads to CPU usage 25-30 %PS-7752Resolved issue: PS-7752Lalit Choudhary
- Upgrade Go version to 1.19PMM-10709Resolved issue: PMM-10709Nurlan Moldomurov
- Additional spaces in email/passwords fields on Sign up/Login pages causes Authentication problemsPMM-8196Resolved issue: PMM-8196Nicola Lamacchia
- Update docs and cluster staging job with psmdb 1.8.0PMM-8099Resolved issue: PMM-8099Former user
- [BE] QAN not handling properly the url encode for variables using colon (:)PMM-8097Resolved issue: PMM-8097Dávid Mikuš
- Community footer link brokenPMM-8095Resolved issue: PMM-8095Fábio Da Silva
- DBaaS: Paused clusters stuck with PSMDB v1.8PMM-8094Resolved issue: PMM-8094Former user
- Collect and present additional ProxySQL metrics taken from `runtime_mysql_servers` tablePMM-8091Resolved issue: PMM-8091Vadim Yalovets
- [DBaaS] controller leaves kubeconfig behind in case of errorPMM-8088Resolved issue: PMM-8088
- [IA] [UI] If i copy alert rule sometimes it is copied with active status of parent and sometimes notPMM-8086Resolved issue: PMM-8086Fábio Da Silva
- Dashboards: Wrong units are used in MongoDB dashboards on memory-related panelsPMM-8085Resolved issue: PMM-8085Vadim Yalovets
- Integrated Alerting: Alert template .yaml is not recognizedPMM-8069Resolved issue: PMM-8069Dávid Mikuš
- Postgres_exporter CPU usage is increasing after upgrade to 2.17.0PMM-8065
- Integrated Alerting: Firing alerts disappear after docker restartPMM-8058Resolved issue: PMM-8058Artem Gavrilov
- mongodb_exporter keep printing connection error messge for invalid connection due to credentialsPMM-8056
- PGStatMonitor Agent's Status is not displaying on Inventory pagePMM-8054
- 'An unexpected error happened' when accessing Settings page as non-adminPMM-8053Resolved issue: PMM-8053Fábio Da Silva
- Release 2.17 testing (Zoriana)PMM-8048Resolved issue: PMM-8048
- Release 2.17 testing (Vojtech)PMM-8047Resolved issue: PMM-8047Vojtech Koval
- Release 2.17 testing (Beata)PMM-8046Resolved issue: PMM-8046
- Release 2.17 testing (Nailya)PMM-8044Resolved issue: PMM-8044
- DBaaS: Expected Consumed and actual Consumed resources don't always matchPMM-8039Resolved issue: PMM-8039
- "Query Analytics" misspelt on left side menuPMM-8021Resolved issue: PMM-8021Tiago Mota
- i/o timeout when trying to add MongoDB monitoringPMM-8020Resolved issue: PMM-8020
- Error when adding Amazon RDS MySQL with TLS over APIPMM-8014Resolved issue: PMM-8014Jiří Čtvrtka
- Better error handling when pg_stat_monitor has an unsupported versionPMM-8001Resolved issue: PMM-8001Jiří Čtvrtka
- QAN with PMM shows "Table not found: sql: no rows in result set" instead of table info when table is not in public schemaPMM-7992
- Query Analytics: Sorting element for the columns is hard to accessPMM-7982Resolved issue: PMM-7982Fábio Da Silva
- DBaaS: Confusing message for Cluster name pattern on DB Cluster creation screenPMM-7970Resolved issue: PMM-7970Tiago Mota
- QAN: Filter does not handle ":"PMM-7967Resolved issue: PMM-7967Tiago Mota
- Postgresql duplicating global queries per datnamePMM-7956
- `pmm-admin list` reports the wrong Node for External ServicesPMM-7948Resolved issue: PMM-7948Dávid Mikuš
- Missing Mongos metrics on the PMM 2.15.1PMM-7947Resolved issue: PMM-7947Santo Leto
- mongodb_exporter provides a wrong replication status valuePMM-7941Resolved issue: PMM-7941
- mysqld_exporter using too much memoryPMM-7940Resolved issue: PMM-7940Nailya Kutlubaeva
- Inconsistent format of version reporting in pmm-adminPMM-7939Resolved issue: PMM-7939
- [DOC] Simple Backup and RestorePMM-7934Resolved issue: PMM-7934Fábio Da Silva
- DBaaS: Invalid Number of Nodes results in bad requestPMM-7911Resolved issue: PMM-7911
- MongoDB Query Collector never recovers from failed cursorPMM-7910Resolved issue: PMM-7910Carlos Salguero
- DBaaS: Improve resources of multi-node clustersPMM-7904Resolved issue: PMM-7904
- Upgrade Go version to 1.16PMM-7902Resolved issue: PMM-7902Nurlan Moldomurov
- DBaaS: Wrong HTML titlePMM-7889Resolved issue: PMM-7889
- Add instance: Fix error for failed Azure authPMM-7880Jiří Čtvrtka
- Improve UI space usage for Query AnalyticsPMM-7877
- PMM can't monitor MongoDB arbiter nodesPMM-7802Resolved issue: PMM-7802Carlos Salguero
- Creating new notifications, while older ones are vanishing.PMM-7782Resolved issue: PMM-7782Fábio Da Silva
- Swagger information for RDS/Add is inaccuratePMM-7773
- DBaaS: Clusters with longer name not initializingPMM-7755Resolved issue: PMM-7755Tiago Mota
- DBaaS: Cluster logs mixed up together when using the same cluster namePMM-7754Resolved issue: PMM-7754
Rollback causes MySQL to crash and restart
Description
Environment
Master slave architecture, one master and one slave;
Attachments
Details
Details
Assignee
Reporter
Labels
Found by Automation
Planned Version/s
Needs QA
Components
Affects versions
Priority

Smart Checklist
Smart Checklist
Activity
Aaditya Dubey December 10, 2023 at 6:37 AM
Hi @zongyang ,
We still haven't heard any news from you. So I assume issue does not persist anymore and will close the ticket. If you disagree just reply and create a follow-up new Jira Ticket.
Aaditya Dubey October 10, 2023 at 9:14 AM
Hi @zongyang,
Thank you for the report.
Looks like it is happening due to corruption, However will be great if you have test case which repeats this issue, Please share if you have one.
zongyang August 23, 2023 at 10:22 AM
Important parameter configuration:
buffer pool
innodb_buffer_pool_size = 96g
innodb_buffer_pool_instances = 8
innodb_log_file_size = 1g
innodb_sort_buffer_size = 4194304
innodb_log_buffer_size = 134217728
temp table
max_heap_table_size = 67108864
tmp_table_size = 67108864
undo log
innodb_undo_tablespaces=4
innodb_undo_logs=128
innodb_max_undo_log_size=5G
innodb_undo_log_truncate = 1
innodb_purge_rseg_truncate_frequency=128
The database deployed in a private environment crashes and restarts MySQL due to rollback. The error message is as follows:
2023-08-23T01:29:40.351223Z 142838 [ERROR] InnoDB: trying to read page [page id: space=977910041, page number=655360] in nonexisting or being-dropped tablespace
2023-08-23T01:29:40.351226Z 142838 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=977910041, page number=655360], I/O length: 16384 bytes
2023-08-23T01:29:40.351230Z 142838 [ERROR] InnoDB: trying to read page [page id: space=977910041, page number=655360] in nonexisting or being-dropped tablespace
2023-08-23T01:29:40.351233Z 142838 [ERROR] InnoDB: Trying to do I/O to a tablespace which does not exist. I/O type: read, page: [page id: space=977910041, page number=655360], I/O length: 16384 bytes
2023-08-23T01:29:40.351236Z 142838 [ERROR] InnoDB: trying to read page [page id: space=977910041, page number=655360] in nonexisting or being-dropped tablespace
2023-08-23T01:29:40.368657Z 142838 [ERROR] [FATAL] InnoDB: Unable to read page [page id: space=977910041, page number=655360] into the buffer pool after 100 attempts. The most probable cause of this error may be that the table has been corrupted. Or, the table was compressed with with an algorithm that is not supported by this instance. If it is not a decompress failure, you can try to fix this problem by using innodb_force_recovery. Please see http://dev.mysql.com/doc/refman/5.7/en/ for more details. Aborting...
2023-08-23 01:29:40 0x7f2959ce3700 InnoDB: Assertion failure in thread 139815577073408 in file ut0ut.cc line 924
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/5.7/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
01:29:40 UTC - mysqld got signal 6 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
Attempting to collect some information that could help diagnose the problem.
As this is a crash and something is definitely wrong, the information
collection process might fail.
Please help us make Percona Server better by reporting any
bugs at https://bugs.percona.com/
key_buffer_size=8388608
read_buffer_size=131072
max_used_connections=679
max_threads=4097
thread_count=524
connection_count=523
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 1639374 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
Build ID: Not Available
Server Version: 5.7.43-47-log Percona Server (GPL), Release 47, Revision ff1a4d42212
Thread pointer: 0x7f2518093500
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 = 7f2959ce2e10 thread_stack 0x40000
mysqld(my_print_stacktrace+0x3f)[0xf3a08f]
mysqld(handle_fatal_signal+0x5a1)[0xd69441]
/lib64/libpthread.so.0(+0x12cf0)[0x7f42ed3bbcf0]
/lib64/libc.so.6(gsignal+0x10f)[0x7f42eb541acf]
/lib64/libc.so.6(abort+0x127)[0x7f42eb514ea5]
mysqld[0x786443]
mysqld[0x7867e1]
mysqld(_Z16buf_page_get_genRK9page_id_tRK11page_size_tmP11buf_block_tmPKcmP5mtr_tbP7dberr_t+0x598)[0x11d90a8]
mysqld(_Z32btr_free_externally_stored_fieldP12dict_index_tPhPKhPKmP14page_zip_des_tmbP5mtr_t+0x3d9)[0x11b8829]
mysqld(_Z26btr_cur_pessimistic_updatemP9btr_cur_tPPmPP16mem_block_info_tS4_PP9big_rec_tP5upd_tmP9que_thr_tmP5mtr_t+0x2dc)[0x11b937c]
mysqld[0x12cfe31]
mysqld[0x12d0a85]
mysqld(_Z12row_undo_modP11undo_node_tP9que_thr_t+0xbd5)[0x12d3855]
mysqld(_Z13row_undo_stepP9que_thr_t+0x7a)[0x1115cca]
mysqld(_Z15que_run_threadsP9que_thr_t+0xc80)[0x10a1d50]
mysqld[0x116be0f]
mysqld[0x116c750]
mysqld(_Z22trx_rollback_for_mysqlP5trx_t+0x338)[0x116cc88]
mysqld[0xfec30b]
mysqld(_Z15ha_rollback_lowP3THDb+0xef)[0x7c19ff]
mysqld(_ZN13MYSQL_BIN_LOG8rollbackEP3THDb+0xbd)[0xed68ed]
mysqld(_Z17ha_rollback_transP3THDb+0x82)[0x7c1b72]
mysqld(_Z14trans_rollbackP3THD+0x2e)[0xd37d3e]
mysqld(_Z21mysql_execute_commandP3THDb+0x35ce)[0xc8860e]
mysqld(_Z11mysql_parseP3THDP12Parser_stateb+0x505)[0xc8cd75]
mysqld(_Z16dispatch_commandP3THDPK8COM_DATA19enum_server_command+0xf96)[0xc8ddc6]
mysqld(_Z10do_commandP3THD+0x1ff)[0xc8f4cf]
mysqld(handle_connection+0x2e0)[0xd50110]
mysqld(pfs_spawn_thread+0x15b)[0xf588fb]
/lib64/libpthread.so.0(+0x81ca)[0x7f42ed3b11ca]
/lib64/libc.so.6(clone+0x43)[0x7f42eb52ce73]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (7f2518012480): rollback
Connection ID (thread ID): 142838
Status: NOT_KILLED