From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Received: from localhost (localhost [127.0.0.1]) by arlo.cworth.org (Postfix) with ESMTP id 491216DE014D for ; Wed, 5 Sep 2018 06:04:49 -0700 (PDT) X-Virus-Scanned: Debian amavisd-new at cworth.org X-Spam-Flag: NO X-Spam-Score: -0.099 X-Spam-Level: X-Spam-Status: No, score=-0.099 tagged_above=-999 required=5 tests=[DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, HTML_MESSAGE=0.001] autolearn=disabled Received: from arlo.cworth.org ([127.0.0.1]) by localhost (arlo.cworth.org [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id fFsd4jDdPpP7 for ; Wed, 5 Sep 2018 06:04:48 -0700 (PDT) X-Greylist: delayed 43472 seconds by postgrey-1.36 at arlo; Wed, 05 Sep 2018 06:04:48 PDT Received: from pdx1-sub0-mail-fallback-a1.dreamhost.com (pdx1-sub0-mail-fallback-a1.dreamhost.com [64.90.62.138]) by arlo.cworth.org (Postfix) with ESMTPS id 8C4F56DE00D4 for ; Wed, 5 Sep 2018 06:04:48 -0700 (PDT) Received: from pdx1-sub0-mail-a20.g.dreamhost.com (unknown [10.35.42.118]) (using TLSv1.2 with cipher AECDH-AES256-SHA (256/256 bits)) (No client certificate requested) by pdx1-sub0-mail-fallback-a1.dreamhost.com (Postfix) with ESMTPS id 3709428295C for ; Tue, 4 Sep 2018 18:00:46 -0700 (PDT) Received: from pdx1-sub0-mail-a20.g.dreamhost.com (localhost [127.0.0.1]) by pdx1-sub0-mail-a20.g.dreamhost.com (Postfix) with ESMTP id 917347EAE9 for ; Tue, 4 Sep 2018 18:00:13 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=nawaz.org; h=message-id :from:to:subject:date:content-type:mime-version; s=nawaz.org; bh=v5ylY61nseHEm/fQMZSO8cUClaM=; b=382eBGPdWj82s+mOJeQSleCPbL1d i5nR0jLQAK6Df3a7R8n/S+LvUuPKWjmsEF4TetY8XAwgLIxDe9IdXpIPyfWlNH+S Gtp8585xJFkr3L/5tJpKluWiDwW+Yp+B/kTSo+UEsjZctj100fD9Ls2PJu94kSAF kjmYvaASC2esfck= Received: from localhost (alc-nat.dreamhost.com [66.33.206.8]) (using TLSv1 with cipher ECDHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) (Authenticated sender: mueen@nawaz.org) by pdx1-sub0-mail-a20.g.dreamhost.com (Postfix) with ESMTPSA id 632207E0AB for ; Tue, 4 Sep 2018 18:00:13 -0700 (PDT) Message-Id: <47409d4ed692a336458371102bcbcbd86ab4a067@webmail.nawaz.org> From: mueen@nawaz.org To: notmuch@notmuchmail.org X-Mailer: Atmail 7.8.0.2 X-Originating-IP: 50.39.167.193 Subject: Notmuch DB Problems Date: Tue, 04 Sep 2018 18:00:12 -0700 Content-Type: multipart/alternative; boundary="=_8030a30e3cb60b262d7ee20765f422a1" MIME-Version: 1.0 X-Mailman-Approved-At: Wed, 05 Sep 2018 07:15:20 -0700 X-BeenThere: notmuch@notmuchmail.org X-Mailman-Version: 2.1.26 Precedence: list List-Id: "Use and development of the notmuch mail system." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Wed, 05 Sep 2018 13:04:49 -0000 --=_8030a30e3cb60b262d7ee20765f422a1 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable =0AHi,=0A=0AA few days ago I noticed notmuch new was no longer working (= I have it=0Aas a cron job so it took a while to figure it out).=0A=0AIt= just freezes. I do have a Python hook, and it was freezing on the=0Alin= e that opens the database.=0A=0AI tried a notmuch dump. Same problem - f= reezes=0A=0ABased on some earlier threads, I tried a notmuch compact. Sa= me problem=0A- freezes.=0A=0AAll these freezes seem to use no memory/CPU= . =0A=0AInterestingly, queries work fine - from both the command line an= d the=0AEmacs interface. So I can read old stuff just fine. But all the= =0Acommands above cause a freeze. =0A=0ACurrently using notmuch-0.24.2.= I tried notmuch-0.27 - same problem.=0A=0AResults of a xapian check:=0A= =0Adocdata:=0Ablocksize=3D8K items=3D6 firstunused=3D3 revision=3D6442 l= evels=3D0 root=3D0=0AB-tree checked okay=0Adocdata table structure check= ed OK=0A=0Atermlist:=0Ablocksize=3D8K items=3D178562 firstunused=3D53441= revision=3D6442 levels=3D2=0Aroot=3D46086=0A/usr/bin/xapian-check: Data= baseError: 1 unused block(s) missing from=0Athe free list, first is 0=0A= =0AWhat are my options? Unfortunately the last dump I have is many month= s=0Aold, so I'm a bit wary of deleting the database and rebuilding. Give= n=0Athat the show and search commands work, I was wondering if I can wri= te=0Aa script to get all the message/thread ID's for all the tags and st= ore=0Athem, and then rebuild the database and use that stored informatio= n to=0Aretag all my messages (all without using the dump command)?=0A=0A= Thanks!=0A=0AMueen=0A --=_8030a30e3cb60b262d7ee20765f422a1 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi,

A few days ago I noticed notmu= ch new was no longer working (I have it as a cron job so it took a while= to figure it out).

It just freezes. I do have= a Python hook, and it was freezing on the line that opens the database.=

I tried a notmuch dump. Same problem - freezes=

Based on some earlier threads, I tried a notmu= ch compact. Same problem - freezes.

All these f= reezes seem to use no memory/CPU.

Interest= ingly, queries work fine - from both the command line and the Emacs inte= rface. So I can read old stuff just fine. But all the commands above cau= se a freeze.

Currently using notmuch-0.24.= 2. I tried notmuch-0.27 - same problem.

Results= of a xapian check:

docdata:
blocksize=3D8K items= =3D6 firstunused=3D3 revision=3D6442 levels=3D0 root=3D0
B-tree check= ed okay
docdata table structure checked OK

termlist:
blocks= ize=3D8K items=3D178562 firstunused=3D53441 revision=3D6442 levels=3D2 r= oot=3D46086
/usr/bin/xapian-check: DatabaseError: 1 unused block(s) m= issing from the free list, first is 0

What are my options? U= nfortunately the last dump I have is many months old, so I'm a bit wary= of deleting the database and rebuilding. Given that the show and search= commands work, I was wondering if I can write a script to get all the m= essage/thread ID's for all the tags and store them, and then rebuild the= database and use that stored information to retag all my messages (all= without using the dump command)?

Thanks!
=

Mueen
--=_8030a30e3cb60b262d7ee20765f422a1--