Gabriel Roldan (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A54db8b09-1e64-436a-adac-248049585cee
) *created* an issue
GeoServer (
https://osgeo-org.atlassian.net/browse/GEOS?atlOrigin=eyJpIjoiYjJkNWU5ZTJhYWQwNDdlY2EzZDUzYjlkYWNmNTgyOTkiLCJwIjoiaiJ9
) / Bug (
https://osgeo-org.atlassian.net/browse/GEOS-10071?atlOrigin=eyJpIjoiYjJkNWU5ZTJhYWQwNDdlY2EzZDUzYjlkYWNmNTgyOTkiLCJwIjoiaiJ9
) GEOS-10071 (
https://osgeo-org.atlassian.net/browse/GEOS-10071?atlOrigin=eyJpIjoiYjJkNWU5ZTJhYWQwNDdlY2EzZDUzYjlkYWNmNTgyOTkiLCJwIjoiaiJ9
) GeoFence H2 configuration lost on abnormal server shutdown (
https://osgeo-org.atlassian.net/browse/GEOS-10071?atlOrigin=eyJpIjoiYjJkNWU5ZTJhYWQwNDdlY2EzZDUzYjlkYWNmNTgyOTkiLCJwIjoiaiJ9
)
Issue Type: Bug Affects Versions: 2.19.0 Assignee: Unassigned Created:
20/May/21 10:03 PM Priority: Medium Reporter: Gabriel Roldan (
https://osgeo-org.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A54db8b09-1e64-436a-adac-248049585cee
)
The currently used version of H2 database (1.1.119) does not survive abnormal
server shutdowns (e.g. kill process)
There have been other issues with it, like database corruption.
Despite not being the recommended set up, the default should at least provide
more consistency.
In the past, using a newer H2 version (e.g. 1.4.199) solved the problem, as the
database file format has been upgraded and is more robust.
The problem is, IIRC, it is incompatible with 1.1.x existing databases, and a
migration tool needs to be applied manually.
There's also a hint in the logs at startup that suggest an upgrade:
20 May 16:52:11 INFO [geoserver.geofence] - GeoFence configuration: instance
name is default-gs
20 May 16:52:12 WARN [ejb.Ejb3Configuration] - hibernate.connection.autocommit
= false break the EJB3 specification
20 May 16:52:12 WARN [dialect.H2Dialect] - The 1.1.119 version of H2 implements
temporary table creation such that it commits current transaction; multi-table,
bulk hql/jpaql will not work properly
20 May 16:52:12 WARN [dialect.H2Dialect] - The 1.1.119 version of H2 implements
temporary table creation such that it commits current transaction; multi-table,
bulk hql/jpaql will not work properly
(
https://osgeo-org.atlassian.net/browse/GEOS-10071#add-comment?atlOrigin=eyJpIjoiYjJkNWU5ZTJhYWQwNDdlY2EzZDUzYjlkYWNmNTgyOTkiLCJwIjoiaiJ9
) Add Comment (
https://osgeo-org.atlassian.net/browse/GEOS-10071#add-comment?atlOrigin=eyJpIjoiYjJkNWU5ZTJhYWQwNDdlY2EzZDUzYjlkYWNmNTgyOTkiLCJwIjoiaiJ9
)
Get Jira notifications on your phone! Download the Jira Cloud app for Android (
https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail
) or iOS (
https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8
) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100162-
sha1:3b69042 )
_______________________________________________
Geoserver-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/geoserver-devel
