| Anonymous | Login | Signup for a new account | 2020-01-21 02:53 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 | OS | Opensuse Tumbleweed | OS 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 | ||||||||||
 Relationships |
|
 Relationships |
|
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. |
|
Notes |
|
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 | |
|
Issue History |
| Copyright © 2000 - 2012 MantisBT Group |
 |