Search found 2 matches
- Sun Jul 31, 2016 7:39 am
- Forum: Vertica Backup & Recovery
- Topic: Vertica Restore error : ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
- Replies: 0
- Views: 17113
Vertica Restore error : ERROR 4757: SnapshotMemento does not match. Oid conflicts are possible
Hi All, I've tried to backup a schema using vbr.py command , first created the setup conf file then backup successfully and dropped the tables and schema but when trying to do restore on the same machine , vertica version ..etc ,I have got this error ERROR 4757 : SnapshotMemento does not match. Oid ...
- Sun Jun 19, 2016 10:58 am
- Forum: Vertica SQL
- Topic: projection_usage table not all tables got query_start_timestamp
- Replies: 2
- Views: 18509
projection_usage table not all tables got query_start_timestamp
I've been trying to develop a report , got each table name and last query date using below query SELECT anchor_table_id, max( query_start_timestamp ) as last_access FROM v_monitor.projection_usage group by 1 and I've noticed that not all tables got an entry in this table although i've performed a qu...