objdb broken after overwritting a target

[larnoldgithub]

Hi Neill Yesterday I entered a target and wanted to update it with a new alias this morning. I used the --overwrite but now the db is broken. apero_astrometrics.py 'Gl699' fails for example. panda errors.

[larnoldgithub]

here is what I get for the last target I entered (an alias of it is SVS 20 S)

apero_astrometrics.py 'IRAS 18274+0112' 03:16:53.426- |ASTROM| 03:16:53.432- |ASTROM| 03:16:53.432- |ASTROM| SPIROU @PID-00017273206128158792-9U6H (V0.7.288) 03:16:53.432- |ASTROM| py3.9.16 git:v0.7.288-stable-test 03:16:53.433- |ASTROM| 03:16:53.438- |ASTROM| 03:16:53.444- |ASTROM| █████╗ ██████╗ ███████╗██████╗ ██████╗
03:16:53.450- |ASTROM| ██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔═══██╗ 03:16:53.455- |ASTROM| ███████║██████╔╝█████╗ ██████╔╝██║ ██║ 03:16:53.461- |ASTROM| ██╔══██║██╔═══╝ ██╔══╝ ██╔══██╗██║ ██║ 03:16:53.467- |ASTROM| ██║ ██║██║ ███████╗██║ ██║╚██████╔╝ 03:16:53.472- |ASTROM| ╚═╝ ╚═╝╚═╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝
03:16:53.478- |ASTROM| * 03:16:53.486-|ASTROM| DRS Setup: 03:16:53.492-|ASTROM| 03:16:53.492-|ASTROM| DRS_ROOT: /apero/apero-drs/apero 03:16:53.492-|ASTROM| DRS_DATA_RAW: /data/spirou4/arlinks 03:16:53.492-|ASTROM| DRS_DATA_REDUC: /data/spirou4/apero-data/offline/red 03:16:53.492-|ASTROM| DRS_DATA_WORKING: /data/spirou4/apero-data/offline/tmp 03:16:53.493-|ASTROM| DRS_CALIB_DB: /data/spirou4/apero-data/offline/calib 03:16:53.493-|ASTROM| DRS_TELLU_DB: /data/spirou4/apero-data/offline/tellu 03:16:53.493-|ASTROM| DRS_DATA_ASSETS: /data/spirou4/apero-data/offline/asset 03:16:53.493-|ASTROM| DRS_DATA_MSG: /data/spirou4/apero-data/offline/msg 03:16:53.493-|ASTROM| DRS_DATA_RUN: /data/spirou4/apero-data/offline/run 03:16:53.493-|ASTROM| DRS_DATA_PLOT: /data/spirou4/apero-data/offline/plot 03:16:53.493-|ASTROM| DRS_CONFIG: /apero/config/offline/user_config.ini 03:16:53.494-|ASTROM| DRS_CONFIG: /apero/config/offline/user_constants.ini 03:16:53.494-|ASTROM| DRS_CONFIG: apero.constants.default.default_config 03:16:53.494-|ASTROM| DRS_CONFIG: apero.constants.default.default_keywords 03:16:53.494-|ASTROM| DRS_CONFIG: config.instruments.spirou.default_config.py 03:16:53.494-|ASTROM| DRS_CONFIG: config.instruments.spirou.default_keywords.py 03:16:53.494-|ASTROM| DRS_CONFIG: core.instruments.default.default_constants.py 03:16:53.495-|ASTROM| DRS_CONFIG: core.instruments.spirou.default_constants.py 03:16:53.495-|ASTROM| DATABASE: MYSQL 03:16:53.495-|ASTROM| DATABASE-calib: aperooffline@localhost:calib_offline_db 03:16:53.495-|ASTROM| DATABASE-tellu: aperooffline@localhost:tellu_offline_db 03:16:53.495-|ASTROM| DATABASE-findex: aperooffline@localhost:findex_offline_db 03:16:53.495-|ASTROM| DATABASE-log: aperooffline@localhost:log_offline_db 03:16:53.495-|ASTROM| DATABASE-astrom: aperooffline@localhost:astrom_offline_db 03:16:53.496-|ASTROM| DATABASE-lang: aperooffline@localhost:lang_offline_db 03:16:53.496-|ASTROM| DATABASE-reject: aperooffline@localhost:reject_offline_db 03:16:53.496-|ASTROM| PRINT_LEVEL: all 03:16:53.496-|ASTROM| LOG_LEVEL: all 03:16:53.496-*|ASTROM| DRS_PLOT: 0 03:16:53.502- |ASTROM| 03:16:53.507-|ASTROM| Arguments used: 03:16:53.513-|ASTROM| 03:16:53.513-|ASTROM| --OBJECTS: IRAS 18274+0112 03:16:53.519- |ASTROM| *** 03:16:55.200- |ASTROM| Updating object database (from google sheets) 03:17:04.020-!!|ASTROM| 03:17:04.014-|DatabaseError|E[00-002-00047] Pandas.to_sql <class 03:17:04.020-!!|ASTROM| 'sqlalchemy.exc.IntegrityError'>: (mysql.connector.errors.IntegrityError) 1062 03:17:04.020-!!|ASTROM| (23000): Duplicate entry 03:17:04.020-!!|ASTROM| 'bd6f7bc8f4b07b5a9073fc8b7d51978e20dc209271262b8a72701f22c91e73e6' for key 03:17:04.020-!!|ASTROM| 'astrom_offline_db.UHASH' 03:17:04.021-!!|ASTROM| [SQL: INSERT INTO astrom_offline_db (OBJNAME, ORIGINAL_NAME, ALIASES, 03:17:04.021-!!|ASTROM| RA_DEG, RA_SOURCE, DEC_DEG, DEC_SOURCE, EPOCH, PMRA, PMRA_SOURCE, 03:17:04.021-!!|ASTROM| PMDE, PMDE_SOURCE, PLX, PLX_SOURCE, RV, RV_SOURCE, TEFF, 03:17:04.021-!!|ASTROM| TEFF_SOURCE, SP_TYPE, SP_SOURCE, NOTES, USED, DATE_ADDED, UHASH) 03:17:04.021-!!|ASTROM| VALUES (%(OBJNAME)s, %(ORIGINAL_NAME)s, %(ALIASES)s, %(RA_DEG)s, %(RA_SOURCE)s, 03:17:04.021-!!|ASTROM| %(DEC_DEG)s, %(DEC_SOURCE)s, %(EPOCH)s, %(PMRA)s, %(PMRA_SOURCE)s, %(PMDE)s, 03:17:04.021-!!|ASTROM| %(PMDE_SOURCE)s, %(PLX)s, %(PLX_SOURCE)s, %(RV)s, %(RV_SOURCE)s, %(TEFF)s, 03:17:04.021-!!|ASTROM| %(TEFF_SOURCE)s, %(SP_TYPE)s, %(SP_SOURCE)s, %(NOTES)s, %(USED)s, 03:17:04.021-!!|ASTROM| %(DATE_ADDED)s, %(UHASH)s)] 03:17:04.021-!!|ASTROM| [parameters: [{'OBJNAME': '10_LAC', 'ORIGINAL_NAME': ' 10 Lac', 'ALIASES': ' 03:17:04.021-!!|ASTROM| 10 Lac| S 813A|* TRN 36|1RXS J223916.4+390252|2MASS J22391567+3903011|ADS 03:17:04.021-!!|ASTROM| 16148 A|AG+38 2350|ALS 14844|BD+38 4826|CCDM J22393+3903A|CEL 5 ... (1090 03:17:04.021-!!|ASTROM| characters truncated) ... 03:17:04.021-!!|ASTROM| 5|10Lac|S813A|TRN36|10LAC|BD+384826|CEL5504|CSI+3848262|FK5852|HGAM1078|HR8622|JP113513|PMC90-93599|PPM88031|ROT3301|SAO72575|UBV19389|UBVM26533', 03:17:04.021-!!|ASTROM| 'RA_DEG': 339.8153184, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 39.05024586, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.436831092, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -4.802891782, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 2.787612618, 'PLX_SOURCE': 'Gaia DR2', 'RV': -10.1, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 35200.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'O9V', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2022-01-31 18:24:17.089 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| 'fe642c035622dbe3482b908f19fc37ffda174b0e534d71ac56febbaf26b137f9'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| '11COM', 'ORIGINAL_NAME': '11Com', 'ALIASES': '* 11 Com|* HO 52A|ADS 8521 03:17:04.021-!!|ASTROM| A|AG+18 1179|BD+18 2592|CCDM J12207+1748A|CSI+18 2592 1|FK5 2987|GC 16835|GCRV 03:17:04.021-!!|ASTROM| 7404|GEN# +1.00107383|GSC 01445-02 ... (641 characters truncated) ... 03:17:04.021-!!|ASTROM| D116214|TIC72437047|TYC1445-2560-1|UBV11083|UBVM18084|WDSJ12207+1748A|WEB10703|YPAC260|YZ184649|GaiaDR33946945413106333696|GaiaDR23946945413106333696', 03:17:04.021-!!|ASTROM| 'RA_DEG': 185.1787793, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 17.79325164, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -109.2413803, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': 88.17010164, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 10.71044534, 'PLX_SOURCE': 'Gaia DR2', 'RV': 43.37, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2018yCat.1345....0G', 'TEFF': 4741.0, 'TEFF_SOURCE': '2016A&A...585A...5B', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'G8+IIIFe-1', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2023-08-18 15:47:26.028 by nirps-client@maestria using drs_astrometrics.py', 03:17:04.021-!!|ASTROM| 'USED': 1, 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| 'bd02770667e8d53269bdac76e22cf8764c20b8ba841d071ed149466801674c3c'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| '15_PEG', 'ORIGINAL_NAME': 'PLX 5288', 'ALIASES': ' 15 Peg|2MASS 03:17:04.021-!!|ASTROM| J21522991+2847367|AG+28 2571|BD+28 4215|GC 30625|GCRV 13741|GEN# +1.00207978|GJ 03:17:04.021-!!|ASTROM| 4234|GSC 02214-02037|Gaia DR2 1896396703077703936|H ... (564 characters 03:17:04.021-!!|ASTROM| truncated) ... 03:17:04.021-!!|ASTROM| -2037-1|UBVM25978|WEB19470|YPAC212|YZ2812966|uvby98100207978|(F)15Peg|15Peg|15Peg|15PEG|BD+284215|GJ4234|HR8354|ROT3183|SAO90065|UBVM25978|YZ2812966', 03:17:04.021-!!|ASTROM| 'RA_DEG': 328.1243627, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 28.79327671, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -59.0848435, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -61.64685766, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 36.86280491, 'PLX_SOURCE': 'Gaia DR2', 'RV': 18.921, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2018A&A...616A...7S', 'TEFF': 6452.0, 'TEFF_SOURCE': '2017AJ....153...21L', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'F2V', 'SP_SOURCE': '1995ApJS...99..135A', 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2022-01-31 18:24:19.330 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| 'afa8e427656815c7be99f255918be0bf8ff716da44ff9301ae779ffc91f66329'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| '16_CYG_A', 'ORIGINAL_NAME': ' 16 Cyg A', 'ALIASES': ' 16 Cyg A| 16 Cyg C| 03:17:04.021-!!|ASTROM| STF 4046A| TRN 4|2MASS J19414896+5031305|ADS 12815 A|AG+50 1407|AKARI-IRC-V1 03:17:04.021-!!|ASTROM| J1941488+503129|ASCC 271116|BD+50 2847 ... (1211 characters truncated) ... 03:17:04.021-!!|ASTROM| |*16CygC|TRN4|16CYGA|ASCC271116|BD+502847|GJ765.1A|HIC96895|HIP96895|HR7503|JP113128|PPM37671|ROT2839|SAO31898|SPOCS854|UBV16779|UBVM24079|YZ506149', 03:17:04.021-!!|ASTROM| 'RA_DEG': 295.4529704, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 50.52437636, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -148.299286, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -158.9610583, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 47.2771232, 'PLX_SOURCE': 'Gaia DR2', 'RV': -27.61, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2002ApJS..141..503N', 'TEFF': 5760.0, 'TEFF_SOURCE': '2021AJ....161..134H', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'G1.5Vb', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2022-01-31 18:24:21.499 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| '2d381d81f98c18409e2c76b3f0f765d3725c667cb91370308bcd9e46d10ce49d'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| '16_SGR', 'ORIGINAL_NAME': ' 16 Sgr', 'ALIASES': ' 16 Sgr| BU 286A| CHR 03:17:04.021-!!|ASTROM| 255|2MASS J18151297-2023167|ADS 11191 A|ALS 4819|ASCC 1595683|BD-20 5055|CCDM 03:17:04.021-!!|ASTROM| J18152-2023A|CGO 482|CPD-20 6919|CSI-2 ... (1207 characters truncated) ... 03:17:04.021-!!|ASTROM| BU286A|CHR255|16SGR|ALS4819|BD-205055|CPD-206919|CSI-2050551|HIC89440|HIP89440|HR6823|Hilt721|MCW632|ROT2574|UBV15500|UBVM22757|YZ1107574|[B10]4613', 03:17:04.021-!!|ASTROM| 'RA_DEG': 273.8040485, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -20.38797834, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 2.107182839, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.086838205, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 0.4805203893, 'PLX_SOURCE': 'Gaia DR2', 'RV': -11.0, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2004A&A...424..727P', 'TEFF': 31000.0, 'TEFF_SOURCE': 'HEADER[CFHT]', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'O9.5III', 'SP_SOURCE': '2014ApJS..211...10S', 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2022-01-31 18:24:23.604 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| 'd137e2e956fce675bac5f75c4a07933b068876f88d67bdc06169d430f1fd8952'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| '16SCO', 'ORIGINAL_NAME': '16Sco', 'ALIASES': ' 16 Sco|2MASS 03:17:04.021-!!|ASTROM| J16120731-0832512|BD-08 4180|GC 21784|GCRV 9313|GEN# +1.00145607|GSC 03:17:04.021-!!|ASTROM| 05612-01227|Gaia DR2 4348404390042854912|HD 145607|HIC 79387| ... (577 03:17:04.021-!!|ASTROM| characters truncated) ... 03:17:04.021-!!|ASTROM| V13773|UBVM21247|WEB13423|YZ985629|uvby98100145607|16Sco|16SCO|16Sco|BD-084180|GCRV9313|HIC79387|HIP79387|HR6033|ROT2296|UBV13773|UBVM21247|YZ985629', 03:17:04.021-!!|ASTROM| 'RA_DEG': 243.0306771, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -8.547581631, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 44.12551107, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -0.07825370467, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 12.64839489, 'PLX_SOURCE': 'Gaia DR2', 'RV': 5.0, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 8472.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'A2IV', 'SP_SOURCE': '1999MSS...C05....0H', 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2022-01-31 18:24:25.736 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| '6877df9a59c5a58247072161446517cc747587d61fe5169382378e7a9e4bc797'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| '17PEG', 'ORIGINAL_NAME': '17Peg', 'ALIASES': ' 17 Peg|2MASS 03:17:04.021-!!|ASTROM| J21565637+1204354|AG+11 2735|BD+11 4696|FK5 3751|GC 30719|GCRV 13788|GEN# 03:17:04.021-!!|ASTROM| +1.00208565|GSC 01130-01972|Gaia DR2 2728431923869085056|H ... (505 characters 03:17:04.021-!!|ASTROM| truncated) ... 03:17:04.021-!!|ASTROM| C60595351|TYC1130-1972-1|UBV18771|UBVM26010|WEB19513|YZ118738|uvby98100208565|17Peg|17PEG|17Peg|BD+114696|HR8373|ROT3192|UBV18771|UBVM26010|YZ118738', 03:17:04.021-!!|ASTROM| 'RA_DEG': 329.2347615, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 12.07643382, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -27.50976278, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -12.81550065, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 7.583223795, 'PLX_SOURCE': 'Gaia DR2', 'RV': 10.3, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 9247.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'A2Vnn', 'SP_SOURCE': None, 'NOTES': 'Added on 2022-01-31 03:17:04.021-!!|ASTROM| 18:24:27.860 by cook@cook using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': 03:17:04.021-!!|ASTROM| '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| '26655654dfc60c58b91769d4013cd35684c458adffcfbd8b52d528a86a71580e'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| '19_CEP', 'ORIGINAL_NAME': ' 19 Cep', 'ALIASES': ' 19 Cep| BU 697A| TRN 03:17:04.021-!!|ASTROM| 35A|1RXS J220508.8+621647|2MASS J22050878+6216473|ADS 15624 A|AG+62 1306|ALS 03:17:04.021-!!|ASTROM| 12117|BD+61 2246|CCDM J22051+6217A|CEL ... (1271 characters truncated) ... 03:17:04.021-!!|ASTROM| |uvby98100209975A|*19Cep|BU697A|TRN35A|19CEP|BD+612246|CEL5432|CSI+6122461|HR8428|JP113454|LSIII+627|PPM23444|ROT3218|SAO19849|UBV18896|UBVM26135', 03:17:04.021-!!|ASTROM| 'RA_DEG': 331.2866092, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 62.27980148, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.026573736, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.493237344, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.021-!!|ASTROM| 'PLX': 1.164795129, 'PLX_SOURCE': 'Gaia DR2', 'RV': -12.3, 'RV_SOURCE': 03:17:04.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 32000.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 03:17:04.021-!!|ASTROM| 'SP_TYPE': 'O9Ib', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2022-01-31 18:24:32.035 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| '8784e154f8c1f0953f0b377b0fa3fe0f3cb2bfa65cd9f66178a242560f4ddf57'} ... 03:17:04.021-!!|ASTROM| displaying 10 of 1449 total bound parameter sets ... {'OBJNAME': 03:17:04.021-!!|ASTROM| 'TIC_266958963', 'ORIGINAL_NAME': 'TIC 266958963', 'ALIASES': 'UCAC4 03:17:04.021-!!|ASTROM| 703-028597|2MASS J04073801+5035260|TIC 266958963|Gaia DR3 03:17:04.021-!!|ASTROM| 247667266200977664|UCAC4703-028597|2MASSJ04073801+5035260|TIC266958963|GaiaDR3247667266200977664', 03:17:04.021-!!|ASTROM| 'RA_DEG': 61.90848215, 'RA_SOURCE': '2020yCat.1350....0G', 'DEC_DEG': 03:17:04.021-!!|ASTROM| 50.59054789, 'DEC_SOURCE': '2020yCat.1350....0G', 'EPOCH': 2451545.0, 'PMRA': 03:17:04.021-!!|ASTROM| 2.889, 'PMRA_SOURCE': '2020yCat.1350....0G', 'PMDE': 0.276, 'PMDE_SOURCE': 03:17:04.021-!!|ASTROM| '2020yCat.1350....0G', 'PLX': 19.4795, 'PLX_SOURCE': '2020yCat.1350....0G', 03:17:04.021-!!|ASTROM| 'RV': None, 'RV_SOURCE': None, 'TEFF': 3223.0, 'TEFF_SOURCE': 'via 03:17:04.021-!!|ASTROM| spdrs@apikipiha', 'SP_TYPE': None, 'SP_SOURCE': None, 'NOTES': 'Added on 03:17:04.021-!!|ASTROM| 2024-09-25 08:06:00.551 by spdrs@apikipiha using drs_astrometrics.py', 'USED': 03:17:04.021-!!|ASTROM| 1, 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| '31167162de3bb3cbd60c417f11317a5f89bf8acd467a961257f35b967ad40215'}, {'OBJNAME': 03:17:04.021-!!|ASTROM| 'SVS_20_S', 'ORIGINAL_NAME': 'IRAS 18274+0112', 'ALIASES': '2MASS 03:17:04.021-!!|ASTROM| J18295773+0114056|AKARI-IRC-V1 J1829578+011406|CK 1|GCNM 98|GCNM 99|GEL 10|IRAS 03:17:04.021-!!|ASTROM| 18274+0112|SSTc2d J182957.7+011406|SSTc2d J182957.7+011405|S ... (933 characters 03:17:04.021-!!|ASTROM| truncated) ... 03:17:04.021-!!|ASTROM| D2916|[HMH2007]182|[K99d]1-21|[K99d]4-32|[KOB2004]314|[LFS2014]S12|[OMP2009]146|[P2003]J182957.7+011404|[SVS76]Ser20|[WMW2007]35|IRAS18274P0112|SVS20', 03:17:04.021-!!|ASTROM| 'RA_DEG': 277.49057, 'RA_SOURCE': '2003yCat.2246....0C', 'DEC_DEG': 1.234915, 03:17:04.021-!!|ASTROM| 'DEC_SOURCE': '2003yCat.2246....0C', 'EPOCH': 2451545.0, 'PMRA': None, 03:17:04.021-!!|ASTROM| 'PMRA_SOURCE': None, 'PMDE': None, 'PMDE_SOURCE': None, 'PLX': None, 03:17:04.021-!!|ASTROM| 'PLX_SOURCE': None, 'RV': None, 'RV_SOURCE': None, 'TEFF': 5900.0, 03:17:04.021-!!|ASTROM| 'TEFF_SOURCE': 'via spdrs@apikipiha', 'SP_TYPE': 'M4:', 'SP_SOURCE': 03:17:04.021-!!|ASTROM| '2009ApJ...691..672O', 'NOTES': 'Added on 2024-09-25 18:21:23.025 by 03:17:04.021-!!|ASTROM| spdrs@apikipiha using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': '2024-09-26 03:17:04.021-!!|ASTROM| 03:16:51.625', 'UHASH': 03:17:04.021-!!|ASTROM| 'a917159c414194c9245f0088f43d75097b4d91ffec30aafc7aaf3a087cc6fe20'}]] 03:17:04.028-!!|ASTROM| (Background on this error at: https://sqlalche.me/e/20/gkpj) 03:17:04.029-!!|ASTROM| path: <class 'sqlalchemy.exc.IntegrityError'> 03:17:04.029-!!|ASTROM| Table name: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate 03:17:04.029-!!|ASTROM| entry 'bd6f7bc8f4b07b5a9073fc8b7d51978e20dc209271262b8a72701f22c91e73e6' for key 03:17:04.029-!!|ASTROM| 'astrom_offline_db.UHASH' 03:17:04.029-!!|ASTROM| [SQL: INSERT INTO astrom_offline_db (OBJNAME, ORIGINAL_NAME, ALIASES, 03:17:04.029-!!|ASTROM| RA_DEG, RA_SOURCE, DEC_DEG, DEC_SOURCE, EPOCH, PMRA, PMRA_SOURCE, 03:17:04.029-!!|ASTROM| PMDE, PMDE_SOURCE, PLX, PLX_SOURCE, RV, RV_SOURCE, TEFF, 03:17:04.029-!!|ASTROM| TEFF_SOURCE, SP_TYPE, SP_SOURCE, NOTES, USED, DATE_ADDED, UHASH) 03:17:04.029-!!|ASTROM| VALUES (%(OBJNAME)s, %(ORIGINAL_NAME)s, %(ALIASES)s, %(RA_DEG)s, %(RA_SOURCE)s, 03:17:04.029-!!|ASTROM| %(DEC_DEG)s, %(DEC_SOURCE)s, %(EPOCH)s, %(PMRA)s, %(PMRA_SOURCE)s, %(PMDE)s, 03:17:04.029-!!|ASTROM| %(PMDE_SOURCE)s, %(PLX)s, %(PLX_SOURCE)s, %(RV)s, %(RV_SOURCE)s, %(TEFF)s, 03:17:04.029-!!|ASTROM| %(TEFF_SOURCE)s, %(SP_TYPE)s, %(SP_SOURCE)s, %(NOTES)s, %(USED)s, 03:17:04.029-!!|ASTROM| %(DATE_ADDED)s, %(UHASH)s)] 03:17:04.030-!!|ASTROM| [parameters: [{'OBJNAME': '10_LAC', 'ORIGINAL_NAME': ' 10 Lac', 'ALIASES': ' 03:17:04.030-!!|ASTROM| 10 Lac| S 813A| TRN 36|1RXS J223916.4+390252|2MASS J22391567+3903011|ADS 03:17:04.030-!!|ASTROM| 16148 A|AG+38 2350|ALS 14844|BD+38 4826|CCDM J22393+3903A|CEL 5 ... (1090 03:17:04.030-!!|ASTROM| characters truncated) ... 03:17:04.030-!!|ASTROM| 5|10Lac|S813A|TRN36|10LAC|BD+384826|CEL5504|CSI+3848262|FK5852|HGAM1078|HR8622|JP113513|PMC90-93599|PPM88031|ROT3301|SAO72575|UBV19389|UBVM26533', 03:17:04.030-!!|ASTROM| 'RA_DEG': 339.8153184, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 39.05024586, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.436831092, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -4.802891782, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 2.787612618, 'PLX_SOURCE': 'Gaia DR2', 'RV': -10.1, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 35200.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'O9V', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2022-01-31 18:24:17.089 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.030-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| 'fe642c035622dbe3482b908f19fc37ffda174b0e534d71ac56febbaf26b137f9'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| '11COM', 'ORIGINAL_NAME': '11Com', 'ALIASES': ' 11 Com| HO 52A|ADS 8521 03:17:04.030-!!|ASTROM| A|AG+18 1179|BD+18 2592|CCDM J12207+1748A|CSI+18 2592 1|FK5 2987|GC 16835|GCRV 03:17:04.030-!!|ASTROM| 7404|GEN# +1.00107383|GSC 01445-02 ... (641 characters truncated) ... 03:17:04.030-!!|ASTROM| D116214|TIC72437047|TYC1445-2560-1|UBV11083|UBVM18084|WDSJ12207+1748A|WEB10703|YPAC260|YZ184649|GaiaDR33946945413106333696|GaiaDR23946945413106333696', 03:17:04.030-!!|ASTROM| 'RA_DEG': 185.1787793, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 17.79325164, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -109.2413803, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': 88.17010164, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 10.71044534, 'PLX_SOURCE': 'Gaia DR2', 'RV': 43.37, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2018yCat.1345....0G', 'TEFF': 4741.0, 'TEFF_SOURCE': '2016A&A...585A...5B', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'G8+IIIFe-1', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2023-08-18 15:47:26.028 by nirps-client@maestria using drs_astrometrics.py', 03:17:04.030-!!|ASTROM| 'USED': 1, 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| 'bd02770667e8d53269bdac76e22cf8764c20b8ba841d071ed149466801674c3c'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| '15_PEG', 'ORIGINAL_NAME': 'PLX 5288', 'ALIASES': ' 15 Peg|2MASS 03:17:04.030-!!|ASTROM| J21522991+2847367|AG+28 2571|BD+28 4215|GC 30625|GCRV 13741|GEN# +1.00207978|GJ 03:17:04.030-!!|ASTROM| 4234|GSC 02214-02037|Gaia DR2 1896396703077703936|H ... (564 characters 03:17:04.030-!!|ASTROM| truncated) ... 03:17:04.030-!!|ASTROM| -2037-1|UBVM25978|WEB19470|YPAC212|YZ2812966|uvby98100207978|(F)15Peg|15Peg|15Peg|15PEG|BD+284215|GJ4234|HR8354|ROT3183|SAO90065|UBVM25978|YZ2812966', 03:17:04.030-!!|ASTROM| 'RA_DEG': 328.1243627, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 28.79327671, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -59.0848435, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -61.64685766, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 36.86280491, 'PLX_SOURCE': 'Gaia DR2', 'RV': 18.921, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2018A&A...616A...7S', 'TEFF': 6452.0, 'TEFF_SOURCE': '2017AJ....153...21L', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'F2V', 'SP_SOURCE': '1995ApJS...99..135A', 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2022-01-31 18:24:19.330 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.030-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| 'afa8e427656815c7be99f255918be0bf8ff716da44ff9301ae779ffc91f66329'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| '16_CYG_A', 'ORIGINAL_NAME': ' 16 Cyg A', 'ALIASES': ' 16 Cyg A| 16 Cyg C| 03:17:04.030-!!|ASTROM| STF 4046A| TRN 4|2MASS J19414896+5031305|ADS 12815 A|AG+50 1407|AKARI-IRC-V1 03:17:04.030-!!|ASTROM| J1941488+503129|ASCC 271116|BD+50 2847 ... (1211 characters truncated) ... 03:17:04.030-!!|ASTROM| |16CygC|TRN4|16CYGA|ASCC271116|BD+502847|GJ765.1A|HIC96895|HIP96895|HR7503|JP113128|PPM37671|ROT2839|SAO31898|SPOCS854|UBV16779|UBVM24079|YZ506149', 03:17:04.030-!!|ASTROM| 'RA_DEG': 295.4529704, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 50.52437636, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -148.299286, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -158.9610583, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 47.2771232, 'PLX_SOURCE': 'Gaia DR2', 'RV': -27.61, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2002ApJS..141..503N', 'TEFF': 5760.0, 'TEFF_SOURCE': '2021AJ....161..134H', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'G1.5Vb', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2022-01-31 18:24:21.499 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.030-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| '2d381d81f98c18409e2c76b3f0f765d3725c667cb91370308bcd9e46d10ce49d'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| '16_SGR', 'ORIGINAL_NAME': ' 16 Sgr', 'ALIASES': ' 16 Sgr| BU 286A| CHR 03:17:04.030-!!|ASTROM| 255|2MASS J18151297-2023167|ADS 11191 A|ALS 4819|ASCC 1595683|BD-20 5055|CCDM 03:17:04.030-!!|ASTROM| J18152-2023A|CGO 482|CPD-20 6919|CSI-2 ... (1207 characters truncated) ... 03:17:04.030-!!|ASTROM| BU286A|CHR255|16SGR|ALS4819|BD-205055|CPD-206919|CSI-2050551|HIC89440|HIP89440|HR6823|Hilt721|MCW632|ROT2574|UBV15500|UBVM22757|YZ1107574|[B10]4613', 03:17:04.030-!!|ASTROM| 'RA_DEG': 273.8040485, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -20.38797834, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 2.107182839, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.086838205, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 0.4805203893, 'PLX_SOURCE': 'Gaia DR2', 'RV': -11.0, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2004A&A...424..727P', 'TEFF': 31000.0, 'TEFF_SOURCE': 'HEADER[CFHT]', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'O9.5III', 'SP_SOURCE': '2014ApJS..211...10S', 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2022-01-31 18:24:23.604 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.030-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| 'd137e2e956fce675bac5f75c4a07933b068876f88d67bdc06169d430f1fd8952'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| '16SCO', 'ORIGINAL_NAME': '16Sco', 'ALIASES': ' 16 Sco|2MASS 03:17:04.030-!!|ASTROM| J16120731-0832512|BD-08 4180|GC 21784|GCRV 9313|GEN# +1.00145607|GSC 03:17:04.030-!!|ASTROM| 05612-01227|Gaia DR2 4348404390042854912|HD 145607|HIC 79387| ... (577 03:17:04.030-!!|ASTROM| characters truncated) ... 03:17:04.030-!!|ASTROM| V13773|UBVM21247|WEB13423|YZ985629|uvby98100145607|16Sco|16SCO|16Sco|BD-084180|GCRV9313|HIC79387|HIP79387|HR6033|ROT2296|UBV13773|UBVM21247|YZ985629', 03:17:04.030-!!|ASTROM| 'RA_DEG': 243.0306771, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -8.547581631, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 44.12551107, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -0.07825370467, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 12.64839489, 'PLX_SOURCE': 'Gaia DR2', 'RV': 5.0, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 8472.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'A2IV', 'SP_SOURCE': '1999MSS...C05....0H', 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2022-01-31 18:24:25.736 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.030-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| '6877df9a59c5a58247072161446517cc747587d61fe5169382378e7a9e4bc797'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| '17PEG', 'ORIGINAL_NAME': '17Peg', 'ALIASES': ' 17 Peg|2MASS 03:17:04.030-!!|ASTROM| J21565637+1204354|AG+11 2735|BD+11 4696|FK5 3751|GC 30719|GCRV 13788|GEN# 03:17:04.030-!!|ASTROM| +1.00208565|GSC 01130-01972|Gaia DR2 2728431923869085056|H ... (505 characters 03:17:04.030-!!|ASTROM| truncated) ... 03:17:04.030-!!|ASTROM| C60595351|TYC1130-1972-1|UBV18771|UBVM26010|WEB19513|YZ118738|uvby98100208565|17Peg|17PEG|17Peg|BD+114696|HR8373|ROT3192|UBV18771|UBVM26010|YZ118738', 03:17:04.030-!!|ASTROM| 'RA_DEG': 329.2347615, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 12.07643382, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -27.50976278, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -12.81550065, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 7.583223795, 'PLX_SOURCE': 'Gaia DR2', 'RV': 10.3, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 9247.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'A2Vnn', 'SP_SOURCE': None, 'NOTES': 'Added on 2022-01-31 03:17:04.030-!!|ASTROM| 18:24:27.860 by cook@cook using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': 03:17:04.030-!!|ASTROM| '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| '26655654dfc60c58b91769d4013cd35684c458adffcfbd8b52d528a86a71580e'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| '19_CEP', 'ORIGINAL_NAME': ' 19 Cep', 'ALIASES': ' 19 Cep| BU 697A| TRN 03:17:04.030-!!|ASTROM| 35A|1RXS J220508.8+621647|2MASS J22050878+6216473|ADS 15624 A|AG+62 1306|ALS 03:17:04.030-!!|ASTROM| 12117|BD+61 2246|CCDM J22051+6217A|CEL ... (1271 characters truncated) ... 03:17:04.030-!!|ASTROM| |uvby98100209975A|*19Cep|BU697A|TRN35A|19CEP|BD+612246|CEL5432|CSI+6122461|HR8428|JP113454|LSIII+627|PPM23444|ROT3218|SAO19849|UBV18896|UBVM26135', 03:17:04.030-!!|ASTROM| 'RA_DEG': 331.2866092, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 62.27980148, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.026573736, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.493237344, 'PMDE_SOURCE': 'Gaia DR2', 03:17:04.030-!!|ASTROM| 'PLX': 1.164795129, 'PLX_SOURCE': 'Gaia DR2', 'RV': -12.3, 'RV_SOURCE': 03:17:04.030-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 32000.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 03:17:04.030-!!|ASTROM| 'SP_TYPE': 'O9Ib', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2022-01-31 18:24:32.035 by cook@cook using drs_astrometrics.py', 'USED': 1, 03:17:04.030-!!|ASTROM| 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| '8784e154f8c1f0953f0b377b0fa3fe0f3cb2bfa65cd9f66178a242560f4ddf57'} ... 03:17:04.030-!!|ASTROM| displaying 10 of 1449 total bound parameter sets ... {'OBJNAME': 03:17:04.030-!!|ASTROM| 'TIC_266958963', 'ORIGINAL_NAME': 'TIC 266958963', 'ALIASES': 'UCAC4 03:17:04.030-!!|ASTROM| 703-028597|2MASS J04073801+5035260|TIC 266958963|Gaia DR3 03:17:04.030-!!|ASTROM| 247667266200977664|UCAC4703-028597|2MASSJ04073801+5035260|TIC266958963|GaiaDR3247667266200977664', 03:17:04.030-!!|ASTROM| 'RA_DEG': 61.90848215, 'RA_SOURCE': '2020yCat.1350....0G', 'DEC_DEG': 03:17:04.030-!!|ASTROM| 50.59054789, 'DEC_SOURCE': '2020yCat.1350....0G', 'EPOCH': 2451545.0, 'PMRA': 03:17:04.030-!!|ASTROM| 2.889, 'PMRA_SOURCE': '2020yCat.1350....0G', 'PMDE': 0.276, 'PMDE_SOURCE': 03:17:04.030-!!|ASTROM| '2020yCat.1350....0G', 'PLX': 19.4795, 'PLX_SOURCE': '2020yCat.1350....0G', 03:17:04.030-!!|ASTROM| 'RV': None, 'RV_SOURCE': None, 'TEFF': 3223.0, 'TEFF_SOURCE': 'via 03:17:04.030-!!|ASTROM| spdrs@apikipiha', 'SP_TYPE': None, 'SP_SOURCE': None, 'NOTES': 'Added on 03:17:04.030-!!|ASTROM| 2024-09-25 08:06:00.551 by spdrs@apikipiha using drs_astrometrics.py', 'USED': 03:17:04.030-!!|ASTROM| 1, 'DATE_ADDED': '2024-09-26 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| '31167162de3bb3cbd60c417f11317a5f89bf8acd467a961257f35b967ad40215'}, {'OBJNAME': 03:17:04.030-!!|ASTROM| 'SVS_20_S', 'ORIGINAL_NAME': 'IRAS 18274+0112', 'ALIASES': '2MASS 03:17:04.030-!!|ASTROM| J18295773+0114056|AKARI-IRC-V1 J1829578+011406|CK 1|GCNM 98|GCNM 99|GEL 10|IRAS 03:17:04.030-!!|ASTROM| 18274+0112|SSTc2d J182957.7+011406|SSTc2d J182957.7+011405|S ... (933 characters 03:17:04.030-!!|ASTROM| truncated) ... 03:17:04.030-!!|ASTROM| D2916|[HMH2007]182|[K99d]1-21|[K99d]4-32|[KOB2004]314|[LFS2014]S12|[OMP2009]146|[P2003]J182957.7+011404|[SVS76]Ser20|[WMW2007]35|IRAS18274P0112|SVS20', 03:17:04.030-!!|ASTROM| 'RA_DEG': 277.49057, 'RA_SOURCE': '2003yCat.2246....0C', 'DEC_DEG': 1.234915, 03:17:04.030-!!|ASTROM| 'DEC_SOURCE': '2003yCat.2246....0C', 'EPOCH': 2451545.0, 'PMRA': None, 03:17:04.030-!!|ASTROM| 'PMRA_SOURCE': None, 'PMDE': None, 'PMDE_SOURCE': None, 'PLX': None, 03:17:04.030-!!|ASTROM| 'PLX_SOURCE': None, 'RV': None, 'RV_SOURCE': None, 'TEFF': 5900.0, 03:17:04.030-!!|ASTROM| 'TEFF_SOURCE': 'via spdrs@apikipiha', 'SP_TYPE': 'M4:', 'SP_SOURCE': 03:17:04.030-!!|ASTROM| '2009ApJ...691..672O', 'NOTES': 'Added on 2024-09-25 18:21:23.025 by 03:17:04.030-!!|ASTROM| spdrs@apikipiha using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': '2024-09-26 03:17:04.030-!!|ASTROM| 03:16:51.625', 'UHASH': 03:17:04.030-!!|ASTROM| 'a917159c414194c9245f0088f43d75097b4d91ffec30aafc7aaf3a087cc6fe20'}]] 03:17:04.036-!!|ASTROM| (Background on this error at: https://sqlalche.me/e/20/gkpj) 03:17:04.037-!!|ASTROM| Function: apero.base.drs_db.py.Database.add_from_pandas() 03:17:04.272-|ASTROM| 03:17:04.283-@!|ASTROM| W[40-003-00005]: Recipe apero_astrometrics has NOT been successfully completed 03:17:04.294-|ASTROM|

[larnoldgithub]

and this is with Gl699

apero_astrometrics.py 'Gl699' 19:48:48.480- |ASTROM| 19:48:48.486- |ASTROM| 19:48:48.487- |ASTROM| SPIROU @PID-00017273801278701430-J64W (V0.7.288) 19:48:48.487- |ASTROM| py3.9.16 git:v0.7.288-stable-test 19:48:48.487- |ASTROM| 19:48:48.493- |ASTROM| 19:48:48.498- |ASTROM| █████╗ ██████╗ ███████╗██████╗ ██████╗
19:48:48.504- |ASTROM| ██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔═══██╗ 19:48:48.510- |ASTROM| ███████║██████╔╝█████╗ ██████╔╝██║ ██║ 19:48:48.515- |ASTROM| ██╔══██║██╔═══╝ ██╔══╝ ██╔══██╗██║ ██║ 19:48:48.521- |ASTROM| ██║ ██║██║ ███████╗██║ ██║╚██████╔╝ 19:48:48.527- |ASTROM| ╚═╝ ╚═╝╚═╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝
19:48:48.532- |ASTROM| * 19:48:48.541-|ASTROM| DRS Setup: 19:48:48.546-|ASTROM| 19:48:48.547-|ASTROM| DRS_ROOT: /apero/apero-drs/apero 19:48:48.547-|ASTROM| DRS_DATA_RAW: /data/spirou4/arlinks 19:48:48.547-|ASTROM| DRS_DATA_REDUC: /data/spirou4/apero-data/offline/red 19:48:48.547-|ASTROM| DRS_DATA_WORKING: /data/spirou4/apero-data/offline/tmp 19:48:48.547-|ASTROM| DRS_CALIB_DB: /data/spirou4/apero-data/offline/calib 19:48:48.548-|ASTROM| DRS_TELLU_DB: /data/spirou4/apero-data/offline/tellu 19:48:48.548-|ASTROM| DRS_DATA_ASSETS: /data/spirou4/apero-data/offline/asset 19:48:48.548-|ASTROM| DRS_DATA_MSG: /data/spirou4/apero-data/offline/msg 19:48:48.548-|ASTROM| DRS_DATA_RUN: /data/spirou4/apero-data/offline/run 19:48:48.548-|ASTROM| DRS_DATA_PLOT: /data/spirou4/apero-data/offline/plot 19:48:48.548-|ASTROM| DRS_CONFIG: /apero/config/offline/user_config.ini 19:48:48.549-|ASTROM| DRS_CONFIG: /apero/config/offline/user_constants.ini 19:48:48.549-|ASTROM| DRS_CONFIG: apero.constants.default.default_config 19:48:48.549-|ASTROM| DRS_CONFIG: apero.constants.default.default_keywords 19:48:48.549-|ASTROM| DRS_CONFIG: config.instruments.spirou.default_config.py 19:48:48.549-|ASTROM| DRS_CONFIG: config.instruments.spirou.default_keywords.py 19:48:48.549-|ASTROM| DRS_CONFIG: core.instruments.default.default_constants.py 19:48:48.549-|ASTROM| DRS_CONFIG: core.instruments.spirou.default_constants.py 19:48:48.550-|ASTROM| DATABASE: MYSQL 19:48:48.550-|ASTROM| DATABASE-calib: aperooffline@localhost:calib_offline_db 19:48:48.550-|ASTROM| DATABASE-tellu: aperooffline@localhost:tellu_offline_db 19:48:48.550-|ASTROM| DATABASE-findex: aperooffline@localhost:findex_offline_db 19:48:48.550-|ASTROM| DATABASE-log: aperooffline@localhost:log_offline_db 19:48:48.550-|ASTROM| DATABASE-astrom: aperooffline@localhost:astrom_offline_db 19:48:48.551-|ASTROM| DATABASE-lang: aperooffline@localhost:lang_offline_db 19:48:48.551-|ASTROM| DATABASE-reject: aperooffline@localhost:reject_offline_db 19:48:48.551-|ASTROM| PRINT_LEVEL: all 19:48:48.551-|ASTROM| LOG_LEVEL: all 19:48:48.551-*|ASTROM| DRS_PLOT: 0 19:48:48.557- |ASTROM| 19:48:48.563-|ASTROM| Arguments used: 19:48:48.568-|ASTROM| 19:48:48.569-|ASTROM| --OBJECTS: Gl699 19:48:48.574- |ASTROM| *** 19:48:50.291- |ASTROM| Updating object database (from google sheets) 19:48:59.019-!!|ASTROM| 19:48:59.013-|DatabaseError|E[00-002-00047] Pandas.to_sql <class 19:48:59.019-!!|ASTROM| 'sqlalchemy.exc.IntegrityError'>: (mysql.connector.errors.IntegrityError) 1062 19:48:59.019-!!|ASTROM| (23000): Duplicate entry 19:48:59.019-!!|ASTROM| 'bd6f7bc8f4b07b5a9073fc8b7d51978e20dc209271262b8a72701f22c91e73e6' for key 19:48:59.019-!!|ASTROM| 'astrom_offline_db.UHASH' 19:48:59.020-!!|ASTROM| [SQL: INSERT INTO astrom_offline_db (OBJNAME, ORIGINAL_NAME, ALIASES, 19:48:59.020-!!|ASTROM| RA_DEG, RA_SOURCE, DEC_DEG, DEC_SOURCE, EPOCH, PMRA, PMRA_SOURCE, 19:48:59.020-!!|ASTROM| PMDE, PMDE_SOURCE, PLX, PLX_SOURCE, RV, RV_SOURCE, TEFF, 19:48:59.020-!!|ASTROM| TEFF_SOURCE, SP_TYPE, SP_SOURCE, NOTES, USED, DATE_ADDED, UHASH) 19:48:59.020-!!|ASTROM| VALUES (%(OBJNAME)s, %(ORIGINAL_NAME)s, %(ALIASES)s, %(RA_DEG)s, %(RA_SOURCE)s, 19:48:59.020-!!|ASTROM| %(DEC_DEG)s, %(DEC_SOURCE)s, %(EPOCH)s, %(PMRA)s, %(PMRA_SOURCE)s, %(PMDE)s, 19:48:59.020-!!|ASTROM| %(PMDE_SOURCE)s, %(PLX)s, %(PLX_SOURCE)s, %(RV)s, %(RV_SOURCE)s, %(TEFF)s, 19:48:59.020-!!|ASTROM| %(TEFF_SOURCE)s, %(SP_TYPE)s, %(SP_SOURCE)s, %(NOTES)s, %(USED)s, 19:48:59.020-!!|ASTROM| %(DATE_ADDED)s, %(UHASH)s)] 19:48:59.021-!!|ASTROM| [parameters: [{'OBJNAME': '10_LAC', 'ORIGINAL_NAME': ' 10 Lac', 'ALIASES': ' 19:48:59.021-!!|ASTROM| 10 Lac| S 813A|* TRN 36|1RXS J223916.4+390252|2MASS J22391567+3903011|ADS 19:48:59.021-!!|ASTROM| 16148 A|AG+38 2350|ALS 14844|BD+38 4826|CCDM J22393+3903A|CEL 5 ... (1090 19:48:59.021-!!|ASTROM| characters truncated) ... 19:48:59.021-!!|ASTROM| 5|10Lac|S813A|TRN36|10LAC|BD+384826|CEL5504|CSI+3848262|FK5852|HGAM1078|HR8622|JP113513|PMC90-93599|PPM88031|ROT3301|SAO72575|UBV19389|UBVM26533', 19:48:59.021-!!|ASTROM| 'RA_DEG': 339.8153184, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 39.05024586, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.436831092, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -4.802891782, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 2.787612618, 'PLX_SOURCE': 'Gaia DR2', 'RV': -10.1, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 35200.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'O9V', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2022-01-31 18:24:17.089 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| 'fe642c035622dbe3482b908f19fc37ffda174b0e534d71ac56febbaf26b137f9'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| '11COM', 'ORIGINAL_NAME': '11Com', 'ALIASES': '* 11 Com|* HO 52A|ADS 8521 19:48:59.021-!!|ASTROM| A|AG+18 1179|BD+18 2592|CCDM J12207+1748A|CSI+18 2592 1|FK5 2987|GC 16835|GCRV 19:48:59.021-!!|ASTROM| 7404|GEN# +1.00107383|GSC 01445-02 ... (641 characters truncated) ... 19:48:59.021-!!|ASTROM| D116214|TIC72437047|TYC1445-2560-1|UBV11083|UBVM18084|WDSJ12207+1748A|WEB10703|YPAC260|YZ184649|GaiaDR33946945413106333696|GaiaDR23946945413106333696', 19:48:59.021-!!|ASTROM| 'RA_DEG': 185.1787793, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 17.79325164, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -109.2413803, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': 88.17010164, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 10.71044534, 'PLX_SOURCE': 'Gaia DR2', 'RV': 43.37, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2018yCat.1345....0G', 'TEFF': 4741.0, 'TEFF_SOURCE': '2016A&A...585A...5B', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'G8+IIIFe-1', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2023-08-18 15:47:26.028 by nirps-client@maestria using drs_astrometrics.py', 19:48:59.021-!!|ASTROM| 'USED': 1, 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| 'bd02770667e8d53269bdac76e22cf8764c20b8ba841d071ed149466801674c3c'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| '15_PEG', 'ORIGINAL_NAME': 'PLX 5288', 'ALIASES': ' 15 Peg|2MASS 19:48:59.021-!!|ASTROM| J21522991+2847367|AG+28 2571|BD+28 4215|GC 30625|GCRV 13741|GEN# +1.00207978|GJ 19:48:59.021-!!|ASTROM| 4234|GSC 02214-02037|Gaia DR2 1896396703077703936|H ... (564 characters 19:48:59.021-!!|ASTROM| truncated) ... 19:48:59.021-!!|ASTROM| -2037-1|UBVM25978|WEB19470|YPAC212|YZ2812966|uvby98100207978|(F)15Peg|15Peg|15Peg|15PEG|BD+284215|GJ4234|HR8354|ROT3183|SAO90065|UBVM25978|YZ2812966', 19:48:59.021-!!|ASTROM| 'RA_DEG': 328.1243627, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 28.79327671, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -59.0848435, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -61.64685766, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 36.86280491, 'PLX_SOURCE': 'Gaia DR2', 'RV': 18.921, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2018A&A...616A...7S', 'TEFF': 6452.0, 'TEFF_SOURCE': '2017AJ....153...21L', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'F2V', 'SP_SOURCE': '1995ApJS...99..135A', 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2022-01-31 18:24:19.330 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| 'afa8e427656815c7be99f255918be0bf8ff716da44ff9301ae779ffc91f66329'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| '16_CYG_A', 'ORIGINAL_NAME': ' 16 Cyg A', 'ALIASES': ' 16 Cyg A| 16 Cyg C| 19:48:59.021-!!|ASTROM| STF 4046A| TRN 4|2MASS J19414896+5031305|ADS 12815 A|AG+50 1407|AKARI-IRC-V1 19:48:59.021-!!|ASTROM| J1941488+503129|ASCC 271116|BD+50 2847 ... (1211 characters truncated) ... 19:48:59.021-!!|ASTROM| |*16CygC|TRN4|16CYGA|ASCC271116|BD+502847|GJ765.1A|HIC96895|HIP96895|HR7503|JP113128|PPM37671|ROT2839|SAO31898|SPOCS854|UBV16779|UBVM24079|YZ506149', 19:48:59.021-!!|ASTROM| 'RA_DEG': 295.4529704, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 50.52437636, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -148.299286, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -158.9610583, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 47.2771232, 'PLX_SOURCE': 'Gaia DR2', 'RV': -27.61, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2002ApJS..141..503N', 'TEFF': 5760.0, 'TEFF_SOURCE': '2021AJ....161..134H', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'G1.5Vb', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2022-01-31 18:24:21.499 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| '2d381d81f98c18409e2c76b3f0f765d3725c667cb91370308bcd9e46d10ce49d'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| '16_SGR', 'ORIGINAL_NAME': ' 16 Sgr', 'ALIASES': ' 16 Sgr| BU 286A| CHR 19:48:59.021-!!|ASTROM| 255|2MASS J18151297-2023167|ADS 11191 A|ALS 4819|ASCC 1595683|BD-20 5055|CCDM 19:48:59.021-!!|ASTROM| J18152-2023A|CGO 482|CPD-20 6919|CSI-2 ... (1207 characters truncated) ... 19:48:59.021-!!|ASTROM| BU286A|CHR255|16SGR|ALS4819|BD-205055|CPD-206919|CSI-2050551|HIC89440|HIP89440|HR6823|Hilt721|MCW632|ROT2574|UBV15500|UBVM22757|YZ1107574|[B10]4613', 19:48:59.021-!!|ASTROM| 'RA_DEG': 273.8040485, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -20.38797834, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 2.107182839, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.086838205, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 0.4805203893, 'PLX_SOURCE': 'Gaia DR2', 'RV': -11.0, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2004A&A...424..727P', 'TEFF': 31000.0, 'TEFF_SOURCE': 'HEADER[CFHT]', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'O9.5III', 'SP_SOURCE': '2014ApJS..211...10S', 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2022-01-31 18:24:23.604 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| 'd137e2e956fce675bac5f75c4a07933b068876f88d67bdc06169d430f1fd8952'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| '16SCO', 'ORIGINAL_NAME': '16Sco', 'ALIASES': ' 16 Sco|2MASS 19:48:59.021-!!|ASTROM| J16120731-0832512|BD-08 4180|GC 21784|GCRV 9313|GEN# +1.00145607|GSC 19:48:59.021-!!|ASTROM| 05612-01227|Gaia DR2 4348404390042854912|HD 145607|HIC 79387| ... (577 19:48:59.021-!!|ASTROM| characters truncated) ... 19:48:59.021-!!|ASTROM| V13773|UBVM21247|WEB13423|YZ985629|uvby98100145607|16Sco|16SCO|16Sco|BD-084180|GCRV9313|HIC79387|HIP79387|HR6033|ROT2296|UBV13773|UBVM21247|YZ985629', 19:48:59.021-!!|ASTROM| 'RA_DEG': 243.0306771, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -8.547581631, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 44.12551107, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -0.07825370467, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 12.64839489, 'PLX_SOURCE': 'Gaia DR2', 'RV': 5.0, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 8472.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'A2IV', 'SP_SOURCE': '1999MSS...C05....0H', 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2022-01-31 18:24:25.736 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| '6877df9a59c5a58247072161446517cc747587d61fe5169382378e7a9e4bc797'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| '17PEG', 'ORIGINAL_NAME': '17Peg', 'ALIASES': ' 17 Peg|2MASS 19:48:59.021-!!|ASTROM| J21565637+1204354|AG+11 2735|BD+11 4696|FK5 3751|GC 30719|GCRV 13788|GEN# 19:48:59.021-!!|ASTROM| +1.00208565|GSC 01130-01972|Gaia DR2 2728431923869085056|H ... (505 characters 19:48:59.021-!!|ASTROM| truncated) ... 19:48:59.021-!!|ASTROM| C60595351|TYC1130-1972-1|UBV18771|UBVM26010|WEB19513|YZ118738|uvby98100208565|17Peg|17PEG|17Peg|BD+114696|HR8373|ROT3192|UBV18771|UBVM26010|YZ118738', 19:48:59.021-!!|ASTROM| 'RA_DEG': 329.2347615, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 12.07643382, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -27.50976278, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -12.81550065, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 7.583223795, 'PLX_SOURCE': 'Gaia DR2', 'RV': 10.3, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 9247.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'A2Vnn', 'SP_SOURCE': None, 'NOTES': 'Added on 2022-01-31 19:48:59.021-!!|ASTROM| 18:24:27.860 by cook@cook using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': 19:48:59.021-!!|ASTROM| '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| '26655654dfc60c58b91769d4013cd35684c458adffcfbd8b52d528a86a71580e'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| '19_CEP', 'ORIGINAL_NAME': ' 19 Cep', 'ALIASES': ' 19 Cep| BU 697A| TRN 19:48:59.021-!!|ASTROM| 35A|1RXS J220508.8+621647|2MASS J22050878+6216473|ADS 15624 A|AG+62 1306|ALS 19:48:59.021-!!|ASTROM| 12117|BD+61 2246|CCDM J22051+6217A|CEL ... (1271 characters truncated) ... 19:48:59.021-!!|ASTROM| |uvby98100209975A|*19Cep|BU697A|TRN35A|19CEP|BD+612246|CEL5432|CSI+6122461|HR8428|JP113454|LSIII+627|PPM23444|ROT3218|SAO19849|UBV18896|UBVM26135', 19:48:59.021-!!|ASTROM| 'RA_DEG': 331.2866092, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 62.27980148, 19:48:59.021-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.026573736, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.493237344, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.021-!!|ASTROM| 'PLX': 1.164795129, 'PLX_SOURCE': 'Gaia DR2', 'RV': -12.3, 'RV_SOURCE': 19:48:59.021-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 32000.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:48:59.021-!!|ASTROM| 'SP_TYPE': 'O9Ib', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2022-01-31 18:24:32.035 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.021-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| '8784e154f8c1f0953f0b377b0fa3fe0f3cb2bfa65cd9f66178a242560f4ddf57'} ... 19:48:59.021-!!|ASTROM| displaying 10 of 1448 total bound parameter sets ... {'OBJNAME': 19:48:59.021-!!|ASTROM| 'TIC_266958963', 'ORIGINAL_NAME': 'TIC 266958963', 'ALIASES': 'UCAC4 19:48:59.021-!!|ASTROM| 703-028597|2MASS J04073801+5035260|TIC 266958963|Gaia DR3 19:48:59.021-!!|ASTROM| 247667266200977664|UCAC4703-028597|2MASSJ04073801+5035260|TIC266958963|GaiaDR3247667266200977664', 19:48:59.021-!!|ASTROM| 'RA_DEG': 61.90848215, 'RA_SOURCE': '2020yCat.1350....0G', 'DEC_DEG': 19:48:59.021-!!|ASTROM| 50.59054789, 'DEC_SOURCE': '2020yCat.1350....0G', 'EPOCH': 2451545.0, 'PMRA': 19:48:59.021-!!|ASTROM| 2.889, 'PMRA_SOURCE': '2020yCat.1350....0G', 'PMDE': 0.276, 'PMDE_SOURCE': 19:48:59.021-!!|ASTROM| '2020yCat.1350....0G', 'PLX': 19.4795, 'PLX_SOURCE': '2020yCat.1350....0G', 19:48:59.021-!!|ASTROM| 'RV': None, 'RV_SOURCE': None, 'TEFF': 3223.0, 'TEFF_SOURCE': 'via 19:48:59.021-!!|ASTROM| spdrs@apikipiha', 'SP_TYPE': None, 'SP_SOURCE': None, 'NOTES': 'Added on 19:48:59.021-!!|ASTROM| 2024-09-25 08:06:00.551 by spdrs@apikipiha using drs_astrometrics.py', 'USED': 19:48:59.021-!!|ASTROM| 1, 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| '31167162de3bb3cbd60c417f11317a5f89bf8acd467a961257f35b967ad40215'}, {'OBJNAME': 19:48:59.021-!!|ASTROM| 'SVS_20_S', 'ORIGINAL_NAME': 'IRAS 18274+0112', 'ALIASES': '2MASS 19:48:59.021-!!|ASTROM| J18295773+0114056|AKARI-IRC-V1 J1829578+011406|CK 1|GCNM 98|GCNM 99|GEL 10|IRAS 19:48:59.021-!!|ASTROM| 18274+0112|SSTc2d J182957.7+011406|SSTc2d J182957.7+011405|S ... (940 characters 19:48:59.021-!!|ASTROM| truncated) ... 19:48:59.021-!!|ASTROM| HMH2007]182|[K99d]1-21|[K99d]4-32|[KOB2004]314|[LFS2014]S12|[OMP2009]146|[P2003]J182957.7+011404|[SVS76]Ser20|[WMW2007]35|IRAS18274P0112|SVS20|SVS 19:48:59.021-!!|ASTROM| 20', 'RA_DEG': 277.49057, 'RA_SOURCE': '2003yCat.2246....0C', 'DEC_DEG': 19:48:59.021-!!|ASTROM| 1.234915, 'DEC_SOURCE': '2003yCat.2246....0C', 'EPOCH': 2451545.0, 'PMRA': None, 19:48:59.021-!!|ASTROM| 'PMRA_SOURCE': None, 'PMDE': None, 'PMDE_SOURCE': None, 'PLX': None, 19:48:59.021-!!|ASTROM| 'PLX_SOURCE': None, 'RV': None, 'RV_SOURCE': None, 'TEFF': 5900.0, 19:48:59.021-!!|ASTROM| 'TEFF_SOURCE': 'via spdrs@apikipiha', 'SP_TYPE': 'M4:', 'SP_SOURCE': 19:48:59.021-!!|ASTROM| '2009ApJ...691..672O', 'NOTES': 'Added on 2024-09-25 18:21:23.025 by 19:48:59.021-!!|ASTROM| spdrs@apikipiha using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': '2024-09-26 19:48:59.021-!!|ASTROM| 19:48:46.651', 'UHASH': 19:48:59.021-!!|ASTROM| 'a917159c414194c9245f0088f43d75097b4d91ffec30aafc7aaf3a087cc6fe20'}]] 19:48:59.028-!!|ASTROM| (Background on this error at: https://sqlalche.me/e/20/gkpj) 19:48:59.028-!!|ASTROM| path: <class 'sqlalchemy.exc.IntegrityError'> 19:48:59.028-!!|ASTROM| Table name: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate 19:48:59.028-!!|ASTROM| entry 'bd6f7bc8f4b07b5a9073fc8b7d51978e20dc209271262b8a72701f22c91e73e6' for key 19:48:59.028-!!|ASTROM| 'astrom_offline_db.UHASH' 19:48:59.029-!!|ASTROM| [SQL: INSERT INTO astrom_offline_db (OBJNAME, ORIGINAL_NAME, ALIASES, 19:48:59.029-!!|ASTROM| RA_DEG, RA_SOURCE, DEC_DEG, DEC_SOURCE, EPOCH, PMRA, PMRA_SOURCE, 19:48:59.029-!!|ASTROM| PMDE, PMDE_SOURCE, PLX, PLX_SOURCE, RV, RV_SOURCE, TEFF, 19:48:59.029-!!|ASTROM| TEFF_SOURCE, SP_TYPE, SP_SOURCE, NOTES, USED, DATE_ADDED, UHASH) 19:48:59.029-!!|ASTROM| VALUES (%(OBJNAME)s, %(ORIGINAL_NAME)s, %(ALIASES)s, %(RA_DEG)s, %(RA_SOURCE)s, 19:48:59.029-!!|ASTROM| %(DEC_DEG)s, %(DEC_SOURCE)s, %(EPOCH)s, %(PMRA)s, %(PMRA_SOURCE)s, %(PMDE)s, 19:48:59.029-!!|ASTROM| %(PMDE_SOURCE)s, %(PLX)s, %(PLX_SOURCE)s, %(RV)s, %(RV_SOURCE)s, %(TEFF)s, 19:48:59.029-!!|ASTROM| %(TEFF_SOURCE)s, %(SP_TYPE)s, %(SP_SOURCE)s, %(NOTES)s, %(USED)s, 19:48:59.029-!!|ASTROM| %(DATE_ADDED)s, %(UHASH)s)] 19:48:59.029-!!|ASTROM| [parameters: [{'OBJNAME': '10_LAC', 'ORIGINAL_NAME': ' 10 Lac', 'ALIASES': ' 19:48:59.029-!!|ASTROM| 10 Lac| S 813A| TRN 36|1RXS J223916.4+390252|2MASS J22391567+3903011|ADS 19:48:59.029-!!|ASTROM| 16148 A|AG+38 2350|ALS 14844|BD+38 4826|CCDM J22393+3903A|CEL 5 ... (1090 19:48:59.029-!!|ASTROM| characters truncated) ... 19:48:59.029-!!|ASTROM| 5|10Lac|S813A|TRN36|10LAC|BD+384826|CEL5504|CSI+3848262|FK5852|HGAM1078|HR8622|JP113513|PMC90-93599|PPM88031|ROT3301|SAO72575|UBV19389|UBVM26533', 19:48:59.029-!!|ASTROM| 'RA_DEG': 339.8153184, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 39.05024586, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.436831092, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -4.802891782, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 2.787612618, 'PLX_SOURCE': 'Gaia DR2', 'RV': -10.1, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 35200.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'O9V', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2022-01-31 18:24:17.089 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.029-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| 'fe642c035622dbe3482b908f19fc37ffda174b0e534d71ac56febbaf26b137f9'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| '11COM', 'ORIGINAL_NAME': '11Com', 'ALIASES': ' 11 Com| HO 52A|ADS 8521 19:48:59.029-!!|ASTROM| A|AG+18 1179|BD+18 2592|CCDM J12207+1748A|CSI+18 2592 1|FK5 2987|GC 16835|GCRV 19:48:59.029-!!|ASTROM| 7404|GEN# +1.00107383|GSC 01445-02 ... (641 characters truncated) ... 19:48:59.029-!!|ASTROM| D116214|TIC72437047|TYC1445-2560-1|UBV11083|UBVM18084|WDSJ12207+1748A|WEB10703|YPAC260|YZ184649|GaiaDR33946945413106333696|GaiaDR23946945413106333696', 19:48:59.029-!!|ASTROM| 'RA_DEG': 185.1787793, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 17.79325164, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -109.2413803, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': 88.17010164, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 10.71044534, 'PLX_SOURCE': 'Gaia DR2', 'RV': 43.37, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2018yCat.1345....0G', 'TEFF': 4741.0, 'TEFF_SOURCE': '2016A&A...585A...5B', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'G8+IIIFe-1', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2023-08-18 15:47:26.028 by nirps-client@maestria using drs_astrometrics.py', 19:48:59.029-!!|ASTROM| 'USED': 1, 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| 'bd02770667e8d53269bdac76e22cf8764c20b8ba841d071ed149466801674c3c'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| '15_PEG', 'ORIGINAL_NAME': 'PLX 5288', 'ALIASES': ' 15 Peg|2MASS 19:48:59.029-!!|ASTROM| J21522991+2847367|AG+28 2571|BD+28 4215|GC 30625|GCRV 13741|GEN# +1.00207978|GJ 19:48:59.029-!!|ASTROM| 4234|GSC 02214-02037|Gaia DR2 1896396703077703936|H ... (564 characters 19:48:59.029-!!|ASTROM| truncated) ... 19:48:59.029-!!|ASTROM| -2037-1|UBVM25978|WEB19470|YPAC212|YZ2812966|uvby98100207978|(F)15Peg|15Peg|15Peg|15PEG|BD+284215|GJ4234|HR8354|ROT3183|SAO90065|UBVM25978|YZ2812966', 19:48:59.029-!!|ASTROM| 'RA_DEG': 328.1243627, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 28.79327671, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -59.0848435, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -61.64685766, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 36.86280491, 'PLX_SOURCE': 'Gaia DR2', 'RV': 18.921, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2018A&A...616A...7S', 'TEFF': 6452.0, 'TEFF_SOURCE': '2017AJ....153...21L', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'F2V', 'SP_SOURCE': '1995ApJS...99..135A', 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2022-01-31 18:24:19.330 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.029-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| 'afa8e427656815c7be99f255918be0bf8ff716da44ff9301ae779ffc91f66329'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| '16_CYG_A', 'ORIGINAL_NAME': ' 16 Cyg A', 'ALIASES': ' 16 Cyg A| 16 Cyg C| 19:48:59.029-!!|ASTROM| STF 4046A| TRN 4|2MASS J19414896+5031305|ADS 12815 A|AG+50 1407|AKARI-IRC-V1 19:48:59.029-!!|ASTROM| J1941488+503129|ASCC 271116|BD+50 2847 ... (1211 characters truncated) ... 19:48:59.029-!!|ASTROM| |16CygC|TRN4|16CYGA|ASCC271116|BD+502847|GJ765.1A|HIC96895|HIP96895|HR7503|JP113128|PPM37671|ROT2839|SAO31898|SPOCS854|UBV16779|UBVM24079|YZ506149', 19:48:59.029-!!|ASTROM| 'RA_DEG': 295.4529704, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 50.52437636, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -148.299286, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -158.9610583, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 47.2771232, 'PLX_SOURCE': 'Gaia DR2', 'RV': -27.61, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2002ApJS..141..503N', 'TEFF': 5760.0, 'TEFF_SOURCE': '2021AJ....161..134H', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'G1.5Vb', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2022-01-31 18:24:21.499 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.029-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| '2d381d81f98c18409e2c76b3f0f765d3725c667cb91370308bcd9e46d10ce49d'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| '16_SGR', 'ORIGINAL_NAME': ' 16 Sgr', 'ALIASES': ' 16 Sgr| BU 286A| CHR 19:48:59.029-!!|ASTROM| 255|2MASS J18151297-2023167|ADS 11191 A|ALS 4819|ASCC 1595683|BD-20 5055|CCDM 19:48:59.029-!!|ASTROM| J18152-2023A|CGO 482|CPD-20 6919|CSI-2 ... (1207 characters truncated) ... 19:48:59.029-!!|ASTROM| BU286A|CHR255|16SGR|ALS4819|BD-205055|CPD-206919|CSI-2050551|HIC89440|HIP89440|HR6823|Hilt721|MCW632|ROT2574|UBV15500|UBVM22757|YZ1107574|[B10]4613', 19:48:59.029-!!|ASTROM| 'RA_DEG': 273.8040485, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -20.38797834, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 2.107182839, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.086838205, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 0.4805203893, 'PLX_SOURCE': 'Gaia DR2', 'RV': -11.0, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2004A&A...424..727P', 'TEFF': 31000.0, 'TEFF_SOURCE': 'HEADER[CFHT]', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'O9.5III', 'SP_SOURCE': '2014ApJS..211...10S', 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2022-01-31 18:24:23.604 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.029-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| 'd137e2e956fce675bac5f75c4a07933b068876f88d67bdc06169d430f1fd8952'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| '16SCO', 'ORIGINAL_NAME': '16Sco', 'ALIASES': ' 16 Sco|2MASS 19:48:59.029-!!|ASTROM| J16120731-0832512|BD-08 4180|GC 21784|GCRV 9313|GEN# +1.00145607|GSC 19:48:59.029-!!|ASTROM| 05612-01227|Gaia DR2 4348404390042854912|HD 145607|HIC 79387| ... (577 19:48:59.029-!!|ASTROM| characters truncated) ... 19:48:59.029-!!|ASTROM| V13773|UBVM21247|WEB13423|YZ985629|uvby98100145607|16Sco|16SCO|16Sco|BD-084180|GCRV9313|HIC79387|HIP79387|HR6033|ROT2296|UBV13773|UBVM21247|YZ985629', 19:48:59.029-!!|ASTROM| 'RA_DEG': 243.0306771, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -8.547581631, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 44.12551107, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -0.07825370467, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 12.64839489, 'PLX_SOURCE': 'Gaia DR2', 'RV': 5.0, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 8472.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'A2IV', 'SP_SOURCE': '1999MSS...C05....0H', 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2022-01-31 18:24:25.736 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.029-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| '6877df9a59c5a58247072161446517cc747587d61fe5169382378e7a9e4bc797'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| '17PEG', 'ORIGINAL_NAME': '17Peg', 'ALIASES': ' 17 Peg|2MASS 19:48:59.029-!!|ASTROM| J21565637+1204354|AG+11 2735|BD+11 4696|FK5 3751|GC 30719|GCRV 13788|GEN# 19:48:59.029-!!|ASTROM| +1.00208565|GSC 01130-01972|Gaia DR2 2728431923869085056|H ... (505 characters 19:48:59.029-!!|ASTROM| truncated) ... 19:48:59.029-!!|ASTROM| C60595351|TYC1130-1972-1|UBV18771|UBVM26010|WEB19513|YZ118738|uvby98100208565|17Peg|17PEG|17Peg|BD+114696|HR8373|ROT3192|UBV18771|UBVM26010|YZ118738', 19:48:59.029-!!|ASTROM| 'RA_DEG': 329.2347615, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 12.07643382, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -27.50976278, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -12.81550065, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 7.583223795, 'PLX_SOURCE': 'Gaia DR2', 'RV': 10.3, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 9247.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'A2Vnn', 'SP_SOURCE': None, 'NOTES': 'Added on 2022-01-31 19:48:59.029-!!|ASTROM| 18:24:27.860 by cook@cook using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': 19:48:59.029-!!|ASTROM| '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| '26655654dfc60c58b91769d4013cd35684c458adffcfbd8b52d528a86a71580e'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| '19_CEP', 'ORIGINAL_NAME': ' 19 Cep', 'ALIASES': ' 19 Cep| BU 697A| TRN 19:48:59.029-!!|ASTROM| 35A|1RXS J220508.8+621647|2MASS J22050878+6216473|ADS 15624 A|AG+62 1306|ALS 19:48:59.029-!!|ASTROM| 12117|BD+61 2246|CCDM J22051+6217A|CEL ... (1271 characters truncated) ... 19:48:59.029-!!|ASTROM| |uvby98100209975A|*19Cep|BU697A|TRN35A|19CEP|BD+612246|CEL5432|CSI+6122461|HR8428|JP113454|LSIII+627|PPM23444|ROT3218|SAO19849|UBV18896|UBVM26135', 19:48:59.029-!!|ASTROM| 'RA_DEG': 331.2866092, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 62.27980148, 19:48:59.029-!!|ASTROM| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.026573736, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.493237344, 'PMDE_SOURCE': 'Gaia DR2', 19:48:59.029-!!|ASTROM| 'PLX': 1.164795129, 'PLX_SOURCE': 'Gaia DR2', 'RV': -12.3, 'RV_SOURCE': 19:48:59.029-!!|ASTROM| '2006AstL...32..759G', 'TEFF': 32000.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:48:59.029-!!|ASTROM| 'SP_TYPE': 'O9Ib', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2022-01-31 18:24:32.035 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:48:59.029-!!|ASTROM| 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| '8784e154f8c1f0953f0b377b0fa3fe0f3cb2bfa65cd9f66178a242560f4ddf57'} ... 19:48:59.029-!!|ASTROM| displaying 10 of 1448 total bound parameter sets ... {'OBJNAME': 19:48:59.029-!!|ASTROM| 'TIC_266958963', 'ORIGINAL_NAME': 'TIC 266958963', 'ALIASES': 'UCAC4 19:48:59.029-!!|ASTROM| 703-028597|2MASS J04073801+5035260|TIC 266958963|Gaia DR3 19:48:59.029-!!|ASTROM| 247667266200977664|UCAC4703-028597|2MASSJ04073801+5035260|TIC266958963|GaiaDR3247667266200977664', 19:48:59.029-!!|ASTROM| 'RA_DEG': 61.90848215, 'RA_SOURCE': '2020yCat.1350....0G', 'DEC_DEG': 19:48:59.029-!!|ASTROM| 50.59054789, 'DEC_SOURCE': '2020yCat.1350....0G', 'EPOCH': 2451545.0, 'PMRA': 19:48:59.029-!!|ASTROM| 2.889, 'PMRA_SOURCE': '2020yCat.1350....0G', 'PMDE': 0.276, 'PMDE_SOURCE': 19:48:59.029-!!|ASTROM| '2020yCat.1350....0G', 'PLX': 19.4795, 'PLX_SOURCE': '2020yCat.1350....0G', 19:48:59.029-!!|ASTROM| 'RV': None, 'RV_SOURCE': None, 'TEFF': 3223.0, 'TEFF_SOURCE': 'via 19:48:59.029-!!|ASTROM| spdrs@apikipiha', 'SP_TYPE': None, 'SP_SOURCE': None, 'NOTES': 'Added on 19:48:59.029-!!|ASTROM| 2024-09-25 08:06:00.551 by spdrs@apikipiha using drs_astrometrics.py', 'USED': 19:48:59.029-!!|ASTROM| 1, 'DATE_ADDED': '2024-09-26 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| '31167162de3bb3cbd60c417f11317a5f89bf8acd467a961257f35b967ad40215'}, {'OBJNAME': 19:48:59.029-!!|ASTROM| 'SVS_20_S', 'ORIGINAL_NAME': 'IRAS 18274+0112', 'ALIASES': '2MASS 19:48:59.029-!!|ASTROM| J18295773+0114056|AKARI-IRC-V1 J1829578+011406|CK 1|GCNM 98|GCNM 99|GEL 10|IRAS 19:48:59.029-!!|ASTROM| 18274+0112|SSTc2d J182957.7+011406|SSTc2d J182957.7+011405|S ... (940 characters 19:48:59.029-!!|ASTROM| truncated) ... 19:48:59.029-!!|ASTROM| HMH2007]182|[K99d]1-21|[K99d]4-32|[KOB2004]314|[LFS2014]S12|[OMP2009]146|[P2003]J182957.7+011404|[SVS76]Ser20|[WMW2007]35|IRAS18274P0112|SVS20|SVS 19:48:59.029-!!|ASTROM| 20', 'RA_DEG': 277.49057, 'RA_SOURCE': '2003yCat.2246....0C', 'DEC_DEG': 19:48:59.029-!!|ASTROM| 1.234915, 'DEC_SOURCE': '2003yCat.2246....0C', 'EPOCH': 2451545.0, 'PMRA': None, 19:48:59.029-!!|ASTROM| 'PMRA_SOURCE': None, 'PMDE': None, 'PMDE_SOURCE': None, 'PLX': None, 19:48:59.029-!!|ASTROM| 'PLX_SOURCE': None, 'RV': None, 'RV_SOURCE': None, 'TEFF': 5900.0, 19:48:59.029-!!|ASTROM| 'TEFF_SOURCE': 'via spdrs@apikipiha', 'SP_TYPE': 'M4:', 'SP_SOURCE': 19:48:59.029-!!|ASTROM| '2009ApJ...691..672O', 'NOTES': 'Added on 2024-09-25 18:21:23.025 by 19:48:59.029-!!|ASTROM| spdrs@apikipiha using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': '2024-09-26 19:48:59.029-!!|ASTROM| 19:48:46.651', 'UHASH': 19:48:59.029-!!|ASTROM| 'a917159c414194c9245f0088f43d75097b4d91ffec30aafc7aaf3a087cc6fe20'}]] 19:48:59.037-!!|ASTROM| (Background on this error at: https://sqlalche.me/e/20/gkpj) 19:48:59.037-!!|ASTROM| Function: apero.base.drs_db.py.Database.add_from_pandas() 19:48:59.273-|ASTROM| 19:48:59.292-@!|ASTROM| W[40-003-00005]: Recipe apero_astrometrics has NOT been successfully completed 19:48:59.304-|ASTROM|

[larnoldgithub]

Sorry with this issue I'm completely stuck with all I have to do with Apero.

[njcuk9999]

I remove the duplicate entry for SVS_20_S but I'm pretty sure I did this before you sent this message.

This was fixed in v0.7.290 - I readded a duplicate and tested it.

I can try and back date this change to v0.7.288-stable-test but this will be some work to remember what I had to do for this and what is not an update related to it and wont happen at least until Monday.

Hopefully me removing the duplicates is enough for it to work for you.

Note you could install v0.7.290 elsewhere and use apero_astrometrics there but we should avoid duplicates (which are allowed) until no one is using older versions (they used to work and broke somewhere between v0.7.279 and v0.7.288)

[larnoldgithub]

I did a fresh install of the .290, but get an error with apero_astrometrics.py: ModuleNotFoundError: No module named 'gspread_pandas' see below.

''' spdrs@9445a6f9f245:/opt/apero-drs/setup$ source /opt/apero-drs/config/test_helu/test_helu.bash.setup

00:54:14.432- |VALID| 00:54:14.436- |VALID| 00:54:14.436- |VALID| SPIROU @PID-00017273984539138998-DTQ5 (V0.7.290) 00:54:14.437- |VALID| py3.9.20 git:v0.7.290-stable-test 00:54:14.437- |VALID| 00:54:14.441- |VALID| 00:54:14.445- |VALID| █████╗ ██████╗ ███████╗██████╗ ██████╗
00:54:14.449- |VALID| ██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔═══██╗ 00:54:14.453- |VALID| ███████║██████╔╝█████╗ ██████╔╝██║ ██║ 00:54:14.457- |VALID| ██╔══██║██╔═══╝ ██╔══╝ ██╔══██╗██║ ██║ 00:54:14.461- |VALID| ██║ ██║██║ ███████╗██║ ██║╚██████╔╝ 00:54:14.465- |VALID| ╚═╝ ╚═╝╚═╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝
00:54:14.470- |VALID| 00:54:14.475-|VALID| DRS Setup: 00:54:14.480-|VALID| 00:54:14.481-|VALID| DRS_ROOT: /opt/apero-drs/apero 00:54:14.481-|VALID| DRS_DATA_RAW: /apero-data/test_helu/raw 00:54:14.481-|VALID| DRS_DATA_REDUC: /apero-data/test_helu/red 00:54:14.481-|VALID| DRS_DATA_WORKING: /apero-data/test_helu/tmp 00:54:14.481-|VALID| DRS_CALIB_DB: /apero-data/test_helu/calib 00:54:14.481-|VALID| DRS_TELLU_DB: /apero-data/test_helu/tellu 00:54:14.481-|VALID| DRS_DATA_ASSETS: /apero-data/test_helu/asset 00:54:14.481-|VALID| DRS_DATA_OUT: /apero-data/test_helu/out 00:54:14.481-|VALID| DRS_DATA_MSG: /apero-data/test_helu/log 00:54:14.482-|VALID| DRS_DATA_RUN: /apero-data/test_helu/run 00:54:14.482-|VALID| DRS_DATA_PLOT: /apero-data/test_helu/plot 00:54:14.482-|VALID| DRS_DATA_OTHER: /apero-data/test_helu/other 00:54:14.482-|VALID| LBL_PATH: /apero-data/test_helu/lbl 00:54:14.482-|VALID| DRS_CONFIG: /opt/apero-drs/config/test_helu/user_config.ini 00:54:14.482-|VALID| DRS_CONFIG: /opt/apero-drs/config/test_helu/user_constants.ini 00:54:14.482-|VALID| DRS_CONFIG: apero.constants.default.default_config 00:54:14.482-|VALID| DRS_CONFIG: apero.constants.default.default_keywords 00:54:14.482-|VALID| DRS_CONFIG: config.instruments.spirou.default_config.py 00:54:14.482-|VALID| DRS_CONFIG: config.instruments.spirou.default_keywords.py 00:54:14.482-|VALID| DRS_CONFIG: core.instruments.default.default_constants.py 00:54:14.483-|VALID| DRS_CONFIG: core.instruments.spirou.default_constants.py 00:54:14.483-|VALID| DATABASE: MYSQL 00:54:14.483-|VALID| DATABASE-calib: spirou@pupus-mysql:calib_test_helu_db 00:54:14.483-|VALID| DATABASE-tellu: spirou@pupus-mysql:tellu_test_helu_db 00:54:14.483-|VALID| DATABASE-findex: spirou@pupus-mysql:findex_test_helu_db 00:54:14.483-|VALID| DATABASE-log: spirou@pupus-mysql:log_test_helu_db 00:54:14.483-|VALID| DATABASE-astrom: spirou@pupus-mysql:astrom_test_helu_db 00:54:14.483-|VALID| DATABASE-lang: spirou@pupus-mysql:lang_test_helu_db 00:54:14.483-|VALID| DATABASE-reject: spirou@pupus-mysql:reject_test_helu_db 00:54:14.483-|VALID| PRINT_LEVEL: all 00:54:14.483-|VALID| LOG_LEVEL: all 00:54:14.484-|VALID| DRS_PLOT: 0 00:54:14.488- |VALID| 00:54:15.191- |VALID| Validation complete 00:54:15.195-|VALID| * 00:54:15.200-|VALID| Recipe apero_validate has been successfully completed 00:54:15.205-*|VALID| test_helu Thu Sep 26 14:54:15 spdrs@9445a6f9f245: /opt/apero-drs/setup test_helu Thu Sep 26 14:54:15 spdrs@9445a6f9f245: /opt/apero-drs/setup

apero_astrometrics.py 'Gl699' Traceback (most recent call last): File "/opt/apero-drs/tools/bin/apero_astrometrics.py", line 17, in from apero.tools.module.database import drs_astrometrics File "/opt/apero-drs/apero/tools/module/database/drs_astrometrics.py", line 20, in import gspread_pandas as gspd ModuleNotFoundError: No module named 'gspread_pandas' test_helu Thu Sep 26 14:54:44 spdrs@9445a6f9f245: /opt/apero-drs/setup

'''

[njcuk9999]

Did you use the requirements_developers.txt file? Tools require the developer options

[larnoldgithub]

Thanks, That was my guess and wanted to try that this morning; I used the current.txt

[larnoldgithub]

There some progress but still an issue, apparently with the mysql syntax.

 apero_astrometrics.py 'IRAS 18274+0112'
19:39:48.233-  |ASTROM| ***************************************************************************
19:39:48.237-  |ASTROM| *
19:39:48.237-  |ASTROM| *  SPIROU @PID-00017274659877151908-LAEU (V0.7.290)
19:39:48.238-  |ASTROM| *         py3.9.20  git:v0.7.290-stable-test
19:39:48.238-  |ASTROM| *
19:39:48.242-  |ASTROM| ***************************************************************************
19:39:48.246-  |ASTROM|       █████╗ ██████╗ ███████╗██████╗  ██████╗  
19:39:48.250-  |ASTROM|      ██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔═══██╗ 
19:39:48.254-  |ASTROM|      ███████║██████╔╝█████╗  ██████╔╝██║   ██║ 
19:39:48.258-  |ASTROM|      ██╔══██║██╔═══╝ ██╔══╝  ██╔══██╗██║   ██║ 
19:39:48.262-  |ASTROM|      ██║  ██║██║     ███████╗██║  ██║╚██████╔╝ 
19:39:48.266-  |ASTROM|      ╚═╝  ╚═╝╚═╝     ╚══════╝╚═╝  ╚═╝ ╚═════╝  
19:39:48.271-  |ASTROM| ***************************************************************************
19:39:48.277-**|ASTROM| DRS Setup:
19:39:48.281-**|ASTROM| 
19:39:48.281-**|ASTROM|     DRS_ROOT: /opt/apero-drs/apero
19:39:48.281-**|ASTROM|     DRS_DATA_RAW: /apero-data/test_helu/raw
19:39:48.282-**|ASTROM|     DRS_DATA_REDUC: /apero-data/test_helu/red
19:39:48.282-**|ASTROM|     DRS_DATA_WORKING: /apero-data/test_helu/tmp
19:39:48.282-**|ASTROM|     DRS_CALIB_DB: /apero-data/test_helu/calib
19:39:48.282-**|ASTROM|     DRS_TELLU_DB: /apero-data/test_helu/tellu
19:39:48.282-**|ASTROM|     DRS_DATA_ASSETS: /apero-data/test_helu/asset
19:39:48.282-**|ASTROM|     DRS_DATA_OUT: /apero-data/test_helu/out
19:39:48.282-**|ASTROM|     DRS_DATA_MSG: /apero-data/test_helu/log
19:39:48.282-**|ASTROM|     DRS_DATA_RUN: /apero-data/test_helu/run
19:39:48.282-**|ASTROM|     DRS_DATA_PLOT: /apero-data/test_helu/plot
19:39:48.282-**|ASTROM|     DRS_DATA_OTHER: /apero-data/test_helu/other
19:39:48.283-**|ASTROM|     LBL_PATH: /apero-data/test_helu/lbl
19:39:48.283-**|ASTROM|     DRS_CONFIG: /opt/apero-drs/config/test_helu/user_config.ini
19:39:48.283-**|ASTROM|     DRS_CONFIG: /opt/apero-drs/config/test_helu/user_constants.ini
19:39:48.283-**|ASTROM|     DRS_CONFIG: apero.constants.default.default_config
19:39:48.283-**|ASTROM|     DRS_CONFIG: apero.constants.default.default_keywords
19:39:48.283-**|ASTROM|     DRS_CONFIG: config.instruments.spirou.default_config.py
19:39:48.283-**|ASTROM|     DRS_CONFIG: config.instruments.spirou.default_keywords.py
19:39:48.283-**|ASTROM|     DRS_CONFIG: core.instruments.default.default_constants.py
19:39:48.283-**|ASTROM|     DRS_CONFIG: core.instruments.spirou.default_constants.py
19:39:48.283-**|ASTROM|     DATABASE: MYSQL
19:39:48.283-**|ASTROM|     DATABASE-calib: spirou@pupus-mysql:calib_test_helu_db
19:39:48.284-**|ASTROM|     DATABASE-tellu: spirou@pupus-mysql:tellu_test_helu_db
19:39:48.284-**|ASTROM|     DATABASE-findex: spirou@pupus-mysql:findex_test_helu_db
19:39:48.284-**|ASTROM|     DATABASE-log: spirou@pupus-mysql:log_test_helu_db
19:39:48.284-**|ASTROM|     DATABASE-astrom: spirou@pupus-mysql:astrom_test_helu_db
19:39:48.284-**|ASTROM|     DATABASE-lang: spirou@pupus-mysql:lang_test_helu_db
19:39:48.284-**|ASTROM|     DATABASE-reject: spirou@pupus-mysql:reject_test_helu_db
19:39:48.284-**|ASTROM|     PRINT_LEVEL: all
19:39:48.284-**|ASTROM|     LOG_LEVEL: all
19:39:48.284-**|ASTROM|     DRS_PLOT: 0
19:39:48.288-  |ASTROM| ***************************************************************************
19:39:48.292-**|ASTROM| Arguments used:
19:39:48.296-**|ASTROM| 
19:39:48.297-**|ASTROM|     --OBJECTS: IRAS 18274+0112
19:39:48.301-  |ASTROM| ***************************************************************************
19:39:48.953-  |ASTROM| Updating object database (from google sheets)
19:39:54.361-  |ASTROM| Searching local object database for object names...
19:39:54.984-  |ASTROM|      - Object: "IRAS 18274+0112" found in database under an alias as "SVS_20"
19:39:55.001-**|ASTROM| Accessing full local object database...
19:39:55.026-**|ASTROM| Checking object IRAS 18274+0112 for errors.
19:39:55.053-!!|ASTROM| 19:39:55.049-**|DatabaseError|E[00-002-00032] <class
19:39:55.053-!!|ASTROM|     'mysql.connector.errors.ProgrammingError'>: 1064 (42000): You have an error in
19:39:55.053-!!|ASTROM|     your SQL syntax; check the manual that corresponds to your MariaDB server
19:39:55.053-!!|ASTROM|     version for the right syntax to use near 'SVS 20 S"" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="2MASSJ18295773+0114056" OR KW_OBJNAME="AKARI-IRC-V1...' at line 1
19:39:55.053-!!|ASTROM| Command: SELECT DISTINCT KW_OBJNAME FROM findex_test_helu_db WHERE
19:39:55.053-!!|ASTROM|     KW_OBJNAME="SVS_20" OR KW_OBJNAME="IRAS 18274+0112" OR KW_OBJNAME="2MASS
19:39:55.053-!!|ASTROM|     J18295773+0114056" OR KW_OBJNAME="AKARI-IRC-V1 J1829578+011406" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="CK 1" OR KW_OBJNAME="GCNM 98" OR KW_OBJNAME="GCNM 99" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="GEL 10" OR KW_OBJNAME="IRAS 18274+0112" OR KW_OBJNAME="SSTc2d
19:39:55.053-!!|ASTROM|     J182957.7+011406" OR KW_OBJNAME="SSTc2d J182957.7+011405" OR KW_OBJNAME="STGM
19:39:55.053-!!|ASTROM|     NIRS 5" OR KW_OBJNAME="STGM 182725.4+011201" OR KW_OBJNAME="TIC 404750826" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="WISEA J182957.74+011405.7" OR KW_OBJNAME="WISE J182957.72+011405.6"
19:39:55.053-!!|ASTROM|     OR KW_OBJNAME="2XMM J182957.7+011405" OR KW_OBJNAME="XMMU J182957.7+011404" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[ACA2003] Ser B 6" OR KW_OBJNAME="[B96] Serpens 7" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[CED93] 6" OR KW_OBJNAME="[EC92] 90" OR KW_OBJNAME="[EDJ2009] 677"
19:39:55.053-!!|ASTROM|     OR KW_OBJNAME="[EES2009] Ser-emb 30" OR KW_OBJNAME="[ETC2005] 16" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[GFM2007] 48" OR KW_OBJNAME="[GMM2009] Serpens 15" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[GSL2010] 5" OR KW_OBJNAME="[HL2013] 277.49055+01.23494" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[HL85] GGD 29 16" OR KW_OBJNAME="[HMH2007] 182" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[K99d] 1-21" OR KW_OBJNAME="[K99d] 4-32" OR KW_OBJNAME="[KOB2004]
19:39:55.053-!!|ASTROM|     314" OR KW_OBJNAME="[LFS2014] S12" OR KW_OBJNAME="[OMP2009] 146" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[P2003] J182957.7+011404" OR KW_OBJNAME="[SVS76] Ser 20" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[WMW2007] 35" OR KW_OBJNAME="IRAS_18274P0112" OR KW_OBJNAME=""SVS 20
19:39:55.053-!!|ASTROM|     S"" OR KW_OBJNAME="2MASSJ18295773+0114056" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="AKARI-IRC-V1J1829578+011406" OR KW_OBJNAME="CK1" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="GCNM98" OR KW_OBJNAME="GCNM99" OR KW_OBJNAME="GEL10" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="IRAS18274+0112" OR KW_OBJNAME="SSTc2dJ182957.7+011406" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="SSTc2dJ182957.7+011405" OR KW_OBJNAME="STGMNIRS5" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="STGM182725.4+011201" OR KW_OBJNAME="TIC404750826" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="WISEAJ182957.74+011405.7" OR KW_OBJNAME="WISEJ182957.72+011405.6" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="2XMMJ182957.7+011405" OR KW_OBJNAME="XMMUJ182957.7+011404" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[ACA2003]SerB6" OR KW_OBJNAME="[B96]Serpens7" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[CED93]6" OR KW_OBJNAME="[EC92]90" OR KW_OBJNAME="[EDJ2009]677" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[EES2009]Ser-emb30" OR KW_OBJNAME="[ETC2005]16" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[GFM2007]48" OR KW_OBJNAME="[GMM2009]Serpens15" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[GSL2010]5" OR KW_OBJNAME="[HL2013]277.49055+01.23494" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[HL85]GGD2916" OR KW_OBJNAME="[HMH2007]182" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[K99d]1-21" OR KW_OBJNAME="[K99d]4-32" OR KW_OBJNAME="[KOB2004]314"
19:39:55.053-!!|ASTROM|     OR KW_OBJNAME="[LFS2014]S12" OR KW_OBJNAME="[OMP2009]146" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[P2003]J182957.7+011404" OR KW_OBJNAME="[SVS76]Ser20" OR
19:39:55.053-!!|ASTROM|     KW_OBJNAME="[WMW2007]35" OR KW_OBJNAME="IRAS18274P0112" OR KW_OBJNAME=""SVS20S""
19:39:55.055-!!|ASTROM|     path: /home/spdrs/.apero/spdrs_at_pupus-mysql
19:39:55.055-!!|ASTROM|     Function: apero.base.drs_db.py.Database.execute()
19:39:55.077-**|ASTROM| ***************************************************************************
19:39:55.083-@!|ASTROM| W[40-003-00005]: Recipe apero_astrometrics has NOT been successfully completed
19:39:55.088-**|ASTROM| ***************************************************************************

[larnoldgithub]

The object IRAS 18274+0112 is in the objdb (pending list) as SVS_20_S (first column) but the error above says it is known as SVS_20

[larnoldgithub]

Also I see in the pending list that lines 64 65 66 67 are redundant with 83 84 85 86 respecively. I can't remember if I had entered those TIC objects before the other day. It's likely worth to remove those 4 lines 83-86

[njcuk9999]

Ah I see for some strange reason the original name was IRAS 18274+011 for SVS_20_S not sure why! I've remove lines 83 to 86 like you ask!

[larnoldgithub]

for those four targets, should we add the alias TIC(space)(ID) ?

[njcuk9999]

Its actually not necessary as TIC_ID is the same thing.

APERO automatically replaces:

• " " with "_"
• "-" with "M"
• "+" with "P"

I've added them any way, the more important one to add is with no space i.e. TIC1234 as well as TIC 1234 as these would be regarded as two separate astrophysical objects

[larnoldgithub]

@njcuk9999 I'm trying this morning to reducedwith the 288 just one star for one PI from 24A. His star is already in the DB. But apero_processing.py fails right away.

here is what I get in the terminal:

apero_processing.py run_24A_Bellotti.ini --test=True 19:53:25.110- |PROC| 19:53:25.116- |PROC| 19:53:25.117- |PROC| SPIROU @PID-00017280716042396050-W8SF (V0.7.288) 19:53:25.117- |PROC| py3.9.16 git:v0.7.288-stable-test 19:53:25.117- |PROC| 19:53:25.123- |PROC| 19:53:25.128- |PROC| █████╗ ██████╗ ███████╗██████╗ ██████╗
19:53:25.134- |PROC| ██╔══██╗██╔══██╗██╔════╝██╔══██╗██╔═══██╗ 19:53:25.140- |PROC| ███████║██████╔╝█████╗ ██████╔╝██║ ██║ 19:53:25.145- |PROC| ██╔══██║██╔═══╝ ██╔══╝ ██╔══██╗██║ ██║ 19:53:25.151- |PROC| ██║ ██║██║ ███████╗██║ ██║╚██████╔╝ 19:53:25.156- |PROC| ╚═╝ ╚═╝╚═╝ ╚══════╝╚═╝ ╚═╝ ╚═════╝
19:53:25.162- |PROC| * 19:53:25.174-|PROC| DRS Setup: 19:53:25.180-|PROC| 19:53:25.180-|PROC| DRS_ROOT: /apero/apero-drs/apero 19:53:25.180-|PROC| DRS_DATA_RAW: /data/spirou4/arlinks 19:53:25.180-|PROC| DRS_DATA_REDUC: /data/spirou4/apero-data/offline/red 19:53:25.181-|PROC| DRS_DATA_WORKING: /data/spirou4/apero-data/offline/tmp 19:53:25.181-|PROC| DRS_CALIB_DB: /data/spirou4/apero-data/offline/calib 19:53:25.181-|PROC| DRS_TELLU_DB: /data/spirou4/apero-data/offline/tellu 19:53:25.181-|PROC| DRS_DATA_ASSETS: /data/spirou4/apero-data/offline/asset 19:53:25.181-|PROC| DRS_DATA_MSG: /data/spirou4/apero-data/offline/msg 19:53:25.181-|PROC| DRS_DATA_RUN: /data/spirou4/apero-data/offline/run 19:53:25.182-|PROC| DRS_DATA_PLOT: /data/spirou4/apero-data/offline/plot 19:53:25.182-|PROC| DRS_CONFIG: /apero/config/offline/user_config.ini 19:53:25.182-|PROC| DRS_CONFIG: /apero/config/offline/user_constants.ini 19:53:25.182-|PROC| DRS_CONFIG: apero.constants.default.default_config 19:53:25.182-|PROC| DRS_CONFIG: apero.constants.default.default_keywords 19:53:25.182-|PROC| DRS_CONFIG: config.instruments.spirou.default_config.py 19:53:25.183-|PROC| DRS_CONFIG: config.instruments.spirou.default_keywords.py 19:53:25.183-|PROC| DRS_CONFIG: core.instruments.default.default_constants.py 19:53:25.183-|PROC| DRS_CONFIG: core.instruments.spirou.default_constants.py 19:53:25.183-|PROC| DATABASE: MYSQL 19:53:25.183-|PROC| DATABASE-calib: aperooffline@localhost:calib_offline_db 19:53:25.183-|PROC| DATABASE-tellu: aperooffline@localhost:tellu_offline_db 19:53:25.184-|PROC| DATABASE-findex: aperooffline@localhost:findex_offline_db 19:53:25.184-|PROC| DATABASE-log: aperooffline@localhost:log_offline_db 19:53:25.184-|PROC| DATABASE-astrom: aperooffline@localhost:astrom_offline_db 19:53:25.184-|PROC| DATABASE-lang: aperooffline@localhost:lang_offline_db 19:53:25.184-|PROC| DATABASE-reject: aperooffline@localhost:reject_offline_db 19:53:25.184-|PROC| PRINT_LEVEL: all 19:53:25.184-|PROC| LOG_LEVEL: all 19:53:25.185-*|PROC| DRS_PLOT: 0 19:53:25.190- |PROC| 19:53:25.196-|PROC| Arguments used: 19:53:25.201-|PROC| 19:53:25.201-|PROC| --RUNFILE: run_24A_Bellotti.ini 19:53:25.202-|PROC| --TEST: True 19:53:25.207- |PROC| ***** 19:53:27.183-|PROC| Updating object database (from google sheets) 19:53:35.740-!!|PROC| 19:53:35.726-|DatabaseError|E[00-002-00047] Pandas.to_sql <class 19:53:35.740-!!|PROC| 'sqlalchemy.exc.IntegrityError'>: (mysql.connector.errors.IntegrityError) 1062 19:53:35.740-!!|PROC| (23000): Duplicate entry 19:53:35.740-!!|PROC| 'bd6f7bc8f4b07b5a9073fc8b7d51978e20dc209271262b8a72701f22c91e73e6' for key 19:53:35.740-!!|PROC| 'astrom_offline_db.UHASH' 19:53:35.741-!!|PROC| [SQL: INSERT INTO astrom_offline_db (OBJNAME, ORIGINAL_NAME, ALIASES, 19:53:35.741-!!|PROC| RA_DEG, RA_SOURCE, DEC_DEG, DEC_SOURCE, EPOCH, PMRA, PMRA_SOURCE, 19:53:35.741-!!|PROC| PMDE, PMDE_SOURCE, PLX, PLX_SOURCE, RV, RV_SOURCE, TEFF, 19:53:35.741-!!|PROC| TEFF_SOURCE, SP_TYPE, SP_SOURCE, NOTES, USED, DATE_ADDED, UHASH) 19:53:35.741-!!|PROC| VALUES (%(OBJNAME)s, %(ORIGINAL_NAME)s, %(ALIASES)s, %(RA_DEG)s, %(RA_SOURCE)s, 19:53:35.741-!!|PROC| %(DEC_DEG)s, %(DEC_SOURCE)s, %(EPOCH)s, %(PMRA)s, %(PMRA_SOURCE)s, %(PMDE)s, 19:53:35.741-!!|PROC| %(PMDE_SOURCE)s, %(PLX)s, %(PLX_SOURCE)s, %(RV)s, %(RV_SOURCE)s, %(TEFF)s, 19:53:35.741-!!|PROC| %(TEFF_SOURCE)s, %(SP_TYPE)s, %(SP_SOURCE)s, %(NOTES)s, %(USED)s, 19:53:35.741-!!|PROC| %(DATE_ADDED)s, %(UHASH)s)] 19:53:35.742-!!|PROC| [parameters: [{'OBJNAME': '10_LAC', 'ORIGINAL_NAME': ' 10 Lac', 'ALIASES': ' 19:53:35.742-!!|PROC| 10 Lac| S 813A| TRN 36|1RXS J223916.4+390252|2MASS J22391567+3903011|ADS 19:53:35.742-!!|PROC| 16148 A|AG+38 2350|ALS 14844|BD+38 4826|CCDM J22393+3903A|CEL 5 ... (1090 19:53:35.742-!!|PROC| characters truncated) ... 19:53:35.742-!!|PROC| 5|*10Lac|S813A|TRN36|10LAC|BD+384826|CEL5504|CSI+3848262|FK5852|HGAM1078|HR8622|JP113513|PMC90-93599|PPM88031|ROT3301|SAO72575|UBV19389|UBVM26533', 19:53:35.742-!!|PROC| 'RA_DEG': 339.8153184, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 39.05024586, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.436831092, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -4.802891782, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 2.787612618, 'PLX_SOURCE': 'Gaia DR2', 'RV': -10.1, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2006AstL...32..759G', 'TEFF': 35200.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:53:35.742-!!|PROC| 'SP_TYPE': 'O9V', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2022-01-31 18:24:17.089 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.742-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| 'fe642c035622dbe3482b908f19fc37ffda174b0e534d71ac56febbaf26b137f9'}, {'OBJNAME': 19:53:35.742-!!|PROC| '11COM', 'ORIGINAL_NAME': '11Com', 'ALIASES': '* 11 Com|* HO 52A|ADS 8521 19:53:35.742-!!|PROC| A|AG+18 1179|BD+18 2592|CCDM J12207+1748A|CSI+18 2592 1|FK5 2987|GC 16835|GCRV 19:53:35.742-!!|PROC| 7404|GEN# +1.00107383|GSC 01445-02 ... (641 characters truncated) ... 19:53:35.742-!!|PROC| D116214|TIC72437047|TYC1445-2560-1|UBV11083|UBVM18084|WDSJ12207+1748A|WEB10703|YPAC260|YZ184649|GaiaDR33946945413106333696|GaiaDR23946945413106333696', 19:53:35.742-!!|PROC| 'RA_DEG': 185.1787793, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 17.79325164, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -109.2413803, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': 88.17010164, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 10.71044534, 'PLX_SOURCE': 'Gaia DR2', 'RV': 43.37, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2018yCat.1345....0G', 'TEFF': 4741.0, 'TEFF_SOURCE': '2016A&A...585A...5B', 19:53:35.742-!!|PROC| 'SP_TYPE': 'G8+IIIFe-1', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2023-08-18 15:47:26.028 by nirps-client@maestria using drs_astrometrics.py', 19:53:35.742-!!|PROC| 'USED': 1, 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| 'bd02770667e8d53269bdac76e22cf8764c20b8ba841d071ed149466801674c3c'}, {'OBJNAME': 19:53:35.742-!!|PROC| '15_PEG', 'ORIGINAL_NAME': 'PLX 5288', 'ALIASES': ' 15 Peg|2MASS 19:53:35.742-!!|PROC| J21522991+2847367|AG+28 2571|BD+28 4215|GC 30625|GCRV 13741|GEN# +1.00207978|GJ 19:53:35.742-!!|PROC| 4234|GSC 02214-02037|Gaia DR2 1896396703077703936|H ... (564 characters 19:53:35.742-!!|PROC| truncated) ... 19:53:35.742-!!|PROC| -2037-1|UBVM25978|WEB19470|YPAC212|YZ2812966|uvby98100207978|(F)15Peg|15Peg|15Peg|15PEG|BD+284215|GJ4234|HR8354|ROT3183|SAO90065|UBVM25978|YZ2812966', 19:53:35.742-!!|PROC| 'RA_DEG': 328.1243627, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 28.79327671, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -59.0848435, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -61.64685766, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 36.86280491, 'PLX_SOURCE': 'Gaia DR2', 'RV': 18.921, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2018A&A...616A...7S', 'TEFF': 6452.0, 'TEFF_SOURCE': '2017AJ....153...21L', 19:53:35.742-!!|PROC| 'SP_TYPE': 'F2V', 'SP_SOURCE': '1995ApJS...99..135A', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2022-01-31 18:24:19.330 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.742-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| 'afa8e427656815c7be99f255918be0bf8ff716da44ff9301ae779ffc91f66329'}, {'OBJNAME': 19:53:35.742-!!|PROC| '16_CYG_A', 'ORIGINAL_NAME': ' 16 Cyg A', 'ALIASES': ' 16 Cyg A| 16 Cyg C| 19:53:35.742-!!|PROC| STF 4046A| TRN 4|2MASS J19414896+5031305|ADS 12815 A|AG+50 1407|AKARI-IRC-V1 19:53:35.742-!!|PROC| J1941488+503129|ASCC 271116|BD+50 2847 ... (1211 characters truncated) ... 19:53:35.742-!!|PROC| |*16CygC|TRN4|16CYGA|ASCC271116|BD+502847|GJ765.1A|HIC96895|HIP96895|HR7503|JP113128|PPM37671|ROT2839|SAO31898|SPOCS854|UBV16779|UBVM24079|YZ506149', 19:53:35.742-!!|PROC| 'RA_DEG': 295.4529704, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 50.52437636, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -148.299286, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -158.9610583, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 47.2771232, 'PLX_SOURCE': 'Gaia DR2', 'RV': -27.61, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2002ApJS..141..503N', 'TEFF': 5760.0, 'TEFF_SOURCE': '2021AJ....161..134H', 19:53:35.742-!!|PROC| 'SP_TYPE': 'G1.5Vb', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2022-01-31 18:24:21.499 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.742-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| '2d381d81f98c18409e2c76b3f0f765d3725c667cb91370308bcd9e46d10ce49d'}, {'OBJNAME': 19:53:35.742-!!|PROC| '16_SGR', 'ORIGINAL_NAME': ' 16 Sgr', 'ALIASES': ' 16 Sgr| BU 286A| CHR 19:53:35.742-!!|PROC| 255|2MASS J18151297-2023167|ADS 11191 A|ALS 4819|ASCC 1595683|BD-20 5055|CCDM 19:53:35.742-!!|PROC| J18152-2023A|CGO 482|CPD-20 6919|CSI-2 ... (1207 characters truncated) ... 19:53:35.742-!!|PROC| BU286A|CHR255|16SGR|ALS4819|BD-205055|CPD-206919|CSI-2050551|HIC89440|HIP89440|HR6823|Hilt721|MCW632|ROT2574|UBV15500|UBVM22757|YZ1107574|[B10]4613', 19:53:35.742-!!|PROC| 'RA_DEG': 273.8040485, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -20.38797834, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 2.107182839, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.086838205, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 0.4805203893, 'PLX_SOURCE': 'Gaia DR2', 'RV': -11.0, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2004A&A...424..727P', 'TEFF': 31000.0, 'TEFF_SOURCE': 'HEADER[CFHT]', 19:53:35.742-!!|PROC| 'SP_TYPE': 'O9.5III', 'SP_SOURCE': '2014ApJS..211...10S', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2022-01-31 18:24:23.604 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.742-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| 'd137e2e956fce675bac5f75c4a07933b068876f88d67bdc06169d430f1fd8952'}, {'OBJNAME': 19:53:35.742-!!|PROC| '16SCO', 'ORIGINAL_NAME': '16Sco', 'ALIASES': ' 16 Sco|2MASS 19:53:35.742-!!|PROC| J16120731-0832512|BD-08 4180|GC 21784|GCRV 9313|GEN# +1.00145607|GSC 19:53:35.742-!!|PROC| 05612-01227|Gaia DR2 4348404390042854912|HD 145607|HIC 79387| ... (577 19:53:35.742-!!|PROC| characters truncated) ... 19:53:35.742-!!|PROC| V13773|UBVM21247|WEB13423|YZ985629|uvby98100145607|16Sco|16SCO|16Sco|BD-084180|GCRV9313|HIC79387|HIP79387|HR6033|ROT2296|UBV13773|UBVM21247|YZ985629', 19:53:35.742-!!|PROC| 'RA_DEG': 243.0306771, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -8.547581631, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 44.12551107, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -0.07825370467, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 12.64839489, 'PLX_SOURCE': 'Gaia DR2', 'RV': 5.0, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2006AstL...32..759G', 'TEFF': 8472.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:53:35.742-!!|PROC| 'SP_TYPE': 'A2IV', 'SP_SOURCE': '1999MSS...C05....0H', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2022-01-31 18:24:25.736 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.742-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| '6877df9a59c5a58247072161446517cc747587d61fe5169382378e7a9e4bc797'}, {'OBJNAME': 19:53:35.742-!!|PROC| '17PEG', 'ORIGINAL_NAME': '17Peg', 'ALIASES': ' 17 Peg|2MASS 19:53:35.742-!!|PROC| J21565637+1204354|AG+11 2735|BD+11 4696|FK5 3751|GC 30719|GCRV 13788|GEN# 19:53:35.742-!!|PROC| +1.00208565|GSC 01130-01972|Gaia DR2 2728431923869085056|H ... (505 characters 19:53:35.742-!!|PROC| truncated) ... 19:53:35.742-!!|PROC| C60595351|TYC1130-1972-1|UBV18771|UBVM26010|WEB19513|YZ118738|uvby98100208565|17Peg|17PEG|17Peg|BD+114696|HR8373|ROT3192|UBV18771|UBVM26010|YZ118738', 19:53:35.742-!!|PROC| 'RA_DEG': 329.2347615, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 12.07643382, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -27.50976278, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -12.81550065, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 7.583223795, 'PLX_SOURCE': 'Gaia DR2', 'RV': 10.3, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2006AstL...32..759G', 'TEFF': 9247.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:53:35.742-!!|PROC| 'SP_TYPE': 'A2Vnn', 'SP_SOURCE': None, 'NOTES': 'Added on 2022-01-31 19:53:35.742-!!|PROC| 18:24:27.860 by cook@cook using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': 19:53:35.742-!!|PROC| '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| '26655654dfc60c58b91769d4013cd35684c458adffcfbd8b52d528a86a71580e'}, {'OBJNAME': 19:53:35.742-!!|PROC| '19_CEP', 'ORIGINAL_NAME': ' 19 Cep', 'ALIASES': ' 19 Cep| BU 697A| TRN 19:53:35.742-!!|PROC| 35A|1RXS J220508.8+621647|2MASS J22050878+6216473|ADS 15624 A|AG+62 1306|ALS 19:53:35.742-!!|PROC| 12117|BD+61 2246|CCDM J22051+6217A|CEL ... (1271 characters truncated) ... 19:53:35.742-!!|PROC| |uvby98100209975A|*19Cep|BU697A|TRN35A|19CEP|BD+612246|CEL5432|CSI+6122461|HR8428|JP113454|LSIII+627|PPM23444|ROT3218|SAO19849|UBV18896|UBVM26135', 19:53:35.742-!!|PROC| 'RA_DEG': 331.2866092, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 62.27980148, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.026573736, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.493237344, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 1.164795129, 'PLX_SOURCE': 'Gaia DR2', 'RV': -12.3, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2006AstL...32..759G', 'TEFF': 32000.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:53:35.742-!!|PROC| 'SP_TYPE': 'O9Ib', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2022-01-31 18:24:32.035 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.742-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| '8784e154f8c1f0953f0b377b0fa3fe0f3cb2bfa65cd9f66178a242560f4ddf57'} ... 19:53:35.742-!!|PROC| displaying 10 of 1444 total bound parameter sets ... {'OBJNAME': 'STKM_1M1262', 19:53:35.742-!!|PROC| 'ORIGINAL_NAME': 'STKM 1-1262', 'ALIASES': 'TYC 3869-496-1|BPS BS 16034-0046|GSC 19:53:35.742-!!|PROC| 03869-00496|LAMOST J153709.49+531919.7|2MASS J15370939+5319205|PM J15371+5319|RX 19:53:35.742-!!|PROC| J1537.1+5319|1RXS J153709.0+531 ... (464 characters truncated) ... 19:53:35.742-!!|PROC| EAJ153709.50+531919.4|2XMMiJ153709.4+531920|[ZEH2003]RXJ1537.1+53191|GaiaDR31597668980175177344|GaiaDR11597668975880498944|GaiaDR21597668980176285824', 19:53:35.742-!!|PROC| 'RA_DEG': 234.2897757, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 53.32193987, 19:53:35.742-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 82.34530266, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -93.74985331, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.742-!!|PROC| 'PLX': 24.46878175, 'PLX_SOURCE': 'Gaia DR2', 'RV': -13.82, 'RV_SOURCE': 19:53:35.742-!!|PROC| '2023ApJS..264...17Z', 'TEFF': 3800.0, 'TEFF_SOURCE': 'via spdrs@apikipiha', 19:53:35.742-!!|PROC| 'SP_TYPE': 'M0', 'SP_SOURCE': '2009ApJS..181..444A', 'NOTES': 'Added on 19:53:35.742-!!|PROC| 2024-09-25 07:29:57.963 by spdrs@apikipiha using drs_astrometrics.py', 'USED': 19:53:35.742-!!|PROC| 1, 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| '1468be4997c1809dc621c9560017c815f38ea6355ee1470ae890850be383cb72'}, {'OBJNAME': 19:53:35.742-!!|PROC| 'SVS_20_S', 'ORIGINAL_NAME': 'SVS 20', 'ALIASES': '2MASS 19:53:35.742-!!|PROC| J18295773+0114056|AKARI-IRC-V1 J1829578+011406|CK 1|GCNM 98|GCNM 99|GEL 10|IRAS 19:53:35.742-!!|PROC| 18274+0112|SSTc2d J182957.7+011406|SSTc2d J182957.7+011405|S ... (940 characters 19:53:35.742-!!|PROC| truncated) ... 19:53:35.742-!!|PROC| HMH2007]182|[K99d]1-21|[K99d]4-32|[KOB2004]314|[LFS2014]S12|[OMP2009]146|[P2003]J182957.7+011404|[SVS76]Ser20|[WMW2007]35|IRAS18274P0112|SVS20|SVS 19:53:35.742-!!|PROC| 20', 'RA_DEG': 277.49057, 'RA_SOURCE': '2003yCat.2246....0C', 'DEC_DEG': 19:53:35.742-!!|PROC| 1.234915, 'DEC_SOURCE': '2003yCat.2246....0C', 'EPOCH': 2451545.0, 'PMRA': None, 19:53:35.742-!!|PROC| 'PMRA_SOURCE': None, 'PMDE': None, 'PMDE_SOURCE': None, 'PLX': None, 19:53:35.742-!!|PROC| 'PLX_SOURCE': None, 'RV': None, 'RV_SOURCE': None, 'TEFF': 5900.0, 19:53:35.742-!!|PROC| 'TEFF_SOURCE': 'via spdrs@apikipiha', 'SP_TYPE': 'M4:', 'SP_SOURCE': 19:53:35.742-!!|PROC| '2009ApJ...691..672O', 'NOTES': 'Added on 2024-09-25 18:21:23.025 by 19:53:35.742-!!|PROC| spdrs@apikipiha using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': '2024-10-04 19:53:35.742-!!|PROC| 19:53:22.960', 'UHASH': 19:53:35.742-!!|PROC| 'a917159c414194c9245f0088f43d75097b4d91ffec30aafc7aaf3a087cc6fe20'}]] 19:53:35.756-!!|PROC| (Background on this error at: https://sqlalche.me/e/20/gkpj) 19:53:35.757-!!|PROC| path: <class 'sqlalchemy.exc.IntegrityError'> 19:53:35.757-!!|PROC| Table name: (mysql.connector.errors.IntegrityError) 1062 (23000): Duplicate 19:53:35.757-!!|PROC| entry 'bd6f7bc8f4b07b5a9073fc8b7d51978e20dc209271262b8a72701f22c91e73e6' for key 19:53:35.757-!!|PROC| 'astrom_offline_db.UHASH' 19:53:35.757-!!|PROC| [SQL: INSERT INTO astrom_offline_db (OBJNAME, ORIGINAL_NAME, ALIASES, 19:53:35.757-!!|PROC| RA_DEG, RA_SOURCE, DEC_DEG, DEC_SOURCE, EPOCH, PMRA, PMRA_SOURCE, 19:53:35.757-!!|PROC| PMDE, PMDE_SOURCE, PLX, PLX_SOURCE, RV, RV_SOURCE, TEFF, 19:53:35.757-!!|PROC| TEFF_SOURCE, SP_TYPE, SP_SOURCE, NOTES, USED, DATE_ADDED, UHASH) 19:53:35.757-!!|PROC| VALUES (%(OBJNAME)s, %(ORIGINAL_NAME)s, %(ALIASES)s, %(RA_DEG)s, %(RA_SOURCE)s, 19:53:35.757-!!|PROC| %(DEC_DEG)s, %(DEC_SOURCE)s, %(EPOCH)s, %(PMRA)s, %(PMRA_SOURCE)s, %(PMDE)s, 19:53:35.757-!!|PROC| %(PMDE_SOURCE)s, %(PLX)s, %(PLX_SOURCE)s, %(RV)s, %(RV_SOURCE)s, %(TEFF)s, 19:53:35.757-!!|PROC| %(TEFF_SOURCE)s, %(SP_TYPE)s, %(SP_SOURCE)s, %(NOTES)s, %(USED)s, 19:53:35.757-!!|PROC| %(DATE_ADDED)s, %(UHASH)s)] 19:53:35.758-!!|PROC| [parameters: [{'OBJNAME': '10_LAC', 'ORIGINAL_NAME': ' 10 Lac', 'ALIASES': ' 19:53:35.758-!!|PROC| 10 Lac| S 813A| TRN 36|1RXS J223916.4+390252|2MASS J22391567+3903011|ADS 19:53:35.758-!!|PROC| 16148 A|AG+38 2350|ALS 14844|BD+38 4826|CCDM J22393+3903A|CEL 5 ... (1090 19:53:35.758-!!|PROC| characters truncated) ... 19:53:35.758-!!|PROC| 5|10Lac|S813A|TRN36|10LAC|BD+384826|CEL5504|CSI+3848262|FK5852|HGAM1078|HR8622|JP113513|PMC90-93599|PPM88031|ROT3301|SAO72575|UBV19389|UBVM26533', 19:53:35.758-!!|PROC| 'RA_DEG': 339.8153184, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 39.05024586, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.436831092, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -4.802891782, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 2.787612618, 'PLX_SOURCE': 'Gaia DR2', 'RV': -10.1, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2006AstL...32..759G', 'TEFF': 35200.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:53:35.758-!!|PROC| 'SP_TYPE': 'O9V', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2022-01-31 18:24:17.089 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.758-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| 'fe642c035622dbe3482b908f19fc37ffda174b0e534d71ac56febbaf26b137f9'}, {'OBJNAME': 19:53:35.758-!!|PROC| '11COM', 'ORIGINAL_NAME': '11Com', 'ALIASES': ' 11 Com| HO 52A|ADS 8521 19:53:35.758-!!|PROC| A|AG+18 1179|BD+18 2592|CCDM J12207+1748A|CSI+18 2592 1|FK5 2987|GC 16835|GCRV 19:53:35.758-!!|PROC| 7404|GEN# +1.00107383|GSC 01445-02 ... (641 characters truncated) ... 19:53:35.758-!!|PROC| D116214|TIC72437047|TYC1445-2560-1|UBV11083|UBVM18084|WDSJ12207+1748A|WEB10703|YPAC260|YZ184649|GaiaDR33946945413106333696|GaiaDR23946945413106333696', 19:53:35.758-!!|PROC| 'RA_DEG': 185.1787793, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 17.79325164, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -109.2413803, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': 88.17010164, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 10.71044534, 'PLX_SOURCE': 'Gaia DR2', 'RV': 43.37, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2018yCat.1345....0G', 'TEFF': 4741.0, 'TEFF_SOURCE': '2016A&A...585A...5B', 19:53:35.758-!!|PROC| 'SP_TYPE': 'G8+IIIFe-1', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2023-08-18 15:47:26.028 by nirps-client@maestria using drs_astrometrics.py', 19:53:35.758-!!|PROC| 'USED': 1, 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| 'bd02770667e8d53269bdac76e22cf8764c20b8ba841d071ed149466801674c3c'}, {'OBJNAME': 19:53:35.758-!!|PROC| '15_PEG', 'ORIGINAL_NAME': 'PLX 5288', 'ALIASES': ' 15 Peg|2MASS 19:53:35.758-!!|PROC| J21522991+2847367|AG+28 2571|BD+28 4215|GC 30625|GCRV 13741|GEN# +1.00207978|GJ 19:53:35.758-!!|PROC| 4234|GSC 02214-02037|Gaia DR2 1896396703077703936|H ... (564 characters 19:53:35.758-!!|PROC| truncated) ... 19:53:35.758-!!|PROC| -2037-1|UBVM25978|WEB19470|YPAC212|YZ2812966|uvby98100207978|(F)15Peg|15Peg|15Peg|15PEG|BD+284215|GJ4234|HR8354|ROT3183|SAO90065|UBVM25978|YZ2812966', 19:53:35.758-!!|PROC| 'RA_DEG': 328.1243627, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 28.79327671, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -59.0848435, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -61.64685766, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 36.86280491, 'PLX_SOURCE': 'Gaia DR2', 'RV': 18.921, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2018A&A...616A...7S', 'TEFF': 6452.0, 'TEFF_SOURCE': '2017AJ....153...21L', 19:53:35.758-!!|PROC| 'SP_TYPE': 'F2V', 'SP_SOURCE': '1995ApJS...99..135A', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2022-01-31 18:24:19.330 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.758-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| 'afa8e427656815c7be99f255918be0bf8ff716da44ff9301ae779ffc91f66329'}, {'OBJNAME': 19:53:35.758-!!|PROC| '16_CYG_A', 'ORIGINAL_NAME': ' 16 Cyg A', 'ALIASES': ' 16 Cyg A| 16 Cyg C| 19:53:35.758-!!|PROC| STF 4046A| TRN 4|2MASS J19414896+5031305|ADS 12815 A|AG+50 1407|AKARI-IRC-V1 19:53:35.758-!!|PROC| J1941488+503129|ASCC 271116|BD+50 2847 ... (1211 characters truncated) ... 19:53:35.758-!!|PROC| |16CygC|TRN4|16CYGA|ASCC271116|BD+502847|GJ765.1A|HIC96895|HIP96895|HR7503|JP113128|PPM37671|ROT2839|SAO31898|SPOCS854|UBV16779|UBVM24079|YZ506149', 19:53:35.758-!!|PROC| 'RA_DEG': 295.4529704, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 50.52437636, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -148.299286, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -158.9610583, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 47.2771232, 'PLX_SOURCE': 'Gaia DR2', 'RV': -27.61, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2002ApJS..141..503N', 'TEFF': 5760.0, 'TEFF_SOURCE': '2021AJ....161..134H', 19:53:35.758-!!|PROC| 'SP_TYPE': 'G1.5Vb', 'SP_SOURCE': '1989ApJS...71..245K', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2022-01-31 18:24:21.499 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.758-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| '2d381d81f98c18409e2c76b3f0f765d3725c667cb91370308bcd9e46d10ce49d'}, {'OBJNAME': 19:53:35.758-!!|PROC| '16_SGR', 'ORIGINAL_NAME': ' 16 Sgr', 'ALIASES': ' 16 Sgr| BU 286A| CHR 19:53:35.758-!!|PROC| 255|2MASS J18151297-2023167|ADS 11191 A|ALS 4819|ASCC 1595683|BD-20 5055|CCDM 19:53:35.758-!!|PROC| J18152-2023A|CGO 482|CPD-20 6919|CSI-2 ... (1207 characters truncated) ... 19:53:35.758-!!|PROC| BU286A|CHR255|16SGR|ALS4819|BD-205055|CPD-206919|CSI-2050551|HIC89440|HIP89440|HR6823|Hilt721|MCW632|ROT2574|UBV15500|UBVM22757|YZ1107574|[B10]4613', 19:53:35.758-!!|PROC| 'RA_DEG': 273.8040485, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -20.38797834, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 2.107182839, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.086838205, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 0.4805203893, 'PLX_SOURCE': 'Gaia DR2', 'RV': -11.0, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2004A&A...424..727P', 'TEFF': 31000.0, 'TEFF_SOURCE': 'HEADER[CFHT]', 19:53:35.758-!!|PROC| 'SP_TYPE': 'O9.5III', 'SP_SOURCE': '2014ApJS..211...10S', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2022-01-31 18:24:23.604 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.758-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| 'd137e2e956fce675bac5f75c4a07933b068876f88d67bdc06169d430f1fd8952'}, {'OBJNAME': 19:53:35.758-!!|PROC| '16SCO', 'ORIGINAL_NAME': '16Sco', 'ALIASES': ' 16 Sco|2MASS 19:53:35.758-!!|PROC| J16120731-0832512|BD-08 4180|GC 21784|GCRV 9313|GEN# +1.00145607|GSC 19:53:35.758-!!|PROC| 05612-01227|Gaia DR2 4348404390042854912|HD 145607|HIC 79387| ... (577 19:53:35.758-!!|PROC| characters truncated) ... 19:53:35.758-!!|PROC| V13773|UBVM21247|WEB13423|YZ985629|uvby98100145607|16Sco|16SCO|16Sco|BD-084180|GCRV9313|HIC79387|HIP79387|HR6033|ROT2296|UBV13773|UBVM21247|YZ985629', 19:53:35.758-!!|PROC| 'RA_DEG': 243.0306771, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': -8.547581631, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 44.12551107, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -0.07825370467, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 12.64839489, 'PLX_SOURCE': 'Gaia DR2', 'RV': 5.0, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2006AstL...32..759G', 'TEFF': 8472.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:53:35.758-!!|PROC| 'SP_TYPE': 'A2IV', 'SP_SOURCE': '1999MSS...C05....0H', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2022-01-31 18:24:25.736 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.758-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| '6877df9a59c5a58247072161446517cc747587d61fe5169382378e7a9e4bc797'}, {'OBJNAME': 19:53:35.758-!!|PROC| '17PEG', 'ORIGINAL_NAME': '17Peg', 'ALIASES': ' 17 Peg|2MASS 19:53:35.758-!!|PROC| J21565637+1204354|AG+11 2735|BD+11 4696|FK5 3751|GC 30719|GCRV 13788|GEN# 19:53:35.758-!!|PROC| +1.00208565|GSC 01130-01972|Gaia DR2 2728431923869085056|H ... (505 characters 19:53:35.758-!!|PROC| truncated) ... 19:53:35.758-!!|PROC| C60595351|TYC1130-1972-1|UBV18771|UBVM26010|WEB19513|YZ118738|uvby98100208565|17Peg|17PEG|17Peg|BD+114696|HR8373|ROT3192|UBV18771|UBVM26010|YZ118738', 19:53:35.758-!!|PROC| 'RA_DEG': 329.2347615, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 12.07643382, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -27.50976278, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -12.81550065, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 7.583223795, 'PLX_SOURCE': 'Gaia DR2', 'RV': 10.3, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2006AstL...32..759G', 'TEFF': 9247.0, 'TEFF_SOURCE': '2012A&A...537A.120Z', 19:53:35.758-!!|PROC| 'SP_TYPE': 'A2Vnn', 'SP_SOURCE': None, 'NOTES': 'Added on 2022-01-31 19:53:35.758-!!|PROC| 18:24:27.860 by cook@cook using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': 19:53:35.758-!!|PROC| '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| '26655654dfc60c58b91769d4013cd35684c458adffcfbd8b52d528a86a71580e'}, {'OBJNAME': 19:53:35.758-!!|PROC| '19_CEP', 'ORIGINAL_NAME': ' 19 Cep', 'ALIASES': ' 19 Cep| BU 697A| TRN 19:53:35.758-!!|PROC| 35A|1RXS J220508.8+621647|2MASS J22050878+6216473|ADS 15624 A|AG+62 1306|ALS 19:53:35.758-!!|PROC| 12117|BD+61 2246|CCDM J22051+6217A|CEL ... (1271 characters truncated) ... 19:53:35.758-!!|PROC| |uvby98100209975A|*19Cep|BU697A|TRN35A|19CEP|BD+612246|CEL5432|CSI+6122461|HR8428|JP113454|LSIII+627|PPM23444|ROT3218|SAO19849|UBV18896|UBVM26135', 19:53:35.758-!!|PROC| 'RA_DEG': 331.2866092, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 62.27980148, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': -1.026573736, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -2.493237344, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 1.164795129, 'PLX_SOURCE': 'Gaia DR2', 'RV': -12.3, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2006AstL...32..759G', 'TEFF': 32000.0, 'TEFF_SOURCE': '2018A&A...613A..65H', 19:53:35.758-!!|PROC| 'SP_TYPE': 'O9Ib', 'SP_SOURCE': '2011ApJS..193...24S', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2022-01-31 18:24:32.035 by cook@cook using drs_astrometrics.py', 'USED': 1, 19:53:35.758-!!|PROC| 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| '8784e154f8c1f0953f0b377b0fa3fe0f3cb2bfa65cd9f66178a242560f4ddf57'} ... 19:53:35.758-!!|PROC| displaying 10 of 1444 total bound parameter sets ... {'OBJNAME': 'STKM_1M1262', 19:53:35.758-!!|PROC| 'ORIGINAL_NAME': 'STKM 1-1262', 'ALIASES': 'TYC 3869-496-1|BPS BS 16034-0046|GSC 19:53:35.758-!!|PROC| 03869-00496|LAMOST J153709.49+531919.7|2MASS J15370939+5319205|PM J15371+5319|RX 19:53:35.758-!!|PROC| J1537.1+5319|1RXS J153709.0+531 ... (464 characters truncated) ... 19:53:35.758-!!|PROC| EAJ153709.50+531919.4|2XMMiJ153709.4+531920|[ZEH2003]RXJ1537.1+53191|GaiaDR31597668980175177344|GaiaDR11597668975880498944|GaiaDR21597668980176285824', 19:53:35.758-!!|PROC| 'RA_DEG': 234.2897757, 'RA_SOURCE': 'Gaia DR2', 'DEC_DEG': 53.32193987, 19:53:35.758-!!|PROC| 'DEC_SOURCE': 'Gaia DR2', 'EPOCH': 2457206.0, 'PMRA': 82.34530266, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': 'Gaia DR2', 'PMDE': -93.74985331, 'PMDE_SOURCE': 'Gaia DR2', 19:53:35.758-!!|PROC| 'PLX': 24.46878175, 'PLX_SOURCE': 'Gaia DR2', 'RV': -13.82, 'RV_SOURCE': 19:53:35.758-!!|PROC| '2023ApJS..264...17Z', 'TEFF': 3800.0, 'TEFF_SOURCE': 'via spdrs@apikipiha', 19:53:35.758-!!|PROC| 'SP_TYPE': 'M0', 'SP_SOURCE': '2009ApJS..181..444A', 'NOTES': 'Added on 19:53:35.758-!!|PROC| 2024-09-25 07:29:57.963 by spdrs@apikipiha using drs_astrometrics.py', 'USED': 19:53:35.758-!!|PROC| 1, 'DATE_ADDED': '2024-10-04 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| '1468be4997c1809dc621c9560017c815f38ea6355ee1470ae890850be383cb72'}, {'OBJNAME': 19:53:35.758-!!|PROC| 'SVS_20_S', 'ORIGINAL_NAME': 'SVS 20', 'ALIASES': '2MASS 19:53:35.758-!!|PROC| J18295773+0114056|AKARI-IRC-V1 J1829578+011406|CK 1|GCNM 98|GCNM 99|GEL 10|IRAS 19:53:35.758-!!|PROC| 18274+0112|SSTc2d J182957.7+011406|SSTc2d J182957.7+011405|S ... (940 characters 19:53:35.758-!!|PROC| truncated) ... 19:53:35.758-!!|PROC| HMH2007]182|[K99d]1-21|[K99d]4-32|[KOB2004]314|[LFS2014]S12|[OMP2009]146|[P2003]J182957.7+011404|[SVS76]Ser20|[WMW2007]35|IRAS18274P0112|SVS20|SVS 19:53:35.758-!!|PROC| 20', 'RA_DEG': 277.49057, 'RA_SOURCE': '2003yCat.2246....0C', 'DEC_DEG': 19:53:35.758-!!|PROC| 1.234915, 'DEC_SOURCE': '2003yCat.2246....0C', 'EPOCH': 2451545.0, 'PMRA': None, 19:53:35.758-!!|PROC| 'PMRA_SOURCE': None, 'PMDE': None, 'PMDE_SOURCE': None, 'PLX': None, 19:53:35.758-!!|PROC| 'PLX_SOURCE': None, 'RV': None, 'RV_SOURCE': None, 'TEFF': 5900.0, 19:53:35.758-!!|PROC| 'TEFF_SOURCE': 'via spdrs@apikipiha', 'SP_TYPE': 'M4:', 'SP_SOURCE': 19:53:35.758-!!|PROC| '2009ApJ...691..672O', 'NOTES': 'Added on 2024-09-25 18:21:23.025 by 19:53:35.758-!!|PROC| spdrs@apikipiha using drs_astrometrics.py', 'USED': 1, 'DATE_ADDED': '2024-10-04 19:53:35.758-!!|PROC| 19:53:22.960', 'UHASH': 19:53:35.758-!!|PROC| 'a917159c414194c9245f0088f43d75097b4d91ffec30aafc7aaf3a087cc6fe20'}]] 19:53:35.768-!!|PROC| (Background on this error at: https://sqlalche.me/e/20/gkpj) 19:53:35.769-!!|PROC| Function: apero.base.drs_db.py.Database.add_from_pandas() 19:53:36.109-|PROC| 19:53:36.138-@!|PROC| W[40-003-00005]: Recipe apero_processing has NOT been successfully completed 19:53:36.161-|PROC|

[larnoldgithub]

Is there a way to reset my mysql objdb without touching the other db ?

[larnoldgithub]

with the 288 I can't add a new target anymore or process a target that is still already in the db with the 290, I can't add a new target either. see the issue #785.

[njcuk9999]

Is there a way to reset my mysql objdb without touching the other db ?

Yes apero_database.py --reset --dbkind='astrom' should work

[larnoldgithub]

Ah I didn't remember that recipe. But with the 288 running apero_database.py --reset --dbkind='astrom' did delete the db and re-create it, but it fails with a lot of errors again, as above, with pandas stuff.

I'll do a test with the 290.

[larnoldgithub]

@njcuk9999 as I have a short PI progm from 24A for which the PI is eager to get the reduced data, I'm still trying to fix my 288 and get the data processed. before closing this issue, and switching to 290, I made the following, trying to force the gspread* as we do for the 290:

source /conda/miniconda3/bin/activate
conda activate apero-env
pip install gspread-pandas==3.2.2
pip install gspread==5.12.4
source /apero/config/offline/offline.bash.setup
 apero_database.py --reset --dbkind='astrom'

For the pip install, it seems to work:

(apero-env) spdrs@apikipiha:~$ pip install gspread-pandas==3.2.2
Requirement already satisfied: gspread-pandas==3.2.2 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (3.2.2)
Requirement already satisfied: gspread>=5.0.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from gspread-pandas==3.2.2) (5.11.3)
Requirement already satisfied: pandas>=0.20.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from gspread-pandas==3.2.2) (2.0.2)
Requirement already satisfied: decorator in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from gspread-pandas==3.2.2) (5.1.1)
Requirement already satisfied: google-auth in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from gspread-pandas==3.2.2) (2.23.3)
Requirement already satisfied: google-auth-oauthlib in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from gspread-pandas==3.2.2) (1.1.0)
Requirement already satisfied: cachetools<6.0,>=2.0.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth->gspread-pandas==3.2.2) (5.3.1)
Requirement already satisfied: pyasn1-modules>=0.2.1 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth->gspread-pandas==3.2.2) (0.3.0)
Requirement already satisfied: rsa<5,>=3.1.4 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth->gspread-pandas==3.2.2) (4.9)
Requirement already satisfied: requests-oauthlib>=0.7.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth-oauthlib->gspread-pandas==3.2.2) (1.3.1)
Requirement already satisfied: python-dateutil>=2.8.2 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from pandas>=0.20.0->gspread-pandas==3.2.2) (2.8.2)
Requirement already satisfied: pytz>=2020.1 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from pandas>=0.20.0->gspread-pandas==3.2.2) (2023.3.post1)
Requirement already satisfied: tzdata>=2022.1 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from pandas>=0.20.0->gspread-pandas==3.2.2) (2023.3)
Requirement already satisfied: numpy>=1.20.3 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from pandas>=0.20.0->gspread-pandas==3.2.2) (1.24.3)
Requirement already satisfied: pyasn1<0.6.0,>=0.4.6 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from pyasn1-modules>=0.2.1->google-auth->gspread-pandas==3.2.2) (0.5.0)
Requirement already satisfied: six>=1.5 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from python-dateutil>=2.8.2->pandas>=0.20.0->gspread-pandas==3.2.2) (1.16.0)
Requirement already satisfied: oauthlib>=3.0.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests-oauthlib>=0.7.0->google-auth-oauthlib->gspread-pandas==3.2.2) (3.2.2)
Requirement already satisfied: requests>=2.0.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests-oauthlib>=0.7.0->google-auth-oauthlib->gspread-pandas==3.2.2) (2.28.2)
Requirement already satisfied: charset-normalizer<4,>=2 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib->gspread-pandas==3.2.2) (3.3.0)
Requirement already satisfied: idna<4,>=2.5 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib->gspread-pandas==3.2.2) (3.4)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib->gspread-pandas==3.2.2) (1.26.17)
Requirement already satisfied: certifi>=2017.4.17 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib->gspread-pandas==3.2.2) (2023.7.22)
WARNING: There was an error checking the latest version of pip.
(apero-env) spdrs@apikipiha:~$ pip install gspread==5.12.4
Collecting gspread==5.12.4
  Obtaining dependency information for gspread==5.12.4 from https://files.pythonhosted.org/packages/22/25/7457afe296c3c7ad6ec374c91ecefe3da2c6585fa4b2818e00ee3546a33d/gspread-5.12.4-py3-none-any.whl.metadata
  Downloading gspread-5.12.4-py3-none-any.whl.metadata (8.8 kB)
