pBlueG / SA-MP-MySQL

MySQL plugin for San Andreas Multiplayer
BSD 3-Clause "New" or "Revised" License
194 stars 81 forks source link

Mysql crashing #248

Closed CnRXoMoX closed 3 years ago

CnRXoMoX commented 3 years ago

I have the code error

[05:22:05] [log-core] signal 11 (SIGSEGV) catched; shutting log-core down (errno: 0, signal code: -6, exit status: 0)

This is what my mysql.log

05:21:56] [DEBUG] CCallback::Execute(amx=0x8ccb680, index=306, num_params=2)
[05:21:56] [INFO] Executing callback 'MDCReportQueryFinish' with 2 parameters...
[05:21:56] [DEBUG] processing internal specifier 'c'
[05:21:56] [DEBUG] pushed value '0' onto AMX stack
[05:21:56] [DEBUG] processing internal specifier 'c'
[05:21:56] [DEBUG] pushed value '8' onto AMX stack
[05:21:56] [DEBUG] executing AMX callback with index '306'
[05:21:56] [DEBUG] cache_get_row_count(0xE60E4FB4) (./includes/mysql.pwn:3035)
[05:21:56] [DEBUG] cache_get_row_count: return value: '1' (./includes/mysql.pwn:3035)
[05:21:56] [DEBUG] AMX callback executed with error '0'
[05:21:56] [INFO] Callback successfully executed.
[05:22:05] [DEBUG] mysql_format(1, 0xDFDD2C98, 4096, "SELECT * FROM `shop_orders` WHERE `user_id` = %d AND `status` = 0") (./includes/timers.pwn:3025)
[05:22:05] [DEBUG] mysql_format: return value: '67' (./includes/timers.pwn:3025)
[05:22:05] [DEBUG] mysql_tquery(1, "SELECT * FROM `shop_orders` WHERE `user_id` = 3083 AND `status` = 0", "ExecuteShopQueue", "ii") (./includes/timers.pwn:3026)
[05:22:05] [DEBUG] CCallback::Create(amx=0x8ccb680, name='ExecuteShopQueue', format='ii', params=0xe60e4fa4, param_offset=5)
[05:22:05] [DEBUG] CCallback::Create - callback index for 'ExecuteShopQueue': 183
[05:22:05] [DEBUG] processing specifier 'i' with parameter index 0
(Crashed here)
CnRXoMoX commented 3 years ago

I fixed it here as soon as i fixed it there some new one appeared, The mysql.log doesn't make any sense here is the last lines

[12:37:36] [DEBUG] CResultSet::Create(connection=0xee33410, query_str='UPDATE `accounts` SET `Username`='Aj_nani' WHERE `Username`='Aj_Hatdog'')
[12:37:36] [DEBUG] created new resultset '0xdca51e70'
[12:37:36] [DEBUG] fetched MySQL result '0x0'
[12:37:36] [DEBUG] CCallback::Execute(amx=0x9809680, index=329, num_params=3)
[12:37:36] [INFO] Executing callback 'NationQueueQueryFinish' with 3 parameters...
[12:37:36] [DEBUG] processing internal specifier 'c'
[12:37:36] [DEBUG] pushed value '2' onto AMX stack
[12:37:36] [DEBUG] processing internal specifier 'c'
[12:37:36] [DEBUG] pushed value '0' onto AMX stack
[12:37:36] [DEBUG] processing internal specifier 'c'
[12:37:36] [DEBUG] pushed value '11' onto AMX stack
[12:37:36] [DEBUG] executing AMX callback with index '329'
[12:37:36] [DEBUG] cache_get_row_count(0xE60E1B14) (./includes/mysql.pwn:3215)
[12:37:36] [DEBUG] cache_get_row_count: return value: '1' (./includes/mysql.pwn:3215)
[12:37:36] [DEBUG] AMX callback executed with error '0'
[12:37:36] [INFO] Callback successfully executed.
[12:37:36] [DEBUG] CCallback::Execute(amx=0x9809680, index=-10058, num_params=2)
CnRXoMoX commented 3 years ago

Fixed this, some issue with the mysql_log turned to off (low_mem) and replaced the log-core.so