pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16261: Not able to start Postgres
4+ messages / 2 participants
[nested] [flat]

* BUG #16261: Not able to start Postgres
@ 2020-02-17 11:23 PG Bug reporting form <noreply@postgresql.org>
  2020-02-17 12:10 ` Re: BUG #16261: Not able to start Postgres Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 1 reply; 4+ messages in thread

From: PG Bug reporting form @ 2020-02-17 11:23 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: abhishreehn@crgroup.co.in

The following bug has been logged on the website:

Bug reference:      16261
Logged by:          Abhishree Nagesh
Email address:      abhishreehn@crgroup.co.in
PostgreSQL version: 9.6.11
Operating system:   linux
Description:        

Jira the atlassian application is connected to Postgressql.

After restarting the server we're unable to start postgresql service. But
the application is up but gives the error page as unable to connect to
datatbase.

FOllowing is the error we are facing.
Kindly look into that
hence its production.

[root@ip-172-22-36-169 ~]# systemctl status  postgresql-9.6.service
● postgresql-9.6.service - SYSV: PostgreSQL database server.
   Loaded: loaded (/etc/rc.d/init.d/postgresql-9.6; bad; vendor preset:
disabled)
   Active: failed (Result: exit-code) since Mon 2020-02-17 10:01:51 UTC; 18s
ago
     Docs: man:systemd-sysv-generator(8)
  Process: 750 ExecStart=/etc/rc.d/init.d/postgresql-9.6 start (code=exited,
status=1/FAILURE)

Feb 17 10:01:49 ip-172-22-36-169.ap-south-1.compute.internal systemd[1]:
Starting SYSV: PostgreSQL database server....
Feb 17 10:01:51 ip-172-22-36-169.ap-south-1.compute.internal
postgresql-9.6[750]: Starting postgresql-9.6 service: [FAILED]
Feb 17 10:01:51 ip-172-22-36-169.ap-south-1.compute.internal systemd[1]:
postgresql-9.6.service: control process exited, code=exited status=1
Feb 17 10:01:51 ip-172-22-36-169.ap-south-1.compute.internal systemd[1]:
Failed to start SYSV: PostgreSQL database server..
Feb 17 10:01:51 ip-172-22-36-169.ap-south-1.compute.internal systemd[1]:
Unit postgresql-9.6.service entered failed state.
Feb 17 10:01:51 ip-172-22-36-169.ap-south-1.compute.internal systemd[1]:
postgresql-9.6.service failed.
[root@ip-172-22-36-169 ~]#



^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: BUG #16261: Not able to start Postgres
  2020-02-17 11:23 BUG #16261: Not able to start Postgres PG Bug reporting form <noreply@postgresql.org>
@ 2020-02-17 12:10 ` Daniel Gustafsson <daniel@yesql.se>
  2020-02-17 12:58   ` Re: BUG #16261: Not able to start Postgres Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 1 reply; 4+ messages in thread

From: Daniel Gustafsson @ 2020-02-17 12:10 UTC (permalink / raw)
  To: abhishreehn@crgroup.co.in, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

> On 17 Feb 2020, at 12:23, PG Bug reporting form <noreply@postgresql.org> wrote:

> FOllowing is the error we are facing.

The log snippet provided doesn't seem to provide too many clues, could you
paste the relevant section from the postgres logs?

cheers ./daniel




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: BUG #16261: Not able to start Postgres
  2020-02-17 11:23 BUG #16261: Not able to start Postgres PG Bug reporting form <noreply@postgresql.org>
  2020-02-17 12:10 ` Re: BUG #16261: Not able to start Postgres Daniel Gustafsson <daniel@yesql.se>
@ 2020-02-17 12:58   ` Daniel Gustafsson <daniel@yesql.se>
  2020-02-17 13:57     ` Re: BUG #16261: Not able to start Postgres Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 1 reply; 4+ messages in thread

From: Daniel Gustafsson @ 2020-02-17 12:58 UTC (permalink / raw)
  To: Abhishree hn <abhishreehn@crgroup.co.in>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>



