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
2
votes
0answers
392 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, ...
7
votes
2answers
8k 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 ...
2
votes
0answers
3k 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), ...
1
vote
1answer
238 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 ...
3
votes
1answer
5k 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 ...
0
votes
2answers
556 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 ...
0
votes
1answer
690 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/...
2
votes
1answer
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, ...
5
votes
2answers
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. ...
3
votes
3answers
9k 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.
0
votes
1answer
428 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 ...
2
votes
1answer
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)
4
votes
2answers
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 ...
1
vote
1answer
756 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 ...
3
votes
1answer
203 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: ...
4
votes
1answer
11k 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, ...
0
votes
0answers
199 views

Upgrading PostgreSQL 9.4.9 to 9.6.x on Debian

Current version: PostgreSQL 9.4.9 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit OS: Debian GNU/Linux 8.6 (jessie) Any considerations and/or recommendations on ...
9
votes
1answer
3k 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 ...
2
votes
0answers
523 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 ...
2
votes
2answers
86 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 ...
1
vote
1answer
975 views

Upgrade MongoDB Community to Enterprise

I have a server using MongoDB Community but my client wants additional features that are only able using the Enterprise version. We're about to buy it, however, I was wondering what should I do to ...
1
vote
2answers
3k views

upgrading Oracle forms and reports 6i to 12c

We are planning a migration of an Oracle Forms and report 6i application to 12c, and at the same time we will upgrade to the latest version of Oracle (from 10g to 12c). I would like to know the ...
3
votes
1answer
10k views

Can't open the mysql.plugin table error when installing MySQL on Mac OS Sierra

I am attempting to install MySQL on macOS Sierra 10.12.5. I had a previous (non-functioning) install of MySQL so I followed the steps here to install a clean copy with Homebrew. I had to create a var/...
1
vote
0answers
1k views

Migration from postgres 9.4 to postgres 9.6

