Bug #3326 error log feature request
Submitted: 29 Mar 2004 9:02 Modified: 20 Dec 2005 9:54
Reporter: NOT_FOUND NULL ! Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S4 (Feature request)
Version:4.0.18 OS:Windows (windows)
Assigned to: CPU Architecture:Any

[29 Mar 2004 9:02] NOT_FOUND NULL !
Description:
I would like to see messages like

     Incorrect key file for table: 'referenceEntries'. Try to repair it

posted to the mysql error log in addition to being sent to the user.

I would also like the sql command that was attempted posted to the mysql error log.

For example, I would like the error log to look something like...

MySQL: ready for connections.
Version: '4.0.18-max-nt-log'  socket: ''  port: 3306
040323  8:46:41  Incorrect key file for table: 'referenceEntries'. Try to repair it 
attempted query was: UPDATE referenceEntries  		SET heading = 'Balanced Budget - Consitution (U.S.) Amendment',  			body = 'Calling on Congress to convene a constitutional convention to draft a balanced budget amendment (we do not yet have an amendment to ratify) 5/92    HCR 31, 65th R.S. 1977 (passed -- pp. 3257-3268, Author: Donaldson, Sponsor: Moore)  HCR 40, 65th R.S. 1977 DID NOT PASS  HCR 13, 65th 2nd C.S. 1978 (passed -- pp. 41-42 Author: Von Dohlen, Sponsor: Hance)  HCR 9, 64th R.S. 1975 DID NOT PASS (pay as you go)  HCR 72, 66th R.S. 1979 DID NOT PASS  HR 113, 69th R.S. 1985 DID NOT PASS  HCR 69, 70th R.S. 1987 DID NOT PASS    None in 71st R.S. 1989 -- nor the 6 special sessions  None in 72nd R.S. 1991 -- nor the 3 special sessions  None in 73rd R.S. 1993  None in 75th R.S. 1997    See also: recent article 89.12.002 for pros and cons    Amending the Federal Constitution to Require a Balanced Budget (351.7202 N213A)    Balanced Budget Amendment to the U.S. Constitution: Impact of Texas (Legislative Study Group, Feb. 23, 1995) L1800.9 L523i 95-03',  			keywords = 'defecit spending federal'  		  			, dateVerified = NULL  		  		WHERE entryID = 226
040323  8:54:18  Warning: Checking table:   './members/referenceentries'
040323  8:54:18  Warning: Recovering table: './members/referenceentries'

Thanks,
Daniel

How to repeat:
feature request
[12 Dec 2005 12:38] Valeriy Kravchuk
Thank you for a useful feature request. I agree, that when MySQL server finds incorrect key, it should inform about that. Error log is a good place for such warnings.
[20 Dec 2005 9:54] Sergei Golubchik
Thank you for your bug report. This issue has already been fixed
in the latest released version of that product, which you can download at 
http://www.mysql.com/downloads/

Additional info:

Already implemented in 5.0