Well, about the error, I can say that the network was ok (I had another database
replicating) and my tables wasn't corrupted (myisamchk / check table / selects) it was
something really weird.
I'm fighting with my MASTER problems (table corruption).
=
>Rodolfo Sikora writes:
> > This table is getting corrupted all the time (twice a week).
> >
> > We have only SELECTS and INSERTS with little updates. (we have 140.000
>registers growing faster to 100 :))
> >
> > CREATE TABLE conta (
> > idConta int(8) unsigned NOT NULL auto_increment,
> > idDominio int(6) unsigned DEFAULT '0' NOT NULL,
> > conta varchar(30) DEFAULT '' NOT NULL,
> > senha varchar(32) DEFAULT '' NOT NULL,
> > usermount varchar(100) DEFAULT '' NOT NULL,
> > userlock int(1) DEFAULT '0' NOT NULL,
> > senha2 varchar(255) DEFAULT '' NOT NULL,
> > PRIMARY KEY (idConta),
> > UNIQUE idDominio (idDominio,conta)
> > );
> >
> > The worst is tha we have another table with 1.000.000
>inserts/updates/deletes/selects and this table never get corrupted.
> >
> > What should I do to prevent corruptions. (every day I run an optimize,
>check table... etc..)
> >
> > I'm running mysql under a NetServer LC2000 (HP) with RAID 5 and 1GB RAM,
>PIII 667/600.
> >
> > Shoudl I use -O key_buffer and/or table_cache.
> >
> > What really does FLUSH TABLES? it's ok do it once a day?
> >
> >
> > By the way I got this interesting message in my slave log:
> >
> > 010207 12:47:42 Error reading packet from server: Contratulations! You
>have hit the magic number and can win sweepstakes if you report the bug (0)
> >
> > Best regards.
> >
> >
>
>
>HI!
>
>The above error message looks like you have hit a very hard error in
>network protocol.
>
>It could be a cause for table corruption, although we would prefer to
>see a full repeatable test case .
>
>But for the start, you could check that you have no errors in your LAN
>network functioning.
>
>
>Regards,
>
>Sinisa
>
> __ _ _ ___ == MySQL AB
> /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic
>/*/ /*/ /*/ \*\_ |*| |*||*| mailto:[EMAIL PROTECTED]
> /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaca, Cyprus
> /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|
> /*/^^^\*\^^^
> /*/ \*\Developers Team
-
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
