Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

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.

0
votes
0answers
4 views

mysql 8 is failure to start after upgrade from 5.7

I've upgraded one of the slave server from mysql 5.6 to 5.7 and now 5.7 to 8. But after up-gradation steps done when i use systemctl start mysqld.service or systemctl restart mysqld facing error and ...
-1
votes
0answers
28 views

MS SQL Server Migration 2008 -> 2016 [duplicate]

Gurus - I was recently asked to perform an analysis of what will it take the company to migrate/upgrade On-Prem MS SQL Sever 2008 to 2016. I googled around, but did not find much regarding this. Can ...
-1
votes
0answers
28 views

databases not showing anymore after an upgrade

I did an upgrade from MySQL 5.5 to 8.0, by doing intermediate upgrades to 5.6 and 5.7 as recommended, thus: 5.5 -> 5.6 -> 5.7 -> 8.0. I ran the mysql_upgrade utility with every step and never had any ...
1
vote
1answer
51 views

Downgrading PostgreSQL 10 to 9.4

Are there any particular precautions I should take when downgrading PG 10 to 9.4? I have a database on Heroku (PG 9.4) which I'm going to upgrade to PG 10.6. In case something goes wrong, I want to ...
1
vote
0answers
30 views

SQL Server upgrade re-initializes subscriptions

I recently, in a test environment, upgraded my SQL Server Distributor from 2012 to 2017. The upgrade went off without a hitch but I noticed that after the upgrade was completed all of my subscriptions ...
1
vote
1answer
35 views

Could anyone please help to understand MSSQL Compatibility Level

I have a task to upgrade database from MSSQL Server-2005 to MSSQL Server-2012. So I took backup of old database and simply restored into SQL Server-2012(SP3). Executed query on New database: SELECT ...
0
votes
1answer
36 views

Upgrade MySQL Master Slave Replication Cluster from 5.7.22 to 5.7.24

I have a two node MySQL cluster with Master Slave replication. The MySQL version is 5.7.22 and the OS is CentOS. I need to upgrade the MySQL version to 5.7.24 due to some security reasons. However, ...
3
votes
1answer
24 views

mysql_upgrade check if it's neccessary to run it

How can I determine, do I need to run 'mysql_upgrade` command on database? Percona-server-5.6.41 is installed and running now for a several monthes. Before it mysql-5.6 was installed. In-place ...
2
votes
2answers
60 views

Upgrading SQL Server 2005 to 2016

I have a requirement to get rid of our old servers, however one of them includes a database server that is currently using SQL Server 2005. We have a new server running with 2016 so I wanted to know ...
1
vote
1answer
34 views

mysql_upgrade on fresh MySQL/MariaDB installation

What I've noticed lately is that whenever I install MariaDB or MySQL on a clean machine, and if I run mysql_upgrade it does the upgrading, so I figured since it's not showing it's already upgraded, I ...
0
votes
1answer
75 views

pg_upgrade --link fails: `directory “/…” already in use as a tablespace`

I'm attempting to upgrade from 9.6.2 to 10.5 using pg_upgrade My upgrade command (from OpenBSD pkg-readme): su _postgresql -c "cd /var/postgresql && \ pg_upgrade --link -b /usr/local/bin/...
0
votes
1answer
65 views

How do I configure my SQL Server instance to use a different Edition with minimal side effects?

I'm in the process of migrating an old server running Windows 2008 R2 with SQL 2012 Express to a new server running SQL Server 2017 Standard and Windows 2016. I would like to mirror databases between ...
1
vote
1answer
19 views

Table column length is fine in MySQL 5.5 and 5.6, but upgrading to 5.7 results in too many columns

