Jump to content

Obsolete:Replication breakage May 2008

From Wikitech
Note: This page was created as a temporary pastebin and probably doesn't make any sense without its proper context

reconstructed statement:

use jawiki;
SET TIMESTAMP=1210707822;
BEGIN;
SET INSERT_ID=19555835;
SET TIMESTAMP=1210707822;
INSERT /* Revision::insertOn Jamesbondxx7 */  INTO `text` (old_id,old_text,old_flags) VALUES (NULL,'DB://cluster14/1515974','utf-8,gzip,external');
SET TIMESTAMP=1210707822;
INSERT /* Revision::insertOn Jamesbondxx7 */  INTO `revision` (rev_id,rev_page,rev_text_id,rev_comment,rev_minor_edit,rev_user,rev_user_text,rev_timestamp,rev_deleted,rev_len,rev_parent_id) VALUES (NULL,'1442883','19555835','',210493,'Jamesbondxx7','20080513194342',0,0,1802,19659299);
update page set page_latest=19659353 where page_id=1442883;
commit;


CHANGE MASTER TO
MASTER_HOST='adler',
MASTER_USER='repl',
MASTER_PASSWORD='<pass here>',
MASTER_LOG_FILE='adler-bin.097',
MASTER_LOG_POS=501657600;