Skip to content

Instantly share code, notes, and snippets.

@bthaile
Last active May 15, 2019 20:51
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save bthaile/b4fde3e112f4730337898376d4ed2243 to your computer and use it in GitHub Desktop.
Save bthaile/b4fde3e112f4730337898376d4ed2243 to your computer and use it in GitHub Desktop.
augur app 1.13 error when trying to sync mainnet
[14:49:14.772] augur-node start: insert into `_knex_temp_alter7` (`account`, `blockNumber`, `eventName`, `logIndex`, `marketId`, `numCompleteSets`, `numPurchasedOrSold`, `tradeGroupId`, `transactionHash`, `universe`) select '0x2404a39e447d0c8b417049fc42b468a26990b4cc' as `account`, 5970747 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 53 as `logIndex`, '0x62fd1c486b124404e863354ac6a32d348ee074b0' as `marketId`, "3" as `numCompleteSets`, '3' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xc00edbcad96cc73cc3843c9a8761c9915d026d7b18d212053ffac142a186c8f2' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x2404a39e447d0c8b417049fc42b468a26990b4cc' as `account`, 5970756 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 84 as `logIndex`, '0x62fd1c486b124404e863354ac6a32d348ee074b0' as `marketId`, "3" as `numCompleteSets`, '3' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xa0c6da53b221a26c4a649c9deae239b20c1bd139e1caf7b12ecab7d70b47e38a' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x9cb9ccae1658bc7c2fe84600a6487f25091dcf37' as `account`, 5970859 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 75 as `logIndex`, '0x3b27b8c9a3b53f94ef151852994a3d0fa973b174' as `marketId`, "0.01" as `numCompleteSets`, '0.01' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x926536b92097c7508a02c19c63e69a21c939702701f26a224acf845c4d6722fc' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xefaef3a9b2bc9b1464c1f85715b6915de4ec659d' as `account`, 5981501 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 35 as `logIndex`, '0x76411268117aac7c77bfabb9bd644349e87e4b49' as `marketId`, "0.158" as `numCompleteSets`, '0.158' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x12395393221d42b7837fb455682fd7491c6c5a0f3889df9424beb462076aaca4' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x2404a39e447d0c8b417049fc42b468a26990b4cc' as `account`, 5993985 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 101 as `logIndex`, '0x7736bb21ac0f676c7c2783af72913d4c5488da90' as `marketId`, "2.2" as `numCompleteSets`, '2.2' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xc0804b0ab180907989e3731533ef5c0eeb944c751d568bb936fb49ac96378925' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xc64e96319366da7d00ef4bc14b42e8b1f3a31f52' as `account`, 6021931 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 79 as `logIndex`, '0x4e0ee58bf4230d3b799584e1a6027b4bda9fc4ed' as `marketId`, "0.5" as `numCompleteSets`, '0.5' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xa693681342f6161e755a4a0f791a4cc131bbfcb2d2e41d850b868b0281b53f98' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xa6d5f47cbb5e4f7412dd12dce162009cf0482405' as `account`, 6022817 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 54 as `logIndex`, '0xb8573e2d08433e74152e8c141817a95a4ec620d9' as `marketId`, "0.1" as `numCompleteSets`, '0.1' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xb98510a47a040d72903c75c0e3ca4d5f6935009a6cd1e6f4299557d4ef6a0ea4' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xc64e96319366da7d00ef4bc14b42e8b1f3a31f52' as `account`, 6024148 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 63 as `logIndex`, '0xdd6eb36fd81a753911073ce3a33c244563540a53' as `marketId`, "0.04" as `numCompleteSets`, '0.04' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x2003a1d3eceacbeeff0c6a5a75bb689e8729ae9c403c9ecc71fe391b167617ad' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x260f180cfaa31e8a615545767461d4a0d72902e4' as `account`, 6029913 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 32 as `logIndex`, '0xc0f593057595b48b0c7f0bb587127f669280e9ca' as `marketId`, "1" as `numCompleteSets`, '1' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xc78b37704a85466d695f027be95dc6ec9097fe0591412db44d0c565540b93a7c' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xa6d5f47cbb5e4f7412dd12dce162009cf0482405' as `account`, 6035785 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 116 as `logIndex`, '0xa0c26f0e5d45800ed85279c37281b49934f3ecf8' as `marketId`, "2" as `numCompleteSets`, '2' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x0258df5045d216cb11212b7173d73e02a823a40abb56f56c38220d282e32f5cf' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x57f095a1e64cde4d934f96f4a94a874127828042' as `account`, 6068865 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 135 as `logIndex`, '0x464e4a7f728f1314bfc4e4371460a9e777b80b73' as `marketId`, "0.01" as `numCompleteSets`, '0.01' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x1dd306720421e3042f8c010a6d7a1baf31d5c6ca97e1cfc4b008fcb33691544e' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xb4168e78c89ac933d79f51abb79437bebcf96c18' as `account`, 6094159 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 117 as `logIndex`, '0xd2b4906276b6ed334604f914306158c05a92e41f' as `marketId`, "0.04" as `numCompleteSets`, '0.04' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x251d442d8ba64e5c3840373e8ede736e58b845eb4a6667c4b270c07b224bb469' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xbf473d6016f15e757c677c7a8cf88e22718b40d2' as `account`, 6094953 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 36 as `logIndex`, '0x95f2301a56a94b1ef6b60b5e94085462e71432fb' as `marketId`, "0.1" as `numCompleteSets`, '0.1' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x14f82b4f58882edfc392d250f86488271a5f328c368c9d8ac6a5680e3c6cef4b' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0xc64e96319366da7d00ef4bc14b42e8b1f3a31f52' as `account`, 6122788 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 80 as `logIndex`, '0xd2b4906276b6ed334604f914306158c05a92e41f' as `marketId`, "1.5192" as `numCompleteSets`, '1.5192' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x894820883332b808121f33a34e4cba13d7ae7cafb03b42616b64980073c6e406' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x4a9767e85a4854c0660c38bb254a696eb5e08b7c' as `account`, 6123286 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 79 as `logIndex`, '0xc0f593057595b48b0c7f0bb587127f669280e9ca' as `marketId`, "0.4" as `numCompleteSets`, '0.4' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x829405b0902e3f7ede0455d9b6d0ddc2b4732306eae02671728c8a2c5a6d3aed' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x4a9767e85a4854c0660c38bb254a696eb5e08b7c' as `account`, 6139483 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 17 as `logIndex`, '0xec13edb3ba77d1010bb5905d09b4f6b1644bf9d4' as `marketId`, "0.1" as `numCompleteSets`, '0.1' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x981a1524ed16d89003417491126aa69173782fd7d3f8fc90ff05e9eb00915ad7' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x196a5b3fc7a7e4fb6627525be8dabb43c66dd8c3' as `account`, 6158902 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 101 as `logIndex`, '0x364b74edceea518445bf3d784be017270e4cfeed' as `marketId`, "3.061" as `numCompleteSets`, '3.061' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xe57a5e4b045543bfa28f04b3f8f58fce84a837303512f1ff0e9b72deeb60d126' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x3c9923956c7a48b46a8a028ff93eb36aca927ebc' as `account`, 6159184 as `blockNumber`, 'CompleteSetsPurchased' as `eventName`, 44 as `logIndex`, '0x4f74d2363527e041995b2bac8eb3e053af9590c8' as `marketId`, "0.05" as `numCompleteSets`, '0.05' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0x976b4f00fc09201fe1b02a9745115309560839f641c4d7f20adf0b3c9ed408a5' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x196a5b3fc7a7e4fb6627525be8dabb43c66dd8c3' as `account`, 6200319 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 27 as `logIndex`, '0xd2b4906276b6ed334604f914306158c05a92e41f' as `marketId`, "5" as `numCompleteSets`, '5' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xa8871aa992986f92e86c552183535f832062af522a05e3923d8aa467a8e0bfd2' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` union all select '0x28e37925e4e628f37332901a98cfbba66f314b23' as `account`, 6220616 as `blockNumber`, 'CompleteSetsSold' as `eventName`, 96 as `logIndex`, '0x2a5d97a16b11a81b6e8390f9e558aaae6dd99585' as `marketId`, "2.6" as `numCompleteSets`, '2.6' as `numPurchasedOrSold`, NULL as `tradeGroupId`, '0xab9446adc22b4183089d6ed243536ca0542f62f42b45e5f84bd3ce37dc3f0cb1' as `transactionHash`, '0xe991247b78f937d7b69cfc00f1a487a293557677' as `universe` - SQLITE_CONSTRAINT: NOT NULL constraint failed: _knex_temp_alter7.numCompleteSets
@bthaile
Copy link
Author

bthaile commented May 15, 2019

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment