Trying to get warm spare to work after upgrading from 13 to 15. When I run the warm spare backup from the primary I get this:
Backup completed successfully
Warmspare enabled for this backup
We Have triggered an API to restore the backup on Spare Server
If I try to restore on the warm spare the file created by the backup run above I get
Restore processing for modules are finished successfully Running Post Restore Hooks⌠Please note that hook will restart httpd service so please refresh your page (using new ports) Running Post Restore Hooks DONE Finished There were errors during the restore process The process â/usr/bin/mysql --host localhost --user freepbxuser -RemovedPassword asteriskcdrdb < /tmp/backup/ae717319-41c5-47e6-9b25-ffac9016e1a5/files/tmp/dbdump/cdr.sqlâ exceeded the timeout of 60 seconds. on line 1335 of file /var/www/html/admin/libraries/Composer/vendor/symfony/process/Process.php
Thanks Dicko. I am going to make sure I still have a backup from before I upgraded then try this. Thank you so much for the help and fast reply. You are Awesome!
So I did this and changed the mysql.connect_timeout = 60 to mysql.connect_timeout = 240 but I still got
Restore processing for modules are finished successfully
Apache will Restart now⌠And your GUI may die if the ports are changed !!!
New port for accessing sslacp = 443
10.1.1.12:443/admin/config.php?display=backup
Running Post Restore Hooks⌠Please note that hook will restart httpd service so please refresh your page (using new ports)
Running Post Restore Hooks DONE
Finished
There were errors during the restore process
The process â/usr/bin/mysql --host localhost --user freepbxuser -removedPassword asteriskcdrdb < /tmp/backup/19ae6b8d-6d14-4dff-a643-20e09fa8be97/files/tmp/dbdump/cdr.sqlâ exceeded the timeout of 60 seconds. on line 1335 of file /var/www/html/admin/libraries/Composer/vendor/symfony/process/Process.php
I did however get updated CDR records in the warm spare.
This issue is because of process time out. currently it is 60 seconds. We are increasing to a higher value.
We have created a ticket for this . https://issues.freepbx.org/browse/FREEPBX-21178
This worked and now I can restore but I have a new problem. When I start a new warm spare backup on the Primary server Calls stop processing for about 10 min. This is probably not an issue because the warm spare backup happens at night but still an issue. I am going to look at logs and see if I can tell what happened.