Jump to content
  • 0
Sign in to follow this  
Followers 0
GabrielVeiga

Erro GameServer: "GRAVE: Could not update item..."

Asked by GabrielVeiga

Question

GabrielVeiga    2

GabrielVeiga
Posted

Olá, pessoal. Estou com um problema no meu servidor e não tenho ideia de como resolver. Bom é o seguinte:

No gameserver aparece isso abaixo, e dentro do jogo não é possível atacar mobs e trava bastante.

Nov 15, 2014 11:22:45 AM com.l2jserver.gameserver.datatables.MultiSell load
GRAVE: MultiSell: Error loading file C:\Documents and Settings\Administrador\Meus documentos\Downloads\Novo L2Dawn\game\data\multisell\70111.xml
com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Byte inválido 1 da sequência UTF-8 do byte 1.
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanData(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
	at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
	at com.l2jserver.gameserver.datatables.MultiSell.load(MultiSell.java:231)
	at com.l2jserver.gameserver.datatables.MultiSell.<init>(MultiSell.java:48)
	at com.l2jserver.gameserver.datatables.MultiSell$SingletonHolder.<clinit>(MultiSell.java:452)
	at com.l2jserver.gameserver.datatables.MultiSell.getInstance(MultiSell.java:447)
	at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:224)
	at com.l2jserver.gameserver.GameServer.main(GameServer.java:525)

Nov 15, 2014 11:22:45 AM com.l2jserver.gameserver.datatables.MultiSell load
GRAVE: MultiSell: Error loading file C:\Documents and Settings\Administrador\Meus documentos\Downloads\Novo L2Dawn\game\data\multisell\70112.xml
com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Byte inválido 1 da sequência UTF-8 do byte 1.
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanData(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
	at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
	at com.l2jserver.gameserver.datatables.MultiSell.load(MultiSell.java:231)
	at com.l2jserver.gameserver.datatables.MultiSell.<init>(MultiSell.java:48)
	at com.l2jserver.gameserver.datatables.MultiSell$SingletonHolder.<clinit>(MultiSell.java:452)
	at com.l2jserver.gameserver.datatables.MultiSell.getInstance(MultiSell.java:447)
	at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:224)
	at com.l2jserver.gameserver.GameServer.main(GameServer.java:525)

Nov 15, 2014 11:22:45 AM com.l2jserver.gameserver.datatables.MultiSell load
GRAVE: MultiSell: Error loading file C:\Documents and Settings\Administrador\Meus documentos\Downloads\Novo L2Dawn\game\data\multisell\70123.xml
com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Byte inválido 1 da sequência UTF-8 do byte 1.
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanData(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
	at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
	at com.l2jserver.gameserver.datatables.MultiSell.load(MultiSell.java:231)
	at com.l2jserver.gameserver.datatables.MultiSell.<init>(MultiSell.java:48)
	at com.l2jserver.gameserver.datatables.MultiSell$SingletonHolder.<clinit>(MultiSell.java:452)
	at com.l2jserver.gameserver.datatables.MultiSell.getInstance(MultiSell.java:447)
	at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:224)
	at com.l2jserver.gameserver.GameServer.main(GameServer.java:525)

