Error code 5000 - solved

My fault, I've created the beer-sample with cbq-engine active.
It was enough stop and start the engine and now it works perfectly!

Hi,
I'm trying N1QL Developer Preview 1 over the 'beer-sample' bucket and that are the results:

cbq> SELECT * from beer-sample where type='brewery'
{
    "resultset": [
        {
            "address": [
                "563 Second Street"
            ],
            "city": "San Francisco",
            "code": "94107",
            "country": "United States",
            "description": "The 21st Amendment Brewery offers a variety of award winning house made brews and American grilled cuisine in a comfortable loft like setting. Join us before and after Giants baseball games in our outdoor beer garden. A great location for functions and parties in our semi-private Brewers Loft. See you soon at the 21A!",
            "geo": {
                "accuracy": "ROOFTOP",
                "lat": 37.7825,
                "lon": -122.393
            },
            "name": "21st Amendment Brewery Cafe",
            "phone": "1-415-369-0900",
            "state": "California",
            "type": "brewery",
            "updated": "2010-10-24 13:54:07",
            "website": "http://www.21st-amendment.com/"
        }
    ],
    "error":
        {
            "caller": "fetch:107",
            "code": 5000,
            "key": "Internal Error",
            "message": "missing value bulk response for key `21st_amendment_brewery_cafe-bitter_american`"
        }
}

second query

cbq> SELECT * from beer-sample where type='beer'
{
    "resultset": [
        {
            "abv": 7.2,
            "brewery_id": "21st_amendment_brewery_cafe",
            "category": "North American Ale",
            "description": "Deep golden color. Citrus and piney hop aromas. Assertive malt backbone supporting the overwhelming bitterness. Dry hopped in the fermenter with four types of hops giving an explosive hop aroma. Many refer to this IPA as Nectar of the Gods. Judge for yourself. Now Available in Cans!",
            "ibu": 0,
            "name": "21A IPA",
            "srm": 0,
            "style": "American-Style India Pale Ale",
            "type": "beer",
            "upc": 0,
            "updated": "2010-07-22 20:00:20"
        },
        {
            "abv": 5,
            "brewery_id": "21st_amendment_brewery_cafe",
            "category": "North American Ale",
            "description": "Deep black color, toasted black burnt coffee flavors and aroma. Dispensed with Nitrogen through a slow-flow faucet giving it the characteristic cascading effect, resulting in a rich dense creamy head.",
            "ibu": 0,
            "name": "563 Stout",
            "srm": 0,
            "style": "American-Style Stout",
            "type": "beer",
            "upc": 0,
            "updated": "2010-07-22 20:00:20"
        },
        {
            "abv": 5.2,
            "brewery_id": "21st_amendment_brewery_cafe",
            "category": "North American Ale",
            "description": "Rich golden hue color. Floral hop with sweet malt aroma. Medium mouth feel with malt sweetness, hop quenching flavor and well-balanced bitterness.",
            "ibu": 0,
            "name": "Amendment Pale Ale",
            "srm": 0,
            "style": "American-Style Pale Ale",
            "type": "beer",
            "upc": 0,
            "updated": "2010-07-22 20:00:20"
        }
    ],
    "error":
        {
            "caller": "fetch:107",
            "code": 5000,
            "key": "Internal Error",
            "message": "missing value bulk response for key `21st_amendment_brewery_cafe-bitter_american`"
        }
}

Anyway I've got the same error, caller, code, key and message, any clue?
Thanks in advance
Lorenzo

3 Answers

« Back to question.

This is a bug. The engine did see the bucket, but while scanning the bucket one of the keys returned from the SCAN operator could not be found by the FETCH operator. There is already a bug open related to this here: http://www.couchbase.com/issues/browse/MB-9134

« Back to question.

The ability to pick up changes to bucket definitions is one of the features in the pipeline. The released product will not require a restart to observe new bucket creations/deletions; that is a temporary limitation of the developer preview.

« Back to question.

Happy to see that you have solved your problem.