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

    Size if history table became bigger

    Scheduled Pinned Locked Moved Solved
    Bug Reports
    2
    8
    2.0k
    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.
    • Matthieu JacquartM
      Matthieu Jacquart
      last edited by

      Hi,

      When I looked on fog database size, I found it was much bigger than before (150Mo vs 2Mo usually).
      In fact, history table is around 146Mo, but I don’t know why it grows so quickly…
      I truncate it 10 minutes ago and there’s already 3000 lines which look like this :

      [2016-03-17 14:02:54] Host ID: 28 NAME: MATT has been successfully updated.
      

      Any reason ?

      Fog 1.5.9.138
      Debian 11
      Vmware ESXi

      1 Reply Last reply Reply Quote 0
      • Tom ElliottT
        Tom Elliott
        last edited by

        The history table is intended to be a record of events that happens. It looks like somebody is constantly updating the MATT host (maybe others?)

        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

        1 Reply Last reply Reply Quote 0
        • Matthieu JacquartM
          Matthieu Jacquart
          last edited by

          I saw into table that each computer update each minute, that’s why there are so many lines…
          But I’m pretty sure database and history table was much smaller before latest svn update…

          Fog 1.5.9.138
          Debian 11
          Vmware ESXi

          Tom ElliottT 1 Reply Last reply Reply Quote 0
          • Tom ElliottT
            Tom Elliott @Matthieu Jacquart
            last edited by

            @Matthieu-Jacquart It was. I added “logging” to the save function, which indeed the host’s do auto update every cycle.

            I’ll see if I can get this limited though.

            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

            Matthieu JacquartM 1 Reply Last reply Reply Quote 1
            • Matthieu JacquartM
              Matthieu Jacquart @Tom Elliott
              last edited by

              @Tom-Elliott After updating to svn 6799, it seems ok, no new line in history table 😉

              Fog 1.5.9.138
              Debian 11
              Vmware ESXi

              Tom ElliottT 1 Reply Last reply Reply Quote 0
              • Tom ElliottT
                Tom Elliott @Matthieu Jacquart
                last edited by

                @Matthieu-Jacquart Basically I just stopped recording anything.

                For now I’ll not record anything as for some long period of time it wasn’t recording either.

                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

                1 Reply Last reply Reply Quote 0
                • Tom ElliottT
                  Tom Elliott
                  last edited by

                  I still don’t know if this should be considered a bug, or if it should be considered potentially problematic as it would be constantly updating the history table (creating a fairly large DB file relatively quickly.) People like logging for the most part. They don’t like what it may entail though.

                  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

                  Matthieu JacquartM 1 Reply Last reply Reply Quote 0
                  • Matthieu JacquartM
                    Matthieu Jacquart @Tom Elliott
                    last edited by

                    @Tom-Elliott Ok I understood… Could it become an option which can be activated if needed in fog settings ?

                    Fog 1.5.9.138
                    Debian 11
                    Vmware ESXi

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

                    229

                    Online

                    12.0k

                    Users

                    17.3k

                    Topics

                    155.2k

                    Posts
                    Copyright © 2012-2024 FOG Project