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

              jz Joacim Zschimmer
              oh Oliver Haufe
              Oliver Haufe 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