Cannot communicate with database server

Tags:

#1 Julius.M. 2 years ago

OS: CentOS Linux release 8.4.2105

DB: usr/libexec/mysqld Ver 8.0.21 for Linux on x86_64 (Source distribution)

my.cnf -> [client] password=asdf Password "asdf" install mysql root user

./dbinit.sh - Done

in /etc/hosts -> 192.168.91.133 localhost.localdomain

[root@localhost db_init]# systemctl status mysqld.service ● mysqld.service - MySQL 8.0 database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2021-09-22 15:59:27 MSK; 9min ago Process: 4119 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS) Process: 4277 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS) Process: 4196 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS) Process: 4171 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 4233 (mysqld) Status: "Server is operational" Tasks: 42 (limit: 49168) Memory: 352.8M CGroup: /system.slice/mysqld.service └─4233 /usr/libexec/mysqld --basedir=/usr

сен 22 15:59:27 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server... сен 22 15:59:27 localhost.localdomain systemd[1]: Started MySQL 8.0 database server.

[root@localhost db_init]# service nxlog-manager status ● nxlog-manager.service - NXLog Manager Loaded: loaded (/usr/lib/systemd/system/nxlog-manager.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2021-09-22 15:58:28 MSK; 11min ago Main PID: 4013 (java) Tasks: 53 (limit: 49168) Memory: 1.5G CGroup: /system.slice/nxlog-manager.service └─4013 /usr/bin/java -Xms1g -Xmx2g -XX:PermSize=64m -XX:MaxPermSize=256m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Dorg.apache.commons.collections.enableUnsa>

Sep 22 16:00:13 localhost.localdomain service.sh[4013]: сен 22, 2021 4:00:13 PM org.apache.jasper.compiler.JDTJavaCompiler setSourceVM Sep 22 16:00:13 localhost.localdomain service.sh[4013]: WARNING: Unknown source VM 1.7 ignored. Sep 22 16:00:14 localhost.localdomain service.sh[4013]: сен 22, 2021 4:00:14 PM org.apache.jasper.compiler.JDTJavaCompiler setTargetVM Sep 22 16:00:14 localhost.localdomain service.sh[4013]: WARNING: Unknown target VM 1.7 ignored.

nxlog-manager.log

2021-09-22 16:23:28,589 WARN localhost.localdomain unknown [com.mchange.v2.resourcepool.BasicResourcePool] - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@487eb16 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception:
java.sql.SQLException: Unknown system variable 'tx_isolation' at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:268) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:296) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:349) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:408) at org.mariadb.jdbc.MySQLConnection.getTransactionIsolation(MySQLConnection.java:410) at com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:120) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:240) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) Caused by: org.mariadb.jdbc.internal.common.QueryException: Unknown system variable 'tx_isolation' at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:995) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1050) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1030) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289) ... 12 more

Permalink

#2 rafDeactivated Nxlog ✓ 2 years ago

#1 Julius.M.

