-
- Novice
- Posts: 9
- Liked: 2 times
- Joined: Mar 18, 2020 1:06 pm
- Contact:
How long to wait on upgrade to V12?
My upgrade from V11a with latest patch to V12 latest (On a Windows 2012 R2 Server) has been on Step 1 for an hour. How long should I wait?
Can I kill the upgrade process and start over?
Last write to C:\ProgramData\Veeam\Setup\Temp\BackupSrvLog.log
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Column [Backup.Model.Backups.ArchiveInfo].[archive_index_id] has been successfully renamed to [legacy_per_vm_archive_index_id]
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Column [dbo].[Backup.Model.Backups.ArchiveInfo].id has been successfully dropped
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Database version has been incremented to <8727> (ContentType=[Schema])
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Database version has been incremented to <8728> (ContentType=[Schema])
This was almost an hour ago and nothing is moving.
Any recommendations?
Can I kill the upgrade process and start over?
Last write to C:\ProgramData\Veeam\Setup\Temp\BackupSrvLog.log
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Column [Backup.Model.Backups.ArchiveInfo].[archive_index_id] has been successfully renamed to [legacy_per_vm_archive_index_id]
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Column [dbo].[Backup.Model.Backups.ArchiveInfo].id has been successfully dropped
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Database version has been incremented to <8727> (ContentType=[Schema])
***Veeam*** SRV: [13.03.2023 14:09:15]:<00000004> [VEEAM] INFO [MSSQL] Database version has been incremented to <8728> (ContentType=[Schema])
This was almost an hour ago and nothing is moving.
Any recommendations?
-
- Novice
- Posts: 9
- Liked: 2 times
- Joined: Mar 18, 2020 1:06 pm
- Contact:
Re: How long to wait on upgrade to V12?
Found SQL Server stuck with error "Timeout occurred while waiting for latch: class 'METADATA_SEQUENCE_GENERATOR'"
Tried to Stop SQL Server with SQl Configuration Management console. No luck. It is hung. So I force killed the SQL Server Instance by killing the PID.
Veeam then complained that it could not finish install due to lost connection with SQL Server. "Fatal error during installation."
C:\ProgramData\Veeam\Setup\Temp\BackupSrvLog.log seems to show install rollback. However, since SQL was shutdown abnormally, not sure what will happen. Will reboot server and try again....
Tried to Stop SQL Server with SQl Configuration Management console. No luck. It is hung. So I force killed the SQL Server Instance by killing the PID.
Veeam then complained that it could not finish install due to lost connection with SQL Server. "Fatal error during installation."
C:\ProgramData\Veeam\Setup\Temp\BackupSrvLog.log seems to show install rollback. However, since SQL was shutdown abnormally, not sure what will happen. Will reboot server and try again....
-
- Novice
- Posts: 9
- Liked: 2 times
- Joined: Mar 18, 2020 1:06 pm
- Contact:
Re: How long to wait on upgrade to V12?
After reboot, Veeam12 Setup said I needed to remove previous installation. Uggh... Which meant removing all Veeam and starting from scratch.
I will need to import my config backup after install. However, new v12 install is installing PostgreSQL. I don't mind, but hopefully it will "just work"![Wink ;)](https://forums.veeam.com/images/smilies/icon_wink.gif)
I will need to import my config backup after install. However, new v12 install is installing PostgreSQL. I don't mind, but hopefully it will "just work"
![Wink ;)](https://forums.veeam.com/images/smilies/icon_wink.gif)
-
- Product Manager
- Posts: 9327
- Liked: 2475 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: How long to wait on upgrade to V12?
Hi Garth
You won‘t be able to import a v11 configuration backup to a V12 postgresql server. Only configuration backups created by v12 will work.
If a new try is not successfull, please provide a case number for this technical issue. We cannot fix technical issues over the forum.
Best,
Fabian
You won‘t be able to import a v11 configuration backup to a V12 postgresql server. Only configuration backups created by v12 will work.
If a new try is not successfull, please provide a case number for this technical issue. We cannot fix technical issues over the forum.
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Novice
- Posts: 9
- Liked: 2 times
- Joined: Mar 18, 2020 1:06 pm
- Contact:
Re: How long to wait on upgrade to V12?
Stickelbats.
Well, you are correct on that one Fabian. Pointed out right in the restore window when trying.
So, I am removing the V12 and will re-install V11, apply the config backup, and try a new V12 upgrade.
I'll post results....
Well, you are correct on that one Fabian. Pointed out right in the restore window when trying.
So, I am removing the V12 and will re-install V11, apply the config backup, and try a new V12 upgrade.
I'll post results....
-
- Novice
- Posts: 9
- Liked: 2 times
- Joined: Mar 18, 2020 1:06 pm
- Contact:
Re: How long to wait on upgrade to V12?
Results:
Removed all Veeam and reinstalled 11a with latest patch. New install created a new SQL instance (2016)
Restored config backup to get server back to where it was.
All backup jobs ran fine.
Started upgrade again.
All went fine this time. Upgrade took approx 20 minutes.
Happy camper![Smile :)](https://forums.veeam.com/images/smilies/icon_smile.gif)
Will look at migrating to PostgreSQL in a couple days.
Removed all Veeam and reinstalled 11a with latest patch. New install created a new SQL instance (2016)
Restored config backup to get server back to where it was.
All backup jobs ran fine.
Started upgrade again.
All went fine this time. Upgrade took approx 20 minutes.
Happy camper
![Smile :)](https://forums.veeam.com/images/smilies/icon_smile.gif)
Will look at migrating to PostgreSQL in a couple days.
-
- Service Provider
- Posts: 216
- Liked: 35 times
- Joined: Jun 10, 2019 12:19 pm
- Full Name: Daniel Johansson
- Contact:
V12 upgrade - MSSQL stuck on 'waiting for latch'
It might be interesting to know that I have the exact same problem - last message is "Database version has been incremented to <8728>", then nothing. And SQL Server has logged the same message about "Timeout occurred while waiting for latch: class 'METADATA_SEQUENCE_GENERATOR'". I had to do other stuff at the same time, so over three hours have passed without progress. Maybe others have the same issue as well? Could be worth investigating. I do not look forward to having to do a full reinstall just to be able to attempt the same upgrade again.
-
- Product Manager
- Posts: 9327
- Liked: 2475 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: How long to wait on upgrade to V12?
@garth1138
Thanks for the update
@DanielJ
Instead of doing a full reinstall, you can always open a support case (severity 1 if you must full fill SLA's).
We need your logs to investigate this behavior.
Please provide me with the case number so I can follow the case from my side.
Best,
Fabian
Thanks for the update
@DanielJ
Instead of doing a full reinstall, you can always open a support case (severity 1 if you must full fill SLA's).
We need your logs to investigate this behavior.
Please provide me with the case number so I can follow the case from my side.
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Service Provider
- Posts: 216
- Liked: 35 times
- Joined: Jun 10, 2019 12:19 pm
- Full Name: Daniel Johansson
- Contact:
Re: How long to wait on upgrade to V12?
Ticket with setup logs: 05944938
-
- Service Provider
- Posts: 60
- Liked: 3 times
- Joined: Nov 16, 2015 5:52 pm
- Full Name: Bill Boyer
- Contact:
Re: How long to wait on upgrade to V12?
I've always found rebooting the Veeam server(s) including SQL if a separate server BEFORE doing any Veeam upgrades helps. My one and only time an upgrade failed was due to a Windows issue that was solved just by rebooting. All my Veeam servers except for repository servers are VM's. So I shutdown and take a snapshot as my fall back point.
But this is Windows so...REBOOT! lol
Bill
But this is Windows so...REBOOT! lol
Bill
-
- Product Manager
- Posts: 9327
- Liked: 2475 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: How long to wait on upgrade to V12?
Hi Daniel
Our customer support found 3 similar cases and will check it out with our RnD Teams.
Best,
Fabian
Our customer support found 3 similar cases and will check it out with our RnD Teams.
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Novice
- Posts: 3
- Liked: never
- Joined: Jul 18, 2016 11:57 pm
- Full Name: Sam
- Contact:
Re: How long to wait on upgrade to V12?
Wished i'd browsed the forums yesterday prior to undertaking the V11 > V12 upgrade.
I also experienced the same issues as reported in this thread.
After failing the install, the V12 installer wanted all V12 Veeam B&R products uninstalled first. Going through uninstalling the failed V12 products and then running again worked using the existing databases.
Then took 2 hours to update the VALRedist.msi on the B&R server once opening the console.
All jobs are still there are still work.
I also experienced the same issues as reported in this thread.
After failing the install, the V12 installer wanted all V12 Veeam B&R products uninstalled first. Going through uninstalling the failed V12 products and then running again worked using the existing databases.
Then took 2 hours to update the VALRedist.msi on the B&R server once opening the console.
All jobs are still there are still work.
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Mar 29, 2023 6:18 pm
- Contact:
Re: How long to wait on upgrade to V12?
I had a similar experience recently. My installation took around 16 hours to complete (I left it running overnight), but I eventually aborted the process. I uninstalled everything and then installed V12 along with a new MS SQL database. Currently, I'm attempting to restore the configuration from backup. As of now, the process is stuck at "Upgrading database (78% done)", after 15 minutes have passed. SQL seems to be utilizing approximately 26% of the processor time, while other metrics, such as Database I/O, are at 0%. I plan to leave it running overnight and check the progress tomorrow, although I don't have much hope for success. Since I'm using the Community Edition and have only five VMs, I'm considering rebuilding everything from scratch if necessary.
-
- Product Manager
- Posts: 9327
- Liked: 2475 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: How long to wait on upgrade to V12?
Hello
Our support team found a possible bug in MSSQL server 2012 (may be not limited to server 2012) that was affecting our installation process. The suggestion was to upgrade the MSSQL server used for the configuration database to the latest SP version or one of the newer MSSQL servers like 2019 and then try again.
If you have a case open, please ask you support engineer to check your case against the case from Daniel:
post480508.html#p480508
Best,
Fabian
Our support team found a possible bug in MSSQL server 2012 (may be not limited to server 2012) that was affecting our installation process. The suggestion was to upgrade the MSSQL server used for the configuration database to the latest SP version or one of the newer MSSQL servers like 2019 and then try again.
If you have a case open, please ask you support engineer to check your case against the case from Daniel:
post480508.html#p480508
Best,
Fabian
Product Management Analyst @ Veeam Software
-
- Enthusiast
- Posts: 35
- Liked: 4 times
- Joined: May 11, 2011 1:37 pm
- Contact:
Re: How long to wait on upgrade to V12?
BUMP so maybe more people will be aware that this still happens.
Looks like we ran into this one as well. Buried down in the thread list so I didn't see it before the upgrade.
Opened case 06032317 to see if there's an easy way out of this. Don't really want to be in a restore situation.
Looks like we ran into this one as well. Buried down in the thread list so I didn't see it before the upgrade.
Opened case 06032317 to see if there's an easy way out of this. Don't really want to be in a restore situation.
-
- Service Provider
- Posts: 326
- Liked: 23 times
- Joined: Oct 09, 2012 2:30 pm
- Full Name: Maso
- Contact:
Re: How long to wait on upgrade to V12?
Had the same problem. After upgrading sql server from 2012 to 2019 it went fine.
-
- Influencer
- Posts: 19
- Liked: 2 times
- Joined: Jan 07, 2020 6:06 pm
- Full Name: Mark Vigil
- Contact:
Re: How long to wait on upgrade to V12?
Hi,
Sorry to bump an old thread but I just had the same issue and it was disastrous. I had to uninstall everything, install SQL2016 express, install BR12, then import my config backup and revalidate all of my credentials to all of my VMS/repositories.
I need to upgrade 6 other Veeam backup servers. Since someone mentioned it is a bug related to SQL2012, would stopping all Veeam services, upgrading the SQL instance Veeam uses to 2016, starting the Veeam services, then running the upgrade work?
Thanks!
Sorry to bump an old thread but I just had the same issue and it was disastrous. I had to uninstall everything, install SQL2016 express, install BR12, then import my config backup and revalidate all of my credentials to all of my VMS/repositories.
I need to upgrade 6 other Veeam backup servers. Since someone mentioned it is a bug related to SQL2012, would stopping all Veeam services, upgrading the SQL instance Veeam uses to 2016, starting the Veeam services, then running the upgrade work?
Thanks!
-
- Lurker
- Posts: 1
- Liked: never
- Joined: Nov 26, 2023 3:29 pm
- Contact:
Re: How long to wait on upgrade to V12?
I'm trying to do the same. I'm back on v11 with clean backups. The enterprise manager wont re-install saying my existing DB is marked with a newer version than that which is installed. Changing the version then using the DB gave me missing patch errors.garth1138 wrote: ↑Mar 14, 2023 5:42 pm Results:
Removed all Veeam and reinstalled 11a with latest patch. New install created a new SQL instance (2016)
Restored config backup to get server back to where it was.
All backup jobs ran fine.
Started upgrade again.
All went fine this time. Upgrade took approx 20 minutes.
Happy camper
Will look at migrating to PostgreSQL in a couple days.
-
- Product Manager
- Posts: 9327
- Liked: 2475 times
- Joined: May 13, 2017 4:51 pm
- Full Name: Fabian K.
- Location: Switzerland
- Contact:
Re: How long to wait on upgrade to V12?
We don't support a downgrade. You can keep Enterprise manager on V12 to manage a VBR v11a server.I'm trying to do the same. I'm back on v11 with clean backups. The enterprise manager wont re-install saying my existing DB is marked with a newer version than that which is installed. Changing the version then using the DB gave me missing patch errors.
Best,
Fabian
Product Management Analyst @ Veeam Software
Who is online
Users browsing this forum: Bing [Bot], Google [Bot] and 25 guests