Resolved Backups to remote FTP repositories are failing

[regisg]

Hello,

I use Plesk Onyx Version 17.5.3 Update #29

These are my backup settings : 2017-11-26_10h03_24.jpg and 2017-11-26_10h32_03.jpg
(I have lot of free space on the remote FTP repository)

=> Backups at not created every night ! Cf. 2017-11-26_10h29_02.jpg

I had a look to /usr/local/psa/PMM/logs/pmmcli.log but i can't see anything about this task : it seems that there was no attempts to create backups at all !

Thx for your help.

 

[Bitpalast]

Please check your log again. /logs/pmmcli.log ist not the right place to look at. The correct log location is
/usr/local/psa/PMM/logs/backup-<datetime>
In that directory you will find two files:
backup.log
pmmcli.log
Most likely either one will explain what is going wrong.

 

[regisg]

Hello,

Thx for you answer.

There is none logs folder into /usr/local/psa/PMM/
See 2017-11-27_06h01_54.jpg

This is the end of the pmmcli.log at the root of /usr/local/psa/PMM/ :

[2017-11-27 06:00:54.592|19862] DEBUG: --> <pmmcli.GetTasksListAction object at 0xf12210>
[2017-11-27 06:00:54.593|19862] INFO: stdin: <?xml version="1.0" ?><tasks-list-query><type>Restore</type><type>Backup</type><top-object-type>server</top-object-type><top-object-id>1</top-object-id></tasks-list-query>
[2017-11-27 06:00:54.595|19862] INFO: Packet succesfully validated.
[2017-11-27 06:00:54.596|19862] DEBUG: <pmmcli.ActionRunner object at 0xf12750>: doActivity
[2017-11-27 06:00:54.596|19862] DEBUG: Acquired session mutex: MainThread
[2017-11-27 06:00:54.596|19862] DEBUG: Released session mutex: MainThread
[2017-11-27 06:00:54.596|19862] DEBUG: <pmmcli.GetTasksListAction object at 0xf12210>: response
[2017-11-27 06:00:54.597|19862] INFO: Outgoing packet:
<?xml version="1.0" ?><response>
    <errcode>0</errcode>
    <data>
        <task-list>
        </task-list>
    </data>
</response>
[2017-11-27 06:00:54.670|19863] DEBUG: --> <pmmcli.GetTasksListAction object at 0xf12210>
[2017-11-27 06:00:54.671|19863] INFO: stdin: <?xml version="1.0" ?><tasks-list-query><type>Backup</type><top-object-type>server</top-object-type><top-object-id>1</top-object-id></tasks-list-query>
[2017-11-27 06:00:54.673|19863] INFO: Packet succesfully validated.
[2017-11-27 06:00:54.673|19863] DEBUG: <pmmcli.ActionRunner object at 0xf12750>: doActivity
[2017-11-27 06:00:54.674|19863] DEBUG: Acquired session mutex: MainThread
[2017-11-27 06:00:54.674|19863] DEBUG: Released session mutex: MainThread
[2017-11-27 06:00:54.674|19863] DEBUG: <pmmcli.GetTasksListAction object at 0xf12210>: response
[2017-11-27 06:00:54.675|19863] INFO: Outgoing packet:
<?xml version="1.0" ?><response>
    <errcode>0</errcode>
    <data>
        <task-list>
        </task-list>
    </data>
