Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0005514opensim[GRID] Inventory Servicepublic2011-06-02 23:432011-09-23 22:57
Reporterdutchglory 
Assigned To 
PrioritynormalSeverityminorReproducibilitysometimes
StatusnewResolutionopen 
PlatformOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0005514: with restoring large .iar archive, "object already in use" error with MS-SQL database...
Descriptionwith restoring a large .iar archive i get a "object already in use" error with MS-SQL database... this could only happen when you are logged in with viewer (avatar fully loaded with attachments)
it says "Successfully loaded 1203 items" at the end, but i'm not sure if ALL objects are successfully restored.

if you do not log in with viewer, restore goes without problems...

Additional Information2011-06-02 21:05:56,958 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: System.IO.IOException: Kan geen toegang krijgen tot het bestand C:\SQL-OPENSIM\bin\assetcache\bc55\0602\-b57\bc550602-b579-47f6-a076-354e49981501 omdat het wordt gebruikt door een ander proces.
(translation - "object already in use" )

2011-06-02 21:05:56,959 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
2011-06-02 21:05:56,961 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
2011-06-02 21:05:56,962 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)
2011-06-02 21:05:56,963 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle)
2011-06-02 21:05:56,964 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTimeUtc(String path, DateTime lastAccessTimeUtc)
2011-06-02 21:05:56,965 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTime(String path, DateTime lastAccessTime)
2011-06-02 21:05:56,966 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij Flotsam.RegionModules.AssetCache.FlotsamAssetCache.Cache(AssetBase asset) in c:\SQL-OPENSIM\OpenSim\Region\CoreModules\Asset\FlotsamAssetCache.cs:regel 265
2011-06-02 21:05:59,213 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 150 assets...
2011-06-02 21:06:02,248 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 200 assets...
2011-06-02 21:06:04,244 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 250 assets...
2011-06-02 21:06:05,620 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 300 assets...
2011-06-02 21:06:07,435 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 350 assets...
2011-06-02 21:06:10,423 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 400 assets...
2011-06-02 21:06:11,443 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: System.IO.IOException: Kan geen toegang krijgen tot het bestand C:\SQL-OPENSIM\bin\assetcache\0000\0000\-000\00000000-0000-2222-3333-100000001033 omdat het wordt gebruikt door een ander proces.
2011-06-02 21:06:11,444 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
2011-06-02 21:06:11,445 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
2011-06-02 21:06:11,446 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)
2011-06-02 21:06:11,447 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle)
2011-06-02 21:06:11,448 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTimeUtc(String path, DateTime lastAccessTimeUtc)
2011-06-02 21:06:11,449 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTime(String path, DateTime lastAccessTime)
2011-06-02 21:06:11,451 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij Flotsam.RegionModules.AssetCache.FlotsamAssetCache.Cache(AssetBase asset) in c:\SQL-OPENSIM\OpenSim\Region\CoreModules\Asset\FlotsamAssetCache.cs:regel 265
2011-06-02 21:06:16,120 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 450 assets...
2011-06-02 21:06:22,622 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: System.IO.IOException: Kan geen toegang krijgen tot het bestand C:\SQL-OPENSIM\bin\assetcache\cd07\5811\-e22\cd075811-e224-4674-b471-7296a76aa360 omdat het wordt gebruikt door een ander proces.
2011-06-02 21:06:22,623 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
2011-06-02 21:06:22,624 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
2011-06-02 21:06:22,626 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)
2011-06-02 21:06:22,626 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle)
2011-06-02 21:06:22,627 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTimeUtc(String path, DateTime lastAccessTimeUtc)
2011-06-02 21:06:22,628 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTime(String path, DateTime lastAccessTime)
2011-06-02 21:06:22,629 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij Flotsam.RegionModules.AssetCache.FlotsamAssetCache.Cache(AssetBase asset) in c:\SQL-OPENSIM\OpenSim\Region\CoreModules\Asset\FlotsamAssetCache.cs:regel 265
2011-06-02 21:06:25,394 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 500 assets...
2011-06-02 21:06:35,541 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 550 assets...
2011-06-02 21:06:40,283 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 600 assets...
2011-06-02 21:06:44,933 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 650 assets...
2011-06-02 21:06:44,987 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: System.IO.IOException: Kan geen toegang krijgen tot het bestand C:\SQL-OPENSIM\bin\assetcache\706e\804e\-98a\706e804e-98ab-4f6c-a645-16001ba43871 omdat het wordt gebruikt door een ander proces.
2011-06-02 21:06:44,989 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
2011-06-02 21:06:44,990 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
2011-06-02 21:06:44,991 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)
2011-06-02 21:06:44,992 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle)
2011-06-02 21:06:44,997 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTimeUtc(String path, DateTime lastAccessTimeUtc)
2011-06-02 21:06:44,998 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTime(String path, DateTime lastAccessTime)
2011-06-02 21:06:45,000 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij Flotsam.RegionModules.AssetCache.FlotsamAssetCache.Cache(AssetBase asset) in c:\SQL-OPENSIM\OpenSim\Region\CoreModules\Asset\FlotsamAssetCache.cs:regel 265
2011-06-02 21:06:52,192 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 700 assets...
2011-06-02 21:06:55,427 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: System.IO.IOException: Kan geen bestand maken dat al bestaat.
2011-06-02 21:06:55,428 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]:
2011-06-02 21:06:55,429 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
2011-06-02 21:06:55,429 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.__Error.WinIOError()
2011-06-02 21:06:55,430 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.Move(String sourceFileName, String destFileName)
2011-06-02 21:06:55,431 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij Flotsam.RegionModules.AssetCache.FlotsamAssetCache.WriteFileCache(String filename, AssetBase asset) in c:\SQL-OPENSIM\OpenSim\Region\CoreModules\Asset\FlotsamAssetCache.cs:regel 551
2011-06-02 21:07:00,120 DEBUG - OpenSim.Region.UserStatistics.WebStatsModule UPDATE
2011-06-02 21:07:03,903 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 750 assets...
2011-06-02 21:07:13,707 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 800 assets...
2011-06-02 21:07:20,690 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 850 assets...
2011-06-02 21:07:30,609 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 900 assets...
2011-06-02 21:07:31,837 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: System.IO.IOException: Kan geen toegang krijgen tot het bestand C:\SQL-OPENSIM\bin\assetcache\90e7\87d2\-339\90e787d2-339a-4eb0-b461-ad2e1965df05 omdat het wordt gebruikt door een ander proces.
2011-06-02 21:07:31,839 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath)
2011-06-02 21:07:31,842 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy)
2011-06-02 21:07:31,843 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize)
2011-06-02 21:07:31,844 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.OpenFile(String path, FileAccess access, SafeFileHandle& handle)
2011-06-02 21:07:31,845 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTimeUtc(String path, DateTime lastAccessTimeUtc)
2011-06-02 21:07:31,845 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij System.IO.File.SetLastAccessTime(String path, DateTime lastAccessTime)
2011-06-02 21:07:31,846 ERROR - Flotsam.RegionModules.AssetCache.FlotsamAssetCache [FLOTSAM ASSET CACHE]: bij Flotsam.RegionModules.AssetCache.FlotsamAssetCache.Cache(AssetBase asset) in c:\SQL-OPENSIM\OpenSim\Region\CoreModules\Asset\FlotsamAssetCache.cs:regel 265
2011-06-02 21:07:40,389 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 950 assets...
2011-06-02 21:07:43,122 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 1000 assets...
2011-06-02 21:07:46,301 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 1050 assets...
2011-06-02 21:07:48,574 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 1100 assets...
2011-06-02 21:07:49,994 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 1150 assets...
2011-06-02 21:07:58,083 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Loaded 1200 assets...
2011-06-02 21:07:58,377 DEBUG - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Successfully loaded 1203 assets with 0 failures
2011-06-02 21:07:58,378 INFO - OpenSim.Region.CoreModules.Avatar.Inventory.Archiver.InventoryArchiveReadRequest [INVENTORY ARCHIVER]: Successfully loaded 1203 items
TagsNo tags attached.
Git Revision or version number?
Run Mode Standalone (Multiple Regions)
Physics EnginePhysicsOfSimplicity
Script Engine
Environment.NET / Windows32
Mono VersionNone
ViewerHippo 0.6.2
Attached Files

