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
---
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
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
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
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
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
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
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
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,
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
[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
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]>
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
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
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
15 matches
Mail list logo
