[HELP] MySQL Server has gone away problem!

[xXObanXx]

Hello everyone!

so i use the last l2jserver H5 revision...

so, i don't know why! but when i'm going to install the `npc` table in the database with all the npc's,

it show me that error!

Does anyone know WTF is this?!

 

[Err] 2006 - MySQL server has gone away

[Err] INSERT INTO `npc` VALUES

(22029,22029,'Ragna Orc',0,'',0,'LineageMonster.batur_orc_03te','9','21.5',40,'male','L2Monster',40,'966.57792','478.8','4.5','1.8',40,43,30,21,20,20,3620,233,'176.36077','156.55035','120.43155','114.55675',253,1,333,2,0,0,80,140,0,1),

(22030,22030,'Ragna Orc Shaman',0,'',0,'LineageMonster.batur_orc_shaman_a_03te','11','16',42,'male','L2Monster',40,'1050.81652','531','5.5','2.1',40,43,30,21,20,20,3782,251,'198.34591','164.88513','135.44454','120.65578',253,1,333,159,0,0,50,140,0,1),

(22031,22031,'Ragna Orc Archer',0,'',0,'LineageMonster.batur_orc_archer_03te','11','21.5',43,'male','L2Monster',1100,'1094.28943','557.4','5.5','2.1',40,43,30,21,20,20,3499,236,'210.04832','169.13417','143.43577','123.76505',253,8,333,13,0,0,45,130,1,1),

(22032,22032,'Ragna Orc Warrior',0,'',0,'LineageMonster.batur_orc_warrior_03te','10','20',44,'male','L2Monster',40,'1138.62924','584','5.5','2.1',40,43,30,21,20,20,4380,299,'222.23112','173.43552','151.75505','126.91259',253,4,333,68,0,0,80,140,0,1),

