Mailing-List: contact dev-help@couchdb.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@couchdb.apache.org
Message-ID: <31006446.210791281157036579.JavaMail.jira@thor>
Date: Sat, 7 Aug 2010 00:57:16 -0400 (EDT)
From: "Lim Yue Chuan (JIRA)" <jira@apache.org>
To: dev@couchdb.apache.org
Subject: [jira] Commented: (COUCHDB-844) Documents missing after CouchDB
 restart
In-Reply-To: <22606105.177591281001036447.JavaMail.jira@thor>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/COUCHDB-844?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12896218#action_12896218 ] 

Lim Yue Chuan commented on COUCHDB-844:
---------------------------------------

As requested, I am having the same problem and have forwarded the database in question to J Chris. Do mail me if you need a copy.

Disk consistency check :
C:\>chkdsk c:
The type of the file system is NTFS.
~ snip ~
CHKDSK is verifying files (stage 1 of 3)...
  366848 file records processed.
File verification completed.
  304 large file records processed.
  0 bad file records processed.
  2 EA records processed.
  179 reparse records processed.
CHKDSK is verifying indexes (stage 2 of 3)...
  454806 index entries processed.
Index verification completed.
  0 unindexed files scanned.
  0 unindexed files recovered.
CHKDSK is verifying security descriptors (stage 3 of 3)...
  366848 file SDs/SIDs processed.
Security descriptor verification completed.
  43980 data files processed.
CHKDSK is verifying Usn Journal...
  36799960 USN bytes processed.
Usn Journal verification completed.
Windows has checked the file system and found no problems.

 209612799 KB total disk space.
 101378104 KB in 322461 files.
    136072 KB in 43981 indexes.
         0 KB in bad sectors.
    476195 KB in use by the system.
     65536 KB occupied by the log file.
 107622428 KB available on disk.

      4096 bytes in each allocation unit.
  52403199 total allocation units on disk.
  26905607 allocation units available on disk.

At no point in time is the disk anywhere close to full.

Running Windows 7 32-bit, NTFS filesystem, harddisk is ST31000528AS - a Seagate 1TB harddisk. Partitoned into 200GB/731GB (200GB is the system partition, and also where CouchDB is installed). Installation directory is in Program Files.

Write caching policy option in Windows is enabled, write-cache buffer flushing is NOT enabled. (These are system defaults, typical of just about every Windows system I have ever encountered, Windows advises that the second option not be turned on unless a UPS is present, I have never made use of the second option).

I am using Mark Hammond's installation of CouchDB (not the one off couch.io)

Do let me know if you require any further details.


> Documents missing after CouchDB restart
> ---------------------------------------
>
>                 Key: COUCHDB-844
>                 URL: https://issues.apache.org/jira/browse/COUCHDB-844
>             Project: CouchDB
>          Issue Type: Bug
>          Components: Database Core
>    Affects Versions: 1.0
>         Environment: Debian Version 5.0.5, Linux *** 2.6.29-xs5.5.0.17 #1 SMP Mon Aug 3 17:37:37 UTC 2009 i686 GNU/Linux, XenServer Guest
>            Reporter: Sascha Reuter
>            Priority: Critical
>
> After a CouchDB restart, recently added/changed documents+designdocuments (min. 2 weeks timeline!) are missing and cant be accessed trough REST Calls / Futon. 
> All documents that are still available trought REST/Futon only exist in old revisions.
> All documents/revisions can be found doing a manual search (less/egrep/...) in the datafile (/var/lib/couchdb/<database>.couch)
> Example:
> strings dtap.couch | grep -i "226b2e6c-24b7-4336-92c7-257abf923b11"
> $226b2e6c-24b7-4336-92c7-257abf923b11h
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11l
> $226b2e6c-24b7-4336-92c7-257abf923b11h
> $226b2e6c-24b7-4336-92c7-257abf923b11h
> curl http://localhost:5984/dtap/226b2e6c-24b7-4336-92c7-257abf923b11
> {"error":"not_found","reason":"missing"}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.