[Release] MySQL Async Library - 3.3.2

zr0iq · June 18, 2019, 10:06pm

It will increase in time. You can click on the legend to hide certain items. Hitch warnings might come from different sources.

JoshhIM · June 18, 2019, 10:24pm

Screenshot_556
Current server screenshot
Any pointers to deal with this?

Michael_Sanelli · June 18, 2019, 10:32pm

Sorry for my ignorance, how can I see this graph?

CyrexV2 · June 18, 2019, 10:32pm

type mysql in f8

Michael_Sanelli · June 18, 2019, 10:36pm

thanks!

JoshhIM · June 18, 2019, 10:50pm

Tracing the hitches back to async too Screenshot_560

zr0iq · June 19, 2019, 8:07am

Could you show the slowest query part, sorted by execution time?

CyrexV2 · June 19, 2019, 8:30am

Are these meant to be like this?

JoshhIM · June 19, 2019, 9:41am

Definitely, no

JoshhIM · June 19, 2019, 11:14am

These are mine

zr0iq · June 19, 2019, 12:43pm

Does the hitching tick only happen at start up or at some later time? Does the issue persist if you switch to let’s say 3.0.8 (which uses an older mysql.js version)?

JoshhIM · June 19, 2019, 1:01pm

Seems to happen once we reach 20+ players. I’ll try 3.0.8 tonight

zr0iq · June 20, 2019, 7:07am

What are your results?

JoshhIM · June 20, 2019, 3:18pm

Errors with 3.0.8 - not able to use it.

Sabuda · June 24, 2019, 3:31pm

I get this error with an older c# version and I cannot fix it

