Problem with toucat7- DHIS2.11 - postgres

We are testing DHIS2.11 on PostgreSQL 9.2 after converting database from MySQL5.5. The servers are on VM ware and database server and application server are on same physical machine connected through a virtual switch. Some time the servers are working fine but sometimes no one can log-on to the application. from log I find the follwoing error: (I attach the log file)

  • ERROR 2013-06-10 10:52:02,253 Application exception overridden by rollback exception (TransactionAspectSupport.java [http-bio-8080-exec-7])
    org.hibernate.exception.JDBCConnectionException: An I/O error occured while sending to the backend.

      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:131)
    

OS : Ubuntu 12.04

Java: Oracle 1.7 64 bit

Regards

Hannan

catalina.out (303 KB)

I heard there was a problem with 64-bit Java. Not sure if that’s the case (can anyone enlighten me?) or has any relation to your problem

···

Den 10. juni 2013 06:12 skrev “Hannan Khan” hannank@gmail.com følgende:

We are testing DHIS2.11 on PostgreSQL 9.2 after converting database from MySQL5.5. The servers are on VM ware and database server and application server are on same physical machine connected through a virtual switch. Some time the servers are working fine but sometimes no one can log-on to the application. from log I find the follwoing error: (I attach the log file)

  • ERROR 2013-06-10 10:52:02,253 Application exception overridden by rollback exception (TransactionAspectSupport.java [http-bio-8080-exec-7])
    org.hibernate.exception.JDBCConnectionException: An I/O error occured while sending to the backend.

      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:131)
    

OS : Ubuntu 12.04

Java: Oracle 1.7 64 bit

Regards

Hannan


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi all,

DHIS 2.11 Data Entry page gives this error whenever a value is entered into the boxes. It says Saving Value Failed with Status Code 1. Instead of also turning green, it first turns yellow and then RED.

Anyone with a solution?

Thanks

Dayo

I dont think its a 64-bit JVM issue. Its been in use otherwise on many working systems.

Looks like the connection with the database is dropping… Could be for a number of reasons, including problematic hardware.

Could you post the postgres logs? That might have something inside

···

Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

On 10 June 2013 08:19, Knut Staring knutst@gmail.com wrote:

I heard there was a problem with 64-bit Java. Not sure if that’s the case (can anyone enlighten me?) or has any relation to your problem

Den 10. juni 2013 06:12 skrev “Hannan Khan” hannank@gmail.com følgende:

We are testing DHIS2.11 on PostgreSQL 9.2 after converting database from MySQL5.5. The servers are on VM ware and database server and application server are on same physical machine connected through a virtual switch. Some time the servers are working fine but sometimes no one can log-on to the application. from log I find the follwoing error: (I attach the log file)

  • ERROR 2013-06-10 10:52:02,253 Application exception overridden by rollback exception (TransactionAspectSupport.java [http-bio-8080-exec-7])
    org.hibernate.exception.JDBCConnectionException: An I/O error occured while sending to the backend.

      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:131)
    

OS : Ubuntu 12.04

Java: Oracle 1.7 64 bit

Regards

Hannan


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Yes!

The connection pool software is saying that the connection is expiring.

I have DHIS running with OpenJDK under 64bit. Can you try OpenJDK instead of the Oracle one?

Caveman

···

On Mon, Jun 10, 2013 at 12:30 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

I dont think its a 64-bit JVM issue. Its been in use otherwise on many working systems.

Looks like the connection with the database is dropping… Could be for a number of reasons, including problematic hardware.

Could you post the postgres logs? That might have something inside


Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

On 10 June 2013 08:19, Knut Staring knutst@gmail.com wrote:

I heard there was a problem with 64-bit Java. Not sure if that’s the case (can anyone enlighten me?) or has any relation to your problem

Den 10. juni 2013 06:12 skrev “Hannan Khan” hannank@gmail.com følgende:

We are testing DHIS2.11 on PostgreSQL 9.2 after converting database from MySQL5.5. The servers are on VM ware and database server and application server are on same physical machine connected through a virtual switch. Some time the servers are working fine but sometimes no one can log-on to the application. from log I find the follwoing error: (I attach the log file)

  • ERROR 2013-06-10 10:52:02,253 Application exception overridden by rollback exception (TransactionAspectSupport.java [http-bio-8080-exec-7])
    org.hibernate.exception.JDBCConnectionException: An I/O error occured while sending to the backend.

      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:131)
    

OS : Ubuntu 12.04

Java: Oracle 1.7 64 bit

Regards

Hannan


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Hi

did this start occurring after updating from 2.10 to 2.11? Does the same thing happen if using Chrome in Incognito mode?

Olav

···
  1. juni 2013 kl. 11:27 skrev Dayo Adeyomoye deemoyes@yahoo.com:

Hi all,

DHIS 2.11 Data Entry page gives this error whenever a value is entered into the boxes. It says Saving Value Failed with Status Code 1. Instead of also turning green, it first turns yellow and then RED.

Anyone with a solution?

Thanks

Dayo


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Thanks Olav,

