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

[Paul Fishwick]

  Good point - I'll probably wait for 0.7.0.2 to emerge. In the mean 
time, I installed
0.6.9-rc2 from May and that seems fine.
-p

On 9/9/2010 11:57 AM, diva at metaverseink.com wrote:
> 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
>>
> _______________________________________________
> Opensim-users mailing list
> Opensim-users at lists.berlios.de
> https://lists.berlios.de/mailman/listinfo/opensim-users
>


-- 
Paul Fishwick, PhD
Professor
University of Florida
CISE Department, CSE 301
Gainesville, FL 32611
Email: fishwick at cise.ufl.edu
Web: http://www.cise.ufl.edu/~fishwick