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

[diva at metaverseink.com]

Yes.
The MySql driver that is currently in the master branch is... a 
challenge. We have it there because it's the newest one and supposedly 
will allow for some future stored procedure optimizations. But it 
doesn't work well for normal schema updates. It's a pain in the neck.

OpenSim official tagged releases will not have this driver, they will 
have the older one, until someone figures out what's wrong with this 
newer one. But the master branch has it, because it's the branch that is 
trying to push things forward.

Bottom line: if you're using developer's code (master head) you're in 
for a bumpy ride with this driver. You basically need to do all the 
migrations manually. :-/


Paul Fishwick wrote:
> 
> 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]
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>