Value for domain outsum violates check constraint on mainnet_candidate

[mmahut]

When running the current master 0c01cde80d271ddbfc703816fb4e12da9796a87c of cardano-db-sync on the mainnet_candidate network. After reaching the epoch 15, it fails with the following error.

Jul 23 14:41:38 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:38.19 UTC] epochPluginInsertBlock: epoch 7
Jul 23 14:41:39 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:39.04 UTC] epochPluginInsertBlock: epoch 8
Jul 23 14:41:39 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:39.20 UTC] insertByronBlock: slot 10000, block 9954, hash 472a75aad31e25b668063c06787e7c9785d7323e768be6772d4666c291c20f57
Jul 23 14:41:39 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:39.72 UTC] epochPluginInsertBlock: epoch 9
Jul 23 14:41:40 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:40.41 UTC] epochPluginInsertBlock: epoch 10
Jul 23 14:41:41 backend1 cardano[15116]: Chain extended, new tip: (Point 154060, "b1f7f8c8d0c880b09af91fd91505937261e3190d77fd50a9d45ea368b5db15c9")
Jul 23 14:41:41 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:41.06 UTC] epochPluginInsertBlock: epoch 11
Jul 23 14:41:41 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:41.72 UTC] epochPluginInsertBlock: epoch 12
Jul 23 14:41:42 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:42.30 UTC] insertByronBlock: slot 15000, block 14954, hash 02d5eb21a1f8e98e80e6a23c94f6e38c1d52a08879302e0b52027fb447af78a5
Jul 23 14:41:42 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:42.38 UTC] epochPluginInsertBlock: epoch 13
Jul 23 14:41:43 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:41:43.06 UTC] epochPluginInsertBlock: epoch 14
Jul 23 14:42:00 backend1 cardano[15116]: Chain extended, new tip: (Point 154080, "366bfc1f5fd3ca04fec81e80c6e461ccb7cf95e39f22cea42f3d2c770a12c53f")
Jul 23 14:42:20 backend1 cardano[15116]: Chain extended, new tip: (Point 154100, "b95b7702a9c599c65ef2465986439919d0cc6048df5414ca35582a994d82aa6e")
Jul 23 14:42:40 backend1 cardano[15116]: Chain extended, new tip: (Point 154120, "519b1b6154e6b9eb90052042c4fff73d20cad53039100ba6b5bb545c6e8b1332")
Jul 23 14:43:00 backend1 cardano[15116]: Chain extended, new tip: (Point 154140, "2af6b60230e9ef1cacc260057721e9d0771097d1228febee64cb5b82c637766b")
Jul 23 14:43:20 backend1 cardano[15116]: Chain extended, new tip: (Point 154160, "6c64e2f685fce049963fb8b9d497fea1a7470f37e1337854021995cf1e994af2")
Jul 23 14:43:40 backend1 cardano[15116]: Chain extended, new tip: (Point 154180, "1d7311d500e0599e4a9d703357fc8fbb53244feaefaae4d9569b8db0d035183c")
Jul 23 14:43:50 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Info:33] [2020-07-23 14:43:50.30 UTC] epochPluginInsertBlock: epoch 15
Jul 23 14:43:50 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Error:33] [2020-07-23 14:43:50.30 UTC] runDBThread: DbInsertException "Epoch" (SqlError {sqlState = "23514", sqlExecStatus = FatalError, sqlErrorMsg = "value for domain outsum violates check constraint \"outsum_check\"", sqlErrorDetail = "", sqlErrorHint = ""})
Jul 23 14:43:50 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Error:36] [2020-07-23 14:43:50.30 UTC] recvMsgRollForward: AsyncCancelled
Jul 23 14:43:50 backend1 cca0j5zrvwd4cm6pm7g97zhz1ijlj0ns-cardano-db-sync[30523]: [db-sync-node:Error:29] [2020-07-23 14:43:50.30 UTC] ChainSyncWithBlocksPtcl: DbInsertException "Epoch" (SqlError {sqlState = "23514", sqlExecStatus = FatalError, sqlErrorMsg = "value for domain outsum violates check constraint \"outsum_check\"", sqlErrorDetail = "", sqlErrorHint = ""})

This might be related to #197.

[erikd]

This is an exact duplicate of #197. Closing.