topic Re: Alfresco services hanging..please help me.. in Alfresco Archive

Alfresco services hanging..please help me..

paramesh — Thu, 09 Aug 2012 09:50:52 GMT

Hi all,My web site using Alfresco…last few days onwards my alfresco site is hanging…and i found some errors in my alfresco log file….i did observe that after i got that error (Please look into below) my alfresco and my web site both are hanging…we deployed the website using "JBOSS 2.6.7 GA" and Alfr

Re: Alfresco services hanging..please help me..

afaust — Thu, 09 Aug 2012 10:50:21 GMT

Hello,

you are using Derby as your database. This is not a supported database for the current Alfresco version, but I do not know, if this was the case for Alfresco 3.0.0 (which is quite old). It might by that you suffer from this: https://issues.apache.org/jira/browse/DERBY-3379

Generally, I'd advise to consider upgrading / updating your software stack. JBoss 2.x is quite old as well and who knows what other components might contain some potential, long fixed errors / bugs…

Regards
Axel

Re: Alfresco services hanging..please help me..

paramesh — Fri, 10 Aug 2012 06:49:29 GMT

Hello,

you are using Derby as your database. This is not a supported database for the current Alfresco version, but I do not know, if this was the case for Alfresco 3.0.0 (which is quite old). It might by that you suffer from this: https://issues.apache.org/jira/browse/DERBY-3379

Generally, I'd advise to consider upgrading / updating your software stack. JBoss 2.x is quite old as well and who knows what other components might contain some potential, long fixed errors / bugs…

Regards
Axel

Dear Sir,

Is there any solution except upgrading…because it been running from last four years…

Thank you.

Re: Alfresco services hanging..please help me..

afaust — Fri, 10 Aug 2012 07:29:07 GMT

Hello,

upgrading is an advice and not a must, since I have not the necessary information to judge it as such. At the least, you should consider upgrading your Derby components, as the issue linked is very similar to what you experience and should be fixed in a newer version.

Regards
Axel

Re: Alfresco services hanging..please help me..

mrogers — Fri, 10 Aug 2012 08:47:15 GMT

If you don't want to migrate or upgrade you will need to figure out what's gone wrong with your database. There's no information in your posting that helps diagnose your problem. All that can be said is that you have some sort of database problem.

Re: Alfresco services hanging..please help me..

paramesh — Fri, 10 Aug 2012 09:17:45 GMT

If you don't want to migrate or upgrade you will need to figure out what's gone wrong with your database. There's no information in your posting that helps diagnose your problem. All that can be said is that you have some sort of database problem.

Dear Sir,

I have checked the derby.log file and i found some error in it.

Cleanup action completed
2012-08-10 08:02:39.198 GMT Thread[http-8082-35,5,main] (XID = 42207274), (SESSI
ONID = 131), (DATABASE = /u01/Alfresco/alf_data/derby_data/alfresco), (DRDAID =
null), Cleanup action starting
2012-08-10 08:02:39.198 GMT Thread[http-8082-35,5,main] (XID = 42207274), (SESSI
ONID = 131), (DATABASE = /u01/Alfresco/alf_data/derby_data/alfresco), (DRDAID =
null), Failed Statement is: select childassoc0_.id as col_0_0_, childassoc0_.typ
e_qname_id as col_1_0_, childassoc0_.qname_ns_id as col_2_0_, childassoc0_.qname
_localname as col_3_0_, childassoc0_.is_primary as col_4_0_, childassoc0_.assoc_
index as col_5_0_, nodeimpl2_.id as col_6_0_, storeimpl3_.protocol as col_7_0_,
storeimpl3_.identifier as col_8_0_, nodeimpl2_.uuid as col_9_0_ from alf_child_a
ssoc childassoc0_ inner join alf_node nodeimpl1_ on childassoc0_.parent_node_id=
nodeimpl1_.id inner join alf_node nodeimpl2_ on childassoc0_.child_node_id=nodei
mpl2_.id inner join alf_store storeimpl3_ on nodeimpl2_.store_id=storeimpl3_.id
where nodeimpl1_.id=? and childassoc0_.qname_ns_id=? and childassoc0_.qname_loca
lname=? order by childassoc0_.assoc_index, childassoc0_.id with 3 parameters beg
in parameter #1: 197057 :end parameter begin parameter #2: 65542 :end parameter
begin parameter #3: preferences :end parameter
java.lang.OutOfMemoryError: GC overhead limit exceeded
        at org.apache.derby.impl.services.locks.ConcurrentLockSet$Entry.<init>(U
nknown Source)
        at org.apache.derby.impl.services.locks.ConcurrentLockSet$Entry.<init>(U
nknown Source)
        at org.apache.derby.impl.services.locks.ConcurrentLockSet.getEntry(Unkno
wn Source)
        at org.apache.derby.impl.services.locks.ConcurrentLockSet.lockObject(Unk
nown Source)
        at org.apache.derby.impl.services.locks.AbstractPool.lockObject(Unknown
Source)
        at org.apache.derby.impl.services.locks.ConcurrentPool.lockObject(Unknow
n Source)
        at org.apache.derby.impl.store.raw.xact.RowLocking2.lockRecordForRead(Un

If you want more details please let me know i will provide you..

Thank you..

Re: Alfresco services hanging..please help me..

afaust — Fri, 10 Aug 2012 09:24:47 GMT

Hello,

this indicates that either a) your Derby has a memory leak and runs full of memory, or b) due to size / transactional data set, the memory alloted to your Derby instance is not enough. An alternative scenario c) could be that the settings for GC are not optimal and may cause an unstable JVM in certain conditions - but this is difficult to say without extensive analysis.

You should check your Derby JVM settings and adjust the max heap size as a short term solution to a) / long term adaption to b). In order to determine wether a) is the case, you would need to profile / analyze the Derby JVM memory usage.

Regards
Axel

Re: Alfresco services hanging..please help me..

paramesh — Fri, 10 Aug 2012 10:10:45 GMT

Hello,

this indicates that either a) your Derby has a memory leak and runs full of memory, or b) due to size / transactional data set, the memory alloted to your Derby instance is not enough. An alternative scenario c) could be that the settings for GC are not optimal and may cause an unstable JVM in certain conditions - but this is difficult to say without extensive analysis.

You should check your Derby JVM settings and adjust the max heap size as a short term solution to a) / long term adaption to b). In order to determine wether a) is the case, you would need to profile / analyze the Derby JVM memory usage.

Regards
Axel

Dear Sir,
Could you please let me know how adjust the heap size for DERBY DATABASE..i know how to change the heap size for Alfresco("JAVA_OPTS=") in "./alfresco.sh" file but i do not know for DERBY please tell me how do so…or is there any way to free up the derby memory..

Thank You..

Re: Alfresco services hanging..please help me..

afaust — Fri, 10 Aug 2012 10:39:30 GMT

Hello,

this depends on how you have deployed / setup Derby. Basically, it is the same parameters used to increase heap for Alfresco (since both run in a JVM).
An example can be found via http://lmgtfy.com/?q=apache+derby+heap+size

Regards
Axel