Re: panic on 7.3

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
>>
>