When a NOCOPY item is rezzed and DELETEd from Inventory, is it INSERTed
anywhere else? Perhaps in a REZZED table with columns for Region Name,
x,y,z, and asset identifier, with asset identifier being the primary
key.
Then it is possible to construct queries for Are any instances of X
rezzed and
It's supposedly inserted into the region tables, but the issue comes
when the region server is unable to do this (or crashes),
the item is lost permanently.
As for the queries, yes, it's absolutely possible to check if things are
rezzed, look for the prims table in the region database.
~Tom
This sounds like a classic case of something that should be a two-phase
commit transaction performed atomically. The fact that it is not, and
may even be spread across multiple processes, is a hole in DB
consistency.
I do not think we want to get into doing *distributed* 2P transactions -
I have
PM
To: opensim-dev@lists.berlios.de
Subject: Re: [Opensim-dev] Inventory loss
I don't recall OSgrid really getting many complaints about it either, infact i
do not recall any, I am not saying its never occured, but its so minimal its
not something i ever remember occuring, even when our whole
to database corruption issues.
Rock
-Original Message-
From: opensim-dev-boun...@lists.berlios.de
[mailto:opensim-dev-boun...@lists.berlios.de] On Behalf Of Melanie
Sent: Monday, July 27, 2009 12:30 PM
To: opensim-dev@lists.berlios.de
Subject: Re: [Opensim-dev] Inventory loss
database backup
cured the problems.
Rock
-Original Message-
From: opensim-dev-boun...@lists.berlios.de
[mailto:opensim-dev-boun...@lists.berlios.de] On Behalf Of Melanie
Sent: Monday, July 27, 2009 2:07 PM
To: opensim-dev@lists.berlios.de
Subject: Re: [Opensim-dev] Inventory loss
IMHO
27, 2009 2:07 PM
To: opensim-dev@lists.berlios.de
Subject: Re: [Opensim-dev] Inventory loss
IMHO, inventory loss due to MySQL errors and/or corruption are below
the radar.
Any losses would occur in OpenSim code, I believe.
Melanie
Colin B. Withers wrote:
I wonder what proportion
-
From: opensim-dev-boun...@lists.berlios.de
[mailto:opensim-dev-boun...@lists.berlios.de] On Behalf Of Melanie
Sent: 27 July 2009 14:32
To: opensim-dev@lists.berlios.de
Subject: Re: [Opensim-dev] Inventory loss
Those MySQL issues listed below and others like it are corner cases
that OpenSim would
Hey folks.
Been thinking a lot about inventory loss in OpenSim, something that I
think we should really do as much as possible to avoid. We've been
experiencing numerous cases of lost inventory in K-Grid recently.
What i'd like to implement, is..
When an item is removed from inventory
-dev-
boun...@lists.berlios.de] On Behalf Of Thomas Grimshaw
Sent: Sunday, 26 July 2009 6:55 PM
To: opensim-dev@lists.berlios.de
Subject: [Opensim-dev] Inventory loss
Hey folks.
Been thinking a lot about inventory loss in OpenSim, something that I
think we should really do as much
10 matches
Mail list logo
