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
-1 votes
1 answer
33 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 ...
user avatar
  • 131
1 vote
1 answer
26 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-...
user avatar
0 votes
1 answer
22 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 ...
user avatar
4 votes
0 answers
56 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 ...
user avatar
-1 votes
1 answer
45 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?
user avatar
  • 637
0 votes
1 answer
145 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 ...
user avatar
  • 345
2 votes
0 answers
29 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 ...
user avatar
3 votes
2 answers
47 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. ...
user avatar
0 votes
1 answer
60 views

What could be the reason for this invalid objects after trying to upgrade?

We recently wanted to upgrade our Database but didnt get to do it as we got a lot of Audit specific invalid objects, after looking online for ressources we couldnt find anything specific reason for ...
user avatar
0 votes
1 answer
56 views

Upgrade all databases using one upgraded database ik one local SQL instance

Situation : MICROSOFT SQL SERVER 2019 server , for testing I use express version. An app is linked to one local SQL instance , let name this instance ‘ Appname’ . In this instance there is a database ,...
user avatar
  • 1
7 votes
2 answers
287 views

Is the Query Store's Overall Resource Consumption report telling me my database is doing terribly or are the numbers just whacked?

Recently we upgraded one of our production servers from SQL Server 2016 to SQL Server 2019 (CU 15). This was a great opportunity for me to enable Query Store on our main application database. It's ...
user avatar
  • 24k
0 votes
1 answer
24 views

Rolling Upgrade Win2012R2/SQL2012 Availability Group to Win2019/SQL2019

To do a rolling upgrade of an Availability Group from Windows 2012R2, SQL 2012 to Windows 2019, SQL 2019 do I have to have an intermediary set of servers on Windows 2016? Based on the documentation ...
user avatar
0 votes
0 answers
78 views

Mysql resetted after upgrading from 80025 to 80027

I was with 8.0.25-0ubuntu0.20.04.1 (as the log say), and I made apt update && apt upgrade (specially to fix some issue with other packages). But, when upgrading, it said "Failed to ...
user avatar
  • 103
1 vote
1 answer
30 views

Potential pitfalls for upgrading PostgreSQL from 9.x/10.x to 13.x?

I have inherited from a predecessor a large number of Debian 9 systems that we are now looking at upgrading to Debian 11. Most of these run PostgreSQL 9 or 10, installed from Postgres's own ...
user avatar
0 votes
0 answers
21 views

Process for upgrading MySQL Master-Slave to a new release series version

I have several MySQL servers that I want to upgrade from 5.7.31 to the most recent release series (5.7.36 I believe), but in one test I found that replication on one server set failed, and it required ...
user avatar
  • 37
0 votes
1 answer
217 views

Problems with pg_upgradecluster

Friday I did an upgrade from PostgreSQL 13 to 14 with pg_upgradecluster (on Debian Buster). This worked so today I wanted to upgrade another server (Linux Mint 20.3 Cinnamon). This time it does not ...
user avatar
  • 3,650
1 vote
1 answer
128 views

Upgrade to PostgreSQL 13 fails

I'm trying to upgrade PostgreSQL 12 cluster to version 13, with following script: /usr/lib/postgresql/13/bin/pg_upgrade --check \ --old-datadir=/var/lib/postgresql/12/main \ --new-datadir=/var/lib/...
user avatar
  • 832
5 votes
1 answer
176 views

Door Number 1, 2, or 3?...Security change, bug, or failed upgrade with an in-place upgrade from SQL Server 2016 to SQL Server 2019?

