>Description:
Users enter data from a php based web site and receive no errors
or warnings of any kind that something is amiss, but the data isn't
entered into the tables. When I go to the mysql command line and run
commands i get a table handler error.
>How-To-Repeat:
this happens every once in a while and i don't know how to make
it happen
>Fix:
what i do to fix this is to stop mysqld and run myisamchk on all
the tables then restart mysqld. This works for a little bit, but the
problem always reoccurs. If i upgrade to the lates version of mysql it
fixes it for a few months, but every time the same thing has eventually
started happening again
>Submitter-Id: <submitter ID>
>Originator:
>Organization:
<organization of PR author (multiple lines)>
>MySQL support: [none | licence | email support | extended email support
]
>Synopsis: <synopsis of the problem (one line)>
>Severity: <[ non-critical | serious | critical ] (one line)>
>Priority: <[ low | medium | high ] (one line)>
>Category: mysql
>Class: <[ sw-bug | doc-bug | change-request | support ] (one
line)>
>Release: mysql-3.23.49 (Official MySQL binary)
>Environment:
<machine, os, target, libraries (multiple lines)>
System: SunOS ccac 5.7 Generic_106541-04 sun4u sparc
SUNW,UltraSPARC-IIi-Engine
Architecture: sun4
Some paths: /usr/local/bin/perl /usr/local/bin/make /usr/local/bin/gcc
/usr/ucb/cc
GCC: Reading specs from
/usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.8.1/specs
gcc version 2.8.1
Compilation info: CC='gcc' CFLAGS='-O3 -fno-omit-frame-pointer'
CXX='gcc' CXXFLAGS='-O3 -fno-omit-frame-pointer -felide-constructors
-fno-exceptions -fno-rtti' LDFLAGS=''
LIBC:
-rw-r--r-- 1 bin bin 1696236 Apr 19 1999 /lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 22 2000 /lib/libc.so ->
./libc.so.1
-rwxr-xr-x 1 bin bin 1118620 Apr 19 1999 /lib/libc.so.1
-rw-r--r-- 1 bin bin 1696236 Apr 19 1999 /usr/lib/libc.a
lrwxrwxrwx 1 root root 11 Mar 22 2000 /usr/lib/libc.so
-> ./libc.so.1
-rwxr-xr-x 1 bin bin 1118620 Apr 19 1999 /usr/lib/libc.so.1
Configure command: ./configure --prefix=/usr/local/mysql
'--with-comment=Official MySQL binary' --with-extra-charsets=complex
--with-server-suffix= --enable-thread-safe-client --enable-local-infile
--enable-assembler --disable-shared
Perl: This is perl, version 5.005_03 built for sun4-solaris
---------------------------------------------------------------------
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
