>Description:
Every time I restart the database engine it loses grant entries, and I have
to manually reenter them by hand. Why aren't there rows finding their
way to disk?
>How-To-Repeat:
Add some grants, restart the database.
>Fix:
I don't know of a fix.
>Submitter-Id: <submitter ID>
>Originator: Josef Karthauser
>Organization:
Littoralis Ltd
>MySQL support: [none | licence | email support | extended email support ]
>Synopsis: Database loses rows when the database is restarted.
>Severity: serious
>Priority: medium
>Category: mysql
>Class: sw-bug
>Release: mysql-4.1.1-alpha (FreeBSD port: mysql-server-4.1.1)
>Server: /usr/local/bin/mysqladmin Ver 8.40 Distrib 4.1.1-alpha, for
>portbld-freebsd5.2 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 4.1.1-alpha
Protocol version 10
Connection Localhost via UNIX socket
UNIX socket /tmp/mysql.sock
Uptime: 8 days 16 hours 7 min 34 sec
Threads: 1 Questions: 222876 Slow queries: 0 Opens: 49 Flush tables: 1 Open
tables: 32 Queries per second avg: 0.297
>C compiler: cc (GCC) 3.3.3 [FreeBSD] 20031106
>C++ compiler: c++ (GCC) 3.3.3 [FreeBSD] 20031106
>Environment:
System: FreeBSD jonah.littoralis.com 5.2.1-RELEASE-p3 FreeBSD 5.2.1-RELEASE-p3 #6: Thu
Mar 18 22:19:20 GMT 2004 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/JONAH i386
Some paths: /usr/bin/perl /usr/bin/make /usr/local/bin/gmake /usr/bin/gcc /usr/bin/cc
GCC: Using built-in specs.
Configured with: FreeBSD/i386 system compiler
Thread model: posix
gcc version 3.3.3 [FreeBSD] 20031106
Compilation info: CC='cc' CFLAGS='-O -pipe -mcpu=pentiumpro -D_THREAD_SAFE'
CXX='c++' CXXFLAGS='-O -pipe -mcpu=pentiumpro -D_THREAD_SAFE -O -pipe
-mcpu=pentiumpro -D_THREAD_SAFE -felide-constructors -fno-rtti -fno-exceptions'
LDFLAGS='' ASFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 892356 Mar 28 16:28 /lib/libc.so.5
-r--r--r-- 1 root wheel 1730770 Mar 18 21:57 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 14 Mar 28 16:28 /usr/lib/libc.so -> /lib/libc.so.5
Configure command: ./configure '--localstatedir=/var/db/mysql' '--without-debug'
'--without-readline' '--without-libedit' '--without-bench' '--without-extra-tools'
'--with-libwrap' '--with-mysqlfs' '--with-vio' '--with-low-memory'
'--with-comment=FreeBSD port: mysql-server-4.1.1' '--enable-thread-safe-client'
'--enable-assembler' '--with-berkeley-db' '--with-named-thread-libs=-lc_r'
'--prefix=/usr/local' '--build=i386-portbld-freebsd5.2' 'CFLAGS=-O -pipe
-mcpu=pentiumpro -D_THREAD_SAFE' 'CXX=c++' 'build_alias=i386-portbld-freebsd5.2'
'CC=cc' 'CXXFLAGS=-O -pipe -mcpu=pentiumpro -D_THREAD_SAFE -O -pipe -mcpu=pentiumpro
-D_THREAD_SAFE -felide-constructors -fno-rtti -fno-exceptions'
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
