pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Guillaume <gwouite@gmail.com>
To: pgsql-admin@postgresql.org
Subject: pg_dumpall problems with Postgresql 7.4
Date: Thu, 08 Dec 2005 14:55:44 +0100
Message-ID: <43983B60.60200@gmail.com> (raw)

Hi,

First, i didn't find a resolution to my problem in the archives ...

I use Postgresql 7.4 and I have a big problem dumping databases :

This is the view from the command line (postmaster launched on port 5228 
to isolate it from other requests) :

pluton:/etc/init.d # ./postgres start
Starting postgres: /usr/local/pgsql/bin/postmaster [8856 8855 8853]
pluton:/etc/init.d # /usr/local/pgsql/bin/pg_dumpall -p5228 > /var/toto.txt
pg_dump: socket not open
pg_dump: SQL command to dump the contents of table "produit" failed: 
PQendcopy() failed.
pg_dump: Error message from server: socket not open
pg_dump: The command was: COPY public.produit (ref_maj, des_maj, 
code_barre, code_rayon, code_tva, poids, ref_maj_subst, code_fabr, 
prix_cession, prix_ht, prix_ref_ht, code_fourn, mnemo, conditionnement, 
bareme, code_remise, code_modif, pos_ufipa, nomen_ufipa, code_monnaie, 
code_gestion, code_barre_gros, code_barre_carton, qte_par_carton, 
qte_par_palette, nomen_douane, code_pays_douane, new_ref_fourn, 
code_rattach, ref_uc_maj, qte_mult_uc, dim_h, dim_l, dim_p, volume, 
date_diff_maj, date_appli_maj, qte_max_cde, actif, blister, dispo, 
ref_ol, pv_ol, fdpsupp, toxique, ref_mobilier, tarif_d) TO stdout;
pg_dumpall: pg_dump failed on database "officeliner_db", exiting
pluton:/etc/init.d # ./postgres stop
Stopping postgres: /usr/local/pgsql/bin/postmaster [8856 8855 8853]
pluton:/etc/init.d #

Here is the view from /var/log/messages :

I launch Postmaster

Dec  8 15:24:45 pluton su: (to postgres) root on none
Dec  8 15:24:45 pluton logger: LOG:  database system was shut down at 
2005-12-08 15:21:52 CET
Dec  8 15:24:45 pluton logger: LOG:  checkpoint record is at 0/C908C624
Dec  8 15:24:45 pluton logger: LOG:  redo record is at 0/C908C624; undo 
record is at 0/0; shutdown TRUE
Dec  8 15:24:45 pluton logger: LOG:  next transaction ID: 377545522; 
next OID: 5399628
Dec  8 15:24:45 pluton logger: LOG:  database system is ready

Here I launch pg_dumpall !

Dec  8 15:25:41 pluton logger: LOG:  server process (PID 8866) was 
terminated by signal 11
Dec  8 15:25:41 pluton logger: LOG:  terminating any other active server 
processes
Dec  8 15:25:41 pluton logger: WARNING:  terminating connection because 
of crash of another server process
Dec  8 15:25:41 pluton logger: DETAIL:  The postmaster has commanded 
this server process to roll back the current 
transa                                       ction and exit, because 
another server process exited abnormally and possibly corrupted shared 
memory.
Dec  8 15:25:41 pluton logger: HINT:  In a moment you should be able to 
reconnect to the database and repeat your 
comman                                       d.
Dec  8 15:25:41 pluton logger: LOG:  all server processes terminated; 
reinitializing
Dec  8 15:25:42 pluton logger: LOG:  database system was interrupted at 
2005-12-08 15:24:45 CET
Dec  8 15:25:42 pluton logger: LOG:  checkpoint record is at 0/C908C624
Dec  8 15:25:42 pluton logger: LOG:  redo record is at 0/C908C624; undo 
record is at 0/0; shutdown TRUE
Dec  8 15:25:42 pluton logger: LOG:  next transaction ID: 377545522; 
next OID: 5399628
Dec  8 15:25:42 pluton logger: LOG:  database system was not properly 
shut down; automatic recovery in progress
Dec  8 15:25:42 pluton logger: LOG:  record with zero length at 0/C908C664
Dec  8 15:25:42 pluton logger: LOG:  redo is not required
Dec  8 15:25:45 pluton logger: LOG:  database system is ready

