This is the official MySQL UDF Repository bug tracker. Please use it with care.
- Before submitting a new bug report, please make sure the bug is not already reported.
- Include the given error code, trace and any other debugging information supplied.
- Please leave your e-mail address, so we can get back to you if it is unclear how to reproduce the bug.
- This library is maintained by Arnold Daniels. Please contact me if you want to help to solve some issues.
Thank you!
FS#15 - lib_mysqludf_xql crashes mysqld process on windows after several queries
Attached to Project:
lib_mysqludf_xql
Opened by 'mcoarr-mitre' - Friday, 25 September 2009, 17:02 GMT+2
Last edited by Arnold Daniels (arnold) - Monday, 23 November 2009, 22:53 GMT+2
Opened by 'mcoarr-mitre' - Friday, 25 September 2009, 17:02 GMT+2
Last edited by Arnold Daniels (arnold) - Monday, 23 November 2009, 22:53 GMT+2
|
DetailsI'm using the binary build of lib_mysqludf_xql on wiindows and I'm having trouble where it crashes the mysqld daemon.
I've been able to reporduce this with a very simple test case. I run the following query 500 times in two separate windows: select xql_element('my-element', 'my content $i') as value ; Here's the bash script that I use to run this query 500 times (run this from a remote linux box; update db host, db name, username, and password): #!/bin/bash target_host=123.456.789.123 for ((i=0; i < 500; i++)) do echo "before $i" mysql --xml -h $target_host --user=myuser --password=mypassword mydb << EOF select xql_element('my-element', 'my content $i') as value ; EOF echo "after $i" echo "before sleeping" sleep 0.1 echo "after sleeping" done When I'm running this script in two separate windows, it seems to die about 100 iterations in. I've also had mysql die when just running one copy of the script, but that's not as quick to produce (and it's made it through all 500 iterations without any problems a couple times). My real query builds a more complex xml document and it dies much sooner. Matt |
This task depends upon
Comment by
Arnold Daniels (arnold) - Saturday, 26 September 2009, 17:29 GMT+2
Thanks for reporting this bug. Unfortunately I'm unable to test/solve this, because I do not have a Windows environment. More important I don't have the knowledge and skills to debug windows software. So, please provide a patch.
Comment by
Arnold Daniels (arnold) - Monday, 23 November 2009, 22:52 GMT+2
The issue might be solved with v1.0.0. Please try it.