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

Thu Sep 23 11:50:10 UTC 2010

Hmmm.... After a little bit of diggin it looks like you drop database in
SQLite by deleting the .db file.

So in theory, if I re-download the 0.6.9 version, put it in a clean
directory and delete the .db files it should create a fresh install?

(Though for the life of me I can't figure out HOW it can find previous
corrupted files from *somewhere* when I have deleted the entire directory!)

Anyways, I'll try this later on to see what happens.

On Thu, Sep 23, 2010 at 4:29 AM, bodzette Coignet <bodzettecoignet at gmail.com
> wrote:

> 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/7cb482e5/attachment.html>