> On 17 Feb 2020, at 13:29, Abhishree hn <abhishreehn@crgroup.co.in> wrote:
> 
> Hi Daniel,
> 
> please find the logs below.

Please retain all addresses in your reply.

> The files belonging to this database system will be owned by user "postgres".
> This user must also own the server process.
> 
> The database cluster will be initialized with locale "en_US.UTF-8".
> The default database encoding has accordingly been set to "UTF8".
> The default text search configuration will be set to "english".
> 
> Data page checksums are disabled.
> 
> fixing permissions on existing directory /var/lib/pgsql/9.6/data ... ok
> creating subdirectories ... ok
> selecting default max_connections ... 100
> selecting default shared_buffers ... 128MB
> selecting dynamic shared memory implementation ... posix
> creating configuration files ... ok
> running bootstrap script ... ok
> performing post-bootstrap initialization ... ok
> syncing data to disk ... ok
> 
> Success. You can now start the database server using:
> 
>     /usr/pgsql-9.6/bin/pg_ctl -D /var/lib/pgsql/9.6/data -l logfile start
> 
> < 2018-11-02 19:13:03.637 UTC > LOG:  redirecting log output to logging collector process
> < 2018-11-02 19:13:03.637 UTC > HINT:  Future log output will appear in directory "pg_log".
> < 2018-11-02 19:31:50.580 UTC > LOG:  redirecting log output to logging collector process
> < 2018-11-02 19:31:50.580 UTC > HINT:  Future log output will appear in directory "pg_log".
> < 2018-11-02 19:35:07.110 UTC > LOG:  redirecting log output to logging collector process
> < 2018-11-02 19:35:07.110 UTC > HINT:  Future log output will appear in directory "pg_log".
> < 2018-12-04 10:59:50.478 UTC > FATAL:  could not create lock file "/var/run/postgresql/.s.PGSQL.5432.lock": No such file or directory
> < 2018-12-04 10:59:50.478 UTC > LOG:  database system is shut down

This log entry might be related to the database not starting.  Does that
directory exist and if so, is it writeable by the process?

cheers ./daniel




^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: BUG #16261: Not able to start Postgres
  2020-02-17 11:23 BUG #16261: Not able to start Postgres PG Bug reporting form <noreply@postgresql.org>
  2020-02-17 12:10 ` Re: BUG #16261: Not able to start Postgres Daniel Gustafsson <daniel@yesql.se>
  2020-02-17 12:58   ` Re: BUG #16261: Not able to start Postgres Daniel Gustafsson <daniel@yesql.se>
@ 2020-02-17 13:57     ` Daniel Gustafsson <daniel@yesql.se>
  0 siblings, 0 replies; 4+ messages in thread

From: Daniel Gustafsson @ 2020-02-17 13:57 UTC (permalink / raw)
  To: Abhishree hn <abhishreehn@crgroup.co.in>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

> On 17 Feb 2020, at 14:17, Abhishree hn <abhishreehn@crgroup.co.in> wrote:
> 
> Hi Daniel,
> 
> There is no such directory exist.

That's quite likely a contributing factor to the problems you're facing.
Either reconfigure to use an alternative directory or make sure this one exists
and is writeable.

> On Mon, Feb 17, 2020 at 6:46 PM Daniel Gustafsson <daniel@yesql.se> wrote:
> > On 17 Feb 2020, at 14:10, Abhishree hn <abhishreehn@crgroup.co.in> wrote:
> > 
> > Hi ,
> > Yes, We are not able to start the database.
> > can you please tell me which directory exitance you are talking about?
> 
> The logs you posted show it in full detail: /var/run/postgresql/.s.PGSQL.5432.lock






^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2020-02-17 13:57 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-02-17 11:23 BUG #16261: Not able to start Postgres PG Bug reporting form <noreply@postgresql.org>
2020-02-17 12:10 ` Daniel Gustafsson <daniel@yesql.se>
2020-02-17 12:58   ` Daniel Gustafsson <daniel@yesql.se>
2020-02-17 13:57     ` Daniel Gustafsson <daniel@yesql.se>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox