Description of problem: We want to upgrade JDBC driver to latest driver 42.1.1 However a regression issue cause our stored procedures to throw NullPointerExceptions when the driver is trying to get the meta-data on the result set returned from the call Version-Release number of selected component (if applicable): How reproducible: Steps to Reproduce: 1. 2. 3. Actual results: Expected results: Additional info: See full details in blocking BZ
(In reply to Eli Mesika from comment #0) > Description of problem: > > We want to upgrade JDBC driver to latest driver 42.1.1 > However a regression issue cause our stored procedures to throw > NullPointerExceptions when the driver is trying to get the meta-data on the > result set returned from the call Last working version of postgresql-jdbc is 9.2, everything newer breaks engine until fixed on upstream
Targeting to 4.2, but at the moment we just need to wait until it's fixed at least on upstream
I have got the suggest fix on postgres JDBC driver and tested it , it solved the sample program I used to demonstrate the issue however engine still failed with : 017-06-07 23:13:15,706+03 ERROR [org.ovirt.engine.core.bll.network.macpool.MacPoolPerCluster] (ServerService Thread Pool -- 52) [] Error initializing: PreparedStatementCallback; bad SQL grammar [select * from getallmacpoolrangesbymacpoolid()]; nested exception is org.postgresql.util.PSQLException: ERROR: function getallmacpoolrangesbymacpoolid() does not exist Hint: No function matches the given name and argument types. You might need to add explicit type casts. Position: 16 But the above exception was when using spring 4.2.4.RELEASE So, I did another try with spring 4.3.8.RELEASE The application worked and all DAO tests also passed with no issues. So , bottom line we should use : 1) postgres 42.1.2 2) spring 4.3.8
After PG JDBC Driver 42.1.3 was released and another issue[1] we have found in one of our SP code was resolved and merged to master, we can go ahead now and use PG 9.5
4.2.2 is out
Upgrading to 42.2.2 should bypass regression in JDBC drivers around Spring Framework support
ovirt-engine installed on fedora with postgresql-jdbc 42.2.2, no NullPointerException, engine running without problems verified in ovirt-engine-4.3.0-0.4.master.20181212102908.git1eda2787ea4.fc28.noarch
This bugzilla is included in oVirt 4.3.0 release, published on February 4th 2019. Since the problem described in this bug report should be resolved in oVirt 4.3.0 release, it has been closed with a resolution of CURRENT RELEASE. If the solution does not work for you, please open a new bug report.