Обсуждение: "Server versions prior to 8.0 do not support savepoints" when using JDBC ...

Hello.

I wonder if anyone can assist with this?

Some of my developers are reporting that they are getting the following 
message when attempting to connect to the database using jdbc:

Caused by: org.postgresql.util.PSQLException: Server versions prior to 
8.0 do not support savepoints

at

org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95)

Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc 
driver version they're employing is postgresl-42.2.9.

The database itself has absolutely no issues creating savepoints (I 
checked it, just in case ...) so I'm assuming it must be some issue with 
the driver / how the driver has been configured.

As you can see I've not been given a a lot to go on, unfortunately. Has 
anyone seen this before? Is this a common issue and my google-fu has 
failed me? :)

Many thanks.

Regards,

M.

-- 
Martin Goodson

Whatever you've got planned, forget it. I'm the Doctor.
I'm 904 years old. I'm from the planet Gallifrey in the
constellation of Kasterborous. I am The Oncoming Storm,
the Bringer of Darkness and you are ... basically just a
rabbit, aren't you? OK, carry on, just a general ...
warning.

On 11/29/20 10:06 AM, Martin Goodson wrote:
> Hello.
> 
> I wonder if anyone can assist with this?
> 
> Some of my developers are reporting that they are getting the following 
> message when attempting to connect to the database using jdbc:
> 
> Caused by: org.postgresql.util.PSQLException: Server versions prior to 
> 8.0 do not support savepoints
> 
> at
> 
> org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95) 
> 
> 
> Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc 
> driver version they're employing is postgresl-42.2.9.

How was the database installed and from where?

Do you have more then one instance of Postgres running on the machine?

What is the connection code being used?


> 
> The database itself has absolutely no issues creating savepoints (I 
> checked it, just in case ...) so I'm assuming it must be some issue with 
> the driver / how the driver has been configured.
> 
> As you can see I've not been given a a lot to go on, unfortunately. Has 
> anyone seen this before? Is this a common issue and my google-fu has 
> failed me? :)
> 
> Many thanks.
> 
> Regards,
> 
> M.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 29/11/2020 18:10, Adrian Klaver wrote:
> On 11/29/20 10:06 AM, Martin Goodson wrote:
>> Hello.
>>
>> I wonder if anyone can assist with this?
>>
>> Some of my developers are reporting that they are getting the 
>> following message when attempting to connect to the database using jdbc:
>>
>> Caused by: org.postgresql.util.PSQLException: Server versions prior to 
>> 8.0 do not support savepoints
>>
>> at
>>
>> org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95) 
>>
>>
>> Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc 
>> driver version they're employing is postgresl-42.2.9.

> How was the database installed and from where?

Hello, Adrian. The database was installed using an enterprisedb 
installer, to its own dedicated set of directories.

> Do you have more then one instance of Postgres running on the machine?

We do not, no. It is the sole PostgreSQL database cluster running on 
that box.

> What is the connection code being used?

An excellent question. I will chase up with them, and find out. I 
believe they're using tomcat, but don't know the exact code involved.

FWIW the connection is not local, the attempted connection is from a 
different server.

Regards,

Martin.

-- 
Martin Goodson

Whatever you've got planned, forget it. I'm the Doctor.
I'm 904 years old. I'm from the planet Gallifrey in the
constellation of Kasterborous. I am The Oncoming Storm,
the Bringer of Darkness and you are ... basically just a
rabbit, aren't you? OK, carry on, just a general ...
warning.

On 11/29/20 10:22 AM, Martin Goodson wrote:
> On 29/11/2020 18:10, Adrian Klaver wrote:
>> On 11/29/20 10:06 AM, Martin Goodson wrote:
>>> Hello.
>>>
>>> I wonder if anyone can assist with this?
>>>
>>> Some of my developers are reporting that they are getting the 
>>> following message when attempting to connect to the database using jdbc:
>>>
>>> Caused by: org.postgresql.util.PSQLException: Server versions prior 
>>> to 8.0 do not support savepoints
>>>
>>> at
>>>
>>> org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95) 
>>>
>>>
>>> Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc 
>>> driver version they're employing is postgresl-42.2.9.
> 
>> How was the database installed and from where?
> 
> Hello, Adrian. The database was installed using an enterprisedb 
> installer, to its own dedicated set of directories.
> 
>> Do you have more then one instance of Postgres running on the machine?
> 
> We do not, no. It is the sole PostgreSQL database cluster running on 
> that box.
> 
>> What is the connection code being used?
> 
> An excellent question. I will chase up with them, and find out. I 
> believe they're using tomcat, but don't know the exact code involved.
> 
> FWIW the connection is not local, the attempted connection is from a 
> different server.

And you know that this is actually the server being reached?

Do you see the attempted connection in the logs?

> 
> Regards,
> 
> Martin.
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com

On 29/11/2020 18:28, Adrian Klaver wrote:
> On 11/29/20 10:22 AM, Martin Goodson wrote:
>> On 29/11/2020 18:10, Adrian Klaver wrote:
>>> On 11/29/20 10:06 AM, Martin Goodson wrote:
>>>> Hello.
>>>>
>>>> I wonder if anyone can assist with this?
>>>>
>>>> Some of my developers are reporting that they are getting the 
>>>> following message when attempting to connect to the database using 
>>>> jdbc:
>>>>
>>>> Caused by: org.postgresql.util.PSQLException: Server versions prior 
>>>> to 8.0 do not support savepoints
>>>>
>>>> at
>>>>
>>>> org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95) 
>>>>
>>>>
>>>> Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc 
>>>> driver version they're employing is postgresl-42.2.9.
>>
>>> How was the database installed and from where?
>>
>> Hello, Adrian. The database was installed using an enterprisedb 
>> installer, to its own dedicated set of directories.
>>
>>> Do you have more then one instance of Postgres running on the machine?
>>
>> We do not, no. It is the sole PostgreSQL database cluster running on 
>> that box.
>>
>>> What is the connection code being used?
>>
>> An excellent question. I will chase up with them, and find out. I 
>> believe they're using tomcat, but don't know the exact code involved.
>>
>> FWIW the connection is not local, the attempted connection is from a 
>> different server.
> 
> And you know that this is actually the server being reached?
> 
> Do you see the attempted connection in the logs?

