Registry api /species/{int}/vernacularNames sometimes does not include source about gbif-api HOT 6 CLOSED

Yes, this is a (data) bug. For some reason the cached dataset table in ChecklistBank is missing some entries.
For example DAISIE - Inventory of alien invasive species in Europe

from gbif-api.

select distinct dataset_key from name_usage where not exists (select 1 from dataset where key=dataset_key);
returns 250 missing datasets:

0010c4e6-f37b-40c6-a2fc-f03234cd0a1e
00e1114c-84e6-49b9-bd27-c3e7221f5a8b
017027f2-09c7-4bc9-af88-f791e15ea4cf
02095cb3-3b8d-4051-8a03-fd98f1017c4a
02c8367f-2b3a-46d1-bf9a-d15c89a3b0be
02e373f0-3ec6-464c-8dfb-59b60cd744a0
03b915ab-1004-4f9c-872e-12958eb23182
04d590f7-68b2-490d-b7ea-732cf66eadee
05bfbfda-770f-4e84-8686-fdf5366c1b9a
07029e9e-48af-4335-a3cd-3130a372a562
0863cdca-59a2-4549-a67b-5c86d9133e6d
08fefa83-10c2-4720-b724-3542e6c8a3c5
0ad6ecdc-c381-4bf4-bc75-164c6c9622cb
0b08c1b1-7031-4c21-acaa-8806048a5380
0df60ac3-92fe-491e-ba26-40d2db665a4e
0e8e83dc-0745-41ad-a372-0fc5cdc03749
0efcada5-1b2c-45cf-bb56-73f4909b5c74
1042ebd4-abca-4d3c-bf36-47b0438c4da1
12c52018-f40f-455c-9e93-836808d3b087
133114e1-dc8b-49d9-8437-ad32020adbea
14ce5f63-3eba-4771-901c-128c773717b5
16ecd65e-f5f0-46e4-a1e0-5b83692a7a49
195fa4b8-0cfa-4f61-b6b1-3a949817b2aa
19a23a7c-4113-4ab0-a548-2092e2216069
19f437c5-bfb5-4223-b662-c45fd7003ebf
1a228008-86f6-4ef1-aa12-28370f86cba0
1b360105-050e-4952-b964-04d9d17c2aa1
1be97f7b-7b0b-439c-ba43-140e04e3d2f2
1c1a4f5c-d754-41f9-88ee-0cc4f547dd77
1dd566b6-ef14-497a-92ce-e7481e3ade98
1ddeda5d-37cb-4479-980c-b49110c3169d
2090f066-c5ef-4aca-90c2-6b267c3ef848
2142abc6-bc6a-4cfd-a320-034c3b6add4e
21741f30-812d-45b7-a766-cdc7e81c32b3
23efa703-6ecd-447c-9309-193c2e021770
24c8554d-e477-4440-8e3f-17af20c1ddc8
24f01fb7-9777-4a53-94d6-71a7a926267a
254d6805-35a0-4114-adfa-c9af4059402a
289244ee-e1c1-49aa-b2d7-d379391ce265
2a05f92b-5125-41c8-ba0d-df4afd5c8e3d
2a24e436-e4af-4820-89c1-656c283760a8
2a809cd9-f17a-4eea-8eb0-ad8f2ee0ef91
2c2cf784-9710-4201-b23e-a7b768af5567
2cafda19-2ab0-45b3-8f5c-05c23d091180
2f6f78b7-1b17-4886-911c-53f10ddb79f2
3099cbb5-2a81-4b55-8401-69313f7a1532
326e2089-b52a-4b6c-b2fe-05af5cc8644e
34edffff-49a3-4399-9eb8-f277e190b6a7
36935fa7-a68c-4fd7-bfb3-afd9737f18b6
37a397a9-1193-4ad9-b060-3fbcd340e923
392032dc-a6b7-4c26-82c8-21c2f93304a1
39256adf-7987-46d7-ab43-998df5970e5c
3996d4b6-345e-4db4-a214-4729d5844552
39f36f10-559b-427f-8c86-2d28afff68ca
3a1e4b25-1608-4a3a-9c80-84e16c937807
3acd6fb6-afce-49a3-a70d-070d4250229b
3b51725f-e873-48d2-918c-bb926e54a7b7
3cd73963-ae34-49eb-b8de-d7e914349840
3f01a867-8b43-446c-83f8-aa2dc2e6d682
3f040435-a70c-49ec-ae9a-07df11b91f4a
40d79a03-eca2-4e36-aed2-e9fbaad785ec
43d5c4f8-1712-4413-9dce-4d401ec9c0a4
43f393b8-6c05-4861-9b7c-2f7f1a169d10
44b432cb-4965-47ea-8ca8-ff039e214ae8
46f14143-5170-4760-b3f2-9452ed80bdaf
478d0311-8526-4f05-8407-43a3629a13b0
49d45069-6150-4b6e-873c-fc8058025a39
49eab955-d6ae-4253-bae3-ab650f77fcfc
4a3d31ca-e16b-4ccf-8407-231aa27702f1
4a792ded-d181-427a-9d49-e7ef16cc7a9a
4c2a0a0d-f675-438e-bf2e-9f6134eadf31
4d17c805-4ede-480f-8026-c22d787b4382
4dbc9b69-b03d-463e-8476-ac370c0d0e08
4e9d76c0-f3b8-45ba-9bf0-dd2befc0f72a
4f0fe7b5-a5d5-44ed-be63-d454acf3c0cb
50efd98b-e1f4-447d-8cc5-917eaf6f435a
55c418be-eacf-4249-93c5-2f563258330b
563f68d5-7547-4bf1-8a3d-d37418a6b0ce
5855eade-aff4-47f0-8015-c267a07a45ae
59741896-2be9-4bf8-9d81-b5621375357b
59c402c8-8173-4274-a378-6f81c0f6cf85
5b436602-7dfa-4336-8dff-24debf9bf16c
5b6f46f3-e85e-4396-9b23-ea30c66081ba
5b78366e-1b6c-4154-ad68-bd9f7e70a536
5bd0d5fb-f0d7-41cc-96af-c48ac8ecd35d
5bf10f28-f0b1-40de-9df6-ac9d8ba22480
5cb64c13-76bb-45f3-9a12-c2413c64c537
5ce053ba-431c-4fc5-83ea-1b8c389fe55f
5ce06218-5f10-4f06-bb4b-882e13d24898
5d898c9f-4cb8-435e-945a-bcf8dcedd3a8
5ddee453-14a5-41ea-bd4d-046468d3651f
5e0132df-f45f-4983-abb0-620aa0f8c257
5eff0024-3ffb-46dc-99bc-795de27fa33b
6008c127-eb17-4f05-8717-257e97a8f368
619e0b96-ba2b-4552-98a7-cdacb88d03e3
619fa7b8-818a-46d7-a31b-32563fb6bb3f
621a93ac-5768-4dc0-9a7f-0c7916d2de20
631a39f7-40d8-47fa-96e0-d04aa885c01e
6393671a-5381-4c30-b7f4-425e24682852
6433b7b7-e1e4-4638-a186-88f89473b9d4
6446fee7-99f6-43cd-b37a-bb6ce3fade53
65f216f4-26f1-4a26-8656-1463b9fcaf01
6688af4f-a096-476e-afbd-77a15285c16c
66fa7f6e-6969-4288-a57c-be68c1c9a87c
6ac34a7a-5610-46f7-b291-46633a61a3c6
6b67185d-1e5e-414a-acc9-54e613b86464
6d726d36-043e-4f11-885e-19423f04957a
6fe68ec7-4966-41aa-8e1d-f91a68be1a0d
71a7456d-0cfa-4a39-8b34-1432dde24b02
7245b739-d300-49ee-b17f-b972f1a65aa5
72f57e78-d531-481f-935e-8ab604837d7d
75f2f9b8-eb81-4a9b-9651-7400fac607aa
762114a7-e97f-488a-816d-cc8c801c1ec4
776234fd-f2e3-4cf5-b9ab-12f5420cdd87
77ddb401-f900-43de-8ea2-fbb15f8aae16
782896dd-8191-40e1-beff-66588d05bc74
799cf10e-6ad8-4df5-b810-08356ab2a748
7b6c18a6-d29a-444f-a849-7a6eea05c2d7
7b7d3eba-3a2e-4496-8e41-2773ed400854
7fcc91e2-3f4d-4de8-a3a5-3a53692b3ab5
8004ac24-5295-475a-85c8-bbf2b651c671
80d90cb1-3b57-463b-896d-f613e25a4e7f
80fec9f5-82b3-487c-a1e9-6fc1d034a371
8214b5e5-1f17-4d4b-93eb-e7e0c383ab6e
8347f9a9-487b-4375-82a4-79c0b4b6767d
83aee115-7c59-468b-9b30-92d14b7add82
83c4097e-3253-42a5-a0a4-90907685d5bf
844fafcf-8f84-4039-ade1-7a03eadaf1d4
882f5e2c-f717-486b-85b3-80679ce2ee73
8b81eb75-a4c5-4c07-9853-26e1a5fb2851
8d431c96-9e2f-4249-8b0a-d875e3273908
8d6c3233-4503-416a-8525-9901206c6557
8fdb5455-17c4-46c6-bdf4-78926b5850f7
90327333-dbf7-4a3e-9a7e-7c2fd259d963
911ecd53-56b9-4c32-b948-7aec22113775
92c8b1bd-65cf-4017-84ff-0efd3ad54eae
939628c7-8768-469d-b88a-d4ddfe9e7a68
93bc2dc6-a9c6-40c0-a0fe-616926cc8ff1
95b0e1a1-4c8f-42ae-9036-94795ead1186
965c4bbe-fbd6-4b4a-b918-b75b8b133efb
96ff3b8d-54ff-4a26-902b-1cac861c3cbe
978ec4b3-8d0e-4f47-8084-610b34b96759
97d3beda-ceba-4422-8787-79e564142fea
9823b3d4-a8ba-4196-b924-02bf807b4d61
98940a79-2bf1-46e6-afd6-ba2e85a26f9f
98bfb263-56ab-4260-8fb0-1bb6eaadbd02
991d3cda-9d4f-4daa-b869-bf15935c1842
9948103c-ea55-4019-9121-b84c3c365e75
9ab4daf3-90f8-4233-bbcd-bb6f447b5164
9ae1ea74-b6cc-4177-ac74-376cff37fea8
9bd8f79a-7f9f-4b4c-9e70-57318f77cfc0
9eca2868-5d64-414e-9905-29f3725d5ae9
a0cd032c-e3a1-4f69-b7c3-0a20554bb228
a0f59fa8-a6be-433a-8405-00170761a6e1
a1481992-dbc6-4d01-b03f-f414260ec51b
a18506ae-da47-4ffe-a21f-995397e961f7
a4428250-3666-4650-9e79-cf02106811ae
a47a335d-4658-4a6d-ac1d-5d5ac841f199
a5562c36-5c76-4b1b-9278-b0d3ce04c20e
a63fbcd8-64c4-4c81-9ea0-c0e45577c7ad
a6bd3b38-516d-45bd-a4f9-a3354e99d122
a72e9038-90bd-459c-807f-d562802a6593
a879fa2f-9c16-46b2-bd3e-2f3c17ed4c19
a96b3ef7-5c39-4d0b-8d35-43706a9802c0
ab9b5bbb-4f34-41c7-8465-672e93791aae
ac6c9e7c-6e97-47f5-a163-e21ab8c840b8
ac9a4b1b-b3d2-4bb0-9ed3-0232012e96c2
acfb224c-fedb-44c4-a849-a1fbe7c8fec0
ad48110e-417d-4c0c-81e8-c1965f64a811
ad58c550-749d-414a-a85c-f49251e328c0
aea50ad9-93cb-417c-9a2b-556f5223f23a
af08637c-3c84-42d2-9b58-a3c88c5b6e28
b03462cb-d252-40aa-976d-e421f49a3ded
b0d5590c-66a9-4126-b2b2-04eaf78f0b7a
b0ddb79b-fd6d-499f-8626-80a64b39fb06
b1a5930e-246e-4123-a748-f89ebb8a9cf3
b20ecce6-c5fa-4dd9-9a1d-9d22fae2826a
b267ac9b-6516-458e-bea7-7643842187f7
b3769dec-b557-4f35-b5dc-c55ae451e43b
b4b2b894-205d-4787-bb50-257c53155a65
b5540ef3-598a-4f52-84c6-eec946bbf32a
b5b7f31d-a51a-41ab-9339-d955990a7a2e
bb8db045-2674-4e59-ac63-d1f909d1dcfb
bba007ee-151d-47e5-9114-cd906a109bdb
bbc149f3-3578-4ae7-a13c-5d22f00a8768
bd59d82f-d7dd-477b-be36-854fa2512013
bdc12bce-f24c-4713-8026-a1aee4193ef5
be130475-bfb1-47fc-9790-98596a726b24
be6c7133-d160-49c1-aa22-4031e2276ed0
bf522066-d756-4fe2-be4d-d2b6b170562e
c147d251-d362-415c-934f-bffe5e85000c
c334310a-79e7-4182-862e-566e19c52037
c39a06fe-b5fd-42ed-9fde-312b590bab52
c3a4486e-bb74-4f26-9f53-2e918d10d8d2
c65f17da-ddda-4efe-b5c9-264f855f20e1
c7af6db8-80a7-45c0-9905-08c7ce3b5827
c97016b0-24b2-404d-b54d-f85e04d55672
ca571051-a81b-44d3-9c71-35c50a927bf5
cc092c5e-54a2-40d3-a34f-ce0d71bb7d3b
ccbd7793-81c7-4fec-aa3b-787a6f43bf75
cd0655f9-d43c-4244-8538-f69ca836da36
cd174407-5632-4090-ba61-9ff3fe41bc03
cd8c1df0-d3cd-4d23-804a-54b2ca87f63a
ce397603-2e1b-45d7-a660-ab4771887774
d099762b-e620-43a2-984b-93c58c41bca7
d0adfdd0-4c63-45fc-9d32-2b17420027ca
d1b8f315-e6cb-4d0e-8c35-77f8ef5786a7
d2ead34b-03f2-45e2-beb9-63c59f6a21cb
d3fcc3d8-efcc-4afd-b0ec-8ca1e19caf27
d603a743-e7ee-4bd2-a084-f77a19713ae3
d7068326-e029-48e7-a0e6-b13e06d18d8b
d7f1d8bc-6c4b-4ddf-a4a2-a4166e9ab0b7
d873f9a9-94e3-4a74-ace7-e536c7bf1721
d959a126-44a7-428d-b4ae-c14268d615a6
d9953b25-4b14-437c-aecf-1ccb60e8d698
db165956-43bc-4a36-bc9e-266d6b721561
ddf01fc8-a165-492e-aa9a-25316f7f4ab6
de92c6c1-5e54-433d-a725-89c348d639c6
e01a3a46-9e8c-4866-b9f7-53f9ec24ba66
e04784c0-e17d-4682-bc2c-3a901e9fce63
e1c3be64-2799-4342-8312-49d076993132
e2523490-1c71-4e99-ba9c-5e3f6c3989dc
e3553d4d-c82d-4f42-bca5-3d83f38c030c
e3eb548e-fa57-4a0e-8d2d-5e299b5b136e
e4d6c5d0-8470-438a-93a6-1ae3eef750b1
e6615626-7b1a-4ec9-a1fb-a2891b10da6a
e741b139-013c-457b-86e2-f08bc01449aa
e742d32b-6995-490d-8b80-0e21dbc82d02
e8e5dd5b-b0ad-461c-981a-ef8ee190a315
e9fb53be-c235-4070-986a-33faea0919e5
ea237bbb-b6cf-443f-bd94-36e49a926620
eb9cfc36-2b27-408f-b08a-e32d95cd3420
ec93a739-1681-4b04-b62f-3a687127a17f
eeaba26d-91f6-41e6-b88a-373c047d47cf
ef85928f-5415-43ef-9f52-4731114085de
efd6153b-d8ba-4e70-ab90-1a27ab696e11
f0b60062-33ae-4461-b3bf-39ec4b82cf26
f3187ddd-f79a-43d2-9692-e101210783bf
f463aada-9f40-4254-84a5-3f86928f35d3
f4caaccd-57e2-4202-b148-f0c8f7191959
f5354607-a2d4-4cb1-b4b4-5ba7ea4d212e
f59e1e92-ed51-43e7-8a5b-6b12f19b37e2
f5f6ed19-d463-4236-9557-0d5a1d138aed
f94dcbe7-79ce-4dc6-8061-97e56f8bbbff
f951894a-49a5-4519-aa91-6d4bdcb10820
fb507bc4-0a9b-4caf-8f1e-d9d34aa6cd8e
fbc5073c-f6bc-41f4-aacd-3f5c8cdb16c8
fbeb92be-3725-4897-bfbf-969aba9f23a1
fcc67b83-24e3-4169-868c-070b670a1633
fd03f669-c046-46cd-861a-6bf56b7fc989

from gbif-api.

Updated the clb dataset table with the missing 250 records.
When Varnish is flushed the API should return a source for all vernacular names from the Backbone again.

I've also tested the registry change listener which is working properly, all changes and new dataset make it through to CLB. Must have happened during downtimes

from gbif-api.

Good API vernaculars from DAISIE here: https://api.gbif.org/v1/species/2706236/vernacularNames

from gbif-api.

Issue also reported at gbif/portal-feedback#2921

from gbif-api.

Thanks for fast fix.

from gbif-api.