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 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
> >
> >
> >
> >
> >  
> >
> >------------------------------------------------------------------------
> >
> >
> >  
> >
> 

-- 
Supergünstige DSL-Tarife + WLAN-Router für 0,- EUR*
Jetzt zu GMX wechseln und sparen http://www.gmx.net/de/go/dsl




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

Reply via email to:

Powered by MHonArc.

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