I restarted the DHIS server and it works now. As you also mentioned, one of the users experienced the problem again but after changing browser it was resolved. I also encountered it again but when I tried Chrome Incognito and IE that I haven’t used for it before. The problem did not surface.

It must have cached the issues.

Thank you.

BlackBerry: 3114F90C
Phone: 08028851441, 08035560463
emails: deemoyes@yahoo.com, addyraph@yahoo.com
Yahoo IM: deemoyes
Facebook: pharael
twitter:pharaell

···

From: Olav Poppe olav.poppe@me.com
To: Dayo Adeyomoye deemoyes@yahoo.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net
Sent: Monday, June 10, 2013 12:05 PM
Subject: Re: [Dhis2-users] DHIS2.11 Saving Value Failed with Status Code 1

Hi

did this start occurring after updating from 2.10 to 2.11? Does the same thing happen if using Chrome in Incognito mode?

Olav

  1. juni 2013 kl. 11:27 skrev Dayo Adeyomoye deemoyes@yahoo.com:

Hi all,

DHIS 2.11 Data Entry page gives this error whenever a value is entered into the boxes. It says Saving Value Failed with Status Code 1. Instead of also turning green, it first turns yellow and then RED.

Anyone with a solution?

Thanks

Dayo


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net
Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp

Thanks Orvalho.

I find that when this is happens the server ping time is exceptionally high. So I requested network administrator to look at that. Also as you suggested I changed the java to open jre 7. After that, that problem is not arrived so far.

Thanks everyone for response.

Regards

Hannan

···

On Mon, Jun 10, 2013 at 12:30 PM, Saptarshi Purkayastha sunbiz@gmail.com wrote:

I dont think its a 64-bit JVM issue. Its been in use otherwise on many working systems.

Looks like the connection with the database is dropping… Could be for a number of reasons, including problematic hardware.

Could you post the postgres logs? That might have something inside


Regards,
Saptarshi PURKAYASTHA

My Tech Blog: http://sunnytalkstech.blogspot.com

You Live by CHOICE, Not by CHANCE

On 10 June 2013 08:19, Knut Staring knutst@gmail.com wrote:

I heard there was a problem with 64-bit Java. Not sure if that’s the case (can anyone enlighten me?) or has any relation to your problem

Den 10. juni 2013 06:12 skrev “Hannan Khan” hannank@gmail.com følgende:

We are testing DHIS2.11 on PostgreSQL 9.2 after converting database from MySQL5.5. The servers are on VM ware and database server and application server are on same physical machine connected through a virtual switch. Some time the servers are working fine but sometimes no one can log-on to the application. from log I find the follwoing error: (I attach the log file)

  • ERROR 2013-06-10 10:52:02,253 Application exception overridden by rollback exception (TransactionAspectSupport.java [http-bio-8080-exec-7])
    org.hibernate.exception.JDBCConnectionException: An I/O error occured while sending to the backend.

      at org.hibernate.exception.internal.SQLStateConversionDelegate.convert(SQLStateConversionDelegate.java:131)
    

OS : Ubuntu 12.04

Java: Oracle 1.7 64 bit

Regards

Hannan


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp

Likely to be a caching issue. To force an update of all data sets you can do this SQL:

update dataset set version = (version+1);

regards,

Lars

···

On Mon, Jun 10, 2013 at 2:30 PM, Dayo Adeyomoye deemoyes@yahoo.com wrote:

Thanks Olav,

I restarted the DHIS server and it works now. As you also mentioned, one of the users experienced the problem again but after changing browser it was resolved. I also encountered it again but when I tried Chrome Incognito and IE that I haven’t used for it before. The problem did not surface.

It must have cached the issues.

Thank you.

BlackBerry: 3114F90C
Phone: 08028851441, 08035560463
emails: deemoyes@yahoo.com, addyraph@yahoo.com

Yahoo IM: deemoyes
Facebook: pharael
twitter:pharaell


From: Olav Poppe olav.poppe@me.com

To: Dayo Adeyomoye deemoyes@yahoo.com
Cc: "dhis2-users@lists.launchpad.net" dhis2-users@lists.launchpad.net

Sent: Monday, June 10, 2013 12:05 PM
Subject: Re: [Dhis2-users] DHIS2.11 Saving Value Failed with Status Code 1

Hi

did this start occurring after updating from 2.10 to 2.11? Does the same thing happen if using Chrome in Incognito mode?

Olav

  1. juni 2013 kl. 11:27 skrev Dayo Adeyomoye deemoyes@yahoo.com:

Hi all,

DHIS 2.11 Data Entry page gives this error whenever a value is entered into the boxes. It says Saving Value Failed with Status Code 1. Instead of also turning green, it first turns yellow and then RED.

Anyone with a solution?

Thanks

Dayo


Mailing list: https://launchpad.net/~dhis2-users
Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users
More help : https://help.launchpad.net/ListHelp


Mailing list: https://launchpad.net/~dhis2-users

Post to : dhis2-users@lists.launchpad.net

Unsubscribe : https://launchpad.net/~dhis2-users

More help : https://help.launchpad.net/ListHelp