I do, yes. We log connections, and I can see connections incoming from 
their application servers.

At the moment we only log connections and erroring statements, but 
tomorrow I think I'll be temporarily enabling logging of all 
disconnections and all statements, to see what (if anything) they're 
actually executing on the database side before they see their error ...

Regards,

Martin.

-
Martin Goodson

Whatever you've got planned, forget it. I'm the Doctor.
I'm 904 years old. I'm from the planet Gallifrey in the
constellation of Kasterborous. I am The Oncoming Storm,
the Bringer of Darkness and you are ... basically just a
rabbit, aren't you? OK, carry on, just a general ...
warning.

On 29/11/2020 18:46, David G. Johnston wrote:
> On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson <kaemaril@googlemail.com>
> wrote:
> 
>> Hello.
>>
>> I wonder if anyone can assist with this?
>>
>> Some of my developers are reporting that they are getting the following
>> message when attempting to connect to the database using jdbc:
>>
>> Caused by: org.postgresql.util.PSQLException: Server versions prior to
>> 8.0 do not support savepoints
>>
>> at
>>
>>
>> org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95)
>>
>> Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc
>> driver version they're employing is postgresl-42.2.9.
>>
> 
> My best guess is that they are not actually running 42.2.9, they are
> running an older version that was released before PostgreSQL v10 came out
> and the version detection code doesn't recognize the new version format
> since 10.
> 
> I didn't dig into this too deeply but I did download the zip for 42.2.9 and
> those classes don't even exist at that point since the build was re-done
> using pre-processors.
> 
> David J.
> 
Oh. That's very interesting. Thank you, David. I will chase up with the 
developers tomorrow to confirm with them the version of the postgres 
jdbc driver they are using.

I'm no coder, it didn't occur to me to actually check with the source. 
Nice one :)

Many thanks.

Regards,

Martin.

-- 
Martin Goodson

Whatever you've got planned, forget it. I'm the Doctor.
I'm 904 years old. I'm from the planet Gallifrey in the
constellation of Kasterborous. I am The Oncoming Storm,
the Bringer of Darkness and you are ... basically just a
rabbit, aren't you? OK, carry on, just a general ...
warning.

On 02/12/2020 23:46, Dave Cramer wrote:
> On Sun, 29 Nov 2020 at 14:09, Martin Goodson <kaemaril@googlemail.com>
> wrote:
> 
>> On 29/11/2020 18:46, David G. Johnston wrote:
>>> On Sun, Nov 29, 2020 at 11:06 AM Martin Goodson <kaemaril@googlemail.com
>>>
>>> wrote:
>>>
>>>> Hello.
>>>>
>>>> I wonder if anyone can assist with this?
>>>>
>>>> Some of my developers are reporting that they are getting the following
>>>> message when attempting to connect to the database using jdbc:
>>>>
>>>> Caused by: org.postgresql.util.PSQLException: Server versions prior to
>>>> 8.0 do not support savepoints
>>>>
>>>> at
>>>>
>>>>
>>>>
>> org.postgresql.jdbc3.AbstractJdbc3Connection.setSavepoint(AbstractJdbc3Connection.java:95)
>>>>
>>>> Database version is 10.5 running under RHEL 7.4. The postgreSQL jdbc
>>>> driver version they're employing is postgresl-42.2.9.
>>>>
>>>
>>> My best guess is that they are not actually running 42.2.9, they are
>>> running an older version that was released before PostgreSQL v10 came out
>>> and the version detection code doesn't recognize the new version format
>>> since 10.
>>>
>>> I didn't dig into this too deeply but I did download the zip for 42.2.9
>> and
>>> those classes don't even exist at that point since the build was re-done
>>> using pre-processors.
>>>
>>> David J.
>>>
>> Oh. That's very interesting. Thank you, David. I will chase up with the
>> developers tomorrow to confirm with them the version of the postgres
>> jdbc driver they are using.
>>
>> I'm no coder, it didn't occur to me to actually check with the source.
>> Nice one :)
>>
>> Many thanks.
>>
>> Regards,
>>
>> Martin.
>>
>> --
>> Martin Goodson
>>
>> Whatever you've got planned, forget it. I'm the Doctor.
>> I'm 904 years old. I'm from the planet Gallifrey in the
>> constellation of Kasterborous. I am The Oncoming Storm,
>> the Bringer of Darkness and you are ... basically just a
>> rabbit, aren't you? OK, carry on, just a general ...
>> warning.
>>
>>
> I'm guessing this is now resolved ?
> 
> 
> Dave Cramer
> www.postgres.rocks
> 
Technically no ... but probably yes.

On Monday I followed up on the ticket and was informed that they had 
made some changes to their code and the problem was no longer occurring ...

No detail was provided on what had been tweaked, unfortunately.

I plan on closing the ticket after a week.

-- 
Martin Goodson

Whatever you've got planned, forget it. I'm the Doctor.
I'm 904 years old. I'm from the planet Gallifrey in the
constellation of Kasterborous. I am The Oncoming Storm,
the Bringer of Darkness and you are ... basically just a
rabbit, aren't you? OK, carry on, just a general ...
warning.