Menu ▾ ▴

#769 nightly_job.py: Rpt 296: error in Python Program: Query stops

v1.0 (example)
closed-fixed
Ahasuerus
None
5
2021-04-11
2021-04-11
Klaus Elsbernd
No

Sorry, had accidentally created this bug-report in the wrong (features)-queue:
I tried to install isfdb on OpenIndiana with Maria-DB; Report 296:
Message: ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')\n and not exists(select 1 from primary_verifications pv\n ...' at line 3")
It seems, that in_clause variable is empty. I added some print lines to read the variable query, so line numbers are somewhat bigger.
Error attached.
Note: Since the crontab job dumps output to /dev/null, maybe no one has seen the error message

1 Attachments
Pyhton-Nightyl_job-Report 296-SQL-failure.html

Discussion

  • Ahasuerus

    Ahasuerus - 2021-04-11
    • summary: nightly_job.py: Rpt 296: error in Python Program: Query stops on MariaDB --> nightly_job.py: Rpt 296: error in Python Program: Query stops
    • Description has changed:

    Diff:

    --- old
+++ new
@@ -1,6 +1,6 @@
 Sorry, had accidentally created this bug-report in the wrong (features)-queue:
 I tried to install isfdb on OpenIndiana with Maria-DB; Report 296:
 Message: ProgrammingError: (1064, "You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ')\n and not exists(select 1 from primary_verifications pv\n ...' at line 3")
-It seems, that in_clause variable is empty. I added some print lines to read the variable query, so line numbers ore somewhat bigger.
+It seems, that in_clause variable is empty. I added some print lines to read the variable query, so line numbers are somewhat bigger.
 Error attached.
 Note: Since the crontab job dumps output to /dev/null, maybe no one has seen the error message
    • status: open --> closed-fixed
    • assigned_to: Ahasuerus
     

  • Ahasuerus

    Ahasuerus - 2021-04-11

    This was a new bug introduced in FR 1405/SVN 610. The change worked properly on the live system, but it errored out when run against the publicly available version of the database, which doesn't include the "submissions" table.

    Fixed in nightly/nightly_job.py, installed in SVN 617 on 2021-04-11. Closing the Bug report.

     

Anonymous
Anonymous

Add attachments
Cancel





MongoDB Logo MongoDB