What I Did: Recently I tested doing an in-place upgrade on ServerA, a development server that was running SQL Server 2016 (SP 2 CU17) Standard Edition to SQL Server 2019 Standard Edition. (I know this ...
user avatar
  • 24k
0 votes
2 answers
152 views

upgrade to postgres 14 from postgres 13 using pg_basebackup

I want to upgrade/move a running timescale cluster manage by Patroni using PostgreSQL 13 to a new hardware with PostgreSQL 14, the dataset is ~ 40GB but is taking ages take a backup using: pg_dump -j ...
user avatar
  • 139
0 votes
0 answers
11 views

Does turning on mysql strict mode have any performance benefits

I am in the process of identifying what changes are needed to enable strict mode on a mysql 5.7 database. The most obvious one is making sure we don't have anything which would conflict with the ...
user avatar
0 votes
0 answers
72 views

Oracle 11g to 19c - Upgrade Error

We upgraded our test database from 11gR2 to 19c (19.12) (OS OL 7.9). After the upgrade, all the components in the dba_registry seem to be in the UPGRADED state, not VALID. At the same time, we ...
user avatar
0 votes
1 answer
31 views

CockroachDB upgrade not finalized

I am running a three-node CockroachDB docker cluster (Debian OS) and I recently upgraded the cluster from version v21.1 to version v21.2 following the procedure outlined in the documentation using the ...
user avatar
1 vote
1 answer
115 views

After a database upgrade from MariaDB 10.1 to 10.6 new ODBC connections are returning wrong values [closed]

I had a total meltdown after installing "Feature update to Windows 10, version 21H2". A month into this I am now suspect that somehow this update reconfigured the way user System is handled. ...
user avatar
  • 133
0 votes
1 answer
276 views

fix InnoDB: corrupted TRX_NO after upgrading to 10.3.31

After upgrading mariadb from 10.3.25 to 10.3.31 it fails to start like described in this bug report I temporary fixed it by downgrading mariadb to 10.3.25 again like I described here. To fix this ...
user avatar
  • 798
0 votes
1 answer
39 views

Postgres Upgrading Errors due to table not existing

I am trying to do an upgrade from Postgres 9.6 to 12, I have done this in the past but in this instance I am having difficulty. When running the pg_upgrade command followed by the parameters: /usr/...
user avatar
  • 143
0 votes
0 answers
49 views

pg_ctl error when using pg_upgrade

We are attempting to upgrade Postgres 10.10 to 12.4 using pg_upgrade on a Windows 2016 Server machine using the command "C:/Program Files/PostgreSQL/12/bin/pg_upgrade.exe” --old-datadir "C:/...
user avatar
0 votes
1 answer
150 views

List of deprecated features for PostgreSQL 8 to 13

I'm going to upgrade several PostgreSQL 8 databases to version 13. The people I work for come from SQL Server. I've been looking for a tool similar to "DMA", specifically the part that lists ...
user avatar
2 votes
1 answer
244 views

Postgres major version upgrade using replication server

I am planning to upgrade my database from Postgres 10 to Posgres 14. To reduce the downtime, I plan to use the replication for the same. Plan (in short) is to: Dump the data using pg_dumpall Kill the ...
user avatar
0 votes
1 answer
196 views

Upgrading Postgres major version using logical replication

We have considered some options to upgrade our Postgres servers from the current (10) version to the latest (14). We decided no to do on the primary - since we need to do with the link option (so in ...
user avatar
  • 121
0 votes
0 answers
66 views

MariaDB upgrade fails on replication slaves

I am having problems when a MariaDB replication slave wants to upgrade its tables after a server was patched. This happens consistently with any sort of OS patching. The system has several slave ...
user avatar
  • 101
0 votes
1 answer
156 views

Incompatible function reference when upgrading to Postgres 13

I want to upgrade a Postgres 9.6 database on CloudSQL (GCP) up to version 13. As SQL export/import is the only supported upgrade path, I've exported the PG9.6 database and attempted to import it into ...
user avatar
  • 155
1 vote
1 answer
73 views

Why would anyone ever want to dump/restore if you can just use pg_upgrade?

pg_upgrade (formerly called pg_migrator) allows data stored in PostgreSQL data files to be upgraded to a later PostgreSQL major version without the data dump/reload typically required for major ...
user avatar
0 votes
0 answers
344 views

Upgrade Postgres database from 10 to 13 running in Docker

I have a Postgres database running in a docker container (https://hub.docker.com/_/postgres). The docker image is postgres:10.0 and I would like to upgrade to postgres:13.3. If I just change the image ...
user avatar
  • 111
0 votes
0 answers
755 views

ERROR 1932 (42S02): Table '....' doesn't exist in engine after upgrade mariadb

I need use JSON_OBJECT builtin mariadb function, but mariadb version in server 10.0.xx, then we upgrade to 10.4.20-MariaDB. Then now mariadb version is 10.4.20-MariaDB But some table can't be accessed ...
user avatar
0 votes
0 answers
152 views

Postgres major upgrade with repmgr

I have a three node cluster pg_version 10, i'm trying to upgrade it to pg_version 11. Also, that cluster is managed by repmgr 10, which should also be upgraded to version 11. I have followed after ...
user avatar
0 votes
0 answers
24 views

Upgrade MySQL Version, need I also upgrade the database as well?

I am running MySQL 5.6.51. And I notice that there is MySQL 8.x. Based on https://severalnines.com/database-blog/tips-for-upgrading-mysql-5-7-to-mysql-8, I need to first upgrade from 5.6.x to 5.7.x, ...
user avatar
  • 165
-2 votes
2 answers
42 views

MySQL Upgrade Procedure in a production environment [closed]

Am new to the role and employers have asked me to come up with a plan to upgrade the MySQL 5.6 on the production server to 5.7. It has partitions and MASTER-MASTER replication setup and has around ...
user avatar
-2 votes
1 answer
156 views

SQL Server 2016 : upgrade from SP2-GDR to CU15

I tried to upgrade one of my SQL Server from 2016 SP2-GDR to 2016 SP2 CU15, but I got nothing can be upgraded warning. Is this normal? The error says: There are no SQL Server instances or shared ...
user avatar
0 votes
1 answer
2k views

How do I correct InnoDB Multiple files found for the same tablespace ID?

Some time ago after an update of Ubuntu 20.10, I discovered that MySQL was not running. When I tried to restart it, the error message suggested that it had started, failed and stopped. A check of the ...
user avatar
3 votes
1 answer
2k views

Perform Postgres Upgrade from 9.6 to 13 with minimal downtime

I am looking to upgrade our Postgres 9.6 server to Postgres 13. I have looked into the following options: pg_upgrade, if I was doing this without the --link option, this would take considerable time ...
user avatar
  • 143
0 votes
2 answers
95 views

Remove Query Tuning Assistant (msqta) schema and tables

When running the Query Tuning Assistant (using the New Database Upgrade Session) on SQL Server 2017 I have a new schema msqta created in the corresponding database as supposed, along with six tables ...
user avatar
2 votes
2 answers
449 views

SQL Server 2016 database backup fails to restore on SQL Server 2019

We were trying to restore the database from SQL Server 2016 Developer Edition to SQL Server 2019 Developer Edition and it was failing with an exception. Details about this DB: It has in-memory ...
user avatar
1 vote
1 answer
885 views

Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation

Need urgent help on this. We have applied latest sql patches on one of the server (SQL 2014, SP3, CU4) and somehow we were not able to start the SQL due to following error. Cannot resolve the ...
user avatar
  • 17
0 votes
1 answer
25 views

Upgrading Operating System only. OS 2016 - 2019

Currently we have a number of Servers that are using Windows 2016 with SQL Server 2017. The support team want to do an in-place upgrade of the OS to 2019 due to 2016 Mainstream support ending in Jan ...
user avatar
0 votes
1 answer
105 views

Why some files in data directory of a Postgresql cluster are symlink to files of another cluster?

I did use pg_upgrade. I had a cluster of Postgresql with version 9.6 on my machine, and then I did start another cluster with version of v12. Each of them had separate data directories, in a directory ...
user avatar
  • 105
1 vote
1 answer
842 views

Upgrading Postgres 12 to 13: 'pg_upgrade.exe' fails

I'm attempting to upgrade a Postgres instance from version 12 to version 13, following the steps outlined at https://www.postgresql.org/docs/13/pgupgrade.html. From an elevated command prompt, I'm ...
user avatar
  • 187
0 votes
0 answers
216 views

SSIS - DMA doesn't support migration assessment to SSIS in local SQL Server 2019

we will migrate from SQL Server 2008 R2 to SQL Server 2019 in near future, we already run DMA to analyze database, however DMA 5.2 doesn't support migration assessment type for intergration services (...
user avatar
0 votes
2 answers
3k views

How to change password version by myself in oracle?

Oracle documentation (18c) says: .... You must expire the users who have only the 10G password version, and do not have one or both of the 11G or 12C password versions. For example: ALTER USER ...
user avatar
  • 506
0 votes
1 answer
41 views

Can I downscale/upscale my MySQL server automatically?

Is this doable? Since we know the peak times of our platform we are planning to downscale our DB after peak hours then upgrade the specs before the start of peak hours, how can we do this? Like how is ...
user avatar
  • 59
1 vote
1 answer
35 views

What are the risks of upgrading DB major version in replica and then promoting it as master?

Recently AWS decided to force update all MariaDB RDS under 10.3, my RDS is in MariaDB 10.1. We are trying to minimize the downtime and any risk of data out of sync. Our plan is to create a replica and ...
user avatar
  • 143

1
2 3 4 5
10