Welcome Guest. Please Login or Register  


You are here: Index > Virtualizor - Virtual Server Control Panel > Bugs > Topic : Segfault when trying to make database backup



Threaded Mode | Print  

 Segfault when trying to make database backup (8 Replies, Read 39133 times)
wolke
Group: NOC
Post Group: Elite Member
Posts: 437
Status:
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

IP: --   

Segfault when trying to make database backup
jevingala
Group: Virtualizor Team
Post Group: Super Member
Posts: 739
Status:
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/
IP: --   

Segfault when trying to make database backup
wolke
Group: NOC
Post Group: Elite Member
Posts: 437
Status:
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.
IP: --   

Segfault when trying to make database backup
jevingala
Group: Virtualizor Team
Post Group: Super Member
Posts: 739
Status:
Please try this command :


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

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

Segfault when trying to make database backup
wolke
Group: NOC
Post Group: Elite Member
Posts: 437
Status:
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)
IP: --   

Segfault when trying to make database backup
jevingala
Group: Virtualizor Team
Post Group: Super Member
Posts: 739
Status:
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/
IP: --   

Segfault when trying to make database backup
wolke
Group: NOC
Post Group: Elite Member
Posts: 437
Status:
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.
IP: --   

Segfault when trying to make database backup
jevingala
Group: Virtualizor Team
Post Group: Super Member
Posts: 739
Status:
Hi,


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

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

Segfault when trying to make database backup
wolke
Group: NOC
Post Group: Elite Member
Posts: 437
Status:
No, that´s a different one.
IP: --   

« Previous    Next »

Threaded Mode | Print  



Jump To :


Users viewing this topic
1 guests, 0 users.


All times are GMT. The time now is March 28, 2024, 3:42 pm.

  Powered By AEF 1.0.8 © 2007-2008 Electron Inc.Queries: 10  |  Page Created In:0.025