lib_mysqludf_xqlFS#15: lib_mysqludf_xql crashes mysqld process on windows after several queries

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!

| Tasklist |

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
Task Type Bug Report
Category
Status Requires testing
Assigned To Arnold Daniels (arnold)
Operating System Windows
Severity High
Priority Normal
Reported Version Development
Due in Version Undecided
Due Date Undecided
Percent Complete 0%
Votes 0
Private No

Details

I'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.
Add comment
Captcha image - if you can't read the image please send an e-mail Please enter the code displayed in the image. The verification is case-insensitive.

Loading...