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, 1: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 customization and demonstration site.
          vBulletin 5 Documentation - Updated every Friday. Report issues here.
          vBulletin 5 API - Full / Mobile
          Vote for your most annoying bugs.
          I am not currently available for vB Messenger Chats.

          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 customization and demonstration site.
              vBulletin 5 Documentation - Updated every Friday. Report issues here.
              vBulletin 5 API - Full / Mobile
              Vote for your most annoying bugs.
              I am not currently available for vB Messenger Chats.

              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 customization and demonstration site.
                  vBulletin 5 Documentation - Updated every Friday. Report issues here.
                  vBulletin 5 API - Full / Mobile
                  Vote for your most annoying bugs.
                  I am not currently available for vB Messenger Chats.

                  Comment


                  • #11
                    OK I tried to search for the thread title keywords (2 long keywords) used in a thread created YESTERDAY.

                    I tried both with and without " "

                    The thread created yesterday is NOT among the (ONLY) 352 results the db reports, and I can notice the year of the threads in the search results is rarely above 2013.... So like 4 years of missing results :????

                    Comment


                    • #12
                      When a thread is created, it should be automatically indexed. If it was not, then it is a separate problem from the indexing script.

                      What is the URL to your site?
                      Translations provided by Google.

                      Wayne Luke
                      The Rabid Badger - a vBulletin Cloud customization and demonstration site.
                      vBulletin 5 Documentation - Updated every Friday. Report issues here.
                      vBulletin 5 API - Full / Mobile
                      Vote for your most annoying bugs.
                      I am not currently available for vB Messenger Chats.

                      Comment


                      • #13
                        www.forovegetariano.org

                        Comment


                        • #14
                          Originally posted by Wayne Luke View Post
                          When a thread is created, it should be automatically indexed. If it was not, then it is a separate problem from the indexing script.

                          What is the URL to your site?
                          But I did run the "reindexing" script from SSH, right?

                          Comment


                          • #15
                            Yes... According to the output above. Should only have to reindex if you drop the contents of the search tables for some reason.
                            Translations provided by Google.

                            Wayne Luke
                            The Rabid Badger - a vBulletin Cloud customization and demonstration site.
                            vBulletin 5 Documentation - Updated every Friday. Report issues here.
                            vBulletin 5 API - Full / Mobile
                            Vote for your most annoying bugs.
                            I am not currently available for vB Messenger Chats.

                            Comment

                            Working...
                            X