Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

RVL-1936 - Seemingly non-monotonically increasing sever version #1023

Open
Rkareko opened this issue Dec 3, 2021 · 2 comments
Open

RVL-1936 - Seemingly non-monotonically increasing sever version #1023

Rkareko opened this issue Dec 3, 2021 · 2 comments
Assignees

Comments

@Rkareko
Copy link
Contributor

Rkareko commented Dec 3, 2021

As mentioned on the call, here are some examples of odd server versions among the plans:

Most recent plan in replica3:

Date: 11-25-2021

ID: d54cf449-66ce-5e79-a8f4-f2ed48150d85

serverVersion: 1601948157735

Some examples of the 67 plans with higher server versions:

Oldest plan

Date: 2019-12-24

ID: f93b98c9-7f37-44db-843c-5eda07f581ae

serverVersion: 1601948157776

Active plan

Date: 2021-05-19

ID: 1e485f9e-f934-5be8-8ec1-470caf42cf78

serverVersion: 1601948157770

A draft plan:

Date: 2021-09-07

ID: 9ac85804-8edd-46a8-834e-a63eeef036e5

serverVersion: 1601948157744

Several of these plans are listed as their first version which should indicate that they have not been updated since they were created.

Reported on Jira RVL-1936

@Rkareko Rkareko self-assigned this Dec 3, 2021
@Rkareko
Copy link
Contributor Author

Rkareko commented Dec 3, 2021

@samkanga here are the plans showing the last time they were edited

select identifier, json->>'status' status, json->>'serverVersion' jsonServerVersion, server_version, json->>'date' planDate, date_edited from core.plan where identifier in
 ('d54cf449-66ce-5e79-a8f4-f2ed48150d85','f93b98c9-7f37-44db-843c-5eda07f581ae', '1e485f9e-f934-5be8-8ec1-470caf42cf78', '9ac85804-8edd-46a8-834e-a63eeef036e5')
 order by jsonServerVersion desc;
              identifier              | status  | jsonserverversion | server_version |  plandate  |       date_edited       
--------------------------------------+---------+-------------------+----------------+------------+-------------------------
 d54cf449-66ce-5e79-a8f4-f2ed48150d85 | active  | 1601948548159     |  1601948548159 | 2021-11-25 | 2021-12-03 16:53:52.968
 1e485f9e-f934-5be8-8ec1-470caf42cf78 | active  | 1601948547985     |  1601948547985 | 2021-05-19 | 2021-12-03 16:51:59.614
 9ac85804-8edd-46a8-834e-a63eeef036e5 | draft   | 1601948547513     |  1601948547513 | 2021-09-07 | 2021-12-03 16:47:00.921
 f93b98c9-7f37-44db-843c-5eda07f581ae | retired | 1601948157776     |  1601948157776 | 2019-12-24 | 2021-11-25 19:50:10.879

@Rkareko
Copy link
Contributor Author

Rkareko commented Dec 3, 2021

@samkanga The above information has been order by server version descending. As you can see it the date_edited corresponds to the server verisons

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant