Jump to content
  • 0

need help about this problem

mitsumei

Asked by mitsumei,

 Share

Question

mitsumei Poring

mitsumei

Posted
  • Group:  Members
  • Topic Count:  7
  • Topics Per Day:  0.00
  • Content Count:  10
  • Reputation:   0
  • Joined:  02/09/12
  • Last Seen:  
Posted 

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

Link to comment
Share on other sites

5 answers to this question

Recommended Posts

Asura Poring

Asura

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
darking123 Poring

darking123

Posted
  • Group:  Members
  • Topic Count:  318
  • Topics Per Day:  0.07
  • Content Count:  931
  • Reputation:   13
  • Joined:  12/20/11
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
Asura Poring

Asura

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  
Posted

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.

Link to comment
Share on other sites
darking123 Poring

darking123

Posted
  • Group:  Members
  • Topic Count:  318
  • Topics Per Day:  0.07
  • Content Count:  931
  • Reputation:   13
  • Joined:  12/20/11
  • Last Seen:  
Posted

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

Link to comment
Share on other sites
Asura Poring

Asura

Posted
  • Group:  Members
  • Topic Count:  3
  • Topics Per Day:  0.00
  • Content Count:  707
  • Reputation:   168
  • Joined:  01/26/12
  • Last Seen:  
Posted

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.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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.

×
 Share
Go to question listing
×
×
  • Create New...