X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 0D8F69FA5C3 for ; Fri, 30 Jun 2006 17:28:25 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 05915-08 for ; Fri, 30 Jun 2006 17:28:13 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from hub.org (hub.org [200.46.204.220]) by postgresql.org (Postfix) with ESMTP id 650DC9FA192 for ; Fri, 30 Jun 2006 17:27:43 -0300 (ADT) Received: from localhost (wm.hub.org [200.46.204.128]) by hub.org (Postfix) with ESMTP id 02978291AFB for ; Fri, 30 Jun 2006 17:27:40 -0300 (ADT) Received: from hub.org ([200.46.204.220]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 75287-07 for ; Fri, 30 Jun 2006 20:27:36 +0000 (UTC) Received: from ganymede.hub.org (blk-7-151-244.eastlink.ca [71.7.151.244]) by hub.org (Postfix) with ESMTP id 1A2AD291AFA for ; Fri, 30 Jun 2006 17:27:33 -0300 (ADT) Received: by ganymede.hub.org (Postfix, from userid 1000) id E35543839D; Fri, 30 Jun 2006 17:27:37 -0300 (ADT) Received: from localhost (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id E298333DF1 for ; Fri, 30 Jun 2006 17:27:37 -0300 (ADT) X-Return-Path: X-Received: from ganymede.hub.org ([unix socket]) by ganymede.hub.org (Cyrus v2.2.13) with LMTPA; Fri, 30 Jun 2006 14:50:28 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from ganymede.hub.org (localhost [127.0.0.1]) by ganymede.hub.org (Postfix) with ESMTP id F17335C382 for ; Fri, 30 Jun 2006 14:50:27 -0300 (ADT) X-Received: from mail.postgresql.org [200.46.204.71] by ganymede.hub.org with IMAP (fetchmail-6.3.4) for (single-drop); Fri, 30 Jun 2006 14:50:27 -0300 (ADT) X-Received: from postgresql.org ([unix socket]) by postgresql.org (Cyrus v2.2.13) with LMTPA; Fri, 30 Jun 2006 14:46:14 -0300 X-Sieve: CMU Sieve 2.2 X-Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id C65329FA192 for ; Fri, 30 Jun 2006 14:46:14 -0300 (ADT) X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 88410-02-2 for ; Fri, 30 Jun 2006 14:46:14 -0300 (ADT) X-Received: from postgresql.org (postgresql.org [200.46.204.71]) by postgresql.org (Postfix) with ESMTP id 619159FA0EC for ; Fri, 30 Jun 2006 14:46:14 -0300 (ADT) X-Original-To: pgsql-admin-postgresql.org-owner@postgresql.org X-Delivered-To: pgsql-admin-postgresql.org-owner@postgresql.org X-Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 01B529FA0EC for ; Fri, 30 Jun 2006 14:46:14 -0300 (ADT) X-Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 88410-02 for ; Fri, 30 Jun 2006 14:46:04 -0300 (ADT) X-Greylist: delayed 00:23:39.361539 by SQLgrey- X-Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 4E9189FA5C3 for ; Fri, 30 Jun 2006 14:46:04 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.3 X-Received: from comm.sochi.net.ru (sochi.net.ru [212.248.80.2]) by svr4.postgresql.org (Postfix) with ESMTP id 7EB805AF04C for ; Fri, 30 Jun 2006 17:22:18 +0000 (GMT) X-Received: from [212.176.39.202] (tcc-dp-dsl1-202.sochi.net.ru [212.176.39.202]) by comm.sochi.net.ru (8.13.4/8.13.4) with ESMTP id k5UHLkml099675 for ; Fri, 30 Jun 2006 21:21:47 +0400 (MSD) (envelope-from M.Babakov@sochi.net.ru) Message-ID: <44A55DA2.8060304@sochi.net.ru> Date: Fri, 30 Jun 2006 21:21:38 +0400 From: "Michael B. Babakov" User-Agent: Thunderbird 1.5.0.4 (Windows/20060516) MIME-Version: 1.0 To: pgsql-admin-owner@postgresql.org Subject: ERROR: invalid overflow block number 13947 Content-Type: text/plain; charset=KOI8-R; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: ClamAV 0.88.2/1578/Fri Jun 30 13:34:32 2006 on comm.sochi.net.ru X-Virus-Status: Clean X-Milter: Spamilter (Reciever: comm.sochi.net.ru; Sender-ip: 212.176.39.202; Sender-helo: [212.176.39.202]; ) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 ReSent-Date: Fri, 30 Jun 2006 17:27:32 -0300 (ADT) ReSent-From: "Marc G. Fournier" ReSent-To: pgsql-admin@postgresql.org ReSent-Subject: ERROR: invalid overflow block number 13947 ReSent-Message-ID: <20060630172732.F1085@ganymede.hub.org> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200607/6 X-Sequence-Number: 22252 Hi, During execution of query UPDATE links SET weight = weight + (0.002972378315) WHERE ot='38933058' AND k='39267613' I got the error: ERROR: invalid overflow block number 13947 The "links" table have two HASH indexes and one BTREE index. Reindexing of "links" table is in progress. But I'm not sure will this resolve this problem ? PgSQL 8.1.3 on FreeBSD Good luck, Michael