.errorfile=/tmp/V-2.err (2025-04-19T22:35:53) -2 -kw.cat=36650009 -ref=VIZ6804254911e46e
-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) aviz@VIZIR'): [1745102153] 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'): [1745102153] 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'): [1745102153] 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'): [1745102153] Select MAX(dbaid) as nlogins from METAdba ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select MAX(famid) as mUCD1 from METAfam ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] 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'): [1745102153] Select kwdno_min, kwdno_max, name from METAkwcat ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAkwd Where catid=74821618 ----db1_reset(0 'metaviz@VIZIR') ----db1_select_into(0): temporary table=T1 Select catid as id, 85*(3-count(*)) as w from METAkwd where kwdid in (Select kwdid from METAkwd where catid=74821618) Group by catid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From T1 ----db1_reset(0 'metaviz@VIZIR') #---resulting table T1: 5656 tuples ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From T1 Where w=0 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From T1 Where w=85 ----db1_reset(0 'metaviz@VIZIR') ----db1_exec(0 'metaviz@VIZIR'): [1745102153] Delete from T1 where w >= 85 ------------(5642 records affected) ----db1_query(0 'metaviz@VIZIR'): [1745102153] 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'): [1745102153] Select authid, name From METAauth where authid=0 tuples [tested=146] ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From T1 Where w>=0 ----db1_reset(0 'metaviz@VIZIR') ...t+0: First pass finds 28 catalogues ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAcat Where catid in (Select id from T1) ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] 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 28 found catalogues ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select w from T1 order by id Catalog 17140476 = J/ApJ/714/476 w=0.0 Catalog 17790119 = J/ApJ/779/119 w=0.0 Catalog 17820075 = J/ApJ/782/75 w=0.0 Catalog 17830036 = J/ApJ/783/36 w=0.0 Catalog 17849007 = J/ApJ/784/L7 w=0.0 Catalog 18140052 = J/ApJ/814/52 w=0.0 Catalog 19000104 = J/ApJ/900/104 w=0.0 Catalog 21690472 = J/ApJS/169/472 w=0.0 Catalog 22050009 = J/ApJS/205/9 w=0.0 Catalog 34551161 = J/A+A/455/1161 w=0.0 Catalog 35400051 = J/A+A/540/A51 w=0.0 Catalog 35530084 = J/A+A/553/A84 w=0.0 Catalog 35770091 = J/A+A/577/A91 w=0.0 Catalog 35900093 = J/A+A/590/A93 w=0.0 Catalog 35910075 = J/A+A/591/A75 w=0.0 Catalog 36190067 = J/A+A/619/A67 w=0.0 Catalog 36210143 = J/A+A/621/A143 w=0.0 Catalog 36230093 = J/A+A/623/A93 w=0.0 Catalog 36440003 = J/A+A/644/A3 w=0.0 Catalog 36470055 = J/A+A/647/A55 w=0.0 Catalog 36570099 = J/A+A/657/A99 w=0.0 Catalog 36590111 = J/A+A/659/A111 w=0.0 Catalog 36650009 = J/A+A/665/A9 w=0.0 Catalog 36660050 = J/A+A/666/A50 w=0.0 Catalog 36660114 = J/A+A/666/A114 w=0.0 Catalog 36660158 = J/A+A/666/A158 w=0.0 Catalog 36800025 = J/A+A/680/A25 w=0.0 Catalog 74492438 = J/MNRAS/449/2438 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'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17140476 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] select login from METAdba where dbaid=44 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=17140476 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] 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'): [1745102153] SELECT max(popu) as Ncalls FROM METAcat where catid!=0 ----db1_close(1 'metaviz@VIZIR') ++++popularity(all): 6.73243e+06 => 6.83 ++++popularity(catid=17140476): 138 => 0.31 ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select idori, kwdid, name, explain From METAorigin ....DisplayFile(/srv/httpd/VizieR/=17140476) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17790119 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=17790119 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=17790119): 1088 => 0.44 ....DisplayFile(/srv/httpd/VizieR/=17790119) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17820075 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=17820075 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=17820075): 140 => 0.31 ....DisplayFile(/srv/httpd/VizieR/=17820075) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17830036 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=17830036 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=17830036): 73 => 0.27 ....DisplayFile(/srv/httpd/VizieR/=17830036) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=17849007 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=17849007 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=17849007): 921 => 0.43 ....DisplayFile(/srv/httpd/VizieR/=17849007) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=18140052 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=18140052 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=18140052): 95 => 0.29 ....DisplayFile(/srv/httpd/VizieR/=18140052) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=19000104 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=19000104 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=19000104) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=21690472 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] select login from METAdba where dbaid=45 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=21690472 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=21690472): 129 => 0.31 ....DisplayFile(/srv/httpd/VizieR/=21690472) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=22050009 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=22050009 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=22050009): 144 => 0.32 ....DisplayFile(/srv/httpd/VizieR/=22050009) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=34551161 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] select login from METAdba where dbaid=41 ----db1_reset(0 'metaviz@VIZIR') ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=34551161 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=34551161): 93 => 0.29 ....DisplayFile(/srv/httpd/VizieR/=34551161) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=35400051 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=35400051 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=35400051): 159 => 0.32 ....DisplayFile(/srv/httpd/VizieR/=35400051) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=35530084 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=35530084 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=35530084): 155 => 0.32 ....DisplayFile(/srv/httpd/VizieR/=35530084) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=35770091 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=35770091 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=35770091): 89 => 0.29 ....DisplayFile(/srv/httpd/VizieR/=35770091) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=35900093 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=35900093 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=35900093): 126 => 0.31 ....DisplayFile(/srv/httpd/VizieR/=35900093) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=35910075 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=35910075 ----db1_reset(0 'metaviz@VIZIR') ++++popularity(catid=35910075): 82 => 0.28 ....DisplayFile(/srv/httpd/VizieR/=35910075) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36190067 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36190067 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36190067) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36210143 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36210143 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36210143) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36230093 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36230093 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36230093) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36440003 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36440003 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36440003) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36470055 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36470055 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36470055) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36570099 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36570099 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36570099) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36590111 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36590111 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36590111) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36650009 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36650009 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36650009) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36660050 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36660050 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36660050) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36660114 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36660114 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36660114) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36660158 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36660158 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36660158) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=36800025 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select COUNT(*) as n From METAobj Where catid=36800025 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=36800025) ****Non-existant file**** ----db1_query(0 'metaviz@VIZIR'): [1745102153] Select name, dbname, catid, tabid, flags, equinox, epoch, explain, dbaid, cooframe, release, records, notid, comment, status, cooprec, morexplain From METAtab Where catid=74492438 order by tabid ----db1_query(0 'metaviz@VIZIR'): [1745102153] select login from METAdba where dbaid=46 ----db1_reset(0 'metaviz@VIZIR') ....DisplayFile(/srv/httpd/VizieR/=74492438) ****Non-existant file**** ----inherit(u=used, h=hidden): +kw.cat=36650009 [u] -ref=VIZ6804254911e46e [h] +kw.cat=36650009 ====inherit(): added 1 hidden fields ----free temporary files ----db1_close(0 'metaviz@VIZIR')
© Université de Strasbourg/CNRS
• Contact