Uploaded image for project: 'JS - JobScheduler'
  1. JS - JobScheduler
  2. JS-781

"SCHEDULER-451 Database check failed, database is not useable" for Postgres if the parameter "standard_conforming_strings" is turned on

    XMLWordPrintable

    Details

      Description

      General

      • Since Postgres Version 9.1 the parameter standard_conforming_strings is turn on.
      • This controls whether ordinary string literals ('...') treat backslashes literally, as specified in the SQL standard. The JobScheduler may check this parameter to determine how string literals will be processed. The presence of this parameter can also be taken as an indication that the escape string syntax (E'...') is supported. Escape string syntax should be used if the JobScheduler desires backslashes to be treated as escape characters.
      • See also http://www.depesz.com/index.php/2010/07/21/waiting-for-9-1-standard_conforming_strings-on/

      Current Situation

      • The JobScheduler has a special implementation to escape strings for Postgres because Postgres < 9.1 has a non SQL standard default behavior.
      • This default behavior in Postgres has change with version 9.1. so that it is necessary to set the Postgres system variable standard_conforming_strings=off
        see https://kb.sos-berlin.com/x/BYM3

      Desired behavior

      • The JobScheduler use for Postgres the SQL standard escaping.

      Note

      • All users which use the JobScheduler since above "fix version" with Postgres has to (re)set the Postgres system variable standard_conforming_strings=on.
      • use show standard_conforming_strings; to check the setting.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                jz Joacim Zschimmer
                Reporter:
                oh Oliver Haufe
                Approver:
                Oliver Haufe
              • Votes:
                0 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - 3 days
                  3d
                  Remaining:
                  Remaining Estimate - 3 days
                  3d
                  Logged:
                  Time Spent - Not Specified
                  Not Specified