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

Internal Server error observed while calling insert and upsert query on analytics standalone collection

    XMLWordPrintable

Details

    • Bug
    • Resolution: Fixed
    • Critical
    • Morpheus
    • Morpheus
    • analytics
    • OS: MacOS
      Couchbase server: 8.0.0-1364

    Description

      Internal Server error observed while calling insert and upsert query on analytics standalone collection

      Steps to reproduce: (Run following queries on analytics):

      CREATE COLLECTION my_shadow_dataset ON my_bucket;
      CREATE COLLECTION my_standalone_dataset PRIMARY KEY (my_pk: string);

      UPSERT INTO my_standalone_dataset
      SELECT v FROM my_shadow_dataset AS v;

      2023-08-07T10:14:21.898+05:30 INFO CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-12] handleRequest: <ud>{"host":"127.0.0.1:8091","path":"/query/service","statement":"UPSERT INTO couchbase\\nSelect v from umang as v;","pretty":false,"mode":"immediate","clientContextID":"53f480d5-8955-4f8d-844c-523a1a5a1fba","clientType":"ASTERIX","dataverse":null,"format":"CLEAN_JSON","timeout":9223372036854775807,"maxResultReads":1,"planFormat":"JSON","expressionTree":false,"rewrittenExpressionTree":false,"logicalPlan":false,"optimizedLogicalPlan":true,"job":false,"profile":"counts","signature":true,"multiStatement":true,"parseOnly":false,"readOnly":false,"maxWarnings":10,"sqlCompat":false,"scanConsistency":"not_bounded","scanWait":null}</ud>
      2023-08-07T10:14:21.899+05:30 INFO CBAS.messaging.CCMessageBroker [Executor-54:ClusterController] Received message: ExecuteStatementRequestMessage(id=225, from=d22851fcceabf207eb51a51381d6f762, uuid=2b99101b-2064-4423-8fc4-8e51aa693738): <ud>UPSERT INTO couchbase\nSelect v from umang as v;</ud>
      2023-08-07T10:14:21.912+05:30 INFO CBAS.context.PrimaryIndexOperationTracker [SA:JID:0.29:TAID:TID:ANID:ODID:1:0:0:0:0] Primary index on dataset 116 and partition 0 is empty... skipping delete
      2023-08-07T10:14:21.912+05:30 INFO CBAS.context.PrimaryIndexOperationTracker [SA:JID:0.29:TAID:TID:ANID:ODID:1:0:1:0:0] Primary index on dataset 116 and partition 1 is empty... skipping delete
      2023-08-07T10:14:21.914+05:30 WARN CBAS.collectors.NonDeterministicChannelReader [SA:JID:0.29:TAID:TID:ANID:ODID:1:0:0:0:0] Sender failed.. returning silently
      2023-08-07T10:14:21.914+05:30 WARN CBAS.collectors.NonDeterministicChannelReader [SA:JID:0.29:TAID:TID:ANID:ODID:1:0:1:0:0] Sender failed.. returning silently
      2023-08-07T10:14:21.914+05:30 WARN CBAS.context.PrimaryIndexOperationTracker [SA:JID:0.29:TAID:TID:ANID:ODID:1:0:0:0:0] flushing an index with LSN 0. Flush log record:  Source : LOCAL LSN : 0 LogType : UPDATE LogSize : 0 TxnId : 0 DatasetId : 0 ResourcePartition : 0 PKHashValue : 0 PKFieldCnt : 0 PKSize: 0 ResourceId : 0 Version : 1
      2023-08-07T10:14:21.914+05:30 WARN CBAS.context.PrimaryIndexOperationTracker [SA:JID:0.29:TAID:TID:ANID:ODID:1:0:1:0:0] flushing an index with LSN 0. Flush log record:  Source : LOCAL LSN : 0 LogType : UPDATE LogSize : 0 TxnId : 0 DatasetId : 0 ResourcePartition : 0 PKHashValue : 0 PKFieldCnt : 0 PKSize: 0 ResourceId : 0 Version : 1
      2023-08-07T10:14:21.914+05:30 WARN CBAS.nc.Task [SA:JID:0.29:TAID:TID:ANID:ODID:4:0:1:0:0] Task failed with exception
      org.apache.hyracks.api.exceptions.HyracksDataException: HYR0002: Error in processing tuple 0 in a frame (in line 2, at column 1)
      	at org.apache.hyracks.api.exceptions.HyracksDataException.create(HyracksDataException.java:62) ~[hyracks-api-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.std.AssignRuntimeFactory$1.produceTuple(AssignRuntimeFactory.java:169) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.std.AssignRuntimeFactory$1.nextFrame(AssignRuntimeFactory.java:131) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.dataflow.common.comm.io.AbstractFrameAppender.write(AbstractFrameAppender.java:94) ~[hyracks-dataflow-common-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.flushAndReset(AbstractOneInputOneOutputOneFramePushRuntime.java:73) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.base.AbstractOneInputOneOutputOneFramePushRuntime.appendProjectionToFrame(AbstractOneInputOneOutputOneFramePushRuntime.java:106) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.std.StreamProjectRuntimeFactory$1.nextFrame(StreamProjectRuntimeFactory.java:80) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$1.nextFrame(AlgebricksMetaOperatorDescriptor.java:155) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.dataflow.common.comm.io.AbstractFrameAppender.write(AbstractFrameAppender.java:94) ~[hyracks-dataflow-common-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.dataflow.common.comm.util.FrameUtils.appendToWriter(FrameUtils.java:185) ~[hyracks-dataflow-common-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.writeSearchResults(IndexSearchOperatorNodePushable.java:290) ~[hyracks-storage-am-common-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.searchAllPartitions(IndexSearchOperatorNodePushable.java:460) ~[hyracks-storage-am-common-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.storage.am.common.dataflow.IndexSearchOperatorNodePushable.nextFrame(IndexSearchOperatorNodePushable.java:313) ~[hyracks-storage-am-common-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.dataflow.common.comm.io.AbstractFrameAppender.write(AbstractFrameAppender.java:94) ~[hyracks-dataflow-common-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.std.EmptyTupleSourceRuntimeFactory$1.open(EmptyTupleSourceRuntimeFactory.java:55) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.meta.AlgebricksMetaOperatorDescriptor$SourcePushRuntime.initialize(AlgebricksMetaOperatorDescriptor.java:105) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.api.rewriter.runtime.SuperActivityOperatorNodePushable.lambda$runInParallel$0(SuperActivityOperatorNodePushable.java:236) ~[hyracks-api-8.0.0-1364.jar:8.0.0-1364]
      	at java.util.concurrent.FutureTask.run(FutureTask.java:264) ~[?:?]
      	at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1136) ~[?:?]
      	at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:635) ~[?:?]
      	at java.lang.Thread.run(Thread.java:833) ~[?:?]
      Caused by: org.apache.hyracks.api.exceptions.HyracksDataException: type mismatch: missing a required closed field name: string
      	at org.apache.asterix.om.pointables.cast.ARecordCaster.matchClosedPart(ARecordCaster.java:274) ~[asterix-om-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.asterix.om.pointables.cast.ARecordCaster.castRecord(ARecordCaster.java:126) ~[asterix-om-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.asterix.om.pointables.cast.ACastVisitor.visit(ACastVisitor.java:128) ~[asterix-om-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.asterix.om.pointables.cast.ACastVisitor.visit(ACastVisitor.java:56) ~[asterix-om-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.asterix.om.pointables.ARecordVisitablePointable.accept(ARecordVisitablePointable.java:294) ~[asterix-om-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.asterix.runtime.evaluators.functions.CastTypeEvaluator.cast(CastTypeEvaluator.java:94) ~[asterix-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.asterix.runtime.evaluators.functions.CastTypeEvaluator.evaluate(CastTypeEvaluator.java:90) ~[asterix-runtime-8.0.0-1364.jar:8.0.0-1364]
      	at org.apache.hyracks.algebricks.runtime.operators.std.AssignRuntimeFactory$1.produceTuple(AssignRuntimeFactory.java:162) ~[algebricks-runtime-8.0.0-1364.jar:8.0.0-1364]
      	... 19 more
      
      

      Attachments

        Issue Links

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

          Activity

            People

              peeyush.gupta Peeyush Gupta
              abhay.aggrawal Abhay Aggrawal
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Gerrit Reviews

                  There are no open Gerrit changes

                  PagerDuty