New issue
Advanced search Search tips

Issue 877342 link

Starred by 1 user

Issue metadata

Status: Duplicate
Merged: issue 890651
Owner: ----
Closed: Oct 1
Cc:
Components:
EstimatedDays: ----
NextAction: ----
OS: Chrome
Pri: 3
Type: Bug



Sign in to add a comment

master-paladin: SQL error in CommitQueueHandleChanges if all builds are cancelled?

Project Member Reported by tfiga@chromium.org, Aug 24

Issue description

https://cros-goldeneye.corp.google.com/chromeos/healthmonitoring/buildDetails?id=2874098

CommitQueueHandleChanges failed

ProgrammingError: (ProgrammingError) (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ')' at line 1") 'SELECT * from hwTestResultTable WHERE build_id IN ()' ()
 
Labels: Hotlist-GoodFirstBug OS-Chrome
Status: Available (was: Untriaged)
Looks like a good starter bug.
Can I take this issue if there is no one working on this?
Sure!
Project Member

Comment 4 by bugdroid1@chromium.org, Sep 8

The following revision refers to this bug:
  https://chromium.googlesource.com/chromiumos/chromite/+/6c8c214ab77ea82ce403db49fba20a719b936ea8

commit 6c8c214ab77ea82ce403db49fba20a719b936ea8
Author: Jongheon Kim <sapzape@gmail.com>
Date: Sat Sep 08 10:23:00 2018

Add syntax error exception for empty values

This patch is add exception for empty value when sql execute in
GetHWTestResultsForBuilds

Bug:  877342 
Change-Id: Ibd9a9c04bbefb55f840a5299e3d8bd8d523d787e
Reviewed-on: https://chromium-review.googlesource.com/1190383
Commit-Ready: Jongheon Kim <sapzape@gmail.com>
Tested-by: Jongheon Kim <sapzape@gmail.com>
Reviewed-by: Mike Frysinger <vapier@chromium.org>

[modify] https://crrev.com/6c8c214ab77ea82ce403db49fba20a719b936ea8/lib/cidb.py
[modify] https://crrev.com/6c8c214ab77ea82ce403db49fba20a719b936ea8/lib/cidb_integration_test.py

Mergedinto: 890651
Status: Duplicate (was: Available)
IIUC, this is still happening, and people are actively working on it on  bug 890651 .

Sign in to add a comment