Bug #45118 mysqld.exe crashed in debug mode on Windows in dbug.c
| Submitted: | 27 May 2009 8:36 | Modified: | 20 Dec 2009 0:46 |
|---|---|---|---|
| Reporter: | Horst Hunger | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL Server: Windows | Severity: | S2 (Serious) |
| Version: | 5.1,azalea (5.4) | OS: | Windows (64-bit) |
| Assigned to: | Alexander Nozdrin | CPU Architecture: | Any |
[27 May 2009 17:08]
MySQL Verification Team
Thank you for the bug report. Verified as described:
c:\build\mysql-azalea\mysql-test>perl mysql-test-run.pl --suite=parts --force partition_alter3_myisam
Found handle.exe version 3.42
Logging: mysql-test-run.pl --suite=parts --force partition_alter3_myisam
090527 14:00:15 [Warning] Forcing shutdown of 1 plugins
MySQL Version 5.4.4
Checking supported features...
- skipping ndbcluster, mysqld not compiled with ndbcluster
- SSL connections supported
- binaries are debug compiled
Collecting tests...
vardir: c:/build/mysql-azalea/mysql-test/var
Removing old var directory...
Creating var directory 'c:/build/mysql-azalea/mysql-test/var'...
Installing system database...
Using server port 50798
==============================================================================
TEST RESULT TIME (ms)
------------------------------------------------------------
worker[1] Using MTR_BUILD_THREAD 300, with reserved ports 13000..13009
Failed to open shutdown_event 'safe_process[3528]', error: 2
Couldn't open the winpid: 3528 for pid: 3528, try one more time
Failed to open shutdown_event 'safe_process[3528]', error: 2
Couldn't open the winpid: 3528 for pid: 3528, continue and see what happens...
Could not open event or process 360, error: 87
Couldn't open the winpid: 360 for pid: 360, try one more time
Could not open event or process 360, error: 87
Couldn't open the winpid: 360 for pid: 360, continue and see what happens...
parts.partition_alter3_myisam [ fail ]
Test ended at 2009-05-27 14:02:26
CURRENT_TEST: parts.partition_alter3_myisam
mysqltest: In included file ".\suite\parts\inc\partition_check_drop.inc": At line 35: query 'SET @aux = load_file('$ls_file')' failed: 2013: Lost connection to MySQL server dur
ing query
The result from queries just before the failure was:
< snip >
# 1.2.6 Remove partitioning
ALTER TABLE t1 REMOVE PARTITIONING;
SHOW CREATE TABLE t1;
Table Create Table
t1 CREATE TABLE `t1` (
`f_date` date DEFAULT NULL,
`f_varchar` varchar(30) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1
t1.MYD
t1.MYI
t1.frm
EXPLAIN PARTITIONS SELECT COUNT(*) FROM t1 WHERE f_date = '1000-02-10';
id select_type table partitions type possible_keys key key_len ref rows Extra
1 SIMPLE t1 NULL ALL NULL NULL NULL NULL 20 Using where
# check read single success: 1
# check read all success: 1
# check read row by row success: 1
# 1.2.7 Remove partitioning from not partitioned table --> ????
ALTER TABLE t1 REMOVE PARTITIONING;
DROP TABLE t1;
More results from queries before failure can be found in c:\build\mysql-azalea\mysql-test\var\log\partition_alter3_myisam.log
Server [mysqld.1 - pid: 360, winpid: 360, exit: 1280] failed during test run
- saving 'c:/build/mysql-azalea/mysql-test/var/log/parts.partition_alter3_myisam/' to 'c:/build/mysql-azalea/mysql-test/var/log/parts.partition_alter3_myisam/'
- found 'mysqld.dmp' (0/5)
Trying 'cdb' to get a backtrace
<cuT>
[26 Aug 2009 15:05]
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/81620 3082 Alexander Nozdrin 2009-08-26 A patch for Bug#45118 (mysqld.exe crashed in debug mode on Windows in dbug.c) -- part 2: a patch for the DBUG subsystem to detect misuse of DBUG_ENTER / DBUG_RETURN macros. 5.1 version.
[26 Aug 2009 17:26]
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/81635 2800 Alexander Nozdrin 2009-08-26 A patch for Bug#45118 (mysqld.exe crashed in debug mode on Windows in dbug.c) -- part 3: mysql-next specific fix.
[28 Aug 2009 9:53]
Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090828095047-jbux7pie1yjnwpce) (version source revid:alik@sun.com-20090826172543-mvrsx03j9r5v8fw0) (merge vers: 5.4.4-alpha) (pib:11)
[29 Aug 2009 23:24]
Paul DuBois
Noted in 5.4.4 changelog. Debug builds of the server on Windows crashed in debugging code.
[10 Sep 2009 7:41]
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/82887 3111 Alexander Nozdrin 2009-09-10 A patch for Bug#45118 (mysqld.exe crashed in debug mode on Windows in dbug.c) -- part 2: a patch for the DBUG subsystem to detect misuse of DBUG_ENTER / DBUG_RETURN macros. 5.1 version.
[10 Sep 2009 8:24]
Alexander Nozdrin
Queued into mysql-5.1-bugteam, mysql-pe. No changelog entry is needed for this push.
[14 Sep 2009 16:04]
Bugs System
Pushed into 5.4.4-alpha (revid:alik@sun.com-20090914155317-m1g9wodmndzdj4l1) (version source revid:alik@sun.com-20090914155317-m1g9wodmndzdj4l1) (merge vers: 5.4.4-alpha) (pib:11)
[6 Oct 2009 9:00]
Bugs System
Pushed into 5.1.40 (revid:joro@sun.com-20091006073316-lea2cpijh9r6on7c) (version source revid:ingo.struewing@sun.com-20090916070128-6053el2ucp5z7pyn) (merge vers: 5.1.39) (pib:11)
[7 Oct 2009 18:40]
Paul DuBois
The 5.4 fix has been pushed to 5.4.3.
[18 Dec 2009 10:38]
Bugs System
Pushed into 5.1.41-ndb-7.1.0 (revid:jonas@mysql.com-20091218102229-64tk47xonu3dv6r6) (version source revid:jonas@mysql.com-20091218095730-26gwjidfsdw45dto) (merge vers: 5.1.41-ndb-7.1.0) (pib:15)
[18 Dec 2009 10:53]
Bugs System
Pushed into 5.1.41-ndb-6.2.19 (revid:jonas@mysql.com-20091218100224-vtzr0fahhsuhjsmt) (version source revid:jonas@mysql.com-20091217101452-qwzyaig50w74xmye) (merge vers: 5.1.41-ndb-6.2.19) (pib:15)
[18 Dec 2009 11:08]
Bugs System
Pushed into 5.1.41-ndb-6.3.31 (revid:jonas@mysql.com-20091218100616-75d9tek96o6ob6k0) (version source revid:jonas@mysql.com-20091217154335-290no45qdins5bwo) (merge vers: 5.1.41-ndb-6.3.31) (pib:15)
[18 Dec 2009 11:22]
Bugs System
Pushed into 5.1.41-ndb-7.0.11 (revid:jonas@mysql.com-20091218101303-ga32mrnr15jsa606) (version source revid:jonas@mysql.com-20091218064304-ezreonykd9f4kelk) (merge vers: 5.1.41-ndb-7.0.11) (pib:15)
Portions of this website are copyright © 2001, 2002 The PHP Group
Page generated in 0.078 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.
Description: mysqld.exe crashed in debug mode on Windows. VC shows the following: Position of crash: dbug.c, line 1762, see cs->framep Autos (variables): - cs 0x02c65020 {process=0x00af2cc8 "E:/bzr/mysql-azalea/sql/debug/mysqld.exe" func=0x013d06a4 "Item_func_set_user_var::check" file=0x013d0694 ".\item_func.cc" ...} _db_code_state_ * + process 0x00af2cc8 "E:/bzr/mysql-azalea/sql/debug/mysqld.exe" const char * + func 0x013d06a4 "Item_func_set_user_var::check" const char * + file 0x013d0694 ".\item_func.cc" const char * - framep 0x000bf6e8 {func=??? file=??? level=??? ...} _db_stack_frame_ * func CXX0030: Error: expression cannot be evaluated file CXX0030: Error: expression cannot be evaluated level CXX0030: Error: expression cannot be evaluated prev CXX0030: Error: expression cannot be evaluated + stack 0x01756730 init_settings {flags=4096 maxdepth=0 delay=0 ...} settings * + jmpfunc 0x00000000 <Bad Ptr> const char * + jmpfile 0x00000000 <Bad Ptr> const char * lineno 0 int level 6 unsigned int jmplevel 0 int u_line 63 unsigned int locked 0 int + u_keyword 0x0161344c "my" const char * - cs->framep 0x000bf6e8 {func=??? file=??? level=??? ...} _db_stack_frame_ * func CXX0030: Error: expression cannot be evaluated file CXX0030: Error: expression cannot be evaluated level CXX0030: Error: expression cannot be evaluated prev CXX0030: Error: expression cannot be evaluated Callstack: mysqld.exe!DoTrace(_db_code_state_ * cs=0x02c65020) Line 1762 + 0xf bytes C mysqld.exe!_db_return_(unsigned int _line_=4303, _db_stack_frame_ * _stack_frame_=0x039fdf08) Line 1253 + 0x9 bytes C mysqld.exe!Item_func_set_user_var::check(bool use_result_field=false) Line 4303 + 0xe bytes C++ mysqld.exe!set_var_user::check(THD * thd=0x03a13878) Line 4170 + 0x36 bytes C++ mysqld.exe!sql_set_variables(THD * thd=0x03a13878, List<set_var_base> * var_list=0x03a14e3c) Line 4009 + 0x13 bytes C++ mysqld.exe!mysql_execute_command(THD * thd=0x03a13878) Line 3558 + 0x10 bytes C++ mysqld.exe!mysql_parse(THD * thd=0x03a13878, const char * inBuf=0x02ca9448, unsigned int length=82, const char * * found_semicolon=0x039ff9b0) Line 5979 + 0x9 bytes C++ mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x03a13878, char * packet=0x02cc16f1, unsigned int packet_length=82) Line 1064 + 0x1e bytes C++ mysqld.exe!do_command(THD * thd=0x03a13878) Line 746 + 0x1b bytes C++ mysqld.exe!handle_one_connection(void * arg=0x03a13878) Line 1146 + 0x9 bytes C++ mysqld.exe!pthread_start(void * p=0x02c2f7c8) Line 61 + 0x9 bytes C mysqld.exe!_callthreadstartex() Line 348 + 0xf bytes C mysqld.exe!_threadstartex(void * ptd=0x03a15478) Line 331 C How to repeat: Create a debug version of mysqld and execute on Windows (server 2003? 64 bit) in "mysql-azalea". Use the following settings/commands: win\configure WITH_INNOBASE_STORAGE_ENGINE WITH_PARTITION_STORAGE_ENGINE WITH_ARCHIVE_STORAGE_ENGINE WITH_FEDERATED_STORAGE_ENGINE WITH_EXAMPLE_STORAGE_ENGINE DISABLE_GRANT_OPTIONS; win\build-vs9.bat; devenv mysql.sln /build debug; Start the test: perl mysql-test-run.pl --suite=parts --force partition_alter3_myisam