Mark Matthews wrote:
> Steve Hay wrote:
> | I've tried the same myself on MyISAM tables as well now, and I also
> | found that there is no problem - it only seems to happen using BDB
> tables.
> |
> | However, I need to use BDB tables rather than MyISAM to get transaction
> | support, which is r
Victoria Reznichenko wrote:
>Steve,
>Wednesday, July 10, 2002, 11:12:48 AM, you wrote:
>
>SH> The bug can be reproduced as follows:
>
>SH> Create the following simple database containing just one BDB table:
>
>SH> CREATE DATABASE test;
>
>SH> CREATE TABLE foo (
>SH>id INT NOT NULL
Steve,
Wednesday, July 10, 2002, 11:12:48 AM, you wrote:
SH> Continuing my troubles with AUTO_INCREMENT (which nobody has yet
SH> responded to), I've now ruled the Perl DBI out of the equation and
SH> reproduced the same problem using the "mysql.exe" command-line tool.
SH> Hopefully somebody w
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Steve Hay wrote:
| Thomas Spahni wrote:
|
|> Steve,
|>
|> I tried your example on MyIsam tables; no problems with auto_increment at
|> all, except for a few
|>
|> ERROR 1040: Too many connections
|>
|> when 100 scripts are inserting concurrently at fu
e on MyIsam tables; no problems with auto_increment at
all, except for a few
ERROR 1040: Too many connections
when 100 scripts are inserting concurrently at full speed.
Thomas
>
> >- Original Message -
> >From: "Steve Hay" <[EMAIL PROTECTED]>
> &g
Thomas Spahni wrote:
>Steve,
>
>I tried your example on MyIsam tables; no problems with auto_increment at
>all, except for a few
>
>ERROR 1040: Too many connections
>
>when 100 scripts are inserting concurrently at full speed.
>
>Thomas
>
I've tried the same myself on MyISAM tables as well now, a
it doesn't always fall over after some particular number of
iterations - it falls over at different, apparently random, times each
time I try the test.
- Steve
>- Original Message -
>From: "Steve Hay" <[EMAIL PROTECTED]>
>To: <[EMAIL PROTECTED]>
Can your INT id be overflowing, i.e. reaches the max value for int and
starting at 1 again?
Rich
- Original Message -
From: "Steve Hay" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
> Hi,
&
Hi,
Continuing my troubles with AUTO_INCREMENT (which nobody has yet
responded to), I've now ruled the Perl DBI out of the equation and
reproduced the same problem using the "mysql.exe" command-line tool.
Hopefully somebody will be tempted to help this time now that there is
no Perl involved
handle lastinsert_id parameter ?
*slightly blank look*
P
On Tue, 13 Feb 2001
[EMAIL PROTECTED] wrote:
> From: [EMAIL PROTECTED]
> To: [EMAIL PROTECTED]
> Subject: Caching Bug with AUTO_INCREMENT columns
>
> Description:
> When i use a table with an AUTO_INCREMENT c
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: Caching Bug with AUTO_INCREMENT columns
Description:
When i use a table with an AUTO_INCREMENT column and
insert Data in the Table with a NULL Value for the
AUTO_INCREMENT column, AUTO_INCREMENT sets an new value
11 matches
Mail list logo
