0008272: PGSQL Standalone: relation "estate_map" does not exist..

View Issue Details [ Jump to Notes ]

[ Issue History ] [ Print ]

Project

Category

View Status

Date Submitted

Last Update

0008272

opensim

[GRID] Other Service

public

2017-12-07 06:57

2019-09-10 04:22

Reporter

Verwijs

Assigned To

Priority

high

Severity

major

Reproducibility

always

Status

new

Resolution

open

Platform

Linux

Operating System

Opensuse Tumbleweed

Operating System Version

20171205

Product Version

master (dev code)

Target Version

Fixed in Version

Summary

0008272: 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 Reproduce

setup opensim with PGSQL DB standalone.

Additional Information

Mono version 5.4.1.6

Notes
(0032541) Verwijs (reporter) 2018-02-15 02:11	remove this one please ..

(0035677) Jeff Hall (reporter) 2019-09-10 04:22	Having same issue when experimenting with OSgrid 0.9.1.0 Snail Dev 2019-08-16. I remember being able years ago to have PGSQL build database from opensim then able to restore an oar. I haven't been able to do so since a long time so i keep using MariaDB/MySQL even if PGSQL is a powerful opensource database alternative. Would be nice to update that DB support in opensim eventually.

Issue History
Date Modified	Username	Field	Change
2017-12-07 06:57	Verwijs	New Issue
2018-02-15 02:11	Verwijs	Note Added: 0032541
2019-09-10 04:22	Jeff Hall	Note Added: 0035677

Relationships