Error while opening .gpkg file

[bartosomail@…]

What steps will reproduce the problem?

1. The error occurs during the opening of .gpkg file (attached).

What is the expected result?

Open file

What happens instead?

Error. Attempt to write a readonly database

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

Relative:URL: ^/trunk
Repository:UUID: 0c6e7542-c601-0410-84e7-c038aed88b3b
Last:Changed Date: 2024-11-15 17:20:57 +0100 (Fri, 15 Nov 2024)
Revision:19259
Build-Date:2024-11-16 02:30:36
URL:https://josm.openstreetmap.de/svn/trunk

Identification: JOSM/1.5 (19259 en_GB) Windows 10 64-Bit
OS Build number: Windows 10 Home 22H2 (19045)
Memory Usage: 720 MB / 4068 MB (99 MB allocated, but free)
Java version: 21.0.2+13-LTS, Azul Systems, Inc., OpenJDK 64-Bit Server VM
Look and Feel: com.sun.java.swing.plaf.windows.WindowsLookAndFeel
Screen: \Display0 3840x2160x32bpp@60Hz (scaling 2.50×2.50)
Maximum Screen Size: 3840×2160
Best cursor sizes: 16×16→64×64, 32×32→64×64
System property file.encoding: UTF-8
System property sun.jnu.encoding: Cp1252
Locale info: en_GB
Numbers with default locale: 1234567890 -> 1234567890

Plugins:
+ Mapillary (1778)
+ QuickLabel (23)
+ SimplifyArea (36344)
+ apache-commons (36349)
+ apache-http (36349)
+ centernode (v1.0.4)
+ editgpx (36349)
+ ejml (36348)
+ geotools (36349)
+ jackson (36349)
+ jaxb (36349)
+ jna (36349)
+ jts (36349)
+ measurement (36350)
+ merge-overlap (36344)
+ opendata (36343)
+ photo_geotagging (36343)
+ photoadjust (36342)
+ reltoolbox (36344)
+ reverter (36343)
+ rex (53)
+ undelete (36349)
+ utilsplugin2 (36350)
+ wikipedia (418)

Tagging presets:
+ D:\OSM\JOSM\presets\cai_josm_preset-master\cai.xml
+ https://josm.openstreetmap.de/josmfile?page=Presets/Mountains&zip=1
+ https://josm.openstreetmap.de/josmfile?page=Presets/ParkingLanes&zip=1
+ https://raw.githubusercontent.com/yopaseopor/traffic_signs_preset_JOSM/master/CH.zip
+ https://raw.githubusercontent.com/yopaseopor/traffic_signs_preset_JOSM/master/IT.zip

Map paint styles:
+ https://josm.openstreetmap.de/josmfile?page=Styles/DestinationSignRelation&zip=1
+ https://raw.githubusercontent.com/species/josm-preset-traffic_sign_direction/master/direction.mapcss
- https://josm.openstreetmap.de/josmfile?page=Styles/Osmc&zip=1
- https://josm.openstreetmap.de/josmfile?page=Styles/MaxspeedIcons&zip=1
+ https://raw.githubusercontent.com/yopaseopor/traffic_signs_style_JOSM/master/Styles_Traffic_signs_EUR.zip
+ https://josm.openstreetmap.de/josmfile?page=Styles/ParkingLanes&zip=1

Last errors/warnings:
- 00000.596 W: extended font config - overriding 'filename.Malgun_Gothic=malgun.ttf' with 'MALGUN.TTF'
- 00000.597 W: extended font config - overriding 'filename.Myanmar_Text=mmrtext.ttf' with 'MMRTEXT.TTF'
- 00000.598 W: extended font config - overriding 'filename.Mongolian_Baiti=monbaiti.ttf' with 'MONBAITI.TTF'
- 00120.003 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 (33) 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:77)
	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(Executors.java:572)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:317)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
	at java.base/java.lang.Thread.run(Thread.java:1583)
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

[kaitu <bartosomail@…>]

Couldn't attach the file (too big)
It's available here:

​https://www.dropbox.com/scl/fi/kxvgxfta460l505g0dqis/base_dbt_per_pianificazione.gpkg?rlkey=ifp9zu36hkbz7yb7vustpls5l&st=9oqxoqib&dl=0

[stoecker]

Ticket #24131 has been marked as a duplicate of this ticket.