Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 7EFF59FC02D for ; Wed, 30 May 2007 16:49:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 51509-03 for ; Wed, 30 May 2007 16:49:11 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.181]) by postgresql.org (Postfix) with ESMTP id 07BA99FC16E for ; Wed, 30 May 2007 16:49:13 -0300 (ADT) Received: by wa-out-1112.google.com with SMTP id v27so1035121wah for ; Wed, 30 May 2007 12:49:12 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=usBQkIxk6W9+k+2kO+1r+6k1zQvgt88+w9x7BoM3BS5bqB4aBl8ZYoV354kJm3q6ImTHhvIh/9CuykLdrVNlRzdlu76cnl5K9JXPfDMhTlpRg0URHPm26gthIAMYdFl3+yISIAyaqWy9F9JoC1S15Kejqadw379V2y0zPAS7vHo= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:references; b=cp91uEi1nw9C8UOMMsdHfh69DyR4l7E1cwopOj//TBCD0ciE4d/Lq5biMjJVmTaMgCFKsfkKGEW7eql/IYHYfc550CApCzuv/b6fs8gd7lEDivFLqOf0FD2aq55eG3Ypat01DhrTavFBrulAu/ZSqcn2JLAo4UEUvQufTusjpK4= Received: by 10.115.49.16 with SMTP id b16mr4191326wak.1180554552426; Wed, 30 May 2007 12:49:12 -0700 (PDT) Received: by 10.114.80.6 with HTTP; Wed, 30 May 2007 12:49:12 -0700 (PDT) Message-ID: Date: Wed, 30 May 2007 23:49:12 +0400 From: "Roman Chervotkin" To: pgsql-admin@postgresql.org Subject: Re: pg_dump: Error message from server: ERROR: compressed data is corrupt In-Reply-To: MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_10526_19832758.1180554552378" References: X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200705/320 X-Sequence-Number: 25640 ------=_Part_10526_19832758.1180554552378 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Please help, I cannot understand what should be done in order to fix the issue. Any hint, I tried search and irc but found nothing useful yet. On 5/30/07, Roman Chervotkin wrote: > > Do usual pg_dump today and have got an error. > > --------------------- > pg_dump: SQL command failed > pg_dump: Error message from server: ERROR: compressed data is corrupt > pg_dump: The command was: COPY public.candidates (id, name, surname, > mid_name, compensation, created, birthday, updated, creator_id, updater_id, > home_region_id, home_city, home_street, other_languages, home_region_other, > edu_conformity, sex, deleted, resume_text, resume_text_index, mark, kids, > driving_license, marital_status, software_knowledge, business_contacts, > type_writing_rus, type_writing_lat, desired_duties, desired_other, > updater_name, citizenship, compensation_currency, folder_id, plus, > random_cat, temp_reg, "temp") TO stdout; > ---------------------- > > I had 8.2.0 on Solaris 10 (SunOS server3 5.10 Generic_125101-05 ), > pg_data_dir on zfs mirrored pool. I've checked status of pool and got: > > ---------------------- > -bash-3.00# zpool status tank > pool: tank > state: ONLINE > status: One or more devices has experienced an unrecoverable error. An > attempt was made to correct the error. Applications are > unaffected. > action: Determine if the device needs to be replaced, and clear the errors > using 'zpool clear' or replace the device with 'zpool replace'. > see: http://www.sun.com/msg/ZFS-8000-9P > scrub: scrub completed with 0 errors on Tue May 29 19:46:12 2007 > config: > > NAME STATE READ WRITE CKSUM > tank ONLINE 0 0 0 > mirror ONLINE 0 0 0 > c1t0d0 ONLINE 1 0 0 > c1t4d0 ONLINE 0 0 0 > > errors: No known data errors > -------------------------------------------------------- > > So it seems a drive should be replaced but pool is still functioning. I > still can copy pg_data_dir to other filesystem without any errors. And > database seems working as usual. So I guess pg_dump should work but It does > not. I've upgraded to 8.2.4 but still have the same error. Copy > pg_data_dir to another file system, start postgres with that data_dir, tried > pg_dump again but still have the error. > > So the question is what should I do in order to pg_dump start working as > usual? > > > Thanks > Roman. > > > ------=_Part_10526_19832758.1180554552378 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline Please help,

I cannot understand what should be done in order to fix the issue.

Any hint, I tried search and irc but found nothing useful yet.


On 5/30/07, Roman Chervotkin <roman.chervotkin@gmail.com> wrote:
Do usual pg_dump today and have got an error.

---------------------
pg_dump: SQL command failed
pg_dump: Error message from server: ERROR:  compressed data is corrupt
pg_dump: The command was: COPY public.candidates (id, name, surname, mid_name, compensation, created, birthday, updated, creator_id, updater_id, home_region_id, home_city, home_street, other_languages, home_region_other, edu_conformity, sex, deleted, resume_text, resume_text_index, mark, kids, driving_license, marital_status, software_knowledge, business_contacts, type_writing_rus, type_writing_lat, desired_duties, desired_other, updater_name, citizenship, compensation_currency, folder_id, plus, random_cat, temp_reg, "temp") TO stdout;
----------------------

I had 8.2.0 on Solaris 10 (SunOS server3 5.10 Generic_125101-05 ), pg_data_dir on zfs mirrored pool. I've checked status of pool and got:

----------------------
-bash-3.00# zpool status tank
  pool: tank
 state: ONLINE
status: One or more devices has experienced an unrecoverable error.  An
        attempt was made to correct the error.  Applications are unaffected.
action: Determine if the device needs to be replaced, and clear the errors
        using 'zpool clear' or replace the device with 'zpool replace'.
   see: http://www.sun.com/msg/ZFS-8000-9P
 scrub: scrub completed with 0 errors on Tue May 29 19:46:12 2007
config:

        NAME        STATE     READ WRITE CKSUM
        tank        ONLINE       0     0     0
          mirror    ONLINE       0     0     0
            c1t0d0  ONLINE       1     0     0
            c1t4d0  ONLINE       0     0     0

errors: No known data errors
--------------------------------------------------------

So it seems a drive should be replaced but pool is still functioning. I still can copy pg_data_dir to other filesystem without any errors. And database seems working as usual. So I guess pg_dump should work but It does not. I've upgraded to 8.2.4 but still have the same error. Copy pg_data_dir to another file system, start postgres with that data_dir, tried pg_dump again but still have the error.

So the question is what should I do in order to pg_dump start working as usual?


Thanks
Roman.



------=_Part_10526_19832758.1180554552378--