,
Once a week or so I get the following error:
080801 8:18:35 [ERROR] Error reading packet from server: error reading log
entry ( server_errno=1236)
080801 8:18:35 [ERROR] Got fatal error 1236: 'error reading log entry' from
master when reading data from binary log
Stopping the slave and restart
Hi All,
Once a week or so I get the following error:
080801 8:18:35 [ERROR] Error reading packet from server: error reading log
entry ( server_errno=1236)
080801 8:18:35 [ERROR] Got fatal error 1236: 'error reading log entry' from
master when reading data from binary log
Stopping the slave
On Wed, Jul 18, 2007 at 06:13:10PM -0400, I wrote:
This afternoon, both slaves stopped at the same place, with the same error:
070718 17:28:00 [ERROR] Error reading packet from server: error reading log
entry ( server_errno=1236)
070718 17:28:00 [ERROR] Got fatal error 1236: 'error reading
server: error reading log
entry ( server_errno=1236)
070718 17:28:00 [ERROR] Got fatal error 1236: 'error reading log entry' from
master when reading data from binary log
070718 17:28:00 [Note] Slave I/O thread exiting, read up to log
'hlgbinlog-oil.15', position 139702230
If I try to stop
matt ryan wrote:
Tobias Asplund wrote:
On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so,
do they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
Do You tried to distribute replication to other machines? Is
Remigiusz Sokoowski wrote:
matt ryan wrote:
Tobias Asplund wrote:
On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so,
do they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
Do You tried to distribute
(server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the
middle of event' from master when reading data from binary log
040901 18:36:21 Slave I/O thread exiting, read up to log
'FINANCE-bin.186', position 7517914
2 slaves on one box
both masters have identical config
one
On Tue, 7 Sep 2004, matt ryan wrote:
Still have not got this fixed, I'm all out of idea's, the slave has been
reloaded again today
I forgot, did you have multiple slaves on multiple machines? If so, do they
have identical hardware/drivers?
--
MySQL General Mailing List
For list archives:
Tobias Asplund wrote:
On Tue, 7 Sep 2004, matt ryan wrote:
I forgot, did you have multiple slaves on multiple machines? If so, do
they
have identical hardware/drivers?
Multiple slaves on same machine, one works fine
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
040901 18:36:21 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when reading data from binary log
040901 18:36:21 Slave I/O thread exiting, read up to log
We have no idea what you are running, or what you are running it on.
matt ryan wrote:
040901 18:36:21 Error reading packet from server: binlog truncated in
the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the middle
of event' from master when
gerald_clark wrote:
We have no idea what you are running, or what you are running it on.
matt ryan wrote:
040901 18:36:21 Error reading packet from server: binlog truncated
in the middle of event (server_errno=1236)
040901 18:36:21 Got fatal error 1236: 'binlog truncated in the
middle of event
(server_errno=1236)
Got fatal error 1236: 'Client requested master to start replication from
impossible position' from master when reading data from binary log
Slave I/O thread exiting, read up to log 'dbm-bin.041', position
117415283
Master status:
mysql show master status
PROTECTED]
Sent: 24 March 2004 21:17
To: '[EMAIL PROTECTED]'
Subject: Error 1236 corrupt binlog on master
Hello Gurus,
Anyone have any ideas as to how I should handle a case of the following
error?
040324 21:02:05 Slave I/O thread: connected to master
mailto:'[EMAIL PROTECTED]:3306' '[EMAIL
Arvind Gangal wrote:
I have been using the mysqlbinlog to investigate the 'saturn2-bin.051'
binlog file.. I have come to pinpoint the problem position in the binlog,
but don't know how i can bypass the corrupted segment.
This is a bit tricky. Open the binlog in a hex editor, and go to the last
'satur
n2-bin.051' position 442744915
040324 21:02:05 Error reading packet from server: binlog truncated in the
middle of event (server_errno=1236)
040324 21:02:05 Got fatal error 1236: 'binlog truncated in the middle of
event' from master when reading data from binary log
040324 21:02:05 Slave I/O
: log event entry
exceeded max_allowed_packet; Increase max_allowed_packet on master
(server_errno=1236)
031216 9:55:44 Got fatal error 1236: 'log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master' from master
when reading data from binary log
031216 9:55:44 Slave
entry
exceeded max_allowed_packet; Increase max_allowed_packet on master
(server_errno=1236)
031216 9:55:44 Got fatal error 1236: 'log event entry exceeded
max_allowed_packet; Increase max_allowed_packet on master' from master
when reading data from binary log
031216 9:55:44 Slave I/O thread
)
031210 17:02:36 Got fatal error 1236: 'Client requested master to start
replication from impossible position' from master when reading data from
binary log
031210 17:02:36 Slave I/O thread exiting, read up to log 'SV07-bin.008',
position 45866
With show master status (on master) I get:
File
Got fatal error 1236: 'binlog truncated in the middle of event'
from master when reading data from binary log
030219 18:03:20 Slave I/O thread exiting, read up to log 'test42-bin.003',
position 5329913
###
what does this mean? and what shoud I do?
somebody help me~
Replication status after
20 matches
Mail list logo