[Jacques Philip]

'peterlaursen' wrote:

There is a similar report here http://bugs.mysql.com/bug.php?id=5151 (it is with a very early 5.0 server and fixed 5+ years ago in the server code).

Please also read this FAQ:

http://www.webyog.com/faq/content/1/178/en/sqlyog-is-a-client-for-the-mysql-server-_-but-what-server-versions-are-supported.html

As I said, I fixed my problem by fixing the views, I just mentioned this to you because I thought it would be a good feature of Sqlyog to report when views reference objects that do not exist so that I can fix those, but if you do not think so, fine with me.

It does not matter if it crashes the server or not, it would just be a nice feature.

[Jacques Philip]

'peterlaursen' wrote:

If the MySQL server crashes is is a bug in the MySQL server and not in SQLyog.

You should report such here: http://bugs.mysql.com

There is nothing wrong with MySql, when I list the views with MySql Administrator, it tells me which views are invalid and does not try to create a temporary table for those views.

Quote:

Or do you mean that SQLyog crashes? And what does it meant that “some views have invalid fields or tables”?

MySql crashes means it stops and does not restart. It can be restarted manually though and runs fine as long as we do not try to list the database objects with Sqlyog.

The last thing it does reported in the log is that it tries to create a temporary table for a view that uses tables that have been deleted from the database. Again, this does not happen with MySql administrator and I believe it does not necessarily cause a crash with Sqlyog as I had invalid views in the past that did not cause problem. (It may be that the missing table have to be part of a certain type of join to cause a crash).

I am not sure if the code you have to list the views in Sqlyog allows you to verify that they use valid objects or if you can prevent MySql from creating a temporary table for the view at that point, looking at the source code of MySql administrator may help.

We fixed our problem by correcting or deleting the invalid views, but never the less, I think Sqlyog should have more error checking and report the views that are invalid instead of doing something resulting in creating a temporary table involving non existing objects.

[Author]

Posts