Skip to main content

Bandwidth SQLite errors moving from cPanel to cPanel

Comments

8 comments

  • hayridumanli
    Did you find a solution about this. I made WHM to WHM transfer "cPanel & WHM 64.0 (build 29)" from a VDS to other, it gave these errors. Then I made the transfer from the VDS to a dedicated server after a couple of months, it gave almost the same errors again;
    RESTORE: Account "diveandwalk": Warnings The system failed to import data from the RRDTool files into the user"s bandwidth database because of an error: (XID zcpb6m) The system received an error from the "SQLite" database "/var/cpanel/bandwidth/diveandwalk.sqlite": SQLITE_CONSTRAINT (UNIQUE constraint failed: metadata.key) RESTORE: Account "metintopa": Warnings The system failed to import data from the RRDTool files into the user"s bandwidth database because of an error: (XID z3xxra) The system received an error from the "SQLite" database "/var/cpanel/bandwidth/metintopa.sqlite": SQLITE_CONSTRAINT (UNIQUE constraint failed: metadata.key) RESTORE: Account "fahirozer": Warnings The system failed to import data from the RRDTool files into the user"s bandwidth database because of an error: (XID 8bc5yg) The system received an error from the "SQLite" database "/var/cpanel/bandwidth/fahirozer.sqlite": SQLITE_CONSTRAINT (UNIQUE constraint failed: metadata.key) RESTORE: Account "rumelcng": Warnings The system failed to import data from the RRDTool files into the user"s bandwidth database because of an error: (XID arf65e) The system received an error from the "SQLite" database "/var/cpanel/bandwidth/rumelcng.sqlite": SQLITE_CONSTRAINT (UNIQUE constraint failed: metadata.key)
    Is there a solution for this?
    0
  • cPanelMichael
    Hello, Those warning messages should not prevent the transfer from completing. It's a warning that indicates the transfer tool was unable to import the previous RRDTool bandwidth data into the user"s new bandwidth database. This can happen if the source server uses a different architecture (e.g. 32-bit) or if the SQLite files on the source server are corrupt. This will not prevent the calculation of new bandwidth data on the destination server. Thank you.
    0
  • hayridumanli
    Thank you for your reply. 1) Is there a way to repair these SQLite files? 2) Or is there a way to delete all old bandwidth datas for corrupted accounts, so the bandwidth database starts from the zero
    0
  • cPanelMichael
    Hello, You should not have to take any additional actions once the accounts are transferred. The warning message shouldn't prevent the transfer of the account from completing, and a new bandwidth file should automatically generate for the new account on the destination server. Thank you.
    0
  • hayridumanli
    All the accounts are already transferred. And all of them (websites, mail accounts, etc.) are working without any problem as you said. But as I said before, those errors happened twice, from first VDS to second VDS, then from second VDS to a dedicated server. I had noted at the end of first transfer to write this forum, but I had to make second transfer in a short time, same accounts gave same errors. So, it means that a new bandwidth file hasn't been generated automatically. Maybe it's not a big deal as you try to say, but small errors can cause bigger ones in the future, so I wanted to learn about it.
    0
  • cPanelMichael
    Hello, Could you open a support ticket using the link in my signature so we can take a closer look and see what's possibly corrupting the SQLite bandwidth files? Thank you.
    0
  • hayridumanli
    I opened a support ticket; Your Support Request ID is: 8694497
    0

Please sign in to leave a comment.