0008323: SQLLite "Library used incorrectly" Multiple errors

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0008323

opensim

[REGION] OpenSim Core

public

2018-05-26 09:46

2018-05-26 10:41

Reporter

claudio

Assigned To

Priority

normal

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

x86_64

Operating System

Linux Mint

Operating System Version

18.3 MATE 64-bit

Product Version

0.9.0

Target Version

Fixed in Version

Summary

0008323: SQLLite "Library used incorrectly" Multiple errors

Description

Hello, I am trying out some stock OAR in a local installation.

Things more or less work, but I experience some random corruption in my regions, after loading a Free Mall OAR and I noticed red SQLlite messages in my terminal which all have this in common:

Library used incorrectly
library routine called out of sequence

I have 3 errors like this. This is the first error, happening at regular intervals in the OAR Free Shopping Mall 2 :

7:43:18 - [EVENT MANAGER]: Delegate for TriggerLandObjectAdded failed - continuing. Library used incorrectly
library routine called out of sequence at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors (System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) <0x4170b570 + 0x002ab> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.UpdatedRowStatus (System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) <0x413dfdc0 + 0x00087> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[] dataRows, System.Data.Common.DataTableMapping tableMapping) <0x413dbb40 + 0x01513> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.UpdateFromDataTable (System.Data.DataTable dataTable, System.Data.Common.DataTableMapping tableMapping) <0x413db310 + 0x00052> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.Update (System.Data.DataSet dataSet, System.String srcTable) <0x413da930 + 0x0014b> in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Update (System.Data.DataSet,string)
  at OpenSim.Data.SQLite.SQLiteSimulationData.Commit () <0x413da670 + 0x0007f> in <filename unknown>:0
  at OpenSim.Data.SQLite.SQLiteSimulationData.StoreLandObject (ILandObject parcel) <0x413d6250 + 0x007f7> in <filename unknown>:0
  at OpenSim.Services.SimulationService.SimulationDataService.StoreLandObject (ILandObject Parcel) <0x413d61d0 + 0x00027> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.EventManager.TriggerLandObjectAdded (ILandObject newParcel) <0x413d6050 + 0x000b4> in <filename unknown>:0

This is instead an error I get when trying to create a new region with region create:

18:19:48 - Command error: Mono.Data.Sqlite.SqliteException: Library used incorrectly
library routine called out of sequence
  at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors (System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) <0x4170b570 + 0x002ab> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.UpdatedRowStatus (System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) <0x413dfdc0 + 0x00087> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[] dataRows, System.Data.Common.DataTableMapping tableMapping) <0x413dbb40 + 0x01513> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.UpdateFromDataTable (System.Data.DataTable dataTable, System.Data.Common.DataTableMapping tableMapping) <0x413db310 + 0x00052> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.Update (System.Data.DataSet dataSet, System.String srcTable) <0x413da930 + 0x0014b> in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Update (System.Data.DataSet,string)
  at OpenSim.Data.SQLite.SQLiteSimulationData.Commit () <0x413da670 + 0x0007f> in <filename unknown>:0
  at OpenSim.Data.SQLite.SQLiteSimulationData.StoreRegionSettings (OpenSim.Framework.RegionSettings rs) <0x41429050 + 0x00147> in <filename unknown>:0
  at OpenSim.Data.SQLite.SQLiteSimulationData.LoadRegionSettings (UUID regionUUID) <0x412dde60 + 0x001c7> in <filename unknown>:0
  at OpenSim.Services.SimulationService.SimulationDataService.LoadRegionSettings (UUID regionUUID) <0x412dde10 + 0x00031> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.Scene..ctor (OpenSim.Framework.RegionInfo regInfo, OpenSim.Framework.AgentCircuitManager authen, ISimulationDataService simDataService, IEstateDataService estateDataService, IConfigSource config, System.String simulatorVersion) <0x412d7000 + 0x00569> in <filename unknown>:0
  at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo regionInfo, ISimulationDataService simDataService, IEstateDataService estateDataService, OpenSim.Framework.AgentCircuitManager circuitManager) <0x412d6cb0 + 0x0008f> in <filename unknown>:0
  at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo regionInfo, Int32 proxyOffset, IConfigSource configSource) <0x412d68e0 + 0x00057> in <filename unknown>:0
  at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) <0x412d5910 + 0x00457> in <filename unknown>:0
  at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo regionInfo, Boolean portadd_flag, IScene& scene) <0x412d58c0 + 0x00027> in <filename unknown>:0
  at OpenSim.OpenSim.HandleCreateRegion (System.String module, System.String[] cmd) <0x41523060 + 0x0048f> in <filename unknown>:0
  at OpenSim.Framework.Console.Commands.Resolve (System.String[] cmd) <0x4148ea10 + 0x000db> in <filename unknown>:0
  at OpenSim.Framework.Console.LocalConsole.ReadLine (System.String p, Boolean isCommand, Boolean e) <0x4145fc80 + 0x006dc> in <filename unknown>:0
  at OpenSim.Framework.Console.CommandConsole.Prompt () <0x4145e8d0 + 0x0004b> in <filename unknown>:0
  at OpenSim.Application.Main (System.String[] args) <0x411949a0 + 0x00de6> in <filename unknown>:0

