Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Unble to Restore Database from R1soft Backup

Discussion in 'Data Protection' started by uk01, May 21, 2019.

  1. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    171
    Likes Received:
    17
    Trophy Points:
    68
    Hi all,

    I'm just putting this out there as I"'ve not found an answer anywhere else and R1soft have not offered any solution. Also the license provider have seen the issue before but have no idea how to resolve.

    There will be Cpanel hosts who also offer R1soft backups. Have any of you started experiencing the errors below recently?
    Our problem started a few weeks ago out of the blue, it's been fine for ages, then suddenly we can't restore databases. Whatever we do, the restore fails.

    Logs below.
    Maybe others looking for a solution will find this thread and we'll get some input.

    Logs
    Code:
    ----------------------------------------
Message Time         Level    Source               Message
5/22/19 3:47:28 AM    Info     Manager    Attempting to connect to agent ********** at port ****
5/22/19 3:47:28 AM    Info     Manager    Connected to agent *********** at port **** successfully
5/22/19 3:47:29 AM    Info     Protected Machine    Agent Version 6.10.0.14
5/22/19 3:47:29 AM    Info     Protected Machine    Connection authenticated; Waiting for command.
5/22/19 3:47:29 AM    Info     Protected Machine    Executing get_mysql_instance_configuration_request request...
5/22/19 3:47:29 AM    Info     Manager    Restoring files to Agent required for selected databases
5/22/19 3:47:30 AM    Info     Manager    Calculating restore size
5/22/19 3:47:30 AM    Info     Manager    Calculation complete
5/22/19 3:47:30 AM    Info     Manager    Calculated 4.1 KB to restore (2 files)
5/22/19 3:47:30 AM    Info     Manager    Calculating restore size
5/22/19 3:47:30 AM    Info     Manager    Calculation complete
5/22/19 3:47:30 AM    Info     Manager    Calculated 76.0 MB to restore (1 files)
5/22/19 3:47:30 AM    Info     Manager    Calculating restore size
5/22/19 3:47:30 AM    Error    Manager    Failed to read filesystem for /var/lib/mysql/./ib_buffer_pool
5/22/19 3:47:30 AM    Error    Manager    Path not found ([var, lib, mysql, ., ib_buffer_pool])
5/22/19 3:47:30 AM    Error    Manager    Failed to read filesystem for /var/lib/mysql/./mysql.ibd
5/22/19 3:47:30 AM    Error    Manager    Path not found ([var, lib, mysql, ., mysql.ibd])
5/22/19 3:47:30 AM    Info     Manager    Calculation complete
5/22/19 3:47:30 AM    Info     Manager    Calculated 96.0 MB to restore (2 files)
5/22/19 3:47:30 AM    Warn     Manager    Errors encountered during calculations
5/22/19 3:47:30 AM    Warn     Manager    Estimated size and file count may not be accurate
5/22/19 3:47:32 AM    Info     Manager    Restoring MySQL database files to '/var/lib/r1soft/tmp/r1soft-mysql-restore-tmp-********************'
5/22/19 3:47:32 AM    Info     Protected Machine    Command completed; Waiting for next command.
5/22/19 3:47:32 AM    Info     Protected Machine    Executing file restore request...
5/22/19 3:47:33 AM    Error    Manager    Errors encountered during file restore
5/22/19 3:48:38 AM    Info     Manager    File restore complete
5/22/19 3:48:38 AM    Info     Manager    Setting up temporary MySQL instance
5/22/19 3:48:38 AM    Info     Protected Machine    Command completed; Waiting for next command.
5/22/19 3:48:38 AM    Info     Protected Machine    Executing mysql_start_restore request...
5/22/19 3:48:43 AM    Info     Protected Machine    Secondary MySQL instance process terminated
5/22/19 3:48:45 AM    Warn     Protected Machine    Secondary MySQL instance is not shutdown; you must do so manually!
5/22/19 3:48:45 AM    Error    Protected Machine    An exception occurred during the request. Unable to start the secondary MySQL instance.
5/22/19 3:48:45 AM    Error    Manager    Failed to start temporary database instance
5/22/19 3:48:45 AM    Error    Manager    Agent reported error during requested operation
5/22/19 3:48:45 AM    Error    Manager    Failed to start temporary database instance
5/22/19 3:48:46 AM    Error    Manager    Failed to start temporary database instance
5/22/19 3:48:46 AM    Error    Manager    Agent reported error during requested operation
5/22/19 3:48:46 AM    Info     Manager    Task Finished
     
    #1 uk01, May 21, 2019
    Last edited by a moderator: May 22, 2019
  2. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,455
    Likes Received:
    178
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    Yes actually, there is a problem with their latest agent. Their current advice is to roll back the agent version.

    This is what they told us:

     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 GOT, May 22, 2019
    cPanelLauren likes this.
  3. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    171
    Likes Received:
    17
    Trophy Points:
    68
    Fantastic, thanks for your reply. I will check this out!
     
    #3 uk01, May 22, 2019
  4. cPanelLauren

    cPanelLauren Forums Analyst II Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    6,141
    Likes Received:
    474
    Trophy Points:
    233
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    Thanks @GOT for the information!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelLauren, May 22, 2019
  5. mlweber

    mlweber Registered

    Joined:
    Jul 16, 2007
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    51
    Rolling back did not work for me. I have been having this issue since migrating to Centos 7. The iWeb Data Center System Administrators have been working with R1Soft for a solution, and I am told that R1Soft claims that the issue is with Centos 7 and mySQL 5.7 compatibility, and that they supposedly need to write a script to make the database restore function correctly.
     
    #5 mlweber, Jun 11, 2019 at 7:45 AM
  6. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    171
    Likes Received:
    17
    Trophy Points:
    68
    Admittably we've not actually tried the roll back yet due to workload. However, we've been on Centos 7 for ages and never had any issues so it's not directly related to that. We use MariaDB 10.1 and it worked before the latest updates (either r1 or otherwise, it just stopped one day!).
    R1 need to get their act together and resolve it rather than look for excuses otherwise people are just going to start looking for better back up solutions, after all R1 is very slow restoring even on a gig connection.
     
    #6 uk01, Jun 11, 2019 at 9:05 AM
    Last edited: Jun 11, 2019 at 9:11 AM
  7. uk01

    uk01 Well-Known Member

    Joined:
    Dec 31, 2009
    Messages:
    171
    Likes Received:
    17
    Trophy Points:
    68
    I would say that the agents etc tend to relate to the kernel version, so there may well be a relation between the latest centos 7 kernel and agent but still, if they are going to charge for software, it's their responsibility to resolve these issues quickly, the problem is R1 take forever to do everything.
     
    #7 uk01, Jun 11, 2019 at 9:08 AM
  8. GOT

    GOT Get Proactive! PartnerNOC

    Joined:
    Apr 8, 2003
    Messages:
    1,455
    Likes Received:
    178
    Trophy Points:
    193
    Location:
    Chesapeake, VA
    cPanel Access Level:
    DataCenter Provider
    We did not actually try the roll back either, so I cannot confirm it works either.

    R1 has been really disappointing. We rolled out an ubuntu 18 server which ahs been out a year and had to use a beta driver for it...

    On my agenda is looking for alternate options. Suggestions welcomed.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #8 GOT, Jun 11, 2019 at 9:09 AM
  9. wintech2003

    wintech2003 Active Member PartnerNOC

    Joined:
    Sep 15, 2010
    Messages:
    29
    Likes Received:
    2
    Trophy Points:
    53
    Location:
    Greece
    cPanel Access Level:
    DataCenter Provider
    We have switched most of our customers to Acronis Backup Cloud since the beginning of the year and are quite happy.
    As for the above solution @GOT suggested, I can confirm it's working on two CloudLinux 6 servers that were experiencing this issue. Haven't tried with it with CentOS/CloudLinux 7 though.
     
    #9 wintech2003, Jun 11, 2019 at 9:51 AM
