.errorfile=/tmp/V-2.err (2025-04-12T08:19:27) -2 -kw.cat=17540091 -ref=VIZ67fa220f1d707
-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) IZIR'): [1744445967] 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 = 'METAtab' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAcol' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAcat' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAmor' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAdic' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAdig' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAfam' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAucd' ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 = 'METAauth' ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select MAX(dbaid) as nlogins from METAdba ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select MAX(famid) as mUCD1 from METAfam ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select hstid, flag from METAhst where name='9e180a4339b6.astro.unistra.fr' ++++-source is empty++++ ....meta_init: connection to ReferenceDirectory already done ...t+0: table_catid() ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select kwdno_min, kwdno_max, name from METAkwcat ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From METAkwd Where catid=17540091 ----db1_reset(0 'metaviz@VIZIR') ----db1_select_into(0): temporary table=T1 Select catid as id, 36*(7-count(*)) as w from METAkwd where kwdid in (Select kwdid from METAkwd where catid=17540091) Group by catid ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From T1 ----db1_reset(0 'metaviz@VIZIR') #---resulting table T1: 18878 tuples ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From T1 Where w=0 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From T1 Where w=36 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From T1 Where w=72 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From T1 Where w=108 ----db1_reset(0 'metaviz@VIZIR') ----db1_exec(0 'metaviz@VIZIR'): [1744445967] Delete from T1 where w >= 108 ------------(18849 records affected) ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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'): [1744445967] Select authid, name From METAauth where authid=0 ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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'): [1744445967] Select catid, morid, text From METAmor where catid=0 order by morid ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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'): [1744445967] 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'): [1744445967] 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'): [1744445967] Select colid, photid, fltrid, photid1, fltrid1 From METAsed where catid=0 and tabid=11 ----db1_query(0 'metaviz@VIZIR'): [1744445967] select login from METAdba where login like 'large_tables%' ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, kwdid, kwdkm, kwdno, Nk From METAkwdef #...meta_close(1): retrieved 146/0 tuples [tested=146] ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From T1 Where w>=0 ----db1_reset(0 'metaviz@VIZIR') ...t+0: First pass finds 29 catalogues ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From METAcat Where catid in (Select id from T1) ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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 29 found catalogues ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select w from T1 order by id Catalog 17540091 = J/ApJ/754/91 w=0.0 Catalog 18230157 = J/ApJ/823/157 w=72.0 Catalog 18360168 = J/ApJ/836/168 w=72.0 Catalog 18590075 = J/ApJ/859/75 w=72.0 Catalog 18600109 = J/ApJ/860/109 w=72.0 Catalog 18740097 = J/ApJ/874/97 w=72.0 Catalog 19170011 = J/ApJ/917/11 w=72.0 Catalog 19300007 = J/ApJ/930/7 w=72.0 Catalog 22370038 = J/ApJS/237/38 w=72.0 Catalog 22570022 = J/ApJS/257/22 w=72.0 Catalog 22650050 = J/ApJS/265/50 w=72.0 Catalog 22660011 = J/ApJS/266/11 w=72.0 Catalog 33840491 = J/A+A/384/491 w=72.0 Catalog 41440005 = J/A+AS/144/5 w=72.0 Catalog 41450451 = J/A+AS/145/451 w=72.0 Catalog 51190727 = J/AJ/119/727 w=72.0 Catalog 51520040 = J/AJ/152/40 w=72.0 Catalog 51540057 = J/AJ/154/57 w=36.0 Catalog 51560006 = J/AJ/156/6 w=72.0 Catalog 51560037 = J/AJ/156/37 w=72.0 Catalog 51560082 = J/AJ/156/82 w=72.0 Catalog 51590254 = J/AJ/159/254 w=72.0 Catalog 51610288 = J/AJ/161/288 w=72.0 Catalog 51680081 = J/AJ/168/81 w=72.0 Catalog 74171823 = J/MNRAS/417/1823 w=72.0 Catalog 74915216 = J/MNRAS/491/5216 w=72.0 Catalog 75075161 = J/MNRAS/507/5161 w=72.0 Catalog 75093355 = J/MNRAS/509/3355 w=72.0 Catalog 75121710 = J/MNRAS/512/1710 w=72.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'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18230157 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744445967] select login from METAdba where dbaid=44 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] 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'): [1744445967] SELECT max(popu) as Ncalls FROM METAcat where catid!=0 ----db1_close(1 'metaviz@VIZIR') ++++popularity(all): 6.73243e+06 => 6.83 ++++popularity(catid=18230157): 233 => 0.35 ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select idori, kwdid, name, explain From METAorigin ....DisplayFile(/srv/httpd/VizieR/=18230157) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18360168 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18360168) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18590075 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18590075) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18600109 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18600109) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18740097 order by tabid ....DisplayFile(/srv/httpd/VizieR/=18740097) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19170011 order by tabid ....DisplayFile(/srv/httpd/VizieR/=19170011) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19300007 order by tabid ....DisplayFile(/srv/httpd/VizieR/=19300007) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22370038 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744445967] select login from METAdba where dbaid=45 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=22370038) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22570022 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22570022) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22650050 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22650050) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22660011 order by tabid ....DisplayFile(/srv/httpd/VizieR/=22660011) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=33840491 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744445967] select login from METAdba where dbaid=41 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=33840491): 1414 => 0.46 ....DisplayFile(/srv/httpd/VizieR/=33840491) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=41440005 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744445967] select login from METAdba where dbaid=42 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=41440005): 1296 => 0.46 ....DisplayFile(/srv/httpd/VizieR/=41440005) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=41450451 order by tabid ++++popularity(catid=41450451): 1723 => 0.47 ....DisplayFile(/srv/httpd/VizieR/=41450451) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51190727 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744445967] select login from METAdba where dbaid=43 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select COUNT(*) as n From METAobj Where catid=51190727 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=51190727): 179 => 0.33 ....DisplayFile(/srv/httpd/VizieR/=51190727) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51520040 order by tabid ++++popularity(catid=51520040): 863 => 0.43 ....DisplayFile(/srv/httpd/VizieR/=51520040) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51560006 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51560006) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51560037 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51560037) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51560082 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51560082) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51590254 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51590254) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51610288 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51610288) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51680081 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51680081) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74171823 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1744445967] select login from METAdba where dbaid=46 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=74171823) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74915216 order by tabid ....DisplayFile(/srv/httpd/VizieR/=74915216) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=75075161 order by tabid ....DisplayFile(/srv/httpd/VizieR/=75075161) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=75093355 order by tabid ....DisplayFile(/srv/httpd/VizieR/=75093355) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=75121710 order by tabid ....DisplayFile(/srv/httpd/VizieR/=75121710) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=51540057 order by tabid ....DisplayFile(/srv/httpd/VizieR/=51540057) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1744445967] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17540091 order by tabid ++++popularity(catid=17540091): 1170 => 0.45 ....DisplayFile(/srv/httpd/VizieR/=17540091) ****Non-existant file**** ----inherit(u=used, h=hidden): +kw.cat=17540091 [u] -ref=VIZ67fa220f1d707 [h] +kw.cat=17540091 ====inherit(): added 1 hidden fields ----free temporary files ----db1_close(0 'metaviz@VIZIR')
© Université de Strasbourg/CNRS
• Contact