Querying view results in error

Sergey Avseyev added a comment - 25/Jul/12 12:31 AM is this all info regarding the issue? what steps are you doing to get the error? if ot is ruby, how can I reproduce it?

Matt Ingenthron added a comment - 25/Jul/12 2:23 AM After discussing this with Sergey, who will put in more notes, the error message: row 'partiton' value is not an integer ... is coming back directly from the server in the errors array. It would seem to indicate the data on disk is not passing some validation I think? Sergey identified it here: https://github.com/couchbase/couchdb/blob/master/src/couch_view_parser/couch_view_parser.cc#L63 Accordingly, I'm passing this to Peter who can get it to the right person.

Matt Ingenthron added a comment - 25/Jul/12 2:25 AM I've added Filipe as a watcher, who may be able to look at it before Peter looks at it.

Marty Schoch added a comment - 25/Jul/12 6:52 AM Server diagnostics

Filipe Manana added a comment - 25/Jul/12 6:57 AM Thanks, but the server diagnostics are not useful here. The obvious is to curl http://10.10.163.246:8092/_view_merge/?descending=true&reduce=false&include_docs=true&stale=false&limit=11 and paste the output.

Marty Schoch added a comment - 25/Jul/12 6:57 AM Until now I hadn't been able to reproduce it outside the application, but I just got it: http://ec2-204-236-211-26.compute-1.amazonaws.com:8092/default/_design/article/_view/by_popularity_and_type?connection_timeout=60000&limit=10&skip=0&reduce=false&descending=true&include_docs=true&stale=false&start_key= [%22video%22,0] Returns: { "total_rows": 18674, "rows": [ { "id": "9939125", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9939125", "_rev": "1-000185cffe1e608b0000000000000000", "$expiration": 0, "$flags": 0, "title": "Les Fatals Picards", "url": " http://en.wikipedia.org/wiki/Les_Fatals_Picards ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "Articles with French language external links", "Articles with hCards", "Comedy musical groups", "Eurovision Song Contest entrants of 2007", "French Eurovision Song Contest entrants", "French musical group stubs", "French musical groups" ], "timestamp": "2012-04-28T05:39:08Z", "content": " http://ia600304.us.archive.org/23/items/Jewelrytelevision-MatchedPairSemiPreciousGemstones536/Jewelrytelevision-MatchedPairSemiPreciousGemstones536.ogv ", "authors": [ { "name": "Werldwayd" } ], "contributors": [ { "name": "Werldwayd", "timestamp": "2012-04-28T05:39:08Z" } ] } }, { "id": "993373", "key": [ "video", 0 ], "value": null, "doc": { "_id": "993373", "_rev": "1-000185d64c7bbcce0000000000000000", "$expiration": 0, "$flags": 0, "title": "Rickettsia rickettsii", "url": " http://en.wikipedia.org/wiki/Rickettsia_rickettsii ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "Articles with 'species' microformats", "Gram-negative bacteria", "Rickettsiales", "Zoonoses" ], "timestamp": "2012-04-28T14:05:24Z", "content": " http://ia600504.us.archive.org/21/items/Nitaai-RadhashtamiKirtana01801/Nitaai-RadhashtamiKirtana01801.ogv ", "authors": [ { "name": "ChrisGualtieri" } ], "contributors": [ { "name": "ChrisGualtieri", "timestamp": "2012-04-28T14:05:24Z" } ] } }, { "id": "9893679", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9893679", "_rev": "1-0001862f7b3513160000000000000000", "$expiration": 0, "$flags": 0, "title": "Ifeoma Ozoeze", "url": " http://en.wikipedia.org/wiki/Ifeoma_Ozoeze ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "1971 births", "Italian athletics biography stubs", "Italian heptathletes", "Living people" ], "timestamp": "2012-07-07T23:16:28Z", "content": " http://ia601201.us.archive.org/20/items/DrinkingWithBob-AmericaTreatsAmericansLikeCrap505-2/DrinkingWithBob-AmericaTreatsAmericansLikeCrap505.ogv ", "authors": [ { "name": "HRoestBot" } ], "contributors": [ { "name": "HRoestBot", "timestamp": "2012-07-07T23:16:28Z" } ] } }, { "id": "988771", "key": [ "video", 0 ], "value": null, "doc": { "_id": "988771", "_rev": "1-0001849ca1eb7ebf0000000000000000", "$expiration": 0, "$flags": 0, "title": "Bitmap textures", "url": " http://en.wikipedia.org/wiki/Bitmap_textures ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "Computer graphics", "Graphics software stubs" ], "timestamp": "2012-05-02T16:25:56Z", "content": " http://ia600406.us.archive.org/30/items/OsuNrotc1cCruiseVideo/NrotcSummerCruiseNew.ogv ", "authors": [ { "name": "Rally24" } ], "contributors": [ { "name": "Rally24", "timestamp": "2012-05-02T16:25:56Z" } ] } }, { "id": "9811499", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9811499", "_rev": "2-00018657f77e96810000000000000000", "$expiration": 0, "$flags": 0, "title": "Windsor Way (Vancouver)", "url": " http://en.wikipedia.org/wiki/Windsor_Way_(Vancouver) ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "Geography of Vancouver", "Transport in Greater Vancouver", "Vancouver stubs" ], "timestamp": "2012-07-03T02:24:48Z", "content": " http://ia601206.us.archive.org/13/items/dom-412322-justmeandmyblunt-musicvideo/me_and_my_blunt-dvd_0.ogv ", "authors": [ { "name": "AvicBot" } ], "contributors": [ { "name": "AvicBot", "timestamp": "2012-07-03T02:24:48Z" } ] } }, { "id": "9721881", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9721881", "_rev": "36-0001bc048b9485240000000000000000", "$expiration": 0, "$flags": 0, "title": "Menedemus of Pyrrha", "url": " http://en.wikipedia.org/wiki/Menedemus_of_Pyrrha ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "4th-century BC Greek people", "4th-century BC philosophers", "Academic philosophers", "Ancient Greek philosophers", "Philosopher stubs" ], "timestamp": "2011-10-01T19:50:25Z", "content": " http://ia600301.us.archive.org/11/items/kylegolfswing/kylegolfswing.ogv ", "authors": [ { "name": "209.73.132.213" } ], "contributors": [ { "name": "209.73.132.213", "timestamp": "2011-10-01T19:50:25Z" } ], "id": "9721881" } }, { "id": "9718109", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9718109", "_rev": "1-00018476a5e245b40000000000000000", "$expiration": 0, "$flags": 0, "title": "VietNam (album)", "url": " http://en.wikipedia.org/wiki/VietNam_(album) ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "2007 albums", "All articles needing additional references", "All articles with dead external links", "Articles needing additional references from June 2011", "Articles with album ratings that need to be turned into prose", "Articles with dead external links from June 2011", "Articles with hAudio microformats", "VietNam albums" ], "timestamp": "2011-06-27T00:21:36Z", "content": " http://ia600704.us.archive.org/12/items/SpanishFamilyAndFriendsProject/SpanishProject.ogv ", "authors": [ { "name": "Fitoschido" } ], "contributors": [ { "name": "Fitoschido", "timestamp": "2011-06-27T00:21:36Z" } ] } }, { "id": "9560193", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9560193", "_rev": "1-000185a3b7cb2c330000000000000000", "$expiration": 0, "$flags": 0, "title": "Davis Mwale", "url": " http://en.wikipedia.org/wiki/Davis_Mwale ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "1972 births", "African boxing biography stubs", "Boxers at the 1996 Summer Olympics", "Boxers at the 2004 Summer Olympics", "Living people", "Olympic boxers of Zambia", "Persondata templates without short description parameter", "Welterweight boxers", "Zambian boxers", "Zambian sportspeople stubs" ], "timestamp": "2011-07-08T04:30:36Z", "content": " http://ia600408.us.archive.org/30/items/UniversityofLethbridgeGlobalizationStudies_7/Dijla_AlRekabi_10of10.ogv ", "authors": [ { "name": "Cydebot" } ], "contributors": [ { "name": "Cydebot", "timestamp": "2011-07-08T04:30:36Z" } ] } }, { "id": "9412979", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9412979", "_rev": "1-000185e7e1168b660000000000000000", "$expiration": 0, "$flags": 0, "title": "Pushforward measure", "url": " http://en.wikipedia.org/wiki/Pushforward_measure ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "All articles lacking sources", "Articles lacking sources from February 2007", "Measures (measure theory)" ], "timestamp": "2012-07-19T15:21:17Z", "content": " http://ia600400.us.archive.org/14/items/Hollywood_Man/Hollywood_Man.ogv ", "authors": [ { "name": "ZéroBot" } ], "contributors": [ { "name": "ZéroBot", "timestamp": "2012-07-19T15:21:17Z" } ] } }, { "id": "9385075", "key": [ "video", 0 ], "value": null, "doc": { "_id": "9385075", "_rev": "1-000185583e41ef4f0000000000000000", "$expiration": 0, "$flags": 0, "title": "Peter Clifton", "url": " http://en.wikipedia.org/wiki/Peter_Clifton ", "type": "video", "is_text": false, "is_video": true, "is_image": false, "popularity": 0, "views": 0, "categories": [ "1947 births", "All articles lacking in-text citations", "Articles lacking in-text citations from April 2009", "Australian film directors", "Led Zeppelin", "Living people", "People from New South Wales", "Use dmy dates from April 2011" ], "timestamp": "2012-06-15T20:07:43Z", "content": " http://ia600508.us.archive.org/13/items/MikeRorkeTheManBurns/MOV03006.ogv ", "authors": [ { "name": "Waacstats" } ], "contributors": [ { "name": "Waacstats", "timestamp": "2012-06-15T20:07:43Z" } ] } } ], "errors": [ { "from": " http://10.226.114.27:8092/_view_merge/?startkey=%5B%22video%22%2C0%5D&descending=true&reduce=false&include_docs=true&stale=false&limit=10 ", "reason": "row 'partition' value is not an integer" }, { "from": " http://10.10.163.246:8092/_view_merge/?startkey=%5B%22video%22%2C0%5D&descending=true&reduce=false&include_docs=true&stale=false&limit=10 ", "reason": "row 'partition' value is not an integer" } ] }

