Tagi:

AutorWątek: max_allowed_packet  (Przeczytany 1748 razy)

0 użytkowników i 1 Gość przegląda ten wątek.

Offline Malin2005

  • czysty jak zad źrebaka
  • *
  • Wiadomości: 1
  • Brud/Czysty: +0/-0
max_allowed_packet
« dnia: 17 Marzec , 2012, 11:41:27 am »
Prosiłbym o pomoc, przy próbie uruchomienia demona pojawia się komunikat Can't create query: Packet for query is too large (5526600 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable. Podejrzewam, że jest to błąd z bazą MySQL, jednak na zapytanie mysql> show variables like 'max%' , otrzymuje wynik max_allowed_packet 335544320.   

C:\demon>java -jar jGuardian.jar "conf\gameservers\default"
2012-03-17 11:14:50,344 JGuardianMainApp        -       |=======================
===================================
2012-03-17 11:14:50,347 JGuardianMainApp        -       | This is jGuardian v2.0
.0(D1)
2012-03-17 11:14:50,352 JGuardianMainApp        -       | Written by Anubis

2012-03-17 11:14:50,352 JGuardianMainApp        -       | Visit our forum at htt
p://g4g.pl
2012-03-17 11:14:50,353 JGuardianMainApp        -       |=======================
===================================
2012-03-17 11:14:50,365 JGuardianMainApp        -       | Program started at: Sa
t Mar 17 11:14:50 CET 2012
2012-03-17 11:14:50,365 JGuardianMainApp        -       |=======================
===================================
2012-03-17 11:14:50,365 JGuardianMainApp        -       | Testing log level: inf
o
2012-03-17 11:14:50,368 JGuardianMainApp        -       | Testing log level: war
n
2012-03-17 11:14:50,368 JGuardianMainApp        -       | Testing log level: err
or
2012-03-17 11:14:50,368 JGuardianMainApp        -       | Testing log level: fat
al
2012-03-17 11:14:50,368 JGuardianMainApp        -       |=======================
===================================
2012-03-17 11:14:50,371 JGuardianMainApp        -       All set... starting...
2012-03-17 11:14:50,385 JGuardianMainApp        -       Loading plugins...
Reading settings.xml...
2012-03-17 11:14:50,390 JGuardianMainApp        -       Reading settings.xml...
2012-03-17 11:14:50,481 JGuardianMainApp        -       loadMainSettings: Loaded

-------------------------------------------------------------
Loading: frostbite.bf3.BattleField3.jar
2012-03-17 11:14:50,513 JGuardianMainApp        -       < Plugin name: GamePlugi
n
2012-03-17 11:14:50,516 JGuardianMainApp        -       < Author: Anubis
2012-03-17 11:14:50,519 JGuardianMainApp        -       < Plugin version: 1.0.0.
0b
2012-03-17 11:14:50,523 JGuardianMainApp        -       < Plugin Description: Ba
ttlefield 3 game plugin
2012-03-17 11:14:50,528 PluginManagerImpl       -       Registering command: nex
tmap for method onNextmap by plugin pl.jguardian.plugin.frostbite.bf3.BattleFiel
d3@3f77b3cd
2012-03-17 11:14:50,541 PluginManagerImpl       -       Registering command: tim
e for method onTime by plugin pl.jguardian.plugin.frostbite.bf3.BattleField3@3f7
7b3cd
2012-03-17 11:14:50,547 JGuardianMainApp        -       ------------------------
-------------------------------------
Settings.xml loaded! Loading plugins for: BF3
2012-03-17 11:14:50,552 JGuardianMainApp        -       ------------------------
-------------------------------------
2012-03-17 11:14:50,556 JGuardianMainApp        -       Loading: common.JGuardia
nMySQL.jar
2012-03-17 11:14:50,584 JGuardianMainApp        -       < Plugin name: MySQL
2012-03-17 11:14:50,589 JGuardianMainApp        -       < Author: Anubis
2012-03-17 11:14:50,591 JGuardianMainApp        -       < Plugin Description: My
SQL interface for Game servers
-------------------------------------------------------------
2012-03-17 11:14:50,605 JGuardianMainApp        -       ------------------------
-------------------------------------
2012-03-17 11:14:50,608 JGuardianMainApp        -       Loading: common.Admin.ja
r
2012-03-17 11:14:50,617 JGuardianMainApp        -       < Plugin name: Admin
2012-03-17 11:14:50,619 JGuardianMainApp        -       < Author: Anubis
2012-03-17 11:14:50,620 JGuardianMainApp        -       < Plugin Description: Ad
min plugin functionality! Commands: say, move, kick, ban, teamid
2012-03-17 11:14:50,622 PluginManagerImpl       -       Registering command: ban
 for method onBan by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,624 PluginManagerImpl       -       Registering command: pba