I did the migration from PostgreSQL 9.4 to version 9.6, but now the stream replication is not working, it stopped replicating. Script followed: installation of postgres 9.6 on the three servers (...
1
vote
1answer
3k views

Upgrade/Migration from SQL Server 2008 R2 to SQL Server 2016

I have a client that is having plans to upgrade/migrate the SQL Server instances from 2008 R2 to 2012. I have provided the details as below. The environments are all Virtual running OS version Windows ...
11
votes
1answer
450 views

SQLServer Upgrade Advisor 2014 hanging

I try to run SQL Server Upgrade Advisor 2014 against a SQL Server 2008 server. Everything looks fine when connecting to the 2008 server and I can select which database I would like to analyze. But ...
3
votes
1answer
85 views

Is it a good idea to shrink prior to a SQL Server upgrade to a new instance

We currently have a 100GB database which is in simple recovery mode, and it is running on 2008 R2. We have a new server with SQL 2016 Enterprise installed, ready to go - and we're building a migration ...
0
votes
1answer
959 views

Oracle Database Upgrade Assistant "Failed in bringing up..." Error

So I was upgrading 3 databases from 10.2.0.5 to 11.2.0.4. Two of them went just fine. Long story short for the last one, the upgrade was interrupted near the end (let me know if more details are ...
2
votes
2answers
2k views

MySQL 5.6 to 5.7 In-Place Upgrade or Fresh Install?

I'm preparing to migrate a production database server on AWS RDS to 5.7 from version 5.6. I'm not sure that I trust the automatic upgrade service. Obviously, I would make a backup prior to doing ...
0
votes
1answer
65 views

alter table which is under the load (sql server)

we have table that being used for sending sms and other notification for confirmation as second factor. Some changes in business logic requires us to alter table to make some columns NOT NULL. Our ...
0
votes
1answer
564 views

Upgrade Oracle APEX 4.0.2 to 5.1.1 error

I installed Oracle 11g XE on CentOS 7 and everything went fine. I wanted to upgrade APEX to the latest version and followed instructions in Upgrading Oracle Application Express within Oracle Database ...
2
votes
2answers
3k views

Upgrading OS and then upgrading to SQL Server 2016 [closed]

One of my clients would like to have the OS upgraded to Windows 2012 enterprise and then the plan is to upgrade the SQL Server to 2016. I would like to know what would be the steps in doing so and how ...
0
votes
1answer
91 views

Upgrading to SQL Server 2012 from SQL Server 2008 R2

I am planning to upgrade my SQL Server 2008 R2 Standard Edition to SQL Server 2012 Standard Edition. I had been through many blogs on advantages of 2012 but I didn't find any performance comparison ...
1
vote
1answer
1k views

SQL Server 2016 in-place upgrade time for large databases

Is there any statistics on how long it will take to in place upgrade SQL Server 2014 to SQL Server 2016 on a server with 1000+ databases and 10TB of storage? How long it will take to install ...
1
vote
0answers
166 views

How to upgrade versions of postgresql without losing statistics

I'm upgrading from 9.5 to 9.6. Running vacuum analyze on the whole db to regenerate stats is a pain. Is there any way to upgrade and migrate over the statistics so I dont have to regenerate them?
3
votes
1answer
2k views

MySQL Upgrade to 5.7 Crashes at InnoDB: Creating sys_virtual_system_tables

Trying to run an upgrade on a virtual Ubuntu Xenial machine. I'm trying to upgrade from 5.6 to 5.7 using aptitude install mysql-server. All went well until it tried to boot up mysqld which failed. ...
4
votes
0answers
332 views

Performance degradation after upgrade from 3.0.11 to 3.2.12

Environment: CentoOS 6 (kernel 2.6.32), MongoDB community edition 3.0.11 and 3.2.12 , storage engine MMAP, config servers on SCCC We are experiencing performance degradation when moving from 3.0.11 ...
3
votes
1answer
733 views

Tokudb 5.7 [Warning] The partition engine is deprecated and will be removed in a future release

I am running upgrade from Tokudb 5.6.30 to 5.7.17 (Percona distribution) and I am getting this warning [Warning] The partition engine, used by table ‘my_table’, is deprecated and will be removed in ...
2
votes
1answer
4k views

Read concern level of majority error while upgrading Sharded Cluster from 3.2 to 3.4

I have upgraded MongodDB sharded cluster having two replica sets from 3.2 to 3.4. Current storage engine is MMAPv1. After successfully upgrading all the secondary, primary, config server and mongos to ...
3
votes
0answers
39 views

Upgrade PostgreSQL 9.3 without moving the DB and messing PostGIS on OSX OpenGeo Suite original installation

I looked for the answer, but could not find a specifically fitting one, so would appreciate an answer or a pointer to one... Q: How do I upgrade PostgreSQL 9.3 to the current (now 9.6 ?) without ...
4
votes
1answer
457 views

Cluster migration to new hardware, same OS, but SQL Server 2012 to 2016

I have a 3 node cluster running on Windows Server 2012 R2. Two nodes for the databases, the 3rd node is an Always On db used for reporting. I have new hardware built running the same OS, but will need ...
1
vote
0answers
931 views

Mysql 5.7 / Ubuntu14.04.5 LTS in-place upgrade - Package 'mysql-server-5.7' has no installation candidate

I have tried upgrading in-place to Mysql 5.7.x from 5.6.33 as well as directly from 5.5.46 on Ubuntu 14.04.5 LTS, but I keep getting stuck at the same step. I followed this answer successfully to ...
2
votes
1answer
93 views

How to upgrade SQL Server 2008 to 2012 with table partition?

My project is upgrading from SQL Server 2008 to 2012, but old version consisting table partition. is this feature will work same as in 2012 also ?
1
vote
1answer
402 views

Can I skip major versions in pg_upgradecluster?

I'm upgrading postgresql 9.3 to 9.5 on ubuntu/xenial and I would like to know if it is possible to run pg_upgradecluster to go directly from 9.3 to 9.5 or whether I need to go through 9.4 in between?
4
votes
2answers
2k views

Need Help Finding a Replacement for sys.sysprocesses

The SQL 2016 Data Migration Assistant (Upgrade Advisor) is saying that I need to stop using old system table references. Namely, it wants me to stop using sysdatabases and sysprocesses. I have some ...
0
votes
1answer
477 views

How do correct mysqld.log error messages on start up? [duplicate]

I'm running Plesk and CentOS 6.7 Following is the excerpt of the log file mysqld.log when I restart mysqld service. I normally don't check this log file, but I just noticed some errors messages. It ...
4
votes
2answers
3k views

Database Mirroring login attempt failed with error: 'Connection handshake failed. The handshake verification failed. State 36.'

While performing a rolling upgrade of an Availability Group from SQL Server 2016 CU1 to 2016 SP1 we noticed an issue. Immediately after we updated the secondary replica replication stopped working for ...
4
votes
2answers
981 views

Rebuilding large columnstore indexed tables - am I doing it right?

We are planning to move the database from SQL 2014 ENT into 2016 ENT. We realized the data currently in columnstore table are not aligned in time when they are loaded, so we need to re-align the data. ...
1
vote
3answers
3k views

Removing older components after upgrading

I will upgrade to SQL Server 2016 from a SQL Server 2014 in my company. This server has had many versions of SQL Server (2008, 2012, etc). What should we do with the old version's components? When a ...
7
votes
4answers
3k views

Upgrade SQL Server 2016 R Service (in-database)

I am just wondering whether this is doable. I have installed R service (in-database) together with SQL Server 2016 (patched at SP1+ CU1). I notice R service version is at 3.2.2, which you can run the ...

1 2 3
4
5
9