Monday, June 15, 2015

.::: How To Configured Transaction IsolationLevel Level READ_COMMITED! on MySQL Server :::.



1. Get Error on log NMS

2015-06-15 12:06:57,158 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The MySQL Server must be configured for Transaction IsolationLevel Level READ_COMMITED!
2015-06-15 12:06:57,167 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) The StableNet® Server will now exit due to this fatal error!
2015-06-15 12:06:57,174 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,178 ERROR [BootstrapBean] (ServerService Thread Pool -- 60)
2015-06-15 12:06:57,184 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) If this problem occurs again at the same position please
2015-06-15 12:06:57,193 ERROR [BootstrapBean] (ServerService Thread Pool -- 60) contact Infosim GmbH & Co. KG, support@infosim.net, +49 931 205 92 200

2. Add "transaction-isolation = READ-COMMITTED" on my.ini  MySQL
on windows

# Path to installation directory. All paths are usually resolved relative to this.
# basedir="C:/Program Files (x86)/MySQL/MySQL Server 5.6/"

# Path to the database root
datadir=C:/ProgramData/MySQL/MySQL Server 5.6/Data
transaction-isolation = READ-COMMITTED

on Linux
[mysqld]

#
# * Basic Settings
#

user = mysql
port = 3306
basedir = /usr
datadir = /var/lib/mysql
tmpdir = /tmp
transaction-isolation = READ-COMMITTED

3. Restart service MySQL
on windows
net stop mysql
net start mysql

on Linux
/etc/init/mysqld restart

No comments:

Post a Comment

Popular Posts