search

wfau / ScienceArchives

0 stars 0 forks source link

2 entries for Var YSOs, in ExternalProduct: version 1 and 2. #651

Open wfastrononomer opened 1 week ago

wfastrononomer commented 1 week ago

|>| 130 | ysoVar | vmc team catalogue data for ysoVar products, version 1 | Keele UK | V. Zivkov | 1 | /VMC/VarYSO/20240809 | zivkov20_table3_mod.csv | -9.99999e+08 | NONE | VSA_vmcTeamCatalogueSchema.sql | vmcYSOVariables | 1 | NONE | 35 |<| |>| 130 | ysoVar | vmc team catalogue data for ysoVar products, version 2 | Keele UK | V. Zivkov | 2 | /VMC/VarYSOs/20240809 | zivkov20_table3_mod.csv | -9.99999e+08 | NONE | VSA_vmcTeamCatalogueSchema.sql | vmcYSOVariables | 1 | NONE | 36 |<|

Put check in to avoid this. Must be different directory path for new version.

wfastrononomer commented 5 days ago

I think I have fixed this. Do more checks

tms-epcc commented 3 days ago

20/NOV/24

wfastrononomer commented 3 days ago

I think this is still an issue. Do repeated runs and see what is happening.

wfastrononomer commented 2 days ago

e.g. select productID,programmeID,productType,releaseNum,directory from ExternalProduct where programmeID=130 and productType like '%pm%'

| 41 | 130 | pmCat | 2 | /VMC/PM/20240307 |<| |>| 42 | 130 | pmCat | 3 | /VMC/PM/20240307 |<| |>| 43 | 130 | pmCat | 4 | /VMC/PM/20240307 |<| |>| 44 | 130 | pmCat | 5 | /VMC/PM/20240307 |<| |>| 45 | 130 | pmCat | 6 | /VMC/PM/20240307 |<| |>| 46 | 130 | pmCat | 7 | /VMC/PM/20240307 |<| |>| 47 | 130 | pmCat | 8 | /VMC/PM/20240307 |<| |>| 48 | 130 | pmCat | 9 | /VMC/PM/20240307 |<| |>| 94 | 130 | pmCat | 10 | /VMC/PM/20240307 |<| |>| 96 | 130 | pmCat | 11 | /VMC/PM/20240307 |<| |>| 116 | 130 | pmCat | 12 | /VMC/PM/20240307 |<| |>| 117 | 130 | pmCat | 13 | /VMC/PM/20240307 |<| |>| 118 | 130 | pmCat | 14 | /VMC/PM/20240307 |<| |>| 119 | 130 | pmCat | 15 | /VMC/PM/20240307 |<| |>| 120 | 130 | pmCat | 16 | /VMC/PM/20240307 |<| |>| 121 | 130 | pmCat | 17 | /VMC/PM/20240307 |<| |>| 122 | 130 | pmCat | 18 | /VMC/PM/20240307 |<| |>| 123 | 130 | pmCat | 19 | /VMC/PM/20240307 |<| |>| 124 | 130 | pmCat | 20 | /VMC/PM/20240307 |<| |>| 125 | 130 | pmCat | 21 | /VMC/PM/20240307 |<| |>| 126 | 130 | pmCat | 22 | /VMC/PM/20240307 |<|

Rows returned: 22 (execution time: 0.00187993 s)

Not good!