Dear Jody and Hans,
Thanks a lot for your answers.
You nailed it properly both of you. There was a conflict between two
postgres jdbc drivers.
One was under tomcat/lib and a new one was added under
tomcat/webapps/geoserver/WEB-INF/lib when I made the upgrade.
Again thank you for your help, it would have taken me ages to find that...
Have a good evening,
Nicolas
On 7/02/23 19:20, Hans Yperman wrote:
I see a few ways forward:
1. in the geoserver logs , you should be able to find the complete
stack trace, of which this is only a part. Can you paste that here?
2. There is a suspicious class org.postgis.PGbox2d in there. Maybe
the postgres server has also been upgraded, and the postgis
extension is missing?
3. You have some kind of class loader conflict, e.g. 2 different
postgres jdbc drivers. For tomcat: Can you tell which files
postgresql*.* exist under tomcat/lib and under
tomcat/webapps/geoserver/WEB-INF/lib . There should be only 1.
*Hans Yperman*
Department IT
*Vlaams Instituut voor de Zee vzw*
InnovOcean Campus, Jacobsenstraat 1
8400 Oostende, België
☎+32 (0) 59 33 61 13
📧hans.yper...@vliz.be
*www.vliz.be
<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.vliz.be%2F&data=05%7C01%7Cndeville%40naturalsciences.be%7Cecbf64684eba4599040608db09380764%7C4da8d35db472419c9e15665786aadbfb%7C1%7C0%7C638113908498099523%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=rg18OBiDpiI%2Fgn%2BewtrJDFrEvHp6CF82SGafkoMalls%3D&reserved=0>***
------------------------------------------------------------------------
*Van:* Nicolas De Ville De Goyet <ndevi...@naturalsciences.be>
*Verzonden:* dinsdag 7 februari 2023 15:09
*Aan:* GeoServer Mailing List List <geoserver-users@lists.sourceforge.net>
*Onderwerp:* [Geoserver-users] Failing Postgis store when upgrading
geoserver to 2.22.1
Dear,
I upgraded my geoserver instance to 2.22.1 and it created issues with
all my postgis stores.
https://spatial.naturalsciences.be/
The previous version I had is 2.19.2
Now, when I try to connect/download my layers I get the following error
message:
version="1.1.1" > <ServiceException>
java.lang.reflect.UndeclaredThrowableExceptionUnable to obtain
connection: Cannot create PoolableConnectionFactory (Something unusual
has occurred to cause the driver to fail. Please report this exception.)
Cannot create PoolableConnectionFactory (Something unusual has occurred
to cause the driver to fail. Please report this exception.)
Something unusual has occurred to cause the driver to fail. Please
report this exception.
class org.postgis.PGbox2d
The other type of data (GeoTiff, shapefiles, ...) are working as expected.
Do you have an idea on the reason of such an issue?
Many thanks for your help,
Nicolas de Ville
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting
to this list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.ianturton.com%2Ftalks%2Ffoss4g.html%23%2F&data=05%7C01%7Cndeville%40naturalsciences.be%7Cecbf64684eba4599040608db09380764%7C4da8d35db472419c9e15665786aadbfb%7C1%7C0%7C638113908498099523%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=bsiGoPGkrMNBPuFN2c1ZmXv8ZnDcj2opCnPVol658Jw%3D&reserved=0>
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
<https://eur02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgeoserver.org%2Fcomm%2Fuserlist-guidelines.html&data=05%7C01%7Cndeville%40naturalsciences.be%7Cecbf64684eba4599040608db09380764%7C4da8d35db472419c9e15665786aadbfb%7C1%7C0%7C638113908498099523%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=SkcFthcOCI7zcOUmslTbM2LObcIWsi8ve2%2BBoGdAeSA%3D&reserved=0>
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fgeoserver%2Fgeoserver%2Fwiki%2FSuccessfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer&data=05%7C01%7Cndeville%40naturalsciences.be%7Cecbf64684eba4599040608db09380764%7C4da8d35db472419c9e15665786aadbfb%7C1%7C0%7C638113908498099523%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=kFtKmv4Aipw3uKQUhgv82DEmmPRWoaEgERt8tfoxMOM%3D&reserved=0>
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
<https://eur02.safelinks.protection.outlook.com/?url=https%3A%2F%2Flists.sourceforge.net%2Flists%2Flistinfo%2Fgeoserver-users&data=05%7C01%7Cndeville%40naturalsciences.be%7Cecbf64684eba4599040608db09380764%7C4da8d35db472419c9e15665786aadbfb%7C1%7C0%7C638113908498255750%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C3000%7C%7C%7C&sdata=G08xXD5BA9XnPa7TrKjSi6TieZW2mJ1W6csU6pXTu0E%3D&reserved=0>
_______________________________________________
Geoserver-users mailing list
Please make sure you read the following two resources before posting to this
list:
- Earning your support instead of buying it, but Ian Turton:
http://www.ianturton.com/talks/foss4g.html#/
- The GeoServer user list posting guidelines:
http://geoserver.org/comm/userlist-guidelines.html
If you want to request a feature or an improvement, also see this:
https://github.com/geoserver/geoserver/wiki/Successfully-requesting-and-integrating-new-features-and-improvements-in-GeoServer
Geoserver-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/geoserver-users
