On 9/2/2011 6:15 AM, Jochem van Dieten wrote:
On Wed, Aug 31, 2011 at 4:10 AM, Peter Brawley wrote:
While a transaction in one thread tries to update a non-existent InnoDB row
with a given key value, an attempt to insert that value in another thread is
locked out. Does anyone know where this beh
On 9/1/2011 9:06 AM, Jerry Schwartz wrote:
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a
On Wed, Aug 31, 2011 at 4:10 AM, Peter Brawley wrote:
> While a transaction in one thread tries to update a non-existent InnoDB row
> with a given key value, an attempt to insert that value in another thread is
> locked out. Does anyone know where this behaviour is documented?
In the manual it is
>> The ability to lock non-existent records is critical.
>
>I concur, although this is just a transaction consisting of 1 statement :).
>--
[JS] As the Three Musketeers used to say, "One for all and all for one!"
Peter, I couldn't even //understand// that paragraph about key gaps. The
document wr
On 9/1/2011 9:46 AM, Rik Wasmus wrote:
-Original Message-
From: Peter Brawley [mailto:peter.braw...@earthlink.net]
Sent: Wednesday, August 31, 2011 10:40 AM
To: r...@grib.nl; mysql@lists.mysql.com
Subject: Re: locked non-existent row
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a
> >-Original Message-
> >From: Peter Brawley [mailto:peter.braw...@earthlink.net]
> >Sent: Wednesday, August 31, 2011 10:40 AM
> >To: r...@grib.nl; mysql@lists.mysql.com
> >Subject: Re: locked non-existent row
> >
> >On 8/31/2011 4:50 AM, Rik Wasm
>-Original Message-
>From: Peter Brawley [mailto:peter.braw...@earthlink.net]
>Sent: Wednesday, August 31, 2011 10:40 AM
>To: r...@grib.nl; mysql@lists.mysql.com
>Subject: Re: locked non-existent row
>
>On 8/31/2011 4:50 AM, Rik Wasmus wrote:
>>> While a tran
On Wednesday 31 August 2011 16:39:52 Peter Brawley wrote:
> >> While a transaction in one thread tries to update a non-existent InnoDB
> >> row with a given key value, an attempt to insert that value in another
> >> thread is locked out. Does anyone know where this behaviour is
> >> documented?
> >
On 8/31/2011 4:50 AM, Rik Wasmus wrote:
While a transaction in one thread tries to update a non-existent InnoDB
row with a given key value, an attempt to insert that value in another
thread is locked out. Does anyone know where this behaviour is documented?
-- connection 1
drop table if exists t
> While a transaction in one thread tries to update a non-existent InnoDB
> row with a given key value, an attempt to insert that value in another
> thread is locked out. Does anyone know where this behaviour is documented?
>
> -- connection 1
> drop table if exists t;
> create table t( lockid cha
10 matches
Mail list logo
