Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008290opensim[REGION] OpenSim Corepublic2018-02-15 04:522018-02-22 12:33
Assigned To 
PlatformWindowOSwindowsOS Version10
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0008290: PGSQL: "operator does not exist: character varying = uuid"
DescriptionFatal error: Npgsql.NpgsqlException:
operator does not exist: character varying = uuid
Severity: ERROR
Code: 42883
Hint: No operator matches the given name and argument type(s). You might need to add explicit type casts.
   at Npgsql.NpgsqlState.<ProcessBackendResponses_Ver_3>d__9.MoveNext()
   at Npgsql.ForwardsOnlyDataReader.GetNextResponseObject(Boolean cleanup)
   at Npgsql.ForwardsOnlyDataReader.GetNextRowDescription()
   at Npgsql.ForwardsOnlyDataReader.NextResultInternal()
   at Npgsql.ForwardsOnlyDataReader..ctor(IEnumerable`1 dataEnumeration, CommandBehavior behavior, NpgsqlCommand command, NotificationThreadBlock threadBlock, Boolean preparedStatement, NpgsqlRowDescription rowDescription)
   at Npgsql.NpgsqlCommand.GetReader(CommandBehavior cb)
   at Npgsql.NpgsqlCommand.ExecuteReader(CommandBehavior cb)
   at OpenSim.Data.PGSQL.PGSQLSimulationData.LoadLandObjects(UUID regionUUID) in C:\OPENSIM-PGSQL\OpenSim\Data\PGSQL\PGSQLSimulationData.cs:regel 720
   at OpenSim.Services.SimulationService.SimulationDataService.LoadLandObjects(UUID regionUUID) in C:\OPENSIM-PGSQL\OpenSim\Services\SimulationService\SimulationDataService.cs:regel 144
   at OpenSim.Region.Framework.Scenes.Scene.loadAllLandObjectsFromStorage(UUID regionID) in C:\OPENSIM-PGSQL\OpenSim\Region\Framework\Scenes\Scene.cs:regel 2224
   at OpenSim.OpenSimBase.CreateRegion(RegionInfo regionInfo, Boolean portadd_flag, Boolean do_post_init, IScene& mscene) in C:\OPENSIM-PGSQL\OpenSim\Region\Application\OpenSimBase.cs:regel 464
   at OpenSim.OpenSimBase.CreateRegion(RegionInfo regionInfo, Boolean portadd_flag, IScene& scene) in C:\OPENSIM-PGSQL\OpenSim\Region\Application\OpenSimBase.cs:regel 376
   at OpenSim.ApplicationPlugins.LoadRegions.LoadRegionsPlugin.PostInitialise() in C:\OPENSIM-PGSQL\OpenSim\ApplicationPlugins\LoadRegions\LoadRegionsPlugin.cs:regel 130
   at OpenSim.OpenSimBase.StartupSpecific() in C:\OPENSIM-PGSQL\OpenSim\Region\Application\OpenSimBase.cs:regel 285
   at OpenSim.OpenSim.StartupSpecific() in C:\OPENSIM-PGSQL\OpenSim\Region\Application\OpenSim.cs:regel 211
   at OpenSim.Framework.Servers.BaseOpenSimServer.Startup() in C:\OPENSIM-PGSQL\OpenSim\Framework\Servers\BaseOpenSimServer.cs:regel 170

Steps To ReproduceEstate_settings > "RegionName" is being read as uuid witch should be "character varying", same goes fo all other "varchar" type fields, not supported by pgsql...

Additional Information..
TagsNo tags attached.
Git Revision or version number
Run Mode Standalone (Multiple Regions)
Physics EngineBulletSim
Environment.NET / Windows64
Mono VersionNone
Attached Files

- Relationships

-  Notes
Gavin Hird (reporter)
2018-02-15 05:05

Please fetch the query that is failing from your Postgres log file. The NPQSL log in isolation is almost impossible to decipher.
Verwijs (reporter)
2018-02-15 06:58

lines from from pgsql log.
I also searched entire solution to find where SQL statement(s) are set/used...
** at line: ..\OpenSim\Data\PGSQL\PGSQLSimulationData.cs(542) **

[3788] ERROR: operator does not exist: character varying = uuid at character 109
[3788] HINT: No operator matches the given name and argument type(s).
              You might need to add explicit type casts.

[3788] STATEMENT: select "RegionUUID", "Revision", "Heightfield" from terrain
                   where "RegionUUID" = (('ab244920-f45c-11e7-8f1a-0800200c9a66')::uuid)
                   order by "Revision" desc limit 1

** at line: ..\OpenSim\Data\PGSQL\PGSQLSimulationData.cs(712) **

[3788] ERROR: operator does not exist: character varying = uuid at character 39
[3788] HINT: No operator matches the given name and argument type(s).
              You might need to add explicit type casts.

[3788] STATEMENT: select * from land where "RegionUUID" = (('ab244920-f45c-11e7-8f1a-0800200c9a66')::uuid)

Verwijs (reporter)
2018-02-22 12:33

should be the same as mysql migrations to bypass the error. with sql that works for pgsql of course..

- Issue History
Date Modified Username Field Change
2018-02-15 04:52 Verwijs New Issue
2018-02-15 05:05 Gavin Hird Note Added: 0032544
2018-02-15 06:58 Verwijs Note Added: 0032545
2018-02-22 12:33 Verwijs Note Added: 0032558

Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker