DB server not running its queue job.

Discussion in 'Installation/Configuration' started by Frost, Sep 8, 2019.

  1. Frost

    Frost New Member

    Environment: Ubuntu 18.04, ISPConfig 3.1.14 Multiserver setup
    Recent changes: I added a mirror DB server(DB2). It was setup as MASTER-MASTER. Replication is running correctly however, after setting it up I tried to resync everything using ISPConfig resync tool. All job queues except DB1 was processed.

    Steps taken to resolve the issue:
    1. rm /usr/local/ispconfig/server/temp/.ispconf*
    2. Run ./server.sh manually.

    Code:
    08.09.2019-18:16 - WARNING - There is already a lockfile set, but no process running with this pid (27678). Continuing.                                                                                                                 
    Datenbank nicht gefunden / Database not foundPHP Fatal error:  Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/server/server.php:72                                                       
    Stack trace:                                                                                                                                                                                                                             
    #0 {main}                                                                                                                                                                                                                               
      thrown in /usr/local/ispconfig/server/server.php on line 72                                                                                                                                                                           
    Datenbank nicht gefunden / Database not foundPHP Fatal error:  Uncaught Error: Call to a member function queryOneRecord() on boolean in /usr/local/ispconfig/security/check.php:55                                                       
    Stack trace:                                                                                                                                                                                                                             
    #0 {main}                                                                                                                                                                                                                               
      thrown in /usr/local/ispconfig/security/check.php on line 55     
     
  2. Frost

    Frost New Member

    Somehow /usr/local/ispconfig/server/lib/config.inc.php listed $conf['db_database'] = 'dbispconfig'; which should be $conf['db_database'] = 'dbispconfig2'; This resolves my issue.
     
    Last edited: Sep 9, 2019
  3. till

    till Super Moderator Staff Member ISPConfig Developer

    It depends on which config.inc.php you are talking about. The interface file on server2 has to contain dbispconfig while the server one has to contain dbispconfig2. If you would put dbispconfig into the interface file, then you get a split-brain config and the system will crash as soon as you use the interface on server2.
     

Share This Page