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.
488
questions
0
votes
0
answers
12
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
0
votes
0
answers
8
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 "...
1
vote
1
answer
172
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
0
votes
1
answer
27
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,305
1
vote
2
answers
40
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
29
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 ...
0
votes
1
answer
41
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 ...
- 1
0
votes
0
answers
86
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
32
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
106
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) ---> ...
- 550
0
votes
0
answers
63
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
0
votes
0
answers
47
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 ...
- 1
1
vote
1
answer
912
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
284
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
253
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
56
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
123
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 > ...
- 151
1
vote
1
answer
39
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
70
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 & ...
- 115
0
votes
1
answer
72
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 ...
- 549
0
votes
1
answer
38
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 ...
- 25
0
votes
0
answers
127
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
0
answers
491
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 ...
0
votes
1
answer
145
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
193
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
181
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
147
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, ...
- 765
0
votes
1
answer
105
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 ...
- 175
1
vote
2
answers
1k
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 ...
- 156
1
vote
2
answers
415
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&...
- 11
1
vote
0
answers
439
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 ...
0
votes
1
answer
301
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. ...
- 103
0
votes
1
answer
523
views
Import postgresql database with Latin encoding
I'm going to upgrade from postgresql 9 to postgresql 11, the encoding used is Latin.
I've exported the database using this command pg_dumpall | gzip > /tmp/db.sql.gz
I extracted the exported ...
2
votes
2
answers
119
views
Do MySQL/InnoDB stats tables persist through major version upgrades?
After performing a major version upgrade of a PostgreSQL database, the ANALYZE command needs to be run in order to repopulate tables for query statistics, which do not persist through the upgrade. ...
- 123
0
votes
1
answer
244
views
SQL Agent Job fails after upgrade to SQL 2017
I have upgraded a database to SQL 2017. A SQL Agent Job that previously ran now fails with this error:
Unable to start execution of step 1
(reason: JobOwner DOMAIN\USERNAME doesn't have permissions ...
- 111
1
vote
0
answers
748
views
Why this aggregate function cannot be converted with pg_upgrade from PostgreSQL 9.5 to PG 14.3?
I am trying to port old PostgreSQL v9.5 database (or family of databases) to PostgreSQL v14.3, with pg_upgrade utility.
After many hassles with old v9.5 binaries, source files (had to be recompiled to ...
- 23
0
votes
1
answer
915
views
upgrade OS and SQL Server version on SQL Cluster [closed]
We have a critical application that uses SQL Server 2016 Cluster running on Windows server 2012. In order for us to upgrade the application, we need to upgrade the OS and the SQL Server version. What ...
- 11
0
votes
0
answers
172
views
What are space requirements for the Postgres database major version upgrade?
I'm using the RDS Postgres database and the current version is 11.13 and want to upgrade it to 12.10. My instance storage is 5000 GB and almost all storage is occupied. Now only ~500 GB are available.
...
- 101
2
votes
1
answer
1k
views
How to rollback to earlier SQL Server version without data loss after SQL Server upgrade
We are planning for SQL Server 2019 upgrade from SQL Server 2014 version. One of the requirement from the business owners is that we should be able to fall back to earlier version without data loss ...
- 21
0
votes
1
answer
76
views
Upgrate postgresql database
I'm going to upgrade postgresql from the version 9 to 11, I exported all the cluster using the command pg_dumpall -h localhost -p 5450 > /tmp/all.sql I have installed postgresql 11 on my new ...
0
votes
1
answer
65
views
Should I backup and restore the SMK when performing a server upgrade and migration?
I understand that the SMK is used to encrypt sensitive data like passwords in the linked server configuration.
Hence when I migrate or upgrade the sql server to another computer, then I assume I ...
- 3,350
-1
votes
1
answer
156
views
Desired State Schema Best Practices for continous schema + data upgrades at different on prem locations
I am looking however to blogs/articles on people who did the same so that i can reference my work against other people who also went in this direction before / or even a github repo:
I have a project ...
- 131
1
vote
1
answer
419
views
What is the best way to migrate & upgrade a extremely large postgreSQL server to another hardware whilst minimising downtime
I am trying to migrate and upgrade an extremely large on-premise live postgreSQL to another hardware whilst minimising downtime.
Even trying to do a backup requires more than 1 day.
Points:
On-...
H-Yee
0
votes
1
answer
300
views
Upgrading Logical Replica of PostgreSQL
I am trying to upgrade a logical replica from PostgreSQL V10 to V13. We are using pglogical for the logical replication.
Though the upgrade process of the replica can be done, however the replication ...
- 532
4
votes
0
answers
88
views
Planning for application upgrade which connects to SQL server database
I am looking for some advise/guidance on how to achieve this with minimum downtime and possibly avoid any errors or failure during production change-
Background-
We have SQL database servers ...
- 762
-1
votes
1
answer
106
views
Should my company upgrade from Enterprise 2017 to sql server 2019? [closed]
Our production server is currently running SQL Enterprise 2017.
We're paying for software assurance which means we can upgrade at any time.
Should we be looking at SQL 2019?
- 657
0
votes
1
answer
7k
views
Known issues with in place upgrade of SQL Server 2016 to SQL Server 2019 [closed]
We are planning to upgrade our existing SQL Server 2016 instances to SQL Server 2019. Our application is in some other environment already running on SQL Server 2019 so we should not have any ...
- 345
2
votes
0
answers
36
views
Table going into Repair mode during upgrade
Recently I was doing an upgrade in production system from MySQL 5.6 to 5.7. there is a particularly large innodb table about 2.5 TB which uses hash partitioning. when I ran mysql_upgrade I noticed ...
- 21
3
votes
2
answers
457
views
How to resolve The instance could not be upgraded because the 'reg*' data type is used in user tables?
I tried to upgrade a Postgres DB Engine from 11.12 to 13.3 on AWS via the admin console in the browser. But the upgrade could not be performed, the error/pg_upgrade_precheck.log shows this message.
...