- Relationships

-  Notes
(0018581)
StrawberryFride (reporter)
2011-06-05 15:51

Not seeing any MSSQL-specific errors in the list, all seem Flotsam related... if you can find anything that is throwing an error from the database layer I'll gladly take a look, but this looks more like a Flotsam cache issue
(0018582)
dutchglory (reporter)
2011-06-05 22:08

yes, your right. it has to do with flotsam cache. but this only happens if you use MS-SQL database. For some reason MS-SQL uses avatar assets when restoring a .iar archive. Not sure how MS-SQL uses flotsam cache...
(0020017)
justincc (administrator)
2011-09-23 18:39

Does this still occur with the current code?
(0020025)
dutchglory (reporter)
2011-09-23 22:57

yes i does, specially with big .iar archives, lets say if you restore a full inventory backup...


thank you for looking at this..
Dutchglory

- Issue History
Date Modified Username Field Change
2011-06-02 23:43 dutchglory New Issue
2011-06-02 23:43 dutchglory Git Revision => ?
2011-06-02 23:43 dutchglory SVN Revision => 0
2011-06-02 23:43 dutchglory Run Mode => Standalone (Multiple Regions)
2011-06-02 23:43 dutchglory Physics Engine => PhysicsOfSimplicity
2011-06-02 23:43 dutchglory Environment => .NET / Windows32
2011-06-02 23:43 dutchglory Mono Version => None
2011-06-02 23:43 dutchglory Viewer => Hippo 0.6.2
2011-06-05 15:51 StrawberryFride Note Added: 0018581
2011-06-05 22:08 dutchglory Note Added: 0018582
2011-09-23 18:39 justincc Note Added: 0020017
2011-09-23 22:57 dutchglory Note Added: 0020025


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker