| Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver |
Hi Erik Merkle,
Is it possible for you to provide us with some of the information we requested below? Especially which version of Windows Server we should advise our customer to use with the GeoServer/GeoGig package.
Best regards
Erik Martinsen
Fra: geogig-dev-bounces@locationtec
h.org [mailto:geogig-dev-bounces@locationtech.org ] På vegne af Erik Martinsen
Sendt: 9. august 2017 03:19
Til: 'GeoGig project'
Cc: Allan Skouborg; ms@xxxxxxxxxx
Emne: Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver
Hi Erik,
Unfortunately installation of the geoserver.war file didn’t resolve the issues we have on the server our customer has delivered with Windows Server 2008. I then tried it on my local machine with Windows 10 and got things to work. We will now try to convince our customer that they need to update their server or make another one available with a newer Windows Server version. For help on that could you provide us with information about which OS the GeoServer/GeoGig package has been developed and tested with? And are there any other requirements regarding system specifications and/or version of software installations we should be aware of?
Best regards
Erik Martinsen
GIS developer
ARTOGIS a/s
Direct
Eltangvej 61
Mobile
DK-6000 Kolding
Phone
Fra: geogig-dev-bounces@locationtec
h.org [mailto:geogig-dev-bounces@locationtech.org ] På vegne af Erik Merkle
Sendt: 14. juli 2017 16:32
Til: GeoGig project
Cc: Allan Skouborg; ms@xxxxxxxxxx
Emne: Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver
Erik, Morten,
I'm sorry there has been so much back and forth with no resolution yet. I've looked at the logs you provided, but I don't see anything that indicates what the problem is.
I have taken the 2.10.0 community release of GeoServer (exact same version, build, git commit) that you are using, removed the PostgreSQL 9.1211 jarfile, and unpacked the plugin for GeoGig (with version 1.1.1 of GeoGig) and re-packaged the WAR. You can download it from the Boundless S3 bucket here: https://s3.amazonaws.com/bound
lessps-public/geoserver/gs- . It is structured the exact same as the Community release of GeoServer 2.10.0:geogig/geoserver-2.10.0-war. zip
Archive: geoserver-2.10.0-war.zip
Zip file size: 79279798 bytes, number of entries: 5
-rw-r--r-- 3.0 unx 79428780 bx defN 17-Jul-14 08:55 geoserver.war
-rw-r--r-- 3.0 unx 18008 tx defN 13-Sep-18 20:42 GPL.txt
-rw-r--r-- 3.0 unx 26610 tx defN 16-Aug-13 01:24 LICENSE.txt
drwxr-xr-x 3.0 unx 0 bx stor 16-Oct-28 09:52 target/
-rw-r--r-- 3.0 unx 333 tx defN 16-Oct-28 09:42 target/VERSION.txt
5 files, 79473731 bytes uncompressed, 79279024 bytes compressed: 0.2%If you could try removing your current geoserver deployment (copy it some place safe if you have data in it you can't easily reproduce) and replace it with the one I linked and let us know if you still have issues, it would be greatly appreciated. You may have a "geoserver.war" file and a "geoserver" folder in your Tomcat "webapps" folder. Remove/backup both if you have them before deploying the WAR above.
If it resolves the issues, maybe try to do a diff between the jarfiles in your current deployment and the ones in the WAR I've provided to see if anything is missing or different, that may indicate where the problem is. If it does not resolve your issue, if you could try it one another system (different OS) to see if it works there.
Again, sorry it's taken this long with no solution yet,
Erik Merkle
On Fri, Jul 14, 2017 at 3:01 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote:
Hi Erik,
We have checked the permissions on files in the lib folder and they all have the same settings. We have then restarted the GeoServer and reproduced the issue.
The GeoServer logs generated after restart are attached in the compressed file TomCat_logs.2017-07-14.abc. After detachment the file extension should be changed to .zip.
I will by the end of this day start a vacation over the next three weeks J So I would ask you to include my colleague Morten Storm (email: ms@xxxxxxxxxx) in emails following this one.
Best regards
Erik Martinsen
GIS developer
ARTOGIS a/s
Direct
Eltangvej 61
Mobile
DK-6000 Kolding
Phone
Fra: geogig-dev-bounces@locationtec
h.org [mailto:geogig-dev-bounces@locationtech.org ] På vegne af Erik Merkle
Sendt: 13. juli 2017 16:02
Til: GeoGig project
Emne: Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver
Erik,
I don't have access to a Windows Server 2012 or 2008 system, but I have tried on Windows 7 with the same GeoServer 2.10.0 you have (same commit and build date), and the 1.1.1 plugin from here: https://github.com/locationtec
h/geogig/releases/download/v1. . I was able to create RocksDB backed repos with that combination fine. The only thing I had to do was remove the postgresql-9.4.1211.jar as the plugin is bundled with the newer 42.1.1 version.1.1/geoserver-2.10.x-geogig- plugin.zip I tried to reproduce the problem, but the only way I can get a NoClassDefFound exception is if the rocksdbjni jarfile is missing, as Gabriel said. Either version should work (4.13.4 or 4.13.5).
Is it possible there are security/permissions issues with the rocksdbjni jarfile? I'd find that odd since it should have the same permissions as the rest of the files in the plugin. But I can't think of anything else that would cause that specific error. Somehow, GeoServer and GeoGig can't find a jarfile with that class defined in it, and it is defined in rocksdbjni. Could you provide the GeoServer logs (Tomcat catalina log) that includes the full startup logs up to the exception? Maybe there's something else going on that I can't think of.
Erik Merkle
On Thu, Jul 13, 2017 at 4:56 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote:
Hi Gabriel and Erik,
Thank you for your replies.
From our side we have tested different things in order to have the GeoGig GeoServer 2.10 plugin working:
· Ensuring that only one JAR file is present of the ones where geogig is part of the file naming.
· Tried to use rocksdbjni-4.13.5.jar instead of the rocskdbjni-4.13.4.jar delivered with the zip file.
· Upgrading the Java installation on the server from 1.8.0_72-b15 to 1.8.0_131-b11.
However we are still not able to create file based GeoGig repositories.
We know we earlier got the plugin to work on a Windows Server 2012 and are now trying to obtain the same on a Windows Server 2008. But since it is a server delivered by our customer it will be difficult for us to upgrade regarding OS server version.
Best regards
Erik Martinsen
GIS developer
ARTOGIS a/s
Direct
Eltangvej 61
Mobile
DK-6000 Kolding
Phone
Fra: geogig-dev-bounces@locationtec
h.org [mailto:geogig-dev-bounces@locationtech.org ] På vegne af Gabriel Roldan
Sendt: 13. juli 2017 02:52
Til: GeoGig project
Cc: Carsten Rossau Christiansen
Emne: Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver
It looks like the missing jar is rocksdbjni-4.13.5.jar
It definitely is in the geoserver-2.10.x-geogig-pl
ugin.zip archive. May you have accidentally removed it from geoserver's WEB-INF/lib?
On Wed, Jul 12, 2017 at 12:21 PM, Erik Merkle <emerkle@xxxxxxxxxxxxxxxx> wrote:
Erik,
That error is strange as it would normally indicate either a missing JAR, or multiple class definitions on the classpath. I'll try to reproduce this on my end.
Could you double check that, when using this plugin:
https://github.com/locationtech/geogig/releases/download/v1. 1.1/geoserver-2.10.x-geogig- plugin.zip you only have 1 JAR file for each of the "geogig" jars. I'm wondering if you might have older GeoGig jar files mixed with the 1.1.1 release versions. For example, you should only have:
geogig-rocksdb-1.1.1.jar
and not have:
geogig-rocksdb-1.1-SNAPSHOT.ja
r or any of the RC release candidate versions:
geogig-rocksdb-1.1.1-RC1.jar, geogig-rocksdb-1.1.1-RC2.jar, geogig-rocksdb-1.1.1-RC3.jar, or geogig-rocksdb-1.1.1-RC4.jar
If you only have one jar, the issue should be easy to reproduce on my end. For now, I've created an issue ticket here to track it:
https://github.com/locationtech/geogig/issues/353
Thanks for reporting the issue,
-
Erik Merkle
On Wed, Jul 12, 2017 at 8:49 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote:
Hi Erik,
We have now tried to install the build of the GeoServer 2.10 plugin provided in your link on a GeoServer with the following information:
GeoServer 2.10 is installed on a Tomcat server with the following configuration:
Server Information
Tomcat Version
JVM Version
JVM Vendor
OS Name
OS Version
OS Architecture
Hostname
IP Address
Apache Tomcat/9.0.0.M1
1.8.0_72-b15
Oracle Corporation
Windows Server 2008 R2
6.1
amd64
VF-GIS02
10.15.1.16
We have removed the PostgreSQL driver postgresql-9.4.1211.jar before installing the GeoServer 2.10 plugin.
The GeoGig menu items in the left side loads as expected after restarting the GeoServer but when we try to create a file based GeoGig repository we get an error of this kind “Could not initialize class org.rocksdb.RocksDB” (further information is included in the attached file java_errors.txt).
We have also tried to install the GeoServer 2.10 plugin from this link: https://github.com/locationtec
h/geogig/releases/download/v1. but unfortunately with the same result.1.1/geoserver-2.10.x-geogig- plugin.zip
Do you know the cause of this issue or a workaround?
Best regards
Erik Martinsen
GIS developer
ARTOGIS a/s
Direct
Eltangvej 61
Mobile
DK-6000 Kolding
Phone
Fra: geogig-dev-bounces@locationtec
h.org [mailto:geogig-dev-bounces@locationtech.org ] På vegne af Erik Merkle
Sendt: 29. juni 2017 15:31
Til: GeoGig project
Emne: Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver
Erik,
The latest GeoServer 2.10 plugin build is here:
http://ares.boundlessgeo.com/geoserver/2.10.x/community-late st/geoserver-2.10-SNAPSHOT- geogig-plugin.zip Be aware, there is an updated PostgreSQL driver bundled in the plugin (version 42.1.1) and it will conflict with the PostgreSQL driver that comes with GeoServer 2.10. If you chose to use the nightly plugin build, you will have to remove the older PostgreSQL driver currently in your GeoServer install (likely postgresql-9.4.1211.jar).
Regards,
Erik Merkle
Software Engineer | Boundless
On Thu, Jun 29, 2017 at 12:46 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote:
Hi Gabriel,
Thank you for the information. Is it possible for you to provide a similar link to the latest build of the GeoServer 2.10 plugin? Or do you know when this plugin will be released in final mode?
We have yesterday tested the build we can download from this link https://github.com/locationtec
h/geogig/releases/download/v1. . It solves some of our problems but we still cannot load the GeoGig repositories after restart of the GeoServer.1.1-RC1/geoserver-2.10- SNAPSHOT-geogig-plugin.zip
Best regards
Erik Martinsen
GIS developer
ARTOGIS a/s
Direct
Eltangvej 61
Mobile
DK-6000 Kolding
Phone
Fra: geogig-dev-bounces@locationtec
h.org [mailto:geogig-dev-bounces@locationtech.org ] På vegne af Gabriel Roldan
Sendt: 27. juni 2017 19:00
Til: GeoGig project
Emne: Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver
Hello,
just a heads that this bug has been fixed and will be released with 1.1.1.
while we wait for 1.1.1 final to come out, you can get the fix from the latest nightly build [1]
Cheers,
Gabriel
On Wed, Jun 21, 2017 at 4:57 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote:
Hi Erik,
Yes, usually we create the GeoGig repository from the GeoServer UI. But we have now tried to create a repository directly from the GeoGig plugin in QGIS.
From QGIS we access the GeoServer using this URL
So the URL to the repository is like in your example: http://server3x2:8082/geoserve
r/geogig/repos/EMA_REPOS_2/ In QGIS the GeoGig plugin is configured with user name and email:
Even though we create the repository directly from QGIS and GeoGig configured with user name and email the first time we try to add a layer to the repository we get this error:
We have tried to configure globally through command line but we have manually to edit the local repository config file on the server by adding these lines:
The repository then works as expected.
After restart of the GeoServer ensuring no QGIS sessions is running that are connected to the repository (so only one single process) the access to the repository from QGIS afterward fails with the following error:
2017-06-21T09:48:13 0 QGIS starter...
2017-06-21T09:48:14 0 Python-understøttelse SLÅET TIL :-)
2017-06-21T09:50:01 0 Application state:
QGIS_PREFIX_PATH env var: C:/PROGRA~2/QGIS2~1.18/apps/qg
is Prefix: C:/PROGRA~2/QGIS2~1.18/apps/qg
is Plugin Path: C:/PROGRA~2/QGIS2~1.18/apps/qg
is/plugins Package Data Path: C:/PROGRA~2/QGIS2~1.18/apps/qg
is/. Active Theme Name: default
Active Theme Path: C:/Users/erik.martinsen/.qgis2
///themes\default\icons/ Default Theme Path: :/images/themes/default/
SVG Search Paths: C:/PROGRA~2/QGIS2~1.18/apps/qg
is/./svg/ C:/Users/erik.martinsen/.qgis2
//svg/ User DB Path: C:/PROGRA~2/QGIS2~1.18/apps/qg
is/./resources/qgis.db Auth DB Path: C:/Users/erik.martinsen/.qgis2
//qgis-auth.db 2017-06-21T09:50:01 0 QGIS er klar!
2017-06-21T09:50:23 2 An error occurred while fetching repository data! 500 Server Error: for url: http://server3x2:8082/geoserve
r/geogig/repos/EMA_REPOS_2/ls- tree?path=HEAD&output_format= json&_onlyTrees_=True
Best regards
Erik Martinsen
GIS developer
ARTOGIS a/s
Direct
Eltangvej 61
Mobile
DK-6000 Kolding
Phone
Fra: geogig-dev-bounces@locationtec
h.org [mailto:geogig-dev-bounces@locationtech.org ] På vegne af Erik Merkle
Sendt: 20. juni 2017 16:38
Til: GeoGig project
Emne: Re: [geogig-dev] Loading of GeoGig repositories fails after restart of Geoserver
Hi Erik,
C
an you clarify a few things for me?
It sounds like your GeoGig repository is created via GeoServer, correct?
Then you are accessing the repository via QGIS. I'm assuming you are using the GeoGig plugin in QGIS to connect. If so, are you exposing the repository via command line "geogig serve", or are you accessing the repository as exposed via GeoServer (using a URL similar to http://localhost/geoserver/geo
gig/repos/myRepo )?The error you are seeing may be related to one of a couple of issues that have been raised:
https://github.com/locationtech/geogig/issues/302
https://github.com/locationtech/geogig/issues/309 The problem with issue #309 is that there are 2 processes trying to access a single RocksDB database at the same time. Currently, the RocksDB integration in GeoGig is such that GeoGig will maintain an exclusive lock on the RocksDB database as long as the repository remains open in a given process. This means that GeoServer can serve out the repository, or "geogig serve" from the command line can serve out the repository, but not both at the same time. I suspect this may be the issue, if you have a QGIS session open and connected to the repository (via geogig serve), and then you try to restart GeoServer, which will try to open the repository as well.
If this is not the case, that is you only have a single process accessing the repository, then it may be related to issue #302, or it may be a new issue we have not come across.
If you would, could you please reply back and let us know if your issue is being caused by more than one process trying to access the database. If that is not the issue, we can collect more details and open a new ticket in GitHub.
Many thanks,
Erik Merkle
Software Engineer | Boundless
On Tue, Jun 20, 2017 at 12:25 AM, Erik Martinsen <ema@xxxxxxxxxx> wrote:
Hi,
We are testing GeoGig on a Windows Server 2012R2 with GeoServer 2.10.0. The server is installed with Java version 1.8.0_121. After creating file based GeoGig repositories we access them from QGIS Desktop 2.18.2.
From QGIS we can successfully add new layers to the repositories and make layer versioning and merging in master and branches.
However after a restart of the GeoServer the repositories fails with an error message of the following type for one and each of them when we try to access them from QGIS:
2017-06-19 13:39:31,954 WARN [geoserver.config] - Error loading GeoGig repository instance for id 5f646e20-aaee-4cd5-8f35-92045e
d9c831 java.lang.RuntimeException: org.rocksdb.RocksDBException: ×
Further details is available from the attached geoserver.log file.
After restart of the GeoServer we can create a new repository that will be operating as expected until next time the GeoServer is restarted.
Are there some kind of close down or start up procedure for the GeoServer we are not aware of?
Best regards
Erik Martinsen
GIS developer
ARTOGIS a/s
Direct
Eltangvej 61
Mobile
DK-6000 Kolding
Phone
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
--
Gabriel Roldán
Software Developer | Boundless
groldan@xxxxxxxxxxxxxxxx
@boundlessgeo
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
--
Gabriel Roldán
Software Developer | Boundless
groldan@xxxxxxxxxxxxxxxx
@boundlessgeo
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
_______________________________________________
geogig-dev mailing list
geogig-dev@xxxxxxxxxxxxxxxx
To change your delivery options, retrieve your password, or unsubscribe from this list, visit
https://dev.locationtech.org/mailman/listinfo/geogig-dev
