{"action":"opened","issue":{"url":"https://api.github.com/repos/hortonworks/registry/issues/430","repository_url":"https://api.github.com/repos/hortonworks/registry","labels_url":"https://api.github.com/repos/hortonworks/registry/issues/430/labels{/name}","comments_url":"https://api.github.com/repos/hortonworks/registry/issues/430/comments","events_url":"https://api.github.com/repos/hortonworks/registry/issues/430/events","html_url":"https://github.com/hortonworks/registry/issues/430","id":308998464,"number":430,"title":"2 schema versions with the same schemaText","user":{"login":"burandobata","id":34664543,"avatar_url":"https://avatars0.githubusercontent.com/u/34664543?v=4","gravatar_id":"","url":"https://api.github.com/users/burandobata","html_url":"https://github.com/burandobata","followers_url":"https://api.github.com/users/burandobata/followers","following_url":"https://api.github.com/users/burandobata/following{/other_user}","gists_url":"https://api.github.com/users/burandobata/gists{/gist_id}","starred_url":"https://api.github.com/users/burandobata/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/burandobata/subscriptions","organizations_url":"https://api.github.com/users/burandobata/orgs","repos_url":"https://api.github.com/users/burandobata/repos","events_url":"https://api.github.com/users/burandobata/events{/privacy}","received_events_url":"https://api.github.com/users/burandobata/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2018-03-27T14:38:53Z","updated_at":"2018-03-27T14:38:53Z","closed_at":null,"author_association":"NONE","body":"Hey,\r\n\r\nI've got following warnings in application logs:\r\n```\r\nWARN  [2018-03-27 09:23:42,216] com.hortonworks.registries.schemaregistry.SchemaVersionLifecycleManager: Exists more than one schema with schemaMetadataName: [xxxxxx] and schemaText [{...}]\r\n``` \r\n\r\nI've upgraded this environment today from 0.3 to 0.5.1 and the error is still there.\r\n\r\nAs I've found inside our database, we have couple of schemas with the same schemaText field in schema_version_info table for different schema versions. The service should have attributed the same schemaText to the same version of a schema. I'm not sure how/why it happened. Based on timestamps in db those schema versions with the same schemaText has been created within couple of ms window. This has happened while we were running 0.3. We are running 2 schema registry services on independent boxes using the same postgres backend.\r\n\r\nI have 2 questions here:\r\n1. Is this a known bug? If so is 0.5.1 still affected?\r\n2. How can I deal with current situation?\r\n\r\nthanks,\r\nMarek"}}
{"actor":{"display_login":"burandobata"}}