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

500 internal server error for unsupported field type for standalone collection create statement

    XMLWordPrintable

Details

    • Untriaged
    • Linux x86_64
    • 0
    • Unknown
    • Analytics Sprint 24

    Description

      CBAS query:

      create collection ABC PRIMARY KEY(id: jkdhfkjsdhfdksjf)
      

      Error received:

      [
        {
          "code": 25000,
          "msg": "Internal error",
          "query_from_user": "create collection ABC PRIMARY KEY(id: jkdhfkjsdhfdksjf)"
        }
      ]
      

      analytics_info.log:

      2023-08-24T14:24:38.482+00:00 INFO CBAS.server.QueryServiceServlet [HttpExecutor(port:8095)-8] handleRequest: <ud>{"host":"10.123.230.101:18091","path":"/query/service","statement":"create collection ABC PRIMARY KEY(id: jkdhfkjsdhfdksjf)","pretty":false,"mode":"immediate","clientContextID":"9c4d0ee9-15a8-4476-a264-37cef099c240","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-24T14:24:38.485+00:00 INFO CBAS.messaging.CCMessageBroker [Executor-11:ClusterController] Received message: ExecuteStatementRequestMessage(id=19, from=45faa23f1f2edb3ba85cd86cf7f3f821, uuid=9092da0f-6680-4828-9e22-293aa6fb4a62): <ud>create collection ABC PRIMARY KEY(id: jkdhfkjsdhfdksjf);</ud>
      2023-08-24T14:24:38.547+00:00 INFO CBAS.nc.RecoveryManager [QueryTranslator:9092da0f-6680-4828-9e22-293aa6fb4a62] rolling back transaction log records from 536870912 to 536871111 for TxnId:8
      2023-08-24T14:24:38.553+00:00 INFO CBAS.nc.RecoveryManager [QueryTranslator:9092da0f-6680-4828-9e22-293aa6fb4a62] undoing loser transaction's effect
      2023-08-24T14:24:38.555+00:00 INFO CBAS.nc.RecoveryManager [QueryTranslator:9092da0f-6680-4828-9e22-293aa6fb4a62] undone loser transaction's effect
      2023-08-24T14:24:38.558+00:00 INFO CBAS.nc.RecoveryManager [QueryTranslator:9092da0f-6680-4828-9e22-293aa6fb4a62] [RecoveryManager's rollback log count] update/entityCommit/undo:1/0/1
      2023-08-24T14:24:38.559+00:00 ERRO CBAS.apache.asterix [Executor-11:ClusterController] Unexpected exception
      java.lang.NullPointerException: Cannot invoke "org.apache.asterix.om.types.IAType.getTypeTag()" because "fieldType" is null
      	at org.apache.asterix.translator.util.ValidateUtil.validatePartitioningExpressionsImpl(ValidateUtil.java:193) ~[asterix-algebra-8.0.0-1384.jar:8.0.0-1384]
      	at org.apache.asterix.translator.util.ValidateUtil.validatePartitioningExpressions(ValidateUtil.java:127) ~[asterix-algebra-8.0.0-1384.jar:8.0.0-1384]
      	at org.apache.asterix.app.translator.QueryTranslator.doCreateDatasetStatement(QueryTranslator.java:844) ~[asterix-app-8.0.0-1384.jar:8.0.0-1384]
      	at com.couchbase.analytics.lang.CBStatementExecutor.doCreateDatasetStatement(CBStatementExecutor.java:651) ~[cbas-connector-8.0.0-1384.jar:8.0.0-1384]
      	at org.apache.asterix.app.translator.QueryTranslator.handleCreateDatasetStatement(QueryTranslator.java:738) ~[asterix-app-8.0.0-1384.jar:8.0.0-1384]
      	at com.couchbase.analytics.lang.CBStatementExecutor.handleCreateDatasetStatement(CBStatementExecutor.java:513) ~[cbas-connector-8.0.0-1384.jar:8.0.0-1384]
      	at org.apache.asterix.app.translator.QueryTranslator.compileAndExecute(QueryTranslator.java:375) ~[asterix-app-8.0.0-1384.jar:8.0.0-1384]
      	at org.apache.asterix.app.message.ExecuteStatementRequestMessage.handle(ExecuteStatementRequestMessage.java:180) ~[asterix-app-8.0.0-1384.jar:8.0.0-1384]
      	at org.apache.asterix.messaging.CCMessageBroker.receivedMessage(CCMessageBroker.java:64) ~[asterix-app-8.0.0-1384.jar:8.0.0-1384]
      	at org.apache.hyracks.control.cc.work.ApplicationMessageWork.lambda$notifyMessageBroker$0(ApplicationMessageWork.java:68) ~[hyracks-control-cc-8.0.0-1384.jar:8.0.0-1384]
      	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) ~[?:?]
      

      Attachments

        No reviews matched the request. Check your Options in the drop-down menu of this sections header.

        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