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:
None 
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 
Description:
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 
part1

Attachment: starter.sql (text/plain), 4.46 KiB.
[3 Oct 2006 9:12] Maciej Pilichowski 
part2

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