n for method onPBan by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,626 PluginManagerImpl       -       Registering command: war
n for method onWarn by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,629 PluginManagerImpl       -       Registering command: kic
k for method onKick by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,630 PluginManagerImpl       -       Registering command: mov
e for method onMove by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,632 PluginManagerImpl       -       Registering command: say
 for method onSay by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,634 PluginManagerImpl       -       Registering command: tid
 for method onTeamid by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,635 PluginManagerImpl       -       Registering command: adm
in for method onUpdateAdmin by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,639 PluginManagerImpl       -       Registering command: kil
l for method onKill by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,652 PluginManagerImpl       -       Registering command: pbs
s for method onPBSS by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,662 PluginManagerImpl       -       Registering command: pbo
n for method onPBOn by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,665 PluginManagerImpl       -       Registering command: pbo
ff for method onPBOff by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,666 PluginManagerImpl       -       Registering command: pbs
tatus for method onPBStatus by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,668 PluginManagerImpl       -       Registering command: pbr
estart for method onPBrestart by plugin pl.jguardian.plugin.common.Admin@5557c2b
d
2012-03-17 11:14:50,682 PluginManagerImpl       -       Registering command: pbu
pdate for method onPBUpdate by plugin pl.jguardian.plugin.common.Admin@5557c2bd
2012-03-17 11:14:50,685 PluginManagerImpl       -       Registering command: pbv
er for method onPBVer by plugin pl.jguardian.plugin.common.Admin@5557c2bd
-------------------------------------------------------------
2012-03-17 11:14:50,690 JGuardianMainApp        -       ------------------------
-------------------------------------
2012-03-17 11:14:50,692 JGuardianMainApp        -       Loading: common.Balancer
.jar
2012-03-17 11:14:50,699 JGuardianMainApp        -       < Plugin name: Balancer
2012-03-17 11:14:50,700 JGuardianMainApp        -       < Author: Anubis
2012-03-17 11:14:50,701 JGuardianMainApp        -       < Plugin Description: Ba
lance!
2012-03-17 11:14:50,702 PluginManagerImpl       -       Registering event: onJoi
n for method player_onJoin by plugin Balancer
2012-03-17 11:14:50,703 PluginManagerImpl       -       Registering event: onLea
ve for method player_onLeave by plugin Balancer
2012-03-17 11:14:50,705 PluginManagerImpl       -       Registering event: PLUGI
N/SETTINGS/UPDATED for method pluginConfigUpdated by plugin Balancer
-------------------------------------------------------------
2012-03-17 11:14:50,707 JGuardianMainApp        -       ------------------------
-------------------------------------
2012-03-17 11:14:50,709 JGuardianMainApp        -       Loading: common.Adverts.
jar
2012-03-17 11:14:50,714 Adverts -       Initializing...
2012-03-17 11:14:50,715 JGuardianMainApp        -       < Plugin name: Adverts
2012-03-17 11:14:50,716 JGuardianMainApp        -       < Author: Anubis
2012-03-17 11:14:50,717 JGuardianMainApp        -       < Plugin Description: Si
mple advert plugin. Shares the variables: bestscoreplayer, topkillplayer, server
name, map, mode, date, time.
2012-03-17 11:14:50,719 PluginManagerImpl       -       Registering event: onRou
ndEnd for method onRoundEnd by plugin Adverts
2012-03-17 11:14:50,722 PluginManagerImpl       -       Registering event: onRou
ndStart for method onRoundStart by plugin Adverts
-------------------------------------------------------------
2012-03-17 11:14:50,734 JGuardianMainApp        -       ------------------------
-------------------------------------
2012-03-17 11:14:50,735 JGuardianMainApp        -       Loading: common.Censor.j
ar
2012-03-17 11:14:50,747 JGuardianMainApp        -       < Plugin name: Censor
2012-03-17 11:14:50,749 JGuardianMainApp        -       < Author: Anubis
2012-03-17 11:14:50,750 JGuardianMainApp        -       < Plugin Description: Ce
nsor :)
2012-03-17 11:14:50,751 PluginManagerImpl       -       Registering event: onRou
ndStart for method onRoundStart by plugin Censor
-------------------------------------------------------------
2012-03-17 11:14:50,757 JGuardianMainApp        -       All plugins loaded! Star
ting engine!...
2012-03-17 11:14:50,768 JGuardianMainApp        -       ========================
=============================================================
2012-03-17 11:14:50,770 JGuardianMainApp        -       Plugins loaded... starti
ng worker thread...
2012-03-17 11:14:50,773 PluginManagerImpl       -       Starting Engine
Can't create query: Packet for query is too large (5526600 > 1048576). You can c
hange this value on the server by setting the max_allowed_packet' variable.

