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 (
SHid 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 transaction
| support, which
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 in the
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]
Sent: Wednesday, July 10, 2002 4:12 AM
Subject: Bug with AUTO_INCREMENT
Hi
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, and I also
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
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
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 actually my
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 understand (as writers
-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 API?
Please help if you can.
Thanks,
Steve Hay
---
Version info:
OS: Windows NT4, SP6
be
greatly appreciated.
Steve Hay
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe
problem, which I did suspect since
the DBD::ADO interface works.
With this, it's probably worth me going back to the mysql-mysql-modules
list.
Thanks!
Steve Hay
-
Before posting, please check:
http://www.mysql.com/manual.php
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 fine with the main Sybase DBD driver
(DBD::ASAny) and with DBD::ADO and DBD::ODBC.
Any help would be greatly appreciated.
Steve Hay
---
Version info:
OS
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
-
Before posting, please check:
http://www.mysql.com/manual.php
15 matches
Mail list logo