So I have a CMS that is being upgraded from MySQL 5.5 -> 5.7. One table has a 1000+ columns, but it works fine in 5.5 and 5.6. When reaching 5.7, queries involving this table result in a 1117 error. (...
1
vote
0answers
22 views

Pg_upgrade for a Big Size Postgres DB Cluster [closed]

I'm upgrading a Postgres DB cluster, each of size around 14TB. 1 primary and 1 secondary/hot-standby DB. Using pg_upgrade in Link mode. What is the recommended process to upgrade these 2 DBs, to ...
1
vote
0answers
90 views

Error with Ola Hallengren backup job after upgrading SQL Server 2016 to SP2 [closed]

Recently I updated SQL Server 2016 with SP2. After that, the Ola Hallengren backup job failed throwing the error below: Source: https://ola.hallengren.com [SQLSTATE 01000] (Message 50000) ...
-1
votes
0answers
36 views

Auto Service Restart During SQL Server 2016 Standard to Enterprise Upgrade?

I understand that SQL Server services require a restart in order to activate SQL Server Enterprise edition when upgrading from Standard. But does this service restart happen automatically or does it ...
3
votes
0answers
57 views

Moving to version 2016 from 2008 and Breaking Change Alert from Upgrade Advisor

DBMS: SQL Server Upgrading from version 2008 to 2016. I have this part of the code that is being flagged by the Upgrade adviser as Breaking Change. Error: uses a constant expression which are ...
0
votes
1answer
165 views

Behavior Differences Running SQL 2017 in 130 Compat Mode vs. Running SQL 2016 in 130 Compat Mode?

We have a new application which includes ETL scripts, R, and .NET code all actively being developed on SQL 2016 architecture. I just recently received approval to start setting up new environments ...
0
votes
1answer
43 views

How to change all connections to SQL Server without investigating each hard-coded connection to serverName?

We've got a server upgrade scheduled for the near-future and we're looking to move to a new server. Our main issue is that we cannot have two servers with the same name on our domain. So is there a ...
-2
votes
2answers
103 views

SQL server migration - Server object listing/scripting tool [closed]

We need to quickly migrate multiple SQL Servers. We need a process to script out all server-level objects, e.g. linked servers, logins, jobs, server roles. We're looking for a tool to script out ...
2
votes
2answers
60 views

Upgrade in-place with low disk space on C: drive

I am due to upgrade SQL Server 2005 Express to 2014 Express. This will be an in-place upgrade. It's not my preferred way of upgrading, but being a physical machine and in a specific secure network ...
1
vote
1answer
112 views

SQL Server Upgrade - A new Approach for Upgrading

Microsoft's technical guide for SQL Server upgrade references two upgrade paths: in-place and side-by-side. I don't see a third, visibly more viable/convenient option, which is to do an in-place ...
0
votes
1answer
44 views

How to upgrade a MySQL database using numbered scripts based on a version field

I have a database that contains a version table with one value stored in it which is the database version number. I would like to be able to update the database version automatically using numbered ...
3
votes
1answer
200 views

Oracle 12 Startup upgrade throws error 443

Please follow the logic of my attempts at upgrade before suggesting a fix. The error 443 is not the main problem here. we are upgrading from oracle 11.2.0.4 to 12.2.0.1 on a Solaris 11.3 server '...
1
vote
0answers
36 views

SQL Server 2008 to 2016 upgrade - Side-By-Side Upgrade, Project Plans and timelines [closed]

I'm planning on upgrading SQL Server in our organization from 2008 to 2016. We have several servers and about a dozen databases (20-25 SSIS packages and a hundred SSRS reports). SQL Server is used to ...
0
votes
0answers
29 views

dockerized postgresql listing no clusters

I'm upgrading an existing dockerized postgres:9.6 to 10. There are plenty of good Q/As on DBA and SO that go the path of pg_upgradecluster, but it is not working for me. When I start a vanilla pg:10 ...
0
votes
1answer
474 views

Mysql upgrade 5.7.22 to 8.0, server not starting after upgrade

I followed the upgrade guide Upgrading MySQL. Already installed version of mysql is 5.7.22 Verified all Upgrade Prerequisites for MySQL 5.7 Installation SET GLOBAL innodb_fast_shutdown = 1; then ...
0
votes
0answers
26 views

Upgrade MySQL 5.5 to 5.7 & catch up meanwhile data incremental data

In my organization we are going to upgrade MySQL server 5.5[MyISAM default engine] running on Windows. I have given new Windows server with same configuration like on prod server. now i will restore ...
2
votes
1answer
40 views

Reversion strategy when upgrading MySQL

We are planning to upgrade from MySQL 5.6 to 8.0 and are considering disaster recovery plans. We have three separate databases within our MySQL 5.6 instance which are 200Gb, 170GB and roughly 9GB. ...
0
votes
1answer
221 views

MySQL upgrade from 5.6 to 8.0

When trying to start MySQL 8.0 it complained about partially upgraded DD. Furthermore, it complained about not being to open a table S/AD.ibd which no longer exists there because we moved it to S/AD....
2
votes
1answer
86 views

SQL Server Patch Level Is Inaccurate, Causing Upgrade Issues

I have a box that lists SQL Server 2014 SP2 (12.2.5000) in both add/remove programs and the registry HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL Server\120\SQLServer2014\CurrentVersion\...
1
vote
1answer
429 views

Oracle Upgrade Standard to Enterprise Edition

I need to upgrade several Oracle Database 12c Standard Edition to Enterprise Edition. The only upgrade path I found is to reinstall the Oracle software. Is that the only way to upgrade?
0
votes
1answer
73 views

Mongodb upgrade from 3.0 to 3.2

I have upgraded the mongodb from 3.0.15 to 3.2 mongodb3.0.15 Configuration : Three shards Three config servers mongodb3.2 Configuration : Three shards Three config servers No replica sets I ...
0
votes
2answers
203 views

Analyze too slow after postgres upgrade

I'm working on a testing server to upgrade a large database, 700GB with around 20000 tables. The upgrade was fast enough using the --link option, but the analyze only script takes 8 hours, which is ...
0
votes
1answer
993 views

Can upgrade from MariaDB 5.5 to MariaDB 10.3 directly?

We have a database running in MariaDB 5.5.60 and we want to upgrade it to the last 10.3.7 version. However I'm looking at MariaDB knowledge base ( https://mariadb.com/kb/en/library/upgrading/ ) and I'...
1
vote
0answers
93 views

pg_upgrade: language “plpythonu” is not trusted

I'm trying to perform PostgreSQL 9.6 -> 10 upgrade with link method: /usr/lib/postgresql/10/bin/pg_upgrade --link \ --old-datadir=/var/lib/postgresql/9.6/main \ --new-datadir=/var/lib/postgresql/10/...
0
votes
0answers
65 views

pg_upgrade: Sequence-Check fails

After pg_upgrade one check fails. This SQL gets executed to list tables and their sequences. In comments to this question it is called "above sql". SELECT S.relname, T.relname, C.attname FROM ...
0
votes
1answer
43 views

Benchmarking procedures or Upgrade tests to be done after upgrading to SQL Server 2016 from SQL Server 2012

I need suggestions on how to benchmark performance or create baselines to test the upgrade from SQL Server 2012 to SQL Server 2016 (both standard edition), also if any post upgrade tasks that needs to ...
2
votes
3answers
961 views

How to repair mongodb service after an upgrade to Fedora 28?

I just upgraded to Fedora 28 and now my mongod service doesn't launch anymore. One possible solution that would fork in my case would be to be able to downgrade mongodb to 3.4, as the system upgrade ...
3
votes
2answers
2k views

Failure during install of SQL Server 2016 sp2

I'm trying to install the new SP2 for SQL Server 2016, but it fails during the install with an Engine error. This is what I can read in the errorlog> Error: 468, Severity: 16, State: 9. Cannot ...
0
votes
0answers
54 views

what version of postgresql 9.6.8 with what version of postgis

I am a bit confused with the upgrade of a dataserver postgres from 9.3 to 9.6.8. Despite the readings of http://postgis.net/windows_downloads/ and the board (not up to date) https://trac.osgeo.org/...
0
votes
1answer
345 views

pg_upgrade issue from postgres 9.3 to 9.6

I am trying to use pg_upgrade to upgrade postgres server from 9.3 to 9.6. I have both binaries on the windows server R8. Here are the 2 pg_hba.conf : > 9.3 : # TYPE DATABASE USER ...
0
votes
1answer
91 views

Methods for right-sizing SQL Server virtualization?

I am starting to plan a migration of SQL Server 2008 R2 Enterprise Ed. to 2017 (edition TBD). One of the more important tasks assigned to me is to determine the specs for the new VMWare hardware my ...
1
vote
1answer
339 views

SQL Server update from SP1 to SP3 [duplicate]

Can I move directly from SQL Server SP1 to SP3 or do i need to install SP2 then go to SP3. I was assigned to upgrade my servers 2014 just to make sure I don't fall into problems
22
votes
3answers
2k views

SQL Server Distributed Availability Group databases not syncing after a server reboot

We're getting ready to perform a large upgrade on our SQL Servers and are noticing some unusual behavior with Distributed Availability Groups that I'm trying to resolve before moving forward. Last ...
0
votes
1answer
178 views

Oracle PDB broken after upgrade from 12.1 to 12.2

We upgraded our development environment Oracle 12.1 RDBMS to 12.2 version. The CDB contained 3 PDBs of which 2 upgraded nicely but 1 did not. The resulting situation is that during the upgrade SYSTEM ...
0
votes
0answers
50 views

SHOW DATABASES query slower after mysql upgrade

I am experiencing some slowness with show databases/show tables query after upgrading mysql from 5.6 to 5.7.I am also experiencing some slowness on phpmysqmdin when pulling databases and tables as ...
1
vote
0answers
165 views

Collation Conflict when patching SSRS

We recently upgraded our test database servers from SQL 2014 SP2 CU3 to 2014 SP2 CU10. Most of the servers are fine, but on 2 of them we are getting the following error when connecting to the ...
2
votes
2answers
352 views

Update expiring Mongo cluster SSL certificate

I have a multi-node mongo cluster using SSL requireSSL and the certificates are going to expire. Is there a zero-downtime method to update the certs? I know the easiest way would be to stop all nodes, ...
1
vote
1answer
211 views

postgres pg_upgrade 9.2 to 9.5 problem

I'm trying to upgrade from 9.2 to 9.5 using the pg_upgrade tool. I'm using CentOS 7.0 current postgres bin folder: /opt/rh/postgresql92/root/usr/bin new postgres bin folder: /opt/rh/rh-postgresql95/...