Hello devels,

Apparently the test suite database needs some love?

E.g. see this URL (generated automatically by webpage, not by me): http://www.freepascal.org/testsuite/cgi-bin/testsuite.cgi?os=1&cpu=8&version=44&date=&submitter=&machine=&comment=&cond=&Category=1&action=View+history

The application encountered the following error:

* Error: : Error executing query: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ') AND (TU_VERSION_FK=44) AND (TU_OS_FK=1) ORDER BY TU_ID DESC LIMIT 50' at line 1
* Stack trace:
$000000000049DDD4 line 2147 of fcl-db/src/base/db.pas

Nikolai

Nikolai Zhubr wrote

Apparently the test suite database needs some love?

Wow, I did not even know such a thing existed! How is it populated?

Mostly via automated nightly regression tests by the FPC developers.

Jonas

Thanks to your email,
Yuri Sidorov (member of the core team)
took the time to look at the problems of the
testsuite.cgi program and fixed several issues he found.

Please test and report if you still find problems...

Pierre Muller

bin/testsuite.cgi?os=1&cpu=8&version=44&date=&submitter=&machine=&comment=&c

Pierre Free Pascal wrote

Thanks to your email, Yuri Sidorov (member of the core team) took the time to look at the problems of the testsuite.cgi program and fixed several issues he found.

Maybe one thing: please limit your accesses and queries of the testsuite to what is absolutely necessary, because that database is huge and several kinds of testsuite queries put a big load on idefix (the machine that also serves the bug tracker, svn and main website).

Jonas

Hi Pierre,

Sorry for late reply, my main computer (with mail) was temporarily out of order.
I'm happy to confirm that the problem no longer exists. I do not get any error messages anymore. Also, it looks like query results are produced much faster now. Good work!
Actually, I reported the issue not because I suffered much from it right now but more because I thought it was a dangerous sympthom. Anyway, its good that the problem has been solved.
Thanks.

Nikolai

02.02.2013 21:00, Pierre Free Pascal: