ObjectWeb Consortium
Search ObjectWeb Mail Archive: 

Advanced Search - Powered by Google


Mail Archive Home | c-jdbc List | August 2004 Index

<--  Date Index  --> <--  Thread Index  -->

Re: [c-jdbc] severe problem on production system


Hi Ozcan,

We need to have a look at your database configuration to see if the one you've specified looks good for the number of users you have. You may also want to switch to the blackdown jvm if you're under linux to improve performances, because after testing it looks as if the sun JVM is less responsive than the blackdown's one. Also, stability has not been a problem in either of them with C-JDBC.

The configuration of the cache, and the parsing of the queries is also important for applications that requires speed over reliability.

What do you mean by the controller crashed? Did the JVM crashed ? Was there a deadlock ? There was no more connections in the pool ?


Also, it would be interesting to know if your database configuration is read or write intensive ? or simply balanced between the two?

Thanks for using C-JDBC !!

Nicolas,

Özcan Acar wrote:

Hi Nicolas,


Hi Ozcan,

You can send an email to c-jdbc-pro@xxxxxxxxxxxxx if you are on a critical business.

Appart from that, can I ask you what os you're running on ?
How many clients ? (Approximately ... 100 ? 200 ?)
What is the JVM you're using ? The version ?

We use Suse LInux 9. Our community has over 200.000 Members, jvm 1.42_05,
apache 139, resin 2.12

At an average there are over 1500 Members in logged in state, in part up to
2000 members...


Also, after how long the system went in that state ?

one or two

Did you send a particular query ? Did you send a query after a certain amount of time ?

The latest queries can you at the end of this message.


Was the system idle for a long time ?

no


Thanks in advance for helping us finding the problem,


We had to switch to our old solution yesterday and deactivated c-jdbc
driver. It blocks after 2 ours. We had also the case, that the controller
suddenly stoped or crashed yesterday and the clients (resin connection pool)
had the error message "connection refused".

Overall the whole web application (community software, developed by us) runs
slower because the sql query take to long to execute. We optimized the sql
queries.

Maybe is c-jdbc not appropriate for such a huge load on the database?

Thanks for your help.

Özcan Acar
Dip. Inf (FH)
Germany



Nicolas,

Özcan Acar wrote:

Hi,
we use c-jdbc 1.0.1 and encountered a severe problem. c-jdbc stops
working
after awhile. We use postgres 745. ps aux shows on our linux server:

2298 ?        S      0:36 postgres: stats buffer process
2299 ?        S      0:30 postgres: stats collector process
2888 ?        S     42:01 postgres: acar bizimalem 127.0.0.1 idle
4672 ?        S      0:12 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4673 ?        S      0:07 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4674 ?        S      0:02 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4676 ?        S      0:05 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4677 ?        S      0:04 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4681 ?        S      0:00 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4682 ?        S      0:00 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4683 ?        S      0:00 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4684 ?        S      0:00 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4685 ?        S      0:00 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4686 ?        S      0:00 postgres: acar bizimalem 127.0.0.1 idle in
transaction
4687 ?        S      0:00 postgres: acar bizimalem 127.0.0.1 UPDATE
waiting
5404 pts/3    S      0:00 grep postgres



These are the last querys that accepted by c-jdbc


