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. The following
are the results of my sessions on Solaris and Linux:
Solaris:
mysql> create table test (x int) type = BDB;
Query OK, 0 rows affected (0.46 sec)
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values (1);
Query OK, 1 row affected (0.00 sec)
mysql> rollback;
Query OK, 0 rows affected (0.00 sec)
mysql> select * from test;
Empty set (0.06 sec)
mysql>
Linux:
mysql> create table test (x int) type = BDB;
Query OK, 0 rows affected (0.01 sec)
mysql> set autocommit=0;
Query OK, 0 rows affected (0.00 sec)
mysql> insert into test values (1);
Query OK, 1 row affected (0.00 sec)
mysql> rollback;
ERROR 1196: Warning: Some non-transactional changed tables couldn't be
rolled b
ack
mysql> select * from test;
+------+
| x |
+------+
| 1 |
+------+
1 row in set (0.00 sec)
mysql>
Stephen L. Faustino
Senior Software Engineer
SecureLogix Corporation
Direct/Vmail (210)402-9669x949
mailto:[EMAIL PROTECTED]
-----Original 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 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 in:
>
> ERROR 1196: Warning: Some non-transactional changed tables couldn't be
> rolled back
>
> When I do a mysqldump, the ddl for the table shows a type of MyISAM.
This suggestst that they weren't created as BDB tables.
Can you verify that they're created properly?
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 328-7878 Fax: (408) 530-5454
Cell: (408) 439-9951
---------------------------------------------------------------------
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, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php