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

Indexer has 0 indexed item and have all the docs in pending state

    XMLWordPrintable

Details

    • Bug
    • Resolution: Unresolved
    • Critical
    • 7.6.4
    • 7.6.2
    • secondary-index
    • 7.6.2-3730
    • Untriaged
    • 0
    • No

    Description

      I'm running a test where I keep on creating, deleting and updating (500K:400K:100K)  doc in a continuous loop and have indexer kill in a loop on all the index nodes available in an interval of 30 secs and then wait for 10 min for next cycle of kill.

      Realised that select query was failing and then checked the UI and saw no. of docs indexed are zero.

       

      hrajput@K61PJW2045 DocLoader % curl --location 'http://172.23.219.92:9102/stats' \        
      --header 'Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==' | jq | grep pending    
        % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                       Dload  Upload   Total   Spent    Left  Speed
      100  7383    0  7383    0     0  13883      0 --:--:-- --:--:-- --:--:-- 13877
        "default:idx:num_docs_pending": 19696221,
      hrajput@K61PJW2045 DocLoader % curl --location 'http://172.23.219.93:9102/stats' \
      --header 'Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==' | jq | grep pending
        % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                       Dload  Upload   Total   Spent    Left  Speed
      100 15503    0 15503    0     0  17932      0 --:--:-- --:--:-- --:--:-- 17922
        "default:_system:_query:#primary (replica 1):num_docs_pending": 12759682,
        "default:idx:num_docs_pending": 12759682,
      hrajput@K61PJW2045 DocLoader % curl --location 'http://172.23.219.94:9102/stats' \
      --header 'Authorization: Basic QWRtaW5pc3RyYXRvcjpwYXNzd29yZA==' | jq | grep pending
        % Total    % Received % Xferd  Average Speed   Time    Time     Time  Current
                                       Dload  Upload   Total   Spent    Left  Speed
      100 14277    0 14277    0     0  15882      0 --:--:-- --:--:-- --:--:-- 15880
        "default:_system:_query:#primary:num_docs_pending": 16403659,
        "default:idx:num_docs_pending": 16403659,
      hrajput@K61PJW2045 DocLoader %  

      https://cb-engineering.s3.amazonaws.com/MB-63358/collectinfo-2024-08-30T071121-ns_1%40172.23.219.90.zip
      https://cb-engineering.s3.amazonaws.com/MB-63358/collectinfo-2024-08-30T071121-ns_1%40172.23.219.91.zip
      https://cb-engineering.s3.amazonaws.com/MB-63358/collectinfo-2024-08-30T071121-ns_1%40172.23.219.92.zip
      https://cb-engineering.s3.amazonaws.com/MB-63358/collectinfo-2024-08-30T071121-ns_1%40172.23.219.93.zip
      https://cb-engineering.s3.amazonaws.com/MB-63358/collectinfo-2024-08-30T071121-ns_1%40172.23.219.94.zip

      Attachments

        Activity

          People

            dhananjay.kshirsagar Dhananjay Kshirsagar
            hemant.rajput Hemant Rajput
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:

              PagerDuty