[ERROR] connect ETIMEDOUT
[ERROR] [MySQL] [esx_society] An error happens on MySQL for query "SELECT * FROM jobs": connect ETIMEDOUT
[ERROR] [MySQL] [esx_shops] An error happens on MySQL for query "SELECT * FROM shops LEFT JOIN items ON items.name = shops.item": Handshake inactivity timeout
[ERROR] [MySQL] [esx_addoninventory] An error happens on MySQL for query "SELECT * FROM items": Handshake inactivity timeout
[ERROR] [MySQL] [esx_locksystem] An error happens on MySQL for query "SELECT `plate`, `owner` FROM owned_vehicles": Handshake inactivity timeout
[ERROR] [MySQL] [esx_addonaccount] An error happens on MySQL for query "SELECT * FROM addon_account": Handshake inactivity timeout
[ERROR] [MySQL] [es_extended] An error happens on MySQL for query "SELECT * FROM items": Handshake inactivity timeout
[ERROR] [MySQL] [es_extended] An error happens on MySQL for query "SELECT * FROM jobs": Handshake inactivity timeout
[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicle_categories": Handshake inactivity timeout
[ERROR] [MySQL] [esx_datastore] An error happens on MySQL for query "SELECT * FROM datastore": Handshake inactivity timeout
Error: (node:993) UnhandledPromiseRejectionWarning: Error: connect ETIMEDOUT
at PoolConnection.Connection._handleConnectTimeout (mysql-async.js:1004:13)
at Object.onceWrapper (events.js:313:30)
at emitNone (events.js:106:13)
at Socket.emit (events.js:208:7)
at Socket._onTimeout (net.js:422:8)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 1)
Error: (node:993) [DEP0018] DeprecationWarning: Unhandled promise rejections are deprecated. In the future, promise rejections that are not handled will terminate the Node.js process with a non-zero exit code.
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 2)
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 3)
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 4)
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 5)
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 6)
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 7)
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 8)
Error: (node:993) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:993) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (rejection id: 9)
Hello, this is a friendly reminder because this is your first time creating a topic (or it has been a while since your last topic) in this category.
Please note that most of the support is provided by the FiveM community on a voluntary basis. We ask you to be patient; there is no guarantee we have a solution to your problem(s). To avoid unnecessary/duplicate topics, please browse the forums before creating a topic.
To improve your chances of your issue(s) being solved, please provide as much information as possible about the issue(s) you are having. Also —whenever possible— please use the template given to you when creating a topic.
# you probably don't want to change these!
# only change them if you're using a server with multiple network interfaces
endpoint_add_tcp "masked:30120"
endpoint_add_udp "masked:30120"
set mysql_connection_string "mysql://usermasked:pwmasked@hostmasked/dbmasked"
`set mysql_debug 1`: Prints out the actual consumed query.
`set mysql_debug_output "console"`: Select where to output the log, accepts `console`, `file`, and `both`. In case of `both` and `file` a file named `mysql-async.log` in your main server folder will be created.
`set mysql_slow_query_warning 200`: Sets a limit in ms, queries slower than this limit will be displayed with a warning at the specified location of `mysql_debug_output`, see above.
set es_enableCustomData 1
add_ace resource.essentialmode command.sets allow
add_ace resource.essentialmode command.add_principal allow
add_ace resource.essentialmode command.add_ace allow
start mapmanager
start chat
start spawnmanager
start fivem
start hardcap
start ■■■■■■■
start mysql-async
start async
start essentialmode
start esplugin_mysql
start cron
start es_pld
start FiveM_TimeAndDateDisplay
start pNotify
start prison-map-addon
start Radiant_gsrtest
start stasiek_selldrugs
start tw_bankdeposit
start watermark
start synn-loadscreen
start map
start es_extended
start esx_menu_default
start esx_menu_list
start esx_menu_dialog
start staff
start esx_phone
start esx-checkdeathcause
start esx_locksystem
start esx_aiomenu
start esx_billing
start esx_voice
start esx_animations
start esx_ambulancejob
start skinchanger
start esx_skin
start esx_vehicleshop
start esx_society
start esx_addonaccount
start esx_addoninventory
start esx_mechanicjob
start esx_taxijob
start esx_service
start esx_identity
start esx_datastore
start esx-ecobottles
start esx-qalle-jail
start esx-qalle-sellvehicles
start esx_basicneeds
start esx_AdvancedFishing
start esx_borrmaskin
start esx_bike-rental
start esx_dmvschool
start esx_doorlock
start esx_extraitems
start esx_drugs
start esx_giveid
start esx_goDirty
start esx_gym
start esx_gsr
start esx_hospital
start esx_hunting
start esx_inventoryhud
start esx_jb_outlawalert
start esx_korvgubbe
start esx_license
start esx_lscustom
start esx_plasticsurgery
start esx_policejob
start esx_robatm
start esx_shops
start esx_SodaMachine
start new_banking
start esx_status
sv_scriptHookAllowed 1
# change this
#rcon_password xd
sv_hostname "RebornRP"
# nested configs!
#exec server_internal.cfg
# loading a server icon (96x96 PNG file)
#load_server_icon rebornrp.net/images/discordreborn.png
# convars for use from script
set temp_convar "hey world!"
# disable announcing? clear out the master by uncommenting this
#sv_master1 ""
# want to only allow players authenticated with a third-party provider like Steam?
#sv_authMaxVariance 1
#sv_authMinTrust 5
# add system admins
add_ace group.admin command allow # allow all commands
add_ace group.admin command.quit deny # but don't allow quit
add_principal identifier.steam:1100001076bf814 group.admin # add the admin to the group
add_principal identifier.steam:110000116900454 group.admin # add the admin to the group
# player endpoint protection
sv_endpointprivacy true
# Server player slot limit (must be between 1 and 32)
sv_maxclients 32
# License key for your server (https://keymaster.fivem.net)
sv_licenseKey keymasked
Which format for setting a MySQL connection string would be of value here? Also, how would I go about checking that the site doesn’t block the connection automatically?
Edit: I have double checked the MySQL connection string and it is configured appropriately.This connection string that I have displayed above worked previously and it seems as if some resources are connecting to the databases as the DMV school and licenses (which require the database) are working just fine without error.
Edit: I’ve researched it and I’m back to the same place I was. Everything is configured properly with the database and it seems to be getting a connection as other resources are using the same database just fine.
I’m getting these still with all of the above information in consideration and connected.
[ERROR] getaddrinfo EAI_AGAIN rebornrp_server:3306
[ERROR] [MySQL] [esx_shops] An error happens on MySQL for query "SELECT * FROM s hops LEFT JOIN items ON items.name = shops.item": getaddrinfo EAI_AGAIN rebornrp _server:3306
[ERROR] [MySQL] [esx_society] An error happens on MySQL for query "SELECT * FROM jobs": getaddrinfo EAI_AGAIN rebornrp_server:3306
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: getaddrinfo EAI_AGAI N rebornrp_server:3306
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:67:26)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 1)
Error: (node:1969) [DEP0018] DeprecationWarning: Unhandled promise rejections ar e deprecated. In the future, promise rejections that are not handled will termin ate the Node.js process with a non-zero exit code.
Error: (node:1969) UnhandledPromiseRejectionWarning: AssertionError [ERR_ASSERTI ON]: unexpected PromiseRejectEvent
at process.<anonymous> (internal/process/promises.js:27:25)
at <anonymous>
at Query.db.query [as _callback] (mysql-async.js:5223:9)
at Query.Sequence.end (mysql-async.js:275:24)
at mysql-async.js:4916:13
at Handshake.onConnect (mysql-async.js:4769:9)
at Handshake.<anonymous> (mysql-async.js:1117:10)
at Handshake._callback (mysql-async.js:1083:16)
at Handshake.Sequence.end (mysql-async.js:275:24)
at Protocol.handleNetworkError (mysql-async.js:6374:14)
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 2)
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: getaddrinfo EAI_AGAI N rebornrp_server:3306
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:67:26)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 3)
[ERROR] [MySQL] [esx_weaponshop] An error happens on MySQL for query "SELECT * F ROM weashops": getaddrinfo EAI_AGAIN rebornrp_server:3306
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: getaddrinfo EAI_AGAI N rebornrp_server:3306
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:67:26)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 4)
[ERROR] [MySQL] [esx_addoninventory] An error happens on MySQL for query "SELECT * FROM items": getaddrinfo EAI_AGAIN rebornrp_server:3306
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: getaddrinfo EAI_AGAI N rebornrp_server:3306
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:67:26)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 5)
[ERROR] [MySQL] [esx_vehicleshop] An error happens on MySQL for query "SELECT * FROM vehicle_categories": getaddrinfo EAI_AGAIN rebornrp_server:3306
[ERROR] [MySQL] [esx_whitelist] An error happens on MySQL for query "SELECT * FR OM whitelist": getaddrinfo EAI_AGAIN rebornrp_server:3306
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: getaddrinfo EAI_AGAI N rebornrp_server:3306
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:67:26)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 6)
Error: (node:1969) UnhandledPromiseRejectionWarning: AssertionError [ERR_ASSERTI ON]: unexpected PromiseRejectEvent
at process.<anonymous> (internal/process/promises.js:27:25)
at <anonymous>
at Query.db.query [as _callback] (mysql-async.js:5223:9)
at Query.Sequence.end (mysql-async.js:275:24)
at mysql-async.js:4916:13
at Handshake.onConnect (mysql-async.js:4769:9)
at Handshake.<anonymous> (mysql-async.js:1117:10)
at Handshake._callback (mysql-async.js:1083:16)
at Handshake.Sequence.end (mysql-async.js:275:24)
at Protocol.handleNetworkError (mysql-async.js:6374:14)
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 7)
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: getaddrinfo EAI_AGAI N rebornrp_server:3306
at GetAddrInfoReqWrap.onlookup [as oncomplete] (dns.js:67:26)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 8)
[ERROR] [MySQL] [esx_addonaccount] An error happens on MySQL for query "SELECT * FROM addon_account": connect ETIMEDOUT
[ERROR] [MySQL] [es_extended] An error happens on MySQL for query "SELECT * FROM items": Handshake inactivity timeout
[ERROR] [MySQL] [es_extended] An error happens on MySQL for query "SELECT * FROM jobs": Handshake inactivity timeout
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: connect ETIMEDOUT
at PoolConnection.Connection._handleConnectTimeout (mysql-async.js:1004:13)
at Object.onceWrapper (events.js:313:30)
at emitNone (events.js:106:13)
at Socket.emit (events.js:208:7)
at Socket._onTimeout (net.js:422:8)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 9)
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 10)
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.query (mysql-async.js:4913:8)
at Promise (mysql-async.js:5220:10)
at new Promise (<anonymous>)
at MySQL.execute (mysql-async.js:5216:26)
at Object.global.exports [as callback] (mysql-async.js:5109:9)
at citizen:/scripting/v8/main.js:96:41
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection . This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). (re jection id: 11)
[ERROR] [MySQL] [esx_datastore] An error happens on MySQL for query "SELECT * FROM datastore": Handshake inactivity timeout
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.releaseConnection (mysql-async.js:4868:10)
at Pool._removeConnection (mysql-async.js:4988:8)
at Pool._purgeConnection (mysql-async.js:4969:8)
at Handshake.onConnect (mysql-async.js:4768:14)
at Handshake.<anonymous> (mysql-async.js:1117:10)
at Handshake._callback (mysql-async.js:1083:16)
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by th rowing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catc h(). (rejection id: 12)
[ERROR] [MySQL] [esx_boat] An error happens on MySQL for query "UPDATE owned_vehicles SET `stored` = true WHERE `sto red` = false AND type = 'boat'": Handshake inactivity timeout
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.releaseConnection (mysql-async.js:4868:10)
at Pool._removeConnection (mysql-async.js:4988:8)
at Pool._purgeConnection (mysql-async.js:4969:8)
at Handshake.onConnect (mysql-async.js:4768:14)
at Handshake.<anonymous> (mysql-async.js:1117:10)
at Handshake._callback (mysql-async.js:1083:16)
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by th rowing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catc h(). (rejection id: 13)
[ERROR] [MySQL] [esx_property] An error happens on MySQL for query "SELECT * FROM properties": Handshake inactivity timeout
Error: (node:1969) UnhandledPromiseRejectionWarning: Error: Handshake inactivity timeout
at Handshake.<anonymous> (mysql-async.js:6165:17)
at emitNone (events.js:106:13)
at Handshake.emit (events.js:208:7)
at Handshake._onTimeout (mysql-async.js:316:8)
at Timer._onTimeout (mysql-async.js:13203:23)
at ontimeout (timers.js:498:11)
at tryOnTimeout (timers.js:323:5)
at Timer.listOnTimeout (timers.js:290:5)
--------------------
at Protocol._enqueue (mysql-async.js:6149:48)
at Protocol.handshake (mysql-async.js:6056:23)
at PoolConnection.connect (mysql-async.js:711:18)
at Pool.getConnection (mysql-async.js:4759:16)
at Pool.releaseConnection (mysql-async.js:4868:10)
at Pool._removeConnection (mysql-async.js:4988:8)
at Pool._purgeConnection (mysql-async.js:4969:8)
at Handshake.onConnect (mysql-async.js:4768:14)
at Handshake.<anonymous> (mysql-async.js:1117:10)
at Handshake._callback (mysql-async.js:1083:16)
Error: (node:1969) UnhandledPromiseRejectionWarning: Unhandled promise rejection. This error originated either by th rowing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catc h(). (rejection id: 14)
Edit: My database is externally connected and all SQL’s have been modified to fit the conditions of the external hosting. Nothing wrong with connectivity as I see since other resources are performing well with the external connection.
