Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0006132opensim[GRID] Robust Serverpublic2012-08-07 12:252012-10-26 02:42
ReporterEmperor 
Assigned To 
PriorityurgentSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformWindows 7 x64bitOSOS Version
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0006132: Robust server unable to locate columns in database
DescriptionRobust Server returns this error when attempting to connect a region:

21,498 ERROR - OpenSim.Server.Handlers.Grid.GridServerPostHandler [GRID HANDLER]: Exception Unknown column 'uuid' in 'where clause' at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at OpenSim.Data.MySQL.MySqlRegionData.RunCommand(MySqlCommand cmd) in C:\Users\user\Desktop\development\galaxygrid\OpenSim\Data\MySQL\MySQLRegionData.cs:line 149
   at OpenSim.Data.MySQL.MySqlRegionData.Get(UUID regionID, UUID scopeID) in C:\Users\user\Desktop\development\galaxygrid\OpenSim\Data\MySQL\MySQLRegionData.cs:line 114
   at OpenSim.Services.GridService.GridService.GetNeighbours(UUID scopeID, UUID regionID) in C:\Users\user\Desktop\development\galaxygrid\OpenSim\Services\GridService\GridService.cs:line 307
   at OpenSim.Server.Handlers.Grid.GridServerPostHandler.GetNeighbours(Dictionary`2 request) in C:\Users\user\Desktop\development\galaxygrid\OpenSim\Server\Handlers\Grid\GridServerPostHandler.cs:line 211
   at OpenSim.Server.Handlers.Grid.GridServerPostHandler.Handle(String path, Stream requestData, IOSHttpRequest httpRequest, IOSHttpResponse httpResponse) in C:\Users\user\Desktop\development\galaxygrid\OpenSim\Server\Handlers\Grid\GridServerPostHandler.cs:line 89

This causes a region in the opensim server to act as though it is registered on the grid though its not. It would appear the database tables are missing the correct information.

Have reproduced this multiple times.
Steps To ReproduceStep 1: Run Robust.exe and upon successful startup run OpenSim.32BitLaunch.exe (potentially happens on OpenSim.exe also) and create region if not already created. When opensim.exe attempts to register the region with grid the error is returned.

Step 2: Redid database (Deleted and installed fresh tables) then repeated step 1.

Step 3: Rewrote Robust.ini and OpenSim.ini files along with GridCommon.ini to fix any potential configuration errors. then repeated step 1.
Additional InformationColumns uuid is not in table Region_settings or spawn_points

TagsNo tags attached.
Git Revision or version number     374ebab5742fda56b148b874d2ead5fb7d13aef9
Run Mode Grid (Multiple Regions per Sim)
Physics EngineODE
Script Engine
EnvironmentMono / Windows
Mono Version2.10
Viewer
Attached Files

- Relationships

-  Notes
(0021986)
Emperor (reporter)
2012-08-07 12:31

Also indicates it cannot read column RegionED
(0022371)
Emperor (reporter)
2012-08-18 16:44

Oky I figured out why I was getting this error. It is because these columns are missing from the database. My guess is they were changed during development and were not corrected. You can get passed this error by inserting these in as follows:

ALTER TABLE `regions` ADD `regionUUID` varchar(255) NOT NULL,
ALTER TABLE `regions` ADD `regionName` varchar(255) NOT NULL,

I also needed to add serverHttpPort as this was also not in the database table: Add as follows:

ALTER TABLE `regions` ADD `serverHttpPort` INT(11) NOT NULL,

Now I have these in which clears the error with the UUID and regionName along with clearing up the found error regarding serverHttpPort.

However now I get a totally new error as follows:

2012-08-18 18:04:06,846 DEBUG - OpenSim.Services.GridService.GridService [GRID SERVICE]: Region SG Welcome Center (5607978c-475c-4e66-9a99-fdf63cfd5cb8) registered successfully at 1000-1000
2012-08-18 18:04:08,758 WARN - OpenSim.Services.GridService.GridService [GRID SERVICE]: GetNeighbours() called for scope 00000000-0000-0000-0000-000000000000, region 5607978c-475c-4e66-9a99-fdf63cfd5cb8 but no such region found
2012-08-18 18:04:09,112 DEBUG - OpenSim.Server.Handlers.MapImage.MapServerPostHandler [MAP ADD SERVER CONNECTOR]: Received map data for region at 1000-1000
2012-08-18 18:06:23,148 ERROR - OpenSim.Data.MySQL.MySqlFramework Unknown column 'serverURI' in 'field list'
MySql.Data.MySqlClient.MySqlException: Unknown column 'serverURI' in 'field list'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at OpenSim.Data.MySQL.MySqlFramework.ExecuteNonQuery(MySqlCommand cmd) in C:\Users\user.user-PC\Desktop\development\galaxygrid\OpenSim\Data\MySQL\MySQLFramework.cs:line 71
2012-08-18 18:06:23,302 ERROR - OpenSim.Data.MySQL.MySqlFramework Unknown column 'serverURI' in 'field list'
MySql.Data.MySqlClient.MySqlException: Unknown column 'serverURI' in 'field list'
   at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at OpenSim.Data.MySQL.MySqlFramework.ExecuteNonQuery(MySqlCommand cmd) in C:\Users\user.user-PC\Desktop\development\galaxygrid\OpenSim\Data\MySQL\MySQLFramework.cs:line 71
2012-08-18 18:06:23,320 DEBUG - OpenSim.Services.GridService.GridService [GRID SERVICE]: Region SG Welcome Center (5607978c-475c-4e66-9a99-fdf63cfd5cb8) registered successfully at 1000-1000
2012-08-18 18:06:25,246 WARN - OpenSim.Services.GridService.GridService [GRID SERVICE]: GetNeighbours() called for scope 00000000-0000-0000-0000-000000000000, region 5607978c-475c-4e66-9a99-fdf63cfd5cb8 but no such region found
2012-08-18 18:06:25,599 DEBUG - OpenSim.Server.Handlers.MapImage.MapServerPostHandler [MAP ADD SERVER CONNECTOR]: Received map data for region at 1000-1000

It appears that it sees the region but believes the region does not exist. Any Help?
(0022372)
SignpostMarv (reporter)
2012-08-18 16:48

what version of mysql server are you using ?
(0022373)
Emperor (reporter)
2012-08-18 17:18

5.5 my hosting provider has updated to the most recent mysql database.
(0022374)
Emperor (reporter)
2012-08-18 17:27

Oops correction it says 5.0.77 for server version.

Must have misread the version. Then again Ive been reading so much code lately easy to misread.
(0022375)
Emperor (reporter)
2012-08-18 18:23

attempted to add serverURL to the regions and regions_settings database tables but still get the error in robust server. I launched the region server also and watched the process. It appears the region is online and connected to the grid as evidenced in the robust server. However the robust server says the region is there but yet does not exist.
(0022376)
SignpostMarv (reporter)
2012-08-18 18:25

are you able to replicate the problem locally in case it's a problem caused by your hosting provider's setup ?

Not sure if it'll make a difference or not, but it's a process of elimination :)
(0022377)
Emperor (reporter)
2012-08-18 18:31

It is replicated locally as well. I thought of that myself. the odd part is that I found where the `UUID` `regionName` and `serverHttpPort` columns were missing as the error referenced the file to look at which I did. However the error with the serverURL is a strange one that it only references mysqlframework.cs but looking there I dont see much about field list.
(0022378)
BlueWall (administrator)
2012-08-18 18:40

Database are automatically migrated during upgrades, however if the application crashes on startup or is interrupted, these migrations will fail. The best way to deal with this situation is to make sure the migration version is below the failed version.

If you want to check for changes you can use git...

git diff HEAD~30 OpenSim/Data/MySQL

That will show any changes in the MySQL data in the past 30 commits.
(0022379)
Emperor (reporter)
2012-08-18 18:41

My immediate guess perhaps is maybe I am dealing with possible code that was intended to be depreciated as i do see serverIP in the database tables.
(0022380)
Emperor (reporter)
2012-08-18 18:51

The error also does not say which database table it doesnt see it in or give a good reference to go look at.
(0022381)
Emperor (reporter)
2012-08-18 19:02

@Bluewall....

The database migrations were successful and Robust server and OpenSim server did not crash. It gives the error regarding column `serverURL` not found in `field lists` and continues on.

The region registers but yet robust says it successfully registered the region but that the region does not exist as follows:

2012-08-18 18:06:23,320 DEBUG - OpenSim.Services.GridService.GridService [GRID SERVICE]: Region SG Welcome Center (5607978c-475c-4e66-9a99-fdf63cfd5cb8) registered successfully at 1000-1000
2012-08-18 18:06:25,246 WARN - OpenSim.Services.GridService.GridService [GRID SERVICE]: GetNeighbours() called for scope 00000000-0000-0000-0000-000000000000, region 5607978c-475c-4e66-9a99-fdf63cfd5cb8 but no such region found

It then proceeds to tell me that map data is received successfully.
(0022382)
Emperor (reporter)
2012-08-18 19:40

Okay after having looked at the migrations I fixed how I had `serverURL` entered in the regions database table. I restarted robust and the opensim servers. I still get the same error message. As far as I can tell I have made the adjustments according to the mysql migrations files correctly.
(0022423)
Emperor (reporter)
2012-08-23 11:56

Okay I tried adding serverURL to the database tble regions according to the migrations information. However I still get the error unknown column `serverURL` in `fields list` This allows the region to register successfully with the robust server however the get neighbours call says the region does not exist. I will attempt to try to produce this error on WIndows 7 32bit operating system to see if it might just be windows 64bit operating system related.
(0022829)
Emperor (reporter)
2012-10-10 19:59

this now is in Opensim.32BitLaunch.

2012-10-10 22:55:38,726 ERROR - OpenSim.Data.MySQL.MySQLSimulationData [REGION DB]: MySQL error in ExecuteNonQuery: Field 'serverURL' doesn't have a default value
2012-10-10 22:55:38,730 ERROR - OpenSim.OpenSimBase [STARTUP]: Registration of region with grid failed, aborting startup due to Field 'serverURL' doesn't have a default value at MySql.Data.MySqlClient.MySqlStream.ReadPacket()
   at MySql.Data.MySqlClient.NativeDriver.GetResult(Int32& affectedRow, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.GetResult(Int32 statementId, Int32& affectedRows, Int32& insertedId)
   at MySql.Data.MySqlClient.Driver.NextResult(Int32 statementId)
   at MySql.Data.MySqlClient.MySqlDataReader.NextResult()
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteReader(CommandBehavior behavior)
   at MySql.Data.MySqlClient.MySqlCommand.ExecuteNonQuery()
   at OpenSim.Data.MySQL.MySQLSimulationData.ExecuteNonQuery(MySqlCommand c)
   at OpenSim.Data.MySQL.MySQLSimulationData.StoreRegionSettings(RegionSettings rs)
   at OpenSim.Framework.RegionSettings.Save()
   at OpenSim.Region.CoreModules.World.WorldMap.WorldMapModule.GenerateMaptile()
   at OpenSim.Region.Framework.Scenes.Scene.RegenerateMaptile()
   at OpenSim.Region.Framework.Scenes.Scene.RegisterRegionWithGrid()
   at OpenSim.OpenSimBase.CreateRegion(RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene)
(0022866)
justincc (administrator)
2012-10-16 16:01

Above should be serverURI, not serverURL
(0022867)
justincc (administrator)
2012-10-16 16:06

Quite frankly though, this stuff indicates your setup is seriously damaged in some way since all those columns should have been created by the very first migration step. Perhaps you could post "describe regions" from the MySQL prompt.
(0022868)
justincc (administrator)
2012-10-16 16:08

And what do you mean by "Installed fresh tables"? You dumped the entire ROBUST database and let OpenSimulator rebuild it from scratch?
(0022883)
Emperor (reporter)
2012-10-22 01:12

I dumped the entire database and redid the database. I also rolled back my database server to 5.1 which did seem to allievate some issues however i still get the issue with the serverurl line in the regions table.
(0022884)
Emperor (reporter)
2012-10-22 01:14

Okay I also ran a fresh start of opensim on my laptop (used the most recent stable version) and it did not actually add the serverURI line in the regions table. in fact I wound up having to add stuff to that version of the regions table also. Perhaps something is incorrect with the database migrations?
(0022885)
Emperor (reporter)
2012-10-22 04:38

Okay thanks to justin catching an error with the 'serverURI' row I went backed and matched the entire regions table with the GridStore.migration file in the source code. I found that the migration never actually properly inserted all the rows into the actual database. So I will do this manually and see what happens.
(0022886)
Emperor (reporter)
2012-10-22 05:37

Okay now that I have made the corrections i get this error.

2012-10-22 08:31:52,243 ERROR - OpenSim.Data.MySQL.MySQLSimulationData [REGION DB]: MySQL error in ExecuteNonQuery: Field 'serverURL' doesn't have a default value

Not sure what the correct default value is supposed to be here. I have corrected the row it refers to so that it is correct.
(0022888)
justincc (administrator)
2012-10-22 19:42

Please post the output of "describe regions" from the mysql prompt. There should be no reference to serverURL, only serverURI.
(0022889)
Emperor (reporter)
2012-10-22 21:34

Okay in doing the describe regions command on our hosting provider's mysql database it shows `serverURI` which is correct as I've added the table from version 1 from the GridStre.migrations file. Let me pull the info from my sql server now as well.
(0022890)
Emperor (reporter)
2012-10-22 22:51

Okay and my local mysql also gives this in its output for the regions table:

 `uuid` varchar(36) NOT NULL,
  `regionHandle` bigint(20) unsigned NOT NULL,
  `regionName` varchar(128) default NULL,
  `regionRecvKey` varchar(128) default NULL,
  `regionSendKey` varchar(128) default NULL,
  `regionSecret` varchar(128) default NULL,
  `regionDataURI` varchar(255) default NULL,
  `serverIP` varchar(64) default NULL,
  `serverPort` int(10) unsigned default NULL,
  `serverURI` varchar(255) default NULL,
  `locX` int(10) unsigned default NULL,
  `locY` int(10) unsigned default NULL,
  `locZ` int(10) unsigned default NULL,
  `eastOverrideHandle` bigint(20) unsigned default NULL,
  `westOverrideHandle` bigint(20) unsigned default NULL,
  `southOverrideHandle` bigint(20) unsigned default NULL,
  `northOverrideHandle` bigint(20) unsigned default NULL,
  `regionAssetURI` varchar(255) default NULL,
  `regionAssetRecvKey` varchar(128) default NULL,
  `regionAssetSendKey` varchar(128) default NULL,
  `regionUserURI` varchar(255) default NULL,
  `regionUserRecvKey` varchar(128) default NULL,
  `regionUserSendKey` varchar(128) default NULL,
  `regionMapTexture` varchar(36) default NULL,
  `serverHttpPort` int(10) default NULL,
  `serverRemotingPort` int(10) default NULL,
  `owner_uuid` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `originUUID` varchar(36) default NULL,
  `access` int(10) unsigned default '1',
  `ScopeID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `sizeX` int(11) NOT NULL default '0',
  `sizeY` int(11) NOT NULL default '0',
  `flags` int(11) NOT NULL default '0',
  `last_seen` int(11) NOT NULL default '0',
  `PrincipalID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `Token` varchar(255) NOT NULL,
  `parcelMapTexture` varchar(36) default NULL,
  PRIMARY KEY (`uuid`),
  KEY `regionName` (`regionName`),
  KEY `regionHandle` (`regionHandle`),
  KEY `overrideHandles` (`eastOverrideHandle`,`westOverrideHandle`,`southOverrideHandle`,`northOverrideHandle`),
  KEY `ScopeID` (`ScopeID`),
  KEY `flags` (`flags`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Rev. 3';
(0022891)
Emperor (reporter)
2012-10-22 22:52

Both of my database servers give that so I am not sure now why the opensim instance would refer to `serverURL`
(0022892)
Emperor (reporter)
2012-10-22 23:28

Okay I have also done a little experiment just to see if it would take the `serverURL` column in opensim also if that was in the mysql database. This also did not work. it throws errors on line 110 in opensim\data\MYSQL\MYSQLSimulationData.cs along with a number of other files. However OpenSim.32BitLaunch.exe will not record the full error message in its log file

It does however post this in the log file.

2012-10-23 02:08:58,667 ERROR - OpenSim.Data.MySQL.MySQLSimulationData [REGION DB]: MySQL error in ExecuteNonQuery: Field 'serverURL' doesn't have a default value

So now I think I can safely rule out an issue directly with either of my mysql servers.
(0022893)
Emperor (reporter)
2012-10-22 23:30

note `serverURI` is also in the database as proved by output files. Even without the little experiment I have tried the same error and file reference is given.
(0022894)
Emperor (reporter)
2012-10-23 01:14

Found the problem.

The Opensim instances are not in fact referring to the regions table. Instead it is referring to the regions settings table where the `serverURL` infact does exist.
(0022896)
Emperor (reporter)
2012-10-23 01:58

I am posting the regionsettings table for you with the fix I used to correct the problem.

--
-- Table structure for table `regionsettings`
--

CREATE TABLE `regionsettings` (
  `regionUUID` char(36) NOT NULL,
  `serverURL` varchar(64) NOT NULL,
  `serverHttpPort` int(11) NOT NULL,
  `block_terraform` int(11) NOT NULL,
  `block_fly` int(11) NOT NULL,
  `allow_damage` int(11) NOT NULL,
  `restrict_pushing` int(11) NOT NULL,
  `allow_land_resell` int(11) NOT NULL,
  `allow_land_join_divide` int(11) NOT NULL,
  `block_show_in_search` int(11) NOT NULL,
  `agent_limit` int(11) NOT NULL,
  `object_bonus` double NOT NULL,
  `maturity` int(11) NOT NULL,
  `disable_scripts` int(11) NOT NULL,
  `disable_collisions` int(11) NOT NULL,
  `disable_physics` int(11) NOT NULL,
  `terrain_texture_1` char(36) NOT NULL,
  `terrain_texture_2` char(36) NOT NULL,
  `terrain_texture_3` char(36) NOT NULL,
  `terrain_texture_4` char(36) NOT NULL,
  `elevation_1_nw` double NOT NULL,
  `elevation_2_nw` double NOT NULL,
  `elevation_1_ne` double NOT NULL,
  `elevation_2_ne` double NOT NULL,
  `elevation_1_se` double NOT NULL,
  `elevation_2_se` double NOT NULL,
  `elevation_1_sw` double NOT NULL,
  `elevation_2_sw` double NOT NULL,
  `water_height` double NOT NULL,
  `terrain_raise_limit` double NOT NULL,
  `terrain_lower_limit` double NOT NULL,
  `use_estate_sun` int(11) NOT NULL,
  `fixed_sun` int(11) NOT NULL,
  `sun_position` double NOT NULL,
  `covenant` char(36) default NULL,
  `Sandbox` tinyint(4) NOT NULL,
  `sunvectorx` double NOT NULL default '0',
  `sunvectory` double NOT NULL default '0',
  `sunvectorz` double NOT NULL default '0',
  `loaded_creation_id` varchar(64) default NULL,
  `loaded_creation_datetime` int(10) unsigned NOT NULL default '0',
  `map_tile_ID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `TelehubObject` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `parcel_tile_ID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `covenant_datetime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (`regionUUID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `regionsettings`
--

Recommended Change:

ALTER TABLE regionsettings change column `serverURL` `serverURL` varchar(255) default NULL;
(0022914)
justincc (administrator)
2012-10-24 20:22

But ServerURL doesn't existing in regionsettings either - it doesn't exist in any of the db tables.

Here is my "describe regionsettings"

mysql> describe regionsettings;
+--------------------------+------------------+------+-----+--------------------------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+--------------------------+------------------+------+-----+--------------------------------------+-------+
| regionUUID | char(36) | NO | PRI | NULL | |
| block_terraform | int(11) | NO | | NULL | |
| block_fly | int(11) | NO | | NULL | |
| allow_damage | int(11) | NO | | NULL | |
| restrict_pushing | int(11) | NO | | NULL | |
| allow_land_resell | int(11) | NO | | NULL | |
| allow_land_join_divide | int(11) | NO | | NULL | |
| block_show_in_search | int(11) | NO | | NULL | |
| agent_limit | int(11) | NO | | NULL | |
| object_bonus | double | NO | | NULL | |
| maturity | int(11) | NO | | NULL | |
| disable_scripts | int(11) | NO | | NULL | |
| disable_collisions | int(11) | NO | | NULL | |
| disable_physics | int(11) | NO | | NULL | |
| terrain_texture_1 | char(36) | NO | | NULL | |
| terrain_texture_2 | char(36) | NO | | NULL | |
| terrain_texture_3 | char(36) | NO | | NULL | |
| terrain_texture_4 | char(36) | NO | | NULL | |
| elevation_1_nw | double | NO | | NULL | |
| elevation_2_nw | double | NO | | NULL | |
| elevation_1_ne | double | NO | | NULL | |
| elevation_2_ne | double | NO | | NULL | |
| elevation_1_se | double | NO | | NULL | |
| elevation_2_se | double | NO | | NULL | |
| elevation_1_sw | double | NO | | NULL | |
| elevation_2_sw | double | NO | | NULL | |
| water_height | double | NO | | NULL | |
| terrain_raise_limit | double | NO | | NULL | |
| terrain_lower_limit | double | NO | | NULL | |
| use_estate_sun | int(11) | NO | | NULL | |
| fixed_sun | int(11) | NO | | NULL | |
| sun_position | double | NO | | NULL | |
| covenant | char(36) | YES | | NULL | |
| Sandbox | tinyint(4) | NO | | NULL | |
| sunvectorx | double | NO | | 0 | |
| sunvectory | double | NO | | 0 | |
| sunvectorz | double | NO | | 0 | |
| loaded_creation_id | varchar(64) | YES | | NULL | |
| loaded_creation_datetime | int(10) unsigned | NO | | 0 | |
| map_tile_ID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | |
| TelehubObject | varchar(36) | NO | | 00000000-0000-0000-0000-000000000000 | |
| parcel_tile_ID | char(36) | NO | | 00000000-0000-0000-0000-000000000000 | |
| covenant_datetime | int(10) unsigned | NO | | 0 | |
+--------------------------+------------------+------+-----+--------------------------------------+-------+
43 rows in set (0.09 sec)
(0022915)
justincc (administrator)
2012-10-24 20:25

I would have to conclude that the extra columns have been added manually by accident - I have never heard of OpenSimulator doing this.
(0022937)
Emperor (reporter)
2012-10-26 02:20

I wound up having to add the columns manually as the columns were not added by opensim. Additionally I implemented my recommended alteration of the `regionsettings` table for column `serverURL` which is actually in the `regionsettings` table and it cleared up the error. I didn't think to look in the region settings table however when i went through all the database tables I did find it in version one of the regionsettings table in the migrations file.

Heres the database table from my database which the migrations files put in before I found the serverURL and made the alteration:

--
-- Table structure for table `regionsettings`
--

CREATE TABLE `regionsettings` (
  `regionUUID` char(36) NOT NULL,
  `serverURL` varchar(64) NOT NULL,
  `serverHttpPort` int(11) NOT NULL,
  `block_terraform` int(11) NOT NULL,
  `block_fly` int(11) NOT NULL,
  `allow_damage` int(11) NOT NULL,
  `restrict_pushing` int(11) NOT NULL,
  `allow_land_resell` int(11) NOT NULL,
  `allow_land_join_divide` int(11) NOT NULL,
  `block_show_in_search` int(11) NOT NULL,
  `agent_limit` int(11) NOT NULL,
  `object_bonus` double NOT NULL,
  `maturity` int(11) NOT NULL,
  `disable_scripts` int(11) NOT NULL,
  `disable_collisions` int(11) NOT NULL,
  `disable_physics` int(11) NOT NULL,
  `terrain_texture_1` char(36) NOT NULL,
  `terrain_texture_2` char(36) NOT NULL,
  `terrain_texture_3` char(36) NOT NULL,
  `terrain_texture_4` char(36) NOT NULL,
  `elevation_1_nw` double NOT NULL,
  `elevation_2_nw` double NOT NULL,
  `elevation_1_ne` double NOT NULL,
  `elevation_2_ne` double NOT NULL,
  `elevation_1_se` double NOT NULL,
  `elevation_2_se` double NOT NULL,
  `elevation_1_sw` double NOT NULL,
  `elevation_2_sw` double NOT NULL,
  `water_height` double NOT NULL,
  `terrain_raise_limit` double NOT NULL,
  `terrain_lower_limit` double NOT NULL,
  `use_estate_sun` int(11) NOT NULL,
  `fixed_sun` int(11) NOT NULL,
  `sun_position` double NOT NULL,
  `covenant` char(36) default NULL,
  `Sandbox` tinyint(4) NOT NULL,
  `sunvectorx` double NOT NULL default '0',
  `sunvectory` double NOT NULL default '0',
  `sunvectorz` double NOT NULL default '0',
  `loaded_creation_id` varchar(64) default NULL,
  `loaded_creation_datetime` int(10) unsigned NOT NULL default '0',
  `map_tile_ID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `TelehubObject` varchar(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `parcel_tile_ID` char(36) NOT NULL default '00000000-0000-0000-0000-000000000000',
  `covenant_datetime` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY (`regionUUID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table `regionsettings`
--
(0022938)
Emperor (reporter)
2012-10-26 02:42

I also don't remember adding the `serverURL` column manually. When this bug started throwing errors the columns `serverIP`, `serverHTTPport`, and one other as showin in this bug log were missing from the database in the `regions` table. I corrected those as suggested by signpostmary and fixed those. I then noticed they were in the GridUser.migrations file and never got nserted. Before this problem begain I don't recall seeing a serverURL in the `regionsettings` table myself but interestingly both Robust.exe and then OpenSim.32BitLaunch.exe and regular OpenSim.exe (I tried it on my old 32 bit operating system also) through the error regarding no defined default in column `serverURL` which i throught meant the regions table until I noticed it in the regionsettings table.

It might be possible that theres an older piece of code somewhere in the mysql files in opensim that requires it though I've not found it myself.

- Issue History
Date Modified Username Field Change
2012-08-07 12:25 Emperor New Issue
2012-08-07 12:31 Emperor Note Added: 0021986
2012-08-18 16:44 Emperor Note Added: 0022371
2012-08-18 16:46 Emperor Priority normal => urgent
2012-08-18 16:46 Emperor Platform => Windows 7 x64bit
2012-08-18 16:48 SignpostMarv Note Added: 0022372
2012-08-18 17:18 Emperor Note Added: 0022373
2012-08-18 17:27 Emperor Note Added: 0022374
2012-08-18 18:23 Emperor Note Added: 0022375
2012-08-18 18:25 SignpostMarv Note Added: 0022376
2012-08-18 18:31 Emperor Note Added: 0022377
2012-08-18 18:40 BlueWall Note Added: 0022378
2012-08-18 18:41 Emperor Note Added: 0022379
2012-08-18 18:51 Emperor Note Added: 0022380
2012-08-18 19:02 Emperor Note Added: 0022381
2012-08-18 19:40 Emperor Note Added: 0022382
2012-08-23 11:56 Emperor Note Added: 0022423
2012-10-10 19:59 Emperor Note Added: 0022829
2012-10-16 16:01 justincc Note Added: 0022866
2012-10-16 16:06 justincc Note Added: 0022867
2012-10-16 16:08 justincc Note Added: 0022868
2012-10-22 01:12 Emperor Note Added: 0022883
2012-10-22 01:14 Emperor Note Added: 0022884
2012-10-22 04:38 Emperor Note Added: 0022885
2012-10-22 05:37 Emperor Note Added: 0022886
2012-10-22 19:42 justincc Note Added: 0022888
2012-10-22 21:34 Emperor Note Added: 0022889
2012-10-22 22:51 Emperor Note Added: 0022890
2012-10-22 22:52 Emperor Note Added: 0022891
2012-10-22 23:28 Emperor Note Added: 0022892
2012-10-22 23:30 Emperor Note Added: 0022893
2012-10-23 01:14 Emperor Note Added: 0022894
2012-10-23 01:58 Emperor Note Added: 0022896
2012-10-24 20:22 justincc Note Added: 0022914
2012-10-24 20:25 justincc Note Added: 0022915
2012-10-26 02:20 Emperor Note Added: 0022937
2012-10-26 02:42 Emperor Note Added: 0022938
2014-01-23 15:41 justincc Category Robust Server => [GRID] Robust Server


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker