[Opensim-dev] Exception: System.Data.DBConcurrencyException: Concurrency violation: the UpdateCommand affected 0 records.

[Tedd Hansen]

Hi

 

 

Can someone who knos MySQLDataStore.cs look into this?

During startup we sometimes get a crash with littlie info on what has
gone wrong.

 

I have done some tracing to figure out why we get this during some
startups.

 

Error:

[SCENE]         [01-18 11:21:14] Loading land objects from storage

[APPLICATION]   [01-18 11:21:14]

APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs

 

Exception: System.Data.DBConcurrencyException: Concurrency violation:
the UpdateCommand affected 0 records.

  at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[]
dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000]

 

Application is terminating: True

 

 

 

And here is the result:

 

This line:

m_landDataAdapter.Update(m_landTable);

in MySQLDataStore.cs line 531 inside Commit() is the one causing the
exception.

 

My manual call-stack:

MySQLDataStore.Commit()

MySQLDataStore.StoreLandObject()

 

MySQLDataStore.StoreLandObject() is hooked up to OnLandObjectAdded()
that is executed during startup.

 

Scene.EventManager.OnLandObjectAdded()

Scene.EventManager.TriggerLandObjectAdded()
LandManager.addLandObject()

LandManager.IncomingLandObjectFromStorage(LandData)

LandManager.IncomingLandObjectsFromStorage(List<LandData>)

Scene.loadAllLandObjectsFromStorage()

RegionApplicationBase.SetupScene()

 

 

 

I think the bug is related to changed being made to dataset before it is
commited, but not 100% sure.

 

 

BR,

 Tedd

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-dev/attachments/20080119/3796e7d9/attachment-0001.html>