[ERROR] [MySQL] An critical error happens on MySQL for query “SELECT phone_users_contacts.id, phone_users_contacts.number, phone_users_contacts.display FROM phone_users_contacts WHERE phone_users_contacts.identifier = @identifier {@identifier=steam:11000010eb604d3}”: Method ‘System.Security.Cryptography.X509Certificates.X509Certificate2…ctor’ not found. at System.Runtime.CompilerServices.AsyncTaskMethodBuilder.Start[TStateMachine] (TStateMachine& stateMachine) [0x0002c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySql.Data.Serialization.MySqlSession.InitSslAsync (MySql.Data.Serialization.ProtocolCapabilities serverCapabilities, MySql.Data.Serialization.ConnectionSettings cs, MySql.Data.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00044] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
at MySql.Data.Serialization.MySqlSession+d__49.MoveNext () [0x003da] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySql.Data.MySqlClient.ConnectionPool+d__0.MoveNext () [0x00467] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at MySql.Data.MySqlClient.MySqlConnection+<CreateSessionAsync>d__68.MoveNext () [0x00102] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0 --- End of stack trace from previous location where exception was thrown --- at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 at System.Runtime.CompilerServices.ConfiguredTaskAwaitable1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySql.Data.MySqlClient.MySqlConnection+d__19.MoveNext () [0x000cb] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
— End of stack trace from previous location where exception was thrown —
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Runtime.CompilerServices.TaskAwaiter.GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at MySql.Data.MySqlClient.MySqlConnection.Open () [0x00012] in <5d2e43c2aa6f4da0bb43a6a12077ad51>:0
at MySQLAsync.Operation1[TResult].Execute (System.String query, System.Collections.Generic.IDictionary2[TKey,TValue] parameters, System.Boolean debug) [0x00020] in <6b79789832b34a31961dbb39358e1b3f>:0

Michael_Sanelli · June 27, 2019, 6:48pm

no news about this?

ArsyanRidz · June 28, 2019, 2:52am

I have the issue with my server. Do you know how to fix it?

[ERROR] connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [gcphone] An error happens on MySQL for query "DELETE FROM phone_messages WHERE (DATEDIFF(CURRENT_DATE,time) > 10)": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [es_extended] An error happens on MySQL for query "SELECT * FROM items": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [es_extended] An error happens on MySQL for query "SELECT * FROM jobs": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [FiveM-Bansql] An error happens on MySQL for query "SELECT * FROM banlist": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [FiveM-Bansql] An error happens on MySQL for query "SELECT * FROM banlisthistory": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicle_categories": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_weaponshop] An error happens on MySQL for query "SELECT * FROM weashops": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_datastore] An error happens on MySQL for query "SELECT * FROM datastore": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_boatshop] An error happens on MySQL for query "SELECT * FROM boat_categories": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_addoninventory] An error happens on MySQL for query "SELECT * FROM items": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_addonaccount] An error happens on MySQL for query "SELECT * FROM addon_account": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_aircraftshop] An error happens on MySQL for query "SELECT * FROM aircraft_categories": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_advancedgarage] An error happens on MySQL for query "UPDATE owned_vehicles SET `stored` = true WHERE `stored` = false": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_shops] An error happens on MySQL for query "SELECT * FROM shops LEFT JOIN items ON items.name = shops.item": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_truckshop] An error happens on MySQL for query "SELECT * FROM truck_categories": connect ECONNREFUSED 127.0.0.1:3306
Error running call reference function for resource es_extended: citizen:/scripting/lua/scheduler.lua:405: @es_extended/server/common.lua:23: attempt to get length of a nil value (local 'result')
stack traceback:
@es_extended/server/common.lua:23: in upvalue 'ref'
citizen:/scripting/lua/scheduler.lua:391: in function <citizen:/scripting/lua/scheduler.lua:390>
[C]: in function 'xpcall'
citizen:/scripting/lua/scheduler.lua:390: in function <citizen:/scripting/lua/scheduler.lua:389>
stack traceback:
[C]: in function 'error'
citizen:/scripting/lua/scheduler.lua:405: in function <citizen:/scripting/lua/scheduler.lua:374>
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
at h (citizen:/scripting/v8/msgpack.js:29:15761)
at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
at unpack (citizen:/scripting/v8/main.js:20:33)
at citizen:/scripting/v8/main.js:51:20
at setImmediate (mysql-async.js:14898:7)
at Object.callback (citizen:/scripting/v8/timer.js:96:21)
Error running call reference function for resource FiveM-Bansql: citizen:/scripting/lua/scheduler.lua:405: @FiveM-Bansql/server.lua:369: attempt to get length of a nil value (local 'data')
stack traceback:
@FiveM-Bansql/server.lua:369: in upvalue 'ref'
citizen:/scripting/lua/scheduler.lua:391: in function <citizen:/scripting/lua/scheduler.lua:390>
[C]: in function 'xpcall'
citizen:/scripting/lua/scheduler.lua:390: in function <citizen:/scripting/lua/scheduler.lua:389>
stack traceback:
[C]: in function 'error'
citizen:/scripting/lua/scheduler.lua:405: in function <citizen:/scripting/lua/scheduler.lua:374>
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
at h (citizen:/scripting/v8/msgpack.js:29:15761)
at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
at unpack (citizen:/scripting/v8/main.js:20:33)
at citizen:/scripting/v8/main.js:51:20
at setImmediate (mysql-async.js:14898:7)
at Object.callback (citizen:/scripting/v8/timer.js:96:21)
Error running call reference function for resource FiveM-Bansql: citizen:/scripting/lua/scheduler.lua:405: @FiveM-Bansql/server.lua:393: attempt to get length of a nil value (local 'data')
stack traceback:
@FiveM-Bansql/server.lua:393: in upvalue 'ref'
citizen:/scripting/lua/scheduler.lua:391: in function <citizen:/scripting/lua/scheduler.lua:390>
[C]: in function 'xpcall'
citizen:/scripting/lua/scheduler.lua:390: in function <citizen:/scripting/lua/scheduler.lua:389>
stack traceback:
[C]: in function 'error'
citizen:/scripting/lua/scheduler.lua:405: in function <citizen:/scripting/lua/scheduler.lua:374>
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
at h (citizen:/scripting/v8/msgpack.js:29:15761)
at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
at unpack (citizen:/scripting/v8/main.js:20:33)
at citizen:/scripting/v8/main.js:51:20
at setImmediate (mysql-async.js:14898:7)
at Object.callback (citizen:/scripting/v8/timer.js:96:21)
Error running call reference function for resource esx_weaponshop: citizen:/scripting/lua/scheduler.lua:405: @esx_weaponshop/server/main.lua:9: attempt to get length of a nil value (local 'result')
stack traceback:
@esx_weaponshop/server/main.lua:9: in upvalue 'ref'
citizen:/scripting/lua/scheduler.lua:391: in function <citizen:/scripting/lua/scheduler.lua:390>
[C]: in function 'xpcall'
citizen:/scripting/lua/scheduler.lua:390: in function <citizen:/scripting/lua/scheduler.lua:389>
stack traceback:
[C]: in function 'error'
citizen:/scripting/lua/scheduler.lua:405: in function <citizen:/scripting/lua/scheduler.lua:374>
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
at h (citizen:/scripting/v8/msgpack.js:29:15761)
at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
at unpack (citizen:/scripting/v8/main.js:20:33)
at citizen:/scripting/v8/main.js:51:20
at setImmediate (mysql-async.js:14898:7)
at Object.callback (citizen:/scripting/v8/timer.js:96:21)
Error running call reference function for resource esx_shops: citizen:/scripting/lua/scheduler.lua:405: @esx_shops/server/main.lua:8: attempt to get length of a nil value (local 'shopResult')
stack traceback:
@esx_shops/server/main.lua:8: in upvalue 'ref'
citizen:/scripting/lua/scheduler.lua:391: in function <citizen:/scripting/lua/scheduler.lua:390>
[C]: in function 'xpcall'
citizen:/scripting/lua/scheduler.lua:390: in function <citizen:/scripting/lua/scheduler.lua:389>
stack traceback:
[C]: in function 'error'
citizen:/scripting/lua/scheduler.lua:405: in function <citizen:/scripting/lua/scheduler.lua:374>
Error: Unhandled error in timer: Error: BUFFER_SHORTAGE
Error: BUFFER_SHORTAGE
at n.e [as reserve] (citizen:/scripting/v8/msgpack.js:29:12766)
at h (citizen:/scripting/v8/msgpack.js:29:15761)
at n.r [as decode] (citizen:/scripting/v8/msgpack.js:29:13908)
at n.fetch (citizen:/scripting/v8/msgpack.js:29:6972)
at n.u [as read] (citizen:/scripting/v8/msgpack.js:29:12076)
at Object.n [as decode] (citizen:/scripting/v8/msgpack.js:29:7097)
at unpack (citizen:/scripting/v8/main.js:20:33)
at citizen:/scripting/v8/main.js:51:20
at setImmediate (mysql-async.js:14898:7)
at Object.callback (citizen:/scripting/v8/timer.js:96:21)
[ERROR] [MySQL] [esx_locksystem] An error happens on MySQL for query "SELECT `plate`, `owner` FROM owned_vehicles": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_property] An error happens on MySQL for query "SELECT * FROM properties": connect ECONNREFUSED 127.0.0.1:3306
[ERROR] [MySQL] [esx_society] An error happens on MySQL for query "SELECT * FROM jobs": connect ECONNREFUSED 127.0.0.1:3306
Error resuming coroutine: @es_extended/server/common.lua:35: attempt to get length of a nil value (local 'result')
stack traceback:
@es_extended/server/common.lua:35: in upvalue 'callback'
@mysql-async/lib/MySQL.lua:194: in function <@mysql-async/lib/MySQL.lua:186>
Error resuming coroutine: @esx_datastore/server/main.lua:11: attempt to get length of a nil value (local 'result')
stack traceback:
@esx_datastore/server/main.lua:11: in upvalue 'callback'
@mysql-async/lib/MySQL.lua:194: in function <@mysql-async/lib/MySQL.lua:186>
Error resuming coroutine: @esx_addoninventory/server/main.lua:13: attempt to get length of a nil value (local 'items')
stack traceback:
@esx_addoninventory/server/main.lua:13: in upvalue 'callback'
@mysql-async/lib/MySQL.lua:194: in function <@mysql-async/lib/MySQL.lua:186>
Error resuming coroutine: @esx_addonaccount/server/main.lua:11: attempt to get length of a nil value (local 'result')
stack traceback:
@esx_addonaccount/server/main.lua:11: in upvalue 'callback'
@mysql-async/lib/MySQL.lua:194: in function <@mysql-async/lib/MySQL.lua:186>
Error running call reference function for resource esx_locksystem: citizen:/scripting/lua/scheduler.lua:405: @esx_locksystem/server/server.lua:16: bad argument #1 to 'pairs' (table expected, got nil)
stack traceback:
[C]: in function 'pairs'
@esx_locksystem/server/server.lua:16: in upvalue 'ref'
citizen:/scripting/lua/scheduler.lua:391: in function <citizen:/scripting/lua/scheduler.lua:390>
[C]: in function 'xpcall'
citizen:/scripting/lua/scheduler.lua:390: in function <citizen:/scripting/lua/scheduler.lua:389>
stack traceback:
[C]: in function 'error'
citizen:/scripting/lua/scheduler.lua:405: in function <citizen:/scripting/lua/scheduler.lua:374>

zr0iq · June 28, 2019, 8:35am

@Michael_Sanelli about what?

@ArsyanRidz “I got an issue, mysql connection to my server was refused”, does not really help trouble shooting the issue, it can be a lot of stuff. Can you connect with another external program like heidisql?

ArsyanRidz · June 28, 2019, 8:54am

i only connect to my localhost phpmyadmin

Michael_Sanelli · June 28, 2019, 7:14pm

about the hitch warning and load server/side