Uploaded image for project: 'Cloud Enablement'
  1. Cloud Enablement
  2. CLOUD-4021

Narayana object store table name should not contain dots


    • Icon: Bug Bug
    • Resolution: Done
    • Icon: Major Major
    • EAP74 7.4.1.GA
    • EAP73 7.3.5.GA
    • EAP7

      The '.' cannot be permitted in the database table names used for JDBC object store.

      The EAP OpenShift scripts provides a way to configure the transaction subsystem to work with a JDBC object store. In such case there is configured a database table name where Narayana transaction log is persisted in. The database table name is prefixed with os and then follow-up with value of env variable JBOSS_NODE_NAME[1].
      (JBOSS_NODE_NAME is developed based on the hostname stripped to 23 characters[2]).

      The particular databases restricts how the table can be named. Oracle does not permit hyphens and they are removed[1]. The PostgreSQL consider dots as a delimiter of table name and namespace. The tablename itself works incorrectly when contains dots.

      [1] https://github.com/wildfly/wildfly-cekit-modules/blob/0.18.10/jboss/container/wildfly/launch/datasources/added/launch/tx-datasource.sh#L63
      [2] https://github.com/wildfly/wildfly-cekit-modules/blob/0.18.10/jboss/container/wildfly/launch/os/node-name/added/launch/openshift-node-name.sh

            jfinelli@redhat.com Manuel Finelli
            ochaloup@redhat.com Ondrej Chaloupka (Inactive)
            0 Vote for this issue
            1 Start watching this issue