Database unreachable

Discussion in 'Installation/Configuration' started by stef157, Jul 31, 2016.

  1. stef157

    stef157 Member

    Hi all,
    I'm currently in trouble with MariaDB.

    The server is not reachable so I've to kill the PID and restart it.
    When it's restarted, i made a "SHOW PROCESSLIST" and here what I see :

    Code:
    50    ispconfig    localhost:46603    dbispconfig    Sleep    98        NULL    0.000
    65    ispconfig    localhost:46624    dbispconfig    Sleep    206        NULL    0.000
    88    ispconfig    localhost:46667    dbispconfig    Sleep    16        NULL    0.000
    101    ispconfig    localhost:46689    dbispconfig    Sleep    49        NULL    0.000
    103    ispconfig    localhost:46691    dbispconfig    Sleep    49        NULL    0.000
    105    ispconfig    localhost:46693    dbispconfig    Sleep    150        NULL    0.000
    106    ispconfig    localhost:46694    dbispconfig    Sleep    150        NULL    0.000
    109    ispconfig    localhost:46697    dbispconfig    Sleep    150        NULL    0.000
    110    ispconfig    localhost:46699    dbispconfig    Sleep    83        NULL    0.000
    117    ispconfig    localhost:46706    dbispconfig    Sleep    15        NULL    0.000
    204    ispconfig    localhost:46782    dbispconfig    Sleep    16        NULL    0.000
    270    ispconfig    localhost:46966    dbispconfig    Sleep    83        NULL    0.000
    278    ispconfig    localhost:46975    dbispconfig    Sleep    48        NULL    0.000
    279    ispconfig    localhost:46976    dbispconfig    Sleep    48        NULL    0.000
    280    ispconfig    localhost:46977    dbispconfig    Sleep    16        NULL    0.000
    281    ispconfig    localhost:46978    dbispconfig    Sleep    16        NULL    0.000
    282    ispconfig    localhost:46979    dbispconfig    Sleep    48        NULL    0.000
    284    root    localhost:46983    NULL    Query    0    init    SHOW PROCESSLIST    0.000
    285    root    localhost:46984    NULL    Sleep    34        NULL    0.000
    287    ispconfig    localhost:46986    dbispconfig    Sleep    16        NULL    0.000
    288    ispconfig    localhost:46987    dbispconfig    Sleep    16        NULL    0.000
    289    ispconfig    localhost:46988    dbispconfig    Sleep    16        NULL    0.000
    290    ispconfig    localhost:46989    dbispconfig    Sleep    17        NULL    0.000
    291    ispconfig    localhost:46990    dbispconfig    Sleep    17        NULL    0.000
    292    ispconfig    localhost:46991    dbispconfig    Sleep    17        NULL    0.000
    293    ispconfig    localhost:46992    dbispconfig    Sleep    17        NULL    0.000
    294    ispconfig    localhost:46993    dbispconfig    Sleep    17        NULL    0.000
    295    ispconfig    localhost:46997    dbispconfig    Sleep    15        NULL    0.000
    296    ispconfig    localhost:46998    dbispconfig    Sleep    15        NULL    0.000
    297    ispconfig    localhost    dbispconfig    Sleep    16        NULL    0.000
    An idea of what I can do or where it comes from?

    Kind regard,
    St├ęphane
     
  2. till

    till Super Moderator Staff Member ISPConfig Developer

    This does not has to be an error, there can be plenty of connections as all parts of the system like postfix, amavis, pure-ftpd and dovecot connect to the database with this user and they keep connections open as it uses less resources then opening and closing connections all the time. So the above number of sleeping connections should be ok.
     
  3. stef157

    stef157 Member

    Alright (thanks for the confirmation), do you have an idea how can i monitor witch access cause the damage or when it appear ?
    => The process is still running but unreachable (timeout).

    And the log are empty.
     

Share This Page