</response>
[2017-11-27 06:00:54.747|19864] DEBUG: --> <pmmcli.GetDumpsListAction object at 0xf12210>
[2017-11-27 06:00:54.747|19864] INFO: parameters: ['-lightweight-mode']
[2017-11-27 06:00:54.748|19864] INFO: stdin: <?xml version="1.0" ?><dump-list-query><dumps-storage-credentials storage-type="local"><root-dir>/var/lib/psa/dumps</root-dir><file-name/></dumps-storage-credentials><object-specification guid="7862cf2e-5487-4f10-a618-1988757e46b0" type="server"/></dump-list-query>
[2017-11-27 06:00:54.751|19864] INFO: Packet succesfully validated.
[2017-11-27 06:00:54.751|19864] DEBUG: <pmmcli.ActionRunner object at 0xf12750>: doActivity
[2017-11-27 06:00:54.752|19864] INFO: Executing <subprocess[19865] '/usr/local/psa/admin/bin/pmm-ras --get-dump-list --dump-storage=/var/lib/psa/dumps/ --type=server --guid=7862cf2e-5487-4f10-a618-1988757e46b0 --session-path=/var/log/plesk/PMM'>
[2017-11-27 06:00:54.760|19864] INFO: Execution of <subprocess[19865] '/usr/local/psa/admin/bin/pmm-ras --get-dump-list --dump-storage=/var/lib/psa/dumps/ --type=server --guid=7862cf2e-5487-4f10-a618-1988757e46b0 --session-path=/var/log/plesk/PMM'> finished successfully.
[2017-11-27 06:00:54.760|19864] DEBUG: <pmmcli.GetDumpsListAction object at 0xf12210>: response
[2017-11-27 06:00:54.761|19864] INFO: Outgoing packet:
<?xml version="1.0" ?><response>
    <errcode>0</errcode>
    <data>
        <dump-list skipped-files-count="">
        </dump-list>
    </data>
</response>
[2017-11-27 06:00:54.834|19866] DEBUG: --> <pmmcli.GetDumpsListAction object at 0xf12210>
[2017-11-27 06:00:54.834|19866] INFO: parameters: ['-lightweight-mode']
[2017-11-27 06:00:54.835|19866] INFO: stdin: <?xml version="1.0" ?><dump-list-query><dumps-storage-credentials storage-type="foreign-ftp" use-ftps="false" use-passive-ftp-mode="false"><login>ns345221.ip-5-196-79.eu</login><password>*****</password><hostname>ftpback-rbx3-515.ovh.net</hostname><root-dir/><file-name/></dumps-storage-credentials><object-specification guid="7862cf2e-5487-4f10-a618-1988757e46b0" type="server"/></dump-list-query>
[2017-11-27 06:00:54.837|19866] INFO: Packet succesfully validated.
[2017-11-27 06:00:54.838|19866] DEBUG: <pmmcli.ActionRunner object at 0xf12750>: doActivity
[2017-11-27 06:00:54.839|19866] INFO: Executing <subprocess[19867] '/usr/local/psa/admin/bin/pmm-ras --get-ftp-dump-list --lightweight-mode --dump-storage=ftp://[email protected]/ --session-path=/var/log/plesk/PMM'>
[2017-11-27 06:00:54.907|19866] INFO: Execution of <subprocess[19867] '/usr/local/psa/admin/bin/pmm-ras --get-ftp-dump-list --lightweight-mode --dump-storage=ftp://[email protected]/ --session-path=/var/log/plesk/PMM'> finished successfully.
[2017-11-27 06:00:54.907|19866] DEBUG: <pmmcli.GetDumpsListAction object at 0xf12210>: response
[2017-11-27 06:00:54.908|19866] INFO: Outgoing packet:
<?xml version="1.0" ?><response>
    <errcode>0</errcode>
    <data>
        <dump-list skipped-files-count="2">
        </dump-list>
    </data>
</response>

 

[Bitpalast]

Let's try to find out whether it is a backup issue or a schedule issue.
Does a manual backup work correctly, meaning that this occurs only on the scheduled backup?
Did your recently upgrade your MySQL database server?

 

[regisg]

Yes, a manual backup works correctly.
(I could't find the correspondent task in the scheduler)
No, I didn't upgrade recently my SQL Database Server... actually I can't do it (see : Issue - Plesk update Mysql Server )
THX.

 

[Bitpalast]

I was asking about the MySQL server upgrade (and version), because I have read reports online where the table format of the scheduler column for the backup scheduler mismatches the required format for the current Plesk version, so that scheduled backups do not run for that reason. If your MySQL server version is old, there is a possibility that this is the case here.

Would it be possible to open a ticket with official Plesk support for this issue? I doubt that this can be solved by a forum discussion. You should then ask about the old MySQL version you are using, too. Plesk Onyx does not support MariaDB 5.0, so most likely issues occuring in your installation are linked to the wrong database version.

 

[regisg]

OK thanks.
The best is first that i try to update MariaDB to V10.1 ...

 

[regisg]

Hello, that's OK now after upgrading (with difficulties...) MariaDB to 10.1
Thx.