couchdb-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Marten Feldtmann (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (COUCHDB-1797) Query against a view creates a questionable result
Date Mon, 20 May 2013 11:25:15 GMT

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

Marten Feldtmann commented on COUCHDB-1797:
-------------------------------------------

The original databse is not available any more (and the code). Therefore I setup a new database
with a new result set (here the last row-item is buggy). Here I add the document to the value-column
- therefore doc-column and value-column should be the same here (regarding the race conflict
mentioned above).

When I ran the query manually for the last (error-) row item via

http://localhost:5984/test6/ac79d7c1b19b8aaa31ae6a7a2cceca1f

I get

"_rev":"1-c95452f27644775049635a4f2927bd43"

as delivered in the value-column of the fifth row-item.

'{"total_rows":12006,"offset":0,"rows":[
{"id":"ac79d7c1b19b8aaa31ae6a7a2cce4d80","key":"ni13_1_2013101_20130520131528540","value":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cce4d80","_rev":"1-86415f3f3b91f3b501a7e524a9f279c2","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528540","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_198315185042540532045688340481_3546501328540","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}},"doc":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cce4d80","_rev":"1-86415f3f3b91f3b501a7e524a9f279c2","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528540","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_198315185042540532045688340481_3546501328540","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}}},
{"id":"ac79d7c1b19b8aaa31ae6a7a2cce5cc7","key":"ni13_1_2013101_20130520131528659","value":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cce5cc7","_rev":"1-a6cf334a1b0a3642d2856ec37982abb2","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528659","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_779537131052834256046960672769_3546501328659","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}},"doc":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cce5cc7","_rev":"1-a6cf334a1b0a3642d2856ec37982abb2","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528659","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_779537131052834256046960672769_3546501328659","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}}},
{"id":"ac79d7c1b19b8aaa31ae6a7a2cce7591","key":"ni13_1_2013101_20130520131528695","value":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cce7591","_rev":"1-8b8ca10911a62368b363d45e58cdda38","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528695","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_765718287174818820142466596865_3546501328695","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}},"doc":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cce7591","_rev":"1-8b8ca10911a62368b363d45e58cdda38","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528695","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_765718287174818820142466596865_3546501328695","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}}},
{"id":"ac79d7c1b19b8aaa31ae6a7a2cceb05c","key":"ni13_1_2013101_20130520131528872","value":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cceb05c","_rev":"1-c808e38343168b90d03a35c2531cf080","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528872","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_553643079724099342449051172865_3546501328872","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}},"doc":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cceb05c","_rev":"1-c808e38343168b90d03a35c2531cf080","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131528872","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_553643079724099342449051172865_3546501328872","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}}},
{"id":"ac79d7c1b19b8aaa31ae6a7a2cceca1f","key":"ni13_1_2013101_20130520131529025","value":{"_id":"ac79d7c1b19b8aaa31ae6a7a2cceca1f","_rev":"1-c95452f27644775049635a4f2927bd43","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130520131529025","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_399893561149819693591485743105_3546501329025","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-df/RyfDzAFGKKg5zA8KCAg==","length":4533,"stub":true}}},"doc":null}
]}
'
                
> Query against a view creates a questionable result
> --------------------------------------------------
>
>                 Key: COUCHDB-1797
>                 URL: https://issues.apache.org/jira/browse/COUCHDB-1797
>             Project: CouchDB
>          Issue Type: Bug
>          Components: Database Core
>    Affects Versions: 1.3
>            Reporter: Marten Feldtmann
>
> I have a test system (CouchDB 1.3.0 under windows 7/64 Bit), where I insert lots of documents(100000)
to get a regular flow of new incoming documents.
> The database has also some views (25). Another task is reading documents from a view,
change some attributes and then the document should disappear from the view (and appear in
another view). Something like a state machine.
> I do the following query against a view:
> http://localhost:5984/test5/_design/ticketorggraphics/_view/waiting?limit=5&include_docs=true&include_end=true
> and get the following string:
> {"total_rows":9224,"offset":0,"rows":[
> {"id":"92224c2862ef49c15f3d51e3e7283cde","key":"ni13_1_2013101_20130518155518065","value":"ni13_2013101_VsPercentResult_83519204509647","doc":{"_id":"92224c2862ef49c15f3d51e3e7283cde","_rev":"1-6e8b57744c2b88f3d2dcad602e2e3353","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130518155518065","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_83519204509647","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-sdff2jkxp4w6xsSlx5Yzxw==","length":4533,"stub":true}}}},
> {"id":"92224c2862ef49c15f3d51e3e7285d38","key":"ni13_1_2013101_20130518155518135","value":"ni13_2013101_VsPercentResult_16771681663808","doc":{"_id":"92224c2862ef49c15f3d51e3e7285d38","_rev":"1-05b92282ec5f2d1b6d56912760792702","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130518155518135","priority":1,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_16771681663808","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-sdff2jkxp4w6xsSlx5Yzxw==","length":4533,"stub":true}}}},
> {"id":"92224c2862ef49c15f3d51e3e728c5e2","key":"ni13_1_2013101_20130518155518413","value":"ni13_2013101_VsPercentResult_10619936276742","doc":null},
> {"id":"b02d128d88188d78ef7f3478586c349b","key":"ni13_2_2013101_20130518155203924","value":"ni13_2013101_VsPercentResult_46202583943140","doc":{"_id":"b02d128d88188d78ef7f3478586c349b","_rev":"1-bd2a2bfb1f7461e6b3ec6d4d106e08e4","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130518155203924","priority":2,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_46202583943140","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-ErSTxuEaSHZrIJ276ANdOQ==","length":4533,"stub":true}}}},
> {"id":"b02d128d88188d78ef7f3478586c72a1","key":"ni13_2_2013101_20130518155204124","value":"ni13_2013101_VsPercentResult_91455901404013","doc":{"_id":"b02d128d88188d78ef7f3478586c72a1","_rev":"1-6f702cff1d12f992d745fc19be84b846","distribution":"global","type":"ESTicketCreateOriginalGraphic","createdTS":"20130518155204124","priority":2,"eDayID":"ni13","electionID":2013101,"layout":"ard2013","baseDocKey":"ni13_2013101_VsPercentResult_91455901404013","_attachments":{"bclitemsdata":{"content_type":"application/zip","revpos":1,"digest":"md5-L9UXpNNRUyk/LSlzAyEsXQ==","length":4533,"stub":true}}}}
> ]}
> Please notice, that the doc attribute of the third item in the rows attribute has the
value "null". That means, that the view entry has no belonging document ????????
> This seems to indicate an inconsistency within the database.
> I can not say, when this error happens, but I know, that it will happen in my test run.

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message