Skip to content

Instantly share code, notes, and snippets.

@rhb2
Last active January 13, 2021 04:04
Show Gist options
  • Save rhb2/c58f3bdbcdf15ec25768fb79d88ef6ff to your computer and use it in GitHub Desktop.
Save rhb2/c58f3bdbcdf15ec25768fb79d88ef6ff to your computer and use it in GitHub Desktop.
1734.stor
32edcc12-778e-46e9-a864-e570f9d723f0=# select distinct assignment_id,dest_shark,skipped_reason from (select assignment_id,dest_shark,skipped_reason from evacuateobjects where skipped_reason is NOT NULL) as foo order by dest_shark;
assignment_id | dest_shark | skipped_reason
--------------------------------------+----------------------------------+-------------------------
d2c91df2-f6b1-4fe2-a007-5dc34cc9245d | 1023.stor.eu-central.scloud.host | destination_unreachable
c5291fbf-5218-41e5-b8bf-991e538a52a6 | 1032.stor.eu-central.scloud.host | source_other_error
db6e4ab4-9892-4823-8b48-085544083e9f | 1118.stor.eu-central.scloud.host | source_other_error
eef43f7c-86d8-44db-8ac1-334948d37c99 | 1136.stor.eu-central.scloud.host | agent_fs_error
20d15f1a-7b55-466a-845d-c62f7ade0537 | 1138.stor.eu-central.scloud.host | {http_status_code:404}
82ae90d7-06cd-4890-874c-93bb324621a4 | 1231.stor.eu-central.scloud.host | agent_fs_error
8de5f6cf-339e-482a-8c16-ea3a06d391fa | 1231.stor.eu-central.scloud.host | destination_unreachable
96070c6c-90f7-471f-95d7-b0704f61ab20 | 1231.stor.eu-central.scloud.host | network_error
ae04610b-fcf8-4044-bddb-15e02a492b85 | 1231.stor.eu-central.scloud.host | agent_fs_error
bafc669a-953e-42dc-aecc-8e5a2b11dc55 | 1231.stor.eu-central.scloud.host | agent_fs_error
e0174777-8304-43d1-a05d-962e06745eff | 1231.stor.eu-central.scloud.host | agent_fs_error
75bee662-abdd-4f19-aa19-acaf35c7c6b0 | 1303.stor.eu-central.scloud.host | agent_fs_error
380bb6e8-414a-4bda-a847-ecdcdde9bbda | 1603.stor.eu-central.scloud.host | source_other_error
3c86fcf3-a989-4ef6-96f6-048b976bf2a8 | 1603.stor.eu-central.scloud.host | agent_fs_error
4bb02a32-0c24-4780-8e11-4a9d3be1a5bd | 1603.stor.eu-central.scloud.host | network_error
6d27d088-de75-4c8b-89c2-8ccd7eb85697 | 1603.stor.eu-central.scloud.host | source_other_error
84a5cd7c-8213-40ed-b55e-b9c23b26c076 | 1603.stor.eu-central.scloud.host | agent_fs_error
84a5cd7c-8213-40ed-b55e-b9c23b26c076 | 1603.stor.eu-central.scloud.host | source_other_error
8f67bdd9-388c-4948-9288-7d1e0397c745 | 1603.stor.eu-central.scloud.host | source_other_error
bc3be1c9-15df-4f7b-83f0-9f91f915e5f4 | 1603.stor.eu-central.scloud.host | agent_fs_error
bc3be1c9-15df-4f7b-83f0-9f91f915e5f4 | 1603.stor.eu-central.scloud.host | source_other_error
cc92f988-9812-44cf-8b0b-5705b01bac31 | 1603.stor.eu-central.scloud.host | agent_fs_error
cc92f988-9812-44cf-8b0b-5705b01bac31 | 1603.stor.eu-central.scloud.host | source_other_error
ccfb330e-c65b-4291-8d75-435dd815b681 | 1603.stor.eu-central.scloud.host | agent_fs_error
ccfb330e-c65b-4291-8d75-435dd815b681 | 1603.stor.eu-central.scloud.host | source_other_error
f6499a39-e7ee-453a-9ef7-831042326139 | 1603.stor.eu-central.scloud.host | destination_unreachable
0d6b9158-a04d-4db3-8852-f94e9599422f | 1777.stor.eu-central.scloud.host | source_other_error
1040a476-1aa8-495d-bd85-db473618f18d | 1777.stor.eu-central.scloud.host | source_other_error
23bfa5b0-c9cc-4bdc-8d50-534af20e775d | 1777.stor.eu-central.scloud.host | source_other_error
24a8903b-a96c-4e88-aa3a-b9a083dd6795 | 1777.stor.eu-central.scloud.host | source_other_error
339b6da6-8196-4271-8b4c-0ffefac85a66 | 1777.stor.eu-central.scloud.host | source_other_error
34f4d9d5-4a81-4c3a-a136-b74c3f746634 | 1777.stor.eu-central.scloud.host | destination_unreachable
3cb5b5f4-c209-4951-8266-b5e70e98684a | 1777.stor.eu-central.scloud.host | source_other_error
3fb1d5f6-4d61-4875-aa91-153eae30c960 | 1777.stor.eu-central.scloud.host | source_other_error
62648a85-0450-4cf2-9ab8-b9f5c67d0337 | 1777.stor.eu-central.scloud.host | source_other_error
772cfc51-6292-48af-b99a-97f77aecc4ae | 1777.stor.eu-central.scloud.host | source_other_error
78de08e8-72b5-4a90-acd3-9ff0ec0349ad | 1777.stor.eu-central.scloud.host | source_other_error
7fd08b9f-158c-47b7-b464-e6c13100ba3a | 1777.stor.eu-central.scloud.host | source_other_error
80098884-05cb-4c25-825e-50702954f2ad | 1777.stor.eu-central.scloud.host | network_error
8522b0ae-b782-42fe-b577-ee75f59038cc | 1777.stor.eu-central.scloud.host | source_other_error
885bdece-da03-4dbc-94ea-6ba1872f0621 | 1777.stor.eu-central.scloud.host | source_other_error
9d413983-b548-44b0-bfd7-7fe57d080d5a | 1777.stor.eu-central.scloud.host | source_other_error
ac3f16e2-24c2-46fe-988d-b5e364077902 | 1777.stor.eu-central.scloud.host | destination_unreachable
adfb01e6-003b-49dc-a6a3-14e323d02cf4 | 1777.stor.eu-central.scloud.host | source_other_error
b55884e1-28b9-43ec-9ef4-9db407797db4 | 1777.stor.eu-central.scloud.host | source_other_error
b5ea7b6d-68f3-41da-8270-c61e4768fd7f | 1777.stor.eu-central.scloud.host | destination_unreachable
c3d8c487-08f5-41bd-8aaf-57716fb30cf0 | 1777.stor.eu-central.scloud.host | source_other_error
c6b1516b-c081-4c96-b6ef-6c3b5fe85762 | 1777.stor.eu-central.scloud.host | network_error
ca87331c-182e-4dca-8529-e6f7e0115b96 | 1777.stor.eu-central.scloud.host | source_other_error
d331fe32-922b-408b-8489-c9f886e4c361 | 1777.stor.eu-central.scloud.host | source_other_error
dc087da1-4246-4778-a1a8-a921e3e9388f | 1777.stor.eu-central.scloud.host | source_other_error
dc4b35d2-01c2-4db5-8e51-e8677709d3d7 | 1777.stor.eu-central.scloud.host | source_other_error
e223f880-b6f0-4ba8-bc02-a70a6439293a | 1777.stor.eu-central.scloud.host | source_other_error
e6a3388b-cb60-4ac2-b969-d11af98fe4b2 | 1777.stor.eu-central.scloud.host | source_other_error
fe026f6f-e1a7-4a0b-9d34-2e7ec0878b86 | 1777.stor.eu-central.scloud.host | source_other_error
181adfe0-cd6a-42d4-8e2e-a7a58bbd8cc2 | 1828.stor.eu-central.scloud.host | source_other_error
8404dff4-5abe-4731-85c5-60c220e83516 | 1828.stor.eu-central.scloud.host | source_other_error
(57 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment