[Qa-jenkins-scm] Build failed in Jenkins: reproducible_html_indexes #4332

[jenkins at jenkins.debian.net]

See <https://jenkins.debian.net/job/reproducible_html_indexes/4332/>

------------------------------------------
Started by user Holger Levsen
Building in workspace <https://jenkins.debian.net/job/reproducible_html_indexes/ws/>
[workspace] $ /bin/sh -xe /tmp/hudson3304620787837910608.sh
+ /srv/jenkins/bin/reproducible_html_indexes.py
INFO: finding out which usertagged bugs have been closed or at least have patches
INFO: "Packages in testing/amd64 tested in the last 24h for build reproducibility" now available at https://reproducible.debian.net/testing/amd64/index_last_24h.html
INFO: "Packages in testing/amd64 where the sources failed to download" now available at https://reproducible.debian.net/testing/amd64/index_404.html
INFO: "Packages in testing/amd64 which failed to build from source" now available at https://reproducible.debian.net/testing/amd64/index_FTBFS.html
INFO: "Packages in testing/amd64 which have been blacklisted" now available at https://reproducible.debian.net/testing/amd64/index_blacklisted.html
INFO: "Packages in testing/amd64 which failed to build reproducibly" now available at https://reproducible.debian.net/testing/amd64/index_FTBR.html
INFO: "Packages in testing/amd64 which built reproducibly" now available at https://reproducible.debian.net/testing/amd64/index_reproducible.html
INFO: "Packages in testing/amd64 tested in the last 48h for build reproducibility" now available at https://reproducible.debian.net/testing/amd64/index_last_48h.html
CRITICAL: Error execting this query:
CRITICAL: SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id COALESCE JOIN notes as n ON n.package_id=r.package_id WHERE s.suite="testing" AND s.architecture="amd64" AND r.status = "FTBFS" AND NOT (n.issues LIKE "%timestamps_from_cpp_macros%" OR n.issues LIKE "%ftbfs_werror_equals%" OR n.issues LIKE "%ocaml_configure_not_as_root%") ORDER BY s.name
CRITICAL: A query failed: SELECT s.name FROM results AS r JOIN sources AS s ON r.package_id=s.id COALESCE JOIN notes as n ON n.package_id=r.package_id WHERE s.suite="{suite}" AND s.architecture="{arch}" AND r.status = "FTBFS" AND NOT (n.issues LIKE "%timestamps_from_cpp_macros%" OR n.issues LIKE "%ftbfs_werror_equals%" OR n.issues LIKE "%ocaml_configure_not_as_root%") ORDER BY s.name
















Traceback (most recent call last):
  File "/srv/jenkins/bin/reproducible_html_indexes.py", line 383, in <module>
    build_page(page, suite, arch)
  File "/srv/jenkins/bin/reproducible_html_indexes.py", line 362, in build_page
    html1, footnote1 = build_page_section(page, section, suite, arch)
  File "/srv/jenkins/bin/reproducible_html_indexes.py", line 294, in build_page_section
    rows = query_db(queries[section['query']].format(suite=suite, arch=arch))
  File "/srv/jenkins/bin/reproducible_common.py", line 241, in query_db
    cursor.execute(query)
sqlite3.OperationalError: near "COALESCE": syntax error
Build step 'Execute shell' marked build as failure