Couple GameServer errors

[Walletman987]

Idk if any of you guys know how to fix this, but if you could point me in the right direction maybe I could help you out too

 

 

15-01-13 22:30:28,373 INFO  - bnf - create timer. handle: 2000004, start_sec: 5372, period_sec: 86400

2015-01-13 22:30:28,373 INFO  - :
2015-01-13 22:30:28,373 INFO  - DBProcess thread start .........................
2015-01-13 22:30:28,374 INFO  - ----- mysql disconnect / host[192.99.154.158] / database name[T_db]
2015-01-13 22:30:28,374 INFO  - ----- mysql disconnect / host[192.99.154.158] / database name[T_data]
Game1: /usr/local/include/boost-1_56/boost/thread/pthread/condition_variable.hpp:168: boost::condition_variable_any::~condition_variable_any(): Assertion `!pthread_mutex_destroy(&internal_mutex)' failed.
2015-01-13 22:30:28,374 FATAL - receive SIGNAL : 6
2015-01-13 22:30:28,374 INFO  - >> saving all user data because server down <<
2015-01-13 22:30:28,375 INFO  - DBProcess thread end .........................
2015-01-13 22:30:28,375 INFO  - DBProcess thread end .........................
 Error in `./Game1': double free or corruption (!prev): 0x3d758f10 
Aborted

 

query error (mysql_store_result) : error[] query[insert into t_characters_guildpoint select a_index, 0, 0 from t_characters]
2015-01-13 22:32:55,399 ERROR - query error (mysql_real_query) : error[Column count doesn't match value count at row 1] query[insert into t_extend_guild select a_index, 0, 5+a_level*5, 0, '', '', '' from t_guild]
2015-01-13 22:32:55,399 ERROR - query error (mysql_real_query) : error[Column count doesn't match value count at row 1] query[insert into t_extend_guildmember select a_guild_index, a_char_index, '', 0, 0, 0 from t_guildmember]
2015-01-13 22:32:55,401 INFO  - SYSTEM > SetCubeUpdateTime : 1421038800
2015-01-13 22:32:55,401 ERROR - query error (mysql_real_query) : error[Column count doesn't match value count at row 1] query[iNSERT DELAYED INTO t_guild_stash_log_backup SELECT * FROM t_guild_stash_log where a_date < DATE_SUB( NOW(), INTERVAL 1 MONTH );]
2015-01-13 22:32:55,402 INFO  - SYSTEM > BACKUP GUILD_STASH LOG
2015-01-13 22:32:55,402 ERROR - query error (mysql_real_query) : error[unknown column 'a_syndicate_point_k' in 'field list'] query[sELECT a_nick, a_index, a_syndicate_point_k FROM t_characters WHERE a_syndicate_type = 1 and a_syndicate_point_k > 2078999999]
2015-01-13 22:32:55,402 ERROR - DB ERROR : LOAD CHARACTER SYNDICATE KING DATA / query[sELECT a_nick, a_index, a_syndicate_point_k FROM t_characters WHERE a_syndicate_type = 1 and a_syndicate_point_k > 2078999999] / error[unknown column 'a_syndicate_point_k' in 'field list']
2015-01-13 22:32:55,402 ERROR - query error (mysql_real_query) : error[unknown column 'a_syndicate_point_d' in 'field list'] query[sELECT a_nick, a_index, a_syndicate_point_d FROM t_characters WHERE a_syndicate_type = 2 and a_syndicate_point_d > 2078999999]
2015-01-13 22:32:55,402 ERROR - DB ERROR : LOAD CHARACTER SYNDICATE KING DATA / query[sELECT a_nick, a_index, a_syndicate_point_d FROM t_characters WHERE a_syndicate_type = 2 and a_syndicate_point_d > 2078999999] / error[unknown column 'a_syndicate_point_d' in 'field list']

 
Sorry, it's a ton of stuff, but I hope someone could help lol.

[pwesty]

query error (mysql_real_query) : error[Column count doesn't match value count at row 1] query[insert into t_characters_guildpoint select a_index, 0, 0 from t_characters]
2015-01-14 00:28:24,440 ERROR - query error (mysql_real_query) : error[Column count doesn't match value count at row 1] query[insert into t_extend_guild select a_index, 0, 5+a_level*5, 0, '', '', '' from t_guild]
2015-01-14 00:28:24,440 ERROR - query error (mysql_real_query) : error[Column count doesn't match value count at row 1] query[insert into t_extend_guildmember select a_guild_index, a_char_index, '', 0, 0, 0 from t_guildmember]

 

these are the only errors now for the Helper...

 

The GameServer crashes after everything is loaded

but also errors with this " EquipExchangeExtend Data Load Fail." at the beginning of it.

[Sickness]

Looking for help on unreleased stuff it seems! RVR stuff is being rejected in those errors

[pwesty]

RvR is controlled by? let me guess SubHelper?

[Nikolee]

You need the right Database for the Files, if you just leaked the Server then u have to rebuild the DB.

[pwesty]

You need the right Database for the Files, if you just leaked the Server then u have to rebuild the DB.

I know that much, basically rebuilding it from what i dont have, everything works but helper and gserver ^^

 

 

t_quest i literally had to change the row format to take the query im getting closer

[Nikolee]

Just rebuild it its not that hard ive done it.

[pwesty]

GameServer_d: /usr/local/include/boost-1_56/boost/thread/pthread/condition_variable.hpp:168: boost::condition_variable_any::~condition_variable_any(): Assertion `!pthread_mutex_destroy(&internal_mutex)' failed.
 

 

Still getting that error on the gameserver, it gets to the end

 

LastChaos Running

mysql connect start

async debug stuff

connects to database

then disconnects from _db and _data will that error code then a seg fault

[Douglas Farias]

try

download this

2

 

and install 

 

cd boost_1_56_0
./bootstrap.sh
./b2 -j2 --toolset=gcc --build-type=complete --layout=versioned link=static threading=multi install

[pwesty]

#CLOSE please!

 

i fixed the issue thank you all for the help