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
0answers
6 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
24 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
38 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
34 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
47 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
36 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
53 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
40 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
283 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
28 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
13 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
219 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
11 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
31 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
28 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
18 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
25 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
31 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
23 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
75 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
99 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
47 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
39 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
96 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
57 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
46 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
319 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
32 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
147 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
241 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
523 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
19 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
26 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
55 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
343 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
9 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 ...
0
votes
0answers
33 views

MySql uncomplated Upgrade Error

I faced showed bellow error every apt upgrade. An mysql server frequently down. I try backup my database with mysqlpump, this backup not contain tables values. Only table construct. How can I fix this ...
1
vote
2answers
85 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
639 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". ...
2
votes
2answers
1k 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
347 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
176 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. * ...
0
votes
2answers
373 views

Upgrade all MySQL columns, tables, and databases from utf8mb3 to utf8mb4

I have thousands of columns across hundreds of tables in about a hundred databases inside a MySQL instance that need to be upgraded from utf8mb3 to utf8mb4. Is there a way to generate ALTER ...
0
votes
1answer
129 views

How to upgrade SQL Server 2016 and 2017 Standard to 2017 Enterprise edition

We have one SQL Server 2016 Standard instance, and two SQL Server 2017 Standard instances installed on the same server. Now my management wants to install SQL Server 2017 Enterprise edition and ...
3
votes
1answer
937 views

Upgrade from Postgres 11 to Postgres 12 made some queries 300x slower, probably due to new CTE handling

My application currently uses PostgreSQL 11.6. Today, I have tested PostgreSQL 12.1 on a virtual machine and the results were shocking: One important query which takes 100ms on version 11 (same VM) ...
1
vote
1answer
20 views

In place upgrade from Express 2005 SP 4 to Express 2014, does database size limitation follow?

We are currently attempting get around a file size limitation issue with our database. The database file size hovers around the 4GB mark (the database size limit is 4GB in SQL Express 2005). We always ...
0
votes
0answers
96 views

AWS Aurora Postgres 9.6 major version upgrade via slony?

The official documentation states that the major in-place version upgrades are not possible. Note Aurora PostgreSQL does not currently support in-place major version upgrades. To migrate a ...
0
votes
1answer
18 views

Upgrading Microsoft SQL 2014 and Always On AG Configurations

I'm getting ready to perform an upgrade from SQL 2014 to 2017 on two servers that are configured for Always On. The concern on the upgrade is how to break Always On to stop replication and to keep any ...
2
votes
0answers
25 views

SQL Server update from GDR to CU-17 [duplicate]

I'm using SQL SERVER 2017 GDR version 14.0.2002.14. I want to upgrade to the latest possible version of SQL Server 2017. My question is can I download CU-17 and directly run the latest cumulative ...

1
2 3 4 5
9