Zack, Saturday, March 30, 2002, 10:52:40 PM, you wrote:
That appears to be a PHP script problem, not MySQL one. But first try to upgrade MySQL to 3.23.49a and see how the behavior changes. ZA> Hey, I'm having MySQL exhibit some really weird behavior. I am running ZA> 3.23.41 on OS X. I'm trying to implement a simple queue using MySQL and PHP. ZA> Basically, I have a table with some data and a status field. The status ZA> field tells the script the status of the queue entry (queued, paused, ZA> executing, etc). So every iteration of the loop in the script, it checks for ZA> entries with a queued status, grabs the first one it sees, marks it as ZA> executing and processes it. I'm doing some benchmarking, so right now I'm ZA> trying to do about 100 entries in 30 seconds. ZA> Anyway, the trouble arrives at random places in the loop. Every time I run ZA> the script, MySQL will return an invalid result from a query. It's really ZA> strange. Sometimes it'll stop on the third queue entry, next it'll end on ZA> the 50th entry. It's a static query, too. There's no dynamic information in ZA> it either, the same exact query is being executed successfully in previous ZA> iterations. Is there anything I can do or use to see what it's really ZA> doing or why it's failing? Are there any bugs for MySQL on OS X that seem to ZA> fit this bill? ZA> Later, ZA> Zack -- For technical support contracts, goto https://order.mysql.com/ This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net <___/ www.mysql.com --------------------------------------------------------------------- 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
