docker-hdp icon indicating copy to clipboard operation
docker-hdp copied to clipboard

Published 20 hours ago • verified publisher icon randerzander

org.postgresql.util.PSQLException: This ResultSet is closed.

Open ashishsoni opened this issue 6 years ago • 5 comments

Getting below error when starting Hive Meta Store

at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAcces sorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:498) at org.apache.hadoop.util.RunJar.run(RunJar.java:233) at org.apache.hadoop.util.RunJar.main(RunJar.java:148) NestedThrowablesStackTrace: org.postgresql.util.PSQLException: This ResultSet is closed. at org.postgresql.jdbc2.AbstractJdbc2ResultSet.checkClosed(AbstractJdbc2 ResultSet.java:2656) at org.postgresql.jdbc2.AbstractJdbc2ResultSet.setFetchSize(AbstractJdbc

ashishsoni avatar Mar 20 '18 20:03 ashishsoni

@ashishsoni , I'm facing the same issue. Are you using the single-container.yml?

EvgenAnufriev avatar Mar 21 '18 09:03 EvgenAnufriev

@EvgenAnufriev Use Postgresh 9.4 docker image instead of latest as latest is postgres 10 version which is not supported by Ambari and HDP , Once i changed it worked for me . You have to modify postgresh docker file to say FROM postgres:9.4 and it should work

ashishsoni avatar Mar 21 '18 11:03 ashishsoni

@ashishsoni , THANKS!!!!! If you have time, can you tell, how you found what causes error?

EvgenAnufriev avatar Mar 21 '18 11:03 EvgenAnufriev

@EvgenAnufriev i did not found the cause but i checked the HDP docs and it says not supported PG 10 so i just straight went to lower pg version, will try to find out if i get some time.

ashishsoni avatar Mar 21 '18 11:03 ashishsoni

Btw, Even though i've changed hdp repo version to 2.6.3 in every place i found, I see links to 2.6.4 in "Stack and Versions" instead. @ashishsoni, maybe you have any idea why? what did i miss?

EvgenAnufriev avatar Mar 21 '18 11:03 EvgenAnufriev