Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email firstname.lastname@example.org
Date: Tue Sep 16 2008 - 14:45:37 CDT
See Thread at: http://www.techienuggets.com/Detail?tx=46643 Posted on behalf of a User
first check the error log and find the position where the replication was terminated.Now run the mysqlbinlog utility on the binarylogs file.
Now when you run the query will get the text format as a result.serch for the position and see as to which query was ran on that position.check if that qurey ran on the slave before bcoz we dont need a duplication of thr query.If not plz run the query on the slave.Stop/start the slave.You sholud get the Slave back to SYNC.
In Response To:
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 at its current postion does not help here
(the same error happens again with next entry in bin log), the only way I
know how to fix this is to flush the logs and restart the slave with the new
log file (changes in between are manually synched).
I would appreciate any pointers about where to start looking for the
problem. E.g. is the bin log file corrupt? And if so why does this happen so
----------------------------------------- Confidentiality Notice:
The following mail message, including any attachments, is for the
sole use of the intended recipient(s) and may contain confidential
and privileged information. The recipient is responsible to
maintain the confidentiality of this information and to use the
information only for authorized purposes. If you are not the
intended recipient (or authorized to receive information for the
intended recipient), you are hereby notified that any review, use,
disclosure, distribution, copying, printing, or action taken in
reliance on the contents of this e-mail is strictly prohibited. If
you have received this communication in error, please notify us
immediately by reply e-mail and destroy all copies of the original
message. Thank you.
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql