[core] ERROR WorldStatisticsManager: Failed update char World Statistics. (DUBLICATE) - L2-scripts Форум

l2gold · 21.12.2012, 14:34

тоже куча ошибпок - писали пофиксили, а не пофикшено

[13:38:59] ERROR WorldStatisticsManager: Failed update char World Statistics.
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'timeInParty' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2359)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at l2s.gameserver.model.worldstat.WorldStatistic.upda teStatsInDb(WorldStatistic.java:181)
at l2s.gameserver.instancemanager.WorldStatisticsMana ger.updateAllStatsInDb(WorldStatisticsManager.java :519)
at l2s.gameserver.taskmanager.tasks.TaskWorldStatisti csSave.onTimeElapsed(TaskWorldStatisticsSave.java: 26)
at l2s.gameserver.taskmanager.TaskManager$ExecutedTas k.runImpl(TaskManager.java:71)
at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21)
at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndRe set(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknow n Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$101(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.runPeriodic(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)

l2gold · 21.12.2012, 14:47

ЗАКРЫТО

ПЕРЕПУТАЛ ЛОГИ

l2gold · 21.12.2012, 15:34

Хотя не, все же есть в последнемапдете ошибки в логе

[16:04:34] ERROR WorldStatisticsManager: Failed update char World Statistics.
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'timeInParty' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2359)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at l2s.gameserver.model.worldstat.WorldStatistic.upda teStatsInDb(WorldStatistic.java:188)
at l2s.gameserver.instancemanager.WorldStatisticsMana ger.updateAllStatsInDb(WorldStatisticsManager.java :519)
at l2s.gameserver.taskmanager.tasks.TaskWorldStatisti csSave.onTimeElapsed(TaskWorldStatisticsSave.java: 26)
at l2s.gameserver.taskmanager.TaskManager$ExecutedTas k.runImpl(TaskManager.java:71)
at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21)
at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndRe set(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknow n Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$101(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.runPeriodic(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
[16:04:34] ERROR WorldClanStatistic: Failed update char World Statistics.
com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'clanReputationCount' at row 1
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4094)
at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4028)
at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90)
at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651)
at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2734)
at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2458)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2375)
at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2359)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05)
at l2s.gameserver.model.worldstat.WorldClanStatistic. updateStatsInDb(WorldClanStatistic.java:66)
at l2s.gameserver.instancemanager.WorldStatisticsMana ger.updateAllStatsInDb(WorldStatisticsManager.java :522)
at l2s.gameserver.taskmanager.tasks.TaskWorldStatisti csSave.onTimeElapsed(TaskWorldStatisticsSave.java: 26)
at l2s.gameserver.taskmanager.TaskManager$ExecutedTas k.runImpl(TaskManager.java:71)
at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21)
at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source)
at java.util.concurrent.FutureTask$Sync.innerRunAndRe set(Unknown Source)
at java.util.concurrent.FutureTask.runAndReset(Unknow n Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$101(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.runPeriodic(Unknown Source)
at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source)
at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source)
at java.lang.Thread.run(Unknown Source)
[16:04:34] INFO World Statistic Manager: Data saved successfully (0 seconds)

Core · 22.12.2012, 00:38

Было исправлено. Зачем дублировать темы?

