My Oracle Support Banner

New Installation on 4.1.x Fails With MySQL Error "''@@tx_isolation' is deprecated" (Doc ID 2648200.1)

Last updated on NOVEMBER 09, 2023

Applies to:

Oracle Communications Session Monitor - Version 4.1 and later
Information in this document applies to any platform.

Symptoms

During installation of OCSM the PSA database does not get initialized due to an deprecated variable being used:

mysql.connector.errors.DatabaseError: 1287: '@@tx_isolation' is deprecated and will be removed in a future release. Please use '@@transaction_isolation' instead

OCSM Version: 4.1.0.6

MySQL Server:
mysql-commercial-server-5.7.29-1.1.el7.x86_64
mysql-commercial-libs-5.7.29-1.1.el7.x86_64
mysql-commercial-client-5.7.29-1.1.el7.x86_64
mysql-commercial-common-5.7.29-1.1.el7.x86_64
mysql-commercial-libs-compat-5.7.29-1.1.el7.x86_64

Changes

New installation of OCSM Release 4.1.x and MySQL Server Version 5.7.29

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.