pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  
help / color / mirror / Atom feed
BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left
2+ messages / 2 participants
[nested] [flat]

* BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left
@ 2020-08-18 13:43 PG Bug reporting form <noreply@postgresql.org>
  2020-08-18 14:25 ` Re: BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left Magnus Hagander <magnus@hagander.net>
  0 siblings, 1 reply; 2+ messages in thread

From: PG Bug reporting form @ 2020-08-18 13:43 UTC (permalink / raw)
  To: pgsql-bugs@lists.postgresql.org; +Cc: hema@crgroup.co.in

The following bug has been logged on the website:

Bug reference:      16584
Logged by:          hema tb
Email address:      hema@crgroup.co.in
PostgreSQL version: 9.6.18
Operating system:   linux 64 bit
Description:        

I have taken the backup in the .bak format and I restored it to the new DB
using command "psql dbname < filename.bak". after restoration I tried to
connect the DB but I am getting this error "could not create relation-cache
initialization file "global/pg_internal.init.5635": No space left on
device". Anyway its connected and when i execute this \dt command, I got "No
relations found" error.
when I tried this command " GRANT ALL ON SCHEMA public TO public;" its
throwing an error like could not access status of transaction 0 DETAIL: 
Could not write to file "pg_subtrans/00A1" at offset 139264: No space left
on device. 

Can anyone help me to resolve this issue?

Thanks in Advance
Hema



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

* Re: BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left
  2020-08-18 13:43 BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left PG Bug reporting form <noreply@postgresql.org>
@ 2020-08-18 14:25 ` Magnus Hagander <magnus@hagander.net>
  0 siblings, 0 replies; 2+ messages in thread

From: Magnus Hagander @ 2020-08-18 14:25 UTC (permalink / raw)
  To: hema@crgroup.co.in, PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>

On Tue, Aug 18, 2020 at 4:23 PM PG Bug reporting form <
noreply@postgresql.org> wrote:

> The following bug has been logged on the website:
>
> Bug reference:      16584
> Logged by:          hema tb
> Email address:      hema@crgroup.co.in
> PostgreSQL version: 9.6.18
> Operating system:   linux 64 bit
> Description:
>
> I have taken the backup in the .bak format and I restored it to the new DB
> using command "psql dbname < filename.bak". after restoration I tried to
> connect the DB but I am getting this error "could not create relation-cache
> initialization file "global/pg_internal.init.5635": No space left on
> device". Anyway its connected and when i execute this \dt command, I got
> "No
> relations found" error.
> when I tried this command " GRANT ALL ON SCHEMA public TO public;" its
> throwing an error like could not access status of transaction 0 DETAIL:
> Could not write to file "pg_subtrans/00A1" at offset 139264: No space left
> on device.
>
> Can anyone help me to resolve this issue?
>

The message seems to pretty clearly say you ran out of diskspace, either
volume or inodes.  So you need to free up disk space and try again (you'll
need to do the restore over from the beginning at that point since you
likely have a partial restore -- which should've given you plenty of errors
in the psql step as well).

-- 
 Magnus Hagander
 Me: https://www.hagander.net/ <http://www.hagander.net/;
 Work: https://www.redpill-linpro.com/ <http://www.redpill-linpro.com/;

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


end of thread, other threads:[~2020-08-18 14:25 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-08-18 13:43 BUG #16584: could not create relation-cache initialization file "global/pg_internal.init.2002": No space left PG Bug reporting form <noreply@postgresql.org>
2020-08-18 14:25 ` Magnus Hagander <magnus@hagander.net>

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