postgres dies while doing vacuum analyze
От | Manuel Sugawara |
---|---|
Тема | postgres dies while doing vacuum analyze |
Дата | |
Msg-id | m3hexhegbs.fsf@dep1.fciencias.unam.mx обсуждение исходный текст |
Ответы |
Re: postgres dies while doing vacuum analyze
|
Список | pgsql-hackers |
Guys, Just installed a new data base in my server and while running vacuum analyze postgres dies with the following message: [...] NOTICE: Index pg_rewrite_oid_index: Pages 2; Tuples 16. CPU 0.00s/0.00u sec. NOTICE: Index pg_rewrite_rulename_index: Pages 2; Tuples 16. CPU 0.00s/0.00u sec. NOTICE: --Relation pg_toast_17058-- NOTICE: Pages 4: Changed 0, reaped 0, Empty 0, New 0; Tup 17: Vac 0, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 219, MaxLen2034; Re-using: Free/Avail. Space 0/0; EndEmpty/Avail. Pages 0/0. CPU 0.00s/0.00u sec. NOTICE: Index pg_toast_17058_idx: Pages 2; Tuples 17. CPU 0.00s/0.00u sec. NOTICE: Analyzing... pqReadData() -- backend closed the channel unexpectedly.This probably means the backend terminated abnormallybefore or whileprocessing the request. The connection to the server was lost. Attempting reset: Failed. !# The postgres version is 7.1.2 and the data base was initialized with $ LANG=es_MX /usr/bin/initdb -D /var/lib/pgsql/data -E latin1 It is running on Redhat Linux 7.1 i686 with 2.4.2-2 kernel. Here is the back trace from gdb (gdb) bt #0 strcoll () at strcoll.c:229 #1 0x081348e7 in varstr_cmp () at eval.c:41 #2 0x0813493f in varstr_cmp () at eval.c:41 #3 0x08134b7c in text_gt () at eval.c:41 #4 0x08148ca2 in FunctionCall2 () at eval.c:41 #5 0x080b3b09 in analyze_rel () at eval.c:41 #6 0x080b3795 in analyze_rel () at eval.c:41 #7 0x080afa76 in vacuum () at eval.c:41 #8 0x080af9c7 in vacuum () at eval.c:41 #9 0x0810a3ca in ProcessUtility () at eval.c:41 #10 0x0810808b in pg_exec_query_string () at eval.c:41 #11 0x081091ce in PostgresMain () at eval.c:41 #12 0x080f208b in PostmasterMain () at eval.c:41 #13 0x080f1c45 in PostmasterMain () at eval.c:41 #14 0x080f0d0c in PostmasterMain () at eval.c:41 #15 0x080f0684 in PostmasterMain () at eval.c:41 #16 0x080cf3c8 in main () at eval.c:41 #17 0x401e2177 in __libc_start_main (main=0x80cf260 <main>, argc=3, ubp_av=0xbffffa7c, init=0x8065c20 <_init>, fini=0x8154bb0<_fini>, rtld_fini=0x4000e184 <_dl_fini>, stack_end=0xbffffa6c) at ../sysdeps/generic/libc-start.c:129 (gdb) Seems like a problem with my locale settings. The strange thing is that postgres dies while analyzing a system table; however I'm able to vacuum my tables individually: $ for t in `psql dep dep -c '\dt' -t -A | cut -d\| -f1`; do psql dep -c "vacuum analyze $t"; done Any ideas? best regards, Manuel.
В списке pgsql-hackers по дате отправления: