vdrifter@stripped wrote:
>
> >Description:
> Hi there. We are using mysql to log tcp/ip connections on our LAN.
> It inserts 500,000+ records per day and over 1 million queries per day.
> Works great, but from day 1 the server dies at approx 22 million entries.
> The error we get is non-unique key is being inserted. The table has 6 keys
> and none of them are set as unique. After running isamchk the error we get
> is
> "error#27 from table handler". The fix has been to delete some of the
> records
> and it works fine (up until it reaches that 22 million mark). There is
> plenty
> of hard drive space left (50% used). This month we've upgraded to mysql 2.22
> from 2.20 hoping that it would fix the problem but it hasn't ... Regardless
> Mysql is a great sql server ...
>
> >How-To-Repeat:
> as described above ...
>
> >Fix:
> as described above. Remove a couple million entries and start up the
> program.
> Works fine until it his that 22 million or so mark. It is worth mentioning
> that
> this problem occurs within your own mysql program. ie: I try to manually
> insert a
> record using an insert query and it gives the error#27 output.
>
>
> >Submitter-Id: <submitter ID>
> >Originator: John Cuzzola
> >Organization: On-Call Internet
>
> >MySQL support: [none | licence | email support | extended email support ]
> >Synopsis: dies at 24 million records and 6 keys
> >Severity: non-critical
> >Priority: low
> >Category: mysql
> >Class: sw-bug
> >Release: mysql-3.22.22 (Source distribution)
> >Server: mysqladmin Ver 7.11 Distrib 3.22.22, for pc-linux-gnu on i686
> TCX Datakonsult AB, by Monty
>
> Server version 3.22.22
> Protocol version 10
> Connection Localhost via UNIX socket
> UNIX socket /tmp/mysql.sock
> Uptime: 11 min 28 sec
>
> Threads: 3 Questions: 601279 Slow queries: 0 Opens: 12 Flush tables: 1 Open
> tables: 8
> >Environment:
>
> System: Linux ip-acc.ocis.net 2.0.36 #2 Wed Nov 25 17:49:18 PST 1998 i686 unknown
> Architecture: i686
>
> Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc
> GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/2.7.2.3/specs
> gcc version 2.7.2.3
> Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
> Configure command: ./configure
> Perl: This is perl, version 5.004_04 built for i386-linux
>
VDrifter,
do an du /usr/local/var/
You may have reached the 2 Gig Filesize limit on 32-bit Linux.
Regards,
Van
--
=========================================================================
Linux rocks!!! www.dedserius.com
=========================================================================