Requirement already satisfied: google-auth>=1.12.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from gspread==5.12.4) (2.23.3)
Requirement already satisfied: google-auth-oauthlib>=0.4.1 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from gspread==5.12.4) (1.1.0)
Requirement already satisfied: cachetools<6.0,>=2.0.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth>=1.12.0->gspread==5.12.4) (5.3.1)
Requirement already satisfied: pyasn1-modules>=0.2.1 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth>=1.12.0->gspread==5.12.4) (0.3.0)
Requirement already satisfied: rsa<5,>=3.1.4 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth>=1.12.0->gspread==5.12.4) (4.9)
Requirement already satisfied: requests-oauthlib>=0.7.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from google-auth-oauthlib>=0.4.1->gspread==5.12.4) (1.3.1)
Requirement already satisfied: pyasn1<0.6.0,>=0.4.6 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from pyasn1-modules>=0.2.1->google-auth>=1.12.0->gspread==5.12.4) (0.5.0)
Requirement already satisfied: oauthlib>=3.0.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests-oauthlib>=0.7.0->google-auth-oauthlib>=0.4.1->gspread==5.12.4) (3.2.2)
Requirement already satisfied: requests>=2.0.0 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests-oauthlib>=0.7.0->google-auth-oauthlib>=0.4.1->gspread==5.12.4) (2.28.2)
Requirement already satisfied: charset-normalizer<4,>=2 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib>=0.4.1->gspread==5.12.4) (3.3.0)
Requirement already satisfied: idna<4,>=2.5 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib>=0.4.1->gspread==5.12.4) (3.4)
Requirement already satisfied: urllib3<1.27,>=1.21.1 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib>=0.4.1->gspread==5.12.4) (1.26.17)
Requirement already satisfied: certifi>=2017.4.17 in /conda/miniconda3/envs/apero-env/lib/python3.9/site-packages (from requests>=2.0.0->requests-oauthlib>=0.7.0->google-auth-oauthlib>=0.4.1->gspread==5.12.4) (2023.7.22)
Downloading gspread-5.12.4-py3-none-any.whl (49 kB)
   ━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━ 49.5/49.5 kB 535.7 kB/s eta 0:00:00
