01-09-2010, 05:07 AM
Привет всем.
Такая проблема, ипользю сборку L2Dream.
гейм сервер запускается нормально а вот логин сервер пишет вот это
Запуск LoginServer.
loading login config
L2Properties: Missing property for key - PacketHandlerDebug
L2Properties: Missing property for key - RequestServerID
L2Properties: Missing property for key - AcceptAlternateID
L2Properties: Missing property for key - DatapackRoot
L2Properties: Missing property for key - RouterHostname
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
An attempt to create an automatic test table failed. Create SQL: CREATE TABLE `c
onnection_test_table` ( a CHAR(1) )
java.sql.SQLException: Can't create table 'l2jdb.connection_test_table' (errno:
121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1949)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:813)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getNumThreadsAw
aitingCheckoutDefaultUser(AbstractPoolBackedDataSource.java:203)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.mchange.v2.beans.BeansUtils.extractAccessiblePropertiesToMap(Bean
sUtils.java:359)
at com.mchange.v2.beans.BeansUtils.appendPropNamesAndValues(BeansUtils.j
ava:324)
at com.mchange.v2.c3p0.ComboPooledDataSource.toString(ComboPooledDataSou
rce.java:539)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(
AbstractPoolBackedDataSource.java:462)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at net.sf.l2j.L2DatabaseFactory.<init>(Unknown Source)
at net.sf.l2j.L2DatabaseFactory.getInstance(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.<init>(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.main(Unknown Source)
Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans
.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreads
AwaitingCheckoutDefaultUser] ]
An attempt to create an automatic test table failed. Create SQL: CREATE TABLE `c
onnection_test_table` ( a CHAR(1) )
java.sql.SQLException: Can't create table 'l2jdb.connection_test_table' (errno:
121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1949)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:813)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at net.sf.l2j.L2DatabaseFactory.<init>(Unknown Source)
at net.sf.l2j.L2DatabaseFactory.getInstance(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.<init>(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.main(Unknown Source)
FATAL: Failed initializing database. Reason: Can't create table 'l2jdb.connectio
n_test_table' (errno: 121)
java.sql.SQLException: Can't create table 'l2jdb.connection_test_table' (errno:
121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1949)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:813)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at net.sf.l2j.L2DatabaseFactory.<init>(Unknown Source)
at net.sf.l2j.L2DatabaseFactory.getInstance(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.<init>(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.main(Unknown Source)
LoginServer: Работа сервера завершена некоректно.
LoginServer: Сервер отключен.
Для продолжения нажмите любую клавишу . . .
Такая проблема, ипользю сборку L2Dream.
гейм сервер запускается нормально а вот логин сервер пишет вот это
Запуск LoginServer.
loading login config
L2Properties: Missing property for key - PacketHandlerDebug
L2Properties: Missing property for key - RequestServerID
L2Properties: Missing property for key - AcceptAlternateID
L2Properties: Missing property for key - DatapackRoot
L2Properties: Missing property for key - RouterHostname
MLog clients using java 1.4+ standard logging.
Initializing c3p0-0.9.1.2 [built 21-May-2007 15:04:56; debug? true; trace: 10]
An attempt to create an automatic test table failed. Create SQL: CREATE TABLE `c
onnection_test_table` ( a CHAR(1) )
java.sql.SQLException: Can't create table 'l2jdb.connection_test_table' (errno:
121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1949)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:813)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getNumThreadsAw
aitingCheckoutDefaultUser(AbstractPoolBackedDataSource.java:203)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at com.mchange.v2.beans.BeansUtils.extractAccessiblePropertiesToMap(Bean
sUtils.java:359)
at com.mchange.v2.beans.BeansUtils.appendPropNamesAndValues(BeansUtils.j
ava:324)
at com.mchange.v2.c3p0.ComboPooledDataSource.toString(ComboPooledDataSou
rce.java:539)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getPoolManager(
AbstractPoolBackedDataSource.java:462)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at net.sf.l2j.L2DatabaseFactory.<init>(Unknown Source)
at net.sf.l2j.L2DatabaseFactory.getInstance(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.<init>(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.main(Unknown Source)
Initializing c3p0 pool... com.mchange.v2.c3p0.ComboPooledDataSource [ java.beans
.IntrospectionException: java.lang.reflect.InvocationTargetException [numThreads
AwaitingCheckoutDefaultUser] ]
An attempt to create an automatic test table failed. Create SQL: CREATE TABLE `c
onnection_test_table` ( a CHAR(1) )
java.sql.SQLException: Can't create table 'l2jdb.connection_test_table' (errno:
121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1949)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:813)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at net.sf.l2j.L2DatabaseFactory.<init>(Unknown Source)
at net.sf.l2j.L2DatabaseFactory.getInstance(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.<init>(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.main(Unknown Source)
FATAL: Failed initializing database. Reason: Can't create table 'l2jdb.connectio
n_test_table' (errno: 121)
java.sql.SQLException: Can't create table 'l2jdb.connection_test_table' (errno:
121)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1055)
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:956)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3515)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3447)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1951)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2101)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2554)
at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.ja
va:1761)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:2046)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1964)
at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java
:1949)
at com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewP
roxyPreparedStatement.java:105)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.initializeAu
tomaticTestTable(C3P0PooledConnectionPoolManager.java:813)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.createPooled
ConnectionPool(C3P0PooledConnectionPoolManager.java:696)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:257)
at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPoolManager.getPool(C3P0
PooledConnectionPoolManager.java:271)
at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(A
bstractPoolBackedDataSource.java:128)
at net.sf.l2j.L2DatabaseFactory.<init>(Unknown Source)
at net.sf.l2j.L2DatabaseFactory.getInstance(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.<init>(Unknown Source)
at net.sf.l2j.loginserver.L2LoginServer.main(Unknown Source)
LoginServer: Работа сервера завершена некоректно.
LoginServer: Сервер отключен.
Для продолжения нажмите любую клавишу . . .