ot backup tool for InnoDB which also backs up MyISAM
tables
http://www.innodb.com/order.php
Order MySQL technical support from https://order.mysql.com/
- Original Message -
From: ""Mr. Gabriele Somthing"" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.myodbc
Sent: Tu
I believe I have read or skimmed all of the posts to this group with
"Lock", "wait" and "timeout" in their body over the past year (172) with
no answers in sight (if I missed a post, please let me know).
I am unable to figure out what is causing this problem that is 100%
reproducible on a 4.0.2
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300:
> Roman,
>
> looks like your application fails to commit this transaction:
>
> "
> 030604 13:52:21 INNODB MONITOR OUTPUT
> ...
> LIST OF TRANSACTIONS FOR EACH SESSION:
> ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251
> 10 lock struct(
# [EMAIL PROTECTED] / 2003-06-04 17:11:19 +0300:
> Roman,
>
> looks like your application fails to commit this transaction:
>
> "
> 030604 13:52:21 INNODB MONITOR OUTPUT
> ...
> LIST OF TRANSACTIONS FOR EACH SESSION:
> ---TRANSACTION 0 407759, ACTIVE 2090 sec, OS thread id 10251
> 10 lock struct(
t; <[EMAIL PROTECTED]>
To: "Heikki Tuuri" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Wednesday, June 04, 2003 3:44 PM
Subject: Re: debuggine 1205 / LOCK wait timeout exceeded errors
> # [EMAIL PROTECTED] / 2003-06-03 22:59:47 +0300:
> > you can use SHOW
# [EMAIL PROTECTED] / 2003-06-03 22:59:47 +0300:
> you can use SHOW INNODB STATUS to look what active transactions you have and
> how many lock structs they have.
>
> Also innodb_lock_monitor helps.
Hi Heikki,
thanks for the reply. I have dropped the database, recreated it,
stopped t
support from https://order.mysql.com/
- Original Message -
From: "Roman Neuhauser" <[EMAIL PROTECTED]>
Newsgroups: mailing.database.mysql
Sent: Tuesday, June 03, 2003 7:51 PM
Subject: debuggine 1205 / LOCK wait timeout exceeded errors
> Hi there,
>
> I have a
Hi there,
I have a problem with LOCKs. I use InnoDB tables and transactions.
[EMAIL PROTECTED] ~ 1001:0 > /usr/local/libexec/mysqld --version
/usr/local/libexec/mysqld Ver 4.0.13 for portbld-freebsd4.8 on i386
[EMAIL PROTECTED] ~ 1002:0 > uname -sr
FreeBSD 4.8-RC
[EMAIL PROTECTED] ~ 1003:0 > htt
