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
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
_______________________________________________
Opensim-users mailing list
[email protected]
https://lists.berlios.de/mailman/listinfo/opensim-users
