Skip to main content

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.

Filter by
Sorted by
Tagged with
0 votes
1 answer
37 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 ...
Misudka's user avatar
  • 35
1 vote
0 answers
93 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 ...
Alessandro Cattaneo's user avatar
0 votes
1 answer
224 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 ...
madeinindia's user avatar
0 votes
1 answer
240 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....
s.k's user avatar
  • 372
0 votes
1 answer
23 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 ...
Frange0's user avatar
0 votes
0 answers
42 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 ...
msbeast's user avatar
  • 21
1 vote
0 answers
90 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 ...
Amer's user avatar
  • 111
0 votes
1 answer
49 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....
Marco's user avatar
  • 3,710
0 votes
1 answer
126 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 ...
user23324007's user avatar
0 votes
0 answers
17 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/...
IGGt's user avatar
  • 2,156
1 vote
1 answer
156 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 ...
Curtis Spencer's user avatar
0 votes
1 answer
17 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)? ...
vrms's user avatar
  • 195
1 vote
1 answer
589 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. ...
P5_'s user avatar
  • 27
0 votes
1 answer
140 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 ...
rajasaur's user avatar
  • 111
1 vote
2 answers
103 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 ...
azzid's user avatar
  • 113
0 votes
0 answers
37 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 ...
user avatar
1 vote
0 answers
50 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....
Kishore's user avatar
  • 11
0 votes
1 answer
323 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 ...
DBA Greg14's user avatar
1 vote
2 answers
197 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 ...
Abhijith Ea's user avatar
0 votes
0 answers
226 views

Mongo Upgrade 4.4 to 5

I am trying to upgrade mongodb standalone ver 4.4.22 to 5. I have stopped the services, made the /etc/yum.repos.d/mongodb-org-5.0.repo directory, installed the yum packages with sudo yum install -y ...
datascinalyst's user avatar
0 votes
1 answer
141 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 ...
Isaac Sutherland's user avatar
0 votes
0 answers
18 views

Running DMA twice from server A to server B

is it possible to run DMA twice on the same destination server from the same source server in SQL server during migration to keep Target Server up to date with Source server ? 2nd DMA run will be done ...
IHANY ARIOLE's user avatar
2 votes
1 answer
192 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 ...
user946207's user avatar
0 votes
0 answers
338 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....
Brad's user avatar
  • 191
0 votes
0 answers
19 views

Dropping database stored with upper cases without downtime

my problem is the following. We are running a MySql server on AWS RDS and are about to upgrade from MySql 5.7 to 8.0.34. When testing this on a restored snapshot I discovered that there is a "...
northmoose's user avatar
3 votes
1 answer
1k 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@...
user avatar
1 vote
1 answer
775 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 ...
tinlyx's user avatar
  • 3,620
1 vote
2 answers
257 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 ...
Ganesh Neupane's user avatar
0 votes
0 answers
49 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 ...
mk SQL's user avatar
  • 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 ...
Dmitri Pavlov's user avatar
0 votes
1 answer
182 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 ...
Caleb's user avatar
  • 1
0 votes
0 answers
212 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 ...
Mikko Rantalainen's user avatar
0 votes
0 answers
41 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 ...
AppLEaDaY's user avatar
0 votes
1 answer
422 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) ---> ...
Astora's user avatar
  • 791
0 votes
1 answer
187 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, ...
user avatar
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] ...
Markus's user avatar
  • 11
2 votes
1 answer
790 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 ...
franklwambo19's user avatar
2 votes
1 answer
801 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 ...
Moduspwnens's user avatar
0 votes
1 answer
117 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: ...
dba_db2_dse's user avatar
-1 votes
1 answer
425 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 > ...
Michael's user avatar
  • 153
1 vote
1 answer
59 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 ...
Roberto Iglesias's user avatar
0 votes
2 answers
131 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 & ...
OJFord's user avatar
  • 125
0 votes
1 answer
215 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 ...
InteXX's user avatar
  • 559
0 votes
1 answer
46 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 ...
Sai's user avatar
  • 37
0 votes
0 answers
283 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 ...
Senior Systems Engineer's user avatar
0 votes
0 answers
878 views

Upgrading to developer edition from SQL Server 2022 Evaluation edition

I ran an inplace upgrade of a SQL Server 2019 Developer to SQL Server 2022 Evaluation on our dev environment in June. The evaluation period now has expired, so I tried to run an edition upgrade via ...
Camilla Gaardsted's user avatar
0 votes
1 answer
203 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 ...
zhang ming's user avatar
-1 votes
2 answers
287 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 ...
datenheim's user avatar
  • 123
2 votes
1 answer
243 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 ...
datenheim's user avatar
  • 123
0 votes
1 answer
287 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, ...
NReilingh's user avatar
  • 785

1
2 3 4 5
11