Select to view content in your preferred language

Relational Datastore Creation Failing

407
0
11-28-2022 08:18 AM
CW-GIS
by
Occasional Contributor

When creating the relational datastore I get the following error:

Attempt to configure data store failed. Caused by: Attempt to configure data store failed. Caused by: Attempt to configure data store failed. Caused by: null

 

In the F:\arcgisdatastore\logs\MACHINENAME\database logs is this:

2022-11-28 15:48:33 UTC: [11584]: [1-1] LOG: database system was shut down at 2022-11-28 15:48:27 UTC
2022-11-28 15:48:33 UTC: [6980]: [6-1] LOG: database system is ready to accept connections
2022-11-28 15:53:35 UTC: [12528]: [1-1] ERROR: insert or update on table "walbackup" violates foreign key constraint "walbackup_storename_fkey"
2022-11-28 15:53:35 UTC: [12528]: [2-1] DETAIL: Key (storename)=(ds_vm4xck96) is not present in table "storeregistry".
2022-11-28 15:53:35 UTC: [12528]: [3-1] STATEMENT: INSERT INTO adm_ojwhk.walbackup VALUES ('ds_vm4xck96','0000000100000003000000EF','0000000100000003000000EF.gz','BackupComplete',1669650815745,1669650815748)
2022-11-28 15:58:35 UTC: [16936]: [1-1] ERROR: insert or update on table "walbackup" violates foreign key constraint "walbackup_storename_fkey"
2022-11-28 15:58:35 UTC: [16936]: [2-1] DETAIL: Key (storename)=(ds_vm4xck96) is not present in table "storeregistry".
2022-11-28 15:58:35 UTC: [16936]: [3-1] STATEMENT: INSERT INTO adm_ojwhk.walbackup VALUES ('ds_vm4xck96','0000000100000003000000F0','0000000100000003000000F0.gz','BackupComplete',1669651115860,1669651115862)
2022-11-28 16:03:35 UTC: [15396]: [1-1] ERROR: insert or update on table "walbackup" violates foreign key constraint "walbackup_storename_fkey"
2022-11-28 16:03:35 UTC: [15396]: [2-1] DETAIL: Key (storename)=(ds_vm4xck96) is not present in table "storeregistry".
2022-11-28 16:03:35 UTC: [15396]: [3-1] STATEMENT: INSERT INTO adm_ojwhk.walbackup VALUES ('ds_vm4xck96','0000000100000003000000F1','0000000100000003000000F1.gz','BackupComplete',1669651415878,1669651415880)
2022-11-28 16:08:35 UTC: [16836]: [1-1] ERROR: insert or update on table "walbackup" violates foreign key constraint "walbackup_storename_fkey"
2022-11-28 16:08:35 UTC: [16836]: [2-1] DETAIL: Key (storename)=(ds_vm4xck96) is not present in table "storeregistry".
2022-11-28 16:08:35 UTC: [16836]: [3-1] STATEMENT: INSERT INTO adm_ojwhk.walbackup VALUES ('ds_vm4xck96','0000000100000003000000F2','0000000100000003000000F2.gz','BackupComplete',1669651715166,1669651715168)
2022-11-28 16:13:03 UTC: [192]: [1-1] FATAL: no pg_hba.conf entry for host "::1", user "dsadmin", database "dsadmindb", SSL on
2022-11-28 16:13:03 UTC: [7380]: [1-1] FATAL: no pg_hba.conf entry for host "::1", user "dsadmin", database "dsadmindb", SSL off
2022-11-28 16:13:04 UTC: [6980]: [7-1] LOG: received fast shutdown request
2022-11-28 16:13:04 UTC: [6980]: [8-1] LOG: aborting any active transactions
2022-11-28 16:13:04 UTC: [17256]: [1-1] FATAL: terminating connection due to administrator command
2022-11-28 16:13:04 UTC: [6980]: [9-1] LOG: background worker "logical replication launcher" (PID 9264) exited with exit code 1
2022-11-28 16:13:04 UTC: [14064]: [1-1] LOG: shutting down
2022-11-28 16:13:05 UTC: [12836]: [1-1] FATAL: the database system is shutting down
2022-11-28 16:13:05 UTC: [16784]: [1-1] FATAL: the database system is shutting down
2022-11-28 16:13:06 UTC: [12960]: [1-1] FATAL: the database system is shutting down
2022-11-28 16:13:06 UTC: [16308]: [1-1] FATAL: the database system is shutting down
2022-11-28 16:13:06 UTC: [11608]: [1-1] FATAL: the database system is shutting down
2022-11-28 16:13:06 UTC: [13324]: [1-1] FATAL: the database system is shutting down
2022-11-28 16:13:06 UTC: [10876]: [1-1] FATAL: the database system is shutting down
2022-11-28 16:13:07 UTC: [6980]: [10-1] LOG: database system is shut down

Tags (1)
0 Kudos
0 Replies