Hey, I'm having MySQL exhibit some really weird behavior. I am running 3.23.41 on OS X. I'm trying to implement a simple queue using MySQL and PHP. Basically, I have a table with some data and a status field. The status field tells the script the status of the queue entry (queued, paused, executing, etc). So every iteration of the loop in the script, it checks for entries with a queued status, grabs the first one it sees, marks it as executing and processes it. I'm doing some benchmarking, so right now I'm trying to do about 100 entries in 30 seconds.
Anyway, the trouble arrives at random places in the loop. Every time I run the script, MySQL will return an invalid result from a query. It's really strange. Sometimes it'll stop on the third queue entry, next it'll end on the 50th entry. It's a static query, too. There's no dynamic information in it either, the same exact query is being executed successfully in previous iterations. Is there anything I can do or use to see what it's really doing or why it's failing? Are there any bugs for MySQL on OS X that seem to fit this bill? Later, Zack --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
