topic Re: Tomcat hangs deleting big sites from share in Alfresco Archive

Tomcat hangs deleting big sites from share

braguzz — Fri, 05 Jul 2013 09:19:57 GMT

configuration:4.2.c communityUbuntu server 12.04 64 8Gb 8 CPU vsphere virtualproblem:deleting a site with many nodes share tell me 'unable to delete site' , tomcat hang and cisf and http connection stop to work.in catalina.log I see—2013-07-02 08:22:05,161 INFO [webscripts.connector.RemoteClient] [h

Re: Tomcat hangs deleting big sites from share

scouil — Fri, 05 Jul 2013 11:13:30 GMT

Hi,

As a workaround, you could try removing nodes bits by bits from the document library and only use the delete site button when the site isn't that big anymore.

Re: Tomcat hangs deleting big sites from share

braguzz — Fri, 05 Jul 2013 11:25:13 GMT

tomcant hangs also when someone delete from share a folder with many nodes.

It's impossible for me to put in production the server because if someone delete those 'big' folder, the other have no more access to the whole documents…

I've notice that when server 'hangs' I see many postgress process with cpu 100%

thanks in advance,
PB

Re: Tomcat hangs deleting big sites from share

scouil — Fri, 05 Jul 2013 11:43:00 GMT

Well yes, if you want big capacity you need to put big means behind.
You know, you can have alfresco, share, solr, postgres all on different servers.

And if you want even more, you can use clustering (only available on enterprise version I think). And use load balancers to redirect traffic between your nodes.

Alfresco scales well, but you have to give it the possibility to do so.

Re: Tomcat hangs deleting big sites from share

braguzz — Fri, 05 Jul 2013 11:52:00 GMT

thanks Scouil, when I say 'big' I say 4Gb, and I suppose that a linux with 8 core with 8Gb should not crash.

and then it seems that there is some misconfiguration (i hope), because I dont think that Alfresco allow that an user could crash the system simply erasing a folder…

Re: Tomcat hangs deleting big sites from share

scouil — Fri, 05 Jul 2013 12:45:28 GMT

You said that postgresql was the one freezing. So it's not about the size of the file I think.
It's more the number of files/folders .
For each one of them he'll check all the permissions to see if you can actually delete it based on your user/groups.
But it might also be some kind of conflict evolving into a deadlock. Try monitoring postgres and see what's actually running.

Re: Tomcat hangs deleting big sites from share

braguzz — Fri, 05 Jul 2013 13:08:12 GMT

I think that pistgress CPU goes high after tomcat timeout.

It sound me strange that i'm tue only one with this problem ….

Re: Tomcat hangs deleting big sites from share

braguzz — Sat, 06 Jul 2013 16:13:00 GMT

Do you think the problem disappares if. I install another server for solr index and postgresql? Otherwise whhat can. I do?

Thanks in advance, Paolo

Re: Tomcat hangs deleting big sites from share

braguzz — Mon, 08 Jul 2013 11:43:50 GMT

Hi,
I made some investigation in postgresql log, and it seems that start to erasing but when timeout occours it start to make rollback
and cpus goes 100%.

Re: Tomcat hangs deleting big sites from share

braguzz — Fri, 12 Jul 2013 20:31:17 GMT

ERROR: duplicate key value violates unique constraint "idx_alf_conturl_cr"
DETAIL: Key (content_url_short, content_url_crc)=(2eedaafc.bin, 692580845) already exists.
STATEMENT: insert into alf_content_url (id, content_url, content_url_short, content_url_crc, content_size, orphan_time)
values ($1, $2, $3, $4, $5, $6)It was postgres.

Installing MySQL problem disappeared.

Thanks, paolo.
Tomcat hangs becouse of an endless list of:

Re: Tomcat hangs deleting big sites from share

kamielvdz — Tue, 24 Jun 2014 11:26:28 GMT

I'm having the same issue. Is it possible to delete nodes without all of the permissions checks?