[Opensim-users] upgrading to latest release (migration issue)

[Paul Fishwick]

System: Ubuntu 10.04 (64 bit). Mono version 2.4.4

Has any one encountered this problem when taking a 0.6.9 MySQL database
and trying to run 0.7.1 ? I seem to recall some discussion about increasing
the timeout for MySQL, but not sure whether that is the problem. Running
mono OpenSim.exe causes a problem (below) and then hangs at:

[SMTP]: module disabled in configuration
....shell hangs....


..................trace of where errors begin................

11:01:55 - [MIGRATIONS]: Upgrading AssetStore to latest revision 8.
11:01:55 - [MIGRATIONS]: NOTE - this may take a while, don't interrupt 
this process!
11:01:55 - [MIGRATIONS]: Cmd was Duplicate column name 'asset_flags' in 
SQL: ALTER TABLE assets ADD COLUMN asset_flags INTEGER NOT NULL DEFAULT 0;
11:01:55 - [MIGRATIONS]: An error has occurred in the migration. This 
may mean you could see errors trying to run OpenSim. If you see database 
related errors, you will need to fix the issue manually. Continuing.
11:01:55 - [MIGRATIONS]: Updating AssetStore to version 7
11:02:37 - [MIGRATIONS]: Cmd was Timeout expired.  The timeout period 
elapsed prior to completion of the operation or the server is not 
responding. in SQL: ALTER TABLE assets ADD COLUMN CreatorID varchar(128) 
NOT NULL DEFAULT '';
11:02:37 - [MIGRATIONS]: An error has occurred in the migration. This 
may mean you could see errors trying to run OpenSim. If you see database 
related errors, you will need to fix the issue manually. Continuing.
11:02:37 - Error loading plugin from OpenSim.Services.AssetService.dll, 
exception System.Exception: Connection must be valid and open. in SQL: 
ROLLBACK;
   at OpenSim.Data.Migration.ExecuteScript 
(System.Data.Common.DbConnection conn, System.String[] script) [0x00000]
   at OpenSim.Data.Migration.ExecuteScript 
(System.Data.Common.DbConnection conn, System.String sql) [0x00000]
   at OpenSim.Data.Migration.ExecuteScript (System.String sql) [0x00000]
   at OpenSim.Data.Migration.Update () [0x00000]
   at OpenSim.Data.MySQL.MySQLAssetData.Initialise (System.String 
connect) [0x00000]