Oscar Stiffelman wrote:
>
> Oscar Stiffelman wrote:
> >
> > Every minute or so, I add about 400 rows to a mysql database using
> > mm.mysql.jdbc-2.0pre4. After about 3 days of this, the database exits
> > with no explanation. It just says "mysqld ended" in the host.err file.
> >
> > I am running mysql version 3.22.30 on Linux compiled from sources.
> >
> > The machine is a dual PIII 500MHZ (SMP) running kernel 2.2.13, and
> > libc5.
> >
> > The database has a large number of rows (~6 million), but the crashes
> > were appearing when it was only around .5 million rows.
> >
> > The ISM file is about 200 MB, and the ISD file is about 130 MB.
> >
>
First, isamchk your tables ( repair if needed).
If the problems still happens, this looks like a segfault in mysql.
See if you can repeat the problem in a separate database, and send us the
trouble tables -- put everything in a tarball with a readme file, and drop it
off to ftp://ftp.mysql.com/pub/mysql/secret
--
Sasha Pachev
+------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sasha Pachev |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sasha@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Provo, Utah, USA |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+------------------------------------------------------------------+