java.lang.NullPointerException
        at pl.jguardian.plugin.frostbite.bf3.BF3PlayerList.gatherServerType(BF3P
layerList.java:1890)
        at pl.jguardian.plugin.frostbite.bf3.BattleField3.PrepareToStart(BattleF
ield3.java:669)
        at pl.jguardian.plugin.PluginManagerImpl$SinglePluginProcessorThread.Pre
pareToStart(PluginManagerImpl.java:297)
        at pl.jguardian.plugin.PluginManagerImpl.startPlugins(PluginManagerImpl.
java:760)
        at pl.jguardian.plugin.PluginManagerImpl.startMainThread(PluginManagerIm
pl.java:747)
        at pl.jguardian.plugin.PluginManagerImpl.run(PluginManagerImpl.java:669)

        at java.lang.Thread.run(Unknown Source)
2012-03-17 11:24:51,178 PluginManagerImpl       -       java.lang.NullPointerExc
eption
2012-03-17 11:24:51,179 PluginManagerImpl       -       Plugins being stopped...

2012-03-17 11:24:51,180 PluginManagerImpl       -       Done.
[ROOT] 2012/03/17 11:24:51 finished
2012-03-17 11:24:51,183 JGuardianMainApp        -       Worker thread closed!
2012-03-17 11:24:51,183 JGuardianMainApp        -        Engine has stopped! So
long...
Engine has stopped! So long...
2012-03-17 11:24:51,185 JGuardianMainApp        -       Application stopped...
« Ostatnia zmiana: 17 Marzec , 2012, 12:16:23 pm wysłana przez Malin2005 »

Offline Anubis

  • أنوبيس
  • Global Moderator
  • śmierdzący zgnilizną brudas
  • *****
  • Wiadomości: 4580
  • Wypił browarów: 2
  • Brud/Czysty: +248/-125
  • Anoobinator
Odp: max_allowed_packet
« Odpowiedź #1 dnia: 19 Marzec , 2012, 09:05:15 am »
Jeśli masz wątpliwości - wal serią.

Offline henn9438

  • czysty jak zad źrebaka
  • *
  • Wiadomości: 1
  • Brud/Czysty: +0/-0
Odp: max_allowed_packet
« Odpowiedź #2 dnia: 11 Grudzień , 2013, 13:45:50 pm »
 instalka poszła ale przy importowaniu bazy danych wywala błąd: