pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedPostgredb issue
6+ messages / 4 participants
[nested] [flat]
* Postgredb issue
@ 2020-05-09 02:33 Thusitha Maheepala <thusitha@onsys.com.au>
2020-05-09 14:38 ` Re: Postgredb issue David G. Johnston <david.g.johnston@gmail.com>
2020-05-09 15:05 ` Re: Postgredb issue Rod Taylor <rbt@rbt.ca>
0 siblings, 2 replies; 6+ messages in thread
From: Thusitha Maheepala @ 2020-05-09 02:33 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org
Hi Team,
I need big support in my postgresql server suddenly shutdown.But again
didn't start I attached here with log can you give solution i search
community also i didn't find solution.I attached here with log.can you give
solution for me.Fix this issue.I really appericate,
--
Thusitha Mahipala
M.Sc-IT,B.Sc,OCP,OCS,OCE,MCP
Country Manager/Head of Database Services
Onsys Technologies
M: +94716326751
E: thusitha@onsys.com.au
W: www.onsys.com.au
No 30, Deanston Place
Colombo 03, Sri Lanka
Attachments:
postgresql-Sat.log (application/octet-stream, 1.2M) download
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgredb issue
2020-05-09 02:33 Postgredb issue Thusitha Maheepala <thusitha@onsys.com.au>
@ 2020-05-09 14:38 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 6+ messages in thread
From: David G. Johnston @ 2020-05-09 14:38 UTC (permalink / raw)
To: Thusitha Maheepala <thusitha@onsys.com.au>; +Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
On Sat, May 9, 2020 at 6:18 AM Thusitha Maheepala <thusitha@onsys.com.au>
wrote:
> Hi Team,
> I need big support in my postgresql server suddenly shutdown.But
> again didn't start I attached here with log can you give solution i search
> community also i didn't find solution.I attached here with log.can you give
> solution for me.Fix this issue.I really appericate,
>
>
Just out of curosity - what if the answer you get is basically that your
live database is hosed you should just setup a new machine and restore your
last backup to it?
David J.
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgredb issue
2020-05-09 02:33 Postgredb issue Thusitha Maheepala <thusitha@onsys.com.au>
@ 2020-05-09 15:05 ` Rod Taylor <rbt@rbt.ca>
2020-05-09 15:09 ` Re: Postgredb issue Rod Taylor <rbt@rbt.ca>
2020-05-09 15:38 ` Re: Postgredb issue Thusitha Maheepala <thusitha@onsys.com.au>
2020-05-09 15:49 ` Re: Postgredb issue Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 3 replies; 6+ messages in thread
From: Rod Taylor @ 2020-05-09 15:05 UTC (permalink / raw)
To: Thusitha Maheepala <thusitha@onsys.com.au>; +Cc: pgsql-bugs@lists.postgresql.org
On Sat, 9 May 2020 at 09:18, Thusitha Maheepala <thusitha@onsys.com.au>
wrote:
> Hi Team,
> I need big support in my postgresql server suddenly shutdown.But
> again didn't start I attached here with log can you give solution i search
> community also i didn't find solution.I attached here with log.can you give
> solution for me.Fix this issue.I really appericate,
>
>
It appears all errors are related to the c_acctprocessorlog_pkey index? Run
the below to ditch the current index and rebuild with data from the table
files.
REINDEX INDEX c_acctprocessorlog_pkey;
It could be a bug in Pg but it's most likely a filesystem corruption or a
hardware issue (bad memory, bad disk controller, bad disk itself). You
might find some additional useful messages in the kernel logs.
Since you don't mention a version, upgrade to the most recent minor version
of Pg very soon.
regards,
Rod
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgredb issue
2020-05-09 02:33 Postgredb issue Thusitha Maheepala <thusitha@onsys.com.au>
2020-05-09 15:05 ` Re: Postgredb issue Rod Taylor <rbt@rbt.ca>
@ 2020-05-09 15:09 ` Rod Taylor <rbt@rbt.ca>
2 siblings, 0 replies; 6+ messages in thread
From: Rod Taylor @ 2020-05-09 15:09 UTC (permalink / raw)
To: Thusitha Maheepala <thusitha@onsys.com.au>; +Cc: pgsql-bugs@lists.postgresql.org
On Sat, 9 May 2020 at 11:05, Rod Taylor <rbt@rbt.ca> wrote:
> On Sat, 9 May 2020 at 09:18, Thusitha Maheepala <thusitha@onsys.com.au>
> wrote:
>
>> Hi Team,
>> I need big support in my postgresql server suddenly shutdown.But
>> again didn't start I attached here with log can you give solution i search
>> community also i didn't find solution.I attached here with log.can you give
>> solution for me.Fix this issue.I really appericate,
>>
>>
> It appears all errors are related to the c_acctprocessorlog_pkey index?
> Run the below to ditch the current index and rebuild with data from the
> table files.
>
Sorry, ignore my response. I just realized you said it won't start at all.
Check for hardware issues and restore from backup.
--
Rod Taylor
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgredb issue
2020-05-09 02:33 Postgredb issue Thusitha Maheepala <thusitha@onsys.com.au>
2020-05-09 15:05 ` Re: Postgredb issue Rod Taylor <rbt@rbt.ca>
@ 2020-05-09 15:38 ` Thusitha Maheepala <thusitha@onsys.com.au>
2 siblings, 0 replies; 6+ messages in thread
From: Thusitha Maheepala @ 2020-05-09 15:38 UTC (permalink / raw)
To: Rod Taylor <rbt@rbt.ca>; +Cc: pgsql-bugs@lists.postgresql.org
Hi Team,
Problem is database service also not started.how to start and index
this situation
On Sat, May 9, 2020 at 8:36 PM Rod Taylor <rbt@rbt.ca> wrote:
> On Sat, 9 May 2020 at 09:18, Thusitha Maheepala <thusitha@onsys.com.au>
> wrote:
>
>> Hi Team,
>> I need big support in my postgresql server suddenly shutdown.But
>> again didn't start I attached here with log can you give solution i search
>> community also i didn't find solution.I attached here with log.can you give
>> solution for me.Fix this issue.I really appericate,
>>
>>
> It appears all errors are related to the c_acctprocessorlog_pkey index?
> Run the below to ditch the current index and rebuild with data from the
> table files.
>
> REINDEX INDEX c_acctprocessorlog_pkey;
>
>
> It could be a bug in Pg but it's most likely a filesystem corruption or a
> hardware issue (bad memory, bad disk controller, bad disk itself). You
> might find some additional useful messages in the kernel logs.
>
> Since you don't mention a version, upgrade to the most recent minor
> version of Pg very soon.
>
> regards,
>
> Rod
>
--
Thusitha Mahipala
M.Sc-IT,B.Sc,OCP,OCS,OCE,MCP
Country Manager/Head of Database Services
Onsys Technologies
M: +94716326751
E: thusitha@onsys.com.au
W: www.onsys.com.au
No 30, Deanston Place
Colombo 03, Sri Lanka
^ permalink raw reply [nested|flat] 6+ messages in thread
* Re: Postgredb issue
2020-05-09 02:33 Postgredb issue Thusitha Maheepala <thusitha@onsys.com.au>
2020-05-09 15:05 ` Re: Postgredb issue Rod Taylor <rbt@rbt.ca>
@ 2020-05-09 15:49 ` Tom Lane <tgl@sss.pgh.pa.us>
2 siblings, 0 replies; 6+ messages in thread
From: Tom Lane @ 2020-05-09 15:49 UTC (permalink / raw)
To: Rod Taylor <rbt@rbt.ca>; +Cc: Thusitha Maheepala <thusitha@onsys.com.au>; pgsql-bugs@lists.postgresql.org
Rod Taylor <rbt@rbt.ca> writes:
> It appears all errors are related to the c_acctprocessorlog_pkey index? Run
> the below to ditch the current index and rebuild with data from the table
> files.
> REINDEX INDEX c_acctprocessorlog_pkey;
That appears to have been the original problem, but at the end of the
log we see that the database is refusing to start, which suggests some
other filesystem corruption has manifested. I'm suspecting some
combination of unreliable storage, ancient/buggy Postgres version etc.
It's troubling that the "last completed transaction" log messages suggest
that no checkpoint has completed since last July ... has the OP somehow
turned off checkpoints? Ordinarily the only thing that could prevent
checkpoint completion is I/O errors, but there's no trace of such in the
log. I wonder how much WAL has accumulated in the pg_wal/pg_xlog area.
It's possible that a professional data recovery service could help you
get something out of this mess. If the data is worth money to you,
see [1] for some places to try. Otherwise, chalk it up to experience
and start over.
regards, tom lane
[1] https://www.postgresql.org/support/professional_support/
^ permalink raw reply [nested|flat] 6+ messages in thread
end of thread, other threads:[~2020-05-09 15:49 UTC | newest]
Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-05-09 02:33 Postgredb issue Thusitha Maheepala <thusitha@onsys.com.au>
2020-05-09 14:38 ` David G. Johnston <david.g.johnston@gmail.com>
2020-05-09 15:05 ` Rod Taylor <rbt@rbt.ca>
2020-05-09 15:09 ` Rod Taylor <rbt@rbt.ca>
2020-05-09 15:38 ` Thusitha Maheepala <thusitha@onsys.com.au>
2020-05-09 15:49 ` Tom Lane <tgl@sss.pgh.pa.us>
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