You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@couchdb.apache.org by "Sam Lown (Commented) (JIRA)" <ji...@apache.org> on 2012/03/16 16:09:39 UTC

[jira] [Commented] (COUCHDB-1225) missing_named_view error on existing erlang design doc and view

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

Sam Lown commented on COUCHDB-1225:
-----------------------------------

Hi. This problem has just happened to me also, for no apparent reason. One of our views just suddenly stopped existing, yet no request had been made to modify the design document.

Here is the last successful log entry:

    [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

Here is the following failure, 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

Strangely, Futon was able to access results from the "all" view, but was unable to access the others. The designs did come up in the list. Restarting the server resolved the problem. So far, this is the first time I've seen such a problem.

We're running CouchDB 1.1.1 compiled from source on Ubuntu 11.04 64bit. Its been running fine for the last 6 months.

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.
                
> missing_named_view error on existing erlang design doc and view
> ---------------------------------------------------------------
>
>                 Key: COUCHDB-1225
>                 URL: https://issues.apache.org/jira/browse/COUCHDB-1225
>             Project: CouchDB
>          Issue Type: Bug
>         Environment: Erlang 1:14.b.3
> CouchDB 1.2.0a-f7cc8fa-git
> Ubuntu Lucid 10.04 64bit
>            Reporter: Alex Koshelev
>
> curl foo.bar:5984/cray_frame_11266/_design/admin/_view/regions_by_channel?limit=1
> {"error":"not_found","reason":"missing_named_view"}
> It worked some time ago but now there is constantly the error. If I restart CoucDB it will solve this issue. Updating the desing doc also solves the issue.
> With debug log level I get this messages:
> [Sat, 16 Jul 2011 23:40:44 GMT] [debug] [<0.898.3>] 'GET' /cray_frame_11266/_design/admin/_view/regions_by_channel?limit=1 {1,
>                                                                                             1} from "93.158.159.91"
> Headers: [{'Accept',"*/*"},
>           {'Host',"foo.bar:5984"},
>           {'User-Agent',"curl/7.19.7 (x86_64-pc-linux-gnu) libcurl/7.19.7 OpenSSL/0.9.8k zlib/1.2.3.3 libidn/1.15"}]
> [Sat, 16 Jul 2011 23:40:44 GMT] [debug] [<0.898.3>] OAuth Params: [{"limit","1"}]
> [Sat, 16 Jul 2011 23:40:44 GMT] [debug] [<0.898.3>] request_group {Pid, Seq} {<0.6419.0>,311}
> [Sat, 16 Jul 2011 23:40:44 GMT] [debug] [<0.898.3>] request_group {Pid, Seq} {<0.6419.0>,311}
> [Sat, 16 Jul 2011 23:40:44 GMT] [debug] [<0.898.3>] Minor error in HTTP request: {not_found,
>                                                   missing_named_view}
> [Sat, 16 Jul 2011 23:40:44 GMT] [debug] [<0.898.3>] Stacktrace: [{io_lib_pretty,cind_tag_tuple,7},
>                                  {io_lib_pretty,while_fail,3},
>                                  {io_lib_pretty,print,6},
>                                  {io_lib_format,build,3},
>                                  {io_lib_format,build,3},
>                                  {io_lib_format,build,3},
>                                  {io_lib_format,build,3},
>                                  {io_lib_format,build,3}]
> [Sat, 16 Jul 2011 23:40:44 GMT] [info] [<0.898.3>] 0.0.0.0 - - GET /cray_frame_11266/_design/admin/_view/regions_by_channel?limit=1 404
> [Sat, 16 Jul 2011 23:40:44 GMT] [debug] [<0.898.3>] httpd 404 error response:
>  {"error":"not_found","reason":"missing_named_view"}
> I've also tried to get _info about design doc and found that it have had zero data_size:
> > curl foo.bar:5984/cray_frame_11266/_design/admin/_info | python -mjson.tool
> {
>     "name": "admin", 
>     "view_index": {
>         "compact_running": false, 
>         "data_size": 0, 
>         "disk_size": 90241, 
>         "language": "erlang", 
>         "purge_seq": 0, 
>         "signature": "09b8b599cad584406b7aa5956b98a335", 
>         "update_seq": 311, 
>         "updater_running": false, 
>         "waiting_clients": 0, 
>         "waiting_commit": false
>     }
> }
> In the same time another similar design doc works fine and has some data_size:
> > curl foo.bar:5984/cray_frame_11266/_design/web/_info | python -mjson.tool
> {
>     "name": "web", 
>     "view_index": {
>         "compact_running": false, 
>         "data_size": 7462075, 
>         "disk_size": 9138406, 
>         "language": "erlang", 
>         "purge_seq": 0, 
>         "signature": "7f01f0c843b3bbb79d00ec4ff8d43010", 
>         "update_seq": 311, 
>         "updater_running": false, 
>         "waiting_clients": 0, 
>         "waiting_commit": false
>     }
> }
> Over the year ago Mark Anderson has asked similar questing in the thread called "Need help diagnosing couchdb view 404s" [1] but seams did not found any answer than. 
> [1]: http://comments.gmane.org/gmane.comp.db.couchdb.user/8994

--
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