[Opensim-users] How do you force a clean install instead of an upgrade?

[bodzette Coignet]

Hi Thanks,

Unfortunately I tried that already - just changing to a MySQL database just
copies the duplicated rows across to MySQL and the boot up still fails.

Any ideas how to completely remove an SQLite installation so I can start
fresh?

On Wed, Sep 22, 2010 at 10:33 PM, Teravus Ovares <teravus at gmail.com> wrote:

> Unfortunately, SQLite is broken on a mac post 0.6.9 because of a
> crypto library incompatibility with mac.
>
> I'd suggest dumping the database and setting it up on a mySQL server
> temporarily.   It's been broken like this for about 4 months.
>
> Regards
>
> Teravus
>
> On Wed, Sep 22, 2010 at 11:28 PM, bodzette Coignet
> <bodzettecoignet at gmail.com> wrote:
> > Hi, on my mac I have somehow corrupted the db's when upgrading from 0.6.9
> to
> > 0.7.
> > The problem now is it's irrevocably corrupted. Even if I drop the
> directory
> > and copy fresh files down from the open simulator site and run the
> install
> > again it somehow finds corruption from previous installs and chokes out.
> > I think there is a duplicate entry somewhere and I can't get rid of it.
> > Is there any way to either: uninstall sqlite and all sqlite databases
> > OR
> > force a clean install of 0.7?
> > FYI here are the errors I get:
> > 21:24:47 - [APPLICATION]:
> > APPLICATION EXCEPTION DETECTED: System.UnhandledExceptionEventArgs
> > Exception: System.Exception: There was a SQL error or connection string
> > configuration error when saving the region settings.  This could be a
> bug,
> > it could also happen if ConnectionString is defined in the
> [DatabaseService]
> > section of StandaloneCommon.ini in the config_include folder.  This could
> > also happen if the config_include folder doesn't exist or if the
> OpenSim.ini
> > [Architecture] section isn't set.  If this is your first time running
> > OpenSimulator, please restart the simulator and bug a developer to fix
> this!
> > ---> Mono.Data.Sqlite.SqliteException: Abort due to constraint violation
> > column regionUUID is not unique
> >   at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement
> stmt)
> > [0x00000] in <filename unknown>:0
> >   at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement
> stmt)
> > [0x00000] in <filename unknown>:0
> >   at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in
> <filename
> > unknown>:0
> >   at (wrapper remoting-invoke-with-check)
> > Mono.Data.Sqlite.SqliteDataReader:NextResult ()
> >   at Mono.Data.Sqlite.SqliteDataReader..ctor
> (Mono.Data.Sqlite.SqliteCommand
> > cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
> >   at (wrapper remoting-invoke-with-check)
> > Mono.Data.Sqlite.SqliteDataReader:.ctor
> > (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
> >   at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior
> behavior)
> > [0x00000] in <filename unknown>:0
> >   at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior
> > behavior) [0x00000] in <filename unknown>:0
> >   at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior
> behavior)
> > [0x00000] in <filename unknown>:0
> >   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader
> > (CommandBehavior behavior) [0x00000] in <filename unknown>:0
> >   at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[]
> > dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in
> > <filename unknown>:0
> >   --- End of inner exception stack trace ---
> >   at OpenSim.Data.SQLite.SQLiteRegionData.Commit () [0x00000] in
> <filename
> > unknown>:0
> >   at OpenSim.Data.SQLite.SQLiteRegionData.StoreRegionSettings
> > (OpenSim.Framework.RegionSettings rs) [0x00000] in <filename unknown>:0
> >   at OpenSim.Data.SQLite.SQLiteRegionData.LoadRegionSettings (UUID
> > regionUUID) [0x00000] in <filename unknown>:0
> >   at OpenSim.Region.Framework.Scenes.Scene..ctor
> > (OpenSim.Framework.RegionInfo regInfo,
> OpenSim.Framework.AgentCircuitManager
> > authen, OpenSim.Region.Framework.Scenes.SceneCommunicationService
> > sceneGridService, OpenSim.Region.Framework.StorageManager storeManager,
> > OpenSim.Region.Framework.ModuleLoader moduleLoader, Boolean
> > dumpAssetsToFile, Boolean physicalPrim, Boolean
> SeeIntoRegionFromNeighbor,
> > IConfigSource config, System.String simulatorVersion) [0x00000] in
> <filename
> > unknown>:0
> >   at OpenSim.OpenSimBase.CreateScene (OpenSim.Framework.RegionInfo
> > regionInfo, OpenSim.Region.Framework.StorageManager storageManager,
> > OpenSim.Framework.AgentCircuitManager circuitManager) [0x00000] in
> <filename
> > unknown>:0
> >   at OpenSim.OpenSimBase.SetupScene (OpenSim.Framework.RegionInfo
> > regionInfo, Int32 proxyOffset, IConfigSource configSource,
> > IClientNetworkServer& clientServer) [0x00000] in <filename unknown>:0
> >   at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo
> > regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene)
> > [0x00000] in <filename unknown>:0
> >   at OpenSim.OpenSimBase.CreateRegion (OpenSim.Framework.RegionInfo
> > regionInfo, Boolean portadd_flag, IScene& scene) [0x00000] in <filename
> > unknown>:0
> >   at
> OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise
> > () [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
> > InnerException: Mono.Data.Sqlite.SqliteException: Abort due to constraint
> > violation
> > column regionUUID is not unique
> >   at Mono.Data.Sqlite.SQLite3.Reset (Mono.Data.Sqlite.SqliteStatement
> stmt)
> > [0x00000] in <filename unknown>:0
> >   at Mono.Data.Sqlite.SQLite3.Step (Mono.Data.Sqlite.SqliteStatement
> stmt)
> > [0x00000] in <filename unknown>:0
> >   at Mono.Data.Sqlite.SqliteDataReader.NextResult () [0x00000] in
> <filename
> > unknown>:0
> >   at (wrapper remoting-invoke-with-check)
> > Mono.Data.Sqlite.SqliteDataReader:NextResult ()
> >   at Mono.Data.Sqlite.SqliteDataReader..ctor
> (Mono.Data.Sqlite.SqliteCommand
> > cmd, CommandBehavior behave) [0x00000] in <filename unknown>:0
> >   at (wrapper remoting-invoke-with-check)
> > Mono.Data.Sqlite.SqliteDataReader:.ctor
> > (Mono.Data.Sqlite.SqliteCommand,System.Data.CommandBehavior)
> >   at Mono.Data.Sqlite.SqliteCommand.ExecuteReader (CommandBehavior
> behavior)
> > [0x00000] in <filename unknown>:0
> >   at Mono.Data.Sqlite.SqliteCommand.ExecuteDbDataReader (CommandBehavior
> > behavior) [0x00000] in <filename unknown>:0
> >   at System.Data.Common.DbCommand.ExecuteReader (CommandBehavior
> behavior)
> > [0x00000] in <filename unknown>:0
> >   at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader
> > (CommandBehavior behavior) [0x00000] in <filename unknown>:0
> >   at System.Data.Common.DbDataAdapter.Update (System.Data.DataRow[]
> > dataRows, System.Data.Common.DataTableMapping tableMapping) [0x00000] in
> > <filename unknown>:0
> > Application is terminating: True
> >
> > _______________________________________________
> > Opensim-users mailing list
> > Opensim-users at lists.berlios.de
> > https://lists.berlios.de/mailman/listinfo/opensim-users
> >
> >
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://opensimulator.org/pipermail/opensim-users/attachments/20100923/35f964d8/attachment.html>