Restoring objects: XXX_PXXX.TABLE1
Approximate bytes to copy: 0.
Dry run finished. Run vbr without --dry-run to complete the task.
While preprocessing catalog: vertica-extract-snapshot failed:Table XXX_PAXX..TABLE2 references XXX_PXXX.TABLE1 in a SET USING or DEFAULT expression, but is not included in the snapshot. HINT: Back up the tables together, or alter table removing SET USING/DEFAULT on attributes
Vbr.py restore error
+2
+2This error suggests that there's a dependency between two tables:
XXX_PAXX..TABLE2 (which is trying to be restored)
XXX_PXXX.TABLE1 (which is referenced by TABLE2)
The problem is that TABLE2 has a column that uses a SET USING or DEFAULT expression that references TABLE1, but TABLE1 is not included in the backup snapshot you're trying to restore.
To resolve this issue, you have two main options:
1. Backup and restore the tables together: Ensure that both TABLE1 and TABLE2 are included in the same backup and restore operation.
2. Alter the table to remove the dependency: If it's appropriate for your use case, you could modify TABLE2 to remove the SET USING or DEFAULT expression that references TABLE1.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
