Bug #10619 | GROUP_CONCAT() crashes mysqld | ||
---|---|---|---|
Submitted: | 13 May 2005 11:18 | Modified: | 2 Jun 2005 19:17 |
Reporter: | Torsten Kasch | Email Updates: | |
Status: | Can't repeat | Impact on me: | |
Category: | MySQL Server: Optimizer | Severity: | S1 (Critical) |
Version: | 4.1.11/4.1.12 | OS: | Solaris (Solaris 9 (SPARC)/Windows) |
Assigned to: | Igor Babaev | CPU Architecture: | Any |
[13 May 2005 11:18]
Torsten Kasch
[13 May 2005 11:33]
Hartmut Holzgraefe
Doesn't crash 4.1.11 on Linux/x86
[13 May 2005 11:52]
MySQL Verification Team
The Linux BK source not crashes but the Windows server 4.1.11 I got a crash will test Windows server latest BK.
[13 May 2005 13:24]
MySQL Verification Team
Testing a Windows server 4.1.12 (BK source) I noticed that only the optimized server crashes, the debug server not crashed. Below a call stack from optimized server: > mysqld-nt.exe!Field_enum::val_int() + 0x13 C++ mysqld-nt.exe!Field_enum::cmp() + 0x15 C++ mysqld-nt.exe!group_concat_key_cmp_with_distinct() + 0x52 C++ mysqld-nt.exe!_tree_insert() + 0x42 C mysqld-nt.exe!Item_func_group_concat::add() + 0xb3 C++ mysqld-nt.exe!JOIN::make_sum_func_list() + 0x478 C++ mysqld-nt.exe!safe_index_read() + 0xbe5 C++ mysqld-nt.exe!create_myisam_from_heap() + 0x719 C++ mysqld-nt.exe!create_myisam_from_heap() + 0x466 C++ mysqld-nt.exe!JOIN::exec() + 0xe18 C++ mysqld-nt.exe!mysql_select() + 0x205 C++ mysqld-nt.exe!handle_select() + 0x81 C++ mysqld-nt.exe!mysql_execute_command() + 0x42a C++ mysqld-nt.exe!mysql_parse() + 0xe6 C++ mysqld-nt.exe!dispatch_command() + 0x46d C++ mysqld-nt.exe!do_command() + 0xa7 C++ mysqld-nt.exe!_handle_one_connection() + 0x1ed C++ mysqld-nt.exe!_pthread_create() + 0xcb C mysqld-nt.exe!__beginthread() + 0xce ntdll.dll!7c9106eb() kernel32.dll!7c80b50b() ntdll.dll!7c9106eb() kernel32.dll!7c8399f3()
[2 Jun 2005 19:01]
Igor Babaev
I failed to repeat the problem with mysqld-nt from 4.1.12a release.
[2 Jun 2005 19:17]
MySQL Verification Team
Yes I can confirm that a server built from today source not crashes any more: mysql> # mysql> # The following Query crashes mysqld: mysql> # mysql> SELECT GROUP_CONCAT(DISTINCT sts.workgroup_id SEPARATOR ',') -> FROM sts, clone -> WHERE sts.uid = 2; +-------------------------------------------------------+ | GROUP_CONCAT(DISTINCT sts.workgroup_id SEPARATOR ',') | +-------------------------------------------------------+ | KO,KO | +-------------------------------------------------------+ 1 row in set (0.00 sec) mysql> select version(); +-----------+ | version() | +-----------+ | 4.1.13-nt | +-----------+ 1 row in set (0.00 sec) mysql>