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.