Alfresco Performance issue

[iswan]

Hi,

I am using default Alfresco 4.2.c community(32 bit) with JVM 1024k max. It went well but now-a-days, It is throwing the below error in alfresco log frequently. Then i unable to login into the Share. Excepting the solution…

1. "11:52:58,262 ERROR [org.hibernate.transaction.JDBCTransaction] JDBC rollback failed
org.postgresql.util.PSQLException: This connection has been closed."
2.    at org.alfresco.repo.content.transform.AbstractContentTransformer2.transform(AbstractContentTransformer2.java:232)
   … 128 more
12:17:37,905 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:17:52,910 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:18:07,899 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:18:22,904 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:18:37,910 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:19:07,907 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:19:22,914 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:19:37,904 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:19:52,910 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:20:07,901 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:20:22,907 WARN  [org.alfresco.repo.activities.post.lookup.PostLookup] Still busy …
12:20:23,938 ERROR [org.quartz.core.JobRunShell] Job DEFAULT.feedGeneratorJobDetail threw an unhandled Exception:
org.alfresco.repo.lock.LockAcquisitionException: 11173355 Failed to release lock '{http://www.alfresco.org/model/system/1.0}activityfeedgenerator' using token 'b5f0a4da-5ee5-4bb1-a514-6425899f2a95'.  The lock has expired and been taken by another process.

[mrogers]

I'm amazed it runs in so little ram!

IIRC one of the activities queries causes MySQL some trouble,  should be fixed now,  however I note that you are running PostgreSQL.   No hum.

[iswan]

Thanks Mrogers for your response.

Actually 1024Mb RAM (Sorry I did typo error)… I am using the default DB postgreSQL..
How can i identify that activity query and fix. Need your guidence

[iswan]

Hi,

I am still getting this error frequently, I was unable to increase the JVM, more than 1024M in 32 bit. If i increase, Tomcat is not starting…

So if i move to 32 bit to 64, Does it solve my problem? (or) I have to look other Application.

Thanks,
Iswan

[iswan]

Hi,

I have moved Alfresco 32 bit to 64 bit, Increased the JVM also to 2 GB. It looks fine in performance.

Problem :

when I delete document, It goes to trash. But I unable to delete in Trash/(Trashcan empty). It throughing the error. It found 2 nodes.
So i don't know how to proceed it.

Seeking the guidance.

Thanks,
Iswan

[iswan]

Hi,

I am still getting this error frequently, I was unable to increase the JVM, more than 1024M in 32 bit. If i increase, Tomcat is not starting…

So if i move to 32 bit to 64, Does it solve my problem? (or) I have to look other Application.

Thanks,
Iswan

[mrogers]

You should probably upgrade to the latest version.    Its a known and fixed issue.    And if you have the choice then you should be running 64 bit.

[mitpatoliya]

Yes, moving to 64 bit would help if that is because of JVM heap size but It should work with 32 bit as I am running it successfully in my local. I don't think this is the issue with JVM space.
How you are trying increase the JVM space?

[iswan]

Thanks for the response.

As suggested, First I will upgrade 4.2c to 4.2e by this weekend and get back to you on this with good update.

I have increased the JVM space in regedit.(Changed from 768M to 1024M), It is reflecting in the LOG also at the time of starting.

Regards,
Iswan