h1, sorry my eng bad. Why do I need to http://192.168.91.133:9090/nxlog-manager when specifying the login "admin" and the password "nxlog123", I get the error " could not contact the database server." OS: CentOS Linux release 8.4.2105 DB: usr/libexec/mysqld Ver 8.0.21 for Linux on x86_64 (Source distribution) my.cnf -> [client] password=asdf Password "asdf" install mysql root user ./dbinit.sh - Done in /etc/hosts -> 192.168.91.133 localhost.localdomain [root@localhost db_init]# systemctl status mysqld.service ● mysqld.service - MySQL 8.0 database server Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2021-09-22 15:59:27 MSK; 9min ago Process: 4119 ExecStopPost=/usr/libexec/mysql-wait-stop (code=exited, status=0/SUCCESS) Process: 4277 ExecStartPost=/usr/libexec/mysql-check-upgrade (code=exited, status=0/SUCCESS) Process: 4196 ExecStartPre=/usr/libexec/mysql-prepare-db-dir mysqld.service (code=exited, status=0/SUCCESS) Process: 4171 ExecStartPre=/usr/libexec/mysql-check-socket (code=exited, status=0/SUCCESS) Main PID: 4233 (mysqld) Status: "Server is operational" Tasks: 42 (limit: 49168) Memory: 352.8M CGroup: /system.slice/mysqld.service └─4233 /usr/libexec/mysqld --basedir=/usr сен 22 15:59:27 localhost.localdomain systemd[1]: Starting MySQL 8.0 database server... сен 22 15:59:27 localhost.localdomain systemd[1]: Started MySQL 8.0 database server. [root@localhost db_init]# service nxlog-manager status ● nxlog-manager.service - NXLog Manager Loaded: loaded (/usr/lib/systemd/system/nxlog-manager.service; enabled; vendor preset: disabled) Active: active (running) since Wed 2021-09-22 15:58:28 MSK; 11min ago Main PID: 4013 (java) Tasks: 53 (limit: 49168) Memory: 1.5G CGroup: /system.slice/nxlog-manager.service └─4013 /usr/bin/java -Xms1g -Xmx2g -XX:PermSize=64m -XX:MaxPermSize=256m -Xss2m -XX:+UseConcMarkSweepGC -XX:+CMSClassUnloadingEnabled -Dorg.apache.commons.collections.enableUnsa> Sep 22 16:00:13 localhost.localdomain service.sh[4013]: сен 22, 2021 4:00:13 PM org.apache.jasper.compiler.JDTJavaCompiler setSourceVM Sep 22 16:00:13 localhost.localdomain service.sh[4013]: WARNING: Unknown source VM 1.7 ignored. Sep 22 16:00:14 localhost.localdomain service.sh[4013]: сен 22, 2021 4:00:14 PM org.apache.jasper.compiler.JDTJavaCompiler setTargetVM Sep 22 16:00:14 localhost.localdomain service.sh[4013]: WARNING: Unknown target VM 1.7 ignored. nxlog-manager.log 2021-09-22 16:23:28,589 WARN localhost.localdomain unknown [com.mchange.v2.resourcepool.BasicResourcePool] - com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask@487eb16 -- Acquisition Attempt Failed!!! Clearing pending acquires. While trying to acquire a needed new resource, we failed to succeed more than the maximum number of allowed acquisition attempts (30). Last acquisition attempt exception: java.sql.SQLException: Unknown system variable 'tx_isolation' at org.mariadb.jdbc.internal.SQLExceptionMapper.get(SQLExceptionMapper.java:149) at org.mariadb.jdbc.internal.SQLExceptionMapper.throwException(SQLExceptionMapper.java:106) at org.mariadb.jdbc.MySQLStatement.executeQueryEpilog(MySQLStatement.java:268) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:296) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:349) at org.mariadb.jdbc.MySQLStatement.executeQuery(MySQLStatement.java:408) at org.mariadb.jdbc.MySQLConnection.getTransactionIsolation(MySQLConnection.java:410) at com.mchange.v2.c3p0.impl.NewPooledConnection.<init>(NewPooledConnection.java:120) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:240) at com.mchange.v2.c3p0.WrapperConnectionPoolDataSource.getPooledConnection(WrapperConnectionPoolDataSource.java:206) at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource(C3P0PooledConnectionPool.java:203) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquire(BasicResourcePool.java:1138) at com.mchange.v2.resourcepool.BasicResourcePool.doAcquireAndDecrementPendingAcquiresWithinLockOnSuccess(BasicResourcePool.java:1125) at com.mchange.v2.resourcepool.BasicResourcePool.access$700(BasicResourcePool.java:44) at com.mchange.v2.resourcepool.BasicResourcePool$ScatteredAcquireTask.run(BasicResourcePool.java:1870) at com.mchange.v2.async.ThreadPoolAsynchronousRunner$PoolThread.run(ThreadPoolAsynchronousRunner.java:696) Caused by: org.mariadb.jdbc.internal.common.QueryException: Unknown system variable 'tx_isolation' at org.mariadb.jdbc.internal.mysql.MySQLProtocol.getResult(MySQLProtocol.java:995) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1050) at org.mariadb.jdbc.internal.mysql.MySQLProtocol.executeQuery(MySQLProtocol.java:1030) at org.mariadb.jdbc.MySQLStatement.execute(MySQLStatement.java:289) ... 12 more

Hey Julius,

Would you mind contacting our Presales Team for help? The community forum is focused on NXLog Community Edition, so catching Presales Team (or Support Team, in case of current customers) is the best way to get help.

Thanks!
Raf