Exception when loading GeoPackage file

[anonymous]

What steps will reproduce the problem?

1. Download "distrikt" or "soknstad" open datasets from the Swedish Mapping Authority. The two files are available on this link: ​https://www.jottacloud.com/s/0594cf677d57f604a79b0c8a96f2ecd908f
2. Load into JOSM. Use last version and updated plugins.

What is the expected result?

Data loaded and displayed in JOSM

What happens instead?

"An unexpected exception occurred".

Please provide any additional information below. Attach a screenshot if possible.

Revision:19307
Build-Date:2025-02-04 10:33:54

Identification: JOSM/1.5 (19307 en_GB) Mac OS X 14.7
OS Build number: macOS 14.7 (23H124)
Memory Usage: 880 MB / 18432 MB (177 MB allocated, but free)
Java version: 21.0.6+7-LTS, Azul Systems, Inc., OpenJDK 64-Bit Server VM
Look and Feel: com.apple.laf.AquaLookAndFeel
Screen: Display 1 1710x1107x32bpp@60Hz (scaling 2.00×2.00)
Maximum Screen Size: 1710×1107
Best cursor sizes: 16×16→16×16, 32×32→32×32
System property file.encoding: UTF-8
System property sun.jnu.encoding: UTF-8
Locale info: en_GB
Numbers with default locale: 1234567890 -> 1234567890
VM arguments: [-Djpackage.app-version=19307, -XX:MaxRAMPercentage=75.0, --add-modules=java.scripting,java.sql,javafx.controls,javafx.media,javafx.swing,javafx.web, --add-exports=java.base/sun.security.action=ALL-UNNAMED, --add-exports=java.desktop/com.apple.eawt=ALL-UNNAMED, --add-exports=java.desktop/com.sun.imageio.plugins.jpeg=ALL-UNNAMED, --add-exports=java.desktop/com.sun.imageio.spi=ALL-UNNAMED, --add-opens=java.base/java.lang=ALL-UNNAMED, --add-opens=java.base/java.nio=ALL-UNNAMED, --add-opens=java.base/jdk.internal.loader=ALL-UNNAMED, --add-opens=java.base/jdk.internal.ref=ALL-UNNAMED, --add-opens=java.desktop/javax.imageio.spi=ALL-UNNAMED, --add-opens=java.desktop/javax.swing.text.html=ALL-UNNAMED, --add-opens=java.prefs/java.util.prefs=ALL-UNNAMED, -Djpackage.app-path=/Applications/JOSM.app/Contents/MacOS/JOSM]

Plugins:
+ apache-commons (36379)
+ conflation (259)
+ ejml (36379)
+ geotools (36379)
+ imagery-xml-bounds (36379)
+ jackson (36379)
+ jaxb (36379)
+ jts (36379)
+ opendata (36379)
+ todo (145)
+ utilsplugin2 (36379)

Map paint styles:
- https://josm.openstreetmap.de/josmfile?page=Styles/Enhanced_Lane_and_Road_Attributes&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Styles/Lane_and_Road_Attributes&zip=1

Last errors/warnings:
- 00054.172 E: Handled by bug report queue: java.lang.RuntimeException: Unable to obtain connection: batch entry 1: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database). Cause: java.sql.BatchUpdateException: batch entry 1: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database). Cause: org.sqlite.SQLiteException: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)



=== REPORTED CRASH DATA ===
BugReportExceptionHandler#handleException:
No data collected.

Warning issued by: BugReportExceptionHandler#handleException

=== STACK TRACE ===
Thread: main-worker-0 (36) of main
java.lang.RuntimeException: Unable to obtain connection: batch entry 1: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)
	at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:2343)
	at org.geotools.jdbc.JDBCDataStore.createTypeNames(JDBCDataStore.java:975)
	at org.geotools.data.store.ContentDataStore.getTypeNames(ContentDataStore.java:261)
	at org.openstreetmap.josm.plugins.opendata.core.io.geographic.GeotoolsConverter.convert(GeotoolsConverter.java:79)
	at org.openstreetmap.josm.plugins.opendata.core.io.geographic.geopackage.GeoPackageReader.parse(GeoPackageReader.java:59)
	at org.openstreetmap.josm.plugins.opendata.core.io.geographic.geopackage.GeoPackageReader.parseDataSet(GeoPackageReader.java:44)
	at org.openstreetmap.josm.plugins.opendata.core.io.geographic.geopackage.GeoPackageImporter.parseDataSet(GeoPackageImporter.java:26)
	at org.openstreetmap.josm.gui.io.importexport.OsmImporter.loadLayer(OsmImporter.java:121)
	at org.openstreetmap.josm.gui.io.importexport.OsmImporter.importData(OsmImporter.java:97)
	at org.openstreetmap.josm.plugins.opendata.core.io.AbstractImporter.importData(AbstractImporter.java:59)
	at org.openstreetmap.josm.gui.io.importexport.FileImporter.importDataHandleExceptions(FileImporter.java:103)
	at org.openstreetmap.josm.actions.OpenFileAction$OpenFileTask.importData(OpenFileAction.java:426)
	at org.openstreetmap.josm.actions.OpenFileAction$OpenFileTask.realRun(OpenFileAction.java:354)
	at org.openstreetmap.josm.gui.PleaseWaitRunnable.doRealRun(PleaseWaitRunnable.java:94)
	at org.openstreetmap.josm.gui.PleaseWaitRunnable.run(PleaseWaitRunnable.java:142)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.base/java.util.concurrent.FutureTask.run(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.base/java.lang.Thread.run(Unknown Source)
Caused by: java.sql.BatchUpdateException: batch entry 1: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)
	at org.sqlite.jdbc3.JDBC3Statement.executeLargeBatch(JDBC3Statement.java:235)
	at org.sqlite.jdbc3.JDBC3Statement.executeBatch(JDBC3Statement.java:215)
	at org.geotools.jdbc.util.SqlUtil.runScript(SqlUtil.java:157)
	at org.geotools.geopkg.GeoPackage.runScript(GeoPackage.java:1824)
	at org.geotools.geopkg.GeoPackage.init(GeoPackage.java:329)
	at org.geotools.geopkg.GeoPkgDialect.initializeConnection(GeoPkgDialect.java:117)
	at org.geotools.jdbc.JDBCDataStore.createConnection(JDBCDataStore.java:2333)
	... 19 more
Caused by: org.sqlite.SQLiteException: [SQLITE_READONLY] Attempt to write a readonly database (attempt to write a readonly database)
	at org.sqlite.core.DB.newSQLException(DB.java:1179)
	at org.sqlite.core.DB.newSQLException(DB.java:1190)
	at org.sqlite.core.DB.execute(DB.java:988)
	at org.sqlite.core.DB.executeUpdate(DB.java:1054)
	at org.sqlite.jdbc3.JDBC3Statement.executeLargeBatch(JDBC3Statement.java:232)
	... 25 more

[stoecker]

Geotools bug? Why does getTypeNames() call a createTypeNames() function?

[GerdP]

Yes, looks suspicious. Maybe the code tries to create the result as a temporary table?

[GerdP]

Looks like a duplicate of #24025 (similar stack trace)