Installing collected packages: gspread
  Attempting uninstall: gspread
    Found existing installation: gspread 5.11.3
    Uninstalling gspread-5.11.3:
      Successfully uninstalled gspread-5.11.3
Successfully installed gspread-5.12.4
WARNING: There was an error checking the latest version of pip.

unfortunatly the apero_database reset and rebuilt of the objdb fails. I get the same long error in the terminal as before with pandas complaining.

[njcuk9999]

could you try the following:

git checkout v0.7.290-stable-test
apero_database.py --reset --dbkind=astrom
git checkout v0.7.288-stable-test

Maybe that will work (as a hack, this is not recommended in general)

[larnoldgithub]

@njcuk9999 here what we did with @cusher

in /apero/apero-drs Chris ran git stash && git checkout v0.7.290-stable-test to switch to 290, I then tried the command apero_database.py --reset --dbkind=astrom and got instantaneously a lot of errors, starting with

Traceback (most recent call last):
  File "/apero/apero-drs/apero/core/constants/path_definitions.py", line 75, in __init__
    raise drs_exceptions.DrsCodedException('', 'error',
apero.core.core.drs_exceptions.DrsCodedException: 01:07:53.905-**|DrsBaseError|E[] BlockPathError: Key DRS_DATA_OTHER does not exist
    Path=/drs/spirou/data/other

and to switch back he did git checkout v0.7.288-stable-test && git stash pop

[njcuk9999]

Okay sorry I forgot there were some changes in v0.7.289 that mean you can't do this.

I think the best option would be to create a new v0.7.288 profile and then in MySQL copy the astrometric database from one to the other

The process I imagine would be like this (though might be worth checking with @cusher):

1. make a new v0.7.288 profile using setup.py (make sure the database table goes to the same place as your other v0.7.288 databases
2. go into MySQL i.e. mysql -h {hostname} -u {username} -p then enter password
3. check the table names you have:

   show databases;
   use {spirou database};
   show tables;

4. delete the original astrometric table: DROP TABLE {my_old_astrom_table}
5. create a new version of the old table: CREATE TABLE {my_old_astrom_table} LIKE {my_new_astrom_table};
6. copy the data into the old astrom table: INSERT INTO {my_old_astrom_table} SELECT * FROM {my_new_astrom_table}

This all assumes you can create a table in v0.7.288 in a new profile - if you can't it means we still have a duplicate problem in the online table and should fix this

[cusher]

Creating a new profile w/ v0.7.288 also failed:

19:05:02.643-**|RESET| ==================================================
19:05:02.672-**|RESET| Assets directory:
19:05:02.698-**|RESET| ==================================================
19:05:02.712-  |RESET|   Resetting assets directory
19:05:07.563-**|RESET| Updating object database (from google sheets)
19:05:17.423-!!|RESET| 19:05:17.417-**|DatabaseError|E[00-002-00047] Pandas.to_sql <class
19:05:17.423-!!|RESET|  'sqlalchemy.exc.IntegrityError'>: (mysql.connector.errors.IntegrityError) 1062
19:05:17.423-!!|RESET|  (23000): Duplicate entry
19:05:17.423-!!|RESET|  'bd6f7bc8f4b07b5a9073fc8b7d51978e20dc209271262b8a72701f22c91e73e6' for key
19:05:17.423-!!|RESET|  'astrom_288fresh_db.UHASH

(loads more here)

19:05:17.439-!!|RESET|  Function: apero.base.drs_db.py.Database.add_from_pandas()
19:05:17.576-**|RESET| ***************************************************************************
19:05:17.592-@!|RESET| W[40-003-00005]: Recipe apero_reset has NOT been successfully completed
19:05:17.608-**|RESET| ***************************************************************************

Error resetting database (see above) cannot install apero

[larnoldgithub]

@njcuk9999 there is another duplicate issue in the objdb, spotted by Chris in the pending list line 53 should be removed, same as 80 (LSPM_J2049...)

[njcuk9999]

okay that is probably the problem, maybe your original v0.7.288 will work now when you reset it.

Note in future there is no problem between a duplicate entry in pending vs main - this should be the proper way to "amend" an old object that needs updating - its just a few of the v0.7.28X versions seem to not like duplicates.

[njcuk9999]

Okay since there seems to be no way round this I've tried to isolate the code in v0.7.290 that fixes this.

Try a git pull in branch v0.7.288-stable-test and see if it works

you'll have to reset the object database with:

apero_database.py --reset --dbkind=astrom

Let me know if it works