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
On Wed, 10 Jul 2002, Steve Hay wrote:
> Richard Fox wrote:
>
> >Can your INT id be overflowing, i.e. reaches the max value for int and
> >starting at 1 again?
> >Rich
> >
> I don't think it is because (a) the last value that was successfully
> INSERT'ed - usually around 40,000-odd - is well sho
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
Richard Fox wrote:
>Can your INT id be overflowing, i.e. reaches the max value for int and
>starting at 1 again?
>Rich
>
I don't think it is because (a) the last value that was successfully
INSERT'ed - usually around 40,000-odd - is well short of the maximum
INT, and (b) it doesn't always fall
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,
>
> Continuing my troubles wi
