Project

General

Profile

Actions
Copy link

action #120973

closed

[qem-dashboard] 500 internal server errors reported by qem-bot

Added by kraih over 1 year ago. Updated over 1 year ago.

Status:
Resolved
Priority:
Normal
Assignee:
kraih
Category:
-
Target version:
openQA Project - Ready
Start date:
2022-11-25
Due date:
% Done:

0%

Estimated time:
Tags:
reactive work

Description

Observation

The qem-bot pipeline https://gitlab.suse.de/qa-maintenance/bot-ng/-/jobs/1256680 started reporting 500 errors today:

2022-11-25 13:47:50 ERROR    Smelt Incidents were not synced to dashboard: error 500
2022-11-25 13:47:50 ERROR    Smelt Incidents were not synced to dashboard: error 500
2022-11-25 13:47:50 ERROR    Smelt Incidents were not synced to dashboard: error 500

A look at the qem-dashboard logs showed that it appears to be responsible for the errors:

Nov 25 12:13:56 qam2 dashboard[17595]: [17595] [e] [Fv4nYiFO8Hb9] DBD::Pg::st execute failed: ERROR:  invalid input syntax for type boolean: "{}" at /home/lurklur/qem-dashboard/lib/Dashboard/Model/Incidents.pm line 261.
Nov 25 12:13:56 qam2 dashboard[17595]: [17595] [e] [qt4QwGntMM0u] DBD::Pg::st execute failed: ERROR:  invalid input syntax for type boolean: "{}" at /home/lurklur/qem-dashboard/lib/Dashboard/Model/Incidents.pm line 261.
Nov 25 12:13:56 qam2 dashboard[12869]: [12869] [e] [YdRxgD1Of09s] DBD::Pg::st execute failed: ERROR:  invalid input syntax for type boolean: "{}" at /home/lurklur/qem-dashboard/lib/Dashboard/Model/Incidents.pm line 261.
Nov 25 12:15:26 qam2 dashboard[26872]: [26872] [e] [y-dXDfJS4mg8] DBD::Pg::st execute failed: ERROR:  invalid input syntax for type boolean: "{}" at /home/lurklur/qem-dashboard/lib/Dashboard/Model/Incidents.pm line 261.
Nov 25 12:15:26 qam2 dashboard[17595]: [17595] [e] [5PdDzxiNwfUM] DBD::Pg::st execute failed: ERROR:  invalid input syntax for type boolean: "{}" at /home/lurklur/qem-dashboard/lib/Dashboard/Model/Incidents.pm line 261.
Nov 25 12:15:26 qam2 dashboard[14450]: [14450] [e] [4K-Md0ngkjF9] DBD::Pg::st execute failed: ERROR:  invalid input syntax for type boolean: "{}" at /home/lurklur/qem-dashboard/lib/Dashboard/Model/Incidents.pm line 261.
Nov 25 12:17:57 qam2 dashboard[17595]: [17595] [e] [-4Bjs_dgJRr1] DBD::Pg::st execute failed: ERROR:  invalid input syntax for type boolean: "{}" at /home/lurklur/qem-dashboard/lib/Dashboard/Model/Incidents.pm line 261
...

Acceptance criteria

  • AC1: No more 500 errors

Suggestions

  • Look at dashboard input validation
  • Check for recent changes to the qem-bot and possibly do a rollback
Actions
Copy link

Also available in: Atom PDF