Support #5165

[SCP ID :##2557##] : TAC problem 27/1/2015

Added by Zahir Abd Latif over 9 years ago. Updated over 9 years ago.

Status:Closed - End of life cycleStart date:January 28, 2015
Priority:NormalDue date:
Assignee:Zahir Abd Latif% Done:

100%

Category:MY RIBSpent time:3.00 hours
Target version:-

Description

Hi,
Kindly attend below request:

TAC delayed on 27/1/2015 around 530pm. TAC pop up screen keep loading until session expired for all 4 instances. 
Server Admin restarted upass service but still failed but suddenly TAC working fine for all instance after they restarted instance 01

Need your help to investigate this issue to avoid the same problem occur in the future

History

#1 Updated by Zahir Abd Latif over 9 years ago

  • Status changed from New - Begin Life Cycle to Development / Work In Progress

Dear Hafiz/KFH team,

Kindly assist to update the current status in Redmine.

Thanks.

#2 Updated by Zahir Abd Latif over 9 years ago

Dear Team,

Last email from Azraf (Jan 28, 2015 02:21 PM) :

We have transferred to \\10.20.8.124\shared\LOG\27012015_ib_logs

Please help to further investigate on this issue and update the current status in Redmine.

Thanks.

#3 Updated by Norhaidah Md Dasuki over 9 years ago

  • Assignee changed from Hafizudin MD to Ngoh Chee Ping
  • % Done changed from 0 to 50

Chee Ping,
Can you please assist on this. What is the findings? Is it related to #5196 where housekeeping on the SMS_table to clean up all the non updated GUID and Null phone number is required.

#4 Updated by Ngoh Chee Ping over 9 years ago

It not related to #5196 where housekeeping on the SMS_table to clean up all the non updated GUID and Null phone number is required.
After checked the log, the error related to the hibernate session. Below are the error i found.

2015/01/27 18:21:17:105 ERROR kfh.hibernate.utils.HibernateTACUtils: Error details : possible non-threadsafe access to the session
Exception class : org.hibernate.engine.TwoPhaseLoad, class method : initializeEntity, line number : 123org.hibernate.engine.TwoPhaseLoad.initializeEntity(TwoPhaseLoad.java:123)
org.hibernate.loader.Loader.initializeEntitiesAndCollections(Loader.java:877)
org.hibernate.loader.Loader.doQuery(Loader.java:752)
org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:259)

Further Error Explanation of this error:
Let say there is 2 hibernate transaction execute at the same time. Both sharing the same session.

Transaction 1: Get session
Transaction 1: Executing
Transaction 2: Get session
Transaction 2: Start execute, since transaction 1 still executing, the session will execute transaction 1 and transaction 2 at the same time, it will cause this problem.

Root Cause:
Used static for the hibernate session inside HibernateTACUtils class.

  • static Session c_oSession = null;
    static {
    c_oSession = HibernateUtils.getCurrentSession();
    }*

Solution:
Remove the static in the hibernate session.

#5 Updated by Ngoh Chee Ping over 9 years ago

  • Assignee changed from Ngoh Chee Ping to Zahir Abd Latif
  • % Done changed from 50 to 100

After check with Kah Yan, and understand that this HibernateTACUtils class file is not belong to our side. Furthermore we cannot help to fix it since we do not have the latest source code.

#6 Updated by Zahir Abd Latif over 9 years ago

  • Status changed from Development / Work In Progress to Closed - End of life cycle

Issue closed in SCP. Refer email: Re: [Request ID :##2557##] : TAC problem 27/1/2015

Also available in: Atom PDF