New issue
Advanced search Search tips
Note: Color blocks (like or ) mean that a user may not be available. Tooltip shows the reason.

Issue 848596 link

Starred by 1 user

Issue metadata

Status: Started
Owner:
Last visit > 30 days ago
Cc:
Components:
EstimatedDays: ----
NextAction: ----
OS: Chrome
Pri: 1
Type: Bug



Sign in to add a comment

Wmatrix is not working at ToT

Project Member Reported by haddowk@chromium.org, Jun 1 2018

Issue description


Data is not being imported into wmatrix

Despite running multiple test suites there is no data in Wmatrix.
 
Owner: mattmallett@chromium.org
Status: Assigned (was: Available)
Status: Started (was: Assigned)
moblab-whining-update-db failing with following error on ToT

Updating wmatrix database (Fri Jun  1 14:18:49 PDT 2018).
ERROR:root:ts_mon monitoring is disabled because the endpoint provided is invalid or not supported:
Traceback (most recent call last):
  File "/whining/src/backend/update_rawdb.py", line 37, in <module>
    init_days=options.init_days)
  File "/whining/src/backend/update_lib.py", line 109, in wrapped_query
    idxs = dbpump.get_starting_idxs_for_init(src_db, init_days)
  File "/whining/src/backend/dbpump.py", line 351, in get_starting_idxs_for_init
    d['TEST_IDX'] = src_db.run_query_scalar(sql)
  File "/whining/src/models/db_interface.py", line 416, in run_query_scalar
    with self.run_query(qry, use_dict=False) as cursor:
  File "/whining/src/models/db_interface.py", line 380, in run_query
    cursor.execute(sql)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'None' in 'where clause'")
ERROR:root:ts_mon monitoring is disabled because the endpoint provided is invalid or not supported:
Traceback (most recent call last):
  File "/whining/src/backend/update_wmdb.py", line 37, in <module>
    init_days=options.init_days)
  File "/whining/src/backend/update_lib.py", line 109, in wrapped_query
    idxs = dbpump.get_starting_idxs_for_init(src_db, init_days)
  File "/whining/src/backend/dbpump.py", line 351, in get_starting_idxs_for_init
    d['TEST_IDX'] = src_db.run_query_scalar(sql)
  File "/whining/src/models/db_interface.py", line 416, in run_query_scalar
    with self.run_query(qry, use_dict=False) as cursor:
  File "/whining/src/models/db_interface.py", line 380, in run_query
    cursor.execute(sql)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/cursors.py", line 205, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib64/python2.7/site-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
_mysql_exceptions.OperationalError: (1054, "Unknown column 'None' in 'where clause'")
Project Member

Comment 3 by bugdroid1@chromium.org, Aug 7

The following revision refers to this bug:
  https://chromium.googlesource.com/chromiumos/overlays/board-overlays/+/6e02c70180c6137915184e0653d814826af9d24f

commit 6e02c70180c6137915184e0653d814826af9d24f
Author: Keith Haddow <haddowk@chromium.org>
Date: Tue Aug 07 05:11:36 2018

[moblab] Fix issues in the wmatrix uploader

It seems like the uploader is still failing, remove the reasons
the script might stop/not respawn and increase the frequency
to 5 mins

BUG=chromium:848596
TEST=None

Change-Id: I4f68a5c9e28b89de684d1874d86fd186b3c5d492
Reviewed-on: https://chromium-review.googlesource.com/1164074
Commit-Ready: Keith Haddow <haddowk@chromium.org>
Tested-by: Keith Haddow <haddowk@chromium.org>
Reviewed-by: Keith Haddow <haddowk@chromium.org>
Reviewed-by: Matt Mallett <mattmallett@chromium.org>

[modify] https://crrev.com/6e02c70180c6137915184e0653d814826af9d24f/project-moblab/chromeos-base/chromeos-bsp-moblab/files/init/moblab-whining-update-db.conf
[rename] https://crrev.com/6e02c70180c6137915184e0653d814826af9d24f/project-moblab/chromeos-base/chromeos-bsp-moblab/chromeos-bsp-moblab-0.0.1-r42.ebuild