21.12.2012, 14:34	#1
l2gold Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO Регистрация: 13.04.2012 Сообщений: 2,226	[core] ERROR WorldStatisticsManager: Failed update char World Statistics. (DUBLICATE) тоже куча ошибпок - писали пофиксили, а не пофикшено [13:38:59] ERROR WorldStatisticsManager: Failed update char World Statistics. com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'timeInParty' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4094) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2734) at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2359) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at l2s.gameserver.model.worldstat.WorldStatistic.upda teStatsInDb(WorldStatistic.java:181) at l2s.gameserver.instancemanager.WorldStatisticsMana ger.updateAllStatsInDb(WorldStatisticsManager.java :519) at l2s.gameserver.taskmanager.tasks.TaskWorldStatisti csSave.onTimeElapsed(TaskWorldStatisticsSave.java: 26) at l2s.gameserver.taskmanager.TaskManager$ExecutedTas k.runImpl(TaskManager.java:71) at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRunAndRe set(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknow n Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$101(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.runPeriodic(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source) at java.lang.Thread.run(Unknown Source)

22.12.2012, 00:38	#4
Core Модератор Регистрация: 03.06.2012 Сообщений: 4,624	Было исправлено. Зачем дублировать темы? __________________ Техническая поддержка L2-Scripts Внимание: с 1 мая 2015 г. скайп технической поддержки будет: L2-scripts старый скайп тех поддержки обслуживаться не будет !

21.12.2012, 14:47	#2
l2gold Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO Регистрация: 13.04.2012 Сообщений: 2,226	ЗАКРЫТО ПЕРЕПУТАЛ ЛОГИ

21.12.2012, 15:34	#3
l2gold Клиент Расширенка Crusade, + Classic 2.5 + svn + New GEO Регистрация: 13.04.2012 Сообщений: 2,226	Хотя не, все же есть в последнемапдете ошибки в логе [16:04:34] ERROR WorldStatisticsManager: Failed update char World Statistics. com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'timeInParty' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4094) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2734) at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2359) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at l2s.gameserver.model.worldstat.WorldStatistic.upda teStatsInDb(WorldStatistic.java:188) at l2s.gameserver.instancemanager.WorldStatisticsMana ger.updateAllStatsInDb(WorldStatisticsManager.java :519) at l2s.gameserver.taskmanager.tasks.TaskWorldStatisti csSave.onTimeElapsed(TaskWorldStatisticsSave.java: 26) at l2s.gameserver.taskmanager.TaskManager$ExecutedTas k.runImpl(TaskManager.java:71) at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRunAndRe set(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknow n Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$101(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.runPeriodic(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source) at java.lang.Thread.run(Unknown Source) [16:04:34] ERROR WorldClanStatistic: Failed update char World Statistics. com.mysql.jdbc.MysqlDataTruncation: Data truncation: Out of range value for column 'clanReputationCount' at row 1 at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4094) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.ja va:4028) at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:24 90) at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java :2651) at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionIm pl.java:2734) at com.mysql.jdbc.PreparedStatement.executeInternal(P reparedStatement.java:2155) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2458) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2375) at com.mysql.jdbc.PreparedStatement.executeUpdate(Pre paredStatement.java:2359) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at org.apache.commons.dbcp.DelegatingPreparedStatemen t.executeUpdate(DelegatingPreparedStatement.java:1 05) at l2s.gameserver.model.worldstat.WorldClanStatistic. updateStatsInDb(WorldClanStatistic.java:66) at l2s.gameserver.instancemanager.WorldStatisticsMana ger.updateAllStatsInDb(WorldStatisticsManager.java :522) at l2s.gameserver.taskmanager.tasks.TaskWorldStatisti csSave.onTimeElapsed(TaskWorldStatisticsSave.java: 26) at l2s.gameserver.taskmanager.TaskManager$ExecutedTas k.runImpl(TaskManager.java:71) at l2s.commons.threading.RunnableImpl.run(RunnableImp l.java:21) at java.util.concurrent.Executors$RunnableAdapter.cal l(Unknown Source) at java.util.concurrent.FutureTask$Sync.innerRunAndRe set(Unknown Source) at java.util.concurrent.FutureTask.runAndReset(Unknow n Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.access$101(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.runPeriodic(Unknown Source) at java.util.concurrent.ScheduledThreadPoolExecutor$S cheduledFutureTask.run(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run Task(Unknown Source) at java.util.concurrent.ThreadPoolExecutor$Worker.run (Unknown Source) at java.lang.Thread.run(Unknown Source) [16:04:34] INFO World Statistic Manager: Data saved successfully (0 seconds)