• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Windows [SQL] Got error reading communication packets

potinho

Intermediate OT User
Joined
Oct 11, 2009
Messages
1,397
Solutions
17
Reaction score
148
Location
Brazil
Hello everyone, everything good?

A few days ago I have noticed that my server has been giving errors in some tables (which I always repair in PHPMyAdmin), but they come back. Another thing that caught my attention is the error when reading communication packets, apparently it doesn't affect the game, but I'm afraid of crashing at some point. I read several topics and already increased my settings in SQL, as below:

# enable-named-pipe
key_buffer=16M
max_allowed_packet=256M
sort_buffer_size=512K
net_buffer_length=8K
read_buffer_size=256K
read_rnd_buffer_size=512K
myisam_sort_buffer_size=8M
log_error="mysql_error.log"


2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\auction_system' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\auction_system'
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\z_ots_comunication' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\z_ots_comunication'
2021-11-12 8:09:14 8 [ERROR] mysqld.exe: Table '.\ots\z_shop_history_item' is marked as crashed and should be repaired
2021-11-12 8:09:14 8 [Warning] Checking table: '.\ots\z_shop_history_item'
2021-11-12 9:33:05 8 [Warning] Aborted connection 8 to db: 'ots' user: 'xxx' host: 'localhost' (Got an error reading communication packets)
2021-11-12 14:12:52 82 [Warning] Aborted connection 82 to db: 'ots' user: 'xxx' host: 'localhost' (Got an error reading communication packets)
 
@potinho Not sure of whats happening, anyways, I leave you some options so you can start searching for the error. Always remember to backup the database and try to solutions mentioned below.

Option 1: do this for every crashed table.

Tcrwz.png


Option 2: use the following links and search the problem


Hope it helps, regards!
 
Back
Top