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,

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 ?

Also, after how long the system went in that state ?
Did you send a particular query ? Did you send a query after a certain amount of time ?
Was the system idle for a long time ?

Thanks in advance for helping us finding the problem,

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.