[MDEV-24605] Assertion failure in file storage/innobase/log/log0log.cc line 631 (signal 6) Created: 2021-01-16 Updated: 2022-02-17 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Storage Engine - InnoDB |
| Affects Version/s: | 10.5.8 |
| Fix Version/s: | 10.5 |
| Type: | Bug | Priority: | Major |
| Reporter: | Alexander Mikhailov | Assignee: | Marko Mäkelä |
| Resolution: | Unresolved | Votes: | 2 |
| Labels: | None | ||
| Environment: |
FreeBSD 12.2-RELEASE-p2, mariadb105-server compiled from ports, options INNOBASE and GSSAPI_NONE only. |
||
| Description |
|
2021-01-16 12:16:31 0xb3b3e0f00 InnoDB: Assertion failure in file storage/innobase/log/log0log.cc line 631 To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.5.8-MariaDB Thread pointer: 0xb431f78d8 Connection ID (thread ID): 1974000 Optimizer switch: index_merge=on,index_merge_union=on,index_merge_sort_union=on,index_merge_intersection=on,index_merge_sort_intersection=off,engine_condition_pushdown=off,i The manual page at https://mariadb.com/kb/en/how-to-produce-a-full-stack-trace-for-mysqld/ contains |
| Comments |
| Comment by Alexander Mikhailov [ 2021-01-16 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
I'm using a following procedure every 10-15 mins to recalculate prices based on suppliers data (changes every 5-10 mins)
Sometimes mariadb GOT signal 6, started from 10.5.6 version | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Alexander Mikhailov [ 2021-01-16 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
mariadb startup options. As I can see in storage/innobase/log/log0log.cc around line 631 it could be connected to disabled double write (on zfs it only lowers performance)
| ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Alexander Mikhailov [ 2021-07-04 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Still getting this issue on versions 10.5.7 - 10.5.11 Latest unaffected version is 10.5.6 | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Alexander Mikhailov [ 2021-09-22 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Still getting same error on 10.5.12 with | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by RG [ 2021-12-14 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Same error in mariadb-server-10.5 on Debian 11 (10.5.12-0+deb11u1)
| ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by RG [ 2021-12-16 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
Same error in 10.5.13 from Mariadb repo | ||||||||||||||||||||||||||||||||||||||||||||||||
| Comment by Alexander Mikhailov [ 2022-02-17 ] | ||||||||||||||||||||||||||||||||||||||||||||||||
|
It seems this bug could be the same as recently fixed |