diff options
| author |   Benjamin, Max (mb388a) <mb388a@us.att.com> | 2019-02-24 10:42:15 -0500 |
|---|---|---|
| committer | Benjamin, Max (mb388a) <mb388a@us.att.com> | 2019-02-24 16:10:26 -0500 |
| commit | 20e1b6517b1c64a82cb52be8a2a2882c86b1318b (patch) | |
| tree | 68acb7b130d6c479eaaa6ba91275b5b2b2897bb6 /adapters/mso-requests-db-adapter/src/main/resources/db/migration | |
| parent | 57af0e334073b329ca9f48b353ab4cc3bd2027a8 (diff) | |
Prevent race conditions on same distributionId.
- Code to include optimistic lock to prevent race conditions on same
distributionId.
Change-Id: Ibe110b32f2472d991a4a3e03e3d15d5e4deefd65
Issue-ID: SO-1566
Signed-off-by: Benjamin, Max (mb388a) <mb388a@us.att.com>
Diffstat (limited to 'adapters/mso-requests-db-adapter/src/main/resources/db/migration')
| -rw-r--r-- | adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.3.1__Watchdog_Lock_Version_Column.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.3.1__Watchdog_Lock_Version_Column.sql b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.3.1__Watchdog_Lock_Version_Column.sql new file mode 100644 index 0000000000..6379bc6015 --- /dev/null +++ b/adapters/mso-requests-db-adapter/src/main/resources/db/migration/V5.3.1__Watchdog_Lock_Version_Column.sql @@ -0,0 +1,3 @@ +use requestdb; + +ALTER TABLE watchdog_distributionid_status ADD LOCK_VERSION int NOT NULL; |