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

Multi-Task Problem

Scheduled Pinned Locked Moved Solved
FOG Problems
3
34
4.9k
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.
  • J
    Joe Gill @Sebastian Roth
    last edited by Jun 12, 2019, 8:42 PM

    @Sebastian-Roth

    Awesome! That gives me a place to start. Thanks! I’ll do some digging. I’ll be tied up here in a couple hours for the rest of the day. I’ll post what I find out before I head out though. Thanks again!

    J 1 Reply Last reply Jun 13, 2019, 1:50 PM Reply Quote 0
    • J
      Joe Gill @Joe Gill
      last edited by Jun 13, 2019, 1:50 PM

      @Sebastian-Roth
      @Fernando-Gietz

      Here’s an error!

      MariaDB [fog]> INSERT INTO `multicastSessions` (`msName`,`msBasePort`,`msLogPath`,`msImage`,`msClients`,`msSessClients`,`msInterface`,`msStartDateTime`,`msPercent`,`msState`,`msCompleteDateTime`,`msIsDD`,`msNFSGroupID`,`msAnon3`,`msAnon4`,`msAnon5`) VALUES ('Multi-Cast Task - Elem-Lab','62250','WIN10Base_SSD','40','','','eth0','2019-06-12 15:05:26','0','0','','1','3','','','') ON DUPLICATE KEY UPDATE `msName`=VALUES(`msName`),`msBasePort`=VALUES(`msBasePort`),`msLogPath`=VALUES(`msLogPath`),`msImage`=VALUES(`msImage`),`msClients`=VALUES(`msClients`),`msSessClients`=VALUES(`msSessClients`),`msInterface`=VALUES(`msInterface`),`msStartDateTime`=VALUES(`msStartDateTime`),`msPercent`=VALUES(`msPercent`),`msState`=VALUES(`msState`),`msCompleteDateTime`=VALUES(`msCompleteDateTime`),`msIsDD`=VALUES(`msIsDD`),`msNFSGroupID`=VALUES(`msNFSGroupID`),`msAnon3`=VALUES(`msAnon3`),`msAnon4`=VALUES(`msAnon4`),`msAnon5`=VALUES(`msAnon5`);
      ERROR 1054 (42S22): Unknown column 'msAnon3' in 'field list'
      MariaDB [fog]> 
      

      Any ideas? I’ll be around all day today if you guys want to take a look at it.

      Thanks!

      1 Reply Last reply Reply Quote 0
      • F
        Fernando Gietz Developer
        last edited by Jun 13, 2019, 2:05 PM

        Hi @Joe-Gill
        And the msAnon3 column, does exist in the database?

        #desc multicastSessions;
        
        J 1 Reply Last reply Jun 13, 2019, 2:06 PM Reply Quote 0
        • S
          Sebastian Roth Moderator
          last edited by Jun 13, 2019, 2:06 PM

          @Joe-Gill Sounds like your DB has more issues that what we have fixed last time. But this one sounds really strange! Please run DESC multicastSessions in the mysql command line and post output here.

          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
          • J
            Joe Gill @Fernando Gietz
            last edited by Jun 13, 2019, 2:06 PM

            @Fernando-Gietz

            MariaDB [fog]> desc multicastSessions;
            +--------------------+---------------+------+-----+---------+----------------+
            | Field              | Type          | Null | Key | Default | Extra          |
            +--------------------+---------------+------+-----+---------+----------------+
            | msID               | int(11)       | NO   | PRI | NULL    | auto_increment |
            | msName             | varchar(250)  | NO   |     | NULL    |                |
            | msBasePort         | int(11)       | NO   |     | NULL    |                |
            | msLogPath          | longtext      | NO   |     | NULL    |                |
            | msImage            | longtext      | NO   |     | NULL    |                |
            | msClients          | int(11)       | NO   |     | NULL    |                |
            | msSessClients      | int(11)       | NO   |     | NULL    |                |
            | msInterface        | varchar(250)  | NO   |     | NULL    |                |
            | msStartDateTime    | datetime      | NO   |     | NULL    |                |
            | msPercent          | int(11)       | NO   |     | NULL    |                |
            | msState            | int(11)       | NO   |     | NULL    |                |
            | msCompleteDateTime | datetime      | NO   |     | NULL    |                |
            | msIsDD             | int(11)       | NO   |     | NULL    |                |
            | msNFSGroupID       | int(11)       | NO   | MUL | NULL    |                |
            | msShutdown         | enum('0','1') | NO   |     | 0       |                |
            | msMaxwait          | int(11)       | NO   |     | NULL    |                |
            | msAnon5            | varchar(250)  | NO   |     | NULL    |                |
            +--------------------+---------------+------+-----+---------+----------------+
            17 rows in set (0.01 sec)
            
            MariaDB [fog]> 
            
            1 Reply Last reply Reply Quote 0
            • F
              Fernando Gietz Developer
              last edited by Jun 13, 2019, 2:07 PM

              Your database is … strange!!! XD

              MariaDB [fog]> desc multicastSessions;
              +--------------------+--------------+------+-----+---------+----------------+
              | Field              | Type         | Null | Key | Default | Extra          |
              +--------------------+--------------+------+-----+---------+----------------+
              | msID               | int(11)      | NO   | PRI | NULL    | auto_increment |
              | msName             | varchar(250) | NO   |     | NULL    |                |
              | msBasePort         | int(11)      | NO   |     | NULL    |                |
              | msLogPath          | longtext     | NO   |     | NULL    |                |
              | msImage            | longtext     | NO   |     | NULL    |                |
              | msClients          | int(11)      | NO   |     | NULL    |                |
              | msSessClients      | int(11)      | NO   |     | NULL    |                |
              | msInterface        | varchar(250) | NO   |     | NULL    |                |
              | msStartDateTime    | datetime     | NO   |     | NULL    |                |
              | msPercent          | int(11)      | NO   |     | NULL    |                |
              | msState            | int(11)      | NO   |     | NULL    |                |
              | msCompleteDateTime | datetime     | NO   |     | NULL    |                |
              | msIsDD             | int(11)      | NO   |     | NULL    |                |
              | msNFSGroupID       | int(11)      | NO   | MUL | NULL    |                |
              | msAnon3            | varchar(250) | NO   |     | NULL    |                |
              | msAnon4            | varchar(250) | NO   |     | NULL    |                |
              | msAnon5            | varchar(250) | NO   |     | NULL    |                |
              +--------------------+--------------+------+-----+---------+----------------+
              17 rows in set (0.012 sec)
              
              J 1 Reply Last reply Jun 13, 2019, 2:08 PM Reply Quote 0
              • J
                Joe Gill @Fernando Gietz
                last edited by Jun 13, 2019, 2:08 PM

                @Fernando-Gietz

                I blame @Tom-Elliott ! Ha! He helped me with it last year and the past few years.

                1 Reply Last reply Reply Quote 0
                • S
                  Sebastian Roth Moderator
                  last edited by Jun 13, 2019, 2:11 PM

                  @Joe-Gill You can manually add the coloumns to match the schema Fernando posted.

                  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

                  J 1 Reply Last reply Jun 13, 2019, 2:14 PM Reply Quote 0
                  • J
                    Joe Gill @Sebastian Roth
                    last edited by Jun 13, 2019, 2:14 PM

                    @Sebastian-Roth

                    I’d need a bit of guidance there as I have little experience working in the DB. But I’m willing to try anything. I have a backup. Ha!

                    1 Reply Last reply Reply Quote 0
                    • S
                      Sebastian Roth Moderator
                      last edited by Jun 13, 2019, 2:29 PM

                      @Joe-Gill Ahhhhhhh, I just figured what’s wrong with your DB. Seems like you have used Tom’s working-1.6 branch at some point in time.

                      Take a look here: https://github.com/FOGProject/fogproject/blob/working-1.6/packages/web/commons/schema.php#L3746

                      Guess you need to manually reverse the last few schema changes you see in the above link. Not sure how far back you need to go. Probably as far as 264.

                      @Tom-Elliott We really need to get the schema change numbers sorted when I get back from my travels.

                      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

                      J 1 Reply Last reply Jun 13, 2019, 2:32 PM Reply Quote 0
                      • J
                        Joe Gill @Sebastian Roth
                        last edited by Jun 13, 2019, 2:32 PM

                        @Sebastian-Roth
                        @Tom-Elliott

                        Yes, I have used Tom’s working-1.6 branch. I’ll check out the link you posted from github and see if I can’t figure things out.

                        Thanks for looking at it!

                        Enjoy your travels!

                        J 1 Reply Last reply Jun 13, 2019, 4:24 PM Reply Quote 0
                        • J
                          Joe Gill @Joe Gill
                          last edited by Jun 13, 2019, 4:24 PM

                          @Sebastian-Roth
                          @Fernando-Gietz

                          Any advice on how to manually reverse the last few schema changes?

                          Thanks!

                          1 Reply Last reply Reply Quote 0
                          • F
                            Fernando Gietz Developer
                            last edited by Fernando Gietz Jun 13, 2019, 10:32 AM Jun 13, 2019, 4:32 PM

                            I will not drop the msShutdown and msMaxwait columns (I don´t know if in this version are neccesary), I will only add the new columns. Try with this:

                            ALTER TABLE multicastSessions
                            ADD COLUMN msAnon3 VARCHAR(250) AFTER msNFSGroupID;
                            
                            ALTER TABLE multicastSessions
                            ADD COLUMN msAnon4 VARCHAR(250) AFTER msAnon3;
                            
                            J 1 Reply Last reply Jun 13, 2019, 4:49 PM Reply Quote 1
                            • J
                              Joe Gill @Fernando Gietz
                              last edited by george1421 Jun 13, 2019, 2:26 PM Jun 13, 2019, 4:49 PM

                              @Fernando-Gietz
                              @Sebastian-Roth

                              Fernando’s fix takes it! That worked!

                              The first statement didn’t produce any results. But the second one did and after I restarted Multicasting, things are working again! Woo Whoo!

                              Thanks guys! I owe you both a beer!

                              Cheers!

                              For the record, if anyone else has this issue…

                              This was the fix…

                              ALTER TABLE multicastSessions
                              ADD COLUMN msAnon4 VARCHAR(250) AFTER msAnon3;
                              
                              1 Reply Last reply Reply Quote 0
                              • 1
                              • 2
                              • 2 / 2
                              2 / 2
                              • First post
                                31/34
                                Last post

                              342

                              Online

                              12.0k

                              Users

                              17.3k

                              Topics

                              155.2k

                              Posts
                              Copyright © 2012-2024 FOG Project