| Bug #114738 | tried to purge non-delete-marked record in index `idx_code` of table | ||
|---|---|---|---|
| Submitted: | 23 Apr 8:03 | Modified: | 23 Apr 9:38 |
| Reporter: | HULONG CUI | Email Updates: | |
| Status: | Can't repeat | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 8.0.27 | OS: | Any (Linux) |
| Assigned to: | CPU Architecture: | Any | |
[23 Apr 9:38]
MySQL Verification Team
Hi Mr. CUI, Thank you for your bug report. However, let us inform you about this forum. This forum is only for the bug reports with fully repeatable test cases. A test case should consist of the set of SQL statements that always lead to abnormal behaviour, such as it happens to you. Beside SQL statements, test case can also contain configuration info. The problem that you report here looks more like a problem with commodity hardware. Low quality hardware has transient errors that can lead to the situation as you describe. This errors are transient, which means that those can not be caught by hardware diagnostic tools. We can not process any report, including this one, which does not contain a test case as described above. You are also using ancient release of the version 8.0. Current release is 8.0.36. Can't repeat.
Description: when use mysql server. no ddl option，but suddenly crash。 error log： 2024-04-23T08:29:23.982401+08:00 0 [ERROR] [MY-012833] [InnoDB] tried to purge non-delete-marked record in index `idx__code` of table `site`.`table_times`: tuple: TUPLE (info_bits=0, 2 n_cmp=2, fields): {[5]57101(0x3537313031),[8] sSG2(0x0000000073534732)}, record: COMPACT RECORD(info_bits=0, 2 fields): {[5]57101(0x3537313031),[8] sSG2(0x0000000073534732)} 2024-04-23T08:29:24.006414+08:00 0 [ERROR] [MY-011853] [InnoDB] Corruption of an index tree: table `site`.`table_times` index `idx_code`, father ptr page no 290778, child page no 2907 2024-04-23T08:29:24.025745+08:00 0 [ERROR] [MY-013183] [InnoDB] Assertion failure: btr0btr.cc:707:ib::fatal triggered thread 139737450100480 mysqld got signal 6 。。。 /usr/sbin/mysqld(btr_compress) /usr/sbin/mysqld(btr_cur_compress_if_userful) /usr/sbin/mysqld(btr_cur_pessimistic_delete) How to repeat: can't repeat