{"action":"created","issue":{"url":"https://api.github.com/repos/geonetwork/core-geonetwork/issues/734","labels_url":"https://api.github.com/repos/geonetwork/core-geonetwork/issues/734/labels{/name}","comments_url":"https://api.github.com/repos/geonetwork/core-geonetwork/issues/734/comments","events_url":"https://api.github.com/repos/geonetwork/core-geonetwork/issues/734/events","html_url":"https://github.com/geonetwork/core-geonetwork/issues/734","id":55465345,"number":734,"title":"Migration / Starting value of the sequence may be too low","user":{"login":"fxprunayre","id":1701393,"avatar_url":"https://avatars.githubusercontent.com/u/1701393?v=3","gravatar_id":"","url":"https://api.github.com/users/fxprunayre","html_url":"https://github.com/fxprunayre","followers_url":"https://api.github.com/users/fxprunayre/followers","following_url":"https://api.github.com/users/fxprunayre/following{/other_user}","gists_url":"https://api.github.com/users/fxprunayre/gists{/gist_id}","starred_url":"https://api.github.com/users/fxprunayre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fxprunayre/subscriptions","organizations_url":"https://api.github.com/users/fxprunayre/orgs","repos_url":"https://api.github.com/users/fxprunayre/repos","events_url":"https://api.github.com/users/fxprunayre/events{/privacy}","received_events_url":"https://api.github.com/users/fxprunayre/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/geonetwork/core-geonetwork/labels/enhancement","name":"enhancement","color":"84b6eb"}],"state":"closed","locked":false,"assignee":null,"milestone":{"url":"https://api.github.com/repos/geonetwork/core-geonetwork/milestones/15","html_url":"https://github.com/geonetwork/core-geonetwork/milestones/3.0.0","labels_url":"https://api.github.com/repos/geonetwork/core-geonetwork/milestones/15/labels","id":981401,"number":15,"title":"3.0.0","description":"","creator":{"login":"fxprunayre","id":1701393,"avatar_url":"https://avatars.githubusercontent.com/u/1701393?v=3","gravatar_id":"","url":"https://api.github.com/users/fxprunayre","html_url":"https://github.com/fxprunayre","followers_url":"https://api.github.com/users/fxprunayre/followers","following_url":"https://api.github.com/users/fxprunayre/following{/other_user}","gists_url":"https://api.github.com/users/fxprunayre/gists{/gist_id}","starred_url":"https://api.github.com/users/fxprunayre/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/fxprunayre/subscriptions","organizations_url":"https://api.github.com/users/fxprunayre/orgs","repos_url":"https://api.github.com/users/fxprunayre/repos","events_url":"https://api.github.com/users/fxprunayre/events{/privacy}","received_events_url":"https://api.github.com/users/fxprunayre/received_events","type":"User","site_admin":false},"open_issues":3,"closed_issues":56,"state":"open","created_at":"2015-02-16T14:52:04Z","updated_at":"2015-04-21T11:55:02Z","due_on":"2015-04-27T22:00:00Z","closed_at":null},"comments":9,"created_at":"2015-01-26T10:12:07Z","updated_at":"2015-04-22T08:57:35Z","closed_at":"2015-04-21T07:28:15Z","body":"When upgrading to 3.0, the initial value of the sequence may be too low.\r\nhttps://github.com/geonetwork/core-geonetwork/blob/develop/web/src/main/webapp/WEB-INF/classes/setup/sql/migrate/v2110/2-migrate-default.sql#L194\r\n\r\nThis will generate SQL errors for queries. Eg. when having lots of requests statistics in the migrated node. We should at least document it or set the init value after migration to the highest id.\r\n\r\n"},"comment":{"url":"https://api.github.com/repos/geonetwork/core-geonetwork/issues/comments/95082035","html_url":"https://github.com/geonetwork/core-geonetwork/issues/734#issuecomment-95082035","issue_url":"https://api.github.com/repos/geonetwork/core-geonetwork/issues/734","id":95082035,"user":{"login":"landryb","id":3421760,"avatar_url":"https://avatars.githubusercontent.com/u/3421760?v=3","gravatar_id":"","url":"https://api.github.com/users/landryb","html_url":"https://github.com/landryb","followers_url":"https://api.github.com/users/landryb/followers","following_url":"https://api.github.com/users/landryb/following{/other_user}","gists_url":"https://api.github.com/users/landryb/gists{/gist_id}","starred_url":"https://api.github.com/users/landryb/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/landryb/subscriptions","organizations_url":"https://api.github.com/users/landryb/orgs","repos_url":"https://api.github.com/users/landryb/repos","events_url":"https://api.github.com/users/landryb/events{/privacy}","received_events_url":"https://api.github.com/users/landryb/received_events","type":"User","site_admin":false},"created_at":"2015-04-22T08:57:35Z","updated_at":"2015-04-22T08:57:35Z","body":"Even if the md id is meaningless and ppl should more refer to it using uuids, i think it would be better to have distinct sequences, at least for statistics/hits (which grow fast) and metadata ids.."}}