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.
510 questions
2
votes
2
answers
152
views
Upgrade SQL Server, not user databases
I have one machine we've been fighting to do an in place upgrade of SQL Server from 2016 SP2 CU3 to 2017. It keeps failing, but that's another topic. My question is, is there a way I can run the ...
- 153
0
votes
1
answer
105
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
2
answers
563
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 ...
- 93
2
votes
2
answers
366
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 ...
- 193
1
vote
1
answer
200
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 ...
- 711
1
vote
1
answer
275
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 ...
- 131
3
votes
1
answer
1k
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 '...
- 499
1
vote
1
answer
982
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 ...
- 121
1
vote
2
answers
5k
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 ...
- 119
2
votes
1
answer
95
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. ...
- 31
0
votes
1
answer
1k
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....
- 31
3
votes
1
answer
415
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
1
answer
2k
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?
- 1,038
-1
votes
1
answer
584
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 ...
- 49
1
vote
2
answers
3k
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 ...
- 113
3
votes
1
answer
4k
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'...
- 667
1
vote
0
answers
345
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/...
- 1,100
0
votes
1
answer
270
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 ...
- 1,561
0
votes
1
answer
194
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 ...
- 103
2
votes
3
answers
3k
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 ...
- 131
4
votes
2
answers
6k
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 ...
- 2,239
1
vote
1
answer
5k
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 ...
- 207
0
votes
1
answer
489
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 ...
- 841
2
votes
1
answer
8k
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
- 1,063
22
votes
3
answers
10k
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 ...
- 9,716
0
votes
1
answer
939
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 ...
1
vote
0
answers
593
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 ...
- 3,272
3
votes
2
answers
5k
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, ...
- 33
3
votes
2
answers
1k
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/...
- 562
0
votes
1
answer
3k
views
How to Recover My database From Old WampServer?
Previously I am using wampserver2 with "mysql5.6.17" version.I have many database in that version.
I uninstall the wampserver and install new latest version wampserver3.1.0_x64.
Before uninstalling ...
- 1
1
vote
0
answers
64
views
MySQL won't start after 5.5 security upgrade
I have the MySQL data directory running in a non-standard location on an Ubuntu 14.04 server. Last night it received a security upgrade and now will not start. The error message is
Can't find file: '...
- 11
2
votes
0
answers
468
views
Postgresql - Primary key index getting corrupted after upgrade from 9.2 to 9.6
Im using a Postgresql-9.2 on Centos 6.7. I tried to upgrade the PostgreSQL using --link. After that, I took a table backup and tried to restore this on Dev server. But Im getting an error like,
...
- 1,960
7
votes
2
answers
11k
views
Update SQL Server Management Studio without restart [closed]
When I install or update SQL Server Management Studio it always asks to restart the server. Like now when I updated from 17.3 to 17.4, it asks to restart the server when the update is finished. Is it ...
- 71
3
votes
0
answers
4k
views
FATAL ERROR: Upgrade failed when running mysql_upgrade on CentOS with SCL
We are a free/open source project. We have a CentOS 7 VM and it needed some software updated because the base CentOS 7 is stuck at PHP 5.4 and MediaWiki 1.26. We enabled Software Collections (SCL), ...
user141074
1
vote
1
answer
270
views
Percona-Server: slow TokuDB queries after upgrading from 5.6 to 5.7. ANALYZE TABLE doesn't resolve the problem
After upgrading from Percona-TokuDB 5.6.29-76.2 to 5.7.19-17 we see some very slow queries on some tables without primary keys, but multiple non-unique indexes. The box we migrated to is pretty well ...
- 11
5
votes
1
answer
7k
views
After mysql_upgrade to 5.7, optimizer not using index on large IN clause
I have a similar issue to some other people have described.
In MySQL 5.6.23-72.1-log, a query with a large number of values in an IN clause uses an index, and takes 10 minutes to run;
In 5.7.19-17 ...
- 51
0
votes
2
answers
675
views
Side By Side Upgrade and Migration from 2008 to 2016
Side By Side Upgrade and Migration from 2008 to 2016
Old Server Name Test1
New Server Name Test1
Default Instance Test 1
My question is when the new server be named as the old one 'Test1" and it ...
- 654
0
votes
1
answer
785
views
Faster way of upgrading postgres to 10 from 9.5
I am trying to test the migration of postgres to 10 from 9.5
On trying in a test DB of size 490 GB in one postgres node it is taking about 18 mins. The command I used
sudo -H -u postgres /usr/lib/...
- 1,243
2
votes
1
answer
4k
views
Have to change schema in production
I have a mean-stack website www.myweb.io. I need to upgrade the code and the database. In the previous database, I have a schema:
var UserSchema = new mongoose.Schema({
username: {type: String, ...
- 151
5
votes
2
answers
2k
views
PostgreSQL extremely slow after upgrade from 9.3 to 9.4
We recently upgraded an Amazon RDS instance from PostgreSQL 9.3 to 9.4. There were no problems during the upgrade, and afterwards we ran VACUUM ANALYZE. Performance is now very slow across the board. ...
- 333
3
votes
3
answers
16k
views
Postgres minor version upgrade
What is the recommended method to perform a minor version upgrade of postgres on linux (Centos)? I am looking at upgrading from 9.5.4 to 9.5.5.
- 342
0
votes
1
answer
453
views
MySQL upgrade to 5.6.4 from 5.6.33 on Ubuntu [closed]
I just upgraded our MySQL server from 5.5.53 by doing the following:
sudo apt-get purge mysql-server-5.5 mysql-client-5.5
sudo apt-get install mysql-server-5.6
Which got me to version 5.6.33
...
- 101
2
votes
1
answer
11k
views
How to upgrade PostgreSQL 9.6 to 10 in Ubuntu 16.04?
Is there any simple apt-get version?
Some people here said the long process was OK for them.
(https://gist.github.com/delameko/bd3aa2a54a15c50c723f0eef8f583a44)
- 136
4
votes
2
answers
3k
views
Applying patch oracle 11.2.0.4 on 11.2.0.2
We are going to apply Oracle patch 11.2.0.4 on Oracle 11.2.0.2. We have 11.2.0.4 patch. We are using (DBUA) for this upgrade. As DBUA will check the preupgrade requisites, we want to run preupgrade ...
- 69
1
vote
1
answer
940
views
MySQL Error: “Table storage engine for `proc` doesn't have this option (ERROR 1031)”
I'm running into a strange problem with MySQL. Searched everywhere for a fix but cannot find anything. Running Ubuntu 14.04.
I have a database running on Percona MySQL 5.7.18-16. I want to update ...
- 11
3
votes
1
answer
221
views
Will SQL 2008 SSIS package files work with SQL 2016 databases after database upgrades?
We plan to upgrade SQL 2008R2 to SQL 2016. We want to upgrade database servers first. We have separate SQL 2008R2 servers for SSIS and SSRS. SSIS packages are stored as files.
My question is:
...
- 93
6
votes
1
answer
18k
views
Optimizing slow performance of simple SELECT query
I have an app called 'Links' where 1) users congregate in groups and add others, 2) post content for each other in the said groups. Groups are defined by a links_group table in my postgresql 9.6.5 DB, ...
- 2,039
9
votes
1
answer
4k
views
PostgreSQL 9.2 - 9.6 upgrade with zero downtime
I have to upgrade from PostgreSQL 9.2 to 9.6. Following are the challenges that I am facing:
Since we have streaming replication setup, and PostgreSQL doesn't support lower to upper version upgrade ...
- 121
2
votes
0
answers
735
views
In-Place SSRS 2014 to 2016 Upgrade Failed. Cannot start new SSRS 2016 instance
We have a SQL server 2014 and SSRS 2014 instance set up on two different 2012 R2 servers. This has been our setup for years, and everything has worked fine.
We did an in place upgrade of the SQL ...
- 21
2
votes
2
answers
123
views
Copy mysql schemas to a new instance of a new version
I have a few schemas, Which are included in mysql 4 instance, And i want to move them to other mysql instance which running under a newer version - mysql 5.6. This instance is already including some ...
- 353