Bug #28451 mysql could not fetch schema table status
Description:
Hi there,
I have reported a bug a while ago (Bug #28140) but I do not seem to receive any news on how to solve it.
This is what I was asked to do:
[2 May 18:06] Miguel Solorzano
Thank you for the feedback. I was not able to repeat either on XP or
Vista. Could you please, stop the service service, edit the my.ini
file adding the general query log:
[mysqld]
# The TCP/IP Port the MySQL Server will listen on
port=3307
log
then start the service again, test the issue reported with MA and
then stop the server and print here the contain od computer_name.log
file.
And here is the text of the .log file:
C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqld-nt, Version:
5.0.37-community-nt-log (MySQL Community Edition (GPL)). started with:
TCP Port: 3306, Named Pipe: (null)
Time Id Command Argument
070508 17:43:36 1 Connect root@localhost on dvdrentals
1 Query SET NAMES utf8
1 Query show databases
1 Query show databases
2 Connect root@localhost on
2 Query SELECT @@sql_mode
2 Query SET SESSION
sql_mode='STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'
2 Query SET NAMES utf8
2 Quit
070508 17:43:44 1 Init DB dvdrentals
1 Query SHOW TABLE STATUS
1 Query SHOW INDEX FROM `customers`
1 Query DESCRIBE `customers`
1 Init DB dvdrentals
070508 17:43:46 1 Init DB dvdrentals
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB dvdrentals
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
070508 17:43:48 1 Init DB test
1 Query SHOW TABLE STATUS
070508 17:43:49 1 Query SHOW INDEX FROM `new table`
1 Query DESCRIBE `new table`
1 Init DB dvdrentals
070508 17:43:50 1 Init DB test
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB test
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
1 Init DB mysql
1 Query SHOW TABLE STATUS
070508 17:43:51 1 Query SHOW INDEX FROM `columns_priv`
1 Query DESCRIBE `columns_priv`
1 Init DB dvdrentals
070508 17:43:52 1 Init DB mysql
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB mysql
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
1 Init DB information_schema
1 Query SHOW TABLE STATUS
1 Query SHOW INDEX FROM `CHARACTER_SETS`
1 Query DESCRIBE `CHARACTER_SETS`
1 Init DB dvdrentals
070508 17:43:53 1 Init DB information_schema
1 Query SHOW TABLE STATUS
1 Init DB dvdrentals
1 Init DB information_schema
1 Query SHOW PROCEDURE STATUS
1 Init DB dvdrentals
Could anyone help me please?
Thanks in advance.
How to repeat:
I have installed MySql Server 5.0 and MySql Administrator 1.2.11 on a XP Home Edition.
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.052 sec. using MySQL 8.4.7-u6-cloud
Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the
respective copyright holders.
It is not reviewed in advance
by Oracle and does not necessarily represent the opinion of
Oracle or any other party.