• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login

Common WebUI pages takes minutes to load.

Scheduled Pinned Locked Moved Solved
FOG Problems
4
12
513
Loading More Posts
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • E
    EduardoTSeoane
    last edited by Nov 20, 2019, 1:51 PM

    @Sebastian-Roth @Tom-Elliott

    First excuse me to link this post to you, but I think that is important, and for me VERY Important

    I have an enviroment with 16500 computers, and 60 Storage Nodes growing, with location plugin. FOG 1.5.6
    And I have this statistics:
    hosts table: 16.500 records
    hostMAC: 2800
    Tabla snapins: 210
    Tabla snapinAssoc: 45.403
    Tabla snapinGroupAssoc: 15390

    This is verified on FOG Version 1.5.6 and FOG Version 1.5.7

    The problem:
    The following list of pages loads two slow, a few minutes:

    host management -> Host general
    host management -> Basic Task -> Deploy
    host management -> Basic Task -> Snapins
    Group management -> Snapins
    Group management -> Basic Task -> Deploy
    Group management -> Basic Task -> Snapins
    Snapin management -> List All Snapins
    ... at least
    

    First i think that was a database stress workload problem.
    Second Speaking with @Fernando-Gietz we think that was a filter problem.
    But as I was unable to create a filter that works.
    Then reading the code a bit more i found that the problem is on the line 1297 on fog/lib/router/route.class.php
    " ‘storagegroupname’ => $class->getStorageGroup()->get(‘name’)"

    if you change the lines
    $class->get(),
    array(
    ‘storagegroupname’ => $class->getStorageGroup()->get(‘name’)
    )
    by
    $class->get()

    The pages goes much more faster.

    I have commented that line and seems that all works correctly with our operations. But maybe is better than someone that knows what are doing take a look about that and can find a “Correct Solution”.

    Free to request more explanations.

    1 Reply Last reply Reply Quote 0
    • T
      Tom Elliott
      last edited by Nov 20, 2019, 2:26 PM

      Would you mind trying on working-1.6? (Preferabbly the same database but on a test instance?) to see if performance is improved at all?

      Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

      Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

      Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

      E 1 Reply Last reply Nov 27, 2019, 8:32 AM Reply Quote 1
      • E
        EduardoTSeoane
        last edited by Nov 20, 2019, 2:57 PM

        yes i can try it, are there any database change? from 1.5.6? maybe i can do a realistic test with the same stressed database.

        A bit of info more:

        The problem is located on snapin.class.php function getPrimaryGroup($groupID)

        Maybe i cant dive a bit more on the code.

        T 1 Reply Last reply Nov 21, 2019, 3:00 PM Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Nov 20, 2019, 4:05 PM

          @EduardoTSeoane With your very advanced setup I wouldn’t suggest you go to working-1.6 yet. If you update the DB schema there is no way back other than manually reverting the DB changes!!! I’d think it’s better we try to find the bottleneck in 1.5.x and port the fix to working-1.6 then as well.

          This is verified on FOG Version 1.5.6 and FOG Version 1.5.7

          Which version do you currently run?

          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

          E 1 Reply Last reply Nov 21, 2019, 9:44 AM Reply Quote 0
          • E
            EduardoTSeoane @Sebastian Roth
            last edited by Nov 21, 2019, 9:44 AM

            @Sebastian-Roth 1.5.6 officially, and on my development/testing machine 1.5.7

            1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator
              last edited by Nov 21, 2019, 2:56 PM

              @EduardoTSeoane I will take a closer look at this on Friday evening (CET). Won’t find the time before that.

              Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

              Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

              1 Reply Last reply Reply Quote 0
              • T
                Tom Elliott @EduardoTSeoane
                last edited by Nov 21, 2019, 3:00 PM

                @EduardoTSeoane The get primary group error is likely from the typo for the snapin checking that has ‘prmary’ rather than ‘primary’

                Can you look for the file that contains ‘prmary’ and add the I to it. This may or may not help, but at least the typo will be corrected either way.

                Please help us build the FOG community with everyone involved. It's not just about coding - way more we need people to test things, update documentation and most importantly work on uniting the community of people enjoying and working on FOG! Get in contact with me (chat bubble in the top right corner) if you want to join in.

                Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                E 2 Replies Last reply Nov 21, 2019, 3:08 PM Reply Quote 0
                • E
                  EduardoTSeoane @Tom Elliott
                  last edited by Nov 21, 2019, 3:08 PM

                  @Tom-Elliott @Sebastian-Roth ok i try it tomorrow and tell you if it helps.

                  1 Reply Last reply Reply Quote 0
                  • E
                    EduardoTSeoane @Tom Elliott
                    last edited by Nov 22, 2019, 8:45 AM

                    @Tom-Elliott @Sebastian-Roth
                    Typo corrected and don’t solve the problem, i dive a bit more on the code, and now i’m on
                    /var/www/html/fog/lib/fog/snapin.class.php

                    Commenting the code into the function getPrimaryGroup($groupID) // line 367

                    The WebUI has reasonable performance.

                    Then i think that the problem is that the nested loop in fastmerge function on line 2397 of fogbase.class.php, “is not so fast hehe”, maybe it helps.

                    A lot of thanks for your efforts in advance.

                    Maybe this night i can configure de working-1.6 personal test server with my production database.

                    Q 1 Reply Last reply Nov 25, 2019, 9:03 AM Reply Quote 0
                    • Q
                      Quazz Moderator @EduardoTSeoane
                      last edited by Quazz Nov 25, 2019, 3:15 AM Nov 25, 2019, 9:03 AM

                      @EduardoTSeoane

                      Here is a possible alternative for the fastmerge function.

                          public static function fastmerge($array1)
                          {
                              $others = func_get_args();
                              array_shift($others);
                              $array1 = array_merge($array1,...$others);
                      
                              return $array1;
                          }
                      

                      Though I expect performance difference to be minimal.

                      More likely that the problem lies in the sheer number of it.

                      Possibly 1.6 is a better environment for that.

                      1 Reply Last reply Reply Quote 0
                      • E
                        EduardoTSeoane @Tom Elliott
                        last edited by Nov 27, 2019, 8:32 AM

                        @Sebastian-Roth @Tom-Elliott said in Common WebUI pages takes minutes to load.:

                        Would you mind trying on working-1.6? (Preferabbly the same database but on a test instance?) to see if performance is improved at all?

                        Ok, I’m ready to start the test, plz explain me how do you want the, bugs/problems report?

                        1 Reply Last reply Reply Quote 0
                        • S
                          Sebastian Roth Moderator
                          last edited by Nov 27, 2019, 1:23 PM

                          @EduardoTSeoane said in Common WebUI pages takes minutes to load.:

                          Ok, I’m ready to start the test, plz explain me how do you want the, bugs/problems report?

                          Just report here in the forums as you did before. Or if you are keen you could also post an issue on github. Whichever suites you best.

                          Web GUI issue? Please check apache error (debian/ubuntu: /var/log/apache2/error.log, centos/fedora/rhel: /var/log/httpd/error_log) and php-fpm log (/var/log/php*-fpm.log)

                          Please support FOG if you like it: https://wiki.fogproject.org/wiki/index.php/Support_FOG

                          1 Reply Last reply Reply Quote 0
                          • 1 / 1
                          1 / 1
                          • First post
                            11/12
                            Last post

                          155

                          Online

                          12.0k

                          Users

                          17.3k

                          Topics

                          155.2k

                          Posts
                          Copyright © 2012-2024 FOG Project