Hi.
Because playfab doesnt have API for getting list guild so im using Google Cloud SQL for interact and manager Guild List.
But i got trouble with TIMEOUT error, example below will describe a case when i try to create a guild and insert few data on Cloud SQL. The first part is okay (guild has been created on Playfab) but timeout when connect to Cloud SQL. I 've checked connection to Cloud SQL and it always be good and respond always less than 1 second.
It happens 1 time per 2-3 requests (including get list guild from google cloud via cloud script)
Log from result.Log:
"{\"url\":\"https://spacex-xxxx.appspot.com/guild/InsertGuild?id=8AB186B989316CF9&name=Super marine&member=1&point=0®ion=VN&logo=6&maxMember=20&key=playfab151\",\"result\":{\"responseContent\":null,\"httpStatus\":null,\"httpStatusCode\":0,\"requestError\":\"Timeout\"},\"httpRequestError\":\"Timeout\"}"
Bonus: that guild has been created on cloud sql but still time out on the log.
Cloud script code:
var GetGuild_flink = "https://spacex-xxxx.appspot.com/guild/"; // google cloud SQL (create for searching + ranking) var url = GetGuild_flink + "InsertGuild" + "?id=" + result.Group.Id + "&name=" + args.GuildName + "&member=" + "1" + "&point=" + "0" + "®ion=" + "VN" + "&logo=" + args.Logo + "&maxMember=" + 20 + "&key=playfab151"; var response = http.request(url); // send log to client var message = result.Group.Id; log.info(message); return {messageValue: message};
Limit for execution of cloud script is 4.5 seconds so i think it shouldnt happen too much
How can i prevent it and how to know the reason?, because i got "can not solve destination host when login on Playfab" and i dont know how to get respond time from external API on cloud script.
Thank you for helping me.