| Bug #27099 | system_mysql fail in pushbuild windows | ||
|---|---|---|---|
| Submitted: | 13 Mar 2007 18:13 | Modified: | 30 Oct 2007 0:22 |
| Reporter: | Mads Martin Joergensen | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server | Severity: | S3 (Non-critical) |
| Version: | 5.1 | OS: | Windows |
| Assigned to: | Georgi Kodinov | CPU Architecture: | Any |
[14 Mar 2007 14:21]
Magnus Blåudd
Seems like this occurs when mysqld decides to write a query to the slow log. It will open it for writing and set the "crashed" flag in the metafile. The crashed flag will not be reset, either because log is never closed or because use_count is not incremented when ha_tina is used from log handler. The writing to and from metafile seems to work fine.
[14 Mar 2007 17:14]
Brian Aker
Ping Antony about his related patch, it may (though may not) effect this.
[15 Oct 2007 16:56]
Bugs System
A patch for this bug has been committed. After review, it may be pushed to the relevant source trees for release in the next version. You can access the patch from: http://lists.mysql.com/commits/35584 ChangeSet@1.2584, 2007-10-15 19:56:24+03:00, gkodinov@magare.gmz +2 -0 Bug #27099: system_mysql fail in pushbuild windows On Windows the debug log was doing freopen () instead of fflush() and that was slowing the logging down that much that some tests timed out. Fixed by replacing the freopen() with an syncing-to-disk flag to fopen() and fflush(). Also increased the timeout of the tests running with --debug on windows : seems to slow down as much as valgrind on linux.
[16 Oct 2007 16:37]
Reggie Burnett
It seems that this bug report is essentially not repeatable now, however the attached patch is a change that needs to happen and is somewhat related to this bug.
[29 Oct 2007 8:46]
Bugs System
Pushed into 5.1.23-beta
[29 Oct 2007 8:50]
Bugs System
Pushed into 6.0.4-alpha
[30 Oct 2007 0:22]
Paul DuBois
Noted in 5.1.23, 6.0.4 changelogs. On WIndows, writes to the debug log were using freopen() instead of fflush(), resulting in slower performance.
Description: *** r/system_mysql_db.result Sun Mar 11 22:51:31 2007 --- r/system_mysql_db.reject Sun Mar 11 23:29:06 2007 *************** *** 251,255 **** --- 251,257 ---- `server_id` int(11) DEFAULT NULL, `sql_text` mediumtext NOT NULL ) ENGINE=CSV DEFAULT CHARSET=utf8 COMMENT='Slow log' + Warnings: + Error 1194 Table 'slow_log' is marked as crashed and should be repaired show tables; Tables_in_test ------------------------------------------------------- How to repeat: Pushbuild 5.1 tree Suggested fix: Let allmighty windows test solver Magnus have a look at it, and it will be fixed as was it magic. As usual :)