#...dbdef =-SVIZIR -Ucds -P@cds4Viz viz7@VIZIR ok not a XMM cat ====Catalog J/MNRAS/441/715 already in VizieR-SVIZIR: J/MNRAS/441/715|74410715|26|1|7 J/MNRAS/441/715|74410715|26|2|7 J/MNRAS/441/715|74410715|26|3|7 #===Items in list: 1 #...Popularity of catalog (J/MNRAS/441/715): 20529 setUCD -raw /home/cats/J/MNRAS/441/715/ReadMe > /tmp/viz44497.ucd CONFIRM /home/cats/bin/confirm_no.nostdin ====Visit the 118 UCDs (in /tmp/viz44497.ucd): [N] (set by default) ====Database chosen for J/MNRAS/441/715 = viz7@VIZIR (from default dbdef) ....Cleaning the /home/cats/in/gl directory ....keeping the list of UCDs as /home/cats/in/gl/UCDs ....Executing (METADB=metaviz@VIZIR, input file=/home/cats/J/MNRAS/441/715/ReadMe): (/usr/local/bin/vizin*) CONFIRM /home/cats/bin/confirm_yes.nostdin ----Executing vizin -confirm=y -popu 20529 -d /home/cats/in/gl -SVIZIR -Ucds -P@cds4Viz -r 30d -b viz7@VIZIR -d /home/cats/in/gl -u3 /home/cats/in/gl/UCDs /home/cats/J/MNRAS/441/715/ReadMe [Y] (set by default) option confirm=y is set #... servername=cdsarc.u-strasbg.fr port=5432 dbase=vizier type=postgres (5) ---- 1 columns added from .status (0 VIRTUAL) #...\vizAddColumn{SimbadName}: values from file table1.sim ---- 2 columns (+1) added from .status (0 VIRTUAL) ****Macro '\vizFilter' doesn't match any table ----There are 10 table/column(s) concerned by \vizSet ====There were 67 UCDs loaded from: /home/cats/in/gl/UCDs use dbname=viz7@VIZIR #...Change in METAtab(explain): => Catalog of known RR Lyrae ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'Catalog of known RR L'... ----[vizier] Stat=0 from 'DROP table c74410715t1' #...Change in METAtab(explain): => References ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'References' where cat'... ----[vizier] Stat=0 from 'DROP table c74410715t2' #...Change in METAtab(explain): => WISE RR Lyrae catalogue ----[vizier] Stat=1 from 'UPDATE METAtab set morexplain = 'WISE RR Lyrae catalog'... ----[vizier] Stat=0 from 'DROP table c74410715t3' ----[vizier] Stat=0 from 'DELETE from METAqin where catid = 74410715' ----[vizier] Stat=0 from 'DELETE from METAdig where catid = 74410715' ----[vizier] Stat=8 from 'DELETE from METAsed where catid = 74410715' ----[vizier] Stat=0 from 'DELETE from METAobj where catid = 74410715' ----[vizier] Stat=0 from 'DELETE from METAtimerel where catid = 74410715' ----[vizier] Stat=0 from 'DELETE from METAtimecol where catid = 74410715' ----[vizier] Stat=63 from 'DELETE from METAcol where catid = 74410715' ----[vizier] Stat=14 from 'DELETE from METAcell00 where catid = 74410715' ----[vizier] Stat=0 from 'DELETE from METAlaf where catid = 74410715' ----[vizier] Stat=4 from 'DELETE from METAkwd where catid = 74410715' ----[vizier] Stat=0 from 'DELETE from METAcro where catid = 74410715' ----[vizier] Stat=3 from 'DELETE from METAtab where catid = 74410715' ----[vizier] Stat=6 from 'DELETE from METAnot where catid = 74410715' ----[vizier] Stat=3 from 'DELETE from METAmor where catid = 74410715' ----[vizier] Stat=0 from 'DELETE from METAcell02 where catid = 74410715' ----[vizier] Stat=142 from 'DELETE from METAcell03 where catid = 74410715' ----[vizier] Stat=390 from 'DELETE from METAcell09 where catid = 74410715' ----[vizier] Stat=664 from 'DELETE from METAcell0a where catid = 74410715' ----[vizier] Stat=968 from 'DELETE from METAcell0b where catid = 74410715' ----[vizier] Stat=1322 from 'DELETE from METAcell0c where catid = 74410715' ----[vizier] Stat=3519 from 'DELETE from METAcell0d where catid = 74410715' ----[vizier] Stat=2528 from 'DELETE from METAcell0e where catid = 74410715' ****Error execute query: INSERT into METAcat( catid, kslot, status, catype, name, title, bibcode, authors, explain, popu, authid, flags, doi, orcid) VALUES ( 74410715, 255, 16, 0, 'J/MNRAS/441/715', 'Mid-infrared study of RR Lyrae stars (Gavrilchenko+, 2014)', '2014MNRAS.441..715G', 'Gavrilchenko T., Klein C.R., Bloom J.S., Richards J.W.', '', 20529, 0, 0, '', '') **** **** --POSTGRES MSG db=1 **** Report from: stdb_pg, Status: STDB_ERR ****ERROR: duplicate key value violates unique constraint "metacat_pkey" DETAIL: K ****ey (catid)=(74410715) already exists. ****ERROR: duplicate key value violates unique constraint "metacat_pkey" DETAIL: K ****ey (catid)=(74410715) already exists. ----[vizier] Stat=-1 from 'INSERT into METAcat( catid, kslot, status, catype, name'... ----[vizier] Stat=1 from 'Update METAcat set status = status | 16 Where catid = 7'... ----[vizier] Stat=0 from 'Update METAcol set morid = 2 Where catid = 74410715 and'... ----[vizier] Stat=0 from 'Update METAcol set morid = 1 Where catid = 74410715 and'... ----[vizier] Stat=1 from 'select add_adc('J/MNRAS/441/715', 'Stars, variable');' ----[vizier] Stat=1 from 'select add_adc('J/MNRAS/441/715', 'Photometry, UBVRI');' ----[vizier] Stat=1 from 'select add_adc('J/MNRAS/441/715', 'Photometry, SDSS');' ----[vizier] Stat=1 from 'select add_adc('J/MNRAS/441/715', 'Photometry, infrared'... INFO: ----wavelength-dependent exists for catalog: J/MNRAS/441/715! ----[vizier] Stat=1 from 'select add_optical('J/MNRAS/441/715');' INFO: ....set_kslot(4!): kslot was J/MNRAS/441/715!; 26! keywords INFO: ----set_kslot(4!): kslot now J/MNRAS/441/715!; 26! keywords ----[vizier] Stat=1 from 'select set_kslot('J/MNRAS/441/715');' ----[vizier] Stat=1 from 'Update METAcat set catype = 5 Where catid = 74410715' ----[vizier] Stat=1 from 'Update METAtab set cooprec=1000.000000 Where catid = 7'... #=== 8 filters detected in J/MNRAS/441/715/table1CONFIRM: <= [y] ----[vizier] Stat=1 from 'Update METAtab set flags=flags|256 where catid=74410715'... .... Creating BCP file 'c74410715t1.bcp' (16904 rows) 16904 records. ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=74410715 and t'... .... Creating BCP file 'c74410715t2.bcp' (26 rows) 26 records. ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set flags=flags-64 where catid=74410715 '... #...table2.dat{BibCode}: option VARCHAR removed (=19.0/19) ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAtab set cooprec=1000.000000 Where catid = 7'... .... Creating BCP file 'c74410715t3.bcp' (3740 rows) 3740 records. ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=28 where catid=74410715 and t'... ----[vizier] Stat=1 from 'Update METAcol set dbtype=20 where catid=74410715 and t'... ----[vizier] Stat=3 from 'update METAtab set morexplain='' where catid=74410715 a'... ----[vizier] Stat=61 from 'update METAcol set morexplain='' where catid=74410715 a'... #The following operations were generated by vizin #From ReadMe: /home/cats/J/MNRAS/441/715/ReadMe #Into METAdb: metaviz@VIZIR # datadb: viz7@VIZIR /*++++++++ Clean up for catalog: 74410715 --------*/ #tab#1 loadate=0485452928s(2015-05-20T16:02:08) J/MNRAS/441/715/table1 #tab#2 loadate=0485452928s(2015-05-20T16:02:08) J/MNRAS/441/715/table2 #tab#3 loadate=0485452928s(2015-05-20T16:02:08) J/MNRAS/441/715/table3 /*------Clean up META tables--------*/ #==> Coordinate System of table1.dat: FK5 equinox=2000 Johnson:K in column: Kmag Johnson:H in column: Hmag Johnson:J in column: Jmag SDSS:z in column: zmag SDSS:i in column: imag SDSS:r in column: rmag SDSS:g in column: gmag SDSS:u in column: umag #==> Coordinate System of table3.dat: FK5 equinox=2000 ----Executed (0): vizin -confirm=y -popu 20529 -d /home/cats/in/gl -SVIZIR -Ucds -P@cds4Viz -r 30d -b viz7@VIZIR -d /home/cats/in/gl -u3 /home/cats/in/gl/UCDs /home/cats/J/MNRAS/441/715/ReadMe #...(already cloned to NEWVIZ) #...(already cloned to VIZDB) ....Sourcing /home/cats/in/gl/c74410715t1.sql SET ERROR: table "c74410715t1" does not exist CREATE TABLE COMMENT SET SET ....Index i0c74410715t1 (recno) CREATE INDEX ....Index i1 (RAJ2000).... CREATE INDEX ....Index i2 (DEJ2000).... CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/c74410715t2.sql SET ERROR: table "c74410715t2" does not exist CREATE TABLE COMMENT SET SET ....Index i0c74410715t2 (recno) CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/c74410715t3.sql SET ERROR: table "c74410715t3" does not exist CREATE TABLE COMMENT SET SET ....Index i0c74410715t3 (recno) CREATE INDEX GRANT CLUSTER ....Sourcing /home/cats/in/gl/zz74410715.sql SET ----From vizAddFKflag ; UPDATE 16904 UPDATE 3740 CLUSTER CLUSTER CLUSTER #***/home/cats/in/gl/zz74410715.sql returned status: 1 CONFIRM /home/cats/bin/confirm_no.nostdin Continue [N] (set by default)