-
Story
-
Resolution: Unresolved
-
Major
-
None
-
None
-
None
-
Documentation (Ref Guide, User Guide, etc.)
-
When using Oracle as the JDBC message store, the following error will occur with the default JDBC store configuration when <page-store-table-name>PAGE_STORE_TABLE</page-store-table-name> is set:
2020-02-03 09:25:44,318 INFO [org.apache.activemq.artemis.core.server] AMQ221000: live Message Broker is starting with configuration Broker Configuration (clustered=false,jdbcDriverClassName=oracle.jdbc.driver.OracleDriver,jdbcConnectionUrl=jdbc:oracle:thin:@oracle-12cr2.hosts.mwqe.eng.bos.redhat.com:1521:dballo,messageTableName=MESSAGE_TABLE,bindingsTableName=BINDINGS_TABLE,largeMessageTableName=LARGE_MESSAGES_TABLE,pageStoreTableName=PAGE_STORE_TABLE,) 2020-02-03 09:25:46,327 ERROR [org.apache.activemq.artemis.core.server] AMQ224000: Failure in initialisation: java.lang.IllegalStateException: The maximum name size for the page store table prefix is 10 characters: THE PAGING STORE CAN'T START at org.apache.activemq.artemis.core.paging.impl.PagingStoreFactoryDatabase.start(PagingStoreFactoryDatabase.java:138) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.core.paging.impl.PagingStoreFactoryDatabase.<init>(PagingStoreFactoryDatabase.java:130) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.getPagingStoreFactory(ActiveMQServerImpl.java:2606) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.createPagingManager(ActiveMQServerImpl.java:2600) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.initialisePart1(ActiveMQServerImpl.java:2776) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.core.server.impl.LiveOnlyActivation.run(LiveOnlyActivation.java:64) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.internalStart(ActiveMQServerImpl.java:600) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.core.server.impl.ActiveMQServerImpl.start(ActiveMQServerImpl.java:527) [artemis-server-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.integration.FileBroker.start(FileBroker.java:70) [artemis-cli-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.cli.commands.Run.execute(Run.java:85) [artemis-cli-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.cli.Artemis.internalExecute(Artemis.java:150) [artemis-cli-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:98) [artemis-cli-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.cli.Artemis.execute(Artemis.java:125) [artemis-cli-2.10.0.redhat-00004.jar:2.10.0.redhat-00004] at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_201] at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_201] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_201] at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_201] at org.apache.activemq.artemis.boot.Artemis.execute(Artemis.java:129) [artemis-boot.jar:2.10.0.redhat-00004] at org.apache.activemq.artemis.boot.Artemis.main(Artemis.java:49) [artemis-boot.jar:2.10.0.redhat-00004]
To workaround this issue the page-store-table-name should be shorten to meet Oracle's restriction:
i.e.
<page-store-table-name>PAGE_STORE</page-store-table-name>
- relates to
-
ENTMQBR-608 JDBC store - ORA-00972: identifier is too long
-
- Closed
-
