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.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 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@postgresql.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