At 19:45 18/06/2010, [email protected] wrote:
From: Alex Ra <[email protected]> You should be able to control the command timeout from the connection string: "Server=myServerAddress;Database=...;Default Command Timeout=20000;"
For the 0.7 RC1 I tried adding the Default Command Timeout=20000; parameter to my data base connection strings (MySQL community edition server 5.1.30) in Opensim.ini and Robust.HG.ini and they seem to have no effect. I still get the Cmd time out after 30 seconds.
2010-06-18 22:46:45,608 INFO - OpenSim.Server.Base.HttpServerBase [SERVER]: Starting HTTP server on port 8003 2010-06-18 22:46:45,648 INFO - OpenSim.Server.Base.HttpServerBase [SERVER]: Requested port 8003 2010-06-18 22:46:45,649 INFO - OpenSim.Server.OpenSimServer [SERVER]: Loading AssetServiceConnector 2010-06-18 22:46:45,972 INFO - OpenSim.Data.Migration [MIGRATIONS] Upgrading AssetStore to latest revision 8. 2010-06-18 22:46:45,972 INFO - OpenSim.Data.Migration [MIGRATIONS] NOTE: this may take a while, don't interupt this process! 2010-06-18 22:47:16,555 DEBUG - OpenSim.Data.Migration [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 asset_flags INTEGER NOT NULL DEFAULT 0;
2010-06-18 22:47:16,555 DEBUG - OpenSim.Data.Migration [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. 2010-06-18 22:47:16,556 INFO - OpenSim.Data.Migration [MIGRATIONS]: Updating AssetStore to version 7 2010-06-18 22:47:47,183 DEBUG - OpenSim.Data.Migration [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 '';
2010-06-18 22:47:47,184 DEBUG - OpenSim.Data.Migration [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. 2010-06-18 22:47:47,184 INFO - OpenSim.Data.Migration [MIGRATIONS]: Updating AssetStore to version 8 2010-06-18 22:47:47,199 INFO - OpenSim.Services.AssetService.AssetService [ASSET]: Loading default asset set from assets/AssetSets.xml 2010-06-18 22:47:47,435 ERROR - OpenSim.Data.MySQL.MySQLAssetData [ASSET DB]: MySQL failure creating asset 8ceccb12-5aee-3584-e4a5-66973a844296 with name "place_marker". Error: Unknown column 'asset_flags' in 'field list' ... then many more of the same.
_______________________________________________ Opensim-dev mailing list [email protected] https://lists.berlios.de/mailman/listinfo/opensim-dev