(You must log in or sign up to post here.)
Loading...
Similar Threads - Unble Restore Database
  1. auxiliaryjoel

    Unble to Clone private Git repository

    auxiliaryjoel, Jan 27, 2019, in forum: General Discussion
    Replies:
    1
    Views:
    416
    cPanelLauren
    Jan 30, 2019
  2. jethrodesign

    Partial Backup/Restore - Exclude Email

    jethrodesign, Apr 8, 2019, in forum: Data Protection
    Replies:
    4
    Views:
    428
    jethrodesign
    Apr 12, 2019
  3. kenneth-vkd

    Restore account default folders?

    kenneth-vkd, Mar 29, 2019, in forum: General Discussion
    Replies:
    3
    Views:
    392
    cPanelMichael
    Mar 29, 2019
  4. grabyourhosting

    Version 80 - Restore backups from a remote destination via FTP transport in WHM

    grabyourhosting, Mar 24, 2019, in forum: Data Protection
    Replies:
    3
    Views:
    549
    cPanelMichael
    May 22, 2019
  5. Legin76

    Restore all DNS settings from backup

    Legin76, Mar 12, 2019, in forum: Bind/DNS/Nameserver
    Replies:
    1
    Views:
    283
    cPanelLauren
    Mar 13, 2019

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice