topic Re: Nuxeo DM 5.5 and PostgreSQL Locks in Nuxeo Forum

Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Thu, 10 May 2012 13:58:48 GMT

Hi all,

We are using Nuxeo DM 5.5 with PostgreSQL 8.4.and we have a singular (almost for us) behavior of the system. For long period of time Nuxeo works well, we are able to insert, upload delete document and so on. Then after a several operation the system do not respond, but the server (tomcat) is up and the database also. After some investigation we have noted that during the period where nuxeo do not respond there are some transaction running in the database that i think create some locks. After 10-15 minutes the transactions are closed and Nuxeo respond and .. incredible the last operation has been done correctly. Any suggestions in order to solve this issue.. I attach the evidence of locks during the session where Nuxeo do not respond. Apologies in case the image is too big. Thanks in advance. Giancarlo

Re: Nuxeo DM 5.5 and PostgreSQL Locks

Florent_Guillau — Thu, 10 May 2012 14:46:24 GMT

Please use the jstack command to get a stack trace of the Nuxeo server while it's doing something unknown. Having the stack trace would help us understand what it's doing.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Fri, 11 May 2012 11:38:47 GMT

Here part of stack error, when happens the problem. Thanks in advance.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

Florent_Guillau — Fri, 11 May 2012 12:17:34 GMT

Seriously, this was unreadable. Such a huge stack trace is not suitable for this site. I removed it. Please post it to an external site designed for pastes (pastebin.com for instance) or give us just an extract.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Fri, 11 May 2012 12:30:13 GMT

Sorry

Re: Nuxeo DM 5.5 and PostgreSQL Locks

Florent_Guillau — Fri, 11 May 2012 14:23:12 GMT

The error Resetting connection means that connection to the database was lost and had to be reset. You also see things like An I/O error occured while sending to the backend or Connection timed out.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Fri, 11 May 2012 14:35:09 GMT

Thanks very much. We will investigate in our infrastructure firewalls, etc

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Tue, 15 May 2012 13:44:26 GMT

We have investigated in our infrastructure and yes we have some problem with firewalls that drops the connection after a certain period of time.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

Florent_Guillau — Tue, 15 May 2012 18:19:32 GMT

To enable keep-alive on PostgreSQL connections you need to change:

the datasources (server.xml or nuxeo.xml or the relevant templates) to add tcpKeepAlive=true to the <Resource> for your datasource(s),
the repository configuration (default-repository-config.xml or its template) to add <property name="TcpKeepAlive">true</property>.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Wed, 16 May 2012 23:03:07 GMT

Thank you very much. In reality we already made this configuration, but the datasource related to the repository seems do not keep in consideration the property. The difference is that we have typed "tcpKeepAlive" instead "TcpKeepAlive". As soon as possible we will made this change, and try again.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Thu, 17 May 2012 12:05:10 GMT

Good morning,

Re: Nuxeo DM 5.5 and PostgreSQL Locks

Florent_Guillau — Mon, 21 May 2012 14:28:52 GMT

It works for me (the method setTcpKeepAlive of the XA datasource is called (checked with a breakpoint) when I add <property name="TcpKeepAlive">true</property> to the repository config.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Wed, 23 May 2012 17:02:44 GMT

Hi Florent, thank you very much for you support. But probably there are some settings wrong that we made. I setted custom/template that replace the postgres default. We have tested it changing the property password with one wrong, and Nuxeo raise an error of wrong password, so we are sure that Nuxeo is using our custum tempalte, but the property TcpKeepAlive has no effect. We have only one datasource that works fine with the tcpkeepalive property as mentioned in the previuos comment. The datasources XA do not recognize the TcpKeepAlive property.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

Florent_Guillau — Wed, 23 May 2012 17:29:32 GMT

Short of breakpointing in RepositoryBackend.initialize to see why the call to BeanUtils.setProperty doesn't do what you want, I don't see how to debug this.

Re: Nuxeo DM 5.5 and PostgreSQL Locks

gianclo_Lori — Fri, 25 May 2012 12:19:44 GMT

Solved.