[Release] MySQL Async Library - 3.3.2

manups4e · August 18, 2018, 9:47pm

Hello, sometimes, i get an error in my server with long lag and database crash because of a player with no name (maybe fantom player?) disconnecting… after this long crash i get a long crash of all esx sctips with xPlayer not found

[  19562563] hitch warning: frame time of 222730 milliseconds
[  19562985] 2018-08-18T23:04:41 [SERVER:QUEUE]: Disconnected: 
[  19563016] Error running system event handling function for resource LastPlanetGenerici: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: messaggi_generici_server.lua:9: attempt to concatenate a nil value
[  19563016] stack traceback:
[  19563016] 	messaggi_generici_server.lua:9: in upvalue 'handler'
[  19563016] 	citizen:/scripting/lua/scheduler.lua:175: in function <citizen:/scripting/lua/scheduler.lua:174>
[  19563016] stack traceback:
[  19563016] 	[C]: in function 'error'
[  19563016] 	citizen:/scripting/lua/scheduler.lua:41: in field 'CreateThreadNow'
[  19563016] 	citizen:/scripting/lua/scheduler.lua:174: in function <citizen:/scripting/lua/scheduler.lua:138>
[  19563313] OndinoH: /ooc mhanz
[  19563360] 2018-08-18T23:04:41 [SERVER:Coda]: Disconnesso: brian02
[  19563844] [ERROR] [MySQL] An critical error happens on MySQL for query "SELECT * FROM users {=}": ServerSession is not connected.   at MySqlConnector.Core.ServerSession.VerifyConnected () [0x00052] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:625 

[  19563844]   at MySqlConnector.Core.ServerSession.ReceiveReplyAsync (MySqlConnector.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00000] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:567 

[  19563844] --- End of stack trace from previous location where exception was thrown ---

[  19563844]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563844]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563844]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563844]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563844]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at MySqlConnector.Core.ServerSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x0001a] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:1026 

[  19563860]   at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySqlConnector.Protocol.PayloadData]:invoke_TResult_T (System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)

[  19563860]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860] --- End of stack trace from previous location where exception was thrown ---

[  19563860]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at MySqlConnector.Core.ResultSet+<<ScanRowAsync>g__ScanRowAsyncAwaited|9_0>d.MoveNext () [0x0002b] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:217 

[  19563860] --- End of stack trace from previous location where exception was thrown ---

[  19563860]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredValueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fcb22>:0 

[  19563860]   at MySqlConnector.Core.ResultSet+<ReadAsync>d__7.MoveNext () [0x0006e] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:175 

[  19563860] --- End of stack trace from previous location where exception was thrown ---

[  19563860]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at MySqlConnector.Core.ResultSet+<ReadEntireAsync>d__4.MoveNext () [0x00034] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:161 

[  19563860] --- End of stack trace from previous location where exception was thrown ---

[  19563860]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at MySql.Data.MySqlClient.MySqlDataReader+<NextResultAsync>d__5.MoveNext () [0x00056] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlDataReader.cs:54 

[  19563860] --- End of stack trace from previous location where exception was thrown ---

[  19563860]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at MySql.Data.MySqlClient.MySqlDataReader.DoClose () [0x00034] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlDataReader.cs:435 

[  19563860]   at MySql.Data.MySqlClient.MySqlDataReader.Dispose (System.Boolean disposing) [0x00003] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlDataReader.cs:290 

[  19563860]   at System.Data.Common.DbDataReader.Dispose () [0x00000] in <c660f5a12cac430aa34fafb29a22e588>:0 

[  19563860]   at MySQLAsync.FetchAll+<ReaderAsync>d__2.MoveNext () [0x00186] in <6f835765886c4fada3e5ffb1ffcd6998>:0 

[  19563860] --- End of stack trace from previous location where exception was thrown ---

