Bug 1567344
Summary: | Mariadb crashing | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Product: | Red Hat Enterprise Linux 7 | Reporter: | Rupesh Patel <rupatel> | ||||||||||||
Component: | mariadb | Assignee: | Michal Schorm <mschorm> | ||||||||||||
Status: | CLOSED WONTFIX | QA Contact: | qe-baseos-daemons | ||||||||||||
Severity: | urgent | Docs Contact: | |||||||||||||
Priority: | urgent | ||||||||||||||
Version: | 7.7 | CC: | databases-maint, dkinkead, hhorak, jenander, jhunt, mmuzila, mprashad, mschorm, raginjup, raramach, rupatel | ||||||||||||
Target Milestone: | rc | Keywords: | PrioBumpGSS | ||||||||||||
Target Release: | --- | ||||||||||||||
Hardware: | All | ||||||||||||||
OS: | Linux | ||||||||||||||
Whiteboard: | |||||||||||||||
Fixed In Version: | Doc Type: | If docs needed, set a value | |||||||||||||
Doc Text: | Story Points: | --- | |||||||||||||
Clone Of: | Environment: | ||||||||||||||
Last Closed: | 2019-08-02 19:42:55 UTC | Type: | Bug | ||||||||||||
Regression: | --- | Mount Type: | --- | ||||||||||||
Documentation: | --- | CRM: | |||||||||||||
Verified Versions: | Category: | --- | |||||||||||||
oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |||||||||||||
Cloudforms Team: | --- | Target Upstream Version: | |||||||||||||
Embargoed: | |||||||||||||||
Attachments: |
|
Description
Rupesh Patel
2018-04-13 20:11:54 UTC
Created attachment 1424222 [details]
table structure
I'm totally fine with leaving them in the ticket. Thanks for them Some more information shared by customer. Hi Rupesh, Customer created a new VM and they are able to reproduce the issue after running for 10 mins. Below is the update from customer: So this time it managed to run for 10 min. It works until the tables in tcm_offline DB getting populated with data. The first line we see here is the Enterprise server getting turbine information from the site. The second line is the actual alarms and data being synced to the Enterprise server. 2018-05-17 12:00:23 rx : 183650, tx : 514, ok: 7, fail :0, time : 4.101, works 2018-05-17 12:10:28 rx : 43771206, tx : 500, ok : 7, fail : 0, time : 8.097, Fails I tested the select statement just after I discovered this. The whole script fails, but picking this out and run it alone, it works: SELECT SUBSTRING_INDEX(SUBSTRING_INDEX(MeasurementKey, '/', 2), '/', - 1) AS turbine, IFNULL(MAX(IF(AckStatus = 'UnAck', IF(ISNULL(ToTime), CASE WHEN AlarmType LIKE '%Red%' OR AlarmType LIKE 'Overrun' THEN 8 WHEN AlarmType LIKE '%Yellow%' THEN 7 WHEN AlarmType LIKE 'Blue%' THEN 6 ELSE 0 END, 2), IF(ISNULL(ToTime), CASE WHEN AlarmType LIKE '%Red%' OR AlarmType LIKE 'Overrun' THEN 5 WHEN AlarmType LIKE '%Yellow%' THEN 4 WHEN AlarmType LIKE 'Blue%' THEN 3 ELSE 0 END, 1))), - 1) AS severity FROM alarm_events WHERE site_index = 2 AND site_index IN (1 , 2) GROUP BY turbine; Note:- This was also reproduced on Azure machine only. Created attachment 1448402 [details]
alarm_events
Created attachment 1448403 [details]
rest_measurement_registry
Created attachment 1448404 [details]
site_configuration
Created attachment 1448405 [details]
syslog_events
Created attachment 1448406 [details]
turbine_information
After discussion with the team closing this bug |