Mysql-async ERROR Packets out of order. Got: 1 Expected: 0

[virrefirre1]

Anybody knows what this is:
cfx> [mysql-async] [ERROR] Packets out of order. Got: 1 Expected: 0
(My database is correctly configured)

[virrefirre1]

Then I get these errors:

SCRIPT ERROR: @esx_shops/server/main.lua:8: attempt to get length of a nil value (local ‘shopResult’)
ref (@esx_shops/server/main.lua:8)
(@mysql-async/mysql-async.js:15543)
SCRIPT ERROR: @esx_addoninventory/server/main.lua:10: attempt to get length of a nil value (local ‘items’)
fn (@mysql-async/lib/MySQL.lua:226)
[MySQL] [ERROR] [esx_vehiclelock] An error happens for query “SELECT owner, plate FROM owned_vehicles : []”: Packets out of order. Got: 1 Expected: 0
[MySQL] [ERROR] [esx_vehiclelock] An error happens for query “SELECT owner, plate FROM rented_vehicles : []”: Packets out of order. Got: 1 Expected: 0
[MySQL] [ERROR] [esx_vehicleshop] An error happens for query “SELECT * FROM vehicles : []”: Packets out of order. Got: 1 Expected: 0
SCRIPT ERROR: @esx_society/server/main.lua:18: attempt to get length of a nil value (local ‘result’)
fn (@mysql-async/lib/MySQL.lua:226)
SCRIPT ERROR: @esx_addonaccount/server/main.lua:9: attempt to get length of a nil value (local ‘result’)
fn (@mysql-async/lib/MySQL.lua:226)
SCRIPT ERROR: @esx_datastore/server/main.lua:9: attempt to get length of a nil value (local ‘result’)
fn (@mysql-async/lib/MySQL.lua:226)
SCRIPT ERROR: @es_extended/server/common.lua:35: attempt to get length of a nil value (local ‘result’)
fn (@mysql-async/lib/MySQL.lua:226)
SCRIPT ERROR: @esx_vehiclelock/server/main.lua:152: attempt to get length of a nil value (local ‘result’)
ref (@esx_vehiclelock/server/main.lua:152)
(@mysql-async/mysql-async.js:15543)
[MySQL] [ERROR] [esx_property] An error happens for query “SELECT * FROM properties : []”: Packets out of order. Got: 1 Expected: 0
SCRIPT ERROR: @esx_property/server/main.lua:69: attempt to get length of a nil value (local ‘properties’)
ref (@esx_property/server/main.lua:69)
(@mysql-async/mysql-async.js:15543)

[nusikales]

Happened to me the same today after server restart. No scripts or database changes before that. Any help?

[virrefirre1]

Exactly the same for me, completely random

[nusikales]

I think it’s not our servers . Because im seeing more and more posts about this issue. Also one in github mysql async page. Hopefully they will find a solution quick :((

[virrefirre1]

Yeah…

[G3JM0N]

I have the same problem today

[ERROR] [MySQL] [gcphone] An error happens on MySQL for query “DELETE FROM phone_messages WHERE (DATEDIFF(CURRENT_DATE,time) > 10)”: Packets out of order. Got: 1 Expected: 0

[ERROR] Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_shops] An error happens on MySQL for query “SELECT * FROM shops LEFT JOIN items ON items.name = shops.item”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_addonaccount] An error happens on MySQL for query “SELECT * FROM addon_account”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_boat] An error happens on MySQL for query “UPDATE owned_vehicles SET stored = true WHERE stored = false AND type = ‘boat’”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [es_extended] An error happens on MySQL for query “SELECT * FROM items”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [es_extended] An error happens on MySQL for query “SELECT * FROM jobs”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query “SELECT * FROM vehicle_categories”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_datastore] An error happens on MySQL for query “SELECT * FROM datastore”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_addoninventory] An error happens on MySQL for query “SELECT * FROM items”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_weaponshop] An error happens on MySQL for query “SELECT * FROM weashops”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_society] An error happens on MySQL for query “SELECT * FROM jobs”: Packets out of order. Got: 1 Expected: 0

[ERROR] [MySQL] [esx_property] An error happens on MySQL for query “SELECT * FROM properties”: Packets out of order. Got: 1 Expected: 0