[  19563860]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19563860]   at MySQLAsync.Operation`1+<ExecuteAsync>d__7[TResult].MoveNext () [0x00169] in <6f835765886c4fada3e5ffb1ffcd6998>:0 
[  19564485] Exception thrown by a task: System.AggregateException: One or more errors occurred. ---> System.IO.EndOfStreamException: Expected to read 1028 payload bytes but only received 797.

[  19564485]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at MySqlConnector.Utilities.ValueTaskExtensions+<>c__DisplayClass0_0`2[T,TResult].<ContinueWith>b__0 (System.Threading.Tasks.Task`1[TResult] task) [0x00000] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Utilities\ValueTaskExtensions.cs:11 

[  19564485]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485] --- End of stack trace from previous location where exception was thrown ---

[  19564485]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at MySqlConnector.Core.ServerSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x0001a] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:1026 

[  19564485]   at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySqlConnector.Protocol.PayloadData]:invoke_TResult_T (System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)

[  19564485]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485] --- End of stack trace from previous location where exception was thrown ---

[  19564485]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at MySqlConnector.Core.ResultSet+<<ScanRowAsync>g__ScanRowAsyncAwaited|9_0>d.MoveNext () [0x0002b] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:217 

[  19564485] --- End of stack trace from previous location where exception was thrown ---

[  19564485]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564485]   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredValueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fcb22>:0 

[  19564485]   at MySqlConnector.Core.ResultSet+<ReadAsync>d__7.MoveNext () [0x0006e] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:175 

[  19564500] --- End of stack trace from previous location where exception was thrown ---

[  19564500]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at MySQLAsync.FetchAll+<ReaderAsync>d__2.MoveNext () [0x0016c] in <6f835765886c4fada3e5ffb1ffcd6998>:0 

[  19564500]    --- End of inner exception stack trace ---

[  19564500] ---> (Inner Exception #0) System.IO.EndOfStreamException: Expected to read 1028 payload bytes but only received 797.

[  19564500]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at MySqlConnector.Utilities.ValueTaskExtensions+<>c__DisplayClass0_0`2[T,TResult].<ContinueWith>b__0 (System.Threading.Tasks.Task`1[TResult] task) [0x00000] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Utilities\ValueTaskExtensions.cs:11 

[  19564500]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500] --- End of stack trace from previous location where exception was thrown ---

[  19564500]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at MySqlConnector.Core.ServerSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x0001a] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:1026 

[  19564500]   at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySqlConnector.Protocol.PayloadData]:invoke_TResult_T (System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)

[  19564500]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500] --- End of stack trace from previous location where exception was thrown ---

[  19564500]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at MySqlConnector.Core.ResultSet+<<ScanRowAsync>g__ScanRowAsyncAwaited|9_0>d.MoveNext () [0x0002b] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:217 

[  19564500] --- End of stack trace from previous location where exception was thrown ---

[  19564500]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredValueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fcb22>:0 

[  19564500]   at MySqlConnector.Core.ResultSet+<ReadAsync>d__7.MoveNext () [0x0006e] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:175 

[  19564500] --- End of stack trace from previous location where exception was thrown ---

[  19564500]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[  19564500]   at MySQLAsync.FetchAll+<ReaderAsync>d__2.MoveNext () [0x0016c] in <6f835765886c4fada3e5ffb1ffcd6998>:0 <---

zr0iq · August 19, 2018, 4:56pm

do not confuse the error with the trace. mysql has nothing to do with it. see here for the error:

[ 19563016] Error running system event handling function for resource LastPlanetGenerici: citizen:/scripting/lua/scheduler.lua:41: Failed to execute thread: messaggi_generici_server.lua:9: attempt to concatenate a nil value

manups4e · August 19, 2018, 5:08pm

That script uses es:playerLoaded
that’s because it uses the database and it was the first one to crash

zr0iq · August 19, 2018, 6:37pm

There might be an issue with the caching of passwords for mysql 8.0.11 and later (for the connector). Though I did not encounter it when testing, but I currently have no testing setup.

manups4e · August 19, 2018, 6:50pm

It happens every time my queue meets a player with " " name

[   4823750] [ERROR] [MySQL] An critical error happens on MySQL for query "SELECT * FROM users {=}": ServerSession is not connected.   at MySqlConnector.Core.ServerSession.VerifyConnected () [0x00052] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:625 

[   4823750]   at MySqlConnector.Core.ServerSession.ReceiveReplyAsync (MySqlConnector.Protocol.Serialization.IOBehavior ioBehavior, System.Threading.CancellationToken cancellationToken) [0x00000] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:567 

[   4823750] --- End of stack trace from previous location where exception was thrown ---

[   4823750]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at MySqlConnector.Core.ServerSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x0001a] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:1026 

[   4823750]   at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySqlConnector.Protocol.PayloadData]:invoke_TResult_T (System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)

[   4823750]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750] --- End of stack trace from previous location where exception was thrown ---

[   4823750]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at MySqlConnector.Core.ResultSet+<<ScanRowAsync>g__ScanRowAsyncAwaited|9_0>d.MoveNext () [0x0002b] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:217 

[   4823750] --- End of stack trace from previous location where exception was thrown ---

[   4823750]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredValueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fcb22>:0 

[   4823750]   at MySqlConnector.Core.ResultSet+<ReadAsync>d__7.MoveNext () [0x0006e] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:175 

[   4823750] --- End of stack trace from previous location where exception was thrown ---

[   4823750]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at MySqlConnector.Core.ResultSet+<ReadEntireAsync>d__4.MoveNext () [0x00034] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:161 

[   4823750] --- End of stack trace from previous location where exception was thrown ---

[   4823750]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable+ConfiguredTaskAwaiter.GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at MySql.Data.MySqlClient.MySqlDataReader+<NextResultAsync>d__5.MoveNext () [0x00056] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlDataReader.cs:54 

[   4823750] --- End of stack trace from previous location where exception was thrown ---

[   4823750]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at MySql.Data.MySqlClient.MySqlDataReader.DoClose () [0x00034] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlDataReader.cs:435 

[   4823750]   at MySql.Data.MySqlClient.MySqlDataReader.Dispose (System.Boolean disposing) [0x00003] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\MySql.Data.MySqlClient\MySqlDataReader.cs:290 

[   4823750]   at System.Data.Common.DbDataReader.Dispose () [0x00000] in <c660f5a12cac430aa34fafb29a22e588>:0 

[   4823750]   at MySQLAsync.FetchAll+<ReaderAsync>d__2.MoveNext () [0x00186] in <6f835765886c4fada3e5ffb1ffcd6998>:0 

[   4823750] --- End of stack trace from previous location where exception was thrown ---

[   4823750]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4823750]   at MySQLAsync.Operation`1+<ExecuteAsync>d__7[TResult].MoveNext () [0x00169] in <6f835765886c4fada3e5ffb1ffcd6998>:0 
[   4824359] Exception thrown by a task: System.AggregateException: One or more errors occurred. ---> System.IO.EndOfStreamException: Expected to read 1021 payload bytes but only received 49.

[   4824359]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at MySqlConnector.Utilities.ValueTaskExtensions+<>c__DisplayClass0_0`2[T,TResult].<ContinueWith>b__0 (System.Threading.Tasks.Task`1[TResult] task) [0x00000] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Utilities\ValueTaskExtensions.cs:11 

[   4824359]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359] --- End of stack trace from previous location where exception was thrown ---

