postgres-xc-developers

[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

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

[Michael P. <mic...@gm...>]

On Mon, Aug 12, 2013 at 8:39 PM, Himpich, Stefan
<Ste...@se...> wrote:
> 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.
Smells like a bug in pgxc_ctl, and perhaps with double-quotes as this
database name has a "-" character embedded with... But this is only an
intuition. Is the database postgres-xc incriminated created
automatically with pgxc_ctl?
-- 
Michael

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

[Koichi S. <koi...@gm...>]

The database is not created automatically by pgxc_ctl.   You need to run
createdb to have non-default database even with pgxc_ctl.   Let me find a
time to re-run attached pgxc_ctl.conf.

Regards;
---
Koichi Suzuki


2013/8/19 Michael Paquier <mic...@gm...>

> On Mon, Aug 12, 2013 at 8:39 PM, Himpich, Stefan
> <Ste...@se...> wrote:
> > 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.
> Smells like a bug in pgxc_ctl, and perhaps with double-quotes as this
> database name has a "-" character embedded with... But this is only an
> intuition. Is the database postgres-xc incriminated created
> automatically with pgxc_ctl?
> --
> Michael
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>

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

[Koichi S. <koi...@gm...>]

I suppose that "init all" command is successful first, then tried to run
psql and found this message.   Your pgxc_ctl log shows this.   The database
"postgres-xc" is the default database when you run psql (or pgxc_ctl's
Psql).   Unfortunately, this database is not created automatically by
pgxc_ctl's init command.  You should run createdb (or pgxc_ctl's Createdb)
command to create it, or you should supply database name to use to psql or
Psql command such as:
pgxc# Createdb postgres-xc

Or you can supply other existing database name to psql or Psql as:
pgxc$ Psql postgres

Good luck;
---
Koichi Suzuki



2013/8/12 Himpich, Stefan <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
>
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>

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

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

Hi all,

I thought the postgres-xc database is needed for XC operation and therefor was worried. If it is optional (or well just default db of psql), everything is fine. Thanks for your feedback!

Greetings,
Stefan


-----Original Message-----
From: Koichi Suzuki [mailto:koi...@gm...]
Sent: Tue 8/20/2013 3:06 AM
To: Himpich, Stefan
Cc: pgxc-hackers mailing list
Subject: Re: [Postgres-xc-developers] Database postgres-xc is not created anymore - please help
 
I suppose that "init all" command is successful first, then tried to run
psql and found this message.   Your pgxc_ctl log shows this.   The database
"postgres-xc" is the default database when you run psql (or pgxc_ctl's
Psql).   Unfortunately, this database is not created automatically by
pgxc_ctl's init command.  You should run createdb (or pgxc_ctl's Createdb)
command to create it, or you should supply database name to use to psql or
Psql command such as:
pgxc# Createdb postgres-xc

Or you can supply other existing database name to psql or Psql as:
pgxc$ Psql postgres

Good luck;
---
Koichi Suzuki



2013/8/12 Himpich, Stefan <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
>
>
>
> ------------------------------------------------------------------------------
> Get 100% visibility into Java/.NET code with AppDynamics Lite!
> It's a free troubleshooting tool designed for production.
> Get down to code-level detail for bottlenecks, with <2% overhead.
> Download for free and get started troubleshooting in minutes.
> http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
> _______________________________________________
> Postgres-xc-developers mailing list
> Pos...@li...
> https://lists.sourceforge.net/lists/listinfo/postgres-xc-developers
>
>

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

[Michael P. <mic...@gm...>]

On Tue, Aug 20, 2013 at 9:47 PM, Himpich, Stefan
<Ste...@se...> wrote:
> Hi all,
>
> I thought the postgres-xc database is needed for XC operation and therefor was worried. If it is optional (or well just default db of psql), everything is fine. Thanks for your feedback!
The default databases are available; postgres and template1.
-- 
Michael