ALT Linux sysadmins discussion
 help / color / mirror / Atom feed
From: "Vladimir V. Kamarzin" <vvk@vvk.pp.ru>
To: ALT Linux sysadmin discuss <sysadmins@lists.altlinux.org>
Subject: [Sysadmins] postgresql crashes
Date: Tue, 25 Aug 2009 11:20:25 +0600
Message-ID: <m34orwxyee.fsf@vvk.distance.ru> (raw)

Hi

Имеется VE с postgresql, которая используется только для zabbix. Есть проблема
- база постоянно разваливается после выполнения скрипта резервного
копирования, основные команды в котором такие:

pg_dump -Fc -f "$cur_backup_dir/$db" -U postgres $db
vacuumdb -f -a -U postgres

Судя по времени в /var/log/messsages, разваливается во время выполнения vacuumdb.

WARNING:  index "history_1" contains 20505050 row versions, but table contains 20504519 row versions
HINT:  Rebuild the index with REINDEX.
vacuumdb: vacuuming of database "zabbix" failed: PANIC:  right sibling's left-link doesn't match: block 88296 links to 737 instead of expected 59541 in index "history_1"
server closed the connection unexpectedly
	This probably means the server terminated abnormally
	before or while processing the request.

Делалось pg_dump/pg_restore в формат и custom и в plain sql, так же делался
REINDEX всего. Ничего не помогает - 2-3 дня работает, а потом
разваливается. Контейнер в лимиты не долбится. postgres не в чруте. Версии:

postgresql8.3-server-8.3.7-alt2
postgresql-common-1.0-alt5
postgresql8.3-8.3.7-alt2

В чём может быть дело?

-- 
vvk


             reply	other threads:[~2009-08-25  5:20 UTC|newest]

Thread overview: 4+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2009-08-25  5:20 Vladimir V. Kamarzin [this message]
2009-08-25 10:35 ` Boris Savelev
2009-08-25 11:42   ` Vladimir V. Kamarzin
2009-08-25 12:28 ` Alex Gorbachenko

Reply instructions:

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

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

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=m34orwxyee.fsf@vvk.distance.ru \
    --to=vvk@vvk.pp.ru \
    --cc=sysadmins@lists.altlinux.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link

ALT Linux sysadmins discussion

This inbox may be cloned and mirrored by anyone:

	git clone --mirror http://lore.altlinux.org/sysadmins/0 sysadmins/git/0.git

	# If you have public-inbox 1.1+ installed, you may
	# initialize and index your mirror using the following commands:
	public-inbox-init -V2 sysadmins sysadmins/ http://lore.altlinux.org/sysadmins \
		sysadmins@lists.altlinux.org sysadmins@lists.altlinux.ru sysadmins@lists.altlinux.com
	public-inbox-index sysadmins

Example config snippet for mirrors.
Newsgroup available over NNTP:
	nntp://lore.altlinux.org/org.altlinux.lists.sysadmins


AGPL code for this site: git clone https://public-inbox.org/public-inbox.git