"Server versions prior to 8.0 do not support savepoints" when using JDBC ...

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

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

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.