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
next 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