Page MenuHomeSoftware Heritage
Paste P1049

weaver flapping between two snapshots
ActivePublic
Actions

Authored by olasd on May 21 2021, 6:44 PM.
```
> select * from origin_visit_status where origin=(select id from origin where url='https://bitbucket.org/pbui/weaver') order by origin,visit,date;
origin │ visit │ date │ status │ metadata │ snapshot │ type
────────┼───────┼───────────────────────────────┼─────────┼──────────┼────────────────────────────────────────────┼──────
694079 │ 1 │ 2020-07-15 11:39:31+00 │ created │ ∅ │ ∅ │ hg
694079 │ 1 │ 2021-05-21 15:47:29.965923+00 │ full │ ∅ │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ hg
694079 │ 2 │ 2020-07-15 11:39:31+00 │ created │ ∅ │ ∅ │ hg
694079 │ 2 │ 2021-05-21 16:28:02.833232+00 │ full │ ∅ │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ hg
694079 │ 3 │ 2020-07-15 11:39:31+00 │ created │ ∅ │ ∅ │ hg
694079 │ 3 │ 2021-05-21 16:29:00.684835+00 │ full │ ∅ │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ hg
694079 │ 4 │ 2020-07-15 11:39:31+00 │ created │ ∅ │ ∅ │ hg
694079 │ 4 │ 2021-05-21 16:30:55.454104+00 │ full │ ∅ │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ hg
694079 │ 5 │ 2020-07-15 11:39:31+00 │ created │ ∅ │ ∅ │ hg
694079 │ 5 │ 2021-05-21 16:32:23.679522+00 │ full │ ∅ │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ hg
694079 │ 6 │ 2020-07-15 11:39:31+00 │ created │ ∅ │ ∅ │ hg
694079 │ 6 │ 2021-05-21 16:33:25.562672+00 │ full │ ∅ │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ hg
694079 │ 7 │ 2020-07-15 11:39:31+00 │ created │ ∅ │ ∅ │ hg
694079 │ 7 │ 2021-05-21 16:38:49.748528+00 │ full │ ∅ │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ hg
(14 lignes)
Temps : 9,616 ms
> select * from snapshot inner join snapshot_branches on snapshot.object_id = snapshot_branches.snapshot_id inner join snapshot_branch on snapshot_branch.object_id = snapshot_branches.branch_id where snapshot.id in ('\x3ab281eb47131a75efb4330e344da59c86013a9e', '\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed') order by snapshot.id, name, target, target_type;
object_id │ id │ snapshot_id │ branch_id │ object_id │ name │ target │ target_type
───────────┼────────────────────────────────────────────┼─────────────┼───────────┼───────────┼──────────────────────┼────────────────────────────────────────────┼─────────────
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597351 │ 9597351 │ \x302e302e35 │ \xdaf39e9ce6afbfdce4a14f2320dbe63d11513d74 │ release
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597352 │ 9597352 │ \x302e302e36 │ \xf6ea0d6573dda510dfe4dbb5fd0a8b6278e934e3 │ release
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597353 │ 9597353 │ \x302e302e37 │ \x0ea8f6656b0540db0b9bc55d046eec8b98981820 │ release
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597354 │ 9597354 │ \x302e302e38 │ \x34a86f591cabdbcf71d56d17a472e52e76430c43 │ release
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597355 │ 9597355 │ \x302e302e39 │ \xfc36e2d3cc37462d0cb21a3fb61d35b816fe2670 │ release
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597356 │ 9597356 │ \x302e312e30 │ \x5c9dc4e6431d896b255b119f08dd99cb3550ea4f │ release
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597358 │ 9597358 │ \x302e312e302d646576 │ \xa98f9b297f096ed21d765a9c43b9f702933259f5 │ revision
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597357 │ 9597357 │ \x302e322e30 │ \x53e3625f07ee107d500d6fad08ceff4875273268 │ release
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597359 │ 9597359 │ \x302e322e302d646576 │ \xf09b54177cff8de02ff151c77e9a22a453ee06f9 │ revision
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 8283839 │ 8283839 │ \x48454144 │ \x64656661756c74 │ alias
803594 │ \x3ab281eb47131a75efb4330e344da59c86013a9e │ 803594 │ 9597360 │ 9597360 │ \x64656661756c74 │ \x7fd1bb4028235d849d45680c1f24f74cc8506f70 │ revision
803680 │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 803680 │ 9597351 │ 9597351 │ \x302e302e35 │ \xdaf39e9ce6afbfdce4a14f2320dbe63d11513d74 │ release
803680 │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 803680 │ 9597352 │ 9597352 │ \x302e302e36 │ \xf6ea0d6573dda510dfe4dbb5fd0a8b6278e934e3 │ release
803680 │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 803680 │ 9597353 │ 9597353 │ \x302e302e37 │ \x0ea8f6656b0540db0b9bc55d046eec8b98981820 │ release
803680 │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 803680 │ 9597354 │ 9597354 │ \x302e302e38 │ \x34a86f591cabdbcf71d56d17a472e52e76430c43 │ release
803680 │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 803680 │ 9597355 │ 9597355 │ \x302e302e39 │ \xfc36e2d3cc37462d0cb21a3fb61d35b816fe2670 │ release
803680 │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 803680 │ 9597356 │ 9597356 │ \x302e312e30 │ \x5c9dc4e6431d896b255b119f08dd99cb3550ea4f │ release
803680 │ \x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 803680 │ 9597357 │ 9597357 │ \x302e322e30 │ \x53e3625f07ee107d500d6fad08ceff4875273268 │ release
> select id, convert_from(name, 'utf-8'), target, target_type from snapshot inner join snapshot_branches on snapshot.object_id = snapshot_branches.snapshot_id inner join snapshot_branch on snapshot_branch.object_id = snapshot_branches.branch_id where snapshot.id in ('\x3ab281eb47131a75efb4330e344da59c86013a9e', '\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed') order by snapshot.id, name, target, target_type;
id │ convert_from │ target │ target_type
────────────────────────────────────────────┼──────────────┼────────────────────────────────────────────┼─────────────
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.0.5 │ \xdaf39e9ce6afbfdce4a14f2320dbe63d11513d74 │ release
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.0.6 │ \xf6ea0d6573dda510dfe4dbb5fd0a8b6278e934e3 │ release
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.0.7 │ \x0ea8f6656b0540db0b9bc55d046eec8b98981820 │ release
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.0.8 │ \x34a86f591cabdbcf71d56d17a472e52e76430c43 │ release
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.0.9 │ \xfc36e2d3cc37462d0cb21a3fb61d35b816fe2670 │ release
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.1.0 │ \x5c9dc4e6431d896b255b119f08dd99cb3550ea4f │ release
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.1.0-dev │ \xa98f9b297f096ed21d765a9c43b9f702933259f5 │ revision
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.2.0 │ \x53e3625f07ee107d500d6fad08ceff4875273268 │ release
\x3ab281eb47131a75efb4330e344da59c86013a9e │ 0.2.0-dev │ \xf09b54177cff8de02ff151c77e9a22a453ee06f9 │ revision
\x3ab281eb47131a75efb4330e344da59c86013a9e │ HEAD │ \x64656661756c74 │ alias
\x3ab281eb47131a75efb4330e344da59c86013a9e │ default │ \x7fd1bb4028235d849d45680c1f24f74cc8506f70 │ revision
id │ convert_from │ target │ target_type
────────────────────────────────────────────┼──────────────┼────────────────────────────────────────────┼─────────────
\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 0.0.5 │ \xdaf39e9ce6afbfdce4a14f2320dbe63d11513d74 │ release
\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 0.0.6 │ \xf6ea0d6573dda510dfe4dbb5fd0a8b6278e934e3 │ release
\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 0.0.7 │ \x0ea8f6656b0540db0b9bc55d046eec8b98981820 │ release
\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 0.0.8 │ \x34a86f591cabdbcf71d56d17a472e52e76430c43 │ release
\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 0.0.9 │ \xfc36e2d3cc37462d0cb21a3fb61d35b816fe2670 │ release
\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 0.1.0 │ \x5c9dc4e6431d896b255b119f08dd99cb3550ea4f │ release
\x932dc65478f6ebcdfb0a9391bdba9e4ef0acaeed │ 0.2.0 │ \x53e3625f07ee107d500d6fad08ceff4875273268 │ release
```
About · Developer information · Legal