>Description: When trying to create a type=BDB table under NetBSD 1.6, mysql reports:
ERROR 1005: Can't create table './test/test.frm' (errno: 9) and the error log shows: 030114 17:10:19 bdb: fstat: Bad file descriptor 030114 17:10:19 bdb: /home/mysql/././test/test.db: Bad file descriptor >How-To-Repeat: I've reproduced this using the default data directory of '/var/mysql' which was symlinked to /home/mysql and recompiling with the datadir set to /home/mysql. Run mysql (as root, with password). Input to mysql: use test; create table test(id int not null primary key) type=bdb; A trace of this shows (in relevant part): T@5 : | | | | | | >ha_berkeley::create T@5 : | | | | | | | >fn_format T@5 : | | | | | | | | enter: name: ./test/test.frm dsk: form: .db flag: 6 T@5 : | | | | | | | | >dirname_part T@5 : | | | | | | | | | enter: './test/test.frm' T@5 : | | | | | | | | <dirname_part T@5 : | | | | | | | | >unpack_dirname T@5 : | | | | | | | | | >dirname_part T@5 : | | | | | | | | | | enter: './test/' T@5 : | | | | | | | | | <dirname_part T@5 : | | | | | | | | | >cleanup_dirname T@5 : | | | | | | | | | | enter: from: './test/' T@5 : | | | | | | | | | | exit: to: './test/' T@5 : | | | | | | | | | <cleanup_dirname T@5 : | | | | | | | | <unpack_dirname T@5 : | | | | | | | <fn_format T@5 : | | | | | | | >create_sub_table T@5 : | | | | | | | | enter: sub_name: main T@5 : | | | | | | | <create_sub_table T@5 : | | | | | | | >create_sub_table T@5 : | | | | | | | | enter: sub_name: key01 T@5 : | | | | | | | | >sql_print_error T@5 : | | | | | | | | | error: bdb: fstat: Bad file descriptor T@5 : | | | | | | | | <sql_print_error T@5 : | | | | | | | | >sql_print_error T@5 : | | | | | | | | | error: bdb: /var/mysql/././test/test.db: Bad file descriptor T@5 : | | | | | | | | <sql_print_error T@5 : | | | | | | | | error: Got error: 9 when opening table './test/test.db' T@5 : | | | | | | | <create_sub_table T@5 : | | | | | | <ha_berkeley::create T@5 : | | | | | | >closefrm Creating a myisam type table with the same parameters works. I'm more than willing to assist in tracking/fixing this problem. I need a transactional based table, and innodb won't even compile, due to configuration problems where the include directory for mit-pthreads is missed. >Fix: Don't use BDB tables. No work around known. >Submitter-Id: Resun2003001 >Originator: Don Phillips >Organization: >MySQL support: none >Synopsis: BDB table creation fails under NetBSD 1.6. >Severity: critical >Priority: high >Category: mysql >Class: sw-bug >Release: mysql-3.23.49 (Source distribution) >Environment: System: NetBSD sqlhost01.resun.com 1.6 NetBSD 1.6 (resun) #2: Fri Oct 4 18:06:47 UTC 2002 root@:/usr/src/sys/arch/i386/compile/resun i386 Some paths: /usr/pkg/bin/perl /usr/bin/make /usr/pkg/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Using builtin specs. gcc version 2.95.3 20010315 (release) (NetBSD nb3) Compilation info: CC='cc' CFLAGS='-I/usr/pkg/include -O2' CXX='c++' CXXFLAGS='-I/usr/pkg/include -I/usr/pkg/include -O2' LDFLAGS='-L/usr/pkg/lib -Wl,-R/usr/pkg/lib/mysql -Wl,-R/usr/pkg/lib' LIBC: -r--r--r-- 1 root wheel 1345334 Sep 8 11:49 /usr/lib/libc.a lrwxr-xr-x 1 root wheel 13 Sep 8 11:49 /usr/lib/libc.so -> libc.so.12.83 lrwxr-xr-x 1 root wheel 13 Sep 8 11:49 /usr/lib/libc.so.12 -> libc.so.12.83 -r--r--r-- 1 root wheel 700411 Sep 8 11:49 /usr/lib/libc.so.12.83 Configure command: ./configure --localstatedir=/var/mysql --with-named-z-libs=z --without-libwrap '--with-named-curses-libs=-lcurses -ltermcap' --without-readline --without-docs --without-debug --without-bench --with-low-memory --without-server --host=i386--netbsdelf --prefix=/usr/pkg --------------------------------------------------------------------- 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