pg_dumpall problems with Postgresql 7.4

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux