[MDEV-31818] Server crashes in choose_best_splitting - Jira

XML

Word

Printable

Details

Type: Bug
Status: Open (View Workflow)
Priority: Major
Resolution: Unresolved
Affects Version/s: 10.11.2, 10.11.4
Fix Version/s: 10.11
Component/s: Server
Labels:
- crash
Environment:
ProLiant DL360 Gen10, 48 cores, 128GB memory, Centos 8

Description

We have a primary with 2 replicas and have seen a crash where both replicas crash almost simultaneously at the same query. At other times during the day the same query has had no problems and unfortunately we have not managed to replicate this either.
So far we have seen exactly the same behaviour only once more two weeks ago where a very similar query crashed both replication servers.
In both cases there was a bulk import running on the primary server that got replicated to the crashing replicas, but on a different schema and table that is requested in the query.

Attachments

- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

2023-08-03-mariaDB-logs.zip
14 kB
2023-08-03 08:57
2023-11-08-mariaDB-logs.zip
4 kB
2023-11-08 11:20
xtradb-3.mariadb.log
24 kB
2023-08-01 10:31
xtradb-4.mariadb.log
45 kB
2023-08-01 10:31

Issue Links

relates to

MDEV-31403 Server crashes in st_join_table::choose_best_splitting (still)

Closed

MDEV-31440 choose_best_splitting: crash on update query using correlated subquery after minor update

Confirmed

MDEV-32064 Crash when searching for the best split of derived table

Closed

Activity

People

Assignee:: Sergei Petrunia

Reporter:: Christian Braeuner

Votes:: 2 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2023-08-01 10:44

Updated:: 2024-01-30 14:38

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.