Tags:
dcache
1
tag this topic
create new tag
view all tags
<!-- 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%
E
dit
|
A
ttach
|
Watch
|
P
rint version
|
H
istory
: r2
<
r1
|
B
acklinks
|
V
iew topic
|
Ra
w
edit
|
M
ore topic actions
Topic revision: r2 - 2014-02-14
-
FabioMartinelli
CmsTier3
Log In
CmsTier3 Web
Create New Topic
Index
Search
Changes
Notifications
Statistics
Preferences
User Pages
Main Page
Policies
Monitoring Storage Space
Monitoring Slurm Usage
Physics Groups
Steering Board Meetings
Admin Pages
AdminArea
Cluster Specs
Home
Site map
CmsTier3 web
LCGTier2 web
PhaseC web
Main web
Sandbox web
TWiki web
CmsTier3 Web
Create New Topic
Index
Search
Changes
Notifications
RSS Feed
Statistics
Preferences
P
View
Raw View
Print version
Find backlinks
History
More topic actions
Edit
Raw edit
Attach file or image
Edit topic preference settings
Set new parent
More topic actions
Account
Log In
E
dit
A
ttach
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