<!-- keep this as a security measure: #uncomment if the subject should only be modifiable by the listed groups * Set ALLOWTOPICCHANGE = Main.TWikiAdminGroup,Main.CMSAdminGroup * Set ALLOWTOPICRENAME = Main.TWikiAdminGroup,Main.CMSAdminGroup #uncomment this if you want the page only be viewable by the listed groups # * Set ALLOWTOPICVIEW = Main.TWikiAdminGroup,Main.CMSAdminGroup --> %TOC% %ICON{arrowleft}% Go to [[CMSTier3LogXX][previous page]] / [[CMSTier3LogXX][next page]] of Tier3 site log %M% ---+ 14. 02. 2014 Missing Billing DB and Billing logs entries about t3fs14 files Yesterday I ran https://bitbucket.org/fabio79ch/billinginfo2chimera/src that nicely updated the =iatime= of *1153009* rows in =chimera.t_inodes=. Execution was: <pre>chimera=# UPDATE t_inodes chimera-# SET iatime = iatimebillinginfo.newer_iatime chimera-# FROM ( chimera(# SELECT max(billinginfo.datestamp) as newer_iatime, chimera(# pnfsid chimera(# FROM billinginfo chimera(# group by pnfsid chimera(# ) AS iatimebillinginfo chimera-# chimera-# WHERE t_inodes.ipnfsid = iatimebillinginfo.pnfsid chimera-# AND iatime < iatimebillinginfo.newer_iatime chimera-# ; LOG: duration: 229333.917 ms statement: UPDATE t_inodes SET iatime = iatimebillinginfo.newer_iatime FROM ( SELECT max(billinginfo.datestamp) as newer_iatime, pnfsid FROM billinginfo group by pnfsid ) AS iatimebillinginfo WHERE t_inodes.ipnfsid = iatimebillinginfo.pnfsid AND iatime < iatimebillinginfo.newer_iatime ; UPDATE %RED%1153009%ENDCOLOR% and now I get: chimera=# select count(*) from t_inodes where iatime > ( ictime + interval '12 hours' ) ; LOG: duration: 4846.568 ms statement: select count(*) from t_inodes where iatime > ( ictime + interval '12 hours' ) ; count -------- 567402 </pre> *but* some dcache gridftp file transfers are neither reported in the =billing.billinginfo= table nor in the billing logs on =t3dcachedb= ; e.g. despite of [[https://t3nagios.psi.ch/nagios/cgi-bin/status.cgi?host=t3cmsvobox02][t3nagios]] constantly hammering the =t3fs14= pools I see =stat= cases like: <pre>/pnfs/psi.ch/cms/t3-nagios/1MB-test-file_pool_t3fs14_cms_7 Access: %RED%2013-08-23%ENDCOLOR% 14:19:27.000000000 +0200 </pre> to try a different protocol I copied by =dccp= the file =/pnfs/psi.ch/cms/t3-nagios/1MB-test-file_pool_t3fs14_cms_7= and the entry appeared both in the =billing.billinginfo= table and in the billing logs. *Because these issues are concentrated just on =t3fs14= I would restart dCache there, but I need to find an idle moment.* =14-02-2014 15:34= </br> restarted =billing= service on =t3dcachedb=, I see a lot of %RED%CPU%ENDCOLOR% used </br> =9407 postgres 20 0 1192M 801M run 456:54 84.70% %RED%95.38%%ENDCOLOR% INSERT INTO billinginfo ("transaction",protocol,transfersize,"action",pnfsid,datestamp,errorcode,p2p,errormessage,fullsize,connectiontime,cellname,client,initiator,storageclass,isnew) VALUES= ---------------- %ICON{arrowleft}% Go to [[CMSTier3LogXX][previous page]] / [[CMSTier3LogXX][next page]] of Tier3 site log %M%
This topic: CmsTier3
>
WebHome
>
CMSTier3Log
>
CMSTier3Log60
Topic revision: r2 - 2014-02-14 - FabioMartinelli
Copyright © 2008-2024 by the contributing authors. All material on this collaboration platform is the property of the contributing authors.
Ideas, requests, problems regarding TWiki?
Send feedback