Uploaded image for project: 'Couchbase Server'
  1. Couchbase Server
  2. MB-36522

ERROR in N1QL Query

    XMLWordPrintable

Details

    • Untriaged
    • Unknown

    Description

      My Task is to test performance of Couchbase. 

      One of the test is that I insert about 1G documents in database and the length of each document is about 20KB. Each document contains 5 fileds, and I create 5 index. Then when I processed N1QL query, it always went wrong.

      At first the error message is :

      Invalid low key (here is my query key) (secondary key is too long(>4608))

      After I alter the value of max_seckey_size by process request:

      curl user:password@127.0.0.1:9102/settings -X POST -d '{"indexer.settings.max_seckey_size": 7000}'

      Then the error message becomes:

      Invalid low key (here is my query key) (collatejson.outputLen)

      Please tell me what to do..

      My N1QL query is like:

      SELECT * FROM `db` WHERE field0="RWZFUUJ3QUprc2p2aHVzUFBidmxNbWZLdXdLQmRKdnhoaXFNRldLaGJMTmJKUVRxb0tOekNwaUFiRHlIYVJoWlV0d2ppSm1XWlFrdkRBdk9LQ0RFaG9KUGxDSFhPdnRHQnZLTHBjT3lXVG5oZXljSXB1UGZvdXRMRW5wTHptd2trSFFaelJMblhLaXRqamJRUU1qdU5uRm5FSWV1WElrelRnTFZNa1lmT1lCeFlHeXNZeUNTUWhZb0RMbHh3Q0ZGYlZqZVNlZGxXakNHTVhGTE5rRkpDYm5MRFhYV2JuQ2lYT0xxdk1TZ2ZQcnNtb3dBWVZobG1vU2tNenhlT1NDU0dYdGplanFGYVlGVklkd1R1R1NySEpJRkVzWlVBdU1FWEd0VHFwQURvaURzRmFNZEtHY05IUm14RmlXcGhJZU9hb0tlSnNITEdXeHZQQkpMbHhEQUNUbE1BV094ZHVuV1hacEhkeUZYS1FJVUJOS2lSU09CRUFIRnNkTGJvWXBvcWphUlR0dkVNalpGRVJjU2pvZUNOR3NJRld5U01QanNFRWhlaVBTdFFWQnlFdUNYVmRtYW9Udnd1Sm9ma2pLWVdpeUNSa0RUUUFWWkZ3TFdNb0Zsb0Z4QWR5RXlsY09hVlFsbUl6TGhpdGdvd01jRnFNckxpS3hYbWJmRkRVZGZ1anNhVWxUVE9XSE93b2hNVnlpSHJzQUNjaUhOQXFPWVBodmdwZE5RQURRWVZhTGdRVVVPUGJrUHBsc2tSS0FJU1JBTUhRak9CRHJmS3pTWkxaSFpCQkhRdkJkQndHcFFSUFBIemRlWEdKcnhSdmpjWVZNRXdLTGF1V3NvRVhNdFNoZ3R5UmtrcWZIdlJLUWZCZWxlSUV2eEprc0J4bnR6bGl5T09aRFVhcnJEdGlEdlZpaXBzU0ZGV1pTUlR6YWV0Rk9DRkZzc3BJdHNmbVNhVm9QcFhNVmhKSE9XbEVqeGZlb2VjQ3VYTm1STkhQU0VwSE5CYlBwcXJPT0Z5amx5bkVqR3loUWx5T2JlbGJQYkVXYktpdWJaRUN1RnFFVUxrSENETFhmd0xnUHRLZmNkS1hRektDcnFweGNTbXlLa3hDTXFBakpTRUdERWFua3lnQkVNYWJieG9Ca2dZbnJieWVpbmlTaElyQ1lNaFNBbXdsSnhxSkpscGlndXVnWkpKVE9kVVdRWktBcHpvU0N3Q1Z4cU5tcFFWUHZxZVdhUnRtTHh3cVJiVmhpS2NJQmd5UEpESUJMZFFxUFdYR0hjWE5yT3BBc1J2Z1R1RkVrdHloSlZFT2xtWURsanJXY2pqVmdsSVVUSVRJbVVxUXd0TU1qYktYTUJUbEdnZnRKWmpabldyVGpIbFRuVUJESUlCQWdaYlRnTndNdmxvV2FMTWRidlVMUXRjYkNCY0RjaUJyU3RLTHlpeFNFQ1hiSEF3eUxiQndtem1YbmFFUUZDeU9RVkN6Sld3S21KYWV0Rmt5Q2J6d1VyV3hSaXVIQ1B6SExBaElXTHRacXpkVnRTdHRVWWNHQUxyZ2didUhPc2Zma2ZlR29Ja2NLSWpPZFhRY0llZ3lEdFduVUlReXlNUkNsbllHSW1mWmxFcVV6dFdvWmlHcHlVcEtxaVVKSWhZS3JPYmFBb3BwdmFUc1ljY2dkSnBQWmRzRlpkVWhjZ1B2YU9QZVVDdU9qbEtscGtCTUFYRFFScFROUFpvSVBoaFVvaXF5YUhIRkxodWRrYm9TRW5GdU9ZWHNIQnlnV3hhQnNBaHNUemJzQXFnbERpbVF2eHhISWxXcEdPVXNHV2hqYU1SUW9Fb2FEb2pzUlNoSFdvRXRMSkt4T2FMUElBZU9MbXdCd2JVVEZpTlFzb3dETlpabUhJUmlVRGdIQmVQTXZGZHR5c2p0QVVBZVJteHR2bnBOYVRScUhueXVQa3l2UGxmSnl0VWd0dlZoQVh0Q1F1SEhRYVBlTHN4dGd4aGhMcFJTQXFjdmVLUVVVVERvcE5udWFOT2dxbFNZcUFBQXdzV2dHd1NwV0ZCVkJZc0JTWWVISVBsZXltVW1zT0NNcEtiUVRraGtLcEd4bk1VYmtFSkpSWHFCQ1NuRXhKTHpxamJzaU1CakNZeGRSSXNnTUN2RGFvaVFuUWdEZ1JVdnVJdk1LZVpEdkxLZ3JQVlhmVGlDeXpaQlZIU1NhdFZQSFlLS0pLd2dKRlduZHVmZmpHWG54eWR3dkhucll3RnB6eEt4dmZBWW5TRXFoWENBTldEU1RMcFl0Zm5mSFJDUFFZTUFtd2ZkWmtVdEJha0NZUkhDYnVRTFJwZFpXQmdmRlhGRHNrQkhmcVFzbHpSYmdxeVVEUnhqeGFzRk9DWk51VldCY01RYlB6Q1dWaERLZ0R0YnplSnBYTWVhalZCZ09zaHBVTnF3SVBndWhSRkJVeVpjTEtVeXNFQlFGbFlPck5oanpoUG5kWWtPamNQcWpGQUR3QVRCT3dJQWpqRlZ4ZUhwZ1hkVGN6Y1lPa0R2Vlh6T2JmUnJEbVZ6bmJsTWZZcmpMSEhLbFJMY3dwTmJkbVV5bEdjZWpKbnZLR1daaVRZc3BhUURvQnZ0QU5uRE5YZVZsVVdKTUpNbE9SZ2VQZ29Sd0pvdm5meWZBcXp6RnZVYWt5VXdHbkNDVEZPV09YVUdEV252dmdIWW9WZlRHRWtuT2tVd2tPWHJ3Q2xPSE1LV09wTVlHekdMUk9WWENsbFdYVUZaUW53c0lXZVVXT21SdXRsRUt2d2d6Q3hyZHZhWXFsdURySUxQUm9aVFJvcWN0T2dBaWphdm1pY25kRmloWG5vZnpXV2RRSmVPbEhNZ0JRcnNnU1VrYWVLWnZlTFJIVGNCZ1hNWHBxV3VJV3FVWUxwQkdMbGpOSmN3U1BqamhjTExEellLTEpyZWxIaGNNTXJFRUhNSGRGcGxDRHdCSHhSR1d2ZWVrV2lqbUtsclpseFRXWVBlRG1PT1lYSXBUWGxMRmZBemF2SWdacUlmS2poRGJlQUd6Wm5BZW9OcmVpVWtGSnlpdVVNRVRUY2hVUmlKUVBlSFFBRkJua0Zna0dQSUdVZ1FEdURNeFJNeFZGQWhrS0hYdFR6ZG5nVG9PbGZjd091VUhGSGRRSUJzS3RUYlVoYVdvbHFIa1JLd3ZRekVkY09yem14d0tDSmt2cG9GRmN2dWtXdWtzRUpsbGtncEdOdWRIQk1ickR1aGdZcW5UUFRUT1VTUnVJWmJGdWprSUpDUlhvYXVrWkFKcXlxT0pxbmhNZENCbU1NRGZpb2dEUEp4UmtjTnBMdmVibXJ2Z0J1dW9wVWVKbnpPd1JDREhTYWRJcllVTnBKdVdBSVlEcWhXcU94blZVcVRvTVBxbVJ6Tm1YQXZWZEdjc3hvak1DY1lWa3hiZEFPb2JRQXh0RENTelhGdUhDY0RQYWJjT0dCSGhjdmpLVVJ5V1BiZ3VNUGNmSnJRYWlNd01FamRqZW9KUE1iUUlDeHBmRVFkclJhd2JjYVh1Vk95bktxSUZKT2lmdkxhSVZhaUhicGZ2RFhkVFJRU0JoWGRoWXJSbWNUVEdmU1BacmRtdEJDSVZFZ21KcE9tSG1tc3NNVlV0SkhyWlpkRkJVSXlXZ0VRbml1ZVJ0U05pWXVudHhCV1l4QkpkQ2phUkRDRllGT2FVdWFKTGxLQ2JaSlpBTVZMb1RETnBLTnRKV2FzeEltT3lDRHZpSFNrVWN6RmlHU3VYQXplVWVpY0JVZ1BBTGRrRnNHUFZldWxMb1NxYmJsd3dLaklmUG5EVVN0VkJDTUhoUUhDY3JMWGJVWmRIRlZGbHdVUWJ0THZlT2NzRkhPcXBqbWxmQ1RWSm1LVWhvb2l2d2JRekdFbktDYkFHY3N5Q01BVWVsaWpSWHRXTmhLY3NjQlN6c1VHQXVYTFJQQ05oSHpkelFpSmFBbU5HT2ZZclZkdnlhelllVUpJS3RTWXlLYmhEeHdPaE1mR3BOTU11SWZoYU9ETVVTTWlhQU1pbXRjamxRZkJmbEtsRFJTSHNOUFBnZ0VIa0NEcHVsV2Z1dEtBRHBIQVVrRlRRcFl4R25tUnpMS0d5amhFT1lvdkxqQXFwWFJhcXpZaGN1aExuQk5WZlBLZGJNRm9KZ0ZUUXdPUlpHbUN2RG5TWU1CU3pSTlhxY0ZHUlRxbnNaVmh4bkxKT0NPSGFuUnZQdlJCVHNpaXZERFd3YUJvS2pvakxBUmNxZkROcnBmc0JrZklmR1ZqWEF1dUZsd1JNclFlT0pIakJRaXhPbXRKcGFUb1JYU3BRZEd0T2Fzc1RZdXhzc1RlYWF6VXZ1VVdzRGNaa252SURSWkhLaVZNakZ2aXFyb1lZdGlIVFJWVUlzVEJOSVBscEZGZXZpeUZvSWJOT3pDekhVc09VWnd4RFNmU09jS2xjSFZpV2ZsZUN2SGxpYlVGa1R6VEVUd0JjcFZQdm52RXVhQUpEdWV6TnNXYkhvTWJJcnJvRkxNZmJnUlVOdU1kZXBDeXpZeW1BTUJCV2NueGhLbnpscXp5d2xWdmtXVUdPWGhTQmhkVGd1R1l3Y0pGT1FyUk5RcWZxeWhMVVZpeVNEa3lHS01qeG90UHpNaVlCa3hYb0ZvR3dIemJkbEFKQ1BPUE50aEFUZXFpeEdqQXRKWVJGeVViakpocnZ0anNMRlBNWVpWQlluY2dvS0pBVW5Ec0VGZmt3VEhOTXRqcHF2QkpidGZObGxmRGluTFFiYVJpaEl5R1Z0SHRrUnhDYmd2WklESEpSWXNnZXJMUWthd2R4YkxkU1JoY3duS3hWcUd0blREWkRxYUpLYXhHdXpDRnhRR2txRmFRcVpGU2luWWVRamFKcnptT1Bad1NzTHJ3bEh1cENha2hQaVVvalNyTGxzeG94S0dIRUtPTGdGelpyY3BIUFBJd2Jrek9XendzRXRlQ2x4c0FLa3BpZkhnaUV2ZUtXQUlUSE9tYWFndFFSRnZHaFVxeVFPVm9OVHhQY2dPWFdLaU1jaHFFZHppWFNKcGdreFR1U093elpwVmdiZXN4TUdXaE1qVUdDUUhpREN3dGVtWVlZdERuSWJTU1d1ZHZwZXp6QURlZVVqdEZpekNyRnFzWk1HVnhEZERSdERiQ252WER0QUNvSGtIZ05zcVZJbkJaV21sSXNlWWNOTHBtVFpSTnN6bE1OQ2d6cXhZVlRzVXFxdmFucGREVGRQamdkWXJEc2NsYkFQd25CWW5XbWptc0xscUhpSW95aGt3emd0QUVVQlJqTUdSRnV2ZEVDb3RwTE9OaGZQTmJkU3lISWRUSHdaUHV4amZoZ2NJZ1laY0Z5d211blFpRUpyZHRSZHFkdm52bE53TEJYSUN4VURrRU9MTmVYV1NWTktPRkVVaXBxYW5vZGtwQnNxUHJMZlhYVXdLWHRCT1dxdUx2Q0RRYkx6Rklkdw=="

      Attachments

        For Gerrit Dashboard: MB-36522
        # Subject Branch Project Status CR V

        Activity

          People

            ajay.bhullar Ajay Bhullar
            zbc8696788 Bytrain
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Time Tracking

                Estimated:
                Original Estimate - 8h
                8h
                Remaining:
                Remaining Estimate - 8h
                8h
                Logged:
                Time Spent - Not Specified
                Not Specified

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty