MySQL Bugs: #39322: Delete from table not working?

Bug #39322	Delete from table not working?
Submitted:	8 Sep 2008 16:10	Modified:	24 Sep 2008 17:25
Reporter:	newbie Shai	Email Updates:
Status:	Not a Bug	Impact on me:	None
Category:	Connector / NET	Severity:	S2 (Serious)
Version:	5.0.8.1	OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Dear All,
         I have a weird thing happened in my application where I have run a statemement Delete from tblTempReceipt; but later I checked through in my log file there line which have been delete is still exist. If any one can help me I can even post the log files too. I have attached log file I dont how to exactly explain. But based on the number 531 Query is my query where it selects. Then based on it I get 532 Query for update and the I do a delete at 533 Query Delete From tblTempReceipt. So this the delete where it never worked. Cause if it have deleted then why I still my record is avaialable at 545 Query Update tblProduct Set tblProduct.productBooked = tblProduct.productBooked - 1 Where tblProduct.productID=1220 . Actually what is the numbers representing e.g 531,532 etc. Thank you for looking into my problem. So in my case Delete From tblTempReceipt suppose to delete everything rite ?

How to repeat:
Delete from table not working

Hi Newbie.

533 Query Delete From tblTempReceipt should have emptied the tblTempReceipt table but I can not say anything based on log you provided. Please make an effort and attach small, simple and self-contained test case exhibiting this error every time you run it. Also, please do check MySQL server's general query log and see what actually got to server.

Dear Tonci,
           Yes according to the log I feel that it should have emptied my table rite. No the problem this is the first time I seen this weird thing happening in and for rest of the cases it is ok. So I have tried other times it works fine and quite difficult for me to get this test case as this is the first time it occuring like this ? I dont get you what is MySQL server's general query log isnt this the log file which I have attached to where must I get the rest of the log file ? Thanks.

Hi newbie.

We'll do it this way. I'll close the report now and if you ever find a reproducible test case to attach, just attach it and reopen the report (I'll keep monitoring it).

Now for your questions:
  o) what is MySQL server's general query log isn't this the log file which I have attached to where must I get the rest of the log file ?

I think what you attached is output from c/NET in VS, right? MySQL server's general query log is a query log usually placed inside <datadir> in form of <your_server_name>.log. You can get one by putting "log" (without "") in [mysqld] section of my.ini/my.cnf file. You can also start your server with --log option like this: mysqld --standalone --console --log. Output in the log file looks like this:
080905 11:18:34	      3 Connect     root@localhost on 
		      3 Query       SET SQL_AUTO_IS_NULL = 0
		      3 Query       SET AUTOCOMMIT=0
		      3 Query       SET AUTOCOMMIT=1
		      3 Query       SHOW DATABASES
080905 11:18:39	      3 Query       USE information_schema

Also, you might wish to consider looking into MySQL server error file. It's also located (usually) in <datadir> folder and it's named <your_server_name>.err. Output to err file looks like this:
080910 12:26:25  InnoDB: Started; log sequence number 0 625311480
080910 12:26:25 [Note] C:\mysql-5.0.68-pb10-win32\bin\mysqld: ready for connections.
Version: '5.0.68-pb10-log'  socket: ''  port: 5068  MySQL Pushbuild Edition, build 10
080910 18:14:19 [Note] C:\mysql-5.0.68-pb10-win32\bin\mysqld: Normal shutdown

Dear Tonci,
          First of I would like to tell you that the previous file which I attached was infact from the MySQL server's general query log. So I have a similar case happened again and I have attached another log file for your review. Ok to help in discovering the problem first you look at 396 where I do a select and then in 397 I do an update and insert. Then in 402 I do a select to check and according I found one record and I did update in 402 and following that is a another delete statement. So by right after this the table tblTempReceipt is should be empty right ? Then if you see in 420 another update is done due to there is data in tblTempReceipt where in real fact is already deleted ? Can you please check for me? Thanks.

Second case

Attachment: 130908.rtf (application/msword, text), 172.57 KiB.