| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | wambacher(at)posteo(dot)de |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: crash during autovacuum |
| Date: | 2018-12-28 15:26:14 |
| Message-ID: | 21518.1546010774@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
wambacher(at)posteo(dot)de writes:
> this morning my database crashed, because of a problem during autovacuum.
> this is the second time during the last 2 month and i can't find out why.
Can you get a stack trace from the crash?
https://wiki.postgresql.org/wiki/Generating_a_stack_trace_of_a_PostgreSQL_backend
The evidence may be gone by now for your current crash, but if so, make
sure you are prepared to capture info from the next one.
The other respondent might be right that this ultimately traces to
data corruption, but it's hard to be sure without more info.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2018-12-28 15:36:14 | Re: Schema and Namespace Oid confusion |
| Previous Message | ZongtianHou | 2018-12-28 12:44:27 | Schema and Namespace Oid confusion |