Filipe Manana added a comment - 25/Jul/12 7:02 AM Thanks Marty, but that's not the URL I was interested in, it's the following one I wanted: http://10.10.163.246:8092/_view_merge/?descending=true&reduce=false&include_docs=true&stale=false&limit=11

Marty Schoch added a comment - 25/Jul/12 7:02 AM Additional curl for the _view_merge queries: curl " http://10.226.114.27:8092/_view_merge/?startkey=%5B%22video%22%2C0%5D&descending=true&reduce=false&include_docs=true&stale=false&limit=10 " {"error":"bad_request","reason":"`views` parameter must be an object with at least 1 property."} curl " http://10.10.163.246:8092/_view_merge/?startkey=%5B%22video%22%2C0%5D&descending=true&reduce=false&include_docs=true&stale=false&limit=10 " {"error":"bad_request","reason":"`views` parameter must be an object with at least 1 property."}

Marty Schoch added a comment - 25/Jul/12 7:04 AM The specific one you requested is: curl " http://10.10.163.246:8092/_view_merge/?descending=true&reduce=false&include_docs=true&stale=false&limit=11 " {"error":"bad_request","reason":"`views` parameter must be an object with at least 1 property."}

Filipe Manana added a comment - 25/Jul/12 7:06 AM Thanks, forgot to mention you need to POST to those URLs, with Content-Type of application/json, and pass a body to curl like this: curl -X POST -H 'Content-Type: application/json' <<URL>> -d '{"views": {"sets": {"default": {"view": "_design/article/by_popularity_and_type", "partitions": [}}}}'

