Project in jeopardy (SQLx issue)
Hi,
I've spent 5 months building vast AMXX / web interface for climbing / cups and everything else regarding KZ maps. Plugin part is now 7 thousand lines long and is estimated to be finished by 90%. This plugin was supposed to be implemented into xtreme-jumps.eu servers - the official international KZ community. All of this is based on true power of SQL ... and therefore, I'm using SQLx with 99% of queries processed thread-wise. But there is one problem standing in a way of going live with this project: The servers crash and they do quite often. I took 2 weeks to check source code for possible causes and I did find some ... but with no apparent improvement. It seemed, that server crashes upon threaded query execution / handling. I've made a simple plugin: Code:
I played around with run_test command, calling it randomly. As you can see from the source code, n indicates number of queries to waiting for handler. Sometimes, it was possible to fill the queue with 500 queries without crashing but mostly, I was not able to get over 20. These are various console printouts upon crash: Quote:
Quote:
Quote:
Now: I've moved to another server running same version of Gentoo Linux and there was no problem at all. I did few extreme tests putting 500 queries into queue and waiting for them to execute. It worked! But it doesn't now and I have no idea why. Only change I did to the system was proftpd installation. Anyone with experience to share? This is rendering threaded SQLx pretty useless for me ... and rebuilding whole thing to static queries sounds like ... well. Thank you in forward. A |
Re: Project in jeopardy (SQLx issue)
Ok, I've tried another of our servers with same Gentoo system. It's working fine:
Quote:
|
Re: Project in jeopardy (SQLx issue)
To everyone else having same problem (regarding any plugin using MySQL module): click me
|
| All times are GMT -4. The time now is 11:01. |
Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.