[Opensim-users] Database issues after server crash

[Ben Faust]

  Please disregard this. I discovered the database files had simply 
become corrupted, and I had to delete them physically (from the server 
files) and start over. Another question though: does anyone know how to 
change the sit settings so they line up with Second Life or even OSgrid? 
I can't just create a box and sit on it, but sit low and sideways, and 
not even on the box at any rotation. This makes importing objects from 
elsewhere nearly impossible in some cases.

On 9/5/2010 3:21 PM, Ben Faust wrote:
>  My server crashed (ran out of disk space), and it took awhile to 
> figure out how to get innoDB running again with MySQL... The database 
> appears to be in tact, except the `migrations` table is missing... 
> Now, when trying to start OpenSim, the following is part of the 
> startup logs. Anyone know how to fix this, or perhaps have the mysql 
> for recreating that table?
>
> Exception: System.Exception: Table 'migrations' already exists in SQL: 
> create table migrations(name varchar(100), version int)
>   at OpenSim.Data.Migration.ExecuteScript 
> (System.Data.Common.DbConnection conn, System.String[] script) 
> [0x00000] in <filename unknown>:0
>   at OpenSim.Data.Migration.ExecuteScript 
> (System.Data.Common.DbConnection conn, System.String sql) [0x00000] in 
> <filename unknown>:0
>   at OpenSim.Data.Migration.ExecuteScript (System.String sql) 
> [0x00000] in <filename unknown>:0
>   at OpenSim.Data.Migration.InitMigrationsTable () [0x00000] in 
> <filename unknown>:0
>   at OpenSim.Data.Migration.Update () [0x00000] in <filename unknown>:0
>   at OpenSim.Data.MySQL.MySQLEstateStore.Initialise (System.String 
> connectionString) [0x00000] in <filename unknown>:0
>   at OpenSim.Region.Framework.StorageManager..ctor (System.String 
> dllName, System.String connectionstring, System.String 
> estateconnectionstring) [0x00000] in <filename unknown>:0
>   at OpenSim.OpenSimBase.CreateStorageManager (System.String 
> connectionstring, System.String estateconnectionstring) [0x00000] in 
> <filename unknown>:0
>   at OpenSim.OpenSimBase.CreateStorageManager () [0x00000] in 
> <filename unknown>:0
>   at OpenSim.Region.ClientStack.RegionApplicationBase.StartupSpecific 
> () [0x00000] in <filename unknown>:0
>   at OpenSim.OpenSimBase.StartupSpecific () [0x00000] in <filename 
> unknown>:0
>   at OpenSim.OpenSim.StartupSpecific () [0x00000] in <filename unknown>:0
>   at OpenSim.Framework.Servers.BaseOpenSimServer.Startup () [0x00000] 
> in <filename unknown>:0
>   at OpenSim.Application.Main (System.String[] args) [0x00000] in 
> <filename unknown>:0
>
>