(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'.
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 My
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 r
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
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
>
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 S
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),
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
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
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
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 wor
TECTED]>
Sent: Wednesday, January 23, 2002 9:41 AM
Subject: how to repair bdb tables?
> Hello Christian,
>
> Wednesday, January 23, 2002, 2:03:18 PM, you wrote:
>
> CH> Hello
>
> CH> I just wondered how to repair/check a berkeley db (bdb) table. I
cannot
> CH> use (
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 m
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 Bur
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
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
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
Hi!
I need some help...
Since Friday I updated our MySQL-server from 3.23.32 to 3.23.39 by
deinstalling the old version (I did not use patches), because we need to
use transactions. I set default-table-type to BDB.
Our OS ist WinNT ServicePack 5, we use mysqld-max.exe .
Everything works fine, e
>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> alte
010531 18:16:22 bdb: log_archive: DB_ARCH_ABS: DB_RUNRECOVERY: Fatal
Peter>> error, run database recovery
Peter>> 010531 18:16:22 /usr/local/mysql/libexec/mysqld: Shutdown Complete
Peter>> So it seems like log files went dammaged.
Peter>> This is even more surprising as I ha
Hello mysql,
I'm testing BDB tables in mysql to find out i'll be able to use
them in my application.
I was testing how does big tables work with BDB and so created table
which is about 10GB in size. I could easy make it with multiple
inserts from test-insert, so the pr
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 " and try to retrieve sa
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 morning
Dear MySQL users:
I've a problem with BDB tables, with specially AutoIncrement field..
The structure is:
CREATE TABLE chart (
id int AUTO_INCREMENT,
accno int,
description text,
balance float,
type char(1) DEFAULT 'A',
gifi int,
category char(1),
link text,
-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
Message-
From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]]
Sent: Monday, 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 So
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 BDB
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)
http://lists.m
ECTED]'
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
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 in?
The output of SHOW VARI
y [mailto:[EMAIL PROTECTED]]
Sent: Monday, 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 th
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'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
Hi!
> "Sasha" == Sasha Pachev <[EMAIL PROTECTED]> writes:
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
Hi Sasha,
The patch you sent me seems to have created other problems,
or simply has allowed to find new ones :)
I'm working on isolating exactly which query makes the bdb
tables crash. Full bug report on the way.
So far, it looks like left joins on bdb tables does something weird.
On Thursday 01 March 2001 13:32, Quentin Bennett wrote:
>
>
>After the patch, MySQL still passes our test suite, which is a good sign.
>
>
>
>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
After the patch, MySQL still passes our test suite, which is a good sign.
But how come it passed the test suite with the bug in place ?? ;-)
Quentin
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
reci
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
&g
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
&g
On Thu, Mar 01, 2001 at 12:04:27AM -0500, [EMAIL PROTECTED] wrote:
>
> I've replicated this problem on 3 different machines, and
> on 3.23.33 and 3.23.32. I had been using BDB tables for a
> couple weeks now in testing, without a hitch until the above
> query starting bein
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
&g
[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 m
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.
#x27;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?
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
re
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
B 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
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
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 comp
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 . And the BDB page-
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
workin
Hello, I'm new to this list, and apologize as I'm sure this has been
covered many times...
I'm upgrading from MySQL 3.22.27 to 3.23.31 on Solaris 2.7, and would
like to experiment with BDB tables.
After reading the 3.23 manual, I'm still unclear whether I need the
MySQL so
53 matches
Mail list logo
