>Description:
MySQL 3.23.39 on FreeBSD 4.3.
Running the sql-bench/test-create script using BDB, mysql will fail
to create a table and will log the error "dbd: Metapage flush failed"
>How-To-Repeat:
sh# test-create --log --create-options=TYPE=BDB
Testing server 'MySQL 3.23.39 log' at 2001-07-05 0:40:12
Testing the speed of creating and droping tables
Testing with 10000 tables and 10000 loop count
Testing create of tables
Can't execute command 'create table bench_407 (i int NOT NULL,d double,f float,s
char(10),v varchar(100),primary key (i)) TYPE=BDB'
Error: Can't create table './test/bench_407.frm' (errno: 0)
>Fix:
>Submitter-Id: <submitter ID>
>Originator: John David Duncan
>Organization:
>MySQL support: none
>Synopsis:
>Severity: non-critical
>Priority: low
>Category: mysql
>Class: sw-bug
>Release: mysql-3.23.39 (yes)
>Server: /usr/local/bin/mysqladmin Ver 8.21 Distrib 3.23.39, for
>unknown-freebsdelf4.3 on i386
Copyright (C) 2000 MySQL AB & MySQL Finland AB & TCX DataKonsult AB
This software comes with ABSOLUTELY NO WARRANTY. This is free software,
and you are welcome to modify and redistribute it under the GPL license
Server version 3.23.39-log
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 3 min 18 sec
Threads: 2 Questions: 11742 Slow queries: 0 Opens: 8 Flush tables: 1 Open tables:
1 Queries per second avg: 59.303
>Environment:
System: FreeBSD great5.greatschools.net 4.3-RELEASE FreeBSD 4.3-RELEASE #0: Sat Jun 30
06:45:57 PDT 2001 [EMAIL PROTECTED]:/usr/src/sys/compile/GREAT i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.3 [FreeBSD] 20010315 (release)
Compilation info: CC='gcc' CFLAGS='-O3 -mpentiumpro' CXX='gcc' CXXFLAGS='-O3
-mpentiumpro -felide-constructors -fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1174570 Apr 21 02:05 /usr/lib/libc.a
lrwxrwxrwx 1 root wheel 9 Jun 27 20:55 /usr/lib/libc.so -> libc.so.4
-r--r--r-- 1 root wheel 561580 Apr 21 02:05 /usr/lib/libc.so.4
Configure command: ./configure --with-mysqld-user=mysql --enable-assembler
--with-comment --with-berkeley-db --localstatedir=/var/mysql
--with-mysqld-ldflags=-all-static --disable-shared --with-gnu-ld --with-charset=latin1
Perl: This is perl, version 5.005_03 built for i386-freebsd
---------------------------------------------------------------------
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
