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

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(dot)krantz(at)kone(dot)com> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 13624
> Logged by: Mikael Krantz
> Email address: mikael(dot)krantz(at)kone(dot)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
>
>
> --
> Sent via pgsql-bugs mailing list (pgsql-bugs(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-bugs
>

--

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 = 1 Megaphone

Maranatha! <><
John McKown