Backup restore failed: INTERNAL 5445: VIAssert(oidMap.count(depOid)) failed

GayleE20

I am trying to restore a schema to a new vertica installation, and keep getting this error:

Error: SQL command "select load_snapshot();" failed: INTERNAL 5445: VIAssert(oidMap.count(depOid)) failed
DETAIL: /scratch_a/release/svrtar14969/vbuild/vertica/Catalog/CatalogQueries.cpp: 5046
HINT: Please report this error to Vertica; try restating your query
Restore FAILED.

We have a number of schemas stored in separate backup objects, and all the other schemas restored fine. What does this mean, and what can I do about it?

The backup was made of vertica 7.2.3, and the new vertica is also 7.2.3 (and will be upgraded once the data is all restored).

Jim_Knicely

Hi,

Which hot fix are you running? Vertica release 7.2.3-17 included the following fix:

VER-52714 - "Object replication and restore sometimes failed if the target database had storage locations, UDTs or storage policies with the same object IDs as the source database objects."

See:
https://www.vertica.com/docs/ReleaseNotes/7.2.x/Vertica_7.2.x_Release_Notes.htm