server crashes at 'SHOW CREATE VIEW' query after upgrading to 8.0.34-26
Description
Environment
Debian Linux 11.8 64bit
Linux Kernel 5.15.146 64bit
Percona MySQL 8.0.34-26 built from sources
Activity
Aaditya Dubey February 3, 2024 at 6:12 AM
Hi
Verified as described.
Thank you connecting Percona!
Georgi Georgiev February 2, 2024 at 4:55 PM
Hello ,
The issue is reproducable with a freshly installed PS 8.0.34 or 8.0.35 from the Percona Debian repo. I have created a temporary test DigitalOcean droplet instance with Debian 11 and installed the latest PS 8.0.35 following this guide: . Then executed the steps from the description above and successfully reproduced the issue. You can log in and test for yourself. The IP of the test droplet is 134.122.80.90 and the root password for the OS and the mysql server is Percona9090TestPass. The steps to reproduce:
Aaditya Dubey January 31, 2024 at 11:56 AM
Hi
Thank you for the report.
Unfortunately i’m unable to repeat this behaviour from my end, could you please let me know the following information?
From which version you upgraded to PS 8.0.34?
In PS 8.0.35 you upgraded from PS 8.0.34?
Please share complete test case which could be helpful to repeat the issue?
Georgi Georgiev January 30, 2024 at 1:21 PM
I cant figure out how to create an attachment, so here is the mysql-error.log:
And here is the sakila-schema.sql:
Details
Details
Assignee
Reporter
Georgi GeorgievUpstream Bug URL
Needs QA
Affects versions
Priority
HighSmart Checklist
Open Smart Checklist
Smart Checklist
Ater upgrading to Percona MySQL 8.0.34-26 the server started crashing (see the attached mysql-error.log). I found out that the crash happens when using SHOW CREATE VIEW for a view with SECURITY=DEFINER and a DEFINER set to a non existent user. I am attaching the database schema sakila-schema.sql. Here is how to reproduce:
As root mysql user:
As sakila@localhost mysql user:
As root mysql user:
The issue also exists in the latest version 8.0.35-27.