Found a strange problem with a system here I'm wondering if anyone can help with.
Got a v3.23.41 installation (source build) on RedHat 6.2 using BDB tables. A front end program uses this database via the C API. gcc on this system is egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) At one point the front end generates an INSERT query to put a new record into the main table of the database. In another bit of the code it does a check to see if a particular record exists (SELECT query on the primary key followed by a mysql_num_rows on the result) before trying to update the record. Now this program has been running fine for a good while, but yesterday in the space of five minutes I got 6 warnings from my front end program that the users were trying to update records that didn't exist. When I did some digging, it looks like the records were/should-have-been present. So I've got two possibilities: 1. The initial insert for the six records didn't work. I'm not sure about this, since there were other record inserts being done around the same time frame that did work. 2. For some reason, either my SELECT decided to return no results, or mysql_num_rows decided to return zero. I'm going to put in some error trapping on the insert now, so if it does fail at least I get an error message. I'm a bit loathe to do this since the system has been so stable, (100K's of transactions at these are the first failures, so replicating the problem is near enough impossible). Plan B is to replace the r41 install with a local build of r49a(/r50?) in case it's a know problem now solved. Any ideas oh great MySQL gurus? Regards Bob Cross. * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * This message is confidential. It may also be privileged or protected by other legal rules. It is not an offer or acceptance of an offer, nor shall it form any part of a legally binding contract. If you have received this communication in error, please let us know by reply then destroy it. You should not use, print, copy the message or disclose its contents to anyone. E-mail is subject to possible data corruption, is not secure, and its content does not necessarily represent the opinion of this Company. No representation or warranty is made as to the accuracy or completeness of the information and no liability is accepted for any loss arising from its use. This e-mail and any attachments are not guaranteed to be free from so-called computer viruses. You should check for viruses before down-loading it to your computer equipment. This Company has no control over other websites to which there may be hypertext links and no liability is accepted in relation to those sites. This Company randomly monitors its e-mail system (including incoming e-mails) for operational purposes. Scottish & Newcastle plc Registered in Scotland, Registered Number 16288 Registered Office: 33, Ellersly Road, Edinburgh, EH12 6HX * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * --------------------------------------------------------------------- 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