Re: panic on 7.3
От | Rick Gigger |
---|---|
Тема | Re: panic on 7.3 |
Дата | |
Msg-id | C8AB66EA-01B1-42C9-ACA5-4F4F454258E9@alpinenetworking.com обсуждение исходный текст |
Ответ на | Re: panic on 7.3 (Andrew Dunstan <andrew@dunslane.net>) |
Список | pgsql-hackers |
Thanks. I'm not quite sure what version I am going to upgrade to yet. Rick On Jan 20, 2006, at 5:59 PM, Andrew Dunstan wrote: > > Updates for FC1 are available here: > > http://download.fedoralegacy.org/fedora/1/updates/i386/ > > they have 7.3.9 dated in March last year. > > Or grab the source for 7.3.13 and build it yourself. > > cheers > > andrew > > Rick Gigger wrote: > >> It is the version that shipped with fedora core 1. The version >> string from psql is (PostgreSQL) 7.3.4-RH. I assume that it must >> have been the first bug since I had plenty of disk space. >> >> >> On Jan 20, 2006, at 5:35 PM, Bruce Momjian wrote: >> >>> Rick Gigger wrote: >>> >>>> Postgres version 7.3.4 >>>> >>>> ... a whole bunch of other files.... >>>> -rw------- 1 postgres postgres 262144 Jan 18 22:42 027D >>>> -rw------- 1 postgres postgres 262144 Jan 19 07:38 027E >>>> -rw------- 1 postgres postgres 262144 Jan 19 08:25 027F >>>> -rw------- 1 postgres postgres 262144 Jan 19 09:07 0280 >>>> -rw------- 1 postgres postgres 262144 Jan 19 09:59 0281 >>>> -rw------- 1 postgres postgres 262144 Jan 19 11:07 0282 >>>> -rw------- 1 postgres postgres 262144 Jan 19 12:22 0283 >>>> -rw------- 1 postgres postgres 262144 Jan 19 13:29 0284 >>>> -rw------- 1 postgres postgres 262144 Jan 19 14:26 0285 >>>> -rw------- 1 postgres postgres 262144 Jan 19 15:58 0286 >>>> -rw------- 1 postgres postgres 262144 Jan 19 19:55 0287 >>>> -rw------- 1 postgres postgres 262144 Jan 19 23:47 0288 >>>> -rw------- 1 postgres postgres 262144 Jan 20 02:35 0289 >>>> -rw------- 1 postgres postgres 262144 Jan 20 04:21 028A >>>> -rw------- 1 postgres postgres 262144 Jan 20 06:16 028B >>>> -rw------- 1 postgres postgres 262144 Jan 20 07:20 028C >>>> -rw------- 1 postgres postgres 262144 Jan 20 08:22 028D >>>> -rw------- 1 postgres postgres 262144 Jan 20 09:24 028E >>>> -rw------- 1 postgres postgres 262144 Jan 20 10:24 028F >>>> -rw------- 1 postgres postgres 262144 Jan 20 11:04 0290 >>>> -rw------- 1 postgres postgres 262144 Jan 20 11:50 0291 >>>> -rw------- 1 postgres postgres 262144 Jan 20 13:27 0292 >>>> -rw------- 1 postgres postgres 262144 Jan 20 14:24 0293 >>>> -rw------- 1 postgres postgres 262144 Jan 20 14:53 0294 >>>> -rw------- 1 postgres postgres 262144 Jan 20 17:10 0295 >>>> >>>> That is right now. Right after it started up it went up to 0292. >>>> There are a lot of files before the ones listed here right now >>>> though. Do you need to see their names? >>> >>> >>> I assume you are missing one of these fixes in 7.3.X current >>> which were >>> done _after_ 7.3.4 was released: >>> >>> * Fix race condition in transaction log management >>> There was a narrow window in which an I/O operation could be >>> initiated for the wrong page, leading to an Assert >>> failure or data corruption. >>> >>> * Repair incorrect order of operations in GetNewTransactionId() >>> This bug could result in failure under out-of-disk-space >>> conditions, including inability to restart even after >>> disk space is freed. >>> >>> -------------------------------------------------------------------- >>> -- ----- >>> >>> >>>> >>>> >>>> On Jan 20, 2006, at 3:58 PM, Tom Lane wrote: >>>> >>>>> Rick Gigger <rick@alpinenetworking.com> writes: >>>>> >>>>>> I got this message: >>>>>> 2006-01-20 11:50:51 PANIC: creation of file /var/lib/pgsql/data/ >>>>>> pg_clog/0292 failed: File exists >>>>> >>>>> >>>>>> In 7.3. It caused the server to restart. >>>>> >>>>> >>>>>> Can anyone tell me what it means? >>>>> >>>>> >>>>> 7.3.what? >>>>> >>>>> What file names exist in the pg_clog directory? >>>>> >>>>> regards, tom lane >>>>> >>>>> ---------------------------(end of >>>>> broadcast)--------------------------- >>>>> TIP 1: if posting/reading through Usenet, please send an >>>>> appropriate >>>>> subscribe-nomail command to majordomo@postgresql.org so >>>>> that >>>>> your >>>>> message can get through to the mailing list cleanly >>>>> >>>> >>>> >>>> ---------------------------(end of >>>> broadcast)--------------------------- >>>> TIP 4: Have you searched our list archives? >>>> >>>> http://archives.postgresql.org >>>> >>> >>> -- >>> Bruce Momjian | http://candle.pha.pa.us >>> pgman@candle.pha.pa.us | (610) 359-1001 >>> + If your life is a hard drive, | 13 Roberts Road >>> + Christ can be your backup. | Newtown Square, >>> Pennsylvania 19073 >>> >>> ---------------------------(end of >>> broadcast)--------------------------- >>> TIP 6: explain analyze is your friend >>> >> >> >> ---------------------------(end of >> broadcast)--------------------------- >> TIP 6: explain analyze is your friend >> >
В списке pgsql-hackers по дате отправления: