Mantis Bug Tracker

View Issue Details Jump to Notes ] Issue History ] Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0008272opensim[GRID] Other Servicepublic2017-12-07 06:572017-12-07 06:57
ReporterVerwijs 
Assigned To 
PriorityhighSeveritymajorReproducibilityalways
StatusnewResolutionopen 
PlatformLinuxOSOpensuse TumbleweedOS Version20171205
Product Versionmaster (dev code) 
Target VersionFixed in Version 
Summary0008272: PGSQL Standalone: relation "estate_map" does not exist..
Description
PGSQL Standalone:
relation "estate_map" does not exist, database entries not being created during migrations...

Run on linux:
grep -rnw '<opensim-folder>/OpenSim/Data/PGSQL/Resources/' -e 'public.'

result:
<opensim-folder>/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations:5:CREATE TABLE IF NOT EXISTS "public"."agentprefs" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/AgentPrefs.migrations:17:ALTER TABLE "public"."agentprefs" ADD PRIMARY KEY ("PrincipalID") NOT DEFERRABLE INITIALLY IMMEDIATE;
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:8:CREATE TABLE IF NOT EXISTS "public"."estate_groups" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:16:CREATE INDEX IF NOT EXISTS "ix_estate_groups" ON "public"."estate_groups" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:21:CREATE TABLE IF NOT EXISTS "public"."estate_managers" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:29:CREATE INDEX IF NOT EXISTS "ix_estate_managers" ON "public"."estate_managers" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:34:CREATE TABLE IF NOT EXISTS "public"."estate_map" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:42:ALTER TABLE "public"."estate_map" ADD PRIMARY KEY ("RegionID") NOT DEFERRABLE INITIALLY IMMEDIATE;
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:47:CREATE TABLE IF NOT EXISTS "public"."estate_settings" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:80:ALTER TABLE "public"."estate_settings" ADD PRIMARY KEY ("EstateID") NOT DEFERRABLE INITIALLY IMMEDIATE;
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:85:CREATE TABLE IF NOT EXISTS "public"."estate_users" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:93:CREATE INDEX IF NOT EXISTS "ix_estate_users" ON "public"."estate_users" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:98:CREATE TABLE IF NOT EXISTS "public"."estateban" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:109:CREATE INDEX IF NOT EXISTS "ix_estateban" ON "public"."estateban" USING btree("EstateID" "pg_catalog"."int4_ops" ASC NULLS LAST);
<opensim-folder>/OpenSim/Data/PGSQL/Resources/EstateStore.migrations:120:CREATE SEQUENCE IF NOT EXISTS "public"."estate_settings_id"
<opensim-folder>/OpenSim/Data/PGSQL/Resources/IM_Store.migrations:34:DROP TABLE IF EXISTS "public"."im_offline";
<opensim-folder>/OpenSim/Data/PGSQL/Resources/IM_Store.migrations:35:CREATE TABLE "public"."im_offline" (
<opensim-folder>/OpenSim/Data/PGSQL/Resources/IM_Store.migrations:43:ALTER TABLE "public"."im_offline" ADD PRIMARY KEY ("ID","PrincipalID","FromID") NOT DEFERRABLE INITIALLY IMMEDIATE;
<opensim-folder>/OpenSim/Data/PGSQL/Resources/RegionStore.migrations:1220:ALTER TABLE "public"."prims" ALTER COLUMN "PassCollisions" DROP DEFAULT;
<opensim-folder>/OpenSim/Data/PGSQL/Resources/RegionStore.migrations:1221:ALTER TABLE "public"."prims"
---

* AgentPrefs.migrations
* EstateStore.migrations
* IM_Store.migrations
* RegionStore.migrations

points to "Public" database, witch should be database defined within GridCommon.ini and StandaloneCommon.ini for standalone.
so database entries not being created. if you create DB's manually, it all works...
 
Steps To Reproducesetup opensim with PGSQL DB standalone.
Additional InformationMono version 5.4.1.6

TagsNo tags attached.
Git Revision or version number1e3cb827562f580aea60deab640f98078107e8a3
Run Mode Standalone (Multiple Regions)
Physics EngineBulletSim
EnvironmentMono / Linux64
Mono VersionOther
ViewerFirestorm 64.5.0.7.52912
Attached Files

- Relationships

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2017-12-07 06:57 Verwijs New Issue


Copyright © 2000 - 2012 MantisBT Group
Powered by Mantis Bugtracker