(Asking again)
After running in production for about seven weeks, our dumps on one of
our BDB tables performed with 'mysqldump --opt' began failing with the
message: 'mysqldump: Error 1030: Got error 12 from table handler when
dumping table `reference` at row: 255233'. The table has about
After running in production for about seven weeks, our dumps on one of
our BDB tables performed with mysqldump began failing with the message:
'mysqldump: Error 1030: Got error 12 from table handler when dumping
table `reference` at row: 255233'.
Reviewing the error log and the MySQL doc, I
Hi,
I've got a problem:
I'm using Berkeley DB tables in my database, but mysql fails to restart
after dropping such database. Mysql claims that it can't restore some of
database tables on start and fails to do it, because tables' files do not
physically exists after database dropping...
I can
Hi, does anyone have any experience using db_stat to get statistics on BDB
tables in MySQL. How did you go about this please? Thanks.
Geetika
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual
Hi,
In addition to the deadlock problems that I'm having, as described in
previous e-mails (still not solved...), it appears that the
transaction_isolation level setting is not being honoured, at least when
using BDB tables. (I'm running mysql-max-nt 3.23.49a on Windows NT4 SP6
On Mon, Apr 29, 2002 at 12:52:23PM +0100, Steve Hay wrote:
Hi,
In addition to the deadlock problems that I'm having, as described
in previous e-mails (still not solved...), it appears that the
transaction_isolation level setting is not being honoured, at least
when using BDB tables
Hi,
I'm trying to run two separate programs which connect to a single MySQL
database and attempt to perform transactions on its BDB tables. I'm
running MySQL 3.23.49a Max on Windows (NT4). The two programs in
question are both Windows Services written in Perl (5.6.1), and they
are using
Hi,
With all the recent talk about replication, just wondering if there are
any others out there who have experience replicating BDB tables?
My experience so far has been that the slave instance of MySQL has been
crashing once in a while, when applying perfectly legitimate
On Fri, Jan 25, 2002 at 04:15:18PM +0800, Geoffrey Soh wrote:
Hi,
My experience so far has been that the slave instance of MySQL
has been crashing once in a while, when applying perfectly
legitimate DELETE queries on the replicated BDB tables.
That's a bad sign.
MySQL
Kalok,
Thursday, January 24, 2002, 6:51:26 PM, you wrote:
KL I'm having the same need.
KL It looks like the following is intended for MyISAM tables only:
KL http://www.mysql.com/doc/U/s/Using_mysqlcheck.html
KL Has anyone else had any other luck ?
Sometimes mysqlcheck works for BDB tables
Hi!
CHECK TABLE does not do anything on BDB tables.
On InnoDB and MyISAM tables CHECK TABLE tries to verify the physical
consistency of the table and its indexes.
The way to repair InnoDB or BDB tables is to dump, drop, and reimport them.
Best regards,
Heikki Tuuri
Innobase Oy
---
Order
Hi,
Just wondering if anyone has received the following error code before on a
BDB table :
ERROR 1030: Got error -30991 from table handler
I have a BDB table consisting of 4 varchar and 2 unsigned bigint columns
with about 30K+ rows. This table is replicated to a slave. Both
I am trying mysql-max 4 with BDB table types and
transaction-isolation-level=READ-COMMITTED.
When I do an update/delete in one session the table row is locked until
rollback or commit for all other sessions. Should this be the case, and if
not how do I get round this?
Regards,
Simon
Simon
At 9:55 PM +0530 9/9/01, Nilesh Parmar wrote:
Hi
I just came across these words in the mailing lists.
Can anyone tell me what are BDB tables and InnoDB tables .
I am new to mysql and would like to know what are they .
thanx in advance
Nilesh
(1) Go to http://www.mysql.com/doc/
(2
Hi
I just came across these words in the mailing lists.
Can anyone tell me what are BDB tables and InnoDB tables .
I am new to mysql and would like to know what are they .
thanx in advance
Nilesh
-
Before
Hi
I just came across these words in the mailing lists.
Can anyone tell me what are BDB tables and InnoDB tables .
I am new to mysql and would like to know what are they .
thanx in advance
Nilesh
Description:
MySQL Crashes with BDB Tables and replace into in some cases
How-To-Repeat:
mysql create table test (sessionid varchar(80) not null primary key, sessionval blob,
lastopen timestamp not null) type=bdb;
Query OK, 0 rows affected (0.88 sec)
mysql alter table test add
Peter So it seems like log files went dammaged.
Peter This is even more surprising as I had no machine crash or reboot...
MW I agree; The above is something that should never happen.
MW How many bdb tables do you have now?
About 1200. But only 120 of them are really used now (in test script
Hi. This is my first post to this list, and it's about a problem
we have with BDB tables in MySQL.
From time to time when we retrieve data from a table we don't get
right answer, i mean, we get part of the result set. Then if we
make an optimize table tablename and try to retrieve same data
we
For some reason the tables BDB corrupt.
Last night it leaves running programs (implemented in C) that consults and
modifies these tables and in morning one of the indexes was corrupt.
All the programs use mysql_close to close the connection to the database.
Look the query i did today of
-5092(WCK)
/ Fax:281-544-2646(WCK)
/ email: [EMAIL PROTECTED]
-
-Original Message-
From: Stephen Faustino [mailto:[EMAIL PROTECTED]]
Sent: Monday, March 05, 2001 4:11 PM
To: '[EMAIL PROTECTED]'
Subject: RE: BDB tables on Linux
show variables
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the tarball
for Solaris and the RPM for Linux. The BDB tables work as expected on
Solaris, but they did not not work under Linux. What I'm seeing is that I
can create a BDB just fine. However, attempting a rollback results
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the
tarball for Solaris and the RPM for Linux. The BDB tables work as
expected on Solaris, but they did not not work under Linux. What
I'm seeing is that I can
, 2001 3:29 PM
To: Stephen Faustino
Cc: '[EMAIL PROTECTED]'
Subject: Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the
tarball for Solaris and the RPM for Linux. The BDB tables work
]'
Subject: Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 03:44:20PM -0600, Stephen Faustino wrote:
Yes, I specified that the table should use the BDB table handler,
but it does not appear that the table was created as a BDB table.
Are you *sure* you're running a version with BDB support compiled
As far I can tell, you have to rebuild from source.
BDB works very bad for me (linuxppc). Extremely slow and errors.
Christian.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
On Mon, Mar 05, 2001 at 04:10:59PM -0600, Stephen Faustino wrote:
show variables showed that have_bdb is no, and none of the bdb
variables are there. So does this mean that BDB is NOT compiled
into the binary included in the Linux RPM, or does it mean that I
need to add the necesary
, March 05, 2001 3:29 PM
To: Stephen Faustino
Cc: '[EMAIL PROTECTED]'
Subject: Re: BDB tables on Linux
On Mon, Mar 05, 2001 at 11:27:54AM -0600, Stephen Faustino wrote:
I've installed 3.23.33 on both Solaris and Linux RH 6.2 using the
tarball for Solaris and the RPM for Linux. The BDB tables work
Hi!
"Sasha" == Sasha Pachev [EMAIL PROTECTED] writes:
cut
Sasha I do have a patch for it now. From what I understood in the code, this is
Sasha actually a more correct way to do things, but I would like to get Monty's
Sasha approval to be sure. After the patch, MySQL still passes our test
[EMAIL PROTECTED] writes:
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided to drop the offending
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided
On Wednesday 28 February 2001 22:04, [EMAIL PROTECTED] wrote:
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided
On Thursday 01 March 2001 13:32, Quentin Bennett wrote:
cut
After the patch, MySQL still passes our test suite, which is a good sign.
/cut
But how come it passed the test suite with the bug in place ?? ;-)
It does not any more, with the bug not fixed, that is. We update the test
suite every
Hi folks, I'm having a hard time using bdb tables. Here are the
details...
I've create a few BDB tables, which are causing me great amounts
of grief. The tables worked fine for a while, then suddenly
started crashing mysqld. I decided to drop the offending
database, and re-create it. No problem
. Where can I
download the source from to start trying to use Innobase rather than BDB
tables?
Innobase is projected to be released in MySQL-3.23.34. Monty will be back
from South America on Thursday or Friday, and the work to build the
release will continue.
By the way, Innobase now has a web
and attempt to rollback a
transaction, we get an error during rollback and the data is not rolled
back. However, doing the exact same transaction on a BDB table that is not
specified as being temporary work as expected, ie, a rollback undoes the
updates.
2. What is the status of BDB tables on Win32
On Mon, Feb 26, 2001 at 05:52:09PM -0600, Stephen Faustino wrote:
3. I've read several posts regarding the Innobase tables. Where can
I download the source from to start trying to use Innobase rather
than BDB tables?
They'll be in 3.23.24 when it is released.
Or you can pull them from
Hello list
I've just installed mysql-3.23.33 with db-3.2.9a (linux on a ppc) and
still have dog slow bdb tables with data errors.
How fast are bdb tables really, for those where they work? Doing 3
queries/sec is not a real option for me.
Note that I had to change the makefile in db-3.2.9a
I am experimenting with MySQL for both Linux and Windows 2000. The trouble is, I do
not Have Visual C to compile the BDB code under Windows 2K. Is there any place to
download them for Windows 2000 in a binary form? Or is there somebody who can compile
them for me?
Description:
The following sequencee of statements should cause a deadlock.
transaction | operation | object
+---+---
1 | write | a
2 | write | b
2 | read | a
1 | read | b
It fails to do so with mysql-3.23.32
I feel like the BDB tables have been around long enough to be
reasonably stable and mature enough to have some confidence in
them. But it always helps to hear people say things like:
I've been using BDB tables in a high-volume environment with no
problems since date. And the BDB page-level
Description : I am use mysql with bdb tables. My front end is make in PHP 4.0.4. And
since i have installed bdb support,
some times my ServerMysql (mysqld) down !!! And i lost all my data bases !!
Before this, i dont can repair the tables which use bdb tables, and i lost every datas
!!
I
Will someone from the MySQL team (or anyone with this knowledge) please tell
me if the test suite has been run with RedHat 7.0 and Berkeley tables?
I am currently running RedHat 6.2 and Berkeley tables and transactions DO
work. I want to upgrade to RedHat 7.0, but not if transactions stop
43 matches
Mail list logo