Questions tagged [upgrade]
Upgrade refers to the replacement of a product with a newer version of the same product. - replace (a software program) with a more recently released, enhanced version. - replace (a hardware device) with one that provides better performance.
517 questions
0
votes
2
answers
41
views
AWS Postgres upgrade reports an error in database that pgmaster can't connect to or see
I have a Postgres 13 instance in AWS I'm trying to upgrade to 16. I have some polymorphism errors that I have to fix, but AWS is reporting that one of the offending objects lives in a database called &...
- 349
1
vote
1
answer
62
views
Running different Cassandra version (3.XX and 4.XX) in "virtual" DC
We currently have few Cassandra clusters and largest one we have has 81 nodes and more that 1petabyte of data. They are in one datacenter, and distributed into 3 different racks The current version ...
- 13
0
votes
0
answers
36
views
MySQL Clone failing after upgrade to 8.4.6. Clone Donor plugin INNODB_TABLESPACES_ENCRYPTION is not active in Recipient
I’ve just upgraded my Percona Server 8.0.17 to 8.4.6, and now my clone routine is failing.
ERROR 3870 (HY000): Clone Donor plugin INNODB_TABLESPACES_ENCRYPTION is not active in Recipient.
I’ve ...
0
votes
1
answer
87
views
SQL Version Upgrade 2017 to 2019 in an unclustered read-scale availability group
We need to upgrade our production SQL servers from SQL 2017 to 2019 (both are Ent. Edition) in the near future. We have ~70 servers hosted in our DC. Each SQL Server instance consists of 2 VMs in a 2 ...
1
vote
1
answer
188
views
Rollback plan after upgrade from SQL Server 2016 Standard edition to SQL Server 2022 Enterprise edition
I'm planning to upgrade our SQL Server from 2016 Standard edition to 2022 Enterprise edition.
To prepare for potential issues, I want to have a rollback strategy in place. If, after the upgrade, our ...
5
votes
0
answers
396
views
Postgres: Queries are too slow after upgrading to PG17 from PG15
Most of the queries got slower after upgrading our postgres from version 15 to 17 using pg_upgrade. I reconfirmed that "vaccuum, analyze" were all taken care.
To debug, instead of upgrade, I ...
- 322
2
votes
1
answer
121
views
"Duplicate entry" error when upgrading MariaDB 10.6 to 11.4
I was trying to upgrade my local development environment (Ubuntu 22.04 WSL) from MariaDB 10.6 to 11.4.
After updating the APT repo file, I run and apt update, which updated the server version.
However,...
- 187
2
votes
1
answer
1k
views
Always on SQL Server upgrade / migration
We currently have a 3 node SQL Server Cluster with 1 node acting as the Primary, and the other 2 are Secondaries. These are configured in an Availability group. These are Windows 2019 servers running ...
- 61
0
votes
0
answers
163
views
Problem upgrade MariaDB 10.11.11 to 11.4.4 on Windows. Service not start
I have MariaDB on Windows server installed and it works fine. I want to upgrade MariaDB 10.11.11 to 11.4.4.
I do the upgrade like this:
I stop the mysql service
I rename the current mysql folder to ...
- 1
0
votes
1
answer
86
views
Automating upgrades with Ansible, fighting with APT auto-starting Cassandra service
I'm preparing to upgrade nodes from 3.11.17 to 4.1.7. I've done the upgrade successfully by hand with some dev nodes, but I am wanting to make this more repeatable with Ansible. I am running on Ubuntu ...
- 43
1
vote
1
answer
91
views
Is it possible to find \ create setup files for SQL Server 2022 with CU, not RTM?
Is it possible to find \ create setup files for SQL Server 2022 with CU, not RTM?
Reason:
Can't upgrade SQL Server from 2019 to 2022 in cluster with AG and CDC due this one bug:
Fixes an issue in ...
- 13
0
votes
1
answer
85
views
Is it possible to give readonly access to a database during an upgrade
I am upgrading a sql server environment which has an application server, web server and a database server and I want to be be able to give my users readonly access to their data during the upgrade. ...
0
votes
1
answer
303
views
SQL Server instance upgrade impacting on other instance maintenance plan jobs
I have two instances on a single server. Instances are named TEST and LIVE for simplicity. Both are running SQL Server 2019. Only the LIVE instance has SQL Agent jobs running (Basic backup jobs via ...
- 101
0
votes
1
answer
157
views
Ola Hallengren Maintenance Solution Upgrade
I’m relatively new to SQL Server and my company is currently using an older version (2014) of the Ola Hallengren Maintenance Solution. We’re looking to upgrade to a version that supports SQL Server ...
1
vote
2
answers
13k
views
How to upgrade MySQL from 8.0 to 8.4?
I'm on Windows. I installed MySQL 8.4, stopped all services and copied the Data folder and my.ini files into the 8.4 folder but now the 8.4 services does not start and does not produce any logs. I can'...
John John