Nov 15, 2014 11:22:45 AM com.l2jserver.gameserver.datatables.MultiSell load
GRAVE: MultiSell: Error loading file C:\Documents and Settings\Administrador\Meus documentos\Downloads\Novo L2Dawn\game\data\multisell\72212.xml
com.sun.org.apache.xerces.internal.impl.io.MalformedByteSequenceException: Byte inválido 1 da sequência UTF-8 do byte 1.
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.invalidByte(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.io.UTF8Reader.read(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.load(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLEntityScanner.scanData(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLScanner.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanComment(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl$PrologDriver.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentScannerImpl.next(Unknown Source)
	at com.sun.org.apache.xerces.internal.impl.XMLDocumentFragmentScannerImpl.scanDocument(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XML11Configuration.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.XMLParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.parsers.DOMParser.parse(Unknown Source)
	at com.sun.org.apache.xerces.internal.jaxp.DocumentBuilderImpl.parse(Unknown Source)
	at javax.xml.parsers.DocumentBuilder.parse(Unknown Source)
	at com.l2jserver.gameserver.datatables.MultiSell.load(MultiSell.java:231)
	at com.l2jserver.gameserver.datatables.MultiSell.<init>(MultiSell.java:48)
	at com.l2jserver.gameserver.datatables.MultiSell$SingletonHolder.<clinit>(MultiSell.java:452)
	at com.l2jserver.gameserver.datatables.MultiSell.getInstance(MultiSell.java:447)
	at com.l2jserver.gameserver.GameServer.<init>(GameServer.java:224)
	at com.l2jserver.gameserver.GameServer.main(GameServer.java:525)

Nov 15, 2014 11:29:59 AM com.l2jserver.gameserver.model.items.instance.L2ItemInstance updateInDb
GRAVE: Could not update item Blessed Spiritshot (S-Grade)(22076)[268487129] in DB: Reason: Lock wait timeout exceeded; try restarting transaction
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
	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(NewProxyPreparedStatement.java:139)
	at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateInDb(L2ItemInstance.java:1656)
	at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1459)
	at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1438)
	at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.destroyItem(ItemContainer.java:426)
	at com.l2jserver.gameserver.model.itemcontainer.PcInventory.destroyItem(PcInventory.java:616)
	at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.destroyItem(L2PcInstance.java:4040)
	at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.destroyItemWithoutTrace(L2PcInstance.java:4138)
	at handlers.itemhandlers.BlessedSpiritShot.useItem(BlessedSpiritShot.java:71)
	at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.rechargeShots(L2PcInstance.java:10530)
	at com.l2jserver.gameserver.model.actor.L2Character.onMagicHitTimer(L2Character.java:6706)
	at com.l2jserver.gameserver.model.actor.L2Character$MagicUseTask.run(L2Character.java:3181)
	at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:74)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

Nov 15, 2014 11:30:24 AM com.l2jserver.gameserver.model.items.instance.L2ItemInstance updateInDb
GRAVE: Could not update item Soulshot (S-Grade)(1467)[268484508] in DB: Reason: Lock wait timeout exceeded; try restarting transaction
java.sql.SQLException: Lock wait timeout exceeded; try restarting transaction
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1074)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4028)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2490)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2651)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2734)
	at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:2155)
	at com.mysql.jdbc.PreparedStatement.executeUpdate(PreparedStatement.java:2458)
	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(NewProxyPreparedStatement.java:139)
	at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateInDb(L2ItemInstance.java:1656)
	at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1459)
	at com.l2jserver.gameserver.model.items.instance.L2ItemInstance.updateDatabase(L2ItemInstance.java:1438)
	at com.l2jserver.gameserver.model.itemcontainer.ItemContainer.destroyItem(ItemContainer.java:426)
	at com.l2jserver.gameserver.model.itemcontainer.PcInventory.destroyItem(PcInventory.java:616)
	at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.destroyItem(L2PcInstance.java:4040)
	at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.destroyItemWithoutTrace(L2PcInstance.java:4138)
	at handlers.itemhandlers.SoulShots.useItem(SoulShots.java:79)
	at com.l2jserver.gameserver.model.actor.instance.L2PcInstance.rechargeShots(L2PcInstance.java:10542)
	at com.l2jserver.gameserver.model.actor.L2Character.onHitTimer(L2Character.java:5888)
	at com.l2jserver.gameserver.model.actor.L2Character$HitTask.run(L2Character.java:3141)
	at com.l2jserver.gameserver.ThreadPoolManager$RunnableWrapper.run(ThreadPoolManager.java:74)
	at java.util.concurrent.Executors$RunnableAdapter.call(Unknown Source)
	at java.util.concurrent.FutureTask.run(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.access$201(Unknown Source)
	at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
	at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
	at java.lang.Thread.run(Unknown Source)

Quando vou ver no meu navicat , a tabela 'items' sumiu e quando tento restaurar o backup, surge a seguinte mensagem:

[Msg] Table Created: item_icons
[Msg] Table Created: item_market
[Msg] 1005 - Can't create table 'l2jdb2.items' (errno: 121)
[Msg] Importing Data...
[Msg] Finished - Stopped before completion

Gostaria de uma ajuda rápido pois estou perdendo players.

 

Ps: Já tentei Trocar de Rev

 

Obrigado!

Share this post

Link to post
Share on other sites

0 answers to this question

Recommended Posts

There have been no answers to this question yet

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.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  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.

Loading...
×
Sign in to follow this  
Followers 0
Go To Question Listing


     



  • Recently Browsing

    No registered users viewing this page.

  • Posts

    • Ar4gorn
      L2J Mega Corrigido

      By Ar4gorn · Posted

      https://mega.nz/#!cJdgXa4D!fmKNVOjCc5Z4C2Qv2Xwn7SZwvCoWjOKR4KtMfE3qsZ8
    • luisalberto
      L2J Mega Corrigido

      By luisalberto · Posted

      Mil disculpas por la pregunta tonta quizás. Alguien sabe de donde descargo el parche del cliente para poder ver todas las cosas que tiene el server ? Descarge del topico L2jmega pero no me da. descarge de aqui en donde dice patch limpio y y veo iconos negros. Porfavor alquien me podria ayudar con eso ? Uso windows 10. Muchas gracias !
    • ~DnR~
      Como verificar, remover e adicionar Zona

      By ~DnR~ · Posted

      This is really helpful for people who do not comprehend the fundamentals of zone system. Nice tutorial.
    • lTheLegenD
      L2J Mega Corrigido

      By lTheLegenD · Posted

      quando coloquei os fakes pra se atacar ficou aparecendo esse erro ai alguem sabe oq é ?   como se eles nao conseguisse dar tovila e voltar
    • Albeci Nogueira
      L2J Mega Corrigido

      By Albeci Nogueira · Posted

      Vai em: gameserver\config\customs\SpecialMods.properties # Custom Spawn for news players CustomSpawn = false -> true RandomAreasSpawn = 1 # X, Y, Z custom_spawn1 = 45928, 49912, -3056 (digite /loc e pegue a localização de onde ele vai nascer) custom_spawn2 = 45928, 49912, -3056 custom_spawn3 = 45928, 49912, -3056
    • luisalberto
      L2J Mega Corrigido

      By luisalberto · Posted

      Nice men ! Amigos como puedo hacer para que mi nuevo player vaya a talking Island en vez de irse a Giran ?
    • Ar4gorn
      L2J Mega Corrigido

      By Ar4gorn · Posted

      Pequena correção para quem pretender usar essa REV e ter jóias boss nos boss... O NPC Gatekeeper of Fire Dragon (npc que abre a porta até o Heart of Volcano) não estava abrindo a porta. Então procurei sobre isso e achei um tópico relacionado a Frozen 1132 mas com a solução definitiva para isso. Caminho para correção na Source: net.sf.l2j.gameserver.scripting.scripts.teleports Procure por:   elif npcId == 31384 : #Gatekeeper of Fire Dragon DoorTable.getInstance().getDoor(24210004).openMe() return elif npcId == 31686 : #Gatekeeper of Fire Dragon DoorTable.getInstance().getDoor(24210006).openMe() return elif npcId == 31687 : #Gatekeeper of Fire Dragon DoorTable.getInstance().getDoor(24210005).openMe() return   E altere os números em vermelho para: 4 5 e 6 respectivamente.   elif npcId == 31384 : #Gatekeeper of Fire Dragon DoorTable.getInstance().getDoor(24210004).openMe() return elif npcId == 31686 : #Gatekeeper of Fire Dragon DoorTable.getInstance().getDoor(24210005).openMe() return elif npcId == 31687 : #Gatekeeper of Fire Dragon DoorTable.getInstance().getDoor(24210006).openMe() return   Correção simples mas que vai ajudar quem queira moldar seu servidor nesse estilo. Créditos pela correção: leozinhobr2    
    • Albeci Nogueira
      L2J Mega Corrigido

      By Albeci Nogueira · Posted

      Você está usando a ultima atualização postada? se não baixa e tente novamente, pode resolver seu problema e conserto de alguns bugs já relatados. Se tiver mais alguma dúvida pergunte no forum de duvidas, que responderemos da mesma forma. https://www.l2jbrasil.com/forum/18-dúvidas/
    • angebosta
      L2J Mega Corrigido

      By angebosta · Posted

      Você sabe como resolver esse erro? O gameserver nunca passa disso...
    • Christian-SDM
      L2J Mega Corrigido

      By Christian-SDM · Posted

      Obrigado a todos pela resposta do tvt 2x2 e 4x4 etc, eu não tenho conhecimento desse evento e coisas semelhantes. Show
×
×
  • Create New...