Re: Help - corruption issue?

Поиск
Список
Период
Сортировка
От Phoenix Kiula
Тема Re: Help - corruption issue?
Дата
Msg-id BANLkTikjLJRwnCekvmsBqoR6E72-SgDbQg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Help - corruption issue?  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: Help - corruption issue?
Список pgsql-general
On Tue, Apr 19, 2011 at 8:35 AM, Scott Marlowe <scott.marlowe@gmail.com> wrote:
> On Mon, Apr 18, 2011 at 5:44 PM, Tomas Vondra <tv@fuzzy.cz> wrote:
>>
>> Still, do the file backup as described in the previous posts. You could
>> even do an online backup using pg_backup_start/pg_backup_stop etc.
>
> As soon as you have a working file system backup, get the tw_cli
> utility for the 3ware cards downloaded and LOOK at what it has to say
> about your RAID controller, drives, and array health.



I am with SoftLayer. They're a very professional bunch. They even
changed my BBU last night. The RAID card is working. The memory and
the hardware are also tested.

I have now upgraded to 8.2.19.

Then I restarted the server, and dropped indexes. When I recreate the
first index, the same thing happens:

------
# CREATE INDEX idx_links_userid ON links (user_id);
server closed the connection unexpectedly
    This probably means the server terminated abnormally
    before or while processing the request.
The connection to the server was lost. Attempting reset: Failed.
------


There is nothing going on in the server other than this command. All
other users are blocked!

Logging is enabled but does not have anything!

I am now worried. What is this problem?

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

Предыдущее
От: Fujii Masao
Дата:
Сообщение: Re: replay doesn't catch up with receive on standby
Следующее
От: Steven Parkes
Дата:
Сообщение: Re: replay doesn't catch up with receive on standby