GreenSQL

Same problem here. I used the greensql 1.2.2 package for Ubuntu 9.10. It starts up fine.. but shortly after running a few queries the cpu is up to 100%.

It seems that it ends up in a loop since when tailing the greensql.log, all I see is:

[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11
[28/Jan/2010 9:22:05] NET_DEBUG [3]frontend socket fired 11


(about 30000 lines per second).

I'm not sure but it seems to happend when there is a larger mount of data transmitted from the mysql server to the client (e.g. a PDF document).

A new comment has been posted on  GreenSQL for the post 'greensql needs 100% cpu-usage'.

IP Address: 62.0.111.205
Name: yuli
Email address: yuli@greensql.com
URL: Comment:

A solution for this problem has been just commited to the code repository.

Please check if it solves your problem. You will have to rebuild the application from the sources.

Run the following commands:
1. Download last version of the code
shel> svn co https://greensql.svn.sourceforge.net/svnroot/greensql greensql

2. Enter the trunk/greensql-fw directory

3. Go over compilation.txt and make sure that all necessary packages are installed.

4. Compile and build a package by running the following command:
shel> /bin/sh ./build.sh

5. If you still getting an error, make sure that all required packages are installed. It is possible to build only the application without creating the package. You can do it by running the following command: make clean && make. If it works for you, you can copy greensql-fw to /usr/sbin/ directory and start the service:
shel> make clean && make
shel> /etc/init.d/greensql-fw stop
shel> cp greensql-fw /usr/sbin/
shel> /etc/init.d/greensql-fw start


Hope this helps,
Yuli

Thanks Yuli. I've tested your fix for 10 minutes now and the problem seems to be solved.

hi yuli,
yes ... it works also by me!

thanks for your help and great work!!
by
jkn

Is this patch included in the current download package already?

I have the same problem and had to downgrade recently.

Thanks for the info.

It is still not included.

We will release a small bug fix version in a few days.

Best regards,
Yuli

As long as there is no FreeBSD support anymore we will kick greenSQL from our servers anyway.

I had the same problem once I upgraded from 1.0 to current.
Building the version from the svn seems to have done the trick here as well with greensql processing about 1000 qps , 1 database in IPS and using up around 20-30% of one cpu core.