Multiple intermittent error on TrackStudio

Discuss problems installing or using TrackStudio.

Multiple intermittent error on TrackStudio

Postby nbe » Thu Aug 30, 2012 4:49 pm

Hello All,

We have installed TrackStudio on CentOS5. and we are facing some intermittent issues with it. Below are the errors from catalina log.
1. We get this error some time when we try to create user / ticket.
-----------------
error is Stack Trace:
org.hibernate.TransactionException: JDBC commit failed
at org.hibernate.transaction.JDBC
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:161)
at com.trackstudiokernel.lock.LockManager$LockTime.closeSession(LockManager.java:89)
at com.trackstudio.kernel.lock.LockManager.releaseWrite(LockManager.java:153)
at com.trackstudio.app.TriggerManager.createMessage(TriggerManager.java:103)

---------------------
2012-08-29 08:51:23,484 ERROR org.hibernate.transaction.JDBCTransaction:commit:155 - JDBC commit failed
java.sql.SQLException: Protocol violation

-----------------

2. Also while we are trying to stop the TrackStudio, we get below error and eventually we need to kill it as it never goes down.

---------------
org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
SEVERE: The web application [/TrackStudio] appears to have started a thread named [pool-2-thread-17] but has failed to stop it. This is very likely to create a memory leak
--------------

Below is my configuration details

------------
OS -
[root@trackstudio packages]# cat /etc/redhat-release
CentOS release 5.7 (Final)
[root@trackstudio packages]# uname -a
Linux trackstudio 2.6.18-274.17.1.el5xen #1 SMP Tue Jan 10 18:06:37 EST 2012 x86_64 x86_64 x86_64 GNU/Linux
[root@trackstudio packages]#

Application -

TrackStudio_4016
jdk-7u5-linux-x64
apache-tomcat-7.0.29
oracle 11G
------------

Can anyone help me out in it? It is very very urgent for me at this stage . :(
nbe
 
Posts: 3
Joined: Thu Aug 30, 2012 3:35 pm

Re: Multiple intermittent error on TrackStudio

Postby Petr » Fri Aug 31, 2012 8:33 am

Hello. What DB do you use?
Стань Java программистом с www.job4j.ru
Petr
 
Posts: 2929
Joined: Wed Aug 12, 2009 4:38 pm

Re: Multiple intermittent error on TrackStudio

Postby nbe » Fri Aug 31, 2012 10:12 am

Petr wrote:Hello. What DB do you use?



Database version:Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
Database major version:11
Database minor version:2
Database driver name:Oracle JDBC driver
Database driver version:11.1.0.7.0-Production
Database driver major version:11
Database driver minor version:1
Hibernate Dialect: org.hibernate.dialect.OracleDialect
Hibernate Driver: oracle.jdbc.OracleDriver
nbe
 
Posts: 3
Joined: Thu Aug 30, 2012 3:35 pm

Re: Multiple intermittent error on TrackStudio

Postby Petr » Fri Aug 31, 2012 10:15 am

first of all you can try to replace jdbc driver which TrackStudio has on original jdbc driver which distributed with your Orable db. It must be located in a lib/jdbc folder.
Стань Java программистом с www.job4j.ru
Petr
 
Posts: 2929
Joined: Wed Aug 12, 2009 4:38 pm

Re: Multiple intermittent error on TrackStudio

Postby nbe » Mon Sep 03, 2012 6:41 pm

Ok...I Tried with copping ojdbc jar file from oracle directory to /TrackStudio/app/tomcat/lib/ojdbc6.jar location and restarted the App. But it did not help me :( I still have the same error. What else can I try ?
nbe
 
Posts: 3
Joined: Thu Aug 30, 2012 3:35 pm

Re: Multiple intermittent error on TrackStudio

Postby admin » Wed Sep 05, 2012 1:34 pm

nbe wrote:Ok...I Tried with copping ojdbc jar file from oracle directory to /TrackStudio/app/tomcat/lib/ojdbc6.jar location and restarted the App. But it did not help me :( I still have the same error. What else can I try ?


Please try to remove extra oracle jdbc drivers and put correct one to webapps/TrackStudio/WEB-INF/lib
Maxim Kramarenko (mailto: maximkr@trackstudio.com)
TrackStudio - Hierarchical Bug & Issue Tracking Software
http://www.trackstudio.com
admin
Site Admin
 
Posts: 8148
Joined: Thu Jan 01, 1970 3:00 am
Location: Smolensk, Russia


Return to TrackStudio Support

Who is online

Users browsing this forum: No registered users and 6 guests

cron