Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0007704opensim[REGION] Specific OpenSim Modulepublic2015-08-24 07:302015-08-25 03:41
Reporteraiaustin 
Assigned To 
PrioritynormalSeveritycrashReproducibilityalways
StatusnewResolutionopen 
PlatformPCOSWindowsOS Version10
Product Versionmaster (dev code) 
Target Versionmaster (dev code)Fixed in Version 
Summary0007704: [UserProfiles] with SQLite causes AgentPreferencesService crash on OpenSim.exe exit after establishing a profile
DescriptionOn a very simple fresh OpenSim standalone using SQLite all works fine with a Ruth avatar. The 8 normal .db file data bases are created in bin. For use later these were saved.

UserProfiles are then enabled in config-include/StandaloneCommon.ini and set to the default URL in OpenSim.ini of
ProfileServiceURL = ${Const|BaseURL}:${Const|PublicPort}

All seems to work when a profile for the single Ruth avatar is created, just adding a line into the Description field. But after log off, which also appears to look normal in the OpenSim.exe console and if you do a "backup" (also okay). But then on "quit"... we get a red error on exit... relating to the AgentPreferencesService.

15:23:39 - [BASE HTTP SERVER]: HandleRequest() threw exception Mono.Data.Sqlite.SqliteException (0x80004005): The database file is locked
database is locked
   at Mono.Data.Sqlite.SQLite3.Step(SqliteStatement stmt)
   at Mono.Data.Sqlite.SqliteDataReader.NextResult()
   at Mono.Data.Sqlite.SqliteDataReader..ctor(SqliteCommand cmd, CommandBehavior behave)
   at Mono.Data.Sqlite.SqliteCommand.ExecuteReader(CommandBehavior behavior)
   at Mono.Data.Sqlite.SqliteCommand.ExecuteNonQuery()
   at OpenSim.Data.SQLite.SQLiteFramework.ExecuteNonQuery(SqliteCommand cmd, SqliteConnection connection) in d:\Temp\opensim-17e920a\OpenSim\Data\SQLite\SQLiteFramework.cs:line 74
   at OpenSim.Data.SQLite.SQLiteGenericTableHandler`1.Store(T row) in d:\Temp\opensim-17e920a\OpenSim\Data\SQLite\SQLiteGenericTableHandler.cs:line 261
   at OpenSim.Services.UserAccountService.AgentPreferencesService.StoreAgentPreferences(AgentPrefs data) in d:\Temp\opensim-17e920a\OpenSim\Services\UserAccountService\AgentPreferencesService.cs:line 68
   at OpenSim.Region.CoreModules.ServiceConnectorsOut.AgentPreferences.LocalAgentPreferencesServicesConnector.StoreAgentPreferences(AgentPrefs data) in d:\Temp\opensim-17e920a\OpenSim\Region\CoreModules\ServiceConnectorsOut\AgentPreferences\LocalAgentPreferencesServiceConnector.cs:line 143
   at OpenSim.Region.ClientStack.LindenCaps.AgentPreferencesModule.UpdateAgentPreferences(String request, String path, String param, UUID agent) in d:\Temp\opensim-17e920a\OpenSim\Region\ClientStack\Linden\Caps\AgentPreferencesModule.cs:line 161
   at OpenSim.Region.ClientStack.LindenCaps.AgentPreferencesModule.<>c__DisplayClass6.<RegisterCaps>b__3(String request, String path, String param, IOSHttpRequest httpRequest, IOSHttpResponse httpResponse) in d:\Temp\opensim-17e920a\OpenSim\Region\ClientStack\Linden\Caps\AgentPreferencesModule.cs:line 101
   at OpenSim.Framework.Servers.HttpServer.RestStreamHandler.ProcessRequest(String path, Stream request, IOSHttpRequest httpRequest, IOSHttpResponse httpResponse) in d:\Temp\opensim-17e920a\OpenSim\Framework\Servers\HttpServer\RestStreamHandler.cs:line 60
   at OpenSim.Framework.Servers.HttpServer.BaseStreamHandler.Handle(String path, Stream request, IOSHttpRequest httpRequest, IOSHttpResponse httpResponse) in d:\Temp\opensim-17e920a\OpenSim\Framework\Servers\HttpServer\BaseStreamHandler.cs:line 72
   at OpenSim.Framework.Servers.HttpServer.BaseHttpServer.HandleRequest(OSHttpRequest request, OSHttpResponse response) in d:\Temp\opensim-17e920a\OpenSim\Framework\Servers\HttpServer\BaseHttpServer.cs:line 560


This persists even after a restart, also giving this error when the OpenSim.exe is quitted.

It can only appear to be fixed by reverting to the 8 original data bases that were saved BEFORE any profile change occurred.
TagsNo tags attached.
Git Revision or version numberr/26200
Run ModeStandalone (1 Region)
Physics EngineBulletSim
Environment.NET / Windows64
Mono VersionNone
ViewerFirestorm 4.7.3
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2015-08-24 07:30 aiaustin New Issue
2015-08-24 07:31 aiaustin Summary [UserProfiles] using inbuilt Userprofiles with SQLite causes crash on OpenSim.exe exit after establishing a profile => [UserProfiles] with SQLite causes causes AgentPreferencesService crash on OpenSim.exe exit after establishing a profile
2015-08-24 07:32 aiaustin Summary [UserProfiles] with SQLite causes causes AgentPreferencesService crash on OpenSim.exe exit after establishing a profile => [UserProfiles] with SQLite causes AgentPreferencesService crash on OpenSim.exe exit after establishing a profile
2015-08-25 03:41 aiaustin Description Updated View Revisions


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker