date: dim. 27 oct. 2024 07:45:01 CET ===================================================== name=CFHT (obscore), dir=cfht, script=update ===================================================== 06:45:05:debug:https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus//availability 06:45:06:debug:lastmodified: update(cadc) 2023-04-30 03:38:10, delete(local) 736141091 06:45:06:debug:copy ReadMe to v109 06:45:06:debug:copy .Summary to v109 06:45:06:debug:copy obscore.dump to v109 06:45:16:debug:get data 06:45:17:debug:TAP(GET): https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus///sync?request=doQuery&phase=RUN&lang=ADQL&format=csv&query=SELECT+TOP+250000+obs_publisher_did,obs_collection,facility_name,instrument_name,obs_id,dataproduct_type,calib_level,obs_release_date,target_name,s_ra,s_dec,s_fov,s_region,s_resolution,s_xel1,s_xel2,t_min,t_max,t_exptime,t_resolution,t_xel,em_min,em_max,em_res_power,em_xel,em_ucd,pol_states,pol_xel,o_ucd,access_format,access_estsize,core_id,lastModified+FROM+ivoa.obscore+WHERE+obs_collection=%27CFHT%27+AND+lastModified%3E=%272023-04-30+03:38:10%27+ORDER+BY+lastModified+ASC 06:45:17:error:b'validateColumnNonAlias: Column: [core_id] does not exist.\n' [debug] close cursor [debug] SQL:select max(lastModified)-7200 as maxdate from b_extern.c102005obscore [debug] begin! [debug] ['736141090'] [debug] close cursor [debug] close cursor [debug] SQL:SELECT t.dbname, d.login FROM METAtab t JOIN METAdba d ON t.dbaid=d.dbaid WHERE t.name='B/cfht/obscore' [debug] begin! [debug] ['dbname', 'login'] [debug] ['c102005obscore', 'B_extern@VIZIR'] [debug] close cursor Traceback (most recent call last): File "/data/too/pyreadme/getCADC.py", line 203, in nrec = obstapManager.update("obscore", adql, vizdb, getdatafn=csv_to_dat) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 778, in update filetsv = getdatafn(self.__tap, adql, fm.tmpdirectory+"/"+filename+"."+TAP_CSV) File "/data/too/pyreadme/getCADC.py", line 178, in csv_to_dat filename = catb.default__getTAP(tap, adql, filename, fmt=catb.TAP_CSV) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 581, in default__getTAP tap.sync(adql, out) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 447, in sync raise Exception("Error connection to {0}: response={1}".format(self.__server, resp)) Exception: Error connection to https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus/: response={'server': 'OpenCADC/cadc-rest', 'www-authenticate': 'ivoa_bearer standard_id="ivo://ivoa.net/sso#tls-with-password", access_url="https://ws-cadc.canfar.net/ac/login", Bearer, ivoa_x509 standard_id="ivo://ivoa.net/sso#BasicAA", access_url="https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/cred/generate"', 'content-disposition': 'inline; filename="error_ree7ypxpe8fs0px0.csv"', 'content-type': 'text/plain', 'content-length': '58', 'date': 'Sun, 27 Oct 2024 06:45:17 GMT', 'strict-transport-security': 'max-age=63072000', 'status': '400'} error= vizaqbox -Ucds -P@cds4Viz -SVIZDB 102005 ++++vc_coo can't change epoch ++++increase the precision for computed column 15 ++++increase the precision for computed column 15 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x1] ++++vc_coo can't change epoch ++++increase the precision for computed column 7 ++++increase the precision for computed column 7 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x2] ---- Copied 77863 records in METAcell ....Insert into metaviz.METAcell00 select 102005, c.qb1, c.ns => 166 ....Insert into metaviz.METAcell02 select 102005, c.qb1, c.ns => 2425 ....Insert into metaviz.METAcell03 select 102005, c.qb1, c.ns => 1200 ....Insert into metaviz.METAcell09 select 102005, c.qb1, c.ns => 17393 ....Insert into metaviz.METAcell0a select 102005, c.qb1, c.ns => 11079 ....Insert into metaviz.METAcell0b select 102005, c.qb1, c.ns => 16681 ....Insert into metaviz.METAcell0c select 102005, c.qb1, c.ns => 14985 ....Insert into metaviz.METAcell0d select 102005, c.qb1, c.ns => 13564 ....Insert into metaviz.METAcell0e select 102005, c.qb1, c.ns => 370 ====Total counts: 3511554 ====Total non-empty qboxes: 77863 #===Items in list: 9 #===Items in list: 9 ===================================================== name=HST (obscore), dir=hst, script=update ===================================================== 06:46:16:debug:https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus//availability [debug] close cursor [debug] SQL:select max(lastModified)-7200 as maxdate from b_extern.c102004obscore Traceback (most recent call last): File "/home/cds/pythonlib/vizier.ingestion/tools/CDSdb.py", line 336, in execute raise Exception(err) Exception: b"ERREUR: la relation \xc2\xab b_extern.c102004obscore \xc2\xbb n'existe pas\n" During handling of the above exception, another exception occurred: Traceback (most recent call last): File "/data/too/pyreadme/getCADC.py", line 167, in lastModified = getLastModifiedDate(dbconn, cat["catid"], __schema) File "/data/too/pyreadme/getCADC.py", line 65, in getLastModifiedDate curs.execute("select max(lastModified)-{0} as maxdate from {1}.c{2}obscore".format(SECOND_BEFORE_LAST_MODIFIED, schema, catid)) File "/home/cds/pythonlib/vizier.ingestion/tools/CDSdb.py", line 344, in execute raise CDSdbException("error in execution: "+str(msg)) CDSdb.CDSdbException: (CDSdbException) error in execution: b"ERREUR: la relation \xc2\xab b_extern.c102004obscore \xc2\xbb n'existe pas\n" error= vizaqbox -Ucds -P@cds4Viz -SVIZDB 102004 ++++vc_coo can't change epoch ++++increase the precision for computed column 15 ++++increase the precision for computed column 15 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x1] ++++vc_coo can't change epoch ++++increase the precision for computed column 8 ++++increase the precision for computed column 8 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x2] ++++vc_coo can't change epoch ++++increase the precision for computed column 7 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x3] ++++ qbox#617775 has 254353 stars, truncated to 32767 ++++ qbox#619909 has 46853 stars, truncated to 32767 ++++ qbox#621145 has 120434 stars, truncated to 32767 ++++ qbox#621148 has 255865 stars, truncated to 32767 ++++ qbox#622411 has 35359 stars, truncated to 32767 ++++ qbox#637999 has 115147 stars, truncated to 32767 ++++ qbox#656253 has 37526 stars, truncated to 32767 ++++ qbox#674201 has 65597 stars, truncated to 32767 ++++ qbox#674460 has 64471 stars, truncated to 32767 ++++ qbox#693502 has 84147 stars, truncated to 32767 ++++ qbox#697758 has 35497 stars, truncated to 32767 ++++ qbox#716558 has 40198 stars, truncated to 32767 ++++ qbox#769110 has 33319 stars, truncated to 32767 ++++ qbox#794383 has 46224 stars, truncated to 32767 ++++ qbox#800064 has 57694 stars, truncated to 32767 ++++ qbox#806634 has 186463 stars, truncated to 32767 ++++ qbox#810126 has 63474 stars, truncated to 32767 ++++ qbox#821224 has 42511 stars, truncated to 32767 ++++ qbox#855774 has 45043 stars, truncated to 32767 ++++ qbox#863859 has 65276 stars, truncated to 32767 ++++ qbox#878676 has 51301 stars, truncated to 32767 ++++ qbox#881925 has 40753 stars, truncated to 32767 ++++ qbox#924926 has 52993 stars, truncated to 32767 ++++ qbox#937960 has 48549 stars, truncated to 32767 ++++ qbox#959793 has 62992 stars, truncated to 32767 ++++ qbox#174319 has 131561 stars, truncated to 32767 ++++ qbox#239571 has 51814 stars, truncated to 32767 ---- Copied 27208 records in METAcell ....Insert into metaviz.METAcell00 select 102004, c.qb1, c.ns => 4 ....Insert into metaviz.METAcell02 select 102004, c.qb1, c.ns => 139 ....Insert into metaviz.METAcell03 select 102004, c.qb1, c.ns => 192 ....Insert into metaviz.METAcell09 select 102004, c.qb1, c.ns => 4696 ....Insert into metaviz.METAcell0a select 102004, c.qb1, c.ns => 3944 ....Insert into metaviz.METAcell0b select 102004, c.qb1, c.ns => 5105 ....Insert into metaviz.METAcell0c select 102004, c.qb1, c.ns => 6202 ....Insert into metaviz.METAcell0d select 102004, c.qb1, c.ns => 3872 ....Insert into metaviz.METAcell0e select 102004, c.qb1, c.ns => 3054 ====Total counts: 18118170 ====Total non-empty qboxes: 27208 #===Items in list: 9 #===Items in list: 9 ===================================================== name=GEMINI (obscore), dir=gemini, script=update ===================================================== 06:47:33:debug:https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus//availability 06:47:33:debug:lastmodified: update(cadc) 2024-03-09 14:25:08, delete(local) 763309509 06:47:34:debug:copy ReadMe to v85 06:47:34:debug:copy .Summary to v85 06:47:34:debug:copy obscore.dump to v85 06:47:38:debug:get data 06:47:38:debug:TAP(GET): https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus///sync?request=doQuery&phase=RUN&lang=ADQL&format=csv&query=SELECT+TOP+200000+obs_publisher_did,obs_collection,facility_name,instrument_name,obs_id,dataproduct_type,calib_level,obs_release_date,target_name,s_ra,s_dec,s_fov,s_region,s_resolution,s_xel1,s_xel2,t_min,t_max,t_exptime,t_resolution,t_xel,em_min,em_max,em_res_power,em_xel,em_ucd,pol_states,pol_xel,o_ucd,access_format,access_estsize,core_id,lastModified+FROM+ivoa.obscore+WHERE+obs_collection=%27GEMINI%27+AND+lastModified%3E=%272024-03-09+14:25:08%27+ORDER+BY+lastModified+ASC 06:47:38:error:b'validateColumnNonAlias: Column: [core_id] does not exist.\n' [debug] close cursor [debug] SQL:select max(lastModified)-7200 as maxdate from b_extern.c102037obscore [debug] begin! [debug] ['763309508'] [debug] close cursor [debug] close cursor [debug] SQL:SELECT t.dbname, d.login FROM METAtab t JOIN METAdba d ON t.dbaid=d.dbaid WHERE t.name='B/gemini/obscore' [debug] begin! [debug] ['dbname', 'login'] [debug] ['c102037obscore', 'B_extern@VIZIR'] [debug] close cursor Traceback (most recent call last): File "/data/too/pyreadme/getCADC.py", line 203, in nrec = obstapManager.update("obscore", adql, vizdb, getdatafn=csv_to_dat) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 778, in update filetsv = getdatafn(self.__tap, adql, fm.tmpdirectory+"/"+filename+"."+TAP_CSV) File "/data/too/pyreadme/getCADC.py", line 178, in csv_to_dat filename = catb.default__getTAP(tap, adql, filename, fmt=catb.TAP_CSV) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 581, in default__getTAP tap.sync(adql, out) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 447, in sync raise Exception("Error connection to {0}: response={1}".format(self.__server, resp)) Exception: Error connection to https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus/: response={'server': 'OpenCADC/cadc-rest', 'www-authenticate': 'ivoa_bearer standard_id="ivo://ivoa.net/sso#tls-with-password", access_url="https://ws-cadc.canfar.net/ac/login", Bearer, ivoa_x509 standard_id="ivo://ivoa.net/sso#BasicAA", access_url="https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/cred/generate"', 'content-disposition': 'inline; filename="error_tl9blo3m1jbj6mp4.csv"', 'content-type': 'text/plain', 'content-length': '58', 'date': 'Sun, 27 Oct 2024 06:47:38 GMT', 'strict-transport-security': 'max-age=63072000', 'status': '400'} error= remove_moc ... OK OK:11::/home/cds/httpd/mocs/mocstables_order11/tab_102037_1_B_gemini_obscore.moc.fits create_mocs_tables ... OK merge_mocs ... OK create_mocsetbin ... OK ===================================================== name=JCMT (obscore), dir=jcmt, script=update ===================================================== 06:47:52:debug:https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus//availability 06:47:52:debug:lastmodified: update(cadc) 2014-02-08 22:54:04, delete(local) 445215245 06:47:53:debug:copy ReadMe to v342 06:47:53:debug:copy .Summary to v342 06:47:53:debug:copy obscore.dump to v342 06:47:55:debug:get data 06:47:56:debug:TAP(GET): https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus///sync?request=doQuery&phase=RUN&lang=ADQL&format=csv&query=SELECT+TOP+100000+obs_publisher_did,obs_collection,facility_name,instrument_name,obs_id,dataproduct_type,calib_level,obs_release_date,target_name,s_ra,s_dec,s_fov,s_region,s_resolution,s_xel1,s_xel2,t_min,t_max,t_exptime,t_resolution,t_xel,em_min,em_max,em_res_power,em_xel,em_ucd,pol_states,pol_xel,o_ucd,access_format,access_estsize,core_id,lastModified+FROM+ivoa.obscore+WHERE+obs_collection=%27JCMT%27+AND+lastModified%3E=%272014-02-08+22:54:04%27+ORDER+BY+lastModified+ASC 06:47:56:error:b'validateColumnNonAlias: Column: [core_id] does not exist.\n' [debug] close cursor [debug] SQL:select max(lastModified)-7200 as maxdate from B_extern.c102038obscore [debug] begin! [debug] ['445215244'] [debug] close cursor [debug] close cursor [debug] SQL:SELECT t.dbname, d.login FROM METAtab t JOIN METAdba d ON t.dbaid=d.dbaid WHERE t.name='B/jcmt/obscore' [debug] begin! [debug] ['dbname', 'login'] [debug] ['c102038obscore', 'B_extern@VIZIR'] [debug] close cursor Traceback (most recent call last): File "/data/too/pyreadme/getCADC.py", line 203, in nrec = obstapManager.update("obscore", adql, vizdb, getdatafn=csv_to_dat) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 778, in update filetsv = getdatafn(self.__tap, adql, fm.tmpdirectory+"/"+filename+"."+TAP_CSV) File "/data/too/pyreadme/getCADC.py", line 178, in csv_to_dat filename = catb.default__getTAP(tap, adql, filename, fmt=catb.TAP_CSV) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 581, in default__getTAP tap.sync(adql, out) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 447, in sync raise Exception("Error connection to {0}: response={1}".format(self.__server, resp)) Exception: Error connection to https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus/: response={'server': 'OpenCADC/cadc-rest', 'www-authenticate': 'ivoa_bearer standard_id="ivo://ivoa.net/sso#tls-with-password", access_url="https://ws-cadc.canfar.net/ac/login", Bearer, ivoa_x509 standard_id="ivo://ivoa.net/sso#BasicAA", access_url="https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/cred/generate"', 'content-disposition': 'inline; filename="error_jfc4wu47vooaft3h.csv"', 'content-type': 'text/plain', 'content-length': '58', 'date': 'Sun, 27 Oct 2024 06:47:56 GMT', 'strict-transport-security': 'max-age=63072000', 'status': '400'} error= vizaqbox -Ucds -P@cds4Viz -SVIZDB 102038 ++++vc_coo can't change epoch ++++increase the precision for computed column 13 ++++increase the precision for computed column 13 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x1] ---- Copied 44 records in METAcell ....Insert into metaviz.METAcell00 select 102038, c.qb1, c.ns => 0 ....Insert into metaviz.METAcell02 select 102038, c.qb1, c.ns => 0 ....Insert into metaviz.METAcell03 select 102038, c.qb1, c.ns => 0 ....Insert into metaviz.METAcell09 select 102038, c.qb1, c.ns => 15 ....Insert into metaviz.METAcell0a select 102038, c.qb1, c.ns => 10 ....Insert into metaviz.METAcell0b select 102038, c.qb1, c.ns => 1 ....Insert into metaviz.METAcell0c select 102038, c.qb1, c.ns => 6 ....Insert into metaviz.METAcell0d select 102038, c.qb1, c.ns => 12 ....Insert into metaviz.METAcell0e select 102038, c.qb1, c.ns => 0 ====Total counts: 115 ====Total non-empty qboxes: 44 #===Items in list: 9 #===Items in list: 9 ===================================================== name=DAO (obscore), dir=dao, script=update ===================================================== 06:47:59:debug:https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus//availability 06:47:59:debug:lastmodified: update(cadc) 2017-11-10 18:24:10, delete(local) 563653451 06:48:00:debug:copy ReadMe to v130 06:48:00:debug:copy .Summary to v130 06:48:00:debug:copy obscore.dump to v130 06:48:02:debug:get data 06:48:02:debug:TAP(GET): https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus///sync?request=doQuery&phase=RUN&lang=ADQL&format=csv&query=SELECT+TOP+50000+obs_publisher_did,obs_collection,facility_name,instrument_name,obs_id,dataproduct_type,calib_level,obs_release_date,target_name,s_ra,s_dec,s_fov,s_region,s_resolution,s_xel1,s_xel2,t_min,t_max,t_exptime,t_resolution,t_xel,em_min,em_max,em_res_power,em_xel,em_ucd,pol_states,pol_xel,o_ucd,access_format,access_estsize,core_id,lastModified+FROM+ivoa.obscore+WHERE+obs_collection=%27DAO%27+AND+lastModified%3E=%272017-11-10+18:24:10%27+ORDER+BY+lastModified+ASC 06:48:02:error:b'validateColumnNonAlias: Column: [core_id] does not exist.\n' [debug] close cursor [debug] SQL:select max(lastModified)-7200 as maxdate from b_extern.c102041obscore [debug] begin! [debug] ['563653450'] [debug] close cursor [debug] close cursor [debug] SQL:SELECT t.dbname, d.login FROM METAtab t JOIN METAdba d ON t.dbaid=d.dbaid WHERE t.name='B/dao/obscore' [debug] begin! [debug] ['dbname', 'login'] [debug] ['c102041obscore', 'B_extern@VIZIR'] [debug] close cursor Traceback (most recent call last): File "/data/too/pyreadme/getCADC.py", line 203, in nrec = obstapManager.update("obscore", adql, vizdb, getdatafn=csv_to_dat) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 778, in update filetsv = getdatafn(self.__tap, adql, fm.tmpdirectory+"/"+filename+"."+TAP_CSV) File "/data/too/pyreadme/getCADC.py", line 178, in csv_to_dat filename = catb.default__getTAP(tap, adql, filename, fmt=catb.TAP_CSV) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 581, in default__getTAP tap.sync(adql, out) File "/home/cds/pythonlib/cds.pyreadme/catb.py", line 447, in sync raise Exception("Error connection to {0}: response={1}".format(self.__server, resp)) Exception: Error connection to https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/argus/: response={'server': 'OpenCADC/cadc-rest', 'www-authenticate': 'ivoa_bearer standard_id="ivo://ivoa.net/sso#tls-with-password", access_url="https://ws-cadc.canfar.net/ac/login", Bearer, ivoa_x509 standard_id="ivo://ivoa.net/sso#BasicAA", access_url="https://ws.cadc-ccda.hia-iha.nrc-cnrc.gc.ca/cred/generate"', 'content-disposition': 'inline; filename="error_w0rn6yfzk8qflekg.csv"', 'content-type': 'text/plain', 'content-length': '58', 'date': 'Sun, 27 Oct 2024 06:48:02 GMT', 'strict-transport-security': 'max-age=63072000', 'status': '400'} error= vizaqbox -Ucds -P@cds4Viz -SVIZDB 102041 ++++vc_coo can't change epoch ++++increase the precision for computed column 14 ++++increase the precision for computed column 14 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x1] ---- Copied 149 records in METAcell ....Insert into metaviz.METAcell00 select 102041, c.qb1, c.ns => 0 ....Insert into metaviz.METAcell02 select 102041, c.qb1, c.ns => 0 ....Insert into metaviz.METAcell03 select 102041, c.qb1, c.ns => 0 ....Insert into metaviz.METAcell09 select 102041, c.qb1, c.ns => 48 ....Insert into metaviz.METAcell0a select 102041, c.qb1, c.ns => 40 ....Insert into metaviz.METAcell0b select 102041, c.qb1, c.ns => 29 ....Insert into metaviz.METAcell0c select 102041, c.qb1, c.ns => 10 ....Insert into metaviz.METAcell0d select 102041, c.qb1, c.ns => 22 ....Insert into metaviz.METAcell0e select 102041, c.qb1, c.ns => 0 ====Total counts: 1000 ====Total non-empty qboxes: 149 #===Items in list: 9 #===Items in list: 9 ===================================================== name=SWIFT, dir=swift, script=update ===================================================== 06:48:04:debug:TABLE B_extern.c102039swiftlog 06:48:04:debug:query Swift in HEASARC from processing_date>60601 06:48:09:debug:number of records is 401203 [debug] export PGPASSWORD=@cds4Viz;psql -U cds -d vizier -h 130.79.128.5 -p 5432 [debug] close cursor [debug] SQL:SELECT t.dbname, d.login FROM METAtab t JOIN METAdba d ON t.dbaid=d.dbaid WHERE t.name='B/swift/swiftlog' [debug] begin! [debug] ['dbname', 'login'] [debug] ['c102039swiftlog', 'B_extern@VIZIR'] [debug] close cursor [debug] export PGPASSWORD=@cds4Viz;psql -U cds -d vizier -h 130.79.128.5 -p 5432 [debug] close cursor [debug] SQL:select max(processing_date) as maxdate from B_extern.c102039swiftlog [debug] begin! [debug] ['60601'] [debug] close cursor [debug] export PGPASSWORD=@cds4Viz;psql -U cds -d vizier -h 130.79.128.5 -p 5432 [debug] close cursor [debug] SQL:begin; delete from B_extern.c102039swiftlog where processing_date>=60601; \copy B_extern.c102039swiftlog from swiftlog.csv with null as '' commit; [debug] begin! [debug] b'BEGIN\n' [debug] b'DELETE 151\n' [debug] b'COPY 774\n' [debug] b'COMMIT\n' [debug] close cursor [debug] close cursor [debug] export PGPASSWORD=@cds4Viz;psql -U cds -d vizier -h 130.79.128.5 -p 5432 [debug] close cursor [debug] SQL:SELECT count(*) FROM B_extern.c102039swiftlog [debug] begin! [debug] ['401203'] [debug] close cursor [debug] SQL:UPDATE METAtab SET release=783326888, records=401203 WHERE name='B/swift/swiftlog' [debug] begin! [debug] b'UPDATE 1\n' [debug] close cursor [debug] close cursor [debug] close cursor [debug] SQL:UPDATE METAtab SET loadate=loadate+1 WHERE name='B/swift/swiftlog' [debug] begin! [debug] b'UPDATE 1\n' [debug] close cursor [debug] close cursor [debug] close cursor [debug] SQL:comment on table B_extern.c102039swiftlog is '783326888' [debug] begin! [debug] b'COMMENT\n' [debug] close cursor [debug] close cursor [debug] export PGPASSWORD=@cds4Viz;psql -U cds -d vizier -h 130.79.128.5 -p 5432 [debug] close cursor [debug] SQL:\copy B_extern.c102039swiftlog to swiftlog.dump with null as '' [debug] begin! [debug] b'COPY 401203\n' [debug] close cursor [debug] close cursor vizaqbox -Ucds -P@cds4Viz -SVIZDB 102039 ++++vc_coo can't change epoch ++++increase the precision for computed column 11 ++++increase the precision for computed column 11 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x1] ---- Copied 44304 records in METAcell ....Insert into metaviz.METAcell00 select 102039, c.qb1, c.ns => 180 ....Insert into metaviz.METAcell02 select 102039, c.qb1, c.ns => 785 ....Insert into metaviz.METAcell03 select 102039, c.qb1, c.ns => 878 ....Insert into metaviz.METAcell09 select 102039, c.qb1, c.ns => 7638 ....Insert into metaviz.METAcell0a select 102039, c.qb1, c.ns => 6527 ....Insert into metaviz.METAcell0b select 102039, c.qb1, c.ns => 7103 ....Insert into metaviz.METAcell0c select 102039, c.qb1, c.ns => 7950 ....Insert into metaviz.METAcell0d select 102039, c.qb1, c.ns => 6482 ....Insert into metaviz.METAcell0e select 102039, c.qb1, c.ns => 6761 ====Total counts: 401121 ====Total non-empty qboxes: 44304 #===Items in list: 9 #===Items in list: 9 ===================================================== name=ASSOCDATA (obscore), dir=assocdata, script=update ===================================================== number of records: 8374628 1 update qboxes... >>>>>>>>>>>> begin vizin program ---- Parse ReadMe/.status/.Summary ... ++++vc_coo can't change epoch ++++increase the precision for computed column 13 ++++increase the precision for computed column 13 #...CooCompute fk5(Eq=2000, Ep=2000) from: fk5(Eq=2000, Ep=2000) [x1] ++++ qbox#621148 has 38535 stars, truncated to 32767 ---- Copied 22707 records in METAcell ....Insert into metaviz.METAcell00 select 102036, c.qb1, c.ns => 2920 ....Insert into metaviz.METAcell02 select 102036, c.qb1, c.ns => 2218 ....Insert into metaviz.METAcell03 select 102036, c.qb1, c.ns => 1712 ....Insert into metaviz.METAcell09 select 102036, c.qb1, c.ns => 3014 ....Insert into metaviz.METAcell0a select 102036, c.qb1, c.ns => 1559 ....Insert into metaviz.METAcell0b select 102036, c.qb1, c.ns => 3134 ....Insert into metaviz.METAcell0c select 102036, c.qb1, c.ns => 1912 ....Insert into metaviz.METAcell0d select 102036, c.qb1, c.ns => 4219 ....Insert into metaviz.METAcell0e select 102036, c.qb1, c.ns => 2019 ====Total counts: 8370729 ====Total non-empty qboxes: 22707 cat: /tmp/viz2633689.foot: No such file or directory #...qfoot catid=102036 => 987 boxes. gawk: cmd. line:8: (FILENAME=- FNR=143) fatal: division by zero attempted cat: /tmp/viz2633689.foot: No such file or directory #...qfootimage catid=102036 -gal -z 5 -swing 1 => ./+footg5.gif #===Items in list: 9 #...qfootimage catid=102036 -gal -z 8 -swing 1 => ./+footg8.gif #===Items in list: 9 ===================================================== name=IAU27 (archives), dir=/ftp/catx/iau27, script=update ===================================================== ###################################################################### # IAU27 (Archives) ###################################################################### #...Getting IBVS#2246 /tmp/IBVS-2246: File exists. URL transformed to HTTPS due to an HSTS policy --2024-10-27 07:49:40-- https://www.konkoly.hu/cgi-bin/IBVS?2246 Resolving www.konkoly.hu (www.konkoly.hu)... 217.144.56.57 Connecting to www.konkoly.hu (www.konkoly.hu)|217.144.56.57|:443... connected. HTTP request sent, awaiting response... 301 Moved Permanently Location: https://konkoly.hu/cgi-bin/IBVS?2246 [following] --2024-10-27 07:49:41-- https://konkoly.hu/cgi-bin/IBVS?2246 Resolving konkoly.hu (konkoly.hu)... 217.144.56.57 Connecting to konkoly.hu (konkoly.hu)|217.144.56.57|:443... connected. HTTP request sent, awaiting response... 404 Not Found 2024-10-27 07:49:41 ERROR 404: Not Found. cmp: EOF on /tmp/IBVS-2246 which is empty #***New version of /ftp/catx/iau27/.IBVS-2246: wc: /tmp/IBVS2246.txt: No such file or directory 432 2785 28041 /ftp/catx/iau27/.IBVS-2246 432 2785 28041 total #===Replace /ftp/catx/iau27/.IBVS-2246 ===================================================== name=FIRST data (alert only if new HTML page), dir=/ftp/cats/VIII/92, script=update ===================================================== ###################################################################### # FIRST data ###################################################################### #...Verify FIRST --2024-10-27 07:49:41-- http://sundog.stsci.edu/first/catalogs/ Resolving sundog.stsci.edu (sundog.stsci.edu)... 130.167.201.60 Connecting to sundog.stsci.edu (sundog.stsci.edu)|130.167.201.60|:80... connected. HTTP request sent, awaiting response... 200 OK Length: 20773 (20K) [text/html] Saving to: 'STDOUT' 0K .......... .......... 100% 202K=0.1s 2024-10-27 07:49:41 (202 KB/s) - written to stdout [20773/20773] #===No change in FIRST (/ftp/cats/VIII/92) ===================================================== name=GAMA (alert only if new HTML page), dir=/ftp/cats/J/MNRAS/413/971, script=update ===================================================== ###################################################################### # GAMA ###################################################################### #...Verify GAMA (J/MNRAS/413/971) --2024-10-27 07:49:42-- http://www.gama-survey.org/ Resolving www.gama-survey.org (www.gama-survey.org)... 134.100.28.116 Connecting to www.gama-survey.org (www.gama-survey.org)|134.100.28.116|:80... connected. HTTP request sent, awaiting response... 302 Found Location: https://www.gama-survey.org/ [following] --2024-10-27 07:49:42-- https://www.gama-survey.org/ Connecting to www.gama-survey.org (www.gama-survey.org)|134.100.28.116|:443... connected. HTTP request sent, awaiting response... 200 OK Length: unspecified [text/html] Saving to: 'index.html.268' 0K .......... .......... .... 68.5M=0s 2024-10-27 07:49:42 (68.5 MB/s) - 'index.html.268' saved [25012] cmp: EOF on /tmp/gama.html which is empty #***GAMA (J/MNRAS/413/971) description modified? 0 0 0 /tmp/gama.html 599 1513 21498 /ftp/cats/J/MNRAS/413/971/gama.html 599 1513 21498 total