[COUCHDB-1444] missing_named_view error on existing javascript design doc and view

• Type: Bug
• Status: Resolved
• Priority: Critical
• Resolution: Fixed
• Affects Version/s: 1.1.1
• Fix Version/s: 1.2.1, 1.3
• Component/s: Database Core
• Labels: 404 bug missing_named_view

Environment

Ubuntu 11.01 64 bit Erlang R13B03

• Skill Level: Dont Know
• Assignee: Unassigned
• Reporter: Sam Lown
• Created: 16/Mar/12 16:18
• Updated: 22/Aug/12 15:05
• Resolved: 21/Aug/12 12:44

Description

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.

Issue Links

• relates to: COUCHDB-1225 missing_named_view error on existing erlang design doc and view