Author Topic: "MySQL has gone away" (Read 1554 times)

dioniz84 · « **on:** December 10, 2009, 09:24:52 am »

I get this error after random time of running bebot. The only change I did was to add !yg and !bound modules to the bot. But it's not the issue I think. Bot starst and even is working for some time. Then "ding" I get this msg: 'MySQL has gone away ...' . And the bot crashes after some time.

I run bebot on Ubuntu VPS and I have no ideahow to fix this. Any ideas??

dioniz84 · « **Reply #1 on:** December 11, 2009, 01:22:56 pm »

I give you more detail. Any info would be appreciated.

Code: [Select]

MySQL ERROR(# 37) on query: Unable to select database bebot Database not found or insufficient priviledges!
MySQL server has gone awayMySQL ERROR(# 38) on query: SELECT * FROM whois WHERE nickname = 'Anngua'
MySQL server has gone awayMySQL ERROR(# 39) on query: Unable to select database bebot Database not found or insufficient priviledges!
MySQL server has gone awayMySQL ERROR(# 40) on query: SELECT * FROM craftingclass WHERE name = 'Anngua'
MySQL server has gone awayMySQL ERROR(# 41) on query: Unable to select database bebot Database not found or insufficient priviledges!
MySQL server has gone awayMySQL ERROR(# 42) on query: INSERT INTO whois (id, nickname, level, class, craft1, craft2, location, online, updated) VALUES ('16888987', 'Anngua', '79', 'Ranger', '', '', 4507141, 1, '1260464832') ON DUPLICATE KEY UPDATE id = VALUES(id), level = VALUES(level), class = VALUES(class), craft1 = VALUES(craft1), craft2 = VALUES(craft2), online = VALUES(online), location = VALUES(location),  updated = VALUES(updated)
MySQL server has gone awayMySQL ERROR(# 43) on query: Unable to select database bebot Database not found or insufficient priviledges!
MySQL server has gone awayMySQL ERROR(# 44) on query: SELECT char_id FROM quinzi_users WHERE nickname = 'Anngua'

Getrix · « **Reply #2 on:** December 11, 2009, 02:14:42 pm »

What costume modules are you using?

Do the MySQL setup have default Ubuntu installation?

dioniz84 · « **Reply #3 on:** December 11, 2009, 03:29:32 pm »

I had :
!ginfo
!items - your's

!raidweapons
!skils - skills calculator
Was working perfectly.
I added:
!yg
!bound
!autogratz
I saw that !autogratz wasn't working at all. Was getting some errors so I removed it. The rest is fine, bot is starting., working for 5-15 min. and then "bum". MySQL goead down. Strange.