FOG Project

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

    Storage Group Activity data displaying wrong information

    FOG Problems
    3
    14
    228
    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.
    • X
      xburnerx00 last edited by

      On the dash board it’s showing I have queued and active tasks but that’s not true. Is there a way to reset this and show correct information?
      88e460bd-5e09-4282-9d45-870888ab107e-image.png

      X 1 Reply Last reply Reply Quote 0
      • Referenced by  S Sebastian Roth 
      • X
        xburnerx00 last edited by

        Yes, the Dell Latitude 3189 are laptops that do not have internet ports and we had to use USB adapters. At that time, the version of FOG didn’t like same MACs for multiple machines. So the way I got around that was deleting the hosts since it was tied to a MAC from a USB and I was more concerned with just getting them imaged. I guess I deleted them prematurely. Unless I just overlooked something completely and did something wrong.

        As for the deploy task ones, I’m not sure why they were stuck in there. They may have been ones that seemed to be giving me imaging problems and I turned off the machine before canceling it in the task menu.

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

          @xburnerx00 Looks to me like the Hosts that were in the task were deleted at some point?

          So, if what I’m gathering makes sense:

          Auto-reg tasks were created (maybe by quick reg for these hosts.), but then the hosts were deleted. When those hosts were deleted, the tasks were not removed.

          This would explain why the tasked showed in the “queue” but not on the tasks list (as the hosts didn’t exist).

          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
          • X
            xburnerx00 last edited by

            MariaDB [fog]> SELECT * FROM hosts WHERE hostID IN ( 515, 401, 513, 529, 532, 584 );
            Empty set (0.00 sec)
            
            MariaDB [fog]> SELECT * FROM images WHERE imageID IN ( 32, 33, 13 );
            +---------+--------------------+-----------+------------------+--------------+----------------+---------------------+---------------+---------------+----------------------------------------------------------------------------------------------------+-------------+----------------------+-----------+-------------+---------------------+---------------+--------------+----------------+-----------------+
            | imageID | imageName          | imageDesc | imagePath        | imageProtect | imageMagnetUri | imageDateTime       | imageCreateBy | imageBuilding | imageSize                                                                                          | imageTypeID | imagePartitionTypeID | imageOSID | imageFormat | imageLastDeploy     | imageCompress | imageEnabled | imageReplicate | imageServerSize |
            +---------+--------------------+-----------+------------------+--------------+----------------+---------------------+---------------+---------------+----------------------------------------------------------------------------------------------------+-------------+----------------------+-----------+-------------+---------------------+---------------+--------------+----------------+-----------------+
            |      13 | DellOP3050         |           | DellOP3050       |            0 |                | 2019-07-17 15:31:36 | fog           |             0 | 524283904.000000:204800.000000:104857600.000000:16777216.000000:9948450.000000:40748851200.000000: |           1 |                    1 |         9 | 0           | 2020-05-11 12:54:12 |             6 | 1            | 1              |     19663157396 |
            |      32 | Dell Latitude 3189 |           | DellLatitude3189 |            0 |                | 2020-03-14 09:27:01 | fog           |             0 | 554692608.000000:104857600.000000:16777216.000000:25425911808.000000:                              |           1 |                    1 |         9 | 0           | 2020-03-14 11:52:34 |             6 | 1            | 1              |     14588521696 |
            |      33 | HP 400 G1          |           | HP400G1          |            0 |                | 2020-05-13 07:39:14 | fog           |             0 | 554692608.000000:104857600.000000:16777216.000000:8306813.000000:34024706048.000000:               |           1 |                    1 |         9 | 5           | 2020-05-13 08:05:09 |             6 | 1            | 1              |     16054171954 |
            +---------+--------------------+-----------+------------------+--------------+----------------+---------------------+---------------+---------------+----------------------------------------------------------------------------------------------------+-------------+----------------------+-----------+-------------+---------------------+---------------+--------------+----------------+-----------------+
            3 rows in set (0.00 sec)
            
            
            Tom Elliott 1 Reply Last reply Reply Quote 0
            • S
              Sebastian Roth Moderator last edited by

              @xburnerx00 Would you please run the following two queries to see if all of the hosts and images referenced still exist.

              SELECT * FROM hosts WHERE hostID IN ( 515, 401, 513, 529, 532, 584 );
              

              and

              SELECT * FROM images WHERE imageID IN ( 32, 33, 13 );
              

              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
              • X
                xburnerx00 last edited by

                @Tom-Elliott said in Storage Group Activity data displaying wrong information:

                UPDATE tasks SET taskStateID = 4 WHERE taskID IN (‘756’,‘905’,‘754’,‘771’,‘777’,‘908’);

                Yes, thank you, that worked.
                c9569b8c-bb88-45e4-8a50-a72ff97bf68c-image.png

                Any idea on what may have caused this, and how to avoid in the future?

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

                  @xburnerx00 If you are certain you have no tasks needed to be run right, can you run:

                  UPDATE tasks SET taskStateID = 4 WHERE taskID IN ('756','905','754','771','777','908');
                  

                  You should then have a cleaned up dashboard.

                  Thank you,

                  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
                  • X
                    xburnerx00 last edited by Sebastian Roth

                    MariaDB [fog]> SELECT * FROM tasks WHERE taskStateID IN ( 0, 1, 2, 3 );
                    +--------+----------------------------+---------------------+---------------------+------------+-------------+-------------+-------------+--------------+-----------+------------------------+------------+------------+----------+-----------------+-------------------+----------------+-----------------+---------------+----------------+-----------------+-----------------+------------------+---------+---------------+--------------+
                    | taskID | taskName                   | taskCreateTime      | taskCheckIn         | taskHostID | taskImageID | taskStateID | taskIsDebug | taskCreateBy | taskForce | taskScheduledStartTime | taskTypeID | taskPCT    | taskBPM  | taskTimeElapsed | taskTimeRemaining | taskDataCopied | taskPercentText | taskDataTotal | taskNFSGroupID | taskNFSMemberID | taskNFSFailures | taskLastMemberID | taskWOL | taskPassreset | taskShutdown |
                    +--------+----------------------------+---------------------+---------------------+------------+-------------+-------------+-------------+--------------+-----------+------------------------+------------+------------+----------+-----------------+-------------------+----------------+-----------------+---------------+----------------+-----------------+-----------------+------------------+---------+---------------+--------------+
                    |    756 | AutoRegTask - IS-STU-SL-03 | 2020-03-14 13:15:35 | 2020-03-14 13:28:02 |        515 |          32 |           1 |           0 | fog          | 0         | 0000-00-00 00:00:00    |          1 | 0000000000 |          |                 |                   |                |                 |               |              1 |               1 |                 |                0 | 0       |               |              |
                    |    905 | Deploy Task - HS-103-SD-17 | 2020-05-13 12:30:18 | 0000-00-00 00:00:00 |        401 |          33 |           1 |           0 | fog          | 0         | 0000-00-00 00:00:00    |          1 | 0000000000 |          |                 |                   |                |                 |               |              1 |               1 |                 |                0 | 0       |               |              |
                    |    754 | Deploy Task - IS-STU-SL-16 | 2020-03-14 13:08:01 | 2020-03-14 13:12:05 |        513 |          32 |           3 |           0 | fog          | 0         | 0000-00-00 00:00:00    |          1 | 0000000014 |   4.20GB | 00:00:50        | 00:05:04          | 3.264 GiB      | 14.12           | 23.680 GiB    |              1 |               1 |                 |                0 | 0       |               |              |
                    |    771 | AutoRegTask - IS-STU-SL-21 | 2020-03-14 16:05:24 | 2020-03-14 16:07:06 |        529 |          32 |           3 |           0 | fog          | 0         | 0000-00-00 00:00:00    |          1 | 0000000074 |   1.85GB | 00:00:11        | 00:00:03          | 415.80 MiB     | 74.05           | 529.00 MiB    |              1 |               1 |                 |                0 | 0       |               |              |
                    |    777 | AutoRegTask - IS-STU-SL-18 | 2020-03-14 16:27:08 | 2020-03-14 16:28:24 |        532 |          32 |           3 |           0 | fog          | 0         | 0000-00-00 00:00:00    |          1 | 0000000061 |  25.17MB | 00:00:55        | 00:00:35          | 23.26 MiB      | 60.50           | 100.00 MiB    |              1 |               1 |                 |                0 | 0       |               |              |
                    |    908 | AutoRegTask - HS-104-SD-13 | 2020-05-13 12:49:04 | 2020-05-13 12:50:03 |        584 |          13 |           3 |           0 | fog          | 0         | 0000-00-00 00:00:00    |          1 | 0000000000 |          |                 |                   |                |                 |               |              1 |               1 |                 |                0 | 0       |               |              |
                    +--------+----------------------------+---------------------+---------------------+------------+-------------+-------------+-------------+--------------+-----------+------------------------+------------+------------+----------+-----------------+-------------------+----------------+-----------------+---------------+----------------+-----------------+-----------------+------------------+---------+---------------+--------------+
                    6 rows in set (0.00 sec)
                    
                    Hard to see for me, but I see tasks that were set back in March 14, 2020 and May 15, 2020.
                    
                    MariaDB [fog]> SELECT * FROM multicastSessions WHERE msState IN ( 0, 1, 2, 3 );
                    Empty set (0.00 sec)
                    

                    I’ve never done Multicast sessions so I would think this should be empty.

                    Tom Elliott 1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator last edited by

                      @xburnerx00 I would think there are some old task states in the DB. Let’s try to figure it out. Go to your FOG server console and run the following commands/queries. First get the DB settings and use those credentials to log into the database to run a few queries:

                      shell> grep DATABASE_ /var/www/html/fog/lib/fog/config.class.php
                      ...
                      shell> mysql -u fogmaster -p fog
                      Password:
                      ...
                      mysql> SELECT * FROM tasks WHERE taskStateID IN ( 0, 1, 2, 3 );
                      ...
                      mysql> SELECT * FROM multicastSessions WHERE msState IN ( 0, 1, 2, 3 );
                      ...
                      mysql> quit
                      

                      Post all output here except your credentials.

                      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
                      • X
                        xburnerx00 last edited by

                        Updated 1.5.7 to 1.5.9-RC1

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

                          When you updated your FOG server, what version did you update from and to?

                          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
                          • X
                            xburnerx00 last edited by

                            No tasks.
                            bea7ccda-b058-4d7d-89d5-2e9228fd004f-image.png

                            1 Reply Last reply Reply Quote 0
                            • S
                              Sebastian Roth Moderator last edited by

                              @xburnerx00 Can you please post a picture of the Active Tasks view as well?

                              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
                              • X
                                xburnerx00 @xburnerx00 last edited by

                                @xburnerx00
                                Forgot to add version.

                                Version 1.5.9-RC1
                                
                                1 Reply Last reply Reply Quote 0
                                • 1 / 1
                                • First post
                                  Last post

                                253
                                Online

                                10.2k
                                Users

                                16.3k
                                Topics

                                149.9k
                                Posts

                                Copyright © 2012-2020 FOG Project