Softaculous

Topic : Segfault when trying to make database backup

Posted By: wolke on November 30, 2019, 12:22 pm

I receive the following error when trying to start a db backup:

Quote

/bin/sh: line 1: 4742 Segmentation fault /usr/local/emps/bin/php /usr/local/virtualizor/scripts/databasebackups.php -r >> /var/virtualizor/log/virtualizor-dbbackup.log

No errors shown in virtualizor-dbbackup.log

Posted By: jevingala on December 13, 2019, 7:00 am | Post: 1

Hi,

Can you please provide output of : ls -lh /usr/local/emps/bin/php

Are you able to backup using this command :

mysqldump -u root -p[db_password] virtualizor > dumpfilename.sql

Edited by jevingala : December 13, 2019, 7:01 am

-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: wolke on December 13, 2019, 11:31 am | Post: 2

Quote

Can you please provide output of : ls -lh /usr/local/emps/bin/php

Code
-rwxr-xr-x 1 root root 13M Jul  5 11:22 /usr/local/emps/bin/php

Quote

Are you able to backup using this command :
mysqldump -u root -p[db_password] virtualizor > dumpfilename.sql

How could I? The db has been instaled by the virtualizor installation script, so I can´t know the root pw for mysql.

Posted By: jevingala on December 13, 2019, 11:32 am | Post: 3

Please try this command :

grep dbpass /usr/local/virtualizor/universal.php

-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: wolke on December 13, 2019, 11:36 am | Post: 4

Yes, that´s working and the dumpfile has been created without errors.
(But I need to start mysqldump inside the /usr/local/emps/bin/ folder)

Posted By: jevingala on December 13, 2019, 11:37 am | Post: 5

Hi,

Are you talking about automated database backup ?

Is there any error in /var/virtualizor/log/virtualizor-dbbackup.log ?

Also on what action's output you saw 4742 Segmentation fault ?

-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: wolke on December 13, 2019, 11:43 am | Post: 6

Yes, this is with automated backups and the log shows only:

Quote

[Sat Nov 30, 2019 12:31:14 GMT] Starting the backup process
Local Backup: TRUE
Remote Backup: TRUE
Remote backup type: SSH
[Sat Nov 30, 2019 12:31:14 GMT] Creating the backup file
Connecting to the backup server

I found the reason, it was a permission problem on the backup server, so the script could not create a folder (thus silently died with a Segvault).
That has been fixed and backups are running fine now.

Posted By: jevingala on December 13, 2019, 11:45 am | Post: 7

Hi,

Great, is the same backup server with same user in use for vps backup plans ?

-----------------------
Regards,
Virtualizor Team.
http://virtualizor.com/

Posted By: wolke on December 13, 2019, 12:00 pm | Post: 8

No, that´s a different one.