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

MYSQL/HTTPD resource issues in 5020

Scheduled Pinned Locked Moved Solved
Bug Reports
8
41
16.6k
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.
  • T
    Trevelyan
    last edited by Oct 26, 2015, 3:01 PM

    Changes don’t seem to have fixed anything for me. Still see 100% usage after restart and update to 5078- basically the same as my screenshot earlier.

    I do see this in the apache error log though, for all the clients that are trying to connect. Not sure itd make any difference though.
    :

    [Mon Oct 26 14:55:09.526015 2015] [:error] [pid 3099] [client 10.240.5.151:57133] PHP Warning:  mysqli::mysqli(): (HY000/2002): No such file or directory in /var/www/html/fog/lib/db/MySQL.class.php on line 18
    
    T 1 Reply Last reply Oct 26, 2015, 3:18 PM Reply Quote 0
    • T
      Tom Elliott @Trevelyan
      last edited by Oct 26, 2015, 3:18 PM

      @Trevelyan this makes absolutely no sense. It sounds like, from the error you are reporting, your server doesn’t have the mysqlnd driver stack for php as it can’t even find the mysqli object.

      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
      • A
        Adam Taylor
        last edited by Oct 26, 2015, 4:43 PM

        I am still seeing 100% usage for me to after the last update with mysql using~30% and httpd using the rest with LOTS of processes.

        Adam

        T 1 Reply Last reply Oct 26, 2015, 4:54 PM Reply Quote 0
        • T
          Tom Elliott @Adam Taylor
          last edited by Oct 26, 2015, 4:54 PM

          @Adam-Taylor WHen I get back to a normal schedule at work, I’d love to link up and run a Teamviewer connection with you.

          It seems, to me, that this isn’t something I’ve been causing, directly. For some time I had some issues, but I have a person who has around 6k hosts and was seeing the resource problems as described. I have confirmed with him that this is now fixed. Now that doesn’t mean an issue still doesn’t persist, but I’m pretty sure this isn’t something FOG is doing any more.

          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
          • A
            Adam Taylor
            last edited by Oct 26, 2015, 6:03 PM

            Can you ask him what OS, apache version, mysql version he is running for a can compare?

            Thanks,

            Adam

            1 Reply Last reply Reply Quote 0
            • A
              Adam Taylor
              last edited by Oct 26, 2015, 6:10 PM

              Question.

              Would the old fog client be causing this? We noticed the new MSI fog client but we are still running the old one.

              Adam

              1 Reply Last reply Reply Quote 0
              • T
                Trevelyan
                last edited by Trevelyan Oct 27, 2015, 3:50 AM Oct 27, 2015, 9:50 AM

                I’ve noticed that first thing in the morning, our server is fine. Its only when PCs start powering up that we see issues - but it isn’t even a hundred that cause it. Just loads and loads of high-CPU hogging apache2 instances that never seem to end.

                For the record - all of these are new clients (we have no PCs running the old client anymore)

                1 Reply Last reply Reply Quote 1
                • S
                  Sebastian Roth Moderator
                  last edited by Oct 27, 2015, 10:16 AM

                  Are you both running the latest SVN? Would be very interesting to see what is going on within those lots of processes! Maybe you could try using strace (option -p to attach to a running process, -o to write to a file) to see what is going on. I am aware of this being an advanced debugging issue and I am not sure if you are keen enough to get into this. Maybe give it a try and well see what we get. I am more than happy to take a look if you upload a strace log file.

                  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
                  • D
                    d4rk3
                    last edited by Oct 27, 2015, 12:24 PM

                    I am also experiencing this. This includes random revisions ranging from r4982 - r5080.

                    1 Reply Last reply Reply Quote 0
                    • J
                      Joseph Hales Testers
                      last edited by Oct 27, 2015, 2:03 PM

                      I am also still seeing this on this mornings SVN 5082 on ubuntu 14.
                      upload-d6018b50-572b-4c50-9f40-2d700c8b102e

                      It does not affect the storage node whose cpu load is around 1. Here is TOP of the main server.
                      upload-6f2fe626-bc01-4e99-bd29-8e863a072721

                      lsof -i :80 output
                      lsof output.txt

                      RTFM

                      1 Reply Last reply Reply Quote 0
                      • J
                        Joseph Hales Testers
                        last edited by Oct 27, 2015, 2:04 PM

                        Should this thread be marked solved or should I start a new thread.

                        RTFM

                        1 Reply Last reply Reply Quote 0
                        • S
                          Sebastian Roth Moderator
                          last edited by Oct 27, 2015, 6:12 PM

                          Maybe it is a good idea to start a (combined) new thread on this issue. Tom and I have been thinking and trying a lot but are unable to reproduce this issue. Probably because we only have a couple to a few dozens of clients to test with. Unfortunately I think we need you - @Adam-Taylor, @Joseph-Hales and @Raymond-Bell - to get into the details of debugging this. I am still not quite sure how we are going to get there. Here are some ideas:

                          • Check the output of apache2 -V or httpd -V for “Server MPM”, is it Worker or Prefork??
                          • Apache server status http://fog-ip/server-status (might be enabled already but only accessable from localhost - check out the apache mod-configs)
                          • Mysql logging, a good talk about this: http://stackoverflow.com/questions/568564/how-can-i-view-live-mysql-queries
                          • mysqladmin -u root -p -i 1 processlist;
                          • Tools like mytop and mtop (http://www.tecmint.com/mysql-performance-monitoring/)

                          Just a few ideas. Probably best to start a new thread and get into the details with this.

                          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
                            Joseph Hales Testers
                            last edited by Oct 27, 2015, 6:26 PM

                            @Uncle-Frank said:

                            mysqladmin -u root -p -i 1 processlist;

                            New thread started here
                            https://forums.fogproject.org/topic/6020/fog-svn-5020-and-above-cpu-hammered-thread/1

                            RTFM

                            1 Reply Last reply Reply Quote 0
                            • 1
                            • 2
                            • 3
                            • 2 / 3
                            2 / 3
                            • First post
                              38/41
                              Last post

                            235

                            Online

                            12.0k

                            Users

                            17.3k

                            Topics

                            155.2k

                            Posts
                            Copyright © 2012-2024 FOG Project