.errorfile=/tmp/V-2.err (2025-04-19T06:38:31) -2 -kw.cat=7215 -ref=VIZ680344e7cad60
-rwxr-xr-x 1 root root 963736 Apr 10 15:32 /srv/httpd/bin/vizier vizier -- Version 7.5 cgiprint -- version 9.68 (2016-01-16) 0): temporary table=T1 Select catid as id, 63*(4-count(*)) as w from METAkwd where kwdid in (Select kwdid from METAkwd where catid=7188) Group by catid ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From T1 ----db1_reset(0 'metaviz@VIZIR') #---resulting table T1: 15712 tuples ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From T1 Where w=0 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From T1 Where w=63 ----db1_reset(0 'metaviz@VIZIR') ----db1_exec(0 'metaviz@VIZIR'): [1745044711] Delete from T1 where w >= 63 ------------(15680 records affected) ----db1_query(0 'metaviz@VIZIR'): [1745044711] select k.catid,k.kwdid from METAkwd k,T1 t where k.catid=t.id and ((-1*kwdid)<(select min(kwdno_min*1) from METAkwcat where name in ('Astronomy')) or (-1*kwdid)>(select max(kwdno_max*1) from METAkwcat where name in ('Astronomy'))) order by catid ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select authid, name From METAauth where authid=0 ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METAkwdef' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0)) ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select catid, morid, text From METAmor where catid=0 order by morid ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, famid, type, dbtype, length, flags, fmt, unit, dbunit, explain, colid, notid, morid, ucdid, vounit, morexplain From METAcol where catid=0 and tabid=11 order by colid ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length from METAcol, METAtab where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid and METAtab.name = 'METAfilter' ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select METAcol.name as name, METAcol.dbname as dbname, METAcol.length as length from METAcol, METAtab where METAcol.catid=0 and METAtab.catid=0 and METAcol.tabid = METAtab.tabid and METAtab.name = 'METAsed' ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11 ----db1_query(0 'metaviz@VIZIR'): [1745044711] select login from METAdba where login like 'large_tables%' ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef #...meta_close(1): retrieved 146/0 tuples [tested=146] ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From T1 Where w>=0 ----db1_reset(0 'metaviz@VIZIR') ...t+0: First pass finds 32 catalogues ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAcat Where catid in (Select id from T1) ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, catid, title, kslot, explain, status, popu, authid, bibcode, flags, doi, orcid, authors From METAcat where catid in (Select id from T1) and (authid=0) ...t+0: Saved all 32 found catalogues ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select w from T1 order by id Catalog 7188 = VII/188 w=0.0 Catalog 7207 = VII/207 w=0.0 Catalog 7215 = VII/215 w=0.0 Catalog 7224 = VII/224 w=0.0 Catalog 7235 = VII/235 w=0.0 Catalog 7248 = VII/248 w=0.0 Catalog 16960580 = J/ApJ/696/580 w=0.0 Catalog 17100764 = J/ApJ/710/764 w=0.0 Catalog 17260016 = J/ApJ/726/16 w=0.0 Catalog 17440177 = J/ApJ/744/177 w=0.0 Catalog 18100014 = J/ApJ/810/14 w=0.0 Catalog 18359038 = J/ApJ/835/L38 w=0.0 Catalog 18670131 = J/ApJ/867/131 w=0.0 Catalog 18800032 = J/ApJ/880/32 w=0.0 Catalog 19130146 = J/ApJ/913/146 w=0.0 Catalog 19250120 = J/ApJ/925/120 w=0.0 Catalog 19430167 = J/ApJ/943/167 w=0.0 Catalog 21890001 = J/ApJS/189/1 w=0.0 Catalog 22570041 = J/ApJS/257/41 w=0.0 Catalog 22600012 = J/ApJS/260/12 w=0.0 Catalog 22620018 = J/ApJS/262/18 w=0.0 Catalog 22710020 = J/ApJS/271/20 w=0.0 Catalog 34720699 = J/A+A/472/699 w=0.0 Catalog 51390390 = J/AJ/139/390 w=0.0 Catalog 51440105 = J/AJ/144/105 w=0.0 Catalog 51460120 = J/AJ/146/120 w=0.0 Catalog 51470143 = J/AJ/147/143 w=0.0 Catalog 51520012 = J/AJ/152/12 w=0.0 Catalog 51610196 = J/AJ/161/196 w=0.0 Catalog 75100469 = J/MNRAS/510/469 w=0.0 Catalog 75101791 = J/MNRAS/510/1791 w=0.0 Catalog 1028000801 = J/other/ChJAA/8.385 w=0.0 ----db1_reset(0 'metaviz@VIZIR') ====Contents of more_defs: (nil) ====argColors='(nil)' ....DisplayFile(/srv/httpd/VizieR/+menu.htx) ****Non-existant file**** ....DisplayFile(/srv/httpd/VizieR/+news.htx) ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAtab Where catid=7188 and cooframe > 0 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab where name = 'METApop' and catid in (select catid from METAcat where catid=METAtab.catid and (authid=0)) ----db1_reset(0 'metaviz@VIZIR') ----db1_open(metaviz@VIZIR) gives: 1 ----Open server: 130.79.128.5, port 5432 (type postgres base vizier) ----db1_query(1 'metaviz@VIZIR'): [1745044711] SELECT max(popu) as Ncalls FROM METAcat where catid!=0 ----db1_close(1 'metaviz@VIZIR') ++++popularity(all): 6.73243e+06 => 6.83 ++++popularity(catid=7188): 850 => 0.43 ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select idori, kwdid, name, explain From METAorigin ....DisplayFile(/srv/httpd/VizieR/=7188) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAtab Where catid=7207 and cooframe > 0 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=7207): 852 => 0.43 ....DisplayFile(/srv/httpd/VizieR/=7207) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAtab Where catid=7215 and cooframe > 0 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=7215): 846 => 0.43 ....DisplayFile(/srv/httpd/VizieR/=7215) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAtab Where catid=7224 and cooframe > 0 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=7224): 1041 => 0.44 ....DisplayFile(/srv/httpd/VizieR/=7224) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAtab Where catid=7235 and cooframe > 0 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=7235): 1050 => 0.44 ....DisplayFile(/srv/httpd/VizieR/=7235) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAtab Where catid=7248 and cooframe > 0 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=7248): 923 => 0.43 ....DisplayFile(/srv/httpd/VizieR/=7248) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=16960580 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745044711] select login from METAdba where dbaid=44 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=16960580): 2304 => 0.49 ....DisplayFile(/srv/httpd/VizieR/=16960580) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17100764 order by tabid ++++popularity(catid=17100764): 3907 => 0.53 ....DisplayFile(/srv/httpd/VizieR/=17100764) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17260016 order by tabid ++++popularity(catid=17260016): 2566 => 0.50 ....DisplayFile(/srv/httpd/VizieR/=17260016) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17440177 order by tabid ++++popularity(catid=17440177): 4105 => 0.53 ....DisplayFile(/srv/httpd/VizieR/=17440177) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18100014 order by tabid ++++popularity(catid=18100014): 2343 => 0.49 ....DisplayFile(/srv/httpd/VizieR/=18100014) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18359038 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18359038) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18670131 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18670131) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18800032 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18800032) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19130146 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAobj Where catid=19130146 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=19130146) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19250120 order by tabid ....DisplayFile(/srv/httpd/VizieR/=19250120) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19430167 order by tabid ....DisplayFile(/srv/httpd/VizieR/=19430167) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21890001 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745044711] select login from METAdba where dbaid=45 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=21890001): 2232 => 0.49 ....DisplayFile(/srv/httpd/VizieR/=21890001) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22570041 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22570041) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22600012 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22600012) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22620018 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22620018) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22710020 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22710020) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=34720699 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745044711] select login from METAdba where dbaid=41 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=34720699): 2412 => 0.50 ....DisplayFile(/srv/httpd/VizieR/=34720699) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51390390 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745044711] select login from METAdba where dbaid=43 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=51390390): 4030 => 0.53 ....DisplayFile(/srv/httpd/VizieR/=51390390) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51440105 order by tabid ++++popularity(catid=51440105): 2394 => 0.49 ....DisplayFile(/srv/httpd/VizieR/=51440105) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51460120 order by tabid ++++popularity(catid=51460120): 2840 => 0.51 ....DisplayFile(/srv/httpd/VizieR/=51460120) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51470143 order by tabid ++++popularity(catid=51470143): 1600 => 0.47 ....DisplayFile(/srv/httpd/VizieR/=51470143) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51520012 order by tabid ++++popularity(catid=51520012): 3629 => 0.52 ....DisplayFile(/srv/httpd/VizieR/=51520012) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51610196 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51610196) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=75100469 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745044711] select login from METAdba where dbaid=46 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=75100469) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=75101791 order by tabid ....DisplayFile(/srv/httpd/VizieR/=75101791) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=1028000801 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745044711] select login from METAdba where dbaid=50 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=1028000801): 1391 => 0.46 ....DisplayFile(/srv/httpd/VizieR/=1028000801) ****Non-existant file**** ----inherit(u=used, h=hidden): +kw.cat=7215 [u] -ref=VIZ680344e7cad60 [h] +kw.cat=7215 ====inherit(): added 1 hidden fields ....DisplayFile(/srv/httpd/VizieR/=1028000801) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745044711] Select COUNT(*) as n From METAtab Where catid=7248 and cooframe > 0 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=7248): 923 => 0.43 ....DisplayFile(/srv/httpd/VizieR/=7248) ****Non-existant file**** ----inherit(u=used, h=hidden): +kw.cat=7248 [u] -ref=VIZ680344e7cad3c [h] +kw.cat=7248 ====inherit(): added 1 hidden fields ----free temporary files ----db1_close(0 'metaviz@VIZIR') ----free temporary files ----db1_close(0 'metaviz@VIZIR')
© Université de Strasbourg/CNRS
• Contact