@Anthony_G_Cyphers - over in the thread: WebApp good in IDE bad in Deployment, you wrote:
My only remotely similar experience recently was with the GraffitiSuite Demo freezing around 24 hours after deployment when built with 2024r4.x and 2025r1.x. And, of course, the service appeared to be running to the system so it would just hang in that dead state rather than being restarted.
I still don’t know what was causing it or what fixed it, but it’s been solid for a few days now after setting up other locations with the same build to see if it was just the one VPS acting up.
I’m having this exact same issue (the web app does use Graffiti Suite but I’m not at all convinced this is causing the issue since, like you, it only has been occurring in Xojo 2024r4.x builds of the app)
You posted ~4 days ago. Did a new VPS “fix” things, or are you still seeing the same eventual hang/freeze of the Graffiti Suite Demo site?
I didn’t fire up a new VPS. It just sort of cleared up on its own after I spent massive amounts of time trying to find the cause, asked two others to put up test instances of the demo in their hosting spaces (including one in Xojo Cloud) which never exhibited the issue, and added a lot of additional logging.
Don’t know what caused it, but it’s ceased now. The only thing I can think of is that I accidentally slipped forward in the Xojo prerelease version I was using to try and reproduce the issue.
I don’t believe it was a GraffitiSuite issue as I never found any evidence to confirm that, and it ceased freezing using the same GraffitiSuite source code.
2 Likes
Just as an fyi, Xojo confirmed my issue; it’s related to MySQL databases.
I made some adjustments to my database code so my running web application is much less “aggressive” in the number of calls it makes to ‘MySQLCommunityServer.Connect’:
This has (so far!) greatly improved the stability of my app.
There is a confirmed issue(s) on the Xojo framework side of things, but things are still being analyzed by Xojo team so I don’t want to speculate until I hear more.
Anthony
3 Likes