Uploaded image for project: 'Red Hat OpenShift Data Science'
  1. Red Hat OpenShift Data Science
  2. RHODS-9789

Pipeline Server cannot be started when using a custom database with dash in Database name

    XMLWordPrintable

Details

    • Bug
    • Resolution: Won't Do
    • Undefined
    • None
    • RHODS_1.29.0_GA
    • Pipelines
    • False
    • None
    • False
    • Release Notes
    • Testable
    • No
    • No
    • Hide
      == Pipeline servers fail to start if they contain a custom database that includes a dash in its database name or username field.
      When you create a pipeline server that uses a custom database, if the value that you set for the *dbname* field or *username* field includes a dash, the pipeline server fails to start.

      *Workaround:* Edit the pipeline server to omit the dash from the affected fields.
      Show
      == Pipeline servers fail to start if they contain a custom database that includes a dash in its database name or username field. When you create a pipeline server that uses a custom database, if the value that you set for the *dbname* field or *username* field includes a dash, the pipeline server fails to start. *Workaround:* Edit the pipeline server to omit the dash from the affected fields.
    • Known Issue
    • No
    • Pending
    • None

    Description

      Description of problem:

      When creating a Pipeline Server using a custom database, if the fields Database (dbname) or Username contain a dash (e.g. my-test-database) the Pipeline Server fails to start.

      Steps to Reproduce

      1. Create a Data Science Project
      2. Configure a Data Connection with credentials for a s3 bucket
      3. Create a pipeline server, selecting the previous data connection,  Show advanced database options and select Connect to external MySQL database
      4. Fill all fields with the database info. In Database, provide a database name with a dash (e.g. my-test-database)
      5. Click on Configure
      6. Wait until an error message is shown: Pipeline server failed

      Expected results:

      It seems that mariadb/msql lets you create identifiers using unquoted characters (they don't allow the dash and other special characters) and also using quoted characters.  RHODS should allow the same identifiers. There is more info in this document: https://mariadb.com/kb/en/identifier-names/

       

      Reproducibility (Always/Intermittent/Only Once):

      Always

      Build Details:

      RHODS 1.29

      Workaround:

      Rename the database name and/or username to use only characters allowed for unquoted identifiers: https://mariadb.com/kb/en/identifier-names/

      Attachments

        Activity

          People

            Unassigned Unassigned
            rhn-support-jgarciao Jorge Garcia Oncins
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: