Question

Violation of PRIMARY KEY constraint 'PK_Storages'


Userlevel 4
Badge
  • Comes here often
  • 16 comments

We have six backup copy jobs that are failing with the following error;

Error: Violation of PRIMARY KEY constraint 'PK_Storages'. Cannot insert duplicate key in object 'dbo.Backup.Model.Storages'.

 

We have rescanned the repositories and reran the backup copy jobs, but still experiencing this error.

A case has been opened with Veeam support and we are anxiously awaiting their response.

Thanks

 

 


13 comments

Userlevel 7
Badge +14

Which Veeam version/build are you running?

Userlevel 7
Badge +21

Besides the Veeam version you are using check the logs here - C:\ProgramData\Veeam\FOLDER for more details on the job.

Also, I would suggest a quick search in the forums - http://forums.veeam.com

 

Userlevel 4
Badge

We are on Veeam version 12.0.01420 P20230718

 

The error is occurring with our backup copy jobs, which we utilize StoreOnce catalyst repositories.

Userlevel 7
Badge +10

Error Is related to Veeam DB. It seems a similar issue due After version upgrade. You can create a new DB with Veeamdb tool.

Wait support reply for correct solution but I think Is only possible.

Let us know how you solve.

 

Userlevel 4
Badge

Support has stated there is a known bug and will be working with us on a fix.  However, it appears we need to make sure our StoreOnce firmware is at 4.3.6.

Keep you in the know.

Userlevel 7
Badge +19

@Moose - When you get it resolved, let us know the details on what exactly is causing the issue and the resolution….of course, without sharing pertitinent work info. What I mean is, if it is the Veeam DB, are you using PostgreSQL or SQL? Is the issue due to the storage type you’re using? (StoreOnce) Or, is it a combination of the two? Or, something else? I just think it would be beneficial for others to know/be aware of who use similar infrastructure as you in case they run into the same issue.

Thanks!

Userlevel 4
Badge

Sure will, our SQL is on its own server, and we utilize HPe StoreOnce for the repositories.  We are still waiting for a support engineer to review and provide us with a fix.  While we are in a wait state, our storage architect is upgrading the firmware of a StoreOnce pair.

Userlevel 7
Badge +19

Great, thanks!

Userlevel 4
Badge

Veeam support is working out a fix in R&D and testing, hopefully it will be released soon.

Userlevel 7
Badge +19

Ah, ok..nice. Thanks for the update @Moose !

Userlevel 7
Badge +21

Veeam support is working out a fix in R&D and testing, hopefully it will be released soon.

Great to hear be sure to report back if it fixes the issue.

Userlevel 4
Badge

Veeam support responded last Friday with the following. 

It seems as though there was some kind of event that happened during the original synthetic full run which caused the problem which may have involved something environmental. The synthetic fulls have generally been successful previously.

Because the trigger seemed to be some temporary condition, and because the firmware on the storage has now been updated to 4.3.6, I wouldn't expect to see reoccurrence even prior to getting the updated hotfix.

The affected backup chains were still in a problem state in the database that is preventing the replication from succeeding, but only the target side catalyst is affected. Because of this, it would be possible to either create a new catalyst store or just select affected backups and "delete from disk" and allow a fresh replication of the files.  This has worked as a temporary fix.

Pete

Userlevel 7
Badge +21

Great to hear you finally got it fixed with the help of support.

Comment