MySQL's pretty good when it describes an error. (if the error message
is vague you might be screwed, but MySQL is pretty good).
Which means:
1) You didn't properly change the max_allowed_packet on the master.
what does show variables like max_allowed_packet; show you?
2) The slave is
Chris Knipe wrote:
[..]
Sure, there is a syntax error in the query - yes. But why does the
master not put the complete query in the bin log? This is the
second time in 3 days that it has happened now. Whilst we are on this,
how do I tell the slave to skip the query and proceed with
Chris Knipe wrote:
[..]
Sure, there is a syntax error in the query - yes. But why does the
master not put the complete query in the bin log? This is the
second time in 3 days that it has happened now. Whilst we are on this,
how do I tell the slave to skip the query and proceed with
Chris Knipe wrote:
[..]
Sure, there is a syntax error in the query - yes. But why does the
master not put the complete query in the bin log? This is the
second time in 3 days that it has happened now. Whilst we are on this,
how do I tell the slave to skip the query and proceed with
Chris Knipe wrote:
Now, I've been running for not even 1 hour with the skip-errors
enabled A quick check, on ONE table...
[EMAIL PROTECTED]:~# mysql --host=mysqldb01 --database=DB -p
Enter password:
Reading table information for completion of table and column names
You can turn off this
mysql SELECT COUNT(RadAcctId) FROM RadiusAccounting;
+--+
| COUNT(RadAcctId) |
+--+
|1144320 |
+--+
1 row in set (1.69 sec)
[EMAIL PROTECTED]:~# mysql --host=mysqldb02 --database=DB -p
mysql SELECT COUNT(RadAcctId) FROM
- Original Message -
From: Richard Lynch [EMAIL PROTECTED]
To: Chris Knipe [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Sent: Friday, March 11, 2005 12:08 AM
Subject: Re: replication errors
mysql SELECT COUNT(RadAcctId) FROM RadiusAccounting;
+--+
| COUNT(RadAcctId
Hi Chris,
OK, I can't take this anymore. :)
Now, I've been running for not even 1 hour with the skip-errors
enabled A quick check, on ONE table...
snip
So there's already data missing on the slave *shrugs*
Yep, you told it to SKIP ERRORS. That means that if any query generates
an error,
So there's already data missing on the slave *shrugs*
Yep, you told it to SKIP ERRORS. That means that if any query generates
an error, for any reason, it's just going to skip over it and move on. So
data was missing on your slave the moment you restarted replication -- it
skipped the
Irek Sonina wrote:
I was thinking that master is executing the same queries that slave does
- if an error exists on slave then it first comes up on the master and
master is not executing it either.
You prove that I was wrong... now I must check the integrity of the data
on my slaves, which all
Thanks! I was hoping it was something that had already been found. I'll
upgrade as soon as I can.
Thanks,
Brian
-Original Message-
From: Sasha Pachev [mailto:[EMAIL PROTECTED]
Sent: Wednesday, March 24, 2004 10:47 PM
To: Stanton, Brian
Cc: '[EMAIL PROTECTED]'
Subject: Re: Replication
Stanton, Brian wrote:
Shortly after the MySQL 4.0 line went to production, I upgraded to mysql
4.0.12. Since then my slave has been getting corrupted tables 2 to 3 times
every month. I've also seen this problem in mysql 4.0.13. When I run a
check table on the table in question it gives the
NEWEST**
I am now getting this error while trying to Replicate to a second MySQL
server.
021125 0:41:01 Slave: Failed reading log event, reconnecting to retry, log
'bsd1-bin.001' position 73
021125 0:41:01 Slave: reconnected to master
'[EMAIL
On Mon, Nov 18, 2002 at 11:47:48AM -0500, Michael T. Babcock wrote:
Any suggestions? This is a live DB ...
021118 10:43:47 InnoDB: Started
/usr/libexec/mysqld: ready for connections
1254 021118 10:43:49 Slave: connected to master
'[EMAIL PROTECTED]:3303', replication started in log
Jeremy Zawodny wrote:
I hate to ask this, bug did you change anything? :-)
In the data? Heck ya :-) ... the versions of the software? No --
although either of them has restarted / flushed logs from time to time
as necessary (I don't have a log rotation program yet for the binary
logs
Pada Wed, 3 Jul 2002 12:56:30 -0700
Jeff Kilbride [EMAIL PROTECTED] menulis :
Is this just a normal timeout error, because there's currently very little
activity on these machines? Or is there some other problem? The
slave_net_timeout value is at it's default of 3600, so I would expect to
16 matches
Mail list logo
