need help about this problem

[mitsumei]

SQL]: DB error - MySQL server has gone away
[Debug]: at char.c:3025 - INSERT INTO `sc_data` (`account_id`, `char_id`, `type`, `tick`, `val1`, `val2`, `val3`, `val4`) VALUES ('2000576','151269','29','199130','10','50','0','0'), ('2000576','151269','30','199130','10','10','0','0'), ('2000576','151269','32','199130','10','12','0','0')
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:746 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`='151269'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:508 - UPDATE `char` SET `base_level`='255', `job_level`='100',`base_exp`='3947826999', `job_exp`='167071930', `zeny`='181809281',`max_hp`='80421',`hp`='38248',`max_sp`='4182',`sp`='5998',`status_point`='10',`skill_point`='20',`str`='255',`agi`='1',`vit`='100',`int`='168',`dex`='150',`luk`='1',`option`='0',`party_id`='0',`guild_id`='43',`pet_id`='0',`homun_id`='0',`weapon`='12',`shield`='4',`head_top`='226',`head_mid`='1042',`head_bottom`='894',`last_map`='lhz_dun02',`last_x`='120',`last_y`='247',`save_map`='merullian',`save_x`='105',`save_y`='58', `rename`='0',`delete_date`='0',`robe`='0' WHERE  `account_id`='2000576' AND `char_id` = '151269'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:602 - DELETE FROM `skill` WHERE `char_id`='151269'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:623 - INSERT INTO `skill`(`char_id`,`id`,`lv`) VALUES ('151269','1','9'),('151269','22','10'),('151269','23','10'),('151269','24','1'),('151269','25','1'),('151269','26','2'),('151269','27','4'),('151269','28','3'),('151269','29','10'),('151269','30','10'),('151269','31','0'),('151269','32','0'),('151269','33','0'),('151269','34','10'),('151269','35','0'),('151269','142','1'),('151269','156','1'),('151269','259','10'),('151269','260','5'),('151269','261','5'),('151269','262','1'),('151269','263','10'),('151269','264','1'),('151269','265','10'),('151269','266','3'),('151269','267','5'),('151269','268','3'),('151269','269','5'),('151269','270','5'),('151269','271','5'),('151269','272','3'),('151269','273','3'),('151269','370','5'),('151269','371','0'),('151269','401','1'),('151269','1015','1'),('151269','1016','1')
[info]: Saved char 151269 - Fantasy: skills.
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:301 - UPDATE `char` SET `online`='0' WHERE `char_id`='151269'
[status]: set users GYRO : 8
[sql]: DB error - MySQL server has gone away
[Debug]: at int_guild.c:248 - UPDATE `guild` SET `connect_member`=0, `average_lv`=255 WHERE `guild_id`=43
[sql]: DB error - MySQL server has gone away
[Debug]: at int_guild.c:272 - REPLACE INTO `guild_member` (`guild_id`,`account_id`,`char_id`,`hair`,`hair_color`,`gender`,`class`,`lv`,`exp`,`exp_payper`,`online`,`position`,`name`) VALUES ('43','2000576','151269','29','111','0','4016','255','356348287','0','0','0','Fantasy')
[info]: Saved guild (43 - Fundamentals): connect members
[info]: Session #6 timed out
[info]: Character 'Duterte' logged off.
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:3025 - INSERT INTO `sc_data` (`account_id`, `char_id`, `type`, `tick`, `val1`, `val2`, `val3`, `val4`) VALUES ('2000121','150253','29','223500','10','50','0','0'), ('2000121','150253','30','223500','10','10','0','0'), ('2000121','150253','32','223500','10','12','0','0')
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:746 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`='150253'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:508 - UPDATE `char` SET `base_level`='255', `job_level`='100',`base_exp`='1823045000', `job_exp`='167071930', `zeny`='493101827',`max_hp`='100041',`hp`='211543',`max_sp`='1338',`sp`='1467',`status_point`='9',`skill_point`='0',`str`='221',`agi`='1',`vit`='110',`int`='1',`dex`='126',`luk`='221',`option`='0',`party_id`='0',`guild_id`='10',`pet_id`='0',`homun_id`='0',`weapon`='29',`shield`='0',`head_top`='380',`head_mid`='1042',`head_bottom`='1045',`last_map`='merullian',`last_x`='108',`last_y`='80',`save_map`='merullian',`save_x`='105',`save_y`='58', `rename`='0',`delete_date`='0',`robe`='0' WHERE  `account_id`='2000121' AND `char_id` = '150253'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:301 - UPDATE `char` SET `online`='0' WHERE `char_id`='150253'
[status]: set users GYRO : 7

