Alex,
a possible temporary workaround you can try: use
LOCK TABLES intraday_PAR WRITE;
in your deleting transaction. It will lock updaters out
of your table while the delete batch is running.
There probably is a bug in hangdling of concurrent deletes
and updates in Innobase. I will try to repe
>Bonjour,
>
> I have a table created with :
>
>CREATE TABLE intraday_PAR (
> symbole char(20) NOT NULL default '',
> date datetime NOT NULL default '-00-00 00:00:00',
Don't use reserved words for column names.
> first double(17,5) NOT NULL default '0.0',
> high double(
Sent: Tuesday, April 03, 2001 6:49 PM
Subject: Mysqld crashes with my DELETE query.
> Bonjour,
>
> I have re-run my query without the other program trying to UPDATE
> the table :
>
> mysql> delete from intraday_PAR where date<'2001-04-03 00:00:00';
> Qu
Bonjour,
I have re-run my query without the other program trying to UPDATE
the table :
mysql> delete from intraday_PAR where date<'2001-04-03 00:00:00';
Query OK, 364842 rows affected (32.95 sec)
It works.
Why did both threads lock each other.
There is one doing a lot of UPDATE
Bonjour,
I may have copy all the lines from "mysqladmin process-list".
While I'm doing my "DELETE FROM", another program is doing UPDATE on
the query, but this should not be a problem.
[12:32pm]# mysqladmin proc
+++---+---+-+--+--+-
Bonjour,
I have a table created with :
CREATE TABLE intraday_PAR (
symbole char(20) NOT NULL default '',
date datetime NOT NULL default '-00-00 00:00:00',
first double(17,5) NOT NULL default '0.0',
high double(17,5) NOT NULL default '0.0',
low double(17,5) NOT NULL defaul