[   4824359]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824359]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at MySqlConnector.Core.ServerSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x0001a] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:1026 

[   4824375]   at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySqlConnector.Protocol.PayloadData]:invoke_TResult_T (System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)

[   4824375]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375] --- End of stack trace from previous location where exception was thrown ---

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at MySqlConnector.Core.ResultSet+<<ScanRowAsync>g__ScanRowAsyncAwaited|9_0>d.MoveNext () [0x0002b] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:217 

[   4824375] --- End of stack trace from previous location where exception was thrown ---

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredValueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fcb22>:0 

[   4824375]   at MySqlConnector.Core.ResultSet+<ReadAsync>d__7.MoveNext () [0x0006e] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:175 

[   4824375] --- End of stack trace from previous location where exception was thrown ---

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at MySQLAsync.FetchAll+<ReaderAsync>d__2.MoveNext () [0x0016c] in <6f835765886c4fada3e5ffb1ffcd6998>:0 

[   4824375]    --- End of inner exception stack trace ---

[   4824375] ---> (Inner Exception #0) System.IO.EndOfStreamException: Expected to read 1021 payload bytes but only received 49.

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at MySqlConnector.Utilities.ValueTaskExtensions+<>c__DisplayClass0_0`2[T,TResult].<ContinueWith>b__0 (System.Threading.Tasks.Task`1[TResult] task) [0x00000] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Utilities\ValueTaskExtensions.cs:11 

[   4824375]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375] --- End of stack trace from previous location where exception was thrown ---

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at MySqlConnector.Core.ServerSession.TryAsyncContinuation (System.Threading.Tasks.Task`1[TResult] task) [0x0001a] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ServerSession.cs:1026 

[   4824375]   at (wrapper delegate-invoke) System.Func`2[System.Threading.Tasks.Task`1[System.ArraySegment`1[System.Byte]],MySqlConnector.Protocol.PayloadData]:invoke_TResult_T (System.Threading.Tasks.Task`1<System.ArraySegment`1<byte>>)

