{"action":"created","issue":{"url":"https://api.github.com/repos/TGAC/miso-lims/issues/1433","repository_url":"https://api.github.com/repos/TGAC/miso-lims","labels_url":"https://api.github.com/repos/TGAC/miso-lims/issues/1433/labels{/name}","comments_url":"https://api.github.com/repos/TGAC/miso-lims/issues/1433/comments","events_url":"https://api.github.com/repos/TGAC/miso-lims/issues/1433/events","html_url":"https://github.com/TGAC/miso-lims/issues/1433","id":320513329,"number":1433,"title":"0.2.117 : db migration issue","user":{"login":"sklages","id":1837422,"avatar_url":"https://avatars3.githubusercontent.com/u/1837422?v=4","gravatar_id":"","url":"https://api.github.com/users/sklages","html_url":"https://github.com/sklages","followers_url":"https://api.github.com/users/sklages/followers","following_url":"https://api.github.com/users/sklages/following{/other_user}","gists_url":"https://api.github.com/users/sklages/gists{/gist_id}","starred_url":"https://api.github.com/users/sklages/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sklages/subscriptions","organizations_url":"https://api.github.com/users/sklages/orgs","repos_url":"https://api.github.com/users/sklages/repos","events_url":"https://api.github.com/users/sklages/events{/privacy}","received_events_url":"https://api.github.com/users/sklages/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":6,"created_at":"2018-05-05T14:24:16Z","updated_at":"2018-05-11T14:28:11Z","closed_at":null,"author_association":"NONE","body":"I just wanted to update our MISO instance and ran into the following error:\r\n\r\n```\r\nMigration V0480__auto_main.sql failed\r\n-------------------------------------\r\nSQL State  : 22004\r\nError Code : 1138\r\nMessage    : Invalid use of NULL value\r\nLocation   : db/migration/V0480__auto_main.sql (<snip path>)\r\nLine       : 81\r\nStatement  : ALTER TABLE SequencerPartitionContainer MODIFY COLUMN sequencingContainerModelId bigint(20) NOT NULL\r\n```\r\nWhen I look into the database **after** that error, I do see the problem: There are a handful of flowcells having a `NULL` value in column `sequencingContainerModelId`.  I reverted back to `115` and could not fix these columns as it seems that these are introduced by the current update (117).\r\n\r\nSo what do I need to fix in `115` database that the update `117` will be successful? :smiley: \r\n"},"comment":{"url":"https://api.github.com/repos/TGAC/miso-lims/issues/comments/388380185","html_url":"https://github.com/TGAC/miso-lims/issues/1433#issuecomment-388380185","issue_url":"https://api.github.com/repos/TGAC/miso-lims/issues/1433","id":388380185,"user":{"login":"sklages","id":1837422,"avatar_url":"https://avatars3.githubusercontent.com/u/1837422?v=4","gravatar_id":"","url":"https://api.github.com/users/sklages","html_url":"https://github.com/sklages","followers_url":"https://api.github.com/users/sklages/followers","following_url":"https://api.github.com/users/sklages/following{/other_user}","gists_url":"https://api.github.com/users/sklages/gists{/gist_id}","starred_url":"https://api.github.com/users/sklages/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sklages/subscriptions","organizations_url":"https://api.github.com/users/sklages/orgs","repos_url":"https://api.github.com/users/sklages/repos","events_url":"https://api.github.com/users/sklages/events{/privacy}","received_events_url":"https://api.github.com/users/sklages/received_events","type":"User","site_admin":false},"created_at":"2018-05-11T14:28:11Z","updated_at":"2018-05-11T14:28:11Z","author_association":"NONE","body":"Just to be sure that I didn't got you both wrong. Using the aforementioned SQL query I get some records, exactly 11. One example:\r\n```\r\ncontainerId  platform partitions\r\n70           3            1\r\n```\r\n\r\nThat's a NextSeq container with just one lane/partition.\r\n\r\nThe record in `SequencerPartitionContainer_Partition` looks like:\r\n```\r\ncontainer_containerId  partitions_partitionId\r\n      70                         425\r\n```\r\nThe corresponding part in `_Partition`:\r\n```\r\npartitionId   partitionNumber   pool_poolId\r\n   425               1             <NULL>\r\n```\r\nI completely wanted to delete both entries. So probably I got the \"keywords\" wrong?\r\nAll these 11 sequencing containers can be removed; I can re-create them if necessary."}}
{"actor":{"display_login":"sklages"}}