While deploying hippo cms.war, loading the data from db is taking too much time


#1

Kindly let me know why I am getting this error while reading data from oracle db.

Stack trace:
java.net.SocketInputStream.socketRead0(Native Method)
java.net.SocketInputStream.socketRead(SocketInputStream.java:116)
java.net.SocketInputStream.read(SocketInputStream.java:171)
java.net.SocketInputStream.read(SocketInputStream.java:141)
oracle.net.ns.Packet.receive(Packet.java:308)
oracle.net.ns.DataPacket.receive(DataPacket.java:106)
oracle.net.ns.NetInputStream.getNextPacket(NetInputStream.java:324)
oracle.net.ns.NetInputStream.read(NetInputStream.java:268)
oracle.net.ns.NetInputStream.read(NetInputStream.java:190)
oracle.net.ns.NetInputStream.read(NetInputStream.java:107)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.readNextPacket(T4CSocketInputStreamWrapper.java:124)
oracle.jdbc.driver.T4CSocketInputStreamWrapper.read(T4CSocketInputStreamWrapper.java:80)
oracle.jdbc.driver.T4CMAREngine.unmarshalUB1(T4CMAREngine.java:1137)
oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:350)
oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
oracle.jdbc.driver.T4CPreparedStatement.fetch(T4CPreparedStatement.java:1121)
oracle.jdbc.driver.OracleResultSetImpl.close_or_fetch_from_next(OracleResultSetImpl.java:384)

  • locked oracle.jdbc.driver.T4CConnection@33a2cfab
    oracle.jdbc.driver.OracleResultSetImpl.next(OracleResultSetImpl.java:288)
  • locked oracle.jdbc.driver.T4CConnection@33a2cfab
    org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
    org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)

#2

Any logging on your database logs? When exactly is this occurring? I assume this is a timeout happening. My first guess would be to look at the database, but I don’t really have enough information to say. Maybe someone else has some insights.


#3

Hi,

Is it about taking too long time on startup due to lucene index rebuilding?

Woonsan

[1] https://documentation.bloomreach.com/library/enterprise/installation-and-configuration/backup-and-restore-strategy.html