Uploaded image for project: 'JBoss Enterprise Application Platform'
  1. JBoss Enterprise Application Platform
  2. JBEAP-9732

JDBC store - ORA-00972: identifier is too long

    XMLWordPrintable

Details

    • User Experience
    • Blocks Testing
    • Hide 
      git clone git://git.app.eng.bos.redhat.com/jbossqe/eap-tests-hornetq.git
cd eap-tests-hornetq/scripts/
git checkout f1860bef3e523ad4ef25499554cfb7508f464c53
groovy -DEAP_VERSION=7.1.0.DR17 PrepareServers7.groovy
export WORKSPACE=$PWD
export JBOSS_HOME_1=$WORKSPACE/server1/jboss-eap
export JBOSS_HOME_2=$WORKSPACE/server2/jboss-eap
export JBOSS_HOME_3=$WORKSPACE/server3/jboss-eap
export JBOSS_HOME_4=$WORKSPACE/server4/jboss-eap

cd ../jboss-hornetq-testsuite/

mvn clean test -Dtest=JGroupsClusterTestCase#clusterTestWithNetworkFailures -DfailIfNoTests=false -Deap=7x -Dprepare.param.JDBC_STORE=true -Dprepare.param.DATABASE=oracle12c | tee log
      Show
      git clone git: //git.app.eng.bos.redhat.com/jbossqe/eap-tests-hornetq.git cd eap-tests-hornetq/scripts/ git checkout f1860bef3e523ad4ef25499554cfb7508f464c53 groovy -DEAP_VERSION=7.1.0.DR17 PrepareServers7.groovy export WORKSPACE=$PWD export JBOSS_HOME_1=$WORKSPACE/server1/jboss-eap export JBOSS_HOME_2=$WORKSPACE/server2/jboss-eap export JBOSS_HOME_3=$WORKSPACE/server3/jboss-eap export JBOSS_HOME_4=$WORKSPACE/server4/jboss-eap cd ../jboss-hornetq-testsuite/ mvn clean test -Dtest=JGroupsClusterTestCase#clusterTestWithNetworkFailures -DfailIfNoTests= false -Deap=7x -Dprepare.param.JDBC_STORE= true -Dprepare.param.DATABASE=oracle12c | tee log

    Description

      Artemis generates identifiers for paging tables using pattern TABLE_NAME + GENERATED ID. Oracle database allows to use only identifiers of maximal length of 30 characters. Generated ID is type of long so it can have size up-to 20 characters what means that maximum length of table name can be only 10 characters. Otherwise error [1] may arises.

      This issue is dangerous because it arises after some time and admin is not advised at start of EAP. EAP/Artemis should do some checks at start and at configuration of these parameters.

      [1]

      SQL STATEMENTS:
CREATE TABLE NODE2_PAGE_STORE_TABLE6442455442(ID NUMBER(19) GENERATED BY DEFAULT ON NULL AS IDENTITY, FILENAME VARCHAR(255), EXTENSION VARCHAR(10), DATA BLOB, PRIMARY KEY(ID))
SQL EXCEPTIONS:
SQLState: 42000 ErrorCode: 972 Message: ORA-00972: identifier is too long

      Customer impact: Paging may stop working after some time depending on length of page table name and number of queues.

      Attachments

        Issue Links

          is blocked by

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. JBEAP-10454 Upgrade Artemis 1.5.4.jbossorg-003

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified
          is cloned by

          Bug - A problem that impairs or prevents the functions of the product. ENTMQBR-608 JDBC store - ORA-00972: identifier is too long

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed
          is incorporated by

          Component Upgrade - A task tracking an update to a bundled component or revision of component upstream of the project. JBEAP-10723 Upgrade Artemis 1.5.4.jbossorg-004

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified
          relates to

          Bug - A problem that impairs or prevents the functions of the product. JBEAP-10233 Server does not fail to start when there is an error in Artemis server

          • Major - To be worked after higher priority work items are addressed. When the severity is high and the effort to change it is low to moderate, this term is chosen. Issues in this category likely have an existing workaround but implementation or execution may be non-trivial.
          • Verified

          Activity

            People

              mtaylor1@redhat.com Martyn Taylor (Inactive)
              eduda_jira Erich Duda (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: