Anonymous | Login | Signup for a new account | 2021-01-28 03:01 PST | ![]() |
Main | My View | View Issues | Change Log | Roadmap | Summary | My Account |
View Issue Details [ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||||
ID | 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 | |||||||||
Tags | No tags attached. | |||||||||
Git Revision or version number | 1e3cb827562f580aea60deab640f98078107e8a3 | |||||||||
Run Mode | Standalone (Multiple Regions) | |||||||||
Physics Engine | BulletSim | |||||||||
Script Engine | ||||||||||
Environment | Mono / Linux64 | |||||||||
Mono Version | Other | |||||||||
Viewer | Firestorm 64.5.0.7.52912 | |||||||||
Attached Files | ||||||||||
![]() |
|
(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. |
![]() |
|||
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 |
Copyright © 2000 - 2012 MantisBT Group |