| Bug #41409 | REPLACE and EXTRACTVALUE crashes mysql | ||
|---|---|---|---|
| Submitted: | 11 Dec 2008 17:45 | Modified: | 15 Oct 2010 5:32 |
| Reporter: | Harald Groven | Email Updates: | |
| Status: | Duplicate | Impact on me: | |
| Category: | MySQL Server: XML functions | Severity: | S2 (Serious) |
| Version: | 5.1.29, 5.1.30, 6.0.8 | OS: | Linux (Windows) |
| Assigned to: | Assigned Account | CPU Architecture: | Any |
| Tags: | xpath replace 2013 | ||
[11 Dec 2008 19:00]
MySQL Verification Team
Thank you for the bug report. I couldn't repeat with latest source server and then tested with 5.1.29 on Windows without crash. Are you sure you've got a server crash? or just a client timeout connection?. Thanks in advance.
[11 Dec 2008 21:12]
Harald Groven
I repated the same queries on a different OS (Mac OS10.4 PPC) on Mysql 5.1.29 and got the same error messages as I got on 5.1.29 on OpenSuse Linux
[12 Dec 2008 4:51]
Valeriy Kravchuk
I've got a crash with 6.0.8. Stack trace is:
mysqld.exe!Item_func_replace::val_str(String * str=0x0a20e9c0) Line 1049 + 0x4 bytes C++
mysqld.exe!Item::send(Protocol * protocol=0x039dfbd8, String * buffer=0x0a20e9c0) Line 5424 + 0xc bytes C++
mysqld.exe!Protocol::send_result_set_row(List<Item> * row_items=0x039e0d20) Line 745 + 0xb bytes C++
mysqld.exe!select_send::send_data(List<Item> & items={...}) Line 1636 + 0xc bytes C++
mysqld.exe!JOIN::exec() Line 2307 + 0x42 bytes C++
mysqld.exe!mysql_select(THD * ... st_select_lex * select_lex=0x039e0c88) Line 3021 C++
mysqld.exe!handle_select(THD * thd=0x039df8b8, LEX * lex=0x039e0988, select_result * result=0x0645fe88, unsigned long setup_tables_done_option=0) Line 301 + 0x79 bytes C++
mysqld.exe!execute_sqlcom_select(THD * thd=0x00000000, TABLE_LIST * all_tables=0x00000000) Line 4646 + 0xa bytes C++
mysqld.exe!mysql_execute_command(THD * thd=0x039df8b8) Line 2066 + 0xc bytes C++
mysqld.exe!mysql_parse(THD * thd=0x039df8b8, const char * inBuf=0x0645f720, unsigned int length=91, const char * * found_semicolon=0x0a20f9b8) Line 5634 + 0x6 bytes C++
mysqld.exe!dispatch_command(enum_server_command command=COM_QUERY, THD * thd=0x039df8b8, char * packet=0x064576f1, unsigned int packet_length=91) Line 1011 C++
mysqld.exe!do_command(THD * thd=0x00000003) Line 689 + 0xf bytes C++
mysqld.exe!handle_one_connection(void * arg=0x039df8b8) Line 1156 + 0xa bytes C++
mysqld.exe!pthread_start(void * param=0x039e19b0) Line 86 + 0x3 bytes C
> mysqld.exe!_threadstart(void * ptd=0x019ea1d8) Line 196 + 0x6 bytes C
[12 Dec 2008 5:00]
Valeriy Kravchuk
5.1.30 on Windows also crashes for me.
[18 Dec 2008 12:14]
Valeriy Kravchuk
This bug is not repeatable any more on current 5.1 and 6.0 from bzr. But I'd prefer to have a test case based on this bug to be included into our regression tests suite.
[6 Oct 2010 19:25]
MySQL Verification Team
see bug #57257 for a current testcase.
Description: Some XPATHs in EXTRACTVALUE nested in REPLACE seems to crash mysql5.1 with error code 2006. This only occurs when the replace from string is more than 1 character. How to repeat: SELECT REPLACE(EXTRACTVALUE('http://www.mysql.com';, '/program/webLink/href'), 'http://','';) ; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 5 Current database: *** NONE *** ERROR 2013 (HY000): Lost connection to MySQL server during query mysql> SELECT REPLACE(EXTRACTVALUE('http://www.mysql.com';, '/program/webLink/href'), 'h','') ; ERROR 2006 (HY000): MySQL server has gone away No connection. Trying to reconnect... Connection id: 1 Current database: *** NONE *** +--------------------------------------------------------------------------------+ | REPLACE(EXTRACTVALUE('http://www.mysql.com';, '/program/webLink/href'), 'h','') | +--------------------------------------------------------------------------------+ | | +--------------------------------------------------------------------------------+ 1 row in set (0.00 sec) mysql> SELECT REPLACE(EXTRACTVALUE('http://www.mysql.com';, '/hurra'), 'http','') ; ERROR 2013 (HY000): Lost connection to MySQL server during query mysql>