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 vote
0 answers
19 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
57 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. ...
0 votes
0 answers
6 views

lost data after upgrading couchdb from v2 to v3

On a debian9 server I upgraded the couchdb 2.1.2 to 3.2 with : apt-get upgrade couchdb and I see no data or users database anymore. Fortunately I had made a backup of the files located in the data ...
0 votes
1 answer
46 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
65 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. ...
0 votes
1 answer
59 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 ...
1 vote
0 answers
50 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
-1 votes
1 answer
75 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 ...
0 votes
0 answers
48 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. ...
2 votes
1 answer
180 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
54 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
42 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 ...
  • 2,874
-1 votes
1 answer
42 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
49 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
90 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 ...
4 votes
0 answers
63 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 ...
-1 votes
1 answer
56 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?
  • 637
0 votes
1 answer
2k 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
31 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 ...
3 votes
2 answers
137 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. ...
0 votes
1 answer
179 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 ...
0 votes
1 answer
59 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 ,...
  • 1
7 votes
2 answers
343 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 ...
  • 26.7k
0 votes
1 answer
144 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 ...
0 votes
0 answers
89 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 ...
  • 145
1 vote
1 answer
47 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 ...
0 votes
0 answers
39 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 ...
  • 37
0 votes
1 answer
783 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 ...
  • 3,680
1 vote
1 answer
326 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/...
  • 882
5 votes
1 answer
194 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 ...
  • 26.7k
0 votes
2 answers
457 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 ...
  • 149
0 votes
0 answers
13 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 ...
0 votes
0 answers
125 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 ...
0 votes
1 answer
40 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 ...
1 vote
1 answer
236 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. ...
  • 133
0 votes
1 answer
388 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 ...
  • 796
0 votes
1 answer
72 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/...
  • 195
0 votes
0 answers
107 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:/...
0 votes
1 answer
416 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 ...
2 votes
1 answer
487 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 ...
1 vote
1 answer
361 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 ...
  • 131
0 votes
0 answers
121 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 ...
  • 101
0 votes
1 answer
307 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 ...
  • 165
1 vote
1 answer
117 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 ...
0 votes
0 answers
1k 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 ...
0 votes
0 answers
27 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, ...
  • 165
-2 votes
2 answers
58 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 ...
-2 votes
1 answer
202 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 ...
0 votes
1 answer
3k 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 ...
3 votes
1 answer
3k 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 ...
  • 195

1
2 3 4 5
10