[Debug]: at inter.c:120 - INSERT INTO `global_reg_value` (`type`, `account_id`, `char_id`, `str`, `value`) VALUES ('3','0','150253',?,?)
[sql]: DB error - Statement not prepared
[Debug]: at inter.c:120 - INSERT INTO `global_reg_value` (`type`, `account_id`, `char_id`, `str`, `value`) VALUES ('3','0','150253',?,?)
[sql]: DB error - Statement not prepared
[Debug]: at inter.c:120 - INSERT INTO `global_reg_value` (`type`, `account_id`, `char_id`, `str`, `value`) VALUES ('3','0','150253',?,?)
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:746 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`='150253'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:508 - UPDATE `char` SET `base_level`='255', `job_level`='100',`base_exp`='1823045000', `job_exp`='167071930', `zeny`='493101827',`max_hp`='100041',`hp`='211543',`max_sp`='1338',`sp`='1467',`status_point`='9',`skill_point`='0',`str`='221',`agi`='1',`vit`='110',`int`='1',`dex`='126',`luk`='221',`option`='0',`party_id`='0',`guild_id`='10',`pet_id`='0',`homun_id`='0',`weapon`='29',`shield`='0',`head_top`='380',`head_mid`='1042',`head_bottom`='1045',`last_map`='merullian',`last_x`='108',`last_y`='80',`save_map`='merullian',`save_x`='105',`save_y`='58', `rename`='0',`delete_date`='0',`robe`='0' WHERE  `account_id`='2000121' AND `char_id` = '150253'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:301 - UPDATE `char` SET `online`='0' WHERE `char_id`='151303'
[status]: set users GYRO : 9
[info]: Character 'Fantasy' logged off.
[status]: Request for connection of Fantasy (ip: 121.54.34.86).
[Notice]: Authentication accepted (account: Fantasy, id: 2000576, ip: 121.54.34.86)
[Notice]: User 'Fantasy' is already online - Rejected.
[info]: Closed connection from '121.54.34.86'.
[status]: Request for connection of Fantasy (ip: 121.54.34.86).
[Notice]: Authentication accepted (account: Fantasy, id: 2000576, ip: 121.54.34.86)
[Notice]: User 'Fantasy' is already online - Rejected.
[info]: Closed connection from '121.54.34.86'.
[status]: Request for connection of Fantasy (ip: 121.54.34.86).
[Notice]: Authentication accepted (account: Fantasy, id: 2000576, ip: 121.54.34.86)
[Notice]: User 'Fantasy' is already online - Rejected.
[info]: Closed connection from '121.54.34.86'.
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:3025 - INSERT INTO `sc_data` (`account_id`, `char_id`, `type`, `tick`, `val1`, `val2`, `val3`, `val4`) VALUES ('2000576','151269','29','199130','10','50','0','0'), ('2000576','151269','30','199130','10','10','0','0'), ('2000576','151269','32','199130','10','12','0','0')
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:746 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`='151269'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:508 - UPDATE `char` SET `base_level`='255', `job_level`='100',`base_exp`='3947826999', `job_exp`='167071930', `zeny`='181809281',`max_hp`='80421',`hp`='38248',`max_sp`='4182',`sp`='5998',`status_point`='10',`skill_point`='20',`str`='255',`agi`='1',`vit`='100',`int`='168',`dex`='150',`luk`='1',`option`='0',`party_id`='0',`guild_id`='43',`pet_id`='0',`homun_id`='0',`weapon`='12',`shield`='4',`head_top`='226',`head_mid`='1042',`head_bottom`='894',`last_map`='lhz_dun02',`last_x`='120',`last_y`='247',`save_map`='merullian',`save_x`='105',`save_y`='58', `rename`='0',`delete_date`='0',`robe`='0' WHERE  `account_id`='2000576' AND `char_id` = '151269'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:602 - DELETE FROM `skill` WHERE `char_id`='151269'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:623 - INSERT INTO `skill`(`char_id`,`id`,`lv`) VALUES ('151269','1','9'),('151269','22','10'),('151269','23','10'),('151269','24','1'),('151269','25','1'),('151269','26','2'),('151269','27','4'),('151269','28','3'),('151269','29','10'),('151269','30','10'),('151269','31','0'),('151269','32','0'),('151269','33','0'),('151269','34','10'),('151269','35','0'),('151269','142','1'),('151269','156','1'),('151269','259','10'),('151269','260','5'),('151269','261','5'),('151269','262','1'),('151269','263','10'),('151269','264','1'),('151269','265','10'),('151269','266','3'),('151269','267','5'),('151269','268','3'),('151269','269','5'),('151269','270','5'),('151269','271','5'),('151269','272','3'),('151269','273','3'),('151269','370','5'),('151269','371','0'),('151269','401','1'),('151269','1015','1'),('151269','1016','1')
[info]: Saved char 151269 - Fantasy: skills.
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:301 - UPDATE `char` SET `online`='0' WHERE `char_id`='151269'
[status]: set users GYRO : 8
[sql]: DB error - MySQL server has gone away
[Debug]: at int_guild.c:248 - UPDATE `guild` SET `connect_member`=0, `average_lv`=255 WHERE `guild_id`=43
[sql]: DB error - MySQL server has gone away
[Debug]: at int_guild.c:272 - REPLACE INTO `guild_member` (`guild_id`,`account_id`,`char_id`,`hair`,`hair_color`,`gender`,`class`,`lv`,`exp`,`exp_payper`,`online`,`position`,`name`) VALUES ('43','2000576','151269','29','111','0','4016','255','356348287','0','0','0','Fantasy')
[info]: Saved guild (43 - Fundamentals): connect members
[info]: Session #6 timed out
[info]: Character 'Duterte' logged off.
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:3025 - INSERT INTO `sc_data` (`account_id`, `char_id`, `type`, `tick`, `val1`, `val2`, `val3`, `val4`) VALUES ('2000121','150253','29','223500','10','50','0','0'), ('2000121','150253','30','223500','10','10','0','0'), ('2000121','150253','32','223500','10','12','0','0')
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:746 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`='150253'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:508 - UPDATE `char` SET `base_level`='255', `job_level`='100',`base_exp`='1823045000', `job_exp`='167071930', `zeny`='493101827',`max_hp`='100041',`hp`='211543',`max_sp`='1338',`sp`='1467',`status_point`='9',`skill_point`='0',`str`='221',`agi`='1',`vit`='110',`int`='1',`dex`='126',`luk`='221',`option`='0',`party_id`='0',`guild_id`='10',`pet_id`='0',`homun_id`='0',`weapon`='29',`shield`='0',`head_top`='380',`head_mid`='1042',`head_bottom`='1045',`last_map`='merullian',`last_x`='108',`last_y`='80',`save_map`='merullian',`save_x`='105',`save_y`='58', `rename`='0',`delete_date`='0',`robe`='0' WHERE  `account_id`='2000121' AND `char_id` = '150253'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:301 - UPDATE `char` SET `online`='0' WHERE `char_id`='150253'
[status]: set users GYRO : 7
[info]: Session #8 timed out
[info]: Character 'Tolputs D 1' logged off.
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:3025 - INSERT INTO `sc_data` (`account_id`, `char_id`, `type`, `tick`, `val1`, `val2`, `val3`, `val4`) VALUES ('2000240','150644','30','44418','10','10','0','0'), ('2000240','150644','32','43517','10','12','0','0'), ('2000240','150644','55','1629834','0','100','0','0'), ('2000240','150644','56','1630049','0','150','0','0'), ('2000240','150644','57','1630565','0','200','0','0'), ('2000240','150644','59','101457','0','0','0','0'), ('2000240','150644','76','109790','10','30','0','0'), ('2000240','150644','77','216789','10','40','0','0'), ('2000240','150644','121','54006','5','3','0','0'), ('2000240','150644','159','109098','1','0','0','0')
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:746 - SELECT `id`, `nameid`, `amount`, `equip`, `identify`, `refine`, `attribute`, `expire_time`, `card0`, `card1`, `card2`, `card3` FROM `inventory` WHERE `char_id`='150644'
[sql]: DB error - MySQL server has gone away
[Debug]: at char.c:301 - UPDATE `char` SET `online`='0' WHERE `char_id`='150644'
[sql]: DB error - MySQL server has gone away
[Debug]: at int_guild.c:248 - UPDATE `guild` SET `connect_member`=1, `average_lv`=255 WHERE `guild_id`=10
[sql]: DB error - MySQL server has gone away
[Debug]: at int_guild.c:272 - REPLACE INTO `guild_member` (`guild_id`,`account_id`,`char_id`,`hair`,`hair_color`,`gender`,`class`,`lv`,`exp`,`exp_payper`,`online`,`position`,`name`) VALUES ('10','2000121','150253','41','224','1','4013','255','0','0','0','19','Duterte')
[info]: Saved guild (10 - Saint Cookies): connect members

our database is not hosted to where are server is hosted...they are separated..please help

[Asura]

Hi mitsumei,

This occurs when the MySQL server lags or times out and closes the connection. The only thing you can do is modify the MySQL configuration's 'wait_timeout' value, and increase it; then restart MySQL.

http://lmgtfy.com/?q=modify+mysql+wait_timeout

[darking123]

sir asura can you guide me on how to make my server auto restart when it crashed because i do not now what do edit here and where to put

my server files is located /home/testserverfile

#!/bin/bash
run=1
if [ "$run" -eq 1 ]; then
if [ $(ps | grep -e login-server | wc -l) -eq 0 ]; then
# Login server down
./login-server_sql & > /dev/null
fi
if [ $(ps | grep -e char-server | wc -l) -eq 0 ]; then
# Char server down
./char-server_sql & > /dev/null
fi
if [ $(ps | grep -e map-server | wc -l) -eq 0 ]; then
# Map server down
./map-server_sql & > /dev/null
fi
sleep 10
./auto-restarter.sh &
fi

[Asura]

Hi glemor123,

I would rather you did not ask me, and forward the question to the community instead. This script is suppose to be saved as a bash script named 'auto-restarter.sh'. Place this file inside your trunk folder, and then modify the permissions for it to be fully executable.

Once completed with these steps, simply run that bash script; and it should begin the auto-restart process if it detects a crash on either the login, map, or char servers.

[darking123]

sir asura so i wont be editing anything to this script

or should i edit /dev/null???if i will be editing it what will i put

#!/bin/bash
run=1
if [ "$run" -eq 1 ]; then
if [ $(ps | grep -e login-server | wc -l) -eq 0 ]; then
# Login server down
./login-server_sql & > /dev/null
fi
if [ $(ps | grep -e char-server | wc -l) -eq 0 ]; then
# Char server down
./char-server_sql & > /dev/null
fi
if [ $(ps | grep -e map-server | wc -l) -eq 0 ]; then
# Map server down
./map-server_sql & > /dev/null
fi
sleep 10
./auto-restarter.sh &
fi

[Asura]

Hi glemor123,

Please don't hijack someone's topic; and as I stated before... open the question to rAthena's community, not me.

And you don't have to edit the script, cause the /dev/null just means that it outputs the results of the process to NOTHING. So it does not waste your VPS's space/resources... the script itself looks fine, I don't see why you feel the absolute need to edit something.