Bug #22709 admin: crash when viewing db with impossible view
Submitted: 26 Sep 2006 19:32 Modified: 7 Nov 2006 7:37
Reporter: Maciej Pilichowski Email Updates:
Status: Can't repeat Impact on me:
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.24a OS:Linux (opensuse 10.0)
Assigned to: CPU Architecture:Any

[26 Sep 2006 19:32] Maciej Pilichowski
Create view, ensure it is working. Then drop the table on which the view depends. Run Admin (GUI), select the database where the view is. CRASH.

How to repeat:
See above.

Suggested fix:
Do not try to show the impossible view, just mark it.
[26 Sep 2006 19:50] MySQL Verification Team
Thank you for the bug report. I was unable to repeat with current source server
5.0 and MySQL Administrator 1.2.3rc. Which version of Administrator are you
using and which crashes the GUI-tool or the server?

Thanks in advance.
[27 Sep 2006 6:48] Maciej Pilichowski
SQLAdmin (GUI) comes from latest stable suite from MySQL RPMs. When I run it it displays such information in client section:
Version: 5.1.11

When I run About -- Version 1.2.3rc.
[28 Sep 2006 1:17] MySQL Verification Team
Thank you for the feedback. Still I was unable to repeat, could you please
start the GUI tool using a console command and print here the messages launched when it crashed. Thanks in advance.
[28 Sep 2006 7:01] Maciej Pilichowski
Not much:
/usr/bin/mysql-administrator: line 103:  9334 Segmentation fault      $PRG-bin $args

Maybe I just include the scripts, it is about 40 lines long and it is highly reproduceable.
[3 Oct 2006 1:17] MySQL Verification Team
Thank you for the feedback. Please attach the script using the File tab here.
Thanks in advance.
[3 Oct 2006 9:12] Maciej Pilichowski

Attachment: starter.sql (text/plain), 4.46 KiB.

[3 Oct 2006 9:12] Maciej Pilichowski

Attachment: norm.sql (text/plain), 1.60 KiB.

[3 Oct 2006 9:14] Maciej Pilichowski
Just to ensure everything is ok drop an create db test. Then apply part1 & part2 to mysql. Run Admin. Click on test db. 

Now, exit Admin, run mysql
drop table biblio;

run Admin again, choose test db again --> crash.
[6 Nov 2006 16:28] MySQL Verification Team
Showing error

Attachment: ma-bug22709.png (image/png, text), 67.47 KiB.

[6 Nov 2006 16:31] MySQL Verification Team
Thank you for the feedback. I was unable to repeat on Suse 10.0/10.1. I
attached a screenshot with final step.
[6 Nov 2006 17:06] Maciej Pilichowski
Miguel, what exactly version of mysql-server do you use? If not some SVN I will install it, and repeat all steps from empty test db.
[6 Nov 2006 18:10] MySQL Verification Team
I ran the test against a today source server 5.0.29.
[7 Nov 2006 7:37] Maciej Pilichowski
I downloaded 5.0.26 -- would it possible to use 5.0.26 or at least 5.0.27? I would like to set the same testing components.

(5.0.26 -> crashes).