Lots of ispconfig_db_backup files

Discussion in 'General' started by davestyle, Nov 4, 2010.

  1. davestyle

    davestyle New Member

    Hey guys,

    Ever since I upgraded 3.0.3 something strange has started happening.
    It looks like something is doing a backup of the ispconfig database every random number of minutes.

    -rwx------ 1 root root 366036 2010-11-03 11:37 ispconfig_db_backup_2010-11-03_11-37.sql
    -rwx------ 1 root root 366036 2010-11-03 11:59 ispconfig_db_backup_2010-11-03_11-59.sql
    -rwx------ 1 root root 366839 2010-11-03 00:05 ispconfig_db_backup_2010-11-03_12-05.sql
    -rwx------ 1 root root 366036 2010-11-03 12:21 ispconfig_db_backup_2010-11-03_12-21.sql
    -rwx------ 1 root root 366876 2010-11-03 00:28 ispconfig_db_backup_2010-11-03_12-28.sql
    -rwx------ 1 root root 366036 2010-11-03 12:43 ispconfig_db_backup_2010-11-03_12-43.sql
    -rwx------ 1 root root 356639 2010-11-03 00:52 ispconfig_db_backup_2010-11-03_12-52.sql

    I don't recall making any scripts to do such a thing, and I can't find a setting anywhere in ISPconfig that would be responsible.
    Anybody shed any light?

    Thanks
     
  2. davestyle

    davestyle New Member

    OK, a bit more investigating has shown some light on the problem.
    It looks like ISPconfig is trying to upgrade itself and is stuck in some sort of loop, probably because of a PHP seg fault that is happening...


    2010-11-03 23:09:45 (98.0 KB/s) - `ISPConfig-3.0.3.tar.gz' saved [2976564/2976564]

    /usr/local/ispconfig/server/server.sh: line 7: 19298 Segmentation fault /usr/bin/php -q /usr/local/ispconfig/server/server.php
    --2010-11-03 23:32:14-- http://www.ispconfig.org/downloads/ISPConfig-3.0.3.tar.gz
    Resolving www.ispconfig.org... 78.46.59.59
    Connecting to www.ispconfig.org|78.46.59.59|:80... connected.
    HTTP request sent, awaiting response... 200 OK
    Length: 2976564 (2.8M) [application/x-gzip]
    Saving to: `ISPConfig-3.0.3.tar.gz'

    0K .......... .......... .......... .......... .......... 1% 317K 9s
    50K .......... .......... .......... .......... .......... 3% 226K 11s
    100K .......... .......... .......... .......... .......... 5% 533K 9s
    150K .......... .......... .......... .......... .......... 6% 160K 11s
    200K .......... .......... .......... .......... .......... 8% 313K 10s
    250K .......... .......... .......... .......... .......... 10% 347K 9s
    300K .......... .......... .......... .......... .......... 12% 297K 9s
    350K .......... .......... .......... .......... .......... 13% 291K 9s

    That pretty much continues in a loop.
    I guess that's where the backups are coming from. I clicked the Update ISPconfig button in the web interface a while back. Does anyone know how to delete that outstanding job.
     
  3. davestyle

    davestyle New Member

    Think I may have fixed it.
    There was 3 ispconfig_update jobs in the sys_remoteaction table in a "pending" state.
    Deleted all of them, and relay my results...

    DELETE FROM `sys_remoteaction` WHERE `sys_remoteaction`.`action_id` = 1;

    Lets just hope something else doesn't explode.
     
  4. davestyle

    davestyle New Member

    Yep, that did the job.

    Teach me to use an experimental feature :)
     

Share This Page