[Release] MySQL Async Library - 3.0.8

dev
mysql
basemods

#651

Why i can’t get any wanted level because of this mod? And how i can fix it?


#653

hello i got a problem in setup a server with the esx and mysql async can get some help?

[


image.png672×1034 18.4 KB

](https://forum.fivem.net/uploads/default/original/3X/9/f/9fbbbedc4484cfe76fb7f06d9320022f039e676f.png)


#654

Does anyone know how to fix this error ?


#655

does anyone know how to install this onto a root server?


#656

It’s a FiveM Server. What do you mean a root server?


#657

Meaning I bought a vps/rootserver from zap-hosting and am running my server off that.


#658

So what you’re saying is you run a FiveM server on a VPS. You install it like any other resource.


#659

What I’m saying is I don’t know how to set up a data base to get this to work with another mod


#660

That mod should offer you an sql file. You need to have an SQL server somewhere


#662

If someone or I come to the server Joine:

Error resuming coroutine: citizen:/scripting/lua/scheduler.lua:760: No such export mysql_fetch_all in resource mysql-async
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:760: in metamethod ‘__index’
@mysql-async/lib/MySQL.lua:143: in field ‘fetchAll’
server/main.lua:131: in local ‘task’
@async/async.lua:67: in local ‘processQueue’
@async/async.lua:86: in field ‘parallelLimit’
@async/async.lua:91: in field ‘series’
server/main.lua:189: in field ‘?’
@async/async.lua:21: in function <@async/async.lua:19>
Error resuming coroutine: citizen:/scripting/lua/scheduler.lua:760: No such export mysql_fetch_all in resource mysql-async
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:760: in metamethod ‘__index’
@mysql-async/lib/MySQL.lua:143: in field ‘fetchAll’
server/main.lua:51: in field ‘?’
@async/async.lua:21: in function <@async/async.lua:19>
Error resuming coroutine: citizen:/scripting/lua/scheduler.lua:760: No such export mysql_fetch_all in resource mysql-async
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:760: in metamethod ‘__index’
@mysql-async/lib/MySQL.lua:143: in field ‘fetchAll’
server/main.lua:28: in field ‘?’
@async/async.lua:21: in function <@async/async.lua:19>
Error resuming coroutine: citizen:/scripting/lua/scheduler.lua:760: No such export mysql_execute in resource mysql-asyncstack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/scheduler.lua:760: in metamethod ‘__index’
@mysql-async/lib/MySQL.lua:130: in field ‘execute’
server/main.lua:18: in field ‘?’
@async/async.lua:21: in function <@async/async.lua:19>


#665

please why i have this 1. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  1. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  2. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  3. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  4. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  5. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  6. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  7. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  8. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  9. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  10. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  11. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  12. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  13. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  14. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  15. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b

  16. WARNING: NON-EXISTENT NATIVE 000000004d52fe5b


#667

Hello, im getting an error whenever a player joins. https://gyazo.com/b502aaf7c39c4396e916ebd324d826c3


#668

can someone help me I have this MYSQL error


#669

Ideas?
[ERROR] [MySQL] An critical error happens on MySQL for query “SELECT * FROM addon_account_data WHERE account_name = @account_name {@account_name=bank_savings}”: Object reference not set to an instance of an object at MySqlConnector.Core.ConnectionPool.GetPool (System.String connectionString) [0x0001a] in <149068887d4e4bc08e7b4c05a59a923b>:0

at MySql.Data.MySqlClient.MySqlConnection+<CreateSessionAsync>d__83.MoveNext () [0x00012] in <149068887d4e4bc08e7b4c05a59a923b>:0

Loaded MySQLAsync.net, Version=2.1.1.0, Culture=neutral, PublicKeyToken=null into ScriptDomain_1702487978


#670

same problem


#671

System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. —> System.ArgumentOutOfRangeException: Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index
at System.ThrowHelper.ThrowArgumentOutOfRangeException (System.ExceptionArgument argument, System.ExceptionResource resource) [0x00029] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.ThrowHelper.ThrowArgumentOutOfRangeException () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Collections.Generic.List`1[T].get_Item (System.Int32 index) [0x00009] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at (wrapper dynamic-method) System.Object:CallSite.Target (System.Runtime.CompilerServices.Closure,System.Runtime.CompilerServices.CallSite,object,int)
at System.Dynamic.UpdateDelegates.UpdateAndExecute2[T0,T1,TRet] (System.Runtime.CompilerServices.CallSite site, T0 arg0, T1 arg1) [0x0010f] in <48501e5f32e8491e924f8b8beae3e4f6>:0
at CitizenFX.Core.MsgPackDeserializer+<>c__DisplayClass36_1.b__1 (System.Object res, System.Object err) [0x00246] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\MsgPackDeserializer.cs:290
at (wrapper managed-to-native) System.Reflection.MonoMethod:InternalInvoke (System.Reflection.MonoMethod,object,object[],System.Exception&)
at System.Reflection.MonoMethod.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00032] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
— End of inner exception stack trace —

Server stack trace:
at System.Reflection.MonoMethod.Invoke (System.Object obj, System.Reflection.BindingFlags invokeAttr, System.Reflection.Binder binder, System.Object[] parameters, System.Globalization.CultureInfo culture) [0x00048] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Reflection.MethodBase.Invoke (System.Object obj, System.Object[] parameters) [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Delegate.DynamicInvokeImpl (System.Object[] args) [0x000e7] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.MulticastDelegate.DynamicInvokeImpl (System.Object[] args) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at System.Delegate.DynamicInvoke (System.Object[] args) [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0
at CitizenFX.Core.FunctionReference.Invoke (System.Int32 reference, System.Byte[] arguments) [0x00062] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\FunctionReference.cs:65
at CitizenFX.Core.InternalManager.CallRef (System.Int32 refIndex, System.Byte[] argsSerialized, System.IntPtr& retvalSerialized, System.Int32& retvalSize) [0x00000] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\InternalManager.cs:273
at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager:CallRef (int,byte[],intptr&,int&)
at (wrapper xdomain-dispatch) CitizenFX.Core.InternalManager:CallRef (object,byte[]&,byte[]&,int,byte[],int&)

Exception rethrown at [0]:
at (wrapper xdomain-invoke) CitizenFX.Core.InternalManager:CallRef (int,byte[],intptr&,int&)
at (wrapper remoting-invoke-with-check) CitizenFX.Core.InternalManager:CallRef (int,byte[],intptr&,int&)
at CitizenFX.Core.MonoScriptRuntime.CallRef (System.Int32 refIndex, System.Byte[] argsSerialized, System.Int32 argsSize, System.IntPtr& retvalSerialized, System.Int32& retvalSize) [0x00013] in C:\gl\builds\4ff63adb\0\cfx\fivem\code\client\clrcore\MonoScriptRuntime.cs:195
Error resuming coroutine: citizen:/scripting/lua/MessagePack.lua:830: missing bytes
stack traceback:
[C]: in function ‘error’
citizen:/scripting/lua/MessagePack.lua:830: in method ‘underflow’
citizen:/scripting/lua/MessagePack.lua:465: in field ‘any’
citizen:/scripting/lua/MessagePack.lua:860: in field ‘unpack’
citizen:/scripting/lua/scheduler.lua:626: in field ‘cb’
citizen:/scripting/lua/scheduler.lua:397: in function citizen:/scripting/lua/scheduler.lua:387


#672

Does anyone know how to resolve this error?


#673

Try unloading some of your broken scripts. Comment them out and then test again one by one, uncommenting them out to see which one is the problem child. Seeing you have ESX, I am sure there are a ton of buggy/broken scripts.

An easy way to find the problem is go through the code in the Lua scripts and specifically look at their mysql query for one that might be performing a locking read. Another way is to run a query in mysql by doing

SET GLOBAL innodb_print_all_deadlocks = ‘ON’;

or

SET GLOBAL innodb_print_all_deadlocks = 1;

If that deadlock happens again, immediately go into MySQL Workbench or whatever you are using and run:

SHOW ENGINE INNODB STATUS;

Another way to nail it down, is to look through your mysql error log.

The reason for that happening in a nutshell is because one thing is locking, lets say Users then is waiting to hold a lock on Jobs while at the same exact time another script is locking Jobs, while trying hold a lock on Users. Boom … deadlocked.

A proper fix would be to fix the transactions that issue select and update statements to multiple tables, to have all the scripts to call the tables in the same exact order.


#674

I’m having this error when I disconnect from the server, but I realized that it is the esx_locksystem, I just do not know how to solve it.