pg_dumpall problems with Postgresql 7.4 - Mailing list pgsql-admin

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