Re: Bizarre InnoDB Error Message ( trx-active_trans == 0, but trx-conc_state != TRX_NOT_STARTED)

2007-01-01 Thread Jason J. W. Williams
Hi Heikki, Yes indeed. We have a uid field that is AUTO INC. Is the error more an issue of the auto inc code in InnoDB not setting its error codes correctly on a rollback than the auto increment code initiating an error? Thank you in advance. Best Regards, Jason On 12/31/06, Heikki Tuuri

Re: Bizarre InnoDB Error Message ( trx-active_trans == 0, but trx-conc_state != TRX_NOT_STARTED)

2006-12-31 Thread Heikki Tuuri
Jason, I am Cc:ing the MySQL General mailing list, so that others who bump into this bug can find this discussion. Jason J. W. Williams wrote: Mr. Tuuri, We have a high degree of UPDATE/INSERT concurrency along with high SELECTs. It causes a deadlock about once every 24 hours. In this case

Bizarre InnoDB Error Message ( trx-active_trans == 0, but trx-conc_state != TRX_NOT_STARTED)

2006-12-28 Thread Jason J. W. Williams
Hello, I noticed the error messages below in my MySQL error log and found them a bit perplexing. Can't find anything on them in the MySQL documentation. If anyone has any clue what they mean it is greatly appreciated. As a sidenote, SHOW INNODB STATUS completes, but only shows through the