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
0
votes
1answer
18 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 ...
0
votes
1answer
26 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 ...
1
vote
1answer
62 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 ...
0
votes
0answers
25 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 (...
0
votes
2answers
114 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 ...
0
votes
1answer
16 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 ...
1
vote
1answer
16 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 ...
0
votes
1answer
20 views

MySQL upgrade via mysqldump

We want to upgrade to MySQL 8.0 from MySQL 5.6 but upgrade manual seems to cumbersome and risky to follow doing an in-place upgrade so we have decided to do it via MySQL Workbench export (mysqldump) ...
0
votes
0answers
13 views

Why all instances of PostgreSQL are not listed in stackbuikder (enterpriseDB)?

On a windows server 2012, There are two instances of PostgreSQL 11.5. The first in running on port 5432 and was created with EnterpriseDB installer. The second was created manualy with initdb then ...
0
votes
1answer
1k views

“ORA-03146: invalid buffer length for TTC field” after upgrade from Oracle 12 to 19c

We are experiencing problems with updating a table record BLOB column. We get the "ORA-03146: invalid buffer length for TTC field" error. We basically are saving e.g. PDF attachments to the ...
0
votes
1answer
106 views

Unable to upgrade to postgresql 13

I'm getting the following error: postgres@:~/>cat loadable_libraries.txt could not load library "$libdir/plpython2": ERROR: could not access file "$libdir/plpython2": No such ...
0
votes
1answer
49 views

Why does the SQL Server build number sequence not correlate with the release date sequence?

I'm looking at the Microsoft SQL Server 2016 Builds (see that section heading). The list of builds is given in build number order. That is, at the top of the list is the "highest" build ...
1
vote
3answers
50 views

Not able to install any DB2 LUW 10.5 fixpacks

I am currently on Fixpack 1 and am trying to install ANY more recent fixpack. All of them refuse to apply themselves with similar errors. The one below is from Fixpack 2 file v10.5fp2_ntx64_server. ...
1
vote
0answers
47 views

Horrible MySQL database performance after upgrading from 5.5 to 5.6

I have run into a performance problem that I don't know how to solve with MySQL after Amazon forced us to upgrade our 5.5 MySQL instance to 5.6. We have a stored procedure which executed in about 10 ...
0
votes
1answer
118 views

pg_upgrade from Postgres 9.5.5 to Postgres 12.3 errors out

I am trying to upgrade the database cluster from 9.5.5 to 12.3 using pg_upgrade. I ran it with the --check option, and the result came back "clusters compatible", but when I run it with the -...
0
votes
1answer
68 views

Drop tables but space not claimed in postgres 12

I have upgraded Postgresql 9.5 to Postgresql 12.4 a few days back using pg_upgrade utility with link (-k) option. So basically I am having two data directories i.e. One is old data directory (v9.5) ...
8
votes
2answers
288 views

Inability to query underlying table of a schema-bound view

I migrated a database from SQL Server 2008R2 to SQL Server 2019 (both Enterprise Edition) using the backup-restore technique, and a set of post-transfer actions like DBCC UPDATEUSAGE or UPDATE ...
0
votes
1answer
58 views

SQL Server 2016 (SP2-GDR) - correct upgrading path

I've found in my organization VM with SQL Server 2016 (SP2-GDR) (KB4532097) - 13.0.5102.14 (X64), which I would like to patch to the latest available version. Can I just install CU15 (KB4577775) on it ...
0
votes
0answers
17 views

Restore from ibd files where is no frm files [duplicate]

I had an Ubuntu 18.04 with mysql 5.7. I upgraded it to Ubuntu 20.04 with mysql 8.x. But this 8.x not was compatible with my Drupal 7 and I tried to downgrade. After this I tried with a 5.7 docker ...
1
vote
3answers
994 views

Can we downgrade from 19c to 12.1.0 if the compatibility is set to 12.2.0

Team: Recently i upgraded a 12.1.0 database to 19c (non CDB architecture). Current compatibility is set to 12.2.0. Can I downgrade it to the earlier version - 12.1.0? Documentation states the ...
0
votes
1answer
16 views

mysql upgrade from 5.6 to 5.7, how to config mysql backup

we have a lot of mysql database running from 5.6 to 5.7 , we use netbackup to backup mysql , the local script (mysql_backup.sh) is as belows: /opt/mysql/meb-4.1.3/bin/mysqlbackup --login-path=root -...
0
votes
0answers
40 views

Mongodb Upgrade from 1.8.2 to 4.4

I would like to upgrade Mongodb version 1.8.2 with replica set available ( 1 primary, 2 secondary) with same version to version 4.4 with no downtime. What are the steps do I need to follow in order to ...
0
votes
1answer
49 views

Transactional replication upgrade from SQL Server 2017

We would like to inplace upgrade of transactional replication topology from SQL Server 2017 to SQL2019 with minimal downtime. The following is the setup. All the all current instances are on SQL ...
0
votes
0answers
20 views

MongoDB 3.6 fresh install

I'm using mongodb 3.6.18 I'm running a cluster of 2 shards and 1 config replicaset. I get this error when trying to set the compatibility version to 3.6: global:PRIMARY> db.adminCommand( { ...
0
votes
0answers
41 views

Mysql_upgrade fails when running from Xampp

Recently I had to reinstall Xampp and I added some older databases to MySQL after which all seemed to run just fine. Now, a few months later, I got an error while using IsNumeric in a query, and was ...
0
votes
1answer
34 views

Why has my root password changed after I updated MySQL from 5.7 to 8.0?

I have set my root account passwords like this: mysql -u root SET PASSWORD FOR 'root'@'localhost' = PASSWORD('pswd1'); SET PASSWORD FOR 'root'@'127.0.0.1' = PASSWORD('pswd2'); SET PASSWORD FOR 'root'@'...
1
vote
2answers
24 views

in-place upgrade native SSRS without the SQL Server portion

We have a single server (2012R2) running SQL 2008R2 + reporting services native mode 2008R2 Can the reporting services portion be upgraded alone without the database engine? Or can the SSRS db be ...
0
votes
1answer
120 views

Cannot upgrade to v12 due to sql_identifier data type

I am attempted to upgrade Postgres 11.8 to 12.3 on an AWS RDS instance. The upgrade fails with the following error: Your installation contains the "sql_identifier" data type in user tables ...
1
vote
0answers
24 views

Is it bad practice to leave the master database at a lower compatibility level after an in-place upgrade? [duplicate]

Based on this documentation, Microsoft intentionally leaves the master database at the previous compatibility level after an in-place upgrade. I recently performed an in-place upgrade from 2012 to ...
3
votes
0answers
120 views

RDS MSSQL in-place upgrade how to update master db compatibility level when rdsa account is db owner

Background My workplace infrastructure team ran a typical in-place upgrade of an RDS MSSQL instance to update the version from 2012 to 2017. After the upgrade, while logged in as the "master ...
0
votes
1answer
86 views

Databases lost after Postgres upgrade from 11 to 12

This is not my first upgrade. In the past I upgraded from 9 to 10 and 10 to 11. I thought that I wrote everything down the last time but apparently not. In verion 11 my databases are in nl_BE.utf-8: ...
0
votes
0answers
65 views

upgrade from 9.4 to 9.6 using pg_upgrade fails

I'm using pg_upgrade to upgrade postgresql from 9.4 to 9.6.Both versions are installed on windows server 2016.I followed the steps described in https://www.postgresql.org/docs/current/pgupgrade.html. ...
1
vote
1answer
209 views

Query performance degraded after upgrading Postgres

I have a table with several million records in a PostgreSQL 12 database, and after an upgrade from 11 to 12, a few queries started performing horribly. They went from taking ~1 second to ~5 minutes. I ...
1
vote
0answers
79 views

AWS RDS upgrade from 8.0.11 to 8.0.19 fails

I am trying to upgrade an RDS database from 8.0.11 to 8.0.17. or 8.0.19. I started by creating a snapshot, restoring that snapshot, and then trying to upgrade to 8.0.17. The upgrade says it was ...
0
votes
1answer
57 views

Need to upgrade SQL Server from 2012 to 2017 on a Server 2008 box

I have been asked to upgrade SQL Server from 2012 to 2017, it is currently installed on a server with Windows 2008 OS. My thinking from what I've researched is this: Take a snapshot of the server ...
3
votes
2answers
475 views

After upgrade to SQL Server 2019 some stored procedures fail

We just upgraded from SQL Server 2008 R2 to SQL Server 2019(Compability lvl 150). We have two different stored procedures that started failing after the upgrade, with error messages like this: Msg ...
0
votes
1answer
39 views

Performing an upgrade of the database

I need to upgrade from PostgreSQL 9.2.24 to 12. However, once the upgrade was complete, I see that the size of the data directory for the old and new one is different. The old one (/var/lib/pgsql/data)...
0
votes
1answer
215 views

SQL Server Standard 2016 Service Pack and Cumulative Update [duplicate]

We are currently using SQL Server 2016 Standard Edition with ALWAYS-ON High Availability. We have two different clusters of SQL servers. We need to update it to the latest version of SQL (As per my ...
0
votes
0answers
534 views

Is there a way to automatically upgrade DBeaver?

I am trying to update DBeaver Community Edition 7.0.3 to (currently) newest 7.1.0 edition on Fedora 30. When I start DBeaver a "Version Update" window pops up with buttons as options to Upgrade and ...
6
votes
4answers
1k views

SQL Server 2019 performance worse than 2012… am I missing something?

We have a SQL Server 2012 server which far outperforms a SQL Server 2019 database on (as far as I can see) the same infrastructure. We are hosting both databases on a cloud platform with the same SLAs....
0
votes
0answers
29 views

Backup and upgrade MongoDB databases

I have a web application using MongoDB (Version 2.6.12), hosted in a (Ubuntu 16.04) server of DigitalOcean. I like to use Robo 3T to connect to the remote database and do simple queries. Sometimes I ...
0
votes
1answer
32 views

Update to MySQL 5.7 and high disk space consumption [closed]

Using: MySQL 5.6 on Debian 9, total DB size is around 450GB Updated to 5.7, ran mysql_upgrade, noticed that around 150 GB has been taken up. 2 tables are really large and they stayed in 'copying to ...
0
votes
1answer
56 views

User info retrieval takes too long - ASP.NET Membership

I have an application that has been taken from a sharepoint user control and converted to plain web pages. Everything is working fine - I can sign up and retrieve my password, etc. However, when I try ...
1
vote
1answer
498 views

Unable to start SQL Server Integration Services 12.0 service (SQL Server 2014) after upgrade to SQL Server 2019 and patched to CU4

I upgraded a SQL Server 2014 Standard instance to SQL Server 2019 Standard (also required upgrading the OS from Windows Server 2012 R2 to Windows Server 2019), and then patched to CU4. During the SQL ...
1
vote
0answers
10 views

Upgrading Debian version of PXC production cluster

I have a 3 node PXC 5.7 cluster behind a ProxySQL instance. The cluster is still running on Debian 8. I have setup recently a testing PXC 5.7 cluster with a copy of the database on Debian 10 without ...
1
vote
2answers
117 views

Best way to backup PostgreSQL cluster before upgrade

I noticed that PGDATA folder changes during an upgrade (which is normal as I use the pg_upgrade --links command), but I don't know the best way to backup up my cluster before the upgrade in order to ...
0
votes
1answer
938 views

LRM-00101: unknown parameter name '_first_spare_parameter'

I am part-way through an upgrade from Oracle 11g to 18c on RedHat. The Database Upgrade Assistant gives the message: Errors encountered during the execution of "Database Components Upgrade". ...
3
votes
2answers
2k views

Eliminating OIDs while upgrading PostgreSQL from 9.4 to 12

I'm currently running PostgreSQL 9.4 in my production environment, but we're in the process of doing an OS upgrade on the server so I thought it might be time to upgrade our PostgreSQL version to the ...
0
votes
1answer
530 views

Mongo E11000 duplicate key error collection after mongo 3.4 to 3.6 upgrade

I have a Mongo replica set on Ubuntu with three members configured for my information system and am having issues when I try to upgrade MongoDB from version 3.4 to 3.6 After setting the "...
0
votes
1answer
230 views

Error during upgrade : Oracle 11g to 12c

While upgrading catupgrade.sql, we are getting below error. Due to errors found during the upgrade process, the post upgrade actions in catuppst.sql have not been automatically run. * ...

1
2 3 4 5
9