Details
-
Bug
-
Resolution: Fixed
-
Critical
-
6.0.0
-
centos
-
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=="