Skip to main content

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

  • October 3, 2018
  • 1 reply
  • 5 views

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).

1 reply

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • October 3, 2018

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