[   4824375]   at System.Threading.Tasks.ContinuationResultTaskFromResultTask`2[TAntecedentResult,TResult].InnerInvoke () [0x00024] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Threading.Tasks.Task.Execute () [0x00010] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375] --- End of stack trace from previous location where exception was thrown ---

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.ConfiguredTaskAwaitable`1+ConfiguredTaskAwaiter[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at MySqlConnector.Core.ResultSet+<<ScanRowAsync>g__ScanRowAsyncAwaited|9_0>d.MoveNext () [0x0002b] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:217 

[   4824375] --- End of stack trace from previous location where exception was thrown ---

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.ConfiguredValueTaskAwaitable`1+ConfiguredValueTaskAwaiter[TResult].GetResult () [0x0001e] in <4ac30274d31c4b8099694c24336fcb22>:0 

[   4824375]   at MySqlConnector.Core.ResultSet+<ReadAsync>d__7.MoveNext () [0x0006e] in C:\Users\Matthias\Documents\GitHub\MySqlConnector\src\MySqlConnector\Core\ResultSet.cs:175 

[   4824375] --- End of stack trace from previous location where exception was thrown ---

[   4824375]   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw () [0x0000c] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess (System.Threading.Tasks.Task task) [0x0003e] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification (System.Threading.Tasks.Task task) [0x00028] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter.ValidateEnd (System.Threading.Tasks.Task task) [0x00008] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at System.Runtime.CompilerServices.TaskAwaiter`1[TResult].GetResult () [0x00000] in <0123fd5b1a1040fe9d70a7e0d4b28acb>:0 

[   4824375]   at MySQLAsync.FetchAll+<ReaderAsync>d__2.MoveNext () [0x0016c] in <6f835765886c4fada3e5ffb1ffcd6998>:0 <---

complete error

winxuser · August 27, 2018, 12:39am

hey guys im having a little issue that i cannot figure out, im using a free mysql host for my cad, essentialmode and whitelist, b ut i cant seem to get it to connect to the whitelist database, the cad works fine, havent tested essential mode… i am using BYTEHOST as the host

set mysql_connection_string “server=sql101.byetcluster.com;database=userid_whitelist;userid=userid;password=password”

and i have tried

set mysql_connection_string “server=IP;database=userid_whitelist;userid=userid;password=password”

it just wont connect to the server. if anyone has had experience with bytehost and the databases please help

FAXES · August 27, 2018, 1:35am

You should remove your info, knowing people they might fuck your database.

Also what errors are showing in console

winxuser · August 27, 2018, 2:28am

There is no information left unless the IP is different for each user.

The console just says that it cannot connect to a mysql database.

I checked the config for the opencad I’m using on the same server and that works perfectly fine.

MoravianLion · August 28, 2018, 7:18pm

Hi!

Could anyone help me to write a command that would give me two specific values from one row?

(One value, “plate” from separate collum)

and

I need to fetch 2 values from my database to my server script. In this case “modEngine” (value “-1”) and “model” (value “-1213539927”)

How is that possible? I’ve never done this complex fetching before…

Something like:

MySQL.Sync.fetchAll(“SELECT * FROM owned_vehicles WHERE owner=@plate AND FROM vehicle WHERE modEngine=@modEngine” AND model=“model”,{[’@plate ‘] = plate, [’@modEngine’] = modEngine}, [’@model’] = model}, function(modEngineValue)

I will appreciate any help in this! It’s very important for me

manups4e · September 1, 2018, 9:07pm

could someone update the script? it’s stuck since 9th of april!!

zr0iq · September 2, 2018, 11:04am

soon ™. I wrote in another post that I will be dropping the mysqlconnector soon.

FunnyGM · September 4, 2018, 2:44am

Anyone know why I would be getting this error

Syntasu · September 4, 2018, 8:06am

@FunnyGM See: [Release] MySQL Async Library - 3.2.3

zr0iq · September 4, 2018, 6:55pm

Update: 3.0.0-rc.0

This is a big update, the library will be migrated to javascript.

Changes

Breaking: The console variable mysql_connection_string needs to be formated now like mysql://username:password@host/database?dateStrings=true additional options can be chained like in urls, first with ? then with &. The options can be gotten from https://github.com/mysqljs/mysql#connection-options
Breaking: Transactions are not included in this release candidate.
Threaded options are no longer needed and will be removed as of 3.1.0

All basic functionality should be working as given. Make sure you run one of the latest server versions when checking this version out before deploying and update the connection string. Docs will be updated later on proper release.

This is a release candidate version, so by all means go ahead and test it.

https://github.com/brouznouf/fivem-mysql-async/tree/node-variant

manups4e · September 4, 2018, 8:26pm

what do you mean? sorry not an expert on databases

zr0iq · September 4, 2018, 8:29pm

Async.transaction and Sync.transaction were taken out temporarily and will return at some future version.

manups4e · September 4, 2018, 8:32pm

i see thanks

manups4e · September 7, 2018, 7:44pm

using node.js gives a weird issue… only in one script, esx_eden_garage keep saying every vehicle is in garage even if is out of garage… (supposed to be at fourier)

zr0iq · September 7, 2018, 7:50pm

Can you link me the script?

SaltyGrandpa · September 7, 2018, 7:52pm

Out of curiosity, what’s the benefit of the JS MySQL library? Faster, lighter, or just different?