Return-Path: X-Original-To: apmail-couchdb-dev-archive@www.apache.org Delivered-To: apmail-couchdb-dev-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 3A0119FAB for ; Wed, 25 Apr 2012 16:30:45 +0000 (UTC) Received: (qmail 96154 invoked by uid 500); 25 Apr 2012 16:30:44 -0000 Delivered-To: apmail-couchdb-dev-archive@couchdb.apache.org Received: (qmail 95990 invoked by uid 500); 25 Apr 2012 16:30:44 -0000 Mailing-List: contact dev-help@couchdb.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@couchdb.apache.org Delivered-To: mailing list dev@couchdb.apache.org Received: (qmail 95963 invoked by uid 99); 25 Apr 2012 16:30:43 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Apr 2012 16:30:43 +0000 X-ASF-Spam-Status: No, hits=-2000.0 required=5.0 tests=ALL_TRUSTED,T_RP_MATCHES_RCVD X-Spam-Check-By: apache.org Received: from [140.211.11.116] (HELO hel.zones.apache.org) (140.211.11.116) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 25 Apr 2012 16:30:40 +0000 Received: from hel.zones.apache.org (hel.zones.apache.org [140.211.11.116]) by hel.zones.apache.org (Postfix) with ESMTP id 7D7BC35F875 for ; Wed, 25 Apr 2012 16:30:19 +0000 (UTC) Date: Wed, 25 Apr 2012 16:30:19 +0000 (UTC) From: "Matt Goodall (JIRA)" To: dev@couchdb.apache.org Message-ID: <774369036.963.1335371419593.JavaMail.tomcat@hel.zones.apache.org> In-Reply-To: <37125276.25139.1331914778562.JavaMail.tomcat@hel.zones.apache.org> Subject: [jira] [Commented] (COUCHDB-1444) missing_named_view error on existing javascript design doc and view MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/COUCHDB-1444?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13261783#comment-13261783 ] Matt Goodall commented on COUCHDB-1444: --------------------------------------- Looks like the same problem happened to me today, running: OS: Ubuntu 10.04.4 LTS Erlang: R13B03 CouchDB: 1.2.0, compiled from the 1.2.x branch. As for Sam, views that had been working for some time (no design doc updates at all, in fact) suddenly started returning a 404 (not_found, missing_named_view) error. All failing views were in the same design doc. However, views in another design doc were still working correctly. So it *seems* as if a single design doc got forgotten somehow. No compaction (views or db) was running or had run recently. After restarting CouchDB, all views started working again. There's nothing in the log file that's any more useful than Sam already posted. I saw no obvious increase in open file descriptors or anything else that might reasonably explain a problem like this. > missing_named_view error on existing javascript design doc and view > ------------------------------------------------------------------- > > Key: COUCHDB-1444 > URL: https://issues.apache.org/jira/browse/COUCHDB-1444 > Project: CouchDB > Issue Type: Bug > Components: Database Core > Affects Versions: 1.1.1 > Environment: Ubuntu 11.01 64 bit Erlang R13B03 > Reporter: Sam Lown > Priority: Critical > Labels: 404, bug, missing_named_view > Attachments: couchdb-missing-view.log > > > Moved over from issue: https://issues.apache.org/jira/browse/COUCHDB-1225 which has similar symptoms but the view is written in Erlang. > On our production server for no apparent reason, one of our views just suddenly stopped responding to requests. The design document was still visible in Futon and the "all" view did provide a list of documents. All other views in the ddoc responded with a 404 {"error":"not_found","reason":"missing_named_view"}. > Restarting the couchdb server resolved the issue, and I've as yet been unable to reproduce the problem. > Here is the last successful log entry for the view: > [Fri, 16 Mar 2012 13:14:19 GMT] [info] [<0.831.531>] 192.168.163.3 - - 'GET' /maxi/_design/Payment/_view/by_journey_id_and_sequence?startkey=%5B%229bd1647eb09fca1634a8a6129a8cff46%22%2C%7B%7D%5D&endkey=%5B%229bd1647eb09fca1634a8a6129a8cff46%22%5D&limit=1&descending=true&include_docs=true&reduce=false 200 > Many requests later to other documents and views, here is when requests stopped working, some 6 minutes later: > [Fri, 16 Mar 2012 13:20:29 GMT] [info] [<0.4510.531>] 192.168.163.3 - - 'GET' /maxi/_design/Payment/_view/by_user_id_and_created_at?startkey=%5B%22a0d0912e031b8fd28c2f89f828eebb12%22%5D&endkey=%5B%22a0d0912e031b8fd28c2f89f828eebb12%22%2C%7B%7D%5D&reduce=true&skip=0&limit=1 404 > Here is the design document in question: https://gist.github.com/2050446 > I could see nothing in the logs out of the ordinary. > Obviously, this problem is very alarming indeed and not something I've come across before in CouchDB. As you can see the view in question is related to Payments, which is something we really do not want to go wrong. > Please let me know if I can provide more information. -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa For more information on JIRA, see: http://www.atlassian.com/software/jira