db1125:3312 positions
ActivePublic
Actions

Authored by • Marostegui on Jan 5 2021, 6:46 AM.

Tags

None

Referenced Files

	F33985186: db1125:3312 positions
	Jan 5 2021, 6:46 AM

Subscribers

None

	root@cumin1001:/home/marostegui/T270053# mysql.py -hdb1125:3312 -e "show slave status\G"
	************************* 1. row *************************
	Slave_IO_State: Reconnecting after a failed master event read
	Master_Host: db1074.eqiad.wmnet
	Master_User: repl
	Master_Port: 3306
	Connect_Retry: 60
	Master_Log_File: db1074-bin.006147
	Read_Master_Log_Pos: 401395959
	Relay_Log_File: db1125-relay-bin.000384
	Relay_Log_Pos: 401396248
	Relay_Master_Log_File: db1074-bin.006147
	Slave_IO_Running: Connecting
	Slave_SQL_Running: Yes
	Replicate_Do_DB:
	Replicate_Ignore_DB:
	Replicate_Do_Table:
	Replicate_Ignore_Table:
	Replicate_Wild_Do_Table:
	Replicate_Wild_Ignore_Table: mysql.%,oai.%,advisorswiki.%,arbcom_cswiki.%,arbcom_dewiki.%,arbcom_enwiki.%,arbcom_fiwiki.%,arbcom_nlwiki.%,arbcom_ruwiki.%,auditcomwiki.%,boardgovcomwiki.%,boardwiki.%,chairwiki.%,chapcomwiki.%,checkuserwiki.%,collabwiki.%,ecwikimedia.%,electcomwiki.%,execwiki.%,fdcwiki.%,grantswiki.%,id_internalwikimedia.%,iegcomwiki.%,ilwikimedia.%,internalwiki.%,legalteamwiki.%,movementroleswiki.%,noboard_chapterswikimedia.%,officewiki.%,ombudsmenwiki.%,otrs_wikiwiki.%,projectcomwiki.%,searchcomwiki.%,spcomwiki.%,stewardwiki.%,sysop_itwiki.%,techconductwiki.%,transitionteamwiki.%,wg_enwiki.%,wikimaniateamwiki.%,zerowiki.%,%.__wmf_checksums,%.accountaudit_login,%.arbcom1_vote,%.archive_old,%.blob_orphans,%.blob_tracking,%.bot_passwords,%.bv2009_edits,%.categorylinks_old,%.click_tracking,%.cu_changes,%.cu_log,%.cur,%.echo_email_batch,%.echo_event,%.echo_target_page,%.echo_unread_wikis,%.echo_notification,%.echo_push_subscription,%.edit_page_tracking,%.email_capture,%.exarchive,%.exrevision,%.globalnames,%.hidden,%.image_old,%.job,%.linkscc,%.localnames,%.log_search,%.logging_old,%.long_run_profiling,%.migrateuser_medium,%.moodbar_feedback,%.moodbar_feedback_response,%.msg_resource,%.oathauth_users,%.oauth_accepted_consumer,%.oauth_ratelimit_client_tier,%.oauth_registered_consumer,%.oauth2_access_tokens,%.objectcache,%.old_growth,%.oldimage_old,%.optin_survey,%.prefstats,%.prefswitch_survey,%.profiling,%.querycache,%.querycache_info,%.querycache_old,%.querycachetwo,%.reading_list,%.reading_list_entry,%.securepoll_cookie_match,%.securepoll_elections,%.securepoll_entity,%.securepoll_lists,%.securepoll_msgs,%.securepoll_options,%.securepoll_properties,%.securepoll_questions,%.securepoll_strike,%.securepoll_voters,%.securepoll_votes,%.spoofuser,%.text,%.titlekey,%.transcache,%.uploadstash,%.urlshortcodes,%.user_newtalk,%.vote_log,%.watchlist,%.watchlist_expiry,%.wikimedia_editor_tasks_counts,%.wikimedia_editor_tasks_keys,%.wikimedia_editor_tasks_targets_passed
	Last_Errno: 0
	Last_Error:
	Skip_Counter: 0
	Exec_Master_Log_Pos: 401395959
	Relay_Log_Space: 401396591
	Until_Condition: None
	Until_Log_File:
	Until_Log_Pos: 0
	Master_SSL_Allowed: Yes
	Master_SSL_CA_File:
	Master_SSL_CA_Path:
	Master_SSL_Cert:
	Master_SSL_Cipher:
	Master_SSL_Key:
	Seconds_Behind_Master: NULL
	Master_SSL_Verify_Server_Cert: No
	Last_IO_Errno: 2003
	Last_IO_Error: error reconnecting to master 'repl@db1074.eqiad.wmnet:3306' - retry-time: 60 maximum-retries: 86400 message: Can't connect to MySQL server on 'db1074.eqiad.wmnet' (111 "Connection refused")
	Last_SQL_Errno: 0
	Last_SQL_Error:
	Replicate_Ignore_Server_Ids:
	Master_Server_Id: 171966668
	Master_SSL_Crl:
	Master_SSL_Crlpath:
	Using_Gtid: Slave_Pos
	Gtid_IO_Pos: 0-180359173-4858865027,171966668-171966668-3090,180359173-180359173-70817914,171978786-171978786-2475603130,171970567-171970567-390719906,171966574-171966574-2221092918,180359241-180359241-121693516,171966670-171966670-2410812544,180359271-180359271-332498589
	Replicate_Do_Domain_Ids:
	Replicate_Ignore_Domain_Ids:
	Parallel_Mode: conservative

Event Timeline

• Marostegui created this paste.Jan 5 2021, 6:46 AM

• Marostegui mentioned this in T268742: Test upgrading sanitarium hosts to Buster + 10.4.

db1125:3312 positionsActivePublicActions

Event Timeline

db1125:3312 positions
ActivePublic
Actions