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)
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)
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.
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)
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)
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.
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.
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.
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
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)
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.
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.