https://pinot.apache.org/ logo
Join Slack
Powered by
# troubleshooting
  • y

    Yash Agarwal

    07/24/2020, 5:31 AM
    ill try making it more like the format you mentioned.
  • x

    Xiang Fu

    07/24/2020, 5:54 AM
    hmm so file name is
    00000_0
    ?
  • x

    Xiang Fu

    07/24/2020, 5:55 AM
    here is some sample layout:
  • x

    Xiang Fu

    07/24/2020, 5:57 AM
    https://github.com/apache/incubator-pinot/tree/master/pinot-tools/src/main/resources/examples/batch/airlineStats/rawdata/2014/01/01
  • y

    Yash Agarwal

    07/24/2020, 6:05 AM
    I am getting the same issue after converting it into this format.
  • y

    Yash Agarwal

    07/24/2020, 6:06 AM
    Copy code
    <hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl/2019/05/18/guest_sdr_gst_data_sgl_data_2019-05-18.avro>
  • y

    Yash Agarwal

    07/24/2020, 6:06 AM
    Copy code
    Unable to extract out the relative path based on base input path: <hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl>
  • y

    Yash Agarwal

    07/24/2020, 8:08 AM
    I was able to log the inputfile and output dir with it.
  • y

    Yash Agarwal

    07/24/2020, 8:08 AM
    Copy code
    java.lang.IllegalStateException: Unable to extract out the relative path based on base input path: <hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl> inputFile: hdfs:/user/Z00290G/guest_sdr_gst_data_sgl/2019/05/21/guest_sdr_gst_data_sgl_data_2019-05-21.avro outputDir: <hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl_staging>
  • y

    Yash Agarwal

    07/24/2020, 8:09 AM
    it is removing the
    <hdfs://bigredns>
    from the input file.
  • x

    Xiang Fu

    07/24/2020, 8:38 AM
    I wrote a simple test
    Copy code
    @Test
      public void testGetRelativePath() {
    
        System.out.println(SegmentGenerationUtils.getRelativeOutputPath(
            URI.create("<hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl>"),
            URI.create("<hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl/2019/05/18/guest_sdr_gst_data_sgl_data_2019-05-18.avro>"),
            URI.create("<hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl_staging>")));
      }
  • x

    Xiang Fu

    07/24/2020, 8:38 AM
    the relative output is
    <hdfs://bigredns/user/Z00290G/guest_sdr_gst_data_sgl_staging/2019/05/18/>
  • x

    Xiang Fu

    07/24/2020, 8:39 AM
    oh, I think the issue is that
    inputFile
    is not under
    base input path
  • x

    Xiang Fu

    07/24/2020, 8:40 AM
    I’m using
    URI relativePath = baseInputDir.relativize(inputFile);
    to get the relative path
  • x

    Xiang Fu

    07/24/2020, 8:40 AM
    which will be empty in this case
  • e

    Elon

    07/25/2020, 5:59 AM
    We upgraded to pinot-0.4.0 and one of the tables is not ingesting. The external view shows the bad segments and we see error messages like this:
    Copy code
    2020/07/23 22:02:12.981 ERROR [LLRealtimeSegmentDataManager_oas_integration_operation_event__2__1309__20200723T2158Z] [oas_integration_operation_event__2__1309__20200723T2158Z] Holding after response from Controller: {"buildTimeSec":-1,"isSplitCommitType":false,"status":"NOT_SENT","offset":-1}
  • e

    Elon

    07/25/2020, 5:59 AM
    and
    Copy code
    ERROR [ServerSegmentCompletionProtocolHandler] [oas_integration_operation_event__1__1309__20200723T2200Z] Could not send request <http://pinot-controller-1.pinot-controller-headless.pinot.svc.cluster.local:9000/segmentConsumed?name=oas_integration_operation_event__1__1309__20200723T2200Z&offset=238845637&instance=Server_pinot-server-0.pinot-server-headless.pinot.svc.cluster.local_8098&reason=rowLimit&rowCount=1731228>
    "
  • e

    Elon

    07/25/2020, 5:59 AM
    Now when I send the same request I get the following message:
  • e

    Elon

    07/25/2020, 6:00 AM
    Copy code
    {
      "status": "FAILED",
      "isSplitCommitType": false,
      "streamPartitionMsgOffset": null,
      "buildTimeSec": -1,
      "offset": -1
    }
  • e

    Elon

    07/25/2020, 6:00 AM
    Is there a way we can delete the realtime segments that show up in error state in the external view and get them to be reingested?
  • k

    Kishore G

    07/25/2020, 6:22 AM
    there is a validation manager that will fix stuck segments
  • x

    Xiang Fu

    07/25/2020, 6:23 AM
    segment deletion api should work for deleting the current consuming segment
  • x

    Xiang Fu

    07/25/2020, 6:24 AM
    Controller should fix this
  • e

    Elon

    07/25/2020, 6:32 AM
    Thanks! So I just delete those segments?
  • x

    Xiang Fu

    07/25/2020, 7:54 AM
    do you get any meaningful log from the controller-1?
  • x

    Xiang Fu

    07/25/2020, 7:54 AM
    Yes, you can just delete those
  • x

    Xiang Fu

    07/25/2020, 7:55 AM
    so all the consuming segments are stopped?
  • k

    Kishore G

    07/25/2020, 11:10 PM
    @Elon can probably help you on this.
    👍 1
  • e

    Elon

    07/27/2020, 7:47 PM
    Thanks for the help, now we're getting a "cannot build segment" for the realtime table, only ingested a few rows. Is there something with the spec that needs to be updated to be compatible with pinot-0.4.0?
  • e

    Elon

    07/27/2020, 7:47 PM
    Untitled
    Untitled
1...122123124...166Latest