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
