Page MenuHomePhabricator
Create Task
Maniphest T337445

db2110 crashed
Closed, ResolvedPublic
Actions

Description

[05:17:50] <+icinga-wm> PROBLEM - Host db2110 #page is DOWN: PING CRITICAL - Packet loss = 100%

Details

SubjectRepoBranchLines +/-
mariadb: Make db2179 candidate master for s4operations/puppetproduction+2 -2
Customize query in gerrit

Event Timeline

• Marostegui created this task.May 25 2023, 5:23 AM
Restricted Application added a subscriber: Aklapper. · View Herald TranscriptMay 25 2023, 5:23 AM
• Marostegui added a comment.May 25 2023, 5:31 AM

Nothing on HW logs

• Marostegui triaged this task as High priority.May 25 2023, 5:38 AM
Ladsgroup subscribed.May 25 2023, 7:50 AM

The uptime is 2:30 so it got rebooted, not like mysql going down and paging.

• Marostegui added a comment.May 25 2023, 8:01 AM

Yes, that's what I mean with crashed :)

• Marostegui moved this task from Triage to In progress on the DBA board.May 25 2023, 8:18 AM

I haven't been able to find anything on why this host crashed. However, this host is the candidate master for s4, so I am going to move that role to a different host just in case.

Ladsgroup added a comment.May 25 2023, 8:22 AM

Maybe this can be useful in picking the next candidate https://fault-tolerance.toolforge.org/map?cluster=s4
and https://fault-tolerance.toolforge.org/map?cluster=db-master-candidates

• Marostegui added a comment.May 25 2023, 9:06 AM

Definitely! Thanks! I am going to pick db2179

gerritbot added a comment.May 25 2023, 9:08 AM

Change 923261 had a related patch set uploaded (by Marostegui; author: Marostegui):

[operations/puppet@production] mariadb: Make db2179 candidate master for s4

https://gerrit.wikimedia.org/r/923261

gerritbot added a project: Patch-For-Review.May 25 2023, 9:08 AM
gerritbot added a comment.May 25 2023, 9:11 AM

Change 923261 merged by Marostegui:

[operations/puppet@production] mariadb: Make db2179 candidate master for s4

https://gerrit.wikimedia.org/r/923261

Maintenance_bot removed a project: Patch-For-Review.May 25 2023, 9:30 AM
jcrespo subscribed.May 25 2023, 10:22 AM

It looks like an IME exception:

LifecycleLog
	2023-05-25 05:16:13 	SYS1003 	System CPU Resetting.	
	
Log Sequence Number:
267
Detailed Description:
System is performing a CPU reset because of system power off, power on or a warm reset like CTRL-ALT-DEL.
Recommended Action:
No response action is required.
		2023-05-25 05:16:05 	SYS1000 	System is turning on.	
	
Log Sequence Number:
266
Detailed Description:
System is turning on.
Recommended Action:
No response action is required.
		2023-05-25 05:16:02 	PWR2271 	The Intel Management Engine has encountered a Exception Event.	
	
Log Sequence Number:
265
Detailed Description:
The Intel Management Engine has encountered a Exception Event.
Recommended Action:
Perform an AC Cycle operation on the host server, and then update the BIOS firmware to the latest version. If the issue persists, contact your service provider. For information about recommended BIOS versions, see the BIOS documentation on the support site.
		2023-05-25 05:15:54 	SYS1001 	System is turning off.	
	
Log Sequence Number:
264
Detailed Description:
System is turning off.
Recommended Action:
No response action is required.
		2023-05-25 05:15:54 	SYS1003 	System CPU Resetting.	
	
Log Sequence Number:
263
Detailed Description:
System is performing a CPU reset because of system power off, power on or a warm reset like CTRL-ALT-DEL.
Recommended Action:
No response action is required.
		2023-05-25 05:15:37 	RAC0703 	Requested system hardreset.	
	
Log Sequence Number:
262
Detailed Description:
Requested system hardreset.
Recommended Action:
No response action is required.
		2023-05-25 05:15:16 	CPU0000 	Internal error has occurred check for additional logs.	
	
