Jump to content

Obsolete:Replication breakage May 2008

From Wikitech
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
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;