Percona Server Crashing when the stored procedure called the second time in the same session

Description

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.

  1. create schema (few tables)

  2. create views

  3. insert sample test data

  4. 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.

Environment

Percona Server 5.7.21 & 5.7.22 

AFFECTED CS IDs

232030

Attachments

1

Smart Checklist

Activity

Show:
Done

Details

Assignee

Reporter

Upstream Bug URL

Needs Review

Yes

Original estimate

Time tracking

1h 8m logged53m remaining

Fix versions

Affects versions

Priority

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
Loading...