Page MenuHomeSoftware Heritage

cassandra: Simplify SELECT statement formatting
ClosedPublic

Authored by vlorentz on Aug 4 2022, 1:51 PM.

Details

Test Plan

Failures of release_add_arbitrary will be solved by D8184; failures of directory_add_arbitrary are unrelated

Diff Detail

Repository
rDSTO Storage manager
Branch
master
Lint
No Linters Available
Unit
No Unit Test Coverage
Build Status
Buildable 30608
Build 47857: Phabricator diff pipeline on jenkinsJenkins console · Jenkins
Build 47856: arc lint + arc unit

Unit TestsFailed

TimeTest
1,595 msJenkins > .tox.py3.lib.python3.7.site-packages.swh.storage.tests.test_postgresql.TestStorage::test_directory_add_get_arbitrary
self = <hypothesis.core.StateForActualGivenExecution object at 0x7fc0ad356b70> data = ConjectureData(INTERESTING, 209 bytes, frozen)
2,795 msJenkins > .tox.py3.lib.python3.7.site-packages.swh.storage.tests.test_postgresql.TestStorage::test_release_add_get_arbitrary
self = <swh.storage.tests.test_postgresql.TestStorage object at 0x7fc30cc705c0> swh_storage = <swh.storage.postgresql.storage.Storage object at 0x7fc0ad3b4630>
114,274 msJenkins > .tox.py3.lib.python3.7.site-packages.swh.storage.tests.test_postgresql_flavor_mirror.TestStorage::test_directory_add_get_arbitrary
self = <swh.storage.tests.test_postgresql.TestStorage object at 0x7fc30c67d828> swh_storage = <swh.storage.postgresql.storage.Storage object at 0x7fc0e2616550>
2,601 msJenkins > .tox.py3.lib.python3.7.site-packages.swh.storage.tests.test_postgresql_flavor_mirror.TestStorage::test_release_add_get_arbitrary
self = <swh.storage.tests.test_postgresql.TestStorage object at 0x7fc30c3df7b8> swh_storage = <swh.storage.postgresql.storage.Storage object at 0x7fc0af668e10>
2,006 msJenkins > .tox.py3.lib.python3.7.site-packages.swh.storage.tests.test_postgresql_flavor_readreplica.TestStorage::test_directory_add_get_arbitrary
self = <swh.storage.tests.test_postgresql.TestStorage object at 0x7fc30c5c3048> swh_storage = <swh.storage.postgresql.storage.Storage object at 0x7fc11e76dac8>
View Full Test Results (7 Failed · 1,604 Passed · 44 Skipped)

Event Timeline

Build has FAILED

Patch application report for D8182 (id=29541)

Rebasing onto 2205fa6e1f...

Current branch diff-target is up to date.
Changes applied before test
commit 0aff46189a13e9f1d1d65418faa99ac1dc33d461
Author: Valentin Lorentz <vlorentz@softwareheritage.org>
Date:   Thu Aug 4 13:51:16 2022 +0200

    cassandra: Simplify SELECT statement formatting

Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1638/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1638/console

Harbormaster returned this revision to the author for changes because remote builds failed.Aug 4 2022, 2:06 PM
Harbormaster failed remote builds in B30608: Diff 29541!

Build has FAILED

Patch application report for D8182 (id=29541)

Rebasing onto 2205fa6e1f...

Current branch diff-target is up to date.
Changes applied before test
commit 0aff46189a13e9f1d1d65418faa99ac1dc33d461
Author: Valentin Lorentz <vlorentz@softwareheritage.org>
Date:   Thu Aug 4 13:51:16 2022 +0200

    cassandra: Simplify SELECT statement formatting

Link to build: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1640/
See console output for more information: https://jenkins.softwareheritage.org/job/DSTO/job/tests-on-diff/1640/console

vlorentz edited the test plan for this revision. (Show Details)
ardumont added a subscriber: ardumont.

lgtm

one question inline.

swh/storage/cassandra/cql.py
1172

you sure on this one?
It used to query the snapshot table.

This revision is now accepted and ready to land.Aug 4 2022, 5:30 PM
swh/storage/cassandra/cql.py
1172

it used to query the snapshot field of the origin_visit_status table, and still does

This revision was landed with ongoing or failed builds.Aug 5 2022, 10:06 AM
This revision was automatically updated to reflect the committed changes.