Announcement

Collapse
No announcement yet.

Weird stuff while indexing via SSH...

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Weird stuff while indexing via SSH...

    Whats the explanation to this? Happened while rebuilding indexes on a large forum...


    ---------8<---------------------8<---------------------8<---------------------8<---------------------8<---------------------8<---------------------8<------------

    [...]

    IDs 800000-810000 ... Terminado (503.94 sec)

    IDs 810000-820000 ... Terminado (310.39 sec)

    IDs 820000-830000 ... Terminado (280.52 sec)

    IDs 830000-840000 ... Terminado (303.49 sec)

    IDs 840000-850000 ... Terminado (307.68 sec)

    IDs 850000-860000 ... Terminado (320.97 sec)

    IDs 860000-870000 ... Terminado (316.26 sec)

    IDs 870000-880000 ... Terminado (302.85 sec)

    IDs 880000-890000 ... Terminado (305.83 sec)

    IDs 890000-900000 ... Terminado (305.44 sec)

    IDs 900000-910000 ... Terminado (318.59 sec)

    IDs 910000-920000 ... Terminado (317.74 sec)

    IDs 920000-930000 ... Terminado (331.74 sec)

    IDs 930000-940000 ... Terminado (14.02 sec)

    IDs 940000-950000 ... Terminado (0.00 sec)

    IDs 950000-960000 ... Terminado (0.00 sec)

    IDs 960000-970000 ... Terminado (0.00 sec)

    IDs 970000-980000 ... Terminado (0.00 sec)

    IDs 980000-990000 ... Terminado (0.00 sec)

    IDs 990000-1000000 ... Terminado (0.00 sec)

    [...]


    IDs 21380000-21390000 ... Terminado (0.00 sec)

    IDs 21390000-21400000 ... Terminado (0.00 sec)

    IDs 21400000-21410000 ... Terminado (0.00 sec)

    IDs 21410000-21420000 ... Terminado (0.00 sec)

    IDs 21420000-21430000 ... Terminado (0.00 sec)

    IDs 21430000-21440000 ... Terminado (48.21 sec)

    IDs 21440000-21450000 ... Terminado (328.03 sec)

    IDs 21450000-21460000 ... Terminado (319.21 sec)

    IDs 21460000-21470000 ... Terminado (318.87 sec)

    IDs 21470000-21480000 ... Terminado (312.13 sec)

    IDs 21480000-21490000 ... Terminado (319.20 sec)

    IDs 21490000-21500000 ... Terminado (314.33 sec)

    IDs 21500000-21510000 ... Terminado (324.11 sec)

    IDs 21510000-21520000 ... Terminado (312.58 sec)

    IDs 21520000-21520997 ... Terminado (32.49 sec)

    Construyendo ?ndice de b?squedas Mensajes: Terminado

    Construyendo ?ndice de b?squedas Grupos ...

    IDs 0-179 ... Terminado (3.99 sec)

    Construyendo ?ndice de b?squedas Grupos: Terminado

    Construyendo ?ndice de b?squedas Mensajes de grupo ...

    IDs 0-9155 ... Terminado (260.06 sec)

    Construyendo ?ndice de b?squedas Mensajes de grupo: Terminado

    Construyendo ?ndice de b?squedas Mensajes de visita ...

    IDs 0-10000 ... Terminado (274.21 sec)

    IDs 10000-20000 ... Terminado (260.28 sec)

    IDs 20000-24366 ... Terminado (110.38 sec)

    Construyendo ?ndice de b?squedas Mensajes de visita: Terminado

    Construyendo ?ndice de b?squedas: 8 hours, 12 minutes and 27 seconds

    #
    ---------8<---------------------8<---------------------8<---------------------8<---------------------8<---------------------8<---------------------8<------------
    Last edited by iAreku; Thu 13th Jul '17, 12:59am.

  • #3
    Nothing reported aside from "FIle does not exist" errors...

    Comment


    • #4
      Any clue I could investigate?

      Comment


      • #5
        No?

        Comment


        • #6
          Does your search work properly?

          In this case, all Terminado means is "Completed" it is listing how long it takes to run each batch.
          Translations provided by Google.

          Wayne Luke
          The Rabid Badger - a vBulletin Cloud site. vBulletin 5 API - Full / Mobile
          Please do not PM me for support unless I specifically ask for information to be delivered that way.

          Comment


          • #7
            No, it does not, its missing posts from specific years range, and I guess its missing the same period the searchindex,php reports as 0,0

            Comment


            • #8
              Do nodes in those ranges exist in the database? The 0.0 could just mean that is empty batches of nodes. Nodes aren't guaranteed to be sequential. All depends on what you add and delete. We don't reuse nodeid values.

              Is the search returning 500 values?
              Translations provided by Google.

              Wayne Luke
              The Rabid Badger - a vBulletin Cloud site. vBulletin 5 API - Full / Mobile
              Please do not PM me for support unless I specifically ask for information to be delivered that way.

              Comment


              • #9
                How do I find out that part?

                Comment


                • #10
                  You can see how many searches are returned by running a search or looking under Settings -> Options -> Message Searching Options.

                  To see if there are blocks of nodes that aren't being used, you would have to run queries against the database's post table .
                  Translations provided by Google.

                  Wayne Luke
                  The Rabid Badger - a vBulletin Cloud site. vBulletin 5 API - Full / Mobile
                  Please do not PM me for support unless I specifically ask for information to be delivered that way.

                  Comment

                  Working...
                  X