I stop postmaster

Dec  8 15:26:29 pluton logger: LOG:  received smart shutdown request
Dec  8 15:26:29 pluton logger: LOG:  shutting down
Dec  8 15:26:31 pluton logger: LOG:  database system is shut down



I tried to do a pg_dumpall with the 8.1 version but it does the same, it 
seems that it is the server which crashes !


here is the core dump result whith gdb

pluton:/var/pgsql/data/base/17142 # gdb /usr/local/pgsql/bin/postmaster
GNU gdb 6.3
Copyright 2004 Free Software Foundation, Inc.
GDB is free software, covered by the GNU General Public License, and you are
welcome to change it and/or distribute copies of it under certain 
conditions.
Type "show copying" to see the conditions.
There is absolutely no warranty for GDB.  Type "show warranty" for details.
This GDB was configured as "i586-suse-linux"...Using host libthread_db 
library "/lib/tls/libthread_db.so.1".

(gdb) core core
Core was generated by `postgres: root officeliner_db [local] 
COPY                                    '.
Program terminated with signal 11, Segmentation fault.
warning: current_sos: Can't read pathname for load map: Input/output error

Reading symbols from /lib/libz.so.1...done.
Loaded symbols for /lib/libz.so.1
Reading symbols from /lib/libreadline.so.5...done.
Loaded symbols for /lib/libreadline.so.5
Reading symbols from /lib/libcrypt.so.1...done.
Loaded symbols for /lib/libcrypt.so.1
Reading symbols from /lib/libresolv.so.2...done.
Loaded symbols for /lib/libresolv.so.2
Reading symbols from /lib/libnsl.so.1...done.
Loaded symbols for /lib/libnsl.so.1
Reading symbols from /lib/libdl.so.2...done.
Loaded symbols for /lib/libdl.so.2
Reading symbols from /lib/tls/libm.so.6...done.
Loaded symbols for /lib/tls/libm.so.6
Reading symbols from /lib/tls/libc.so.6...done.
Loaded symbols for /lib/tls/libc.so.6
Reading symbols from /lib/libncurses.so.5...done.
Loaded symbols for /lib/libncurses.so.5
Reading symbols from /lib/ld-linux.so.2...done.
Loaded symbols for /lib/ld-linux.so.2
#0  0x081ab1e3 in pglz_decompress ()
(gdb) bt full
#0  0x081ab1e3 in pglz_decompress ()
No symbol table info available.
#1  0x0807f54f in heap_tuple_untoast_attr ()
No symbol table info available.
#2  0x0819fed5 in varcharout ()
No symbol table info available.
#3  0x081bfffd in FunctionCall3 ()
No symbol table info available.
#4  0x080d2666 in DoCopy ()
No symbol table info available.
#5  0x0815f392 in PortalRunUtility ()
No symbol table info available.
#6  0x0815fb25 in PortalRun ()
No symbol table info available.
#7  0x0815c2ec in exec_simple_query ()
No symbol table info available.
#8  0x0815d837 in PostgresMain ()
No symbol table info available.
#9  0x0813b568 in ServerLoop ()
No symbol table info available.
#10 0x0813c520 in PostmasterMain ()
No symbol table info available.
#11 0x081113bc in main ()
No symbol table info available.
(gdb) quit
pluton:/var/pgsql/data/base/17142 #



Do you have any idea ?

I tried this dump in an other box before. And it did the same ! I 
transfered it from one to the other copying the files of the Data Dir !



Best Regards, Guillaume MARTIN




Message-ID: <43983B60.60200@gmail.com>
Permalink:  ../43983B60.60200@gmail.com/
Also on:    postgresql.org/message-id/43983B60.60200@gmail.com

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: gwouite@gmail.com
  Subject: Re: pg_dumpall problems with Postgresql 7.4
  In-Reply-To: <43983B60.60200@gmail.com>
  References: <43983B60.60200@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox