• 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.
  • A
    Adam Taylor
    last edited by Oct 23, 2015, 3:13 PM

    3306 is all localhost connections.

    80 is all different clients from around the campus.

    1 Reply Last reply Reply Quote 0
    • A
      Adam Taylor
      last edited by Oct 23, 2015, 3:27 PM

      I changed the DB connect from persistant to non persistant to test and see if the connections would then go away.

      The connections go up much faster then before (what i expected since no reuse) but once again…they never go down.

      That’s all i know to look at/try at the moment. Do appreciate your help in this!

      Thanks!

      Adam

      T 1 Reply Last reply Oct 23, 2015, 3:31 PM Reply Quote 0
      • T
        Tom Elliott @Adam Taylor
        last edited by Oct 23, 2015, 3:31 PM

        @Adam-Taylor I know I keep asking the same things, but please reupdate and try again?

        The only other thing that I think could be causing the issue is in line and hopefully this is corrected for. I have no real clue whether or not it is the case 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

        1 Reply Last reply Reply Quote 0
        • A
          Adam Taylor
          last edited by Oct 23, 2015, 3:58 PM

          The system is still getting hammered and all four cores are at 100% after a complete reboot.

          Adam

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

            Also, that 100% is always ~30% for mysql and the rest is chewed up with httpd processes.

            Adam

            W 1 Reply Last reply Oct 24, 2015, 12:36 AM Reply Quote 0
            • W
              Wayne Workman @Adam Taylor
              last edited by Oct 24, 2015, 12:36 AM

              @Adam-Taylor Tom has made some changes, update again.

              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!
              Daily Clean Installation Results:
              https://fogtesting.fogproject.us/
              FOG Reporting:
              https://fog-external-reporting-results.fogproject.us/

              1 Reply Last reply Reply Quote 0
              • 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
                                          32/41
                                          Last post

                                        204

                                        Online

                                        12.0k

                                        Users

                                        17.3k

                                        Topics

                                        155.2k

                                        Posts
                                        Copyright © 2012-2024 FOG Project