Ir para conteúdo
  • Cadastre-se
  • 0

ONDE PODE ESTA O ERRO


kamal

Pergunta

Nao consigo ligar o serve sempre aparece esse erro nao estou sabendo identificar alguem poderia me ajudar

 

 

 

Iniciando KingServer Login Server.

 

An attempt to create an automatic test table failed. Create SQL: CREATE TABLE `c

onnection_test_table` ( a CHAR(1) )

java.sql.SQLException: Could not retrieve transation read-only status server

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:950)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:940)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3900)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3871)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2408)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2375)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2359)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP

roxyPreparedStatement.java:147)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:927)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled

ConnectionPool(C3P0PooledConnectionPoolManager.java:809)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:319)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:336)

at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A

bstractPoolBackedDataSource.java:128)

at king.server.L2DatabaseFactory.<init>(L2DatabaseFactory.java:111)

at king.server.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:253)

 

at king.server.loginserver.L2LoginServer.<init>(L2LoginServer.java:99)

at king.server.loginserver.L2LoginServer.main(L2LoginServer.java:62)

Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2738)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1617)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3894)

... 14 more

 

FATAL: Failed initializing database. Reason: Could not retrieve transation read-

only status server

java.sql.SQLException: Could not retrieve transation read-only status server

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:988)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:974)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:919)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:950)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:940)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3900)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3871)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2408)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2375)

at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java

:2359)

at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP

roxyPreparedStatement.java:147)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu

tomaticTestTable(C3P0PooledConnectionPoolManager.java:927)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled

ConnectionPool(C3P0PooledConnectionPoolManager.java:809)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:319)

at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0

PooledConnectionPoolManager.java:336)

at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A

bstractPoolBackedDataSource.java:128)

at king.server.L2DatabaseFactory.<init>(L2DatabaseFactory.java:111)

at king.server.L2DatabaseFactory.getInstance(L2DatabaseFactory.java:253)

 

at king.server.loginserver.L2LoginServer.<init>(L2LoginServer.java:99)

at king.server.loginserver.L2LoginServer.main(L2LoginServer.java:62)

Caused by: java.sql.SQLException: Unknown system variable 'tx_read_only'

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4120)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4052)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2503)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2664)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2788)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2738)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1617)

at com.mysql.jdbc.ConnectionImpl.isReadOnly(ConnectionImpl.java:3894)

... 14 more

 

 

Login Server terminated abnormally!

 

 

Login Server Terminated.

 

Pressione qualquer tecla para continuar. . .

Game Server:.....................V

Loading Server:..............V

Link para o comentário
Compartilhar em outros sites

1 resposta a esta questão

Posts recomendados

Provavelmente pelo erro as configurações do nome da data base está errada ele esta tentando procurar certas tabelas nao esta achando tente restaura o backup novamente colocar tudo como l2jdb para padronizar claro... pode ser o nome nas configs da rec ou ate mesmo no navicat vc tem q verificar estas duas possibilidades ou quando vc restaurou o backup deu alguma falha por qeu dis que está faltando uma table

Um mundo de diversão no Lineage 2

https://www.primeworld.com.br

Discord: Em breve

Comunidade brasileira de Lineage. Interlude Remastered / High Five / Essence 

Classes remasterizadas, sistemas únicos, diversão garantida.

Link para o comentário
Compartilhar em outros sites


Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Visitante
Responder esta pergunta...

×   Você colou conteúdo com formatação.   Remover formatação

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Processando...



×
×
  • Criar Novo...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.