Page 1 of 1

Database writer issue writing to database on nfs share

Posted: Wed Nov 10, 2021 3:27 pm
by mw0jni
I am trying to get vrs to write to a database on a nfs share to save writes on my sd card. However I get the following error in my logs -

Database writer plugin caught exception on starting session: Mono.Data.Sqlite.SqliteException (0x80004005): Attempt to write a read-only database
attempt to write a readonly database
at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement stmt) [0x00096] in <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement stmt) [0x00046] in <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00129] in <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SqliteDataReader..ctor (Mono.Data.Sqlite.SqliteCommand cmd, System.Data.CommandBehavior behave) [0x00051] in <fe9fd999cd9f407db94500dce293e66f>:0
at (wrapper remoting-invoke-with-check) Mono.Data.Sqlite.SqliteDataReader:.ctor (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (System.Data.CommandBehavior behavior) [0x00006] in <fe9fd999cd9f407db94500dce293e66f>:0
at Mono.Data.Sqlite.SqliteCommand.ExecuteScalar () [0x00000] in <fe9fd999cd9f407db94500dce293e66f>:0
at Dapper.SqlMapper.ExecuteScalarImpl[T] (System.Data.IDbConnection cnn, Dapper.CommandDefinition& command) [0x0005f] in <63a8cc06dfb842f1823bc51677815d4b>:0
at Dapper.SqlMapper.ExecuteScalar[T] (System.Data.IDbConnection cnn, System.String sql, System.Object param, System.Data.IDbTransaction transaction, System.Nullable`1[T] commandTimeout, System.Nullable`1[T] commandType) [0x00018] in <63a8cc06dfb842f1823bc51677815d4b>:0
at VirtualRadar.Database.BaseStation.Database.Sessions_Insert (VirtualRadar.Interface.Database.BaseStationSession session) [0x00013] in <bd87b900823240ceba9d05dac1faa3a5>:0
at VirtualRadar.Database.BaseStation.Database.InsertSession (VirtualRadar.Interface.Database.BaseStationSession session) [0x0005e] in <bd87b900823240ceba9d05dac1faa3a5>:0
at VirtualRadar.Plugin.BaseStationDatabaseWriter.Plugin.StartSession () [0x001e1] in <c140d3fa747f4ab9859dfef52fdd3f52>:0

the database is a copy of the one on my rpi sd card - the nfs share has read write access to everyone.

anyone have any ideas of what I can do to solve this.

Thanks in advance

Re: Database writer issue writing to database on nfs share

Posted: Thu Nov 18, 2021 10:00 am
by mw0jni
I now appear to have resolved this. I have have reimaged my sd card with the latest piaware 6.1 sd image and it is now writing to the nfs share database.