Marty Schoch added a comment - 25/Jul/12 7:10 AM That produces: curl -X POST -H 'Content-Type: application/json' " http://10.10.163.246:8092/_view_merge/?descending=true&reduce=false&include_docs=true&stale=false&limit=11 " -d '{"views": {"sets": {"default": {"view": "_design/article/by_popularity_and_type", "partitions": []}}}}' {"total_rows":19328,"rows":[ {"id":"991496","key":["video",0],"value":null,"doc":{"_id":"991496","_rev":"38-0001bc902f88edfc0000000000000000","$expiration":0,"$flags":0,"title":"Durrow, County Offaly","url":" http://en.wikipedia.org/wiki/Durrow,_County_Offaly ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0.0,"views":0,"categories":["Articles containing Irish language text","Articles to be expanded from October 2007","Ireland geography stubs","Towns and villages in County Offaly","Untranslated Irish place names"],"timestamp":"2012-06-04T12:10:10Z","content":" http://ia600309.us.archive.org/11/items/Gbtemple-TheMostHonorablePerson156/Gbtemple-TheMostHonorablePerson156.ogv ","authors":[{"name":"84.111.129.33"}],"contributors":[{"name":"84.111.129.33","timestamp":"2012-06-04T12:10:10Z"}],"id":"991496"}}, {"id":"9861993","key":["video",0],"value":null,"doc":{"_id":"9861993","_rev":"37-0001bc908e4805850000000000000000","$expiration":0,"$flags":0,"title":"Chief Blue Meanie","url":" http://en.wikipedia.org/wiki/Chief_Blue_Meanie ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0.0,"views":0,"categories":["All articles lacking sources","Articles lacking sources from March 2007","Fictional dictators","MGM cartoon characters"],"timestamp":"2012-04-28T04:25:26Z","content":" http://ia700306.us.archive.org/29/items/BartWeetjens_2010X/BartWeetjens_2010X.ogv ","authors":[{"name":"Mark Arsten"}],"contributors":[{"name":"Mark Arsten","timestamp":"2012-04-28T04:25:26Z"}],"id":"9861993"}}, {"id":"9809032","key":["video",0],"value":null,"doc":{"_id":"9809032","_rev":"38-0001bc911575886c0000000000000000","$expiration":0,"$flags":0,"title":"Hafei Lobo","url":" http://en.wikipedia.org/wiki/Hafei_Lobo ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0.0,"views":0,"categories":["Cars of China","City cars","Modern auto stubs"],"timestamp":"2012-04-24T18:25:58Z","content":" http://ia600300.us.archive.org/11/items/dom-24252-revelationofjesusname/To_God_Be_the_Glory_ep7.ogv ","authors":[{"name":"Mr.choppers"}],"contributors":[{"name":"Mr.choppers","timestamp":"2012-04-24T18:25:58Z"}],"id":"9809032"}}, {"id":"980191","key":["video",0],"value":null,"doc":{"_id":"980191","_rev":"38-0001bc9131dcd7f50000000000000000","$expiration":0,"$flags":0,"title":"LUMS","url":" http://en.wikipedia.org/wiki/LUMS ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0.0,"views":0,"categories":["All article disambiguation pages","All disambiguation pages","Article Feedback Blacklist","Disambiguation pages"],"timestamp":"2012-03-02T19:27:19Z","content":" http://ia600508.us.archive.org/11/items/mortdegerry/mortdegerry.ogv ","authors":[{"name":"BD2412"}],"contributors":[{"name":"BD2412","timestamp":"2012-03-02T19:27:19Z"}],"id":"980191"}}, {"id":"9795243","key":["video",0],"value":null,"doc":{"_id":"9795243","_rev":"38-0001bc91439590440000000000000000","$expiration":0,"$flags":0,"title":"Wisdom of Children","url":" http://en.wikipedia.org/wiki/Wisdom_of_Children ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0.0,"views":0,"categories":["1885 short stories","Parables","Short stories by Leo Tolstoy"],"timestamp":"2012-05-03T15:50:33Z","content":" http://ia600209.us.archive.org/0/items/aidenmvi1550MVI1550mp4/MVI_1550.ogv ","authors":[{"name":"59.99.0.23"}],"contributors":[{"name":"59.99.0.23","timestamp":"2012-05-03T15:50:33Z"}],"id":"9795243"}}, {"id":"97393","key":["video",0],"value":null,"doc":{"_id":"97393","_rev":"38-0001bc91ce82d9f30000000000000000","$expiration":0,"$flags":0,"title":"Anuket","url":" http://en.wikipedia.org/wiki/Anuket ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0.0,"views":0,"categories":["All articles with unsourced statements","Articles with unsourced statements from September 2011","Egyptian goddesses","Egyptian mythology stubs","Sea and river goddesses"],"timestamp":"2012-05-14T19:30:14Z","content":" http://ia600501.us.archive.org/12/items/ResumenLatinoamericano16DeSeptiembreDe2010/ResumenLatinoamericano16DeSeptiembreDe2010.ogv ","authors":[{"name":"AvocatoBot"}],"contributors":[{"name":"AvocatoBot","timestamp":"2012-05-14T19:30:14Z"}],"id":"97393"}}, {"id":"9587750","key":["video",0],"value":null,"doc":{"_id":"9587750","_rev":"38-0001bc92cd91fe680000000000000000","$expiration":0,"$flags":0,"title":"A. W. Baxter","url":" http://en.wikipedia.org/wiki/A._W._Baxter ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0,"views":0,"categories":["1928 births","2005 deaths","American winemakers","Wine biography stubs"],"timestamp":"2011-01-17T03:49:51Z","content":" http://ia600302.us.archive.org/30/items/BURNcast-BURNcastTV18LalaToy202/BURNcast-BURNcastTV18LalaToy202.ogv ","authors":[{"name":"Agne27"}],"contributors":[{"name":"Agne27","timestamp":"2011-01-17T03:49:51Z"}],"id":"9587750"}}, {"id":"9433313","key":["video",0],"value":null,"doc":{"_id":"9433313","_rev":"39-0001bc96724fd20b0000000000000000","$expiration":0,"$flags":0,"title":"Ion (paintball marker)","url":" http://en.wikipedia.org/wiki/Ion_(paintball_marker) ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0.0,"views":0,"categories":["Paintball markers"],"timestamp":"2011-09-26T02:10:06Z","content":" http://ia700305.us.archive.org/26/items/AnimalsInModernLifere-edit/AnimalsInModernLife.ogv ","authors":[{"name":"143.105.199.91"}],"contributors":[{"name":"143.105.199.91","timestamp":"2011-09-26T02:10:06Z"}],"id":"9433313"}}, {"id":"9432377","key":["video",0],"value":null,"doc":{"_id":"9432377","_rev":"38-0001bc967820bf4b0000000000000000","$expiration":0,"$flags":0,"title":"List of mayors of Stonnington","url":" http://en.wikipedia.org/wiki/List_of_mayors_of_Stonnington ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0,"views":0,"categories":["Lists of Mayors and Lord Mayors of places in Australia","Victoria (Australia)-related lists"],"timestamp":"2012-01-16T03:03:08Z","content":" http://ia600705.us.archive.org/13/items/DissectingOwlPelletsInMs.DebrasClass/OwlPelletsInMs.ogv ","authors":[{"name":"124.191.113.107"}],"contributors":[{"name":"124.191.113.107","timestamp":"2012-01-16T03:03:08Z"}],"id":"9432377"}}, {"id":"9334327","key":["video",0],"value":null,"doc":{"_id":"9334327","_rev":"38-0001bc970848b71a0000000000000000","$expiration":0,"$flags":0,"title":"Daniel G. Aldrich","url":" http://en.wikipedia.org/wiki/Daniel_G._Aldrich ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0,"views":0,"categories":["1918 births","1990 deaths","Chancellors of the University of California","Persondata templates without short description parameter","University of California, Irvine","University of California, Riverside","University of Rhode Island alumni"],"timestamp":"2012-06-27T23:40:40Z","content":" http://ia600500.us.archive.org/1/items/JasonTalbotAnotherFineDayattheOffice/Movie_0001.ogv ","authors":[{"name":"FrescoBot"}],"contributors":[{"name":"FrescoBot","timestamp":"2012-06-27T23:40:40Z"}],"id":"9334327"}}, {"id":"9203878","key":["video",0],"value":null,"doc":{"_id":"9203878","_rev":"38-0001bc97bd2773700000000000000000","$expiration":0,"$flags":0,"title":"Baruch of Benevento","url":" http://en.wikipedia.org/wiki/Baruch_of_Benevento ","type":"video","is_text":false,"is_video":true,"is_image":false,"popularity":0,"views":0,"categories":["16th-century Italian rabbis","Italian history stubs","Italian religious biography stubs","Jewish scholars","Kabbalah stubs","Kabbalists","People from Naples","Persondata templates without short description parameter","Wikipedia articles incorporating a citation from the 1906 Jewish Encyclopedia","Wikipedia articles incorporating a citation from the 1906 Jewish Encyclopedia without a Wikisource reference","Wikipedia articles incorporating text from the 1906 Jewish Encyclopedia","Year of birth missing","Year of death missing"],"timestamp":"2011-07-14T11:17:05Z","content":" http://ia700301.us.archive.org/16/items/Erictester-Donna_Edwards_only_719668/Erictester-Donna_Edwards_only_719668.ogv ","authors":[{"name":"Chesdovi"}],"contributors":[{"name":"Chesdovi","timestamp":"2011-07-14T11:17:05Z"}],"id":"9203878"}} ] }

Marty Schoch added a comment - 25/Jul/12 7:14 AM The same query without include_docs=true: curl -X POST -H 'Content-Type: application/json' " http://10.10.163.246:8092/_view_merge/?descending=true&reduce=false&stale=false&limit=11 " -d '{"views": {"sets": {"default": {"view": "_design/article/by_popularity_and_type", "partitions": []}}}}' {"total_rows":19547,"rows":[ {"id":"991496","key":["video",0],"value":null}, {"id":"9861993","key":["video",0],"value":null}, {"id":"9809032","key":["video",0],"value":null}, {"id":"980191","key":["video",0],"value":null}, {"id":"9795243","key":["video",0],"value":null}, {"id":"97393","key":["video",0],"value":null}, {"id":"9587750","key":["video",0],"value":null}, {"id":"9433313","key":["video",0],"value":null}, {"id":"9432377","key":["video",0],"value":null}, {"id":"9334327","key":["video",0],"value":null}, {"id":"9203878","key":["video",0],"value":null} ] }

Filipe Manana added a comment - 25/Jul/12 9:34 AM Fixed in master, gerrit change: http://review.couchbase.org/#change,18811

Thuan Nguyen added a comment - 25/Jul/12 7:22 PM Integrated in github-couchdb-preview #456 (See [ http://qa.hq.northscale.net/job/github-couchdb-preview/456/ ])      MB-6013 Fix parser error if doc has a boolean field (Revision 3430b7660ae1e753159a3eaee6582e69611783e9)      Result = SUCCESS Filipe David Borba Manana : Files : * src/couch_view_parser/couch_view_parser.cc * src/couch_view_parser/test/01-map-view.t