Some customer was trying to activate JDBC store,i checked the logs and found this.
<Aug 7, 2013 4:03:23 AM CDT> <Warning> <Store> <BEA-280076> <Database table "WLStore" for store "test" is currently owned by "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866194364]". Trying to wait for ownership.>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280077> <JDBC store "test" in this server is not the owner of database table "WLStore". Unexpected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866214386]", expected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=test!table=WLStore}:random=-1796623192164004707:timestamp=1375866203282]".>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280072> <JDBC store "test" failed to open table "WLStore".
weblogic.store.io.jdbc.JDBCStoreException: [Store:280064]280077 (server="osb_server1" store="test" table="WLStore")
at weblogic.store.io.jdbc.JDBCStoreIO.checkTableOwnership(JDBCStoreIO.java:2621)
at weblogic.store.io.jdbc.JDBCStoreIO.getTableOwnershipLogical(JDBCStoreIO.java:2734)
at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:495)
at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:436)
at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:423)
Truncated. see log file for complete stacktrace>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280061> <The persistent store "test" could not be deployed: weblogic.store.io.jdbc.JDBCStoreException: open failed
weblogic.store.io.jdbc.JDBCStoreException: open failed
Solution:
Please ensure that for each JDBC Store you set the prefix for the store to a unique value for each configured JDBC store table, as mentioned in the URL http://download.oracle.com/docs/cd/E12839_01/web.1111/e13701/store.htm#i1143431. This will ensure that each store has its own table.
<Aug 7, 2013 4:03:23 AM CDT> <Warning> <Store> <BEA-280076> <Database table "WLStore" for store "test" is currently owned by "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866194364]". Trying to wait for ownership.>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280077> <JDBC store "test" in this server is not the owner of database table "WLStore". Unexpected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=AHSOSBJDBCStore!table=WLStore}:random=5697096127807814759:timestamp=1375866214386]", expected current owner is "[name={server=osb_server1!host=140.85.192.10!domain=soa_domain!store=test!table=WLStore}:random=-1796623192164004707:timestamp=1375866203282]".>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280072> <JDBC store "test" failed to open table "WLStore".
weblogic.store.io.jdbc.JDBCStoreException: [Store:280064]280077 (server="osb_server1" store="test" table="WLStore")
at weblogic.store.io.jdbc.JDBCStoreIO.checkTableOwnership(JDBCStoreIO.java:2621)
at weblogic.store.io.jdbc.JDBCStoreIO.getTableOwnershipLogical(JDBCStoreIO.java:2734)
at weblogic.store.io.jdbc.JDBCStoreIO.open(JDBCStoreIO.java:495)
at weblogic.store.internal.PersistentStoreImpl.recoverStoreConnections(PersistentStoreImpl.java:436)
at weblogic.store.internal.PersistentStoreImpl.open(PersistentStoreImpl.java:423)
Truncated. see log file for complete stacktrace>
<Aug 7, 2013 4:03:43 AM CDT> <Error> <Store> <BEA-280061> <The persistent store "test" could not be deployed: weblogic.store.io.jdbc.JDBCStoreException: open failed
weblogic.store.io.jdbc.JDBCStoreException: open failed
Cause:
The cause of this issue is that the database table representing the
store is locked by another JMS server at the same time, as is indicated
by the error message. This setup of using the same underlying database
table to represent more than one JDBC Store is not recommended or
supported.
Please ensure that for each JDBC Store you set the prefix for the store to a unique value for each configured JDBC store table, as mentioned in the URL http://download.oracle.com/docs/cd/E12839_01/web.1111/e13701/store.htm#i1143431. This will ensure that each store has its own table.
No comments:
Post a Comment