(22033,22033,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,5625,391,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22034,22034,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,5158,358,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22035,22035,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,5625,391,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22036,22036,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,3963,275,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22037,22037,'Ragna Orc Healer',0,'',0,'LineageMonster.batur_orc_shaman_a_03te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,4342,301,'234.89829','177.78746','160.40508','130.09715',253,1,333,316,0,0,50,140,0,1),

(22038,22038,'Ragna Orc Hero',0,'',0,'LineageMonster.batur_orc_overlord_03te','12','24',48,'male','L2Monster',40,'1324.01623','692.4','5.5','2.1',40,43,30,21,20,20,5213,380,'275.82705','191.12803','188.35412','139.8592',253,4,333,74,0,0,80,140,0,1),

(22039,22039,'Ragna Orc Commander',0,'',0,'LineageMonster.batur_orc_overlord_01te','12','24',49,'male','L2Monster',40,'1372.18568','720','5.5','2.1',40,43,30,21,20,20,5432,401,'290.44588','195.66302','198.33688','143.17771',253,4,333,135,0,0,80,140,0,1),

(22040,22040,'Ragna Orc Sniper',0,'',0,'LineageMonster.batur_orc_archer_01te','11','21.5',47,'male','L2Monster',1100,'1276.53628','665','5.5','2.1',40,43,30,21,20,20,4180,299,'261.69549','186.63569','178.7041','136.5719',253,8,333,275,0,0,45,140,1,1),

(22041,22041,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,6944,522,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22042,22042,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,6368,479,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22043,22043,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,6944,522,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22044,22044,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,4892,368,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22045,22045,'Dark Corpse',

[Err] 1136 - Column count doesn't match value count at row 2248

[Err] INSERT INTO `npc` VALUES

(32211,32211,'Jueno',0,'Master',0,'LineageNPC2.K_M1_master','15','25',70,'male','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,30,120,0,1),

(32212,32212,'Rishtar',0,'Master',0,'LineageNPC2.K_F1_master','12','23',70,'female','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9644,0,0,24,120,0,1),

(32213,32213,'Vitus',0,'Grand Master',0,'LineageNPC2.K_M1_grand','13','25',70,'male','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,28,120,0,1),

(32214,32214,'Meldina',0,'Grand Master',0,'LineageNPC2.K_F1_grand','11','22.25',70,'female','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,28,120,0,1),

(32215,32215,'Tenain',0,'Master',0,'LineageNPC2.K_M1_master','15','25',70,'male','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,30,120,0,1),

(32216,32216,'Noir',0,'Master',0,'LineageNPC2.K_F1_master','12','23',70,'female','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9644,0,0,24,120,0,1),

(32217,32217,'Barta',0,'Grand Master',0,'LineageNPC2.K_M1_grand','13','25',70,'male','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9645,0,0,28,120,0,1),

(32218,32218,'Miya',0,'Grand Master',0,'LineageNPC2.K_F1_grand','11','22.25',70,'female','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9644,0,0,28,120,0,1),

(32219,32219,'Fabnor',0,'Master',0,'LineageNPC2.K_M1_master','15','25',70,'male','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,30,120,0,1),

(32220,32220,'Selsia',0,'Master',0,'LineageNPC2.K_F1_master','12','23',70,'female','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9644,0,0,24,120,0,1),

(32221,32221,'Brome',0,'Grand Master',0,'LineageNPC2.K_M1_grand','13','25',70,'male','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,28,120,0,1),

(32222,32222,'Liane',0,'Grand Master',0,'LineageNPC2.K_F1_grand','11','22.25',70,'female','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,28,120,0,1),

(32223,32223,'Duroga',0,'Master',0,'LineageNPC2.K_M1_master','15','25',70,'male','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,30,120,0,1),

(32224,32224,'Auren',0,'Master',0,'LineageNPC2.K_F1_master','12','23',70,'female','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9644,0,0,24,120,0,1),

(32225,32225,'Taine',0,'Grand Master',0,'LineageNPC2.K_M1_grand','13','25',70,'male','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9645,0,0,28,120,0,1),

(32226,32226,'Raula',0,'Grand Master',0,'LineageNPC2.K_F1_grand','11','22.25',70,'female','L2VillageMasterKamael',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9644,0,0,28,120,0,1),

(32227,32227,'Digler',0,'Master',0,'LineageNPC2.K_M1_master','15','25',70,'male','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.4

[Msg] Finished - Unsuccessfully

--------------------------------------------------

[Tryskell]

Verify the line beginning by

(32227,32227,'Digler',0,'Master',0,

The end must be truncated.

 

If not it's either a syntax error, a missing ' punctuation, or whatever which make mysql angry.

[xXObanXx]

Verify the line beginning by

(32227,32227,'Digler',0,'Master',0,

The end must be truncated.

 

If not it's either a syntax error, a missing ' punctuation, or whatever which make mysql angry.

 

What exactly i have to do here?

the line is:

(32227,32227,'Digler',0,'Master',0,'LineageNPC2.K_M1_master','15','25',70,'male','L2Trainer',40,'2444.46819','1345.8','7.5','2.7',40,43,30,21,20,20,0,0,'688.86373','295.91597','470.40463','216.53847',253,4,333,9646,0,0,30,120,0,1),

 

there is no a syntax error...

cause i tested it and with the clear npc.sql file from SVN and it give's me the same error!

(cause on the other file i have input some npc's!)

[xXObanXx]

here is the error from the official npc.sql file:

 

[Err] 2006 - MySQL server has gone away

[Err] INSERT INTO `npc` VALUES

(22029,22029,'Ragna Orc',0,'',0,'LineageMonster.batur_orc_03te','9','21.5',40,'male','L2Monster',40,'966.57792','478.8','4.5','1.8',40,43,30,21,20,20,3620,233,'176.36077','156.55035','120.43155','114.55675',253,1,333,2,0,0,80,140,0,1),

(22030,22030,'Ragna Orc Shaman',0,'',0,'LineageMonster.batur_orc_shaman_a_03te','11','16',42,'male','L2Monster',40,'1050.81652','531','5.5','2.1',40,43,30,21,20,20,3782,251,'198.34591','164.88513','135.44454','120.65578',253,1,333,159,0,0,50,140,0,1),

(22031,22031,'Ragna Orc Archer',0,'',0,'LineageMonster.batur_orc_archer_03te','11','21.5',43,'male','L2Monster',1100,'1094.28943','557.4','5.5','2.1',40,43,30,21,20,20,3499,236,'210.04832','169.13417','143.43577','123.76505',253,8,333,13,0,0,45,130,1,1),

(22032,22032,'Ragna Orc Warrior',0,'',0,'LineageMonster.batur_orc_warrior_03te','10','20',44,'male','L2Monster',40,'1138.62924','584','5.5','2.1',40,43,30,21,20,20,4380,299,'222.23112','173.43552','151.75505','126.91259',253,4,333,68,0,0,80,140,0,1),

(22033,22033,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,5625,391,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22034,22034,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,5158,358,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22035,22035,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,5625,391,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22036,22036,'Ragna Orc Mage',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,3963,275,'234.89829','177.78746','160.40508','130.09715',253,1,333,179,0,0,50,140,1,1),

(22037,22037,'Ragna Orc Healer',0,'',0,'LineageMonster.batur_orc_shaman_a_03te','11','16',45,'male','L2Monster',40,'1183.80594','610.8','5.5','2.1',40,43,30,21,20,20,4342,301,'234.89829','177.78746','160.40508','130.09715',253,1,333,316,0,0,50,140,0,1),

(22038,22038,'Ragna Orc Hero',0,'',0,'LineageMonster.batur_orc_overlord_03te','12','24',48,'male','L2Monster',40,'1324.01623','692.4','5.5','2.1',40,43,30,21,20,20,5213,380,'275.82705','191.12803','188.35412','139.8592',253,4,333,74,0,0,80,140,0,1),

(22039,22039,'Ragna Orc Commander',0,'',0,'LineageMonster.batur_orc_overlord_01te','12','24',49,'male','L2Monster',40,'1372.18568','720','5.5','2.1',40,43,30,21,20,20,5432,401,'290.44588','195.66302','198.33688','143.17771',253,4,333,135,0,0,80,140,0,1),

(22040,22040,'Ragna Orc Sniper',0,'',0,'LineageMonster.batur_orc_archer_01te','11','21.5',47,'male','L2Monster',1100,'1276.53628','665','5.5','2.1',40,43,30,21,20,20,4180,299,'261.69549','186.63569','178.7041','136.5719',253,8,333,275,0,0,45,140,1,1),

(22041,22041,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,6944,522,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22042,22042,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,6368,479,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22043,22043,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,6944,522,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22044,22044,'Ragna Orc Sorcerer',0,'',0,'LineageMonster.batur_orc_shaman_a_01te','11','16',50,'male','L2Monster',40,'1421.00103','747.8','5.5','2.1',40,43,30,21,20,20,4892,368,'305.54906','200.23844','208.6504','146.5258',253,1,333,7,0,0,50,140,1,1),

(22045,22045,'Dark Corpse',

[Msg] Finished - Unsuccessfully

--------------------------------------------------

[vampir]

if your problem is not related with syntax, try this one: http://bogdan.org.ua/2008/12/25/how-to-fix-mysql-server-has-gone-away-error-2006.html

[Tryskell]

Yup you probably made a query which is too big, update max_allowed_packet or cut your query in 2.

[xXObanXx]

so... i have mysql community server

(downloaded from here: http://dev.mysql.com/downloads/mysql/)

so i see this topic with that fix but it don't work on me...

so as i see on this topic they edit the my.cfg.

i don't have this file on the MySQL folder... i see some comment's and they said, they edit my.ini file...

i have this file but on ths file don't have the options:

wait_timeout = 120

or

innodb_lock_wait_timeout = 120

and

max_allowed_packet = 14M

 

but...

i find that options on

my-innodb-heavy-4G.ini

but i change the options from:

innodb_lock_wait_timeout = 120

and

max_allowed_packet = 14M

to:

innodb_lock_wait_timeout = 6000 and 20000

and

max_allowed_packet = 64M

 

but still don't work!

[xXObanXx]

ok i made an other way that it works!

i put the npc.sql file to other 3 .sql files and works perfect!

 

but the question now is....

why it show me that error, when i was install the npc.sql and before and don't show me that error!

any answer about that?!

[Tryskell]

Two possibilities :

- you reinstalled mySQL and it dropped your ancient values about max_allowed_packet

- your SQL was at the possible limit, you added something on it (some lines or such) or decided to regroup queries, and the packet becomes too big.

 

In order to avoid that issue coming back, either :

- cut your SQL query which bugs in multiple little queries (instead of having one big query of 5000 entries, you make 5 of 1000 entries).

- up max_allowed_packet value (tempoary solution as it is linked to your own mySQL installation and so on others mySQL servers it could be too short).

[xXObanXx]

Two possibilities :

- you reinstalled mySQL and it dropped your ancient values about max_allowed_packet

- your SQL was at the possible limit, you added something on it (some lines or such) or decided to regroup queries, and the packet becomes too big.

 

In order to avoid that issue coming back, either :

- cut your SQL query which bugs in multiple little queries (instead of having one big query of 5000 entries, you make 5 of 1000 entries).

- up max_allowed_packet value (tempoary solution as it is linked to your own mySQL installation and so on others mySQL servers it could be too short).

 

1. i reinstalled mysql 2 times to see if is from mysql side the problem! but nothing

2. i do that... i make npc.sql, 5 files to make mysql to can take this!