Create_tables.txt
error_12Sep21.log
explain.txt
[MDEV-26596] MariaDB crashes with specific query Created: 2021-09-12 Updated: 2021-09-13 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | Data Manipulation - Update |
| Affects Version/s: | 10.6.4 |
| Fix Version/s: | None |
| Type: | Bug | Priority: | Critical |
| Reporter: | MARKUS Wynand Coetzer | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 0 |
| Labels: | crash | ||
| Environment: |
Ubuntu 18.04.5 LTS |
||
| Attachments: |
Create_tables.txt
error_12Sep21.log
explain.txt
|
| Description |
|
The DB crashes as in stops completely and needs to be restarted whenever a specific query is executed. However, it appears to only crash when the query is executed in a trigger or a stored procedure. The exact query is in the attached error log. |
| Comments |
| Comment by Daniel Black [ 2021-09-13 ] |
|
Markus, Thanks for the bug report. Can you include SHOW CREATE TABLE information for those tables in this query? |
| Comment by MARKUS Wynand Coetzer [ 2021-09-13 ] |
|
Thank you very much for the prompt response, Daniel. I added two files, with the creation SQL and the explain output. However, in order to be able to execute the explain statement, I had to replace the New.individual_id and New.company_id with parameters :individual_id and :company_id. If I do that and execute the query, it runs without the crash. The crash only happens when the query runs inside a trigger or, I am pretty sure, also when it runs in a stored procedure. Another observation: It also seems that if the trigger is activated once, it mostly succeeds, but when an action on a number of rows activates the trigger repetively, it fails. Please contact me if you need anything else. I will try my best to help asap. Regards Wynand |
| Comment by MARKUS Wynand Coetzer [ 2021-09-13 ] |
|
Sorry, the trigger is attached to the table fit_ind_exemption. |