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 transactio
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
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]>
[EMAIL PROTECTED] wrote:
>Your message cannot be posted because it appears to be either spam or
>simply off topic to our filter. To bypass the filter you must include
>one of the following words in your message:
>
>sql,query
>
>If you just reply to this message, and include the entire text of it
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
Hi,
I've continued trying to solve the problem that I emailed yesterday
regarding AUTO_INCREMENT, and I just seem to be going backwards.
The sample database/software that I sent yesterday had a UNIQUE
constraint and a couple of SELECT statements. I thought that removing
them bizarrely made i
Hi,
I'm having trouble trying to INSERT rows into a table which has an
AUTO_INCREMENT PRIMARY KEY column plus a UNIQUE constraint on two other
columns.
For each INSERT I specify NULL for the AUTO_INCREMENT column to let the
database assign a value automatically, but I frequently get the error
Benjamin Pflugmann wrote:
>>>[...] Which table
>>>type (MyISAM/InnoDB/BDB) do you use? Do you intend to use transactions
>>>or not?
>>>
>>I am using BDB tables, and I am making use of transactions.
>>
>Okay, than that is the reason for the deadlocks and it is to be
>expected, as far as I understa
Benjamin Pflugmann wrote:
>Hi.
>
>Well, a perfect example of misunderstanding due to lack of
>information. I interpreted your former description in a way that your
>applications simply hangs.
>
My apologies for the sparse information in the e-mail to which you
originally replied. It was actuall
ith an empty test database, asked
each client to do 10,000 inserts and finished up with 20,000 rows, so it
looks like they both completed.
I guess that shows it's a DBD::mysql problem, which I did suspect since
the DBD::ADO interface works.
With this, it's probably worth me going b
ese transaction isolation levels supposed to work with BDB tables?
Any help on this, and my previous problems with deadlocking, would be
greatly appreciated.
Steve Hay
-
Before posting, please check:
http://www.mysql.com/manual
when using a Sybase
database instead.
I originally posted my query to the msql-mysql-modules mailing list, but
was told that since DBD::mysql is just a thin layer over the C API I
should post my query here instead. I haven't had a single reply yet!
Does nobody on this list use the Perl A
same deadlock errors as DBD::mysql.)
However, I'm not keen to use the DBD::ADO driver because it doesn't
(currently) support bind parameters, which I'm making much use of.
Also, the same program with only the DBI connect string changed to
access a Sybase database works fi
e:
[19]: fetch() without execute()
[1062]: Duplicate entry '116' for key 1.
There is nothing so fundamentally wrong with the programs that they do
this every time, just once in a while when they're getting hammered hard.
What on earth is going on?
Help!
Steve Hay
---
15 matches
Mail list logo
