-
Новые темы в этом разделе публикуются автоматически при добавлении файла в менеджер ресурсов.
Ручное создание новых тем невозможно.
У меня таже проблема ант есть примение среды настроил в чем может бить проблема?
читать умеешь? посмотри как xml файл называется,и какой в батнике прописан
тебе консоль говорит что нет там ни какого файла local.xml
розобрался
Подскажите в чем проблема sql не заливается в бд
Starting Lineage II - GameServer(High Five).
22:07:39 [main] INFO StdSchedulerFactory - Using default implementation for Thr
eadExecutor
22:07:39 [main] INFO SimpleThreadPool - Job execution threads will use class lo
ader of thread: main
22:07:39 [main] INFO SchedulerSignalerImpl - Initialized Scheduler Signaller of
type: class org.quartz.core.SchedulerSignalerImpl
22:07:39 [main] INFO QuartzScheduler - Quartz Scheduler v.2.2.2 created.
22:07:39 [main] INFO RAMJobStore - RAMJobStore initialized.
22:07:39 [main] INFO QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v
2.2.2) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persis
tence. and is not clustered.
22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler 'DefaultQuartzSched
uler' initialized from default resource file in Quartz package: 'quartz.properti
es'
22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler version: 2.2.2
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - Revision: ................ -1
22:07:39 [main] INFO GameServer - Build date: .............. -1
22:07:39 [main] INFO GameServer - Compiler version: ........ 1.8.0_171-b11 (Ora
cle Corporation)
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - ================== Configuration ============
====
22:07:40 [main] INFO Reflections - Reflections took 827 ms to scan 2 urls, prod
ucing 315 keys and 4589 values
22:07:40 [main] INFO ConfigLoader - Loading CClassMasterConfig config.
22:07:40 [main] INFO ConfigLoader - Loading FormulasConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OlympiadConfig config.
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - Olymp
iadPointTransfer is null
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - addCu
stomEffect is null
22:07:40 [main] INFO ConfigLoader - Loading AllSettingsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PvpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AiConfig config.
22:07:40 [main] INFO ConfigLoader - Loading EventsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AcpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BaseProtectSetting config.
22:07:40 [main] INFO ConfigLoader - Loading ResidenceConfig config.
22:07:40 [main] ERROR ConfigParser - class : ResidenceConfig : value name - Cast
leResetFlags is null
22:07:40 [main] INFO ConfigLoader - Loading CRatingConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CServiceConfig config.
22:07:40 [main] INFO ConfigLoader - Loading SpoilConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ServerConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBasicConfig config.
22:07:40 [main] INFO ConfigLoader - Loading TelnetConfig config.
22:07:40 [main] INFO ConfigLoader - Loading GeodataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OtherConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BossConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBufferConfig config.
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onTvt
is null
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onCtf
is null
22:07:40 [main] INFO ConfigLoader - Loading ServicesConfig config.
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_ITEMS is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_COSTUMES is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_FOR_VISUAL_ITEMS is null
22:07:40 [main] INFO ConfigLoader - Loading CTeleportConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ExtConfig config.
22:07:40 [main] INFO ConfigLoader - Loading L2TopConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PtsDataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading JtsProtectionConfig config.
22:07:40 [main] INFO AbuseWorldsConfigParser - abusewords.txt loaded 18 abuse w
ords.
22:07:40 [main] INFO GmAccessConfigParser - GMAccess.xml
22:07:40 [main] INFO GmAccessConfigParser - event_manager.xml
22:07:40 [main] INFO GmAccessConfigParser - full.xml
22:07:40 [main] INFO GmAccessConfigParser - marshal.xml
22:07:40 [main] INFO GmAccessConfigParser - moderator.xml
22:07:40 [main] INFO GmAccessConfigParser - sheriff.xml
22:07:40 [main] INFO GameServer - =============== end Configuration ===========
====
22:07:40 [main] INFO ServerOpcodeManager - ServerOpcodeManager: load ServerPack
ets=215, and Extended(FE)=230
22:07:40 [main] INFO HikariDataSource - HikariPool-1 - Started.
22:07:41 [main] INFO DatabaseFactory - Database connection working.
22:07:41 [main] INFO DatabaseInstaller - Installing tables in database.
22:07:41 [main] INFO VersionPrinter - Flyway 4.0 by Boxfuse
22:07:41 [main] INFO DbSupportFactory - Database: jdbc:mysql://localhost:3306/1
?characterEncoding=utf-8 (MySQL 5.5)
22:07:41 [main] INFO DbMigrate - Current version of schema `1`: 1.1
Exception in thread "main" org.flywaydb.core.api.FlywayException: Schema `1` con
tains a failed migration to version 1.1 !
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:218)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
22:07:39 [main] INFO StdSchedulerFactory - Using default implementation for Thr
eadExecutor
22:07:39 [main] INFO SimpleThreadPool - Job execution threads will use class lo
ader of thread: main
22:07:39 [main] INFO SchedulerSignalerImpl - Initialized Scheduler Signaller of
type: class org.quartz.core.SchedulerSignalerImpl
22:07:39 [main] INFO QuartzScheduler - Quartz Scheduler v.2.2.2 created.
22:07:39 [main] INFO RAMJobStore - RAMJobStore initialized.
22:07:39 [main] INFO QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v
2.2.2) 'DefaultQuartzScheduler' with instanceId 'NON_CLUSTERED'
Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
NOT STARTED.
Currently in standby mode.
Number of jobs executed: 0
Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persis
tence. and is not clustered.
22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler 'DefaultQuartzSched
uler' initialized from default resource file in Quartz package: 'quartz.properti
es'
22:07:39 [main] INFO StdSchedulerFactory - Quartz scheduler version: 2.2.2
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - Revision: ................ -1
22:07:39 [main] INFO GameServer - Build date: .............. -1
22:07:39 [main] INFO GameServer - Compiler version: ........ 1.8.0_171-b11 (Ora
cle Corporation)
22:07:39 [main] INFO GameServer - =============================================
====
22:07:39 [main] INFO GameServer - ================== Configuration ============
====
22:07:40 [main] INFO Reflections - Reflections took 827 ms to scan 2 urls, prod
ucing 315 keys and 4589 values
22:07:40 [main] INFO ConfigLoader - Loading CClassMasterConfig config.
22:07:40 [main] INFO ConfigLoader - Loading FormulasConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OlympiadConfig config.
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - Olymp
iadPointTransfer is null
22:07:40 [main] ERROR ConfigParser - class : OlympiadConfig : value name - addCu
stomEffect is null
22:07:40 [main] INFO ConfigLoader - Loading AllSettingsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PvpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AiConfig config.
22:07:40 [main] INFO ConfigLoader - Loading EventsConfig config.
22:07:40 [main] INFO ConfigLoader - Loading AcpConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BaseProtectSetting config.
22:07:40 [main] INFO ConfigLoader - Loading ResidenceConfig config.
22:07:40 [main] ERROR ConfigParser - class : ResidenceConfig : value name - Cast
leResetFlags is null
22:07:40 [main] INFO ConfigLoader - Loading CRatingConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CServiceConfig config.
22:07:40 [main] INFO ConfigLoader - Loading SpoilConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ServerConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBasicConfig config.
22:07:40 [main] INFO ConfigLoader - Loading TelnetConfig config.
22:07:40 [main] INFO ConfigLoader - Loading GeodataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading OtherConfig config.
22:07:40 [main] INFO ConfigLoader - Loading BossConfig config.
22:07:40 [main] INFO ConfigLoader - Loading CBufferConfig config.
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onTvt
is null
22:07:40 [main] ERROR ConfigParser - class : CBufferConfig : value name - onCtf
is null
22:07:40 [main] INFO ConfigLoader - Loading ServicesConfig config.
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_ITEMS is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_COSTUMES is null
22:07:40 [main] ERROR ConfigParser - class : ServicesConfig : value name - VISUA
L_DISALLOWED_FOR_VISUAL_ITEMS is null
22:07:40 [main] INFO ConfigLoader - Loading CTeleportConfig config.
22:07:40 [main] INFO ConfigLoader - Loading ExtConfig config.
22:07:40 [main] INFO ConfigLoader - Loading L2TopConfig config.
22:07:40 [main] INFO ConfigLoader - Loading PtsDataConfig config.
22:07:40 [main] INFO ConfigLoader - Loading JtsProtectionConfig config.
22:07:40 [main] INFO AbuseWorldsConfigParser - abusewords.txt loaded 18 abuse w
ords.
22:07:40 [main] INFO GmAccessConfigParser - GMAccess.xml
22:07:40 [main] INFO GmAccessConfigParser - event_manager.xml
22:07:40 [main] INFO GmAccessConfigParser - full.xml
22:07:40 [main] INFO GmAccessConfigParser - marshal.xml
22:07:40 [main] INFO GmAccessConfigParser - moderator.xml
22:07:40 [main] INFO GmAccessConfigParser - sheriff.xml
22:07:40 [main] INFO GameServer - =============== end Configuration ===========
====
22:07:40 [main] INFO ServerOpcodeManager - ServerOpcodeManager: load ServerPack
ets=215, and Extended(FE)=230
22:07:40 [main] INFO HikariDataSource - HikariPool-1 - Started.
22:07:41 [main] INFO DatabaseFactory - Database connection working.
22:07:41 [main] INFO DatabaseInstaller - Installing tables in database.
22:07:41 [main] INFO VersionPrinter - Flyway 4.0 by Boxfuse
22:07:41 [main] INFO DbSupportFactory - Database: jdbc:mysql://localhost:3306/1
?characterEncoding=utf-8 (MySQL 5.5)
22:07:41 [main] INFO DbMigrate - Current version of schema `1`: 1.1
Exception in thread "main" org.flywaydb.core.api.FlywayException: Schema `1` con
tains a failed migration to version 1.1 !
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:218)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
Последнее редактирование модератором:
так текст ошибки при добавлении запросов в бд можно?
Да блин, вы рофлите чтоль? Только что обсуждали мой трид. Да и вроде на 5.5 не стартанёт. Хотя судя по еррору, там трабла с контролем версий.
Хз, даже после шары jts, с юнити уходить не собираюсь, хоть и лосты мне больше нравятся.
Последнее редактирование модератором:
поставь более свежую версия mysql и проверь драйвер какой используется для подключения (в конфиге)
Поставил mysql 5.7 вот ошибки
18:41:46 [main] WARN JdbcTemplate - DB: Cannot add foreign key constraint (SQL
State: HY000 - Error Code: 1215)
18:41:46 [main] ERROR DbMigrate - Migration of schema `1` to version 1.1 - Add c
haracter tables failed! Please restore backups and roll back database and code!
Exception in thread "main" org.flywaydb.core.internal.dbsupport.FlywaySqlScriptE
xception:
Migration V1_1__Add_character_tables.sql failed
-----------------------------------------------
SQL State : HY000
Error Code : 1215
Message : Cannot add foreign key constraint
Location : sql/V1_1__Add_character_tables.sql (D:\classika\gameserver\sql\V1_1
__Add_character_tables.sql)
Line : 68
Statement : CREATE TABLE `character_mail` (
`char_id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`is_sender` tinyint(1) NOT NULL,
PRIMARY KEY (`char_id`,`message_id`),
KEY `message_id` (`message_id`),
FOREIGN KEY (`message_id`) REFERENCES `mail` (`message_id`) ON DELETE CASCADE
) ENGINE=InnoDB
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:117)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(
SqlMigrationExecutor.java:71)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java
:352)
at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigr
ate.java:308)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate
.java:305)
at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:230)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
Caused by: java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatem
ent.java)
at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(Jd
bcTemplate.java:238)
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:114)
... 18 more
Логин сервер
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@594a11, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1314)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@1ad2aa7, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1315)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [main] INFO DbMigrate - Successfully applied 1 migration to schema `1`
(execution time 00:03.357s).
State: HY000 - Error Code: 1215)
18:41:46 [main] ERROR DbMigrate - Migration of schema `1` to version 1.1 - Add c
haracter tables failed! Please restore backups and roll back database and code!
Exception in thread "main" org.flywaydb.core.internal.dbsupport.FlywaySqlScriptE
xception:
Migration V1_1__Add_character_tables.sql failed
-----------------------------------------------
SQL State : HY000
Error Code : 1215
Message : Cannot add foreign key constraint
Location : sql/V1_1__Add_character_tables.sql (D:\classika\gameserver\sql\V1_1
__Add_character_tables.sql)
Line : 68
Statement : CREATE TABLE `character_mail` (
`char_id` int(11) NOT NULL,
`message_id` int(11) NOT NULL,
`is_sender` tinyint(1) NOT NULL,
PRIMARY KEY (`char_id`,`message_id`),
KEY `message_id` (`message_id`),
FOREIGN KEY (`message_id`) REFERENCES `mail` (`message_id`) ON DELETE CASCADE
) ENGINE=InnoDB
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:117)
at org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(
SqlMigrationExecutor.java:71)
at org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java
:352)
at org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigr
ate.java:308)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate
.java:305)
at org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.ja
va:47)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:230)
at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
at org.flywaydb.core.Flyway.execute(Flyway.java:1361)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.gameserver.GameServer.<init>(GameServer.java:129)
at org.mmocore.gameserver.GameServer.main(GameServer.java:324)
Caused by: java.sql.SQLException: Cannot add foreign key constraint
at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:957)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3878)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3814)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2478)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2625)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2547)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2505)
at com.mysql.jdbc.StatementImpl.executeInternal(StatementImpl.java:840)
at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:740)
at com.zaxxer.hikari.pool.ProxyStatement.execute(ProxyStatement.java:95)
at com.zaxxer.hikari.pool.HikariProxyStatement.execute(HikariProxyStatem
ent.java)
at org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(Jd
bcTemplate.java:238)
at org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:114)
... 18 more
Логин сервер
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@594a11, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1314)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [HikariPool-1 housekeeper] WARN ProxyLeakTask - Connection leak detect
ion triggered for com.mysql.jdbc.JDBC4Connection@1ad2aa7, stack trace follows
java.lang.Exception: Apparent connection leak detected
at org.flywaydb.core.internal.util.jdbc.JdbcUtils.openConnection(JdbcUti
ls.java:50)
at org.flywaydb.core.Flyway.execute(Flyway.java:1315)
at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
at org.mmocore.commons.database.installer.DatabaseInstaller.start(Databa
seInstaller.java:26)
at org.mmocore.authserver.AuthServer.<init>(AuthServer.java:35)
at org.mmocore.authserver.AuthServer.main(AuthServer.java:96)
18:41:00 [main] INFO DbMigrate - Successfully applied 1 migration to schema `1`
(execution time 00:03.357s).
скайп в личку напиши
Пропиши в dataSource.url =
в место родного кода вот так:
jdbc:mysql://localhost/имя_базы?useUnicode=true&characterEncoding=utf-8
И ошибка исчезнет!Тоже была ошибка на 5.7 как и в теме поправил конект и все завелось!
Можно с портом можно без и так и так будет работать если порт используешь по умолчанию.
А так по конфигам лажа то не вывели в конфиг то дублированные к примеру в olympiad.json 2а раза указан параметр "OlympiadDeleteCubics" с true и false
и в него же не вывели вот эти данные:
В community/communityBuffer.json забыли прописать эти параметры.
Так же в residence.json
в место родного кода вот так:
jdbc:mysql://localhost/имя_базы?useUnicode=true&characterEncoding=utf-8
И ошибка исчезнет!Тоже была ошибка на 5.7 как и в теме поправил конект и все завелось!
Можно с портом можно без и так и так будет работать если порт используешь по умолчанию.
А так по конфигам лажа то не вывели в конфиг то дублированные к примеру в olympiad.json 2а раза указан параметр "OlympiadDeleteCubics" с true и false
и в него же не вывели вот эти данные:
Код:
@Setting(name = "OlympiadDeleteCubics")
public static boolean OLYMPIAD_DELETE_CUBICS;
@Setting(name = "OlympiadPointTransfer")
public static boolean OLYMPIAD_POINT_TRANSFER;
@Setting(name = "OlympiadPointTransferTime", canNull = true)
public static int[] OLYMPIAD_POINT_TRANSFER_TIMES = new int[0];
public static boolean addCustomEffect;В community/communityBuffer.json забыли прописать эти параметры.
Код:
public static boolean onTvt;
public static boolean onCtf;Так же в residence.json
Код:
@Setting(name = "CastleSiegePeriod")
public static int CASTLE_SIEGE_PERIOD;
Последнее редактирование:
Да сам думаю перейти. Давно приглядываюсь, не как не отвыкну от старой дурной привычки на стандартном mysql.
Наверно тоже посмотрю что оно такое, а то давно все рекомендуют особенно под линукс часто наталкивался на советы по MariaDB.
А так в целом зашел сборка не плохая есть ошибки но они не критичны. И в основном от незнания сборки. Чуть полазить и пошаманить и все будет гуд)
Мало того, что юзаю марию, так еще и прикрутил их конетор, полёт нормальный. Я хз что у вас за траблы там.
жтс из коробки заводится нормально.
аналогично, стоит 5,5 mysql были не большие траблы с java( просило по кд поставить JDK) решилось простым указанием пути до явы
Хз, батники не юзал, запускал через идею.
Да по сути проблем не у кого из тех кто привык думать а не просить и нет. Там дел на пару минут, разобраться в вылезших при первом запуске ошибках и пару минут на решить их!
А по драйверу коннекторе для MariaDB вы подключали mariadb-java-client-2.2.5-sources ?
dataSource.url = jdbc:mariadb://localhost:3306/game_database?characterEncoding=utf-8
dataSourceClassName = org.mariadb.jdbc.MariaDbDataSource
А по драйверу коннекторе для MariaDB вы подключали mariadb-java-client-2.2.5-sources ?
dataSource.url = jdbc:mariadb://localhost:3306/game_database?characterEncoding=utf-8
dataSourceClassName = org.mariadb.jdbc.MariaDbDataSource
Последнее редактирование:
