[Postgres-xc-developers] Database postgres-xc is not created anymore - please help

[Himpich, S. <Ste...@se...>]

Hi Guys,

I have a problem. While upgrading to latest sources last week, my testbed stopped working. I get the error message:

FATAL:  3D000: database "postgres-xc" does not exist

I get this message on all datanodes and all coordinators. GMT Log shows no errors.


I have no idea where this problem comes from and would be greatful for any hints!


Attached you find the pgxc_ctl.conf, the logfile from the init all run and the output of show configuration all

I included the full Logfile from the datanode-master (node dbms181 on server dbms181) in this message.



Greetings,
Stefan


Full Logfile from Datanode-Master:
LOG:  00000: database system was shut down at 2013-08-12 13:25:44 UTC
LOCATION:  StartupXLOG, xlog.c:6344
LOG:  00000: database system is ready to accept connections
LOCATION:  reaper, postmaster.c:2560
LOG:  00000: autovacuum launcher started
LOCATION:  AutoVacLauncherMain, autovacuum.c:407
LOG:  00000: connection received: host=gtm81 port=60914
LOCATION:  BackendInitialize, postmaster.c:3666
LOG:  00000: connection authorized: user=postgres-xc database=postgres-xc
LOCATION:  PerformAuthentication, postinit.c:229
FATAL:  3D000: database "postgres-xc" does not exist
LOCATION:  InitPostgres, postinit.c:716
LOG:  00000: connection received: host=dbms297 port=38572
LOCATION:  BackendInitialize, postmaster.c:3666
LOG:  00000: replication connection authorized: user=postgres-xc
LOCATION:  PerformAuthentication, postinit.c:225
LOG:  00000: checkpoint starting: force wait
LOCATION:  LogCheckpointStart, xlog.c:7902
LOG:  00000: checkpoint complete: wrote 0 buffers (0.0%); 0 transaction log file(s) added, 0 removed, 0 recycled; write=0.000 s, sync=0.000 s, total=0.365 s; sync files=0, longest=0.000 s, average=0.000 s
LOCATION:  LogCheckpointEnd, xlog.c:7990
Warning: Permanently added 'dbms297,10.182.201.109' (ECDSA) to the list of known hosts.
Warning: Permanently added 'dbms297,10.182.201.109' (ECDSA) to the list of known hosts.
LOG:  00000: disconnection: session time: 0:00:04.583 user=postgres-xc database= host=dbms297 port=38572
LOCATION:  log_disconnections, postgres.c:4707
Warning: Permanently added 'dbms297,10.182.201.109' (ECDSA) to the list of known hosts.
LOG:  00000: connection received: host=gtm81 port=60950
LOCATION:  BackendInitialize, postmaster.c:3666
LOG:  00000: connection authorized: user=postgres-xc database=postgres-xc
LOCATION:  PerformAuthentication, postinit.c:229
FATAL:  3D000: database "postgres-xc" does not exist
LOCATION:  InitPostgres, postinit.c:716
LOG:  00000: connection received: host=dbms297 port=38573
LOCATION:  BackendInitialize, postmaster.c:3666
LOG:  00000: replication connection authorized: user=postgres-xc
LOCATION:  PerformAuthentication, postinit.c:225
LOG:  00000: connection received: host=gtm81 port=60983
LOCATION:  BackendInitialize, postmaster.c:3666
LOG:  00000: connection authorized: user=postgres-xc database=postgres-xc
LOCATION:  PerformAuthentication, postinit.c:229
FATAL:  3D000: database "postgres-xc" does not exist
LOCATION:  InitPostgres, postinit.c:716