Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

SQLITE BUSY during geopackage conversion #17

Open
fabcg opened this issue Jan 31, 2022 · 0 comments
Open

SQLITE BUSY during geopackage conversion #17

fabcg opened this issue Jan 31, 2022 · 0 comments

Comments

@fabcg
Copy link

fabcg commented Jan 31, 2022

Hello!

When trying to convert a shape file to geopackage, we get the following error :

ERROR - 2022-01-31 09:44:22 - org.apache.struts2.dispatcher.DefaultDispatcherErrorHandler - Exception occurred during processing request: Unable to obtain connection: batch entry 0: [SQLITE_BUSY] The database file is locked (database is locked)
java.lang.RuntimeException: Unable to obtain connection: batch entry 0: [SQLITE_BUSY] The database file is locked (database is locked)
at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:2147) ~[gt-jdbc-26.1.jar:?]
at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:934) ~[gt-jdbc-26.1.jar:?]
at org.geotools.data.store.ContentDataStore.entry(ContentDataStore.java:509) ~[gt-main-26.1.jar:?]
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:719) ~[gt-jdbc-26.1.jar:?]
at org.geotools.jdbc.JDBCDataStore.createSchema(JDBCDataStore.java:144) ~[gt-jdbc-26.1.jar:?]
at eu.europa.ec.eurostat.jgiscotools.io.geo.GeoData$GPKGHandler.save(GeoData.java:205) ~[jgiscotools-geo-io-0.9.21.jar:?]

For information, we get no problem when converting into local server (on windows), but we can't generate the file on unix servers. Not sure it helps...

We've only launched :
....
CoordinateReferenceSystem crs = GeoData.getCRS(filePathIn);
Collection featuresSHP = GeoData.getFeatures(filePathIn);
GeoData.save(featuresSHP, filePathOut, crs);

Can you help?
Thanks

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant