Thread: BUG #13624: App shutdown due to fatal error, and want start after that

BUG #13624: App shutdown due to fatal error, and want start after that

From

mikael.krantz@kone.com

Date:

17 September 2015, 20:10:46

The following bug has been logged on the website:

Bug reference:      13624
Logged by:          Mikael Krantz
Email address:      mikael.krantz@kone.com
PostgreSQL version: 9.1.16
Operating system:   Ubuntu 12.04 64-bit
Description:

Snap-shot from our log:
< 2015-09-15 14:47:13.279 EEST>LOG:  received fast shutdown request
< 2015-09-15 14:47:13.279 EEST>LOG:  aborting any active transactions
< 2015-09-15 14:47:13.312 EEST>LOG:  autovacuum launcher shutting down
< 2015-09-15 14:47:13.399 EEST>LOG:  shutting down
< 2015-09-15 14:47:15.924 EEST>LOG:  database system is shut down
< 2015-09-15 14:48:16.786 EEST>LOG:  database system was shut down at
2015-09-15 14:47:15 EEST
< 2015-09-15 14:48:16.933 EEST>LOG:  database system is ready to accept
connections
< 2015-09-15 14:48:16.933 EEST>LOG:  autovacuum launcher started
<[unknown] 2015-09-15 14:48:17.125 EEST>LOG:  incomplete startup packet
<calculator_login 2015-09-15 14:48:35.621 EEST>LOG:  duration: 3908.293 ms
statement: SELECT oltp.close_all_open_events_p('CONNFAILURE')
<calculator_login 2015-09-15 14:50:08.591 EEST>LOG:  duration: 7885.086 ms
statement: SELECT ods.sum_quarter_hour_data_p()
< 2015-09-15 15:11:48.799 EEST>LOG:  database system was interrupted; last
known up at 2015-09-15 14:48:16 EEST
< 2015-09-15 15:11:48.804 EEST>FATAL:  could not open directory

"/var/lib/postgresql/9.1/main/pg_tblspc/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150":
Too many levels of symbolic links
< 2015-09-15 15:11:48.805 EEST>LOG:  startup process (PID 1203) exited with
exit code 1
< 2015-09-15 15:11:48.805 EEST>LOG:  aborting startup due to startup process
failure

Re: BUG #13624: App shutdown due to fatal error, and want start after that

From

John McKown

Date:

17 September 2015, 20:25:07

Gee, that looks _interesting_ (to me). I'd guess that the directory entry:
/var/lib/postgresql/9.1/main/pg_tblspc/17150 is a symlink which points to
itself. Have you done an:

ls -l /var/lib/postgresql/9.1/main/pg_tblspc/17150

or tried to:

cd /var/lib/postgresql/9.1/main/pg_tblspc/17150

and likely gotten:

bash: cd: a: Too many levels of symbolic links

Then you _might_ (own risk!) do and then try restarting:

rm /var/lib/postgresql/9.1/main/pg_tblspc/17150


On Thu, Sep 17, 2015 at 4:49 AM, <mikael.krantz@kone.com> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      13624
> Logged by:          Mikael Krantz
> Email address:      mikael.krantz@kone.com
> PostgreSQL version: 9.1.16
> Operating system:   Ubuntu 12.04 64-bit
> Description:
>
> Snap-shot from our log:
> < 2015-09-15 14:47:13.279 EEST>LOG:  received fast shutdown request
> < 2015-09-15 14:47:13.279 EEST>LOG:  aborting any active transactions
> < 2015-09-15 14:47:13.312 EEST>LOG:  autovacuum launcher shutting down
> < 2015-09-15 14:47:13.399 EEST>LOG:  shutting down
> < 2015-09-15 14:47:15.924 EEST>LOG:  database system is shut down
> < 2015-09-15 14:48:16.786 EEST>LOG:  database system was shut down at
> 2015-09-15 14:47:15 EEST
> < 2015-09-15 14:48:16.933 EEST>LOG:  database system is ready to accept
> connections
> < 2015-09-15 14:48:16.933 EEST>LOG:  autovacuum launcher started
> <[unknown] 2015-09-15 14:48:17.125 EEST>LOG:  incomplete startup packet
> <calculator_login 2015-09-15 14:48:35.621 EEST>LOG:  duration: 3908.293 m=
s
> statement: SELECT oltp.close_all_open_events_p('CONNFAILURE')
> <calculator_login 2015-09-15 14:50:08.591 EEST>LOG:  duration: 7885.086 m=
s
> statement: SELECT ods.sum_quarter_hour_data_p()
> < 2015-09-15 15:11:48.799 EEST>LOG:  database system was interrupted; las=
t
> known up at 2015-09-15 14:48:16 EEST
> < 2015-09-15 15:11:48.804 EEST>FATAL:  could not open directory
>
> "/var/lib/postgresql/9.1/main/pg_tblspc/17150/17150/17150/17150/17150/171=
50/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/=
17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150/171=
50/17150/17150/17150/17150/17150/17150/17150/17150/17150/17150":
> Too many levels of symbolic links
> < 2015-09-15 15:11:48.805 EEST>LOG:  startup process (PID 1203) exited wi=
th
> exit code 1
> < 2015-09-15 15:11:48.805 EEST>LOG:  aborting startup due to startup
> process
> failure
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>



--=20

Schrodinger's backup: The condition of any backup is unknown until a
restore is attempted.

Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be.

He's about as useful as a wax frying pan.

10 to the 12th power microphones =3D 1 Megaphone

Maranatha! <><
John McKown