LOG:  statement: select * from community_login_failed where
username='ferhaat32' order by id asc
LOG:  statement: select friend, sex, username   from community_friend
where
friend='albustanli' and ignored=1 order by username asc
LOG:  statement: delete from community_login_failed where id=508449
LOG:  statement: select username, clubid from community_club_member where
username='albustanli' and approved=1
LOG:  statement: select kontostand from community_konto where
username='albustanli'
LOG:  statement: select * from  nextval ('password_failed_unique_id') as
result;
LOG:  statement: insert into community_login_failed (id,username, ip,
created) values(508539,'ferhaat32','80.133.157.24','2004-08-28
22:47:29.198')
LOG:  statement: select id,sex,sexwanted, familienstand, geburtsdatum,
stadt, plz, begruessung, username, pic_profil, pic_profil_activated,
pic_profi
l_thumb from community_single  where pic_profil_activated='1' order by
pic_lastupdate_activated desc  limit 20 offset 0
LOG:  statement: select plz from com_plz where plz='58455'
LOG:  statement: select ort from com_plz where plz='58455'
LOG:  statement: update community_account set
hobby='~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&
#38;gt;&#38;gt; $efkat ve merhamette güne$ gibi ol....
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(
_~.}}(_~.}}(_~.}
',height='~.}}¯)~.}}¯)',weight='(_~.}}(_~.}}',haircolor='~.}}¯)~.}}¯)',eyecolor='(_~.}}(_~.}}',bornin='~.}}¯)~.}}¯)',burc='(_~.}}(_~

..}}',favoritefilm='~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt; Ba$kalarinin kusurunu örtmede
gece
gibi ol.... &#38;gt;&#38;gt;&#38;gt;&#38;gt;
(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}
',favoritemusic='~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.
}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
Hiddet ve asabiyette ölü gibi ol.... &#38;gt;&#38;gt;
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}
',recentlyreadbooks='~.}}¯)~.}}¯)~.}}¯
)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt; Tevazu ve alcakgönüllülükte
toprak
gibi ol.... &#38;gt;&#38;gt;&#38;gt
;&#38;gt;&#38;gt; (_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}
',favoritesport='~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;
gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
Ho$görülükte deniz gibi ol.... &#38;gt;&#38;gt;&#38;gt;&#38;gt;&#
38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}
',favoritevacationspot='~.}}¯)~.}}¯)~.}}¯)~.}}¯)
~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
Ya oldugun gibi görün
.....
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}
}(_~.}
',charakter='~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt; Cömertlikte yardim etmede akar
su
gibi ol....   &#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}
',computer='~.}}¯)~.}}¯)~.}}¯)~.}}¯)~.}
}¯)~.}}¯)~.}}¯)~.}}¯)~.}}¯)
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
Ya göründügün gibi ol...
..
&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;&#38;gt;
(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_~.}}(_
~.} ', birthday='1977-08-17', firstname='Arzu', name='Can',
email='mickymaus58@xxxxxx', sex='w', job='~Studentin}', maritalstatus='',
country='DE', t
own='Witten', zip='58455', chattime='1', premiumsms=1093726031872 where
username='Zehra25'
ERROR:  value too long for type character varying(255)

LOG:  connection received: host=192.168.1.58 port=41391
LOG:  connection authorized: user=acar database=bizimalem
LOG:  statement: set datestyle to 'ISO'; select version(), case when
pg_encoding_to_char(1) = 'SQL_ASCII' then 'UNKNOWN' else
getdatabaseencoding() e
nd;
LOG:  statement: set client_encoding = 'UNICODE'
LOG:  statement: select * from community_account where
username_lowercase='deli-kiz87'
LOG:  statement: select count(*) from com_guestbook where
guestbookowner='dudu-dudu-20' and ablage='0'
LOG:  statement: select * from community_account where
username_lowercase='_sevgi'
LOG:  recycled transaction log file "000000010000008F"
LOG:  recycled transaction log file "0000000100000090"
LOG:  recycled transaction log file "0000000100000091"
LOG:  recycled transaction log file "0000000100000092"
LOG:  connection received: host=192.168.1.198 port=25639
LOG:  incomplete startup packet


Here you can see a thread dump from c-jdbc controller

http://www.bizimalem.com/cjdbc-thread-dump.txt

The file contains the output of the controller, at the end of the file
the
thread  dump, taken with kill -QUIT pid

Can you please help me to isolate the problem. We are on the production
system and this problem affects our business.

Thanks

Özcan Acar






------------------------------------------------------------------------









<--  Date Index  --> <--  Thread Index  -->

Reply via email to:

Powered by MHonArc.

Copyright © 1999-2005, ObjectWeb Consortium | contact | webmaster.