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
0 answers
14 views

postgres 11->15 upgrade issue with pg_ts_dict and pg_ts_parser [closed]

I'm trying to upgrade v11 to v15 and running into the following issue public4u8p1dnq05qcq3nwoyudmjfqxxuheiny.pg_ts_dict.dict_init public4u8p1dnq05qcq3nwoyudmjfqxxuheiny.pg_ts_dict.dict_lexize ...
Mike's user avatar
  • 175
0 votes
1 answer
26 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,700
0 votes
1 answer
50 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
7 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,106
1 vote
1 answer
79 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
14 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
  • 175
1 vote
1 answer
194 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
94 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
75 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
22 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
25 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
111 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
127 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
170 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
84 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
16 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
133 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
140 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
16 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
831 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
0 votes
1 answer
319 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,500
1 vote
2 answers
149 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
46 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
94 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
158 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
36 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
240 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
  • 703
0 votes
0 answers
110 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
0 votes
0 answers
62 views

MariaDB galera cluster wsrep GTID numbering after update from 10.5.16 to higher versions

I had a fully functional MariaDB 10.5.16 with a Galera cluster (26.4.11). There were 3 nodes, and the GTID was set up and functioning properly, with each server having identical settings, including ...
Peter's user avatar
  • 1
1 vote
1 answer
978 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
560 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
545 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
86 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
256 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
54 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
106 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
  • 115
0 votes
1 answer
131 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
44 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
  • 35
0 votes
0 answers
244 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
695 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
178 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
267 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
228 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
229 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
  • 765
0 votes
1 answer
198 views

migrating databases from postgres-11-PostGIS-2.5 > postgres-12-PostGIS-3.2.2

In my current example I have to migrate ~90 databases between 2 Servers ... source: debian11, postgres-11, postGIS 2.5 target: rhel8, postgres-12, postGIS 3.2.2 on PostGIS upgrades i read in the ...
vrms's user avatar
  • 175
1 vote
2 answers
2k views

In-Place upgrade from SQL Sever 2014 to 2017 finds nothing to upgrade

I'm attempting an in place upgrade from SQL 2014 to SQL 2017, Standard Edition on Windows 2012 R2 (Yes, I know...) The issue is that the installer never presents me with a screen to select the ...
SandraV's user avatar
  • 156
1 vote
2 answers
588 views

Cassandra-4-Update: Multiple Schema Versions

after upgrading our first node, it has a different schema version (according to node tool describe cluster). This caused Spark Jobs to hang, because of reoccurring "schema agreement not reached&...
Sven's user avatar
  • 11
1 vote
0 answers
604 views

Upgrade Replication MySQL from 5.7.34 to 8.0.28 without database downtime

I have to upgrade a MySQL replication topology from 5.7 to 8.0 without database downtime. It’s MySQL Community Edition. There is one source and 5 replicas in the topology and connections happen via ...
Avinash Pawar's user avatar
0 votes
1 answer
489 views

SQL Server 2005 error after update to windows 10 [closed]

I have a SQL Server 2005 database that I can see in SQL Server Management Studio Express. There is a front end application, but since the upgrade to Windows 10, I cannot access the database with it. ...
Aquamarine's user avatar

1
2 3 4 5
11