• Recent
  • Unsolved
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Register
  • Login
  • 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.1k
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.
  • M
    Matthieu Jacquart
    last edited by Mar 17, 2016, 1:34 PM

    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
    • T
      Tom Elliott
      last edited by Mar 17, 2016, 1:35 PM

      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
      • M
        Matthieu Jacquart
        last edited by Mar 17, 2016, 1:52 PM

        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

        T 1 Reply Last reply Mar 17, 2016, 3:44 PM Reply Quote 0
        • T
          Tom Elliott @Matthieu Jacquart
          last edited by Mar 17, 2016, 3:44 PM

          @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

          M 1 Reply Last reply Mar 18, 2016, 7:12 AM Reply Quote 1
          • M
            Matthieu Jacquart @Tom Elliott
            last edited by Mar 18, 2016, 7:12 AM

            @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

            T 1 Reply Last reply Mar 18, 2016, 11:03 AM Reply Quote 0
            • T
              Tom Elliott @Matthieu Jacquart
              last edited by Mar 18, 2016, 11:03 AM

              @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
              • T
                Tom Elliott
                last edited by Mar 18, 2016, 11:04 AM

                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

                M 1 Reply Last reply Mar 18, 2016, 11:40 AM Reply Quote 0
                • M
                  Matthieu Jacquart @Tom Elliott
                  last edited by Mar 18, 2016, 11:40 AM

                  @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
                  1 / 1
                  • First post
                    1/8
                    Last post

                  161

                  Online

                  12.1k

                  Users

                  17.3k

                  Topics

                  155.3k

                  Posts
                  Copyright © 2012-2024 FOG Project