Percona Server Crashing when the stored procedure called the second time in the same session
General
Escalation
General
Escalation
Description
Environment
Percona Server 5.7.21 & 5.7.22
AFFECTED CS IDs
232030
Attachments
1
Smart Checklist
Activity
Show:

Kamil Holubicki October 25, 2022 at 1:06 PM
Done
Details
Details
Assignee

Reporter

Labels
Upstream Bug URL
Needs Review
Yes
Original estimate
Time tracking
Fix versions
Priority
Smart Checklist
Open Smart Checklist
Smart Checklist

Open Smart Checklist
Created August 22, 2018 at 1:28 PM
Updated March 6, 2024 at 12:55 PM
Resolved April 26, 2022 at 10:10 AM
Hi Team,
Customer has PXC set up where second INSERT into a table is crashing the server. It is told that there is an INSERT AFTER trigger for this table where a stored procedure is being called. Later, we could see even calling the stored procedure second time in the same session is resulting the crash.
How to repeat.
A SQL script having the queries required to re produce this are attached. I can say there are below steps.
create schema (few tables)
create views
insert sample test data
create stored procedure.
Now, you can re produce the crash either by doing the INSERTs as below
OR by calling the stored procedure twice as given below.
Please look into this.