MantisBT - opensim
View Issue Details
0005514opensim[GRID] Inventory Servicepublic2011-06-02 23:432011-09-23 22:57
dutchglory 
 
normalminorsometimes
newopen 
master (dev code) 
 
?
Standalone (Multiple Regions)
PhysicsOfSimplicity
.NET / Windows32
None
Hippo 0.6.2
0005514: with restoring large .iar archive, "object already in use" error with MS-SQL database...
with 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...

2011-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
No tags attached.
Issue History
2011-06-02 23:43dutchgloryNew Issue
2011-06-02 23:43dutchgloryGit Revision => ?
2011-06-02 23:43dutchglorySVN Revision => 0
2011-06-02 23:43dutchgloryRun Mode => Standalone (Multiple Regions)
2011-06-02 23:43dutchgloryPhysics Engine => PhysicsOfSimplicity
2011-06-02 23:43dutchgloryEnvironment => .NET / Windows32
2011-06-02 23:43dutchgloryMono Version => None
2011-06-02 23:43dutchgloryViewer => Hippo 0.6.2
2011-06-05 15:51StrawberryFrideNote Added: 0018581
2011-06-05 22:08dutchgloryNote Added: 0018582
2011-09-23 18:39justinccNote Added: 0020017
2011-09-23 22:57dutchgloryNote Added: 0020025

Notes
(0018581)
StrawberryFride   
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   
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   
2011-09-23 18:39   
Does this still occur with the current code?
(0020025)
dutchglory   
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