Log Sequence Number:
261
Detailed Description:
System event log and OS logs may indicate the source of the error.
Recommended Action:
Review System Event Log and Operating System Logs. These logs can help the user identify the possible issue that is producing the problem.
		2023-05-04 09:42:46 	SYS1003 	System CPU Resetting.	
	
Log Sequence Number:
260
Detailed Description:
System is performing a CPU reset because of system power off, power on or a warm reset like CTRL-ALT-DEL.
Recommended Action:
No response action is required.
• Marostegui added a project: ops-codfw.May 25 2023, 11:57 AM
• Marostegui added subscribers: wiki_willy, Papaul.

@Papaul @wiki_willy this server is out of warranty right? I don't know if there's much we can do about

2023-05-25 05:16:13 	SYS1003 	System CPU Resetting.
Maintenance_bot added a project: SRE.May 25 2023, 12:29 PM
wiki_willy assigned this task to Jhancock.wm.May 25 2023, 4:51 PM
wiki_willy added a subscriber: Jhancock.wm.

Hi @Marostegui - Papaul is on paternity leave for another week, so I'm going to pass this over to @Jhancock.wm to check out. The server is about 4yrs old, so it's out of warranty, but there might be parts that could be pulled from a decommissioned server if we're able to isolate the issue. Thanks, Willy

• Marostegui added a comment.May 25 2023, 5:02 PM

Yeah, I wonder if there's anything we can do to troubleshoot this from a hardware point of view.

Jhancock.wm moved this task from Backlog to Hardware Failure / Troubleshoot on the ops-codfw board.May 26 2023, 12:24 AM
Jhancock.wm added a comment.May 26 2023, 2:24 PM

@Marostegui I am looking for a suitable cpu replacement in our decommissioned servers. In the meantime Log Event 265 recommends a BIOS update. The bios is very out of date on this one and I am running that task now.

• Marostegui added a comment.May 26 2023, 2:25 PM

Thanks!

Jhancock.wm added a comment.May 26 2023, 3:46 PM

@Marostegui
the BIOS update is complete.
I found a suitable CPU replacement. Do we want to give that a try now or see if the BIOS update did the trick.
LMK if you wanna swap and if it's safe to do so at this time. thanks!

• Marostegui added a comment.May 26 2023, 3:47 PM

Let's go for the CPU swap too. You can do it anytime. The host isn't in use

Jhancock.wm added a comment.May 26 2023, 3:49 PM

I forgot to ask. was it CPU1 or CPU2 that was having the issue?

• Marostegui added a comment.May 26 2023, 3:52 PM

It doesn't say on the error:

	2023-05-25 05:16:13 	SYS1003 	System CPU Resetting.
Jhancock.wm added a comment.May 26 2023, 4:24 PM

I replace both since we're not sure. server has booted without issues. all components are green in the idrac dashboard. it's all yours now!

I do see some slight discoloration on the old CPU2. not sure if it's from regular use or an undiagnosed issue.
I've put the old CPUs in the server with the tag 11V3DP2.

• Marostegui added a comment.May 26 2023, 8:15 PM

Thank you!. I'll bring Mariadb up on Monday and leave it running for a few days before repooling it, to make sure everything is stable

• Marostegui added a comment.May 29 2023, 5:32 AM

Started mariadb

• Marostegui closed this task as Resolved.May 30 2023, 7:15 AM

The host is repooled. Thanks for your help!

Maintenance_bot moved this task from In progress to Done on the DBA board.May 30 2023, 7:15 AM
Content licensed under Creative Commons Attribution-ShareAlike (CC BY-SA) 4.0 unless otherwise noted; code licensed under GNU General Public License (GPL) 2.0 or later and other open source licenses. By using this site, you agree to the Terms of Use, Privacy Policy, and Code of Conduct. · Wikimedia Foundation · Privacy Policy · Code of Conduct · Terms of Use · Disclaimer · CC-BY-SA · GPL