Project Member

Comment 4 by bugdroid1@chromium.org, Aug 8

Labels: merge-merged-release-R68-10718.B
The following revision refers to this bug:
  https://chromium.googlesource.com/chromiumos/overlays/board-overlays/+/e6913b6e4dfea8b54a8b65b95cbb0d1b3bcc7c46

commit e6913b6e4dfea8b54a8b65b95cbb0d1b3bcc7c46
Author: Keith Haddow <haddowk@chromium.org>
Date: Wed Aug 08 14:49:19 2018

[moblab] Fix issues in the wmatrix uploader

It seems like the uploader is still failing, remove the reasons
the script might stop/not respawn and increase the frequency
to 5 mins

BUG=chromium:848596
TEST=None

Change-Id: I4f68a5c9e28b89de684d1874d86fd186b3c5d492
Reviewed-on: https://chromium-review.googlesource.com/1164074
Commit-Ready: Keith Haddow <haddowk@chromium.org>
Tested-by: Keith Haddow <haddowk@chromium.org>
Reviewed-by: Keith Haddow <haddowk@chromium.org>
Reviewed-by: Matt Mallett <mattmallett@chromium.org>
(cherry picked from commit 6e02c70180c6137915184e0653d814826af9d24f)
Reviewed-on: https://chromium-review.googlesource.com/1165525
Trybot-Ready: Keith Haddow <haddowk@chromium.org>
Commit-Queue: Keith Haddow <haddowk@chromium.org>

[modify] https://crrev.com/e6913b6e4dfea8b54a8b65b95cbb0d1b3bcc7c46/project-moblab/chromeos-base/chromeos-bsp-moblab/files/init/moblab-whining-update-db.conf
[add] https://crrev.com/e6913b6e4dfea8b54a8b65b95cbb0d1b3bcc7c46/project-moblab/chromeos-base/chromeos-bsp-moblab/chromeos-bsp-moblab-0.0.1-r42.ebuild

Project Member

Comment 5 by bugdroid1@chromium.org, Aug 8

Labels: merge-merged-release-R69-10895.B
The following revision refers to this bug:
  https://chromium.googlesource.com/chromiumos/overlays/board-overlays/+/1f0279613260d15ed48220f77a8495aecdfb6eef

commit 1f0279613260d15ed48220f77a8495aecdfb6eef
Author: Keith Haddow <haddowk@chromium.org>
Date: Wed Aug 08 18:50:32 2018

[moblab] Fix issues in the wmatrix uploader

It seems like the uploader is still failing, remove the reasons
the script might stop/not respawn and increase the frequency
to 5 mins

BUG=chromium:848596
TEST=None

Change-Id: I4f68a5c9e28b89de684d1874d86fd186b3c5d492
Reviewed-on: https://chromium-review.googlesource.com/1164074
Commit-Ready: Keith Haddow <haddowk@chromium.org>
Tested-by: Keith Haddow <haddowk@chromium.org>
Reviewed-by: Keith Haddow <haddowk@chromium.org>
Reviewed-by: Matt Mallett <mattmallett@chromium.org>
(cherry picked from commit 6e02c70180c6137915184e0653d814826af9d24f)
Reviewed-on: https://chromium-review.googlesource.com/1165524
Commit-Queue: Keith Haddow <haddowk@chromium.org>
Trybot-Ready: Keith Haddow <haddowk@chromium.org>

[modify] https://crrev.com/1f0279613260d15ed48220f77a8495aecdfb6eef/project-moblab/chromeos-base/chromeos-bsp-moblab/files/init/moblab-whining-update-db.conf
[rename] https://crrev.com/1f0279613260d15ed48220f77a8495aecdfb6eef/project-moblab/chromeos-base/chromeos-bsp-moblab/chromeos-bsp-moblab-0.0.1-r42.ebuild

Sign in to add a comment