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.
510 questions
0
votes
1
answer
39
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
52
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
37
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 ...
0
votes
2
answers
2k
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
0
votes
1
answer
66
views
After upgrade Postgres python is the same version
I upgraded my postgres from 13.5 to 16.2 version (and the RHEL from 7.5 to 8.9).
The problem is, python was not upgraded.
I created procedure pyver():
CREATE OR REPLACE FUNCTION pyver ()
RETURNS TEXT
...
- 45
1
vote
0
answers
171
views
MySQL 8.0 fails to store 5.7-allowed symbols (Incorrect string value, Error 1366) [closed]
I'm upgrading MySQL 5.7 server to 8.0 with a bunch of user-input data that sometimes contain "malformed" unicode characters like x'eda0bdedb98f'. The latter seems to be 2 UTF-16 characters ...
0
votes
1
answer
647
views
Mariadb upgrade from 10.3 to 10.11
Is it possible to upgrade from Maria 10.3 to 10.11. What are the necessary steps or any script that can be followed? Also I’m planning to upgrade my os from rhel7 to 8, what additional steps should I ...
0
votes
1
answer
579
views
pg_upgrade fails on pg_restore: error: connection to server at "localhost" port 5433 failed: FATAL: password authentication failed for user "postgres"
I have a PostgreSQL 13 installation on a Windows 10 server (on port 5432) that I want to migrate to a new PG 16.2 installation.
To this end, I downloaded the Windows x86-64 installer for PostgreSQL 16....
- 384
0
votes
1
answer
56
views
Postgres server migration and version upgrade
We are migrating a 2TB server with a very large amount of BLOBs from an on-premises server to a cloud server. During the migration, we'd also like to update the Postgres version from 14 to 16.
Now due ...
- 1
0
votes
0
answers
80
views
Query performance degrade after upgrade from MySQLv5.6 to v5.7
I upgraded the MySQL Server from v5.6 to v5.7 and since then I see query performance degrade. For example, I have the following select query that selects some columns and has a single column in the ...
- 21
1
vote
0
answers
188
views
AWS RDS MySQL "manual" read replica in "Waiting for dependent transaction to commit" state but lag is zero
I have an SOP I use to upgrade AWS RDS instances running MySQL with no downtime that I have been following since 2021. I'll outline my method below, but it involves manually hooking up a new master ...
- 111
0
votes
1
answer
78
views
Can I choose which PostgreSQL version is used by barman?
I installed barman on the same server as my production database. Perhaps not a good choice but it is that way. I use barman to make backups of the production database and of databases on other servers....
- 3,720
0
votes
1
answer
148
views
Upgrading MySQL from 5.7 to 8.0
I need to upgrade one of my servers, running mysql 5.7. The DB and the OS is on different drives on my machine.
Can I drop the DB's from my 5.7 installation, reinstall the server with new OS and ...
0
votes
0
answers
44
views
MySQL Upgrade on Windows and now SSL_CTX_set_default_verify_paths failed error
I am in the process of upgrading my databases from MySQL 5.7 to MySQL 8.0.
One of them is running on windows. Replication was previously set up as:
change master to
. . .
master_ssl_ca="c:/mysql/...
- 2,166
1
vote
1
answer
302
views
Fatal error 1408 when installing mariadb-server / mariadb-upgrade
I recently upgraded my Debian 10 server running MySQL 5.7 to Debian 11 and MariaDB 10.3. That upgrade went smoothly. I then decided to upgrade to Debian 12 and MariaDB 10.11. While performing that ...
0
votes
1
answer
19
views
postgis uprade route
I need to upgrade
source: rhel7-pg-10-postgis-2.4
target: rhel8-pg-14-postgis-3.1
is my assupmtion correct, that I need to go in these steps (using pg_dump/pg_restore to jump between versions)?
...
- 215
1
vote
1
answer
785
views
Gameplan for Upgrading SQL Server fr 2014 to 2017 & 2022
First I would like to say sorry if my knowledge within the DBA realm is very limited since I and several other team members were just given this project because we are significantly resource-limited.
...
- 27
0
votes
1
answer
189
views
Mariadb not using indexes post upgrade to 10.5.23 from 10.2
We upgraded our MariaDB server from 10.2 to 10.5.23 and have found a significant CPU spike after this and almost most of the queries landing in the slow query logs. On investigation, we found that ...
- 111
1
vote
2
answers
140
views
Safe upgrade routine for Cassandra
I've been tasked with upgrading an Ubuntu based Cassandra cluster - having no prior experience with Cassandra.
I've tried digging through the docs but have been unable to find any instructions on how ...
- 113
0
votes
0
answers
54
views
mongodb sharded cluster upgrade to 4.4
we had a mongodb sharded cluster of version 3.6. we updated this cluster to 4.0 and 4.2 respectively. then we upgrade the cluster to 4.4 based on the docs.
the problem is when we are doing the last ...
Ali
1
vote
0
answers
65
views
Performance degradation after upgrading to MySQL 8
We have upgraded MySQL in our application from version 5.7.43 to version 8.0.35.
We are getting below exception while trying the fetch the records from the database.
231104 04:04:03 : com.mysql.jdbc....
- 11
0
votes
1
answer
465
views
best practice for side by side sql version upgrade with Availability groups
We are attempting our first ever side by side upgrade of a 2 node(multi-subnet, enterprise edition) AG from sql 2016 to 2019. I have some questions on how best to approach this:
Do we create a brand ...
- 255
1
vote
2
answers
248
views
How to Identify Tables with Index Size Issues during MySQL 5.7 to 8.0 Migration?
I'm trying to migrate from MySQL 5.7 to MySQL 8.0 for my application's database. However, the precheck failed with an incompatibility error "25," stating that tables with redundant row ...
- 113
0
votes
1
answer
168
views
mysql hot backup with upgrade support
I perform a hot backup of a production mysql database using an LVM snapshot, and then I attempt to restore said backup on a development machine. However, the dev mysql database will not start, and ...
- 123
2
votes
1
answer
220
views
MariaDB 11.0 to 11.1 GA fails with ERROR 1210 (HY000) at line 32: Incorrect arguments to DATA DIRECTORY
I upgraded to MariaDB 11 some time ago, and all has been working well for a long time. I saw there was a newer GA release, 11.1, so decided to update to that, but the upgrade fails. This is on Windows ...
- 41
0
votes
0
answers
473
views
Upgrade warning when starting MariaDB
When I start up my Mariadb instance I see the following with systemctl:
$systemctl status mariadb
● mariadb.service - MariaDB 10.3 database server
Loaded: loaded (/etc/systemd/system/mariadb....
- 191
3
votes
1
answer
2k
views
mysqld constantly shutdown when trying to upgrade from '80033' to '80034'
I left my ghost website running for a week on an ubuntu22.04 droplet on digitalocean and came back seeing mysql.service always in the status of "Server upgrade in progress".
root@...
GeefrytheBo
1
vote
1
answer
1k
views
How can I cleanly recreate the main postgresql cluster?
I am using the beta versions of PostgreSQL 16 under Ubuntu (22.04). An issue is that every time (three times so far) a new beta is released, the existing database/cluster has to be upgraded due to ...
- 3,692
1
vote
2
answers
392
views
Cassandra Upgrade 2.1 to 3.11
I have a multi(two) DC Apache cassandra cluster with active replication. DC1 is primary(production) and DC2 is DR.
I plan to upgrade from 2.1 to 3.11. What is the best way to achieve the upgrade ...
0
votes
0
answers
52
views
SSRS 2016 compatibility with SQL 2017 after SQL2016 upgrade
We have an SQL Server database engine on the 2016 version. We also have SSRS in the 2016 version. I plan to upgrade the SQL database engine from the 2016 version to the 2017 for it to participate in ...
- 5
6
votes
3
answers
1k
views
Is it OK to have nodes with mixed major versions running for months?
We are planning to upgrade to Cassandra 4 (currently on 3.x).
The question is -> Is it ok for Cassandra cluster to run for extended periods (months) in a mixed mode. Like some datacenters Cassandra ...
1
vote
1
answer
273
views
Upgrade Postgres version with a lot of BLOBs
We are in the process of trying to upgrade our DB from Postgres 9.5 to 14 and decided to use the postgres utility pg_upgrade --link. This was left to run for over a day and we had to abort the process ...
- 11
0
votes
0
answers
259
views
How to temporarily switch PostgreSQL to logical replication to allow major version upgrade without downtime?
We have a PostgreSQL cluster running on one master (db1) and two async hot-standby servers (db2 and db3) replicating from it. All the servers are working as a backend for a web service and all the ...
0
votes
0
answers
47
views
/var/lib/mysql grows indefinitely in size
Having the need to upgrade from Ubuntu Bionic to Ubuntu Focal, I made an upgrade from server 5.7 - deduced afterward - to 8.0 by simply inheriting the original /var/lib/mysql directory, that is I left ...
0
votes
1
answer
574
views
Rolling Upgrade (with logical standby) from 11g and 19c question
Let's say we have the following upgrade map:
server1 (11g production db) ---> server2 (11g logical standby db)
then we upgrade the 11g logical standby db to 19c
server1 (11g production db) ---> ...
- 801
0
votes
1
answer
269
views
Upgrade Pgbouncer
I need some advice for upgrading pgbouncer. I couldn't find any document which tells me how to upgrade pgbouncer. I tried the command
apt install pgbouncer
I wonder if there is another good, ...
user274715
1
vote
1
answer
1k
views
MariaDB 11 fails to start: [ERROR] [FATAL] InnoDB: Unable to find charset-collation for 15
after performing an upgrade from MariaDB 10.11 to 11.0.1 on AlmaLinux 9.1 MariaDB fails to start when I set my datadir to the location of our old MariaDB 10.11 databases:
2023-04-13 12:37:55 0 [Note] ...
- 11
2
votes
1
answer
958
views
SQL server wont start automatically after OS upgrade
I did an in place upgrade for host OS from Windows server 2012 R2 to windows server 2022. After this move, I noticed the SQL server 2017 enterprise edition instance therein does not start ...
2
votes
1
answer
991
views
MariaDB upgrade requires table rebuild. Rebuild takes too long. Options?
I've got a MariaDB instance (10.6.8) hosted on Amazon RDS (db.m6g.4xlarge). It had automatic minor upgrades enabled, which unfortunately caused hours of downtime last time it triggered.
In reviewing ...
- 123
0
votes
1
answer
136
views
How do I upgrade a DataStax Enterprise cluster to 6.8.25 with OpsCenter Lifecycle Manager?
What are the steps (or all the commands) to upgrade (just the 6.8.25 fix, I have 6.18.16 version now) all nodes in cluster with LifeCycle Manager?
I've found this but it refers to 6.5 version of DSE:
...
- 21
-1
votes
1
answer
492
views
Use pgdump sql file to upgrade version?
Can I use a pgdump .sql file generated by one version as a way to upgrade to another version?
For example:
If I created a backup on PostgreSQL 14 with:
pg_dump --no-privileges --no-owner $DB_NAME > ...
- 163
1
vote
1
answer
63
views
Is londiste compatible with postgres 12.1?
I have two PostgreSQL databases both running version 9.1.24 (no logical replication available). DB-A delivers changes to DB-B using londiste (skytools 3). I have almost zero knowledge of pgq/pgqd and ...
0
votes
2
answers
181
views
Conditionally execute DDL, short-circuiting syntax error
I'm trying to execute a different create or replace function signature according to version() - since anyarray & anyelement are removed in postgres 14 and replaced by anycompatiblearray & ...
- 125
0
votes
1
answer
295
views
How to update ALL folder locations after server upgrade?
I recently upgraded my server from SQL 2019 to SQL 2022 (first time ever in-place upgrade, after all these years). I'm somewhat disappointed, however, to find that the server is still pointing to the ...
- 559
0
votes
1
answer
53
views
How do I upgrade Cassandra on GKE?
Is there any specific documentation on the GKE Cassandra upgrade process? Especially when we update the image on yaml file, what would be the post upgrade steps? Normally, when the upgrade happens on ...
- 39
0
votes
0
answers
312
views
Inplace upgrade SQL Server 2008R2 to 2019 while retaining IP and computername using Start-DbaMigration?
I am running existing legacy applications in production using an older version of SQL Server 2008 R2 Standard Edition, my goal here is to perform an inline/in-place upgrade to SQL Server 2019 Standard ...
0
votes
1
answer
231
views
Configuration files not generated in /etc/cassandra after upgrading to Cassandra 4.0.5
Cassandra 3.11.16 upgrade to 4.0.5,all seems good,but under /etc/cassandra,nothing generated by cassandra installer except triggers folder
When I installed c* 4.0.5 directly on a brand new machine,it ...
-1
votes
2
answers
301
views
Is there a short script to safely perform a major-release upgrade on a postgreSQL docker container?
The question specifically focuses on the assumed required upgrade of the data structures when stepping up to the next or even latest major release.
I know it usually involves dumping the data before ...
- 123
2
votes
1
answer
250
views
Is there a short and proven linux shell command or script to safely perform a major-release upgrade on a mariadb docker container?
The question is basically in the title already. At first I thought about a one-liner but maybe a short script is fine as well.
The command or script is meant to initiate all updating on the actual ...
- 123
0
votes
1
answer
366
views
How can I create a sql dump from postgres that I can restore on a new server with no psql options?
I want to have an easy, repeatable process of upgrading a dockerized postgres database to a new version. Minor and patch versions are easy -- the container can simply be upgraded to the new version, ...
- 785