Re: error during vacuum full

Поиск
Список
Период
Сортировка
От Barry Lind
Тема Re: error during vacuum full
Дата
Msg-id 3D2BB3B0.5070808@xythos.com
обсуждение исходный текст
Ответ на error during vacuum full  (Barry Lind <barry@xythos.com>)
Ответы Re: error during vacuum full  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Tom,

It was not compiled with debug.  I will do that now and see if this 
happens again in the future.  If and when it happens again what would 
you like me to do?  I am willing provide you access if you need it.

thanks,
--Barry

Tom Lane wrote:

>Barry Lind <barry@xythos.com> writes:
>  
>
>>When trying to perform a full vacuum I am getting the following error:
>>ERROR:  No one parent tuple was found
>>    
>>
>
>Want to dig into it with gdb, or let someone else into your system to
>do so?
>
>I've suspected for awhile that there's still a lurking bug or three
>in the VACUUM FULL tuple-chain-moving code, but without an example
>to study it's damn hard to make any progress.
>
>Note that restarting the postmaster will probably make the problem
>go away, as tuple chains cannot exist unless there are old open
>transactions.  So unless your installation is already compiled
>--enable-debug, there's probably not much we can learn :=(
>
>            regards, tom lane
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>  
>




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: error during vacuum full
Следующее
От: Tom Lane
Дата:
Сообщение: Re: error during vacuum full