This is the third and last error, I get this when leaving the Conference Center region:

Exception removing claudio fontana from conference_center. Cleaning up. Exception Mono.Data.Sqlite.SqliteException: Library used incorrectly
library routine called out of sequence
  at System.Data.Common.DbDataAdapter.UpdatedRowStatusErrors (System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) <0x4170b570 + 0x002ab> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.UpdatedRowStatus (System.Data.Common.RowUpdatedEventArgs rowUpdatedEvent, BatchCommandInfo[] batchCommands, Int32 commandCount) <0x413dfdc0 + 0x00087> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[] dataRows, System.Data.Common.DataTableMapping tableMapping) <0x413dbb40 + 0x01513> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.UpdateFromDataTable (System.Data.DataTable dataTable, System.Data.Common.DataTableMapping tableMapping) <0x413db310 + 0x00052> in <filename unknown>:0
  at System.Data.Common.DbDataAdapter.Update (System.Data.DataSet dataSet, System.String srcTable) <0x413da930 + 0x0014b> in <filename unknown>:0
  at (wrapper remoting-invoke-with-check) System.Data.Common.DbDataAdapter:Update (System.Data.DataSet,string)
  at OpenSim.Data.SQLite.SQLiteSimulationData.Commit () <0x413da670 + 0x0007f> in <filename unknown>:0
  at OpenSim.Data.SQLite.SQLiteSimulationData.RemoveObject (UUID obj, UUID regionUUID) <0x41668ed0 + 0x003b7> in <filename unknown>:0
  at OpenSim.Services.SimulationService.SimulationDataService.RemoveObject (UUID uuid, UUID regionUUID) <0x41668e80 + 0x00045> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.Scene.UnlinkSceneObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup so, Boolean softDelete) <0x41684ec0 + 0x00101> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.Scene.DeleteSceneObject (OpenSim.Region.Framework.Scenes.SceneObjectGroup group, Boolean silent, Boolean removeScripts) <0x41684a50 + 0x001ab> in <filename unknown>:0
  at OpenSim.Region.CoreModules.Avatar.Attachments.AttachmentsModule.UpdateDetachedObject (IScenePresence sp, OpenSim.Region.Framework.Scenes.SceneObjectGroup so, System.String scriptedState) <0x41684620 + 0x00123> in <filename unknown>:0
  at OpenSim.Region.CoreModules.Avatar.Attachments.AttachmentsModule.DeRezAttachments (IScenePresence sp) <0x417409c0 + 0x002df> in <filename unknown>:0
  at OpenSim.Region.Framework.Scenes.Scene.RemoveClient (UUID agentID, Boolean closeChildAgents) <0x4173a620 + 0x007b4> in <filename unknown>:0

Steps To Reproduce

New installation of OpenSim 9.0.0-source.

create regions using the create region command

gliwa (just terrain fill 25 and a simple screen prim with MOAP),
conference_center with the free ConferenceCenter OAR, using load oar
mall with the free mall 2 OAR, using load oar
shopping_center (empty region, created via create region but with errors)

Notes
(0032680) claudio (reporter) 2018-05-26 09:48	Mono JIT compiler version 4.2.1 (Debian 4.2.1.102+dfsg2-7ubuntu4)

(0032681) claudio (reporter) 2018-05-26 10:22	I switched to MariaDB, the performance is just so much better anyway :-)

(0032682) UbitUmarov (administrator) 2018-05-26 10:41	Strange errors that no one reported to far :( And yes mySql or mariaDB are a better choice, also because some features are not supported with sqlite even so i would like to try solve any issues on sqlite :(

Issue History
Date Modified	Username	Field	Change
2018-05-26 09:46	claudio	New Issue
2018-05-26 09:48	claudio	Note Added: 0032680
2018-05-26 10:22	claudio	Note Added: 0032681
2018-05-26 10:41	UbitUmarov	Note Added: 0032682

Relationships