Firebird News

Tuesday, October 19, 2010

clang++ production tests with Firebird 2.5

Two good news and a bad one
I will start with the bad one , small bug in make install (I call it Stopping Firebird server forever on make install)

Seems that there is still bug while doing make install in
the Release 2.5 branch
./configure --prefix=/opt/firebird2.5 --enable-superserver --with-system-icu --with-system-editline
make install 
...
(cd ../gen/FirebirdSS-2.5.0.26107-0.amd64; FIREBIRD= ./install.sh)

Firebird super 2.5.0.26107-0.amd64 Installation

Press Enter to start installation or ^C to abort
Extracting install data
Stopping Firebird server: Stopping Firebird server: Stopping Firebird
server: Stopping Firebird server: Stopping Firebird server: Stopping
Firebird server: Stopping Firebird server: Stopping Firebird server:
Stopping Firebird server: ^Cmake[2]: *** [install] Interrupt
make[1]: *** [install] Interrupt
make: *** [install] Interrupt

2. I checket out the 2.5 branch and all compiles fine and installs somehow (password is ok)
and i can start the super server with /etc/init.d/firebird script after i press ctrl-C
on make install
Here are some entries from the log (while installing the super server)


borkstationx64 (Client) Tue Oct 19 15:20:32 2010
/opt/firebird2.5/bin/fbguard: guardian starting
/opt/firebird2.5/bin/fbserver
borkstationx64 (Server) Tue Oct 19 15:20:32 2010
Database: /opt/firebird2.5/security2.fdb
Can't access lock files' directory ../gen/firebird
borkstationx64 (Client) Tue Oct 19 15:20:32 2010
/opt/firebird2.5/bin/fbguard: /opt/firebird2.5/bin/fbserver
terminated due to startup error (2)
borkstationx64 (Client) Tue Oct 19 15:20:38 2010
INET/inet_error: connect errno = 111

3.the firebird tests are running (for about a few hours) and all sems
to be fine ! I was expecting some errors any errors but all seems to be fine as you will see from bellow numbers (I will test/show the g++ vs clang++ numbers later)
Database was created with flamerobin in /tmp/test.fdb
and then i have installed kinterbasdb 3.3.x

wget http://www.firebirdsql.org/download/rabbits/pmakowski/ibench1.py
python ibench1.py --db_user=sysdba --db_password=masterkey --db_name=/tmp/test.fdb --setup
#rows #seconds cum_ips last_ips #queries cum_qps last_qps

10000 56 179.4 179.4 2210 39.7 39.7
20000 136 147.1 124.7 5525 40.6 41.3
30000 250 119.9 87.5 10592 42.3 44.3
40000 399 100.4 67.4 16841 42.3 42.1
50000 551 90.7 65.4 23991 43.5 46.8
60000 708 84.7 63.7 30445 43.0 41.1
70000 866 80.8 63.5 35920 41.5 34.8
80000 1038 77.1 58.2 41111 39.6 30.2
90000 1217 73.9 55.7 46142 37.9 28.0
100000 1408 71.0 52.4 51142 36.3 26.2
110000 1607 68.4 50.2 55951 34.8 24.2
120000 1803 66.5 51.0 60282 33.4 22.1
130000 2000 65.0 50.9 64400 32.2 21.0
140000 2212 63.3 47.2 68577 31.0 19.7
150000 2414 62.1 49.3 71987 29.8 16.8
160000 2625 61.0 47.5 75301 28.7 15.8
170000 2830 60.1 48.7 78098 27.6 13.6
..........................................................



I will run the other set of tests fbtcs, and the ones from qa

No comments: