天堂2单机论坛

用户名  找回密码
 立即注册
查看: 1203|回复: 1

伺服器出現異常訊息 找不到方向,請會的大老請教

[复制链接]
  • TA的每日心情
    无聊
    2025-5-21 23:04
  • 签到天数: 180 天

    [LV.7]常住居民III

    12

    主题

    292

    帖子

    2991

    积分

    金牌会员

    Rank: 6Rank: 6

    积分
    2991
    发表于 2024-10-1 19:48:57 | 显示全部楼层 |阅读模式
    以下為異常訊息:


    9月 29, 2024 8:03:50 下午 org.l2jmobius.gameserver.model.actor.Player restoreEffects
    WARNING: Could not restore Player:女巫[268530466] active effect data: (conn=174542) Table '.\l2jmobiusessence73\character_skills_save' is marked as crashed and should be repaired
    java.sql.SQLTransientConnectionException: (conn=174542) Table '.\l2jmobiusessence73\character_skills_save' is marked as crashed and should be repaired
            at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.createException(ExceptionFactory.java:79)
            at org.mariadb.jdbc.internal.util.exceptions.ExceptionFactory.create(ExceptionFactory.java:158)
            at org.mariadb.jdbc.MariaDbStatement.executeExceptionEpilogue(MariaDbStatement.java:266)
            at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:229)
            at org.mariadb.jdbc.ClientSidePreparedStatement.execute(ClientSidePreparedStatement.java:149)
            at org.mariadb.jdbc.ClientSidePreparedStatement.executeQuery(ClientSidePreparedStatement.java:163)
            at org.l2jmobius.gameserver.model.actor.Player.restoreEffects(Player.java:8063)
            at org.l2jmobius.gameserver.model.actor.Player.onPlayerEnter(Player.java:10741)
            at org.l2jmobius.gameserver.network.clientpackets.EnterWorld.run(EnterWorld.java:559)
            at org.l2jmobius.gameserver.network.PacketHandler.handle(PacketHandler.java:80)
            at org.l2jmobius.gameserver.network.PacketHandler.handle(PacketHandler.java:29)
            at org.l2jmobius.commons.network.ExecuteThread$ExecuteTask.run(ExecuteThread.java:130)
            at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1144)
            at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:642)
            at java.base/java.lang.Thread.run(Thread.java:1583)
    Caused by: org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException: Table '.\l2jmobiusessence73\character_skills_save' is marked as crashed and should be repaired
            at org.mariadb.jdbc.internal.util.exceptions.MariaDbSqlException.of(MariaDbSqlException.java:34)
            at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:194)
            at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.exceptionWithQuery(AbstractQueryProtocol.java:177)
            at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:321)
            at org.mariadb.jdbc.ClientSidePreparedStatement.executeInternal(ClientSidePreparedStatement.java:220)
            ... 11 more
    Caused by: java.sql.SQLException: Table '.\l2jmobiusessence73\character_skills_save' is marked as crashed and should be repaired
            at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readErrorPacket(AbstractQueryProtocol.java:1695)
            at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.readPacket(AbstractQueryProtocol.java:1557)
            at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.getResult(AbstractQueryProtocol.java:1520)
            at org.mariadb.jdbc.internal.protocol.AbstractQueryProtocol.executeQuery(AbstractQueryProtocol.java:318)
            ... 12 more

    出現以上異常訊息,上網查說是
    錯誤訊息
    • Table '.\l2jmobiusessence73\character_skills_save' is marked as crashed and should be repaired
      表示 character_skills_save 資料表已經崩潰,需要進行修復。



    有哪位大老可以幫我看看可能哪邊有問題
    找不到方向

    回复

    举报

  • TA的每日心情
    无聊
    2025-5-21 23:04
  • 签到天数: 180 天

    [LV.7]常住居民III

    12

    主题

    292

    帖子

    2991

    积分

    金牌会员

    Rank: 6Rank: 6

    积分
    2991
     楼主| 发表于 2024-10-1 20:03:17 | 显示全部楼层
    mysql> REPAIR TABLE character_skills_save;
    +------------------------------------------+--------+----------+----------+
    | Table                                    | Op     | Msg_type | Msg_text |
    +------------------------------------------+--------+----------+----------+
    | l2jmobiusessence73.character_skills_save | repair | status   | OK       |
    +------------------------------------------+--------+----------+----------+
    1 row in set (0.01 sec)

    目前使用數據表修復,好像好了..
    回复

    举报

    您需要登录后才可以回帖 登录 | 立即注册

    本版积分规则

    QQ|Archiver|手机版|监狱|天堂2单机论坛 ( 粤ICP备20030366号 )

    GMT+8, 2025-6-1 04:04 , Processed in 0.076084 second(s), 21 queries .

    Powered by Discuz! X3.4

    © 2001-2023 Discuz! Team.

    快速回复 返回顶部 返回列表