|
Home > Archive > WebSphere Portal Server > April 2005 > wps5022 express - logs full of exceptions like this
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
wps5022 express - logs full of exceptions like this
|
|
| Jouni Rajala 2005-04-05, 7:54 am |
| Portal server installs ok and startsup correctly. After few days
of usage our logs start to show lots of following exceptions.
Each click on page causes multiple of these.
Portal seems to work ok however. It is just that it generates
huge amounts of log and that slows system down.
[4/5/05 11:19:15:156 EEST] 53bf494d DataSourcePro W CONM7002W: Could not
find the property user on class com.ibm.db2j.jdbc.DB2jXADataSource
[4/5/05 11:19:15:156 EEST] 53bf494d DataSourcePro W CONM7002W: Could not
find the property password on class com.ibm.db2j.jdbc.DB2jXADataSource
[4/5/05 11:19:15:156 EEST] 53bf494d CMXAResourceF W WTRN0005W: An
exception occured while creating an XAConnection and XAResource. The
exception stack trace follows: SQL Exception: Failed to start database
'h:/WEBSPH~1/PORTAL~1/cloudscape/wps50', see the next exception for details.
at db2j.s.h.tq_(Unknown Source)(Inlined Compiled Code)
at db2j.s.h.newCloudscapeSQLException(Unknown Source)(Inlined Compiled
Code)
at db2j.s.h.generateCsSQLException(Unknown Source)(Inlined Compiled Code)
at db2j.s.c._eo(Unknown Source)(Compiled Code)
at db2j.s.c.<init>(Unknown Source)(Compiled Code)
at db2j.i.c.<init>(Unknown Source)(Inlined Compiled Code)
at db2j.i.b.getNewLocalConnection(Unknown Source)(Compiled Code)
at db2j.s.n.connect(Unknown Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnectionViaDriver(Unknown
Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnection(Unknown
Source)(Inlined Compiled Code)
at com.ibm.db2j.jdbc.DB2jXADataSource.setupResourceAdapter(Unknown
Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnectionWork(Unknown
Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnection(Unknown Source)
at
com.ibm.ejs.cm.CMXAResourceFactory.getXAResource(CMXAResourceFactory.java:72)
at
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.reconnectRM(JTAXAResourceImpl.java(Compiled
Code))
at
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.commit(JTAXAResourceImpl.java(Compiled
Code))
at
com.ibm.ejs.jts.jts.ResourceVector.deliverOutcomeWork(ResourceVector.java(Compiled
Code))
at
com.ibm.ejs.jts.jts.ResourceVector.deliverOutcome(ResourceVector.java:783)
at com.ibm.ejs.jts.jts.ResourceVector.access$200(ResourceVector.java:194)
at
com.ibm.ejs.jts.jts.ResourceVector$OutcomeDeliveryThread.run(ResourceVector.java:1199)
---- Begin backtrace for Nested Throwables
ERROR XSDB6: Another instance of Cloudscape may have already booted the
database H:\WebSphere\PortalServer\cloudscape\wps
50.
at db2j.bq.b.newException(Unknown Source)(Inlined Compiled Code)
at db2j.g.t._d3(Unknown Source)(Compiled Code)
at db2j.g.m.run(Unknown Source)(Compiled Code)
at java.security.AccessController.doPrivileged(Native Method)
at db2j.g.m._d3(Unknown Source)(Compiled Code)
at db2j.g.t.boot(Unknown Source)(Compiled Code)
at db2j.g.g.boot(Unknown Source)(Compiled Code)
at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
at db2j.ck.a.startModule(Unknown Source)(Compiled Code)
at db2j.cd.h.boot(Unknown Source)(Compiled Code)
at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
at db2j.ck.a.startModule(Unknown Source)(Compiled Code)
at db2j.aw.b.boot(Unknown Source)(Compiled Code)
at db2j.ck.a._vf(Unknown Source)(Inlined Compiled Code)
at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
at db2j.ck.a.startModule(Unknown Source)(Compiled Code)
at db2j.ct.b.boot(Unknown Source)(Compiled Code)
at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
at db2j.ck.a.bootService(Unknown Source)(Compiled Code)
at db2j.ck.a.startProviderService(Unknown Source)(Inlined Compiled Code)
at db2j.ck.a.findProviderAndStartService(Unknown Source)(Compiled Code)
at db2j.ck.a.startPersistentService(Unknown Source)(Inlined Compiled Code)
at db2j.ck.a.startPersistentService(Unknown Source)(Compiled Code)
at db2j.s.c._eo(Unknown Source)(Compiled Code)
at db2j.s.c.<init>(Unknown Source)(Compiled Code)
at db2j.i.c.<init>(Unknown Source)(Inlined Compiled Code)
at db2j.i.b.getNewLocalConnection(Unknown Source)(Compiled Code)
at db2j.s.n.connect(Unknown Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnectionViaDriver(Unknown
Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jDataSource.getConnection(Unknown
Source)(Inlined Compiled Code)
at com.ibm.db2j.jdbc.DB2jXADataSource.setupResourceAdapter(Unknown
Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnectionWork(Unknown
Source)(Compiled Code)
at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnection(Unknown Source)
at
com.ibm.ejs.cm.CMXAResourceFactory.getXAResource(CMXAResourceFactory.java:72)
at
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.reconnectRM(JTAXAResourceImpl.java(Compiled
Code))
at
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.commit(JTAXAResourceImpl.java(Compiled
Code))
at
com.ibm.ejs.jts.jts.ResourceVector.deliverOutcomeWork(ResourceVector.java(Compiled
Code))
at
com.ibm.ejs.jts.jts.ResourceVector.deliverOutcome(ResourceVector.java:783)
at com.ibm.ejs.jts.jts.ResourceVector.access$200(ResourceVector.java:194)
at
com.ibm.ejs.jts.jts.ResourceVector$OutcomeDeliveryThread.run(ResourceVector.java:1199)
--
Jouni Rajala
| |
| George Niece 2005-04-05, 5:54 pm |
| Are you actually running in production on Cloudscape? Holy smokes are you
brave.
This looks like you are having multiple connections to trying to take over
the database
and kicking out those error messages. cloudscape only allows one
application to connect
at a time. So for instance you cannot be in interactive sql to a cloudscape
db that is currently running a J2EE application like portal.
You might try changing to the non XA datasource, I did not think that was
the default, or are you doing some kind of two phase commit in your
implementation?
Regards,
geo
"Jouni Rajala" <jouni.rajala@systeemiratkaisu.fi> wrote in message
news:d2tj9l$738a$1@news.boulder.ibm.com...
> Portal server installs ok and startsup correctly. After few days
> of usage our logs start to show lots of following exceptions.
> Each click on page causes multiple of these.
>
> Portal seems to work ok however. It is just that it generates
> huge amounts of log and that slows system down.
>
>
>
> [4/5/05 11:19:15:156 EEST] 53bf494d DataSourcePro W CONM7002W: Could not
> find the property user on class com.ibm.db2j.jdbc.DB2jXADataSource
> [4/5/05 11:19:15:156 EEST] 53bf494d DataSourcePro W CONM7002W: Could not
> find the property password on class com.ibm.db2j.jdbc.DB2jXADataSource
> [4/5/05 11:19:15:156 EEST] 53bf494d CMXAResourceF W WTRN0005W: An
> exception occured while creating an XAConnection and XAResource. The
> exception stack trace follows: SQL Exception: Failed to start database
> 'h:/WEBSPH~1/PORTAL~1/cloudscape/wps50', see the next exception for
details.
> at db2j.s.h.tq_(Unknown Source)(Inlined Compiled Code)
> at db2j.s.h.newCloudscapeSQLException(Unknown Source)(Inlined Compiled
> Code)
> at db2j.s.h.generateCsSQLException(Unknown Source)(Inlined Compiled Code)
> at db2j.s.c._eo(Unknown Source)(Compiled Code)
> at db2j.s.c.<init>(Unknown Source)(Compiled Code)
> at db2j.i.c.<init>(Unknown Source)(Inlined Compiled Code)
> at db2j.i.b.getNewLocalConnection(Unknown Source)(Compiled Code)
> at db2j.s.n.connect(Unknown Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jDataSource.getConnectionViaDriver(Unknown
> Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jDataSource.getConnection(Unknown
> Source)(Inlined Compiled Code)
> at com.ibm.db2j.jdbc.DB2jXADataSource.setupResourceAdapter(Unknown
> Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnectionWork(Unknown
> Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnection(Unknown Source)
> at
>
com.ibm.ejs.cm.CMXAResourceFactory.getXAResource(CMXAResourceFactory.java:72
)
> at
>
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.reconnectRM(JTAXAResourceImpl
..java(Compiled
> Code))
> at
>
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.commit(JTAXAResourceImpl.java
(Compiled
> Code))
> at
>
com.ibm.ejs.jts.jts.ResourceVector.deliverOutcomeWork(ResourceVector.java(Co
mpiled
> Code))
> at
> com.ibm.ejs.jts.jts.ResourceVector.deliverOutcome(ResourceVector.java:783)
> at com.ibm.ejs.jts.jts.ResourceVector.access$200(ResourceVector.java:194)
> at
>
com.ibm.ejs.jts.jts.ResourceVector$OutcomeDeliveryThread.run(ResourceVector.
java:1199)
> ---- Begin backtrace for Nested Throwables
> ERROR XSDB6: Another instance of Cloudscape may have already booted the
> database H:\WebSphere\PortalServer\cloudscape\wps
50.
> at db2j.bq.b.newException(Unknown Source)(Inlined Compiled Code)
> at db2j.g.t._d3(Unknown Source)(Compiled Code)
> at db2j.g.m.run(Unknown Source)(Compiled Code)
> at java.security.AccessController.doPrivileged(Native Method)
> at db2j.g.m._d3(Unknown Source)(Compiled Code)
> at db2j.g.t.boot(Unknown Source)(Compiled Code)
> at db2j.g.g.boot(Unknown Source)(Compiled Code)
> at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
> at db2j.ck.a.startModule(Unknown Source)(Compiled Code)
> at db2j.cd.h.boot(Unknown Source)(Compiled Code)
> at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
> at db2j.ck.a.startModule(Unknown Source)(Compiled Code)
> at db2j.aw.b.boot(Unknown Source)(Compiled Code)
> at db2j.ck.a._vf(Unknown Source)(Inlined Compiled Code)
> at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
> at db2j.ck.a.startModule(Unknown Source)(Compiled Code)
> at db2j.ct.b.boot(Unknown Source)(Compiled Code)
> at db2j.ck.c.bootModule(Unknown Source)(Compiled Code)
> at db2j.ck.a.bootService(Unknown Source)(Compiled Code)
> at db2j.ck.a.startProviderService(Unknown Source)(Inlined Compiled Code)
> at db2j.ck.a.findProviderAndStartService(Unknown Source)(Compiled Code)
> at db2j.ck.a.startPersistentService(Unknown Source)(Inlined Compiled Code)
> at db2j.ck.a.startPersistentService(Unknown Source)(Compiled Code)
> at db2j.s.c._eo(Unknown Source)(Compiled Code)
> at db2j.s.c.<init>(Unknown Source)(Compiled Code)
> at db2j.i.c.<init>(Unknown Source)(Inlined Compiled Code)
> at db2j.i.b.getNewLocalConnection(Unknown Source)(Compiled Code)
> at db2j.s.n.connect(Unknown Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jDataSource.getConnectionViaDriver(Unknown
> Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jDataSource.getConnection(Unknown
> Source)(Inlined Compiled Code)
> at com.ibm.db2j.jdbc.DB2jXADataSource.setupResourceAdapter(Unknown
> Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnectionWork(Unknown
> Source)(Compiled Code)
> at com.ibm.db2j.jdbc.DB2jXADataSource.getXAConnection(Unknown Source)
> at
>
com.ibm.ejs.cm.CMXAResourceFactory.getXAResource(CMXAResourceFactory.java:72
)
> at
>
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.reconnectRM(JTAXAResourceImpl
..java(Compiled
> Code))
> at
>
com.ibm.ejs.jts.jta.portable.JTAXAResourceImpl.commit(JTAXAResourceImpl.java
(Compiled
> Code))
> at
>
com.ibm.ejs.jts.jts.ResourceVector.deliverOutcomeWork(ResourceVector.java(Co
mpiled
> Code))
> at
> com.ibm.ejs.jts.jts.ResourceVector.deliverOutcome(ResourceVector.java:783)
> at com.ibm.ejs.jts.jts.ResourceVector.access$200(ResourceVector.java:194)
> at
>
com.ibm.ejs.jts.jts.ResourceVector$OutcomeDeliveryThread.run(ResourceVector.
java:1199)
>
>
> --
> Jouni Rajala
| |
| Jouni Rajala 2005-04-06, 7:53 am |
| > Are you actually running in production on Cloudscape? Holy smokes are you
> brave.
We tried to move database to iSeries DB2 but script IBM provided fails
miserably. It is full of sql syntax problems.
> This looks like you are having multiple connections to trying to take over
> the database
> and kicking out those error messages. cloudscape only allows one
> application to connect
> at a time. So for instance you cannot be in interactive sql to a cloudscape
> db that is currently running a J2EE application like portal.
There is only portal running and using this database.
> You might try changing to the non XA datasource, I did not think that was
> the default, or are you doing some kind of two phase commit in your
> implementation?
It is default settings out of the box installation.
--
Jouni Rajala
|
|
|
|
|