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,
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
So, you're a lucky guy! I got the same "problem" but more strange and comic.
I've been using perl / DBI to access mysql on my scripts, an week ago I got the same
error as you.
I runned out repair my tables (everyone says that this error is about corrupted
tables), after repair and local/consol
2 servers with --log-slave-update and
other required replication stuff, so I'll put them replicating each other and if some
table get corrupted I'll change the LVS switch and my system will work fine until I
fix the problem.
Next time I see some bug I'll send a report wit
cerveja:/var/lib/mysql# mysqldump -e -l -F -h champagne velop >
champagne.velop.20010214.dump
Segmentation fault
cerveja:/var/lib/mysql#
:/
---
Tenha uma conta de email Grátis no ACBusca!
---
mysqldump dia a wrong dump.
it had problems dumpping fields filled with a lot of ' " : ( '
the strange point is that I redo the dump and it worked.
---
Tenha uma conta de email Grátis no ACBusca!
--
Does this problem exist in 3.23.32??
>
>Thanks for the bug report. The problem is a bug in the code that skips events
>when it sees a log entry with the same server id - something that can only
>happen in the bi-directional replicaiton setup. Fix:
>
>--- 1.85/sql/slave.cc Sat Jan 27 15:33:
I'm running mysql 3.23.32, I did the test:
With a running server I forced a kind of problem, I delete the MYI file.
#mv contaComum.MYI contaComum.MYI.bck
Then I run CHECK TABLE contaComum;
It returns OK.
If I restard server or execute a flush tables it'll show the problem.
Should CHECK TABLE
I'm getting this erros sometimes
DBI->connect failed: Can't create a new thread (errno 11). If you are not out of
available memory, you can consult the manual for a possible OS-dependent bug at
/usr/lib/perl5/INOVA/DB/libdb.pm line 113
This beggins to happen after I set max_connections up
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).
I got the magic number, but I prefer a solution instead my prize!
I have a lot of "COOL BUGS".
I'am a MYSQL FAN.
-
How to start a replication from without stoping master?
-
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
How can I get the log-bin initial position?
Like: trevas-bin.001
trevas-bin.002
I want to know in which position trevas-bin.002 began.
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
12 matches
Mail list logo
