Skip to main content

This content is closed to future replies and is no longer being maintained or updated.
Links may no longer function. If you have a similar request, please write a new post.

Question

 Devarajulu Prathapaneni (DevarajPrathapaneni)
Swedbank AB
Solution Architect
Swedbank AB
SE
DevarajPrathapaneni Member since 2020 39 posts
Swedbank AB
Posted: Oct 15, 2018
Last activity: Mar 8, 2019
Posted: 15 Oct 2018 5:20 EDT
Last activity: 8 Mar 2019 11:42 EST
Closed
Solved

Server is hung on runing of recreateindexesforclass utility

Hi All,

We are adding additional columns to index table from work class blob. So We are running recreateindexesforclass utility on production existing data . But is system is hanging for 10 k records also. In log trace we could see issue in recreateindexesforinstance activity step 2.

ThreadMonitor W WSVR0605W: Thread "WebContainer : 4" (xxxxx) has been active for 628772 milliseconds and may be hung. There is/are 1 thread(s) in total in the server that may be hung

We would like to know the possible root cause.

Thanks,

Deva.

***Updated by moderator: Lochan to tag SR to post***

To see attachments, please log in.
Dev/Designer Studio
Support Case Created

Posted: 6 years ago
Posted: 15 Oct 2018 6:32 EDT
Ujjwal Kumar Shukla (UjjwalShukla_GCS)
PEGA
Senior Manager, Technical Support
Pegasystems Inc.
IN

Hi Deva,

Did you get a chance to look at thred-dump that may have been generated in the rules logs.
Issue might be with connectivity if I have to take a guess.

Regards,
Ujjwal

To see attachments, please log in.
Posted: 6 years ago
Posted: 15 Oct 2018 10:27 EDT
Devarajulu Prathapaneni (DevarajPrathapaneni)
Swedbank AB
Solution Architect
Swedbank AB
SE

Thanks for response. We could see below log snippet from  thread dump. But we could not root to DB team as we are not sure what is the excact issue . Please share your thoguhts on this .

 

Show More

Thanks for response. We could see below log snippet from  thread dump. But we could not root to DB team as we are not sure what is the excact issue . Please share your thoguhts on this .

 

"WebContainer : 1" Id=458 in RUNNABLE (running in native)
BlockedCount : 70, BlockedTime : -1, WaitedCount : 269108, WaitedTime : -1
    at java.net.SocketInputStream.socketRead0(Native Method)
    at java.net.SocketInputStream.read(SocketInputStream.java:165)
    at java.net.SocketInputStream.read(SocketInputStream.java:134)
    at oracle.net.ns.Packet.receive(Packet.java:311)
    at oracle.net.ns.DataPacket.receive(DataPacket.java:105)
    at oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:305)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:249)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:171)
    at oracle.net.ns.NetInputStream.read(NetInputStream.java:89)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:123)
    at oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:79)
    at oracle.jdbc.driver.T4CMAREngineStream.unmarshalUB1(T4CMAREngineStream.java:426)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:390)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:249)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:566)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:215)
    at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:58)
    at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:943)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:929)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1034)
    at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3820)
    at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3867)
      - locked oracle.jdbc.driver.T4CConnection@cf38e949
    at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1502)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.pmiExecuteQuery(WSJdbcPreparedStatement.java:1220)
    at com.ibm.ws.rsadapter.jdbc.WSJdbcPreparedStatement.executeQuery(WSJdbcPreparedStatement.java:738)
    at com.pega.pegarules.data.internal.store.DatabasePreparedStatementImpl.executeQuery(DatabasePreparedStatementImpl.java:395)
    at com.pega.pegarules.data.internal.access.Opener$1.getResultPageFromDatabase(Opener.java:753)
    at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:721)
    at com.pega.pegarules.data.internal.access.Opener$1.action(Opener.java:718)
    at com.pega.pegarules.data.internal.store.DataStoreManager.readInTransaction(DataStoreManager.java:70)
    at com.pega.pegarules.data.internal.access.Opener.openData(Opener.java:789)
    at com.pega.pegarules.data.internal.access.Opener.open(Opener.java:2221)
    at com.pega.pegarules.data.internal.access.DatabaseImpl.open(DatabaseImpl.java:2508)

 

Thanks,

Deva 


Show Less
To see attachments, please log in.
Posted: 6 years ago
Posted: 30 Nov 2018 14:03 EST
Marissa Rogers (MarissaRogers)
MOD
Principal Knowledge Management Specialist
Pegasystems Inc.
US

Hi @Deva_Prathapaneni,

While going through our posts that have SRs on them, I looked up your SR referenced here: SR-59819 and that SR is from 2011. Could you verify for me the SR that you raised on this please?

Thank you!

To see attachments, please log in.

We'd prefer it if you saw us at our best.

Pega Collaboration Center has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice