Weird stuff while indexing via SSH...

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • iAreku
    New Member
    • Jul 2017
    • 20
    • 4.2.x

    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 13 Jul '17, 12:59am.
  • Trevor Hannant
    vBulletin Support
    • Aug 2002
    • 24325
    • 5.7.X

    #2
    Any messages in your server's error logs for the time of these terminated results?
    Vote for:

    - Admin Settable Paid Subscription Reminder Timeframe (vB6)
    - Add Admin ability to auto-subscribe users to specific channel(s) (vB6)

    Comment

    • iAreku
      New Member
      • Jul 2017
      • 20
      • 4.2.x

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

      Comment

      • iAreku
        New Member
        • Jul 2017
        • 20
        • 4.2.x

        #4
        Any clue I could investigate?

        Comment

        • iAreku
          New Member
          • Jul 2017
          • 20
          • 4.2.x

          #5
          No?

          Comment

          • Wayne Luke
            vBulletin Technical Support Lead
            • Aug 2000
            • 73981

            #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 demonstration site.
            vBulletin 5 API

            Comment

            • iAreku
              New Member
              • Jul 2017
              • 20
              • 4.2.x

              #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

              • Wayne Luke
                vBulletin Technical Support Lead
                • Aug 2000
                • 73981

                #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 demonstration site.
                vBulletin 5 API

                Comment

                • iAreku
                  New Member
                  • Jul 2017
                  • 20
                  • 4.2.x

                  #9
                  How do I find out that part?

                  Comment

                  • Wayne Luke
                    vBulletin Technical Support Lead
                    • Aug 2000
                    • 73981

                    #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 demonstration site.
                    vBulletin 5 API

                    Comment

                    • iAreku
                      New Member
                      • Jul 2017
                      • 20
                      • 4.2.x

                      #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

                      • Wayne Luke
                        vBulletin Technical Support Lead
                        • Aug 2000
                        • 73981

                        #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 demonstration site.
                        vBulletin 5 API

                        Comment

                        • iAreku
                          New Member
                          • Jul 2017
                          • 20
                          • 4.2.x

                          #13
                          Primer foro hispano para vegetarianos de todo el mundo, respaldado por unionvegetariana.org

                          Comment

                          • iAreku
                            New Member
                            • Jul 2017
                            • 20
                            • 4.2.x

                            #14
                            Originally posted by Wayne Luke
                            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

                            • Wayne Luke
                              vBulletin Technical Support Lead
                              • Aug 2000
                              • 73981

                              #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 demonstration site.
                              vBulletin 5 API

                              Comment

                              widgetinstance 262 (Related Topics) skipped due to lack of content & hide_module_if_empty option.
                              Working...