﻿id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc
24025	Error while opening .gpkg file	bartosomail@…	team	"==== What steps will reproduce the problem?
1. The error occurs during the opening of .gpkg file (attached).
2. 
3. 

==== 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
}}}
"	defect	new	normal		Plugin opendata	latest		template_report	
