API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Apr 8th, 2017
300
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 83.08 KB | None | 0 0
raw download clone embed print report
  1. 2017-04-09 04:43:39 INFO: nxt.enableStackTraces = "true"
  2. 2017-04-09 04:43:39 INFO: nxt.enableLogTraceback = "true"
  3. 2017-04-09 04:43:39 INFO: Logger.<clinit>: logging enabled
  4. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: socksProxyHost not defined
  5. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: socksProxyPort not defined
  6. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.version = 1.8.0_121
  7. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vm.version = 25.121-b13
  8. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vm.name = Java HotSpot(TM) 64-Bit Server VM
  9. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vendor = Oracle Corporation
  10. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vm.vendor = Oracle Corporation
  11. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.home = C:\Java\jdk1.8.0_121\jre
  12. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.library.path = <censored>
  13. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.class.path = E:\apache-maven-3.3.9\boot\plexus-classworlds-2.5.2.jar
  14. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: os.arch = amd64
  15. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: sun.arch.data.model = 64
  16. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: os.name = Windows Server 2012 R2
  17. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: file.encoding = Cp1252
  18. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.security.policy = null
  19. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.security.manager = null
  20. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: nxt.runtime.mode = null
  21. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: nxt.runtime.dirProvider = null
  22. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: availableProcessors = 8
  23. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: maxMemory = 954728448
  24. 2017-04-09 04:43:39 FINE: Nxt.logSystemProperties: processId = 2672
  25. 2017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.isTestnet = "true"
  26. 2017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.isOffline = "false"
  27. 2017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.isLightClient = "false"
  28. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.maxRollback = "800"
  29. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.testnetGuaranteedBalanceConfirmations = "10"
  30. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.testnetLeasingDelay not defined or not numeric, using default value 1440
  31. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testnetMinForgingBalance not defined
  32. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.forgingDelay = "20"
  33. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.forgingSpeedup = "3"
  34. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.maxPrunableLifetime = "7776000"
  35. 2017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.includeExpiredPrunable = "true"
  36. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.supernodeBinding not defined or not numeric, using default value 20
  37. 2017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.correctInvalidFees = "false"
  38. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.statementLogThreshold = "10000"
  39. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.transactionLogThreshold = "15000"
  40. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.transactionLogInterval = "15"
  41. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbCacheKB = "0"
  42. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbUrl not defined
  43. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbType = "h2"
  44. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbDir = "./elastic_test_db/nxt"
  45. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbParams = "DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE;MV_STORE=FALSE"
  46. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbUsername = "sa"
  47. 2017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbPassword = "{not logged}"
  48. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.maxDbConnections = "30"
  49. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbLoginTimeout = "70"
  50. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbDefaultLockTimeout = "60"
  51. 2017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbMaxMemoryRows = "1000000"
  52. 2017-04-09 04:43:39 INFO: BasicDb.init: Database jdbc url set to jdbc:h2:./elastic_test_db/nxt;DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE;MV_STORE=FALSE;CACHE_SIZE=262144 username sa
  53. 2017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.useStrongSecureRandom = "false"
  54. 2017-04-09 04:43:40 FINE: BasicDb.getPooledConnection: Database connection pool current size: 1
  55. 2017-04-09 04:43:40 INFO: DbVersion.init: Initializing an empty database
  56. 2017-04-09 04:43:40 FINE: BasicDb.getPooledConnection: Database connection pool current size: 2
  57. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  58. CREATE TABLE IF NOT EXISTS block (db_id IDENTITY, id BIGINT NOT NULL, version INT NOT NULL, timestamp INT NOT NULL, previous_block_id BIGINT, total_amount BIGINT NOT NULL, total_fee BIGINT NOT NULL, payload_length INT NOT NULL, previous_block_hash BINARY(32), cumulative_difficulty VARBINARY NOT NULL, base_target BIGINT NOT NULL, next_block_id BIGINT, height INT NOT NULL, generation_signature BINARY(64) NOT NULL, block_signature BINARY(64), payload_hash BINARY(32) NOT NULL, generator_id BIGINT NOT NULL, min_pow_target VARCHAR(255))
  59. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  60. CREATE UNIQUE INDEX IF NOT EXISTS block_id_idx ON block (id)
  61. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  62. CREATE TABLE IF NOT EXISTS transaction (db_id IDENTITY, id BIGINT NOT NULL, sncleanid BIGINT NOT NULL,deadline SMALLINT NOT NULL, recipient_id BIGINT, amount BIGINT NOT NULL, fee BIGINT NOT NULL, full_hash BINARY(32) NOT NULL, height INT NOT NULL, block_id BIGINT NOT NULL, FOREIGN KEY (block_id) REFERENCES block (id) ON DELETE CASCADE, signature BINARY(64) NOT NULL, superNodePublicKey BINARY(32), supernode_signature BINARY(64), timestamp INT NOT NULL, type TINYINT NOT NULL, subtype TINYINT NOT NULL, sender_id BIGINT NOT NULL, block_timestamp INT NOT NULL, referenced_transaction_full_hash BINARY(32), transaction_index SMALLINT NOT NULL, phased BOOLEAN NOT NULL DEFAULT FALSE, attachment_bytes VARBINARY, version TINYINT NOT NULL, has_message BOOLEAN NOT NULL DEFAULT FALSE, has_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE, has_public_key_announcement BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_source_code BOOLEAN NOT NULL DEFAULT FALSE, has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE, ec_block_height INT DEFAULT NULL, ec_block_id BIGINT DEFAULT NULL, has_encrypttoself_message BOOLEAN NOT NULL DEFAULT FALSE)
  63. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  64. CREATE UNIQUE INDEX IF NOT EXISTS transaction_id_idx ON transaction (id)
  65. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  66. CREATE UNIQUE INDEX IF NOT EXISTS block_height_idx ON block (height)
  67. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  68. CREATE UNIQUE INDEX IF NOT EXISTS transaction_snid_idx ON transaction (sncleanid)
  69. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  70. CREATE INDEX IF NOT EXISTS block_generator_id_idx ON block (generator_id)
  71. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  72. CREATE INDEX IF NOT EXISTS transaction_sender_id_idx ON transaction (sender_id)
  73. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  74. CREATE INDEX IF NOT EXISTS transaction_recipient_id_idx ON transaction (recipient_id)
  75. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  76. CREATE TABLE IF NOT EXISTS work (db_id IDENTITY, closing_timestamp INT NOT NULL, id BIGINT NOT NULL, work_id BIGINT NOT NULL, block_id BIGINT NOT NULL, sender_account_id BIGINT NOT NULL, xel_per_pow BIGINT NOT NULL, title VARCHAR NOT NULL, blocks_remaining SMALLINT NOT NULL, closed BOOLEAN NOT NULL DEFAULT FALSE, close_pending BOOLEAN NOT NULL DEFAULT FALSE, cancelled BOOLEAN NOT NULL DEFAULT FALSE, timedout BOOLEAN NOT NULL DEFAULT FALSE, xel_per_bounty BIGINT NOT NULL, balance_pow_fund BIGINT NOT NULL, balance_bounty_fund BIGINT NOT NULL, balance_pow_fund_orig BIGINT NOT NULL, balance_bounty_fund_orig BIGINT NOT NULL,received_bounties INT NOT NULL, received_bounty_announcements INT NOT NULL, received_pows INT NOT NULL, bounty_limit INT NOT NULL, originating_height INT NOT NULL, height INT NOT NULL, work_min_pow_target VARCHAR(255), latest BOOLEAN NOT NULL DEFAULT TRUE)
  77. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  78. CREATE TABLE IF NOT EXISTS pow_and_bounty (db_id IDENTITY, id BIGINT NOT NULL, too_late BOOLEAN NOT NULL DEFAULT FALSE, work_id BIGINT NOT NULL, hash BINARY(32), account_id BIGINT NOT NULL, multiplicator VARBINARY NOT NULL, is_pow BOOLEAN NOT NULL DEFAULT TRUE, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  79. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  80. CREATE TABLE IF NOT EXISTS pow_and_bounty_announcements (db_id IDENTITY, id BIGINT NOT NULL, too_late BOOLEAN NOT NULL DEFAULT FALSE, work_id BIGINT NOT NULL, hash BINARY(32), account_id BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  81. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  82. CREATE TABLE IF NOT EXISTS peer (address VARCHAR PRIMARY KEY, last_updated INT, services BIGINT)
  83. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  84. CREATE INDEX IF NOT EXISTS transaction_block_timestamp_idx ON transaction (block_timestamp DESC)
  85. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  86. CREATE TABLE IF NOT EXISTS alias (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, alias_name VARCHAR NOT NULL, alias_name_lower VARCHAR AS LOWER (alias_name) NOT NULL, alias_uri VARCHAR NOT NULL, timestamp INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  87. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  88. CREATE UNIQUE INDEX IF NOT EXISTS alias_id_height_idx ON alias (id, height DESC)
  89. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  90. CREATE INDEX IF NOT EXISTS alias_account_id_idx ON alias (account_id, height DESC)
  91. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  92. CREATE INDEX IF NOT EXISTS alias_name_lower_idx ON alias (alias_name_lower)
  93. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  94. CREATE TABLE IF NOT EXISTS alias_offer (db_id IDENTITY, id BIGINT NOT NULL, price BIGINT NOT NULL, buyer_id BIGINT, height INT NOT NULL, latest BOOLEAN DEFAULT TRUE NOT NULL)
  95. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  96. CREATE UNIQUE INDEX IF NOT EXISTS alias_offer_id_height_idx ON alias_offer (id, height DESC)
  97. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  98. CREATE TABLE IF NOT EXISTS asset (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, quantity BIGINT NOT NULL, decimals TINYINT NOT NULL, initial_quantity BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  99. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  100. CREATE INDEX IF NOT EXISTS asset_account_id_idx ON asset (account_id)
  101. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  102. CREATE TABLE IF NOT EXISTS trade (db_id IDENTITY, asset_id BIGINT NOT NULL, block_id BIGINT NOT NULL, ask_order_id BIGINT NOT NULL, bid_order_id BIGINT NOT NULL, ask_order_height INT NOT NULL, bid_order_height INT NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, quantity BIGINT NOT NULL, price BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
  103. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  104. CREATE INDEX IF NOT EXISTS trade_asset_id_idx ON trade (asset_id, height DESC)
  105. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  106. CREATE INDEX IF NOT EXISTS trade_seller_id_idx ON trade (seller_id, height DESC)
  107. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  108. CREATE INDEX IF NOT EXISTS trade_buyer_id_idx ON trade (buyer_id, height DESC)
  109. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  110. CREATE TABLE IF NOT EXISTS ask_order (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  111. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  112. CREATE UNIQUE INDEX IF NOT EXISTS ask_order_id_height_idx ON ask_order (id, height DESC)
  113. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  114. CREATE INDEX IF NOT EXISTS ask_order_account_id_idx ON ask_order (account_id, height DESC)
  115. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  116. CREATE INDEX IF NOT EXISTS ask_order_asset_id_price_idx ON ask_order (asset_id, price)
  117. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  118. CREATE TABLE IF NOT EXISTS bid_order (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, price BIGINT NOT NULL, transaction_index SMALLINT NOT NULL, transaction_height INT NOT NULL, quantity BIGINT NOT NULL, creation_height INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  119. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  120. CREATE UNIQUE INDEX IF NOT EXISTS bid_order_id_height_idx ON bid_order (id, height DESC)
  121. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  122. CREATE INDEX IF NOT EXISTS bid_order_account_id_idx ON bid_order (account_id, height DESC)
  123. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  124. CREATE INDEX IF NOT EXISTS bid_order_asset_id_price_idx ON bid_order (asset_id, price DESC)
  125. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  126. CREATE TABLE IF NOT EXISTS goods (db_id IDENTITY, id BIGINT NOT NULL, seller_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, parsed_tags ARRAY, tags VARCHAR, timestamp INT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, delisted BOOLEAN NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  127. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  128. CREATE UNIQUE INDEX IF NOT EXISTS goods_id_height_idx ON goods (id, height DESC)
  129. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  130. CREATE INDEX IF NOT EXISTS goods_seller_id_name_idx ON goods (seller_id, name)
  131. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  132. CREATE INDEX IF NOT EXISTS goods_timestamp_idx ON goods (timestamp DESC, height DESC)
  133. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  134. CREATE TABLE IF NOT EXISTS purchase (db_id IDENTITY, id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, goods_id BIGINT NOT NULL, seller_id BIGINT NOT NULL, quantity INT NOT NULL, price BIGINT NOT NULL, deadline INT NOT NULL, note VARBINARY, nonce BINARY(32), timestamp INT NOT NULL, pending BOOLEAN NOT NULL, goods VARBINARY, goods_nonce BINARY(32), goods_is_text BOOLEAN NOT NULL DEFAULT TRUE, refund_note VARBINARY, refund_nonce BINARY(32), has_feedback_notes BOOLEAN NOT NULL DEFAULT FALSE, has_public_feedbacks BOOLEAN NOT NULL DEFAULT FALSE, discount BIGINT NOT NULL, refund BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  135. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  136. CREATE UNIQUE INDEX IF NOT EXISTS purchase_id_height_idx ON purchase (id, height DESC)
  137. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  138. CREATE INDEX IF NOT EXISTS purchase_buyer_id_height_idx ON purchase (buyer_id, height DESC)
  139. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  140. CREATE INDEX IF NOT EXISTS purchase_seller_id_height_idx ON purchase (seller_id, height DESC)
  141. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  142. CREATE INDEX IF NOT EXISTS purchase_deadline_idx ON purchase (deadline DESC, height DESC)
  143. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  144. CREATE TABLE IF NOT EXISTS account (db_id IDENTITY, id BIGINT NOT NULL, balance BIGINT NOT NULL, unconfirmed_balance BIGINT NOT NULL, forged_balance BIGINT NOT NULL, active_lessee_id BIGINT, supernode_deposit_blocked BOOLEAN NOT NULL DEFAULT FALSE, has_control_phasing BOOLEAN NOT NULL DEFAULT FALSE, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  145. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  146. CREATE UNIQUE INDEX IF NOT EXISTS account_id_height_idx ON account (id, height DESC)
  147. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  148. CREATE TABLE IF NOT EXISTS account_asset (db_id IDENTITY, account_id BIGINT NOT NULL, asset_id BIGINT NOT NULL, quantity BIGINT NOT NULL, unconfirmed_quantity BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  149. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  150. CREATE UNIQUE INDEX IF NOT EXISTS account_asset_id_height_idx ON account_asset (account_id, asset_id, height DESC)
  151. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  152. CREATE TABLE IF NOT EXISTS account_guaranteed_balance (db_id IDENTITY, account_id BIGINT NOT NULL, additions BIGINT NOT NULL, height INT NOT NULL)
  153. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  154. CREATE UNIQUE INDEX IF NOT EXISTS account_guaranteed_balance_id_height_idx ON account_guaranteed_balance (account_id, height DESC)
  155. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  156. CREATE TABLE IF NOT EXISTS purchase_feedback (db_id IDENTITY, id BIGINT NOT NULL, feedback_data VARBINARY NOT NULL, feedback_nonce BINARY(32) NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  157. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  158. CREATE INDEX IF NOT EXISTS purchase_feedback_id_height_idx ON purchase_feedback (id, height DESC)
  159. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  160. CREATE TABLE IF NOT EXISTS purchase_public_feedback (db_id IDENTITY, id BIGINT NOT NULL, public_feedback VARCHAR NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  161. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  162. CREATE INDEX IF NOT EXISTS purchase_public_feedback_id_height_idx ON purchase_public_feedback (id, height DESC)
  163. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  164. CREATE TABLE IF NOT EXISTS unconfirmed_transaction (db_id IDENTITY, id BIGINT NOT NULL, sncleanid BIGINT NOT NULL, expiration INT NOT NULL, transaction_height INT NOT NULL, fee_per_byte BIGINT NOT NULL, arrival_timestamp BIGINT NOT NULL, transaction_bytes VARBINARY NOT NULL, height INT NOT NULL)
  165. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  166. CREATE UNIQUE INDEX IF NOT EXISTS unconfirmed_transaction_id_idx ON unconfirmed_transaction (id)
  167. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  168. CREATE UNIQUE INDEX IF NOT EXISTS unconfirmed_transaction_snid_idx ON unconfirmed_transaction (sncleanid)
  169. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  170. CREATE TABLE IF NOT EXISTS asset_transfer (db_id IDENTITY, id BIGINT NOT NULL, asset_id BIGINT NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT NOT NULL, quantity BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
  171. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  172. CREATE UNIQUE INDEX IF NOT EXISTS asset_transfer_id_idx ON asset_transfer (id)
  173. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  174. CREATE INDEX IF NOT EXISTS asset_transfer_asset_id_idx ON asset_transfer (asset_id, height DESC)
  175. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  176. CREATE INDEX IF NOT EXISTS asset_transfer_sender_id_idx ON asset_transfer (sender_id, height DESC)
  177. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  178. CREATE INDEX IF NOT EXISTS asset_transfer_recipient_id_idx ON asset_transfer (recipient_id, height DESC)
  179. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  180. CREATE INDEX IF NOT EXISTS account_asset_quantity_idx ON account_asset (quantity DESC)
  181. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  182. CREATE INDEX IF NOT EXISTS purchase_timestamp_idx ON purchase (timestamp DESC, id)
  183. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  184. CREATE INDEX IF NOT EXISTS ask_order_creation_idx ON ask_order (creation_height DESC)
  185. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  186. CREATE INDEX IF NOT EXISTS bid_order_creation_idx ON bid_order (creation_height DESC)
  187. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  188. CREATE UNIQUE INDEX IF NOT EXISTS block_timestamp_idx ON block (timestamp DESC)
  189. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  190. ALTER TABLE goods ADD COLUMN IF NOT EXISTS parsed_tags ARRAY
  191. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  192. CREATE TABLE IF NOT EXISTS tag (db_id IDENTITY, tag VARCHAR NOT NULL, in_stock_count INT NOT NULL, total_count INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  193. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  194. CREATE UNIQUE INDEX IF NOT EXISTS tag_tag_idx ON tag (tag, height DESC)
  195. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  196. CREATE INDEX IF NOT EXISTS tag_in_stock_count_idx ON tag (in_stock_count DESC, height DESC)
  197. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  198. CREATE TABLE IF NOT EXISTS currency (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, name_lower VARCHAR AS LOWER (name) NOT NULL, code VARCHAR NOT NULL, description VARCHAR, type INT NOT NULL, initial_supply BIGINT NOT NULL DEFAULT 0, reserve_supply BIGINT NOT NULL, max_supply BIGINT NOT NULL, creation_height INT NOT NULL, issuance_height INT NOT NULL, min_reserve_per_unit_nqt BIGINT NOT NULL, min_difficulty TINYINT NOT NULL, max_difficulty TINYINT NOT NULL, ruleset TINYINT NOT NULL, algorithm TINYINT NOT NULL, decimals TINYINT NOT NULL DEFAULT 0,height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  199. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  200. CREATE UNIQUE INDEX IF NOT EXISTS currency_id_height_idx ON currency (id, height DESC)
  201. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  202. CREATE INDEX IF NOT EXISTS currency_account_id_idx ON currency (account_id)
  203. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  204. CREATE TABLE IF NOT EXISTS account_currency (db_id IDENTITY, account_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, units BIGINT NOT NULL, unconfirmed_units BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  205. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  206. CREATE UNIQUE INDEX IF NOT EXISTS account_currency_id_height_idx ON account_currency (account_id, currency_id, height DESC)
  207. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  208. CREATE TABLE IF NOT EXISTS currency_founder (db_id IDENTITY, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, amount BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  209. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  210. CREATE UNIQUE INDEX IF NOT EXISTS currency_founder_currency_id_idx ON currency_founder (currency_id, account_id, height DESC)
  211. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  212. CREATE TABLE IF NOT EXISTS currency_mint (db_id IDENTITY, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, counter BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  213. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  214. CREATE UNIQUE INDEX IF NOT EXISTS currency_mint_currency_id_account_id_idx ON currency_mint (currency_id, account_id, height DESC)
  215. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  216. CREATE TABLE IF NOT EXISTS buy_offer (db_id IDENTITY, id BIGINT NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL,rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, transaction_height INT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  217. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  218. CREATE UNIQUE INDEX IF NOT EXISTS buy_offer_id_idx ON buy_offer (id, height DESC)
  219. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  220. CREATE INDEX IF NOT EXISTS buy_offer_currency_id_account_id_idx ON buy_offer (currency_id, account_id, height DESC)
  221. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  222. CREATE TABLE IF NOT EXISTS sell_offer (db_id IDENTITY, id BIGINT NOT NULL, currency_id BIGINT NOT NULL, account_id BIGINT NOT NULL, rate BIGINT NOT NULL, unit_limit BIGINT NOT NULL, supply BIGINT NOT NULL, expiration_height INT NOT NULL, transaction_height INT NOT NULL, creation_height INT NOT NULL, transaction_index SMALLINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  223. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  224. CREATE UNIQUE INDEX IF NOT EXISTS sell_offer_id_idx ON sell_offer (id, height DESC)
  225. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  226. CREATE INDEX IF NOT EXISTS sell_offer_currency_id_account_id_idx ON sell_offer (currency_id, account_id, height DESC)
  227. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  228. CREATE TABLE IF NOT EXISTS exchange (db_id IDENTITY, transaction_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, block_id BIGINT NOT NULL, offer_id BIGINT NOT NULL, seller_id BIGINT NOT NULL, buyer_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
  229. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  230. CREATE UNIQUE INDEX IF NOT EXISTS exchange_offer_idx ON exchange (transaction_id, offer_id)
  231. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  232. CREATE INDEX IF NOT EXISTS exchange_currency_id_idx ON exchange (currency_id, height DESC)
  233. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  234. CREATE INDEX IF NOT EXISTS exchange_seller_id_idx ON exchange (seller_id, height DESC)
  235. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  236. CREATE INDEX IF NOT EXISTS exchange_buyer_id_idx ON exchange (buyer_id, height DESC)
  237. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  238. CREATE TABLE IF NOT EXISTS currency_transfer (db_id IDENTITY, id BIGINT NOT NULL, currency_id BIGINT NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT NOT NULL, units BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
  239. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  240. CREATE UNIQUE INDEX IF NOT EXISTS currency_transfer_id_idx ON currency_transfer (id)
  241. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  242. CREATE INDEX IF NOT EXISTS currency_transfer_currency_id_idx ON currency_transfer (currency_id, height DESC)
  243. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  244. CREATE INDEX IF NOT EXISTS currency_transfer_sender_id_idx ON currency_transfer (sender_id, height DESC)
  245. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  246. CREATE INDEX IF NOT EXISTS currency_transfer_recipient_id_idx ON currency_transfer (recipient_id, height DESC)
  247. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  248. CREATE INDEX IF NOT EXISTS account_currency_units_idx ON account_currency (units DESC)
  249. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  250. CREATE INDEX IF NOT EXISTS currency_name_idx ON currency (name_lower, height DESC)
  251. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  252. CREATE INDEX IF NOT EXISTS currency_code_idx ON currency (code, height DESC)
  253. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  254. CREATE INDEX IF NOT EXISTS buy_offer_rate_height_idx ON buy_offer (rate DESC, creation_height ASC)
  255. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  256. CREATE INDEX IF NOT EXISTS sell_offer_rate_height_idx ON sell_offer (rate ASC, creation_height ASC)
  257. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  258. DROP INDEX IF EXISTS unconfirmed_transaction_height_fee_timestamp_idx
  259. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  260. ALTER TABLE unconfirmed_transaction DROP COLUMN IF EXISTS timestamp
  261. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  262. ALTER TABLE unconfirmed_transaction ADD COLUMN IF NOT EXISTS arrival_timestamp BIGINT NOT NULL DEFAULT 0
  263. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  264. CREATE INDEX IF NOT EXISTS unconfirmed_transaction_height_fee_timestamp_idx ON unconfirmed_transaction (transaction_height ASC, fee_per_byte DESC, arrival_timestamp ASC)
  265. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.trimDerivedTables = "true"
  266. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.testnetNumberOfForkConfirmations = "1"
  267. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.simulateEndlessDownload not defined, assuming false
  268. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.trimFrequency = "1000"
  269. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableGetMoreBlocksThread not defined, assuming false
  270. 2017-04-09 04:43:40 INFO: BlockDb.deleteAll: Deleting blockchain...
  271. 2017-04-09 04:43:40 FINE: TransactionalDb.endTransaction: Average database transaction time is 0.003 seconds
  272. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  273. ALTER TABLE transaction ADD COLUMN IF NOT EXISTS transaction_index SMALLINT NOT NULL
  274. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  275. TRUNCATE TABLE ask_order
  276. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  277. ALTER TABLE ask_order ADD COLUMN IF NOT EXISTS transaction_index SMALLINT NOT NULL
  278. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  279. TRUNCATE TABLE bid_order
  280. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  281. ALTER TABLE bid_order ADD COLUMN IF NOT EXISTS transaction_index SMALLINT NOT NULL
  282. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  283. CREATE TABLE IF NOT EXISTS scan (rescan BOOLEAN NOT NULL DEFAULT FALSE, height INT NOT NULL DEFAULT 0, validate BOOLEAN NOT NULL DEFAULT FALSE)
  284. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  285. INSERT INTO scan (rescan, height, validate) VALUES (false, 0, false)
  286. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  287. CREATE INDEX IF NOT EXISTS currency_creation_height_idx ON currency (creation_height DESC)
  288. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  289. CREATE TABLE IF NOT EXISTS currency_supply (db_id IDENTITY, id BIGINT NOT NULL, current_supply BIGINT NOT NULL, current_reserve_per_unit_nqt BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  290. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  291. CREATE UNIQUE INDEX IF NOT EXISTS currency_supply_id_height_idx ON currency_supply (id, height DESC)
  292. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  293. TRUNCATE TABLE currency
  294. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  295. ALTER TABLE currency DROP COLUMN IF EXISTS current_supply
  296. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  297. ALTER TABLE currency DROP COLUMN IF EXISTS current_reserve_per_unit_nqt
  298. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  299. CREATE TABLE IF NOT EXISTS public_key (db_id IDENTITY, account_id BIGINT NOT NULL, public_key BINARY(32), height INT NOT NULL, FOREIGN KEY (height) REFERENCES block (height) ON DELETE CASCADE, latest BOOLEAN NOT NULL DEFAULT TRUE)
  300. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  301. ALTER TABLE account DROP COLUMN IF EXISTS public_key
  302. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  303. ALTER TABLE block DROP COLUMN IF EXISTS generator_public_key
  304. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  305. ALTER TABLE transaction DROP COLUMN IF EXISTS sender_public_key
  306. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  307. CREATE INDEX IF NOT EXISTS account_guaranteed_balance_height_idx ON account_guaranteed_balance(height)
  308. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  309. CREATE INDEX IF NOT EXISTS asset_transfer_height_idx ON asset_transfer(height)
  310. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  311. CREATE INDEX IF NOT EXISTS currency_transfer_height_idx ON currency_transfer(height)
  312. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  313. CREATE INDEX IF NOT EXISTS exchange_height_idx ON exchange(height)
  314. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  315. CREATE INDEX IF NOT EXISTS trade_height_idx ON trade(height)
  316. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  317. DROP TABLE IF EXISTS poll
  318. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  319. DROP TABLE IF EXISTS vote
  320. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  321. CREATE TABLE IF NOT EXISTS vote (db_id IDENTITY, id BIGINT NOT NULL, poll_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, vote_bytes VARBINARY NOT NULL, height INT NOT NULL)
  322. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  323. CREATE UNIQUE INDEX IF NOT EXISTS vote_id_idx ON vote (id)
  324. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  325. CREATE UNIQUE INDEX IF NOT EXISTS vote_poll_id_idx ON vote (poll_id, voter_id)
  326. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  327. CREATE TABLE IF NOT EXISTS poll (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, options ARRAY NOT NULL, min_num_options TINYINT, max_num_options TINYINT, min_range_value TINYINT, max_range_value TINYINT, timestamp INT NOT NULL, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, min_balance BIGINT, min_balance_model TINYINT, holding_id BIGINT, height INT NOT NULL)
  328. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  329. CREATE TABLE IF NOT EXISTS poll_result (db_id IDENTITY, poll_id BIGINT NOT NULL, result BIGINT, weight BIGINT NOT NULL, height INT NOT NULL)
  330. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  331. ALTER TABLE transaction ADD COLUMN IF NOT EXISTS phased BOOLEAN NOT NULL DEFAULT FALSE
  332. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  333. CREATE TABLE IF NOT EXISTS phasing_poll (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, whitelist_size TINYINT NOT NULL DEFAULT 0, finish_height INT NOT NULL, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, hashed_secret VARBINARY, algorithm TINYINT, height INT NOT NULL)
  334. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  335. CREATE TABLE IF NOT EXISTS phasing_vote (db_id IDENTITY, vote_id BIGINT NOT NULL, transaction_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, height INT NOT NULL)
  336. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  337. CREATE TABLE IF NOT EXISTS phasing_poll_voter (db_id IDENTITY, transaction_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, height INT NOT NULL)
  338. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  339. CREATE INDEX IF NOT EXISTS vote_height_idx ON vote(height)
  340. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  341. CREATE UNIQUE INDEX IF NOT EXISTS poll_id_idx ON poll(id)
  342. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  343. CREATE INDEX IF NOT EXISTS poll_height_idx ON poll(height)
  344. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  345. CREATE INDEX IF NOT EXISTS poll_account_idx ON poll(account_id)
  346. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  347. CREATE INDEX IF NOT EXISTS poll_finish_height_idx ON poll(finish_height DESC)
  348. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  349. CREATE INDEX IF NOT EXISTS poll_result_poll_id_idx ON poll_result(poll_id)
  350. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  351. CREATE INDEX IF NOT EXISTS poll_result_height_idx ON poll_result(height)
  352. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  353. CREATE UNIQUE INDEX IF NOT EXISTS phasing_poll_id_idx ON phasing_poll(id)
  354. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  355. CREATE INDEX IF NOT EXISTS phasing_poll_height_idx ON phasing_poll(height)
  356. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  357. CREATE INDEX IF NOT EXISTS phasing_poll_account_id_idx ON phasing_poll(account_id, height DESC)
  358. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  359. CREATE INDEX IF NOT EXISTS phasing_poll_holding_id_idx ON phasing_poll(holding_id, height DESC)
  360. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  361. CREATE UNIQUE INDEX IF NOT EXISTS phasing_vote_transaction_voter_idx ON phasing_vote(transaction_id, voter_id)
  362. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  363. CREATE UNIQUE INDEX IF NOT EXISTS phasing_poll_voter_transaction_voter_idx ON phasing_poll_voter(transaction_id, voter_id)
  364. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  365. CREATE TABLE IF NOT EXISTS phasing_poll_result (db_id IDENTITY, id BIGINT NOT NULL, result BIGINT NOT NULL, approved BOOLEAN NOT NULL, height INT NOT NULL)
  366. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  367. CREATE UNIQUE INDEX IF NOT EXISTS phasing_poll_result_id_idx ON phasing_poll_result(id)
  368. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  369. CREATE INDEX IF NOT EXISTS phasing_poll_result_height_idx ON phasing_poll_result(height)
  370. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  371. CREATE INDEX IF NOT EXISTS currency_founder_account_id_idx ON currency_founder (account_id, height DESC)
  372. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  373. TRUNCATE TABLE trade
  374. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  375. ALTER TABLE trade ADD COLUMN IF NOT EXISTS is_buy BOOLEAN NOT NULL
  376. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  377. CREATE INDEX IF NOT EXISTS phasing_poll_voter_height_idx ON phasing_poll_voter(height)
  378. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  379. TRUNCATE TABLE ask_order
  380. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  381. ALTER TABLE ask_order ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
  382. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  383. TRUNCATE TABLE bid_order
  384. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  385. ALTER TABLE bid_order ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
  386. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  387. TRUNCATE TABLE buy_offer
  388. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  389. ALTER TABLE buy_offer ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
  390. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  391. TRUNCATE TABLE sell_offer
  392. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  393. ALTER TABLE sell_offer ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
  394. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  395. CREATE INDEX IF NOT EXISTS phasing_vote_height_idx ON phasing_vote(height)
  396. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  397. DROP INDEX IF EXISTS transaction_full_hash_idx
  398. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  399. DROP INDEX IF EXISTS trade_ask_bid_idx
  400. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  401. CREATE INDEX IF NOT EXISTS trade_ask_idx ON trade (ask_order_id, height DESC)
  402. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  403. CREATE INDEX IF NOT EXISTS trade_bid_idx ON trade (bid_order_id, height DESC)
  404. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  405. CREATE TABLE IF NOT EXISTS account_info (db_id IDENTITY, account_id BIGINT NOT NULL, name VARCHAR, description VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  406. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  407. CREATE UNIQUE INDEX IF NOT EXISTS account_info_id_height_idx ON account_info (account_id, height DESC)
  408. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  409. ALTER TABLE account DROP COLUMN IF EXISTS name
  410. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  411. ALTER TABLE account DROP COLUMN IF EXISTS description
  412. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  413. ALTER TABLE account DROP COLUMN IF EXISTS message_pattern_regex
  414. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  415. ALTER TABLE account DROP COLUMN IF EXISTS message_pattern_flags
  416. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  417. TRUNCATE TABLE poll
  418. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  419. ALTER TABLE poll ADD COLUMN IF NOT EXISTS timestamp INT NOT NULL
  420. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  421. CREATE TABLE IF NOT EXISTS redeems (db_id IDENTITY, id BIGINT NOT NULL, address VARCHAR, secp_signatures VARCHAR, receiver_id BIGINT NOT NULL, amount BIGINT NOT NULL, block_timestamp INT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL, FOREIGN KEY (height) REFERENCES block (height) ON DELETE CASCADE, latest BOOLEAN NOT NULL DEFAULT TRUE)
  422. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  423. CREATE TABLE IF NOT EXISTS prunable_message (db_id IDENTITY, id BIGINT NOT NULL, sender_id BIGINT NOT NULL, recipient_id BIGINT, message VARBINARY NOT NULL, is_text BOOLEAN NOT NULL, is_compressed BOOLEAN NOT NULL, encrypted_message VARBINARY, encrypted_is_text BOOLEAN DEFAULT FALSE, is_encrypted BOOLEAN NOT NULL, timestamp INT NOT NULL, expiration INT NOT NULL, height INT NOT NULL, FOREIGN KEY (height) REFERENCES block (height) ON DELETE CASCADE)
  424. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  425. CREATE TABLE IF NOT EXISTS prunable_source_code (db_id IDENTITY, id BIGINT NOT NULL, work_id BIGINT NOT NULL, source VARBINARY NOT NULL, language SMALLINT NOT NULL, timestamp INT NOT NULL, expiration INT NOT NULL, height INT NOT NULL, FOREIGN KEY (height) REFERENCES block (height) ON DELETE CASCADE)
  426. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  427. CREATE UNIQUE INDEX IF NOT EXISTS prunable_message_id_idx ON prunable_message (id)
  428. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  429. CREATE INDEX IF NOT EXISTS prunable_message_expiration_idx ON prunable_message (expiration DESC)
  430. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  431. ALTER TABLE transaction ADD COLUMN IF NOT EXISTS has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE
  432. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  433. TRUNCATE TABLE unconfirmed_transaction
  434. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  435. ALTER TABLE unconfirmed_transaction ADD COLUMN IF NOT EXISTS prunable_json VARCHAR
  436. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  437. CREATE INDEX IF NOT EXISTS prunable_message_sender_idx ON prunable_message (sender_id)
  438. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  439. CREATE INDEX IF NOT EXISTS prunable_message_recipient_idx ON prunable_message (recipient_id)
  440. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  441. CREATE INDEX IF NOT EXISTS prunable_source_code_workid_idx ON prunable_source_code (work_id)
  442. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  443. ALTER TABLE transaction ADD COLUMN IF NOT EXISTS has_prunable_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE
  444. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  445. CREATE UNIQUE INDEX IF NOT EXISTS prunable_source_code_id_idx ON prunable_source_code (id)
  446. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  447. ALTER TABLE prunable_message ALTER COLUMN expiration RENAME TO transaction_timestamp
  448. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  449. UPDATE prunable_message SET transaction_timestamp = SELECT timestamp FROM transaction WHERE prunable_message.id = transaction.id
  450. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  451. ALTER INDEX prunable_message_expiration_idx RENAME TO prunable_message_transaction_timestamp_idx
  452. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  453. ALTER TABLE prunable_message ALTER COLUMN timestamp RENAME TO block_timestamp
  454. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  455. DROP INDEX IF EXISTS prunable_message_timestamp_idx
  456. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  457. CREATE INDEX IF NOT EXISTS prunable_message_block_timestamp_dbid_idx ON prunable_message (block_timestamp DESC, db_id DESC)
  458. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  459. DROP INDEX IF EXISTS prunable_message_height_idx
  460. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  461. DROP INDEX IF EXISTS public_key_height_idx
  462. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  463. CREATE TABLE IF NOT EXISTS tagged_data (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, name VARCHAR NOT NULL, description VARCHAR, tags VARCHAR, parsed_tags ARRAY, type VARCHAR, data VARBINARY NOT NULL, is_text BOOLEAN NOT NULL, filename VARCHAR, channel VARCHAR, block_timestamp INT NOT NULL, transaction_timestamp INT NOT NULL, height INT NOT NULL, FOREIGN KEY (height) REFERENCES block (height) ON DELETE CASCADE, latest BOOLEAN NOT NULL DEFAULT TRUE)
  464. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  465. CREATE UNIQUE INDEX IF NOT EXISTS tagged_data_id_height_idx ON tagged_data (id, height DESC)
  466. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  467. CREATE INDEX IF NOT EXISTS tagged_data_expiration_idx ON tagged_data (transaction_timestamp DESC)
  468. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  469. CREATE INDEX IF NOT EXISTS tagged_data_account_id_height_idx ON tagged_data (account_id, height DESC)
  470. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  471. CREATE INDEX IF NOT EXISTS tagged_data_block_timestamp_height_db_id_idx ON tagged_data (block_timestamp DESC, height DESC, db_id DESC)
  472. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  473. CREATE INDEX IF NOT EXISTS prunable_source_code_expiration_idx ON prunable_source_code (expiration DESC)
  474. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  475. CREATE TABLE IF NOT EXISTS data_tag (db_id IDENTITY, tag VARCHAR NOT NULL, tag_count INT NOT NULL, height INT NOT NULL, FOREIGN KEY (height) REFERENCES block (height) ON DELETE CASCADE, latest BOOLEAN NOT NULL DEFAULT TRUE)
  476. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  477. CREATE UNIQUE INDEX IF NOT EXISTS data_tag_tag_height_idx ON data_tag (tag, height DESC)
  478. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  479. CREATE INDEX IF NOT EXISTS data_tag_count_height_idx ON data_tag (tag_count DESC, height DESC)
  480. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  481. CREATE TABLE IF NOT EXISTS tagged_data_timestamp (db_id IDENTITY, id BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  482. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  483. CREATE UNIQUE INDEX IF NOT EXISTS tagged_data_timestamp_id_height_idx ON tagged_data_timestamp (id, height DESC)
  484. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  485. ALTER TABLE prunable_source_code ALTER COLUMN expiration RENAME TO transaction_timestamp
  486. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  487. UPDATE prunable_source_code SET transaction_timestamp = SELECT timestamp FROM transaction WHERE prunable_source_code.id = transaction.id
  488. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  489. ALTER INDEX prunable_source_code_expiration_idx RENAME TO prunable_source_code_transaction_timestamp_idx
  490. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  491. ALTER TABLE prunable_source_code ALTER COLUMN timestamp RENAME TO block_timestamp
  492. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  493. ALTER TABLE tagged_data ADD COLUMN IF NOT EXISTS channel VARCHAR
  494. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  495. CREATE INDEX IF NOT EXISTS tagged_data_channel_idx ON tagged_data (channel, height DESC)
  496. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  497. ALTER TABLE peer ADD COLUMN IF NOT EXISTS last_updated INT
  498. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  499. DROP INDEX IF EXISTS account_current_lessee_id_leasing_height_idx
  500. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  501. TRUNCATE TABLE account
  502. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  503. ALTER TABLE account ADD COLUMN IF NOT EXISTS active_lessee_id BIGINT
  504. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  505. ALTER TABLE account DROP COLUMN IF EXISTS current_leasing_height_from
  506. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  507. ALTER TABLE account DROP COLUMN IF EXISTS current_leasing_height_to
  508. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  509. ALTER TABLE account DROP COLUMN IF EXISTS current_lessee_id
  510. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  511. ALTER TABLE account DROP COLUMN IF EXISTS next_leasing_height_from
  512. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  513. ALTER TABLE account DROP COLUMN IF EXISTS next_leasing_height_to
  514. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  515. ALTER TABLE account DROP COLUMN IF EXISTS next_lessee_id
  516. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  517. CREATE INDEX IF NOT EXISTS account_active_lessee_id_idx ON account (active_lessee_id)
  518. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  519. CREATE TABLE IF NOT EXISTS account_lease (db_id IDENTITY, lessor_id BIGINT NOT NULL, current_leasing_height_from INT, current_leasing_height_to INT, current_lessee_id BIGINT, next_leasing_height_from INT, next_leasing_height_to INT, next_lessee_id BIGINT, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  520. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  521. CREATE UNIQUE INDEX IF NOT EXISTS account_lease_lessor_id_height_idx ON account_lease (lessor_id, height DESC)
  522. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  523. CREATE INDEX IF NOT EXISTS account_lease_current_leasing_height_from_idx ON account_lease (current_leasing_height_from)
  524. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  525. CREATE INDEX IF NOT EXISTS account_lease_current_leasing_height_to_idx ON account_lease (current_leasing_height_to)
  526. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  527. CREATE INDEX IF NOT EXISTS account_lease_height_id_idx ON account_lease (height, lessor_id)
  528. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  529. CREATE INDEX IF NOT EXISTS account_asset_asset_id_idx ON account_asset (asset_id)
  530. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  531. CREATE INDEX IF NOT EXISTS account_currency_currency_id_idx ON account_currency (currency_id)
  532. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  533. CREATE INDEX IF NOT EXISTS currency_issuance_height_idx ON currency (issuance_height)
  534. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  535. CREATE INDEX IF NOT EXISTS unconfirmed_transaction_expiration_idx ON unconfirmed_transaction (expiration DESC)
  536. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  537. DROP INDEX IF EXISTS account_height_idx
  538. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  539. CREATE INDEX IF NOT EXISTS account_height_id_idx ON account (height, id)
  540. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  541. DROP INDEX IF EXISTS account_asset_height_idx
  542. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  543. CREATE INDEX IF NOT EXISTS account_asset_height_id_idx ON account_asset (height, account_id, asset_id)
  544. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  545. DROP INDEX IF EXISTS account_currency_height_idx
  546. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  547. CREATE INDEX IF NOT EXISTS account_currency_height_id_idx ON account_currency (height, account_id, currency_id)
  548. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  549. DROP INDEX IF EXISTS alias_height_idx
  550. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  551. CREATE INDEX IF NOT EXISTS alias_height_id_idx ON alias (height, id)
  552. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  553. DROP INDEX IF EXISTS alias_offer_height_idx
  554. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  555. CREATE INDEX IF NOT EXISTS alias_offer_height_id_idx ON alias_offer (height, id)
  556. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  557. DROP INDEX IF EXISTS ask_order_height_idx
  558. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  559. CREATE INDEX IF NOT EXISTS ask_order_height_id_idx ON ask_order (height, id)
  560. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  561. DROP INDEX IF EXISTS bid_order_height_idx
  562. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  563. CREATE INDEX IF NOT EXISTS bid_order_height_id_idx ON bid_order (height, id)
  564. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  565. DROP INDEX IF EXISTS buy_offer_height_idx
  566. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  567. CREATE INDEX IF NOT EXISTS buy_offer_height_id_idx ON buy_offer (height, id)
  568. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  569. DROP INDEX IF EXISTS currency_height_idx
  570. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  571. CREATE INDEX IF NOT EXISTS currency_height_id_idx ON currency (height, id)
  572. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  573. DROP INDEX IF EXISTS currency_founder_height_idx
  574. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  575. CREATE INDEX IF NOT EXISTS currency_founder_height_id_idx ON currency_founder (height, currency_id, account_id)
  576. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  577. DROP INDEX IF EXISTS currency_mint_height_idx
  578. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  579. CREATE INDEX IF NOT EXISTS currency_mint_height_id_idx ON currency_mint (height, currency_id, account_id)
  580. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  581. DROP INDEX IF EXISTS currency_supply_height_idx
  582. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  583. CREATE INDEX IF NOT EXISTS currency_supply_height_id_idx ON currency_supply (height, id)
  584. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  585. DROP INDEX IF EXISTS goods_height_idx
  586. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  587. CREATE INDEX IF NOT EXISTS goods_height_id_idx ON goods (height, id)
  588. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  589. DROP INDEX IF EXISTS purchase_height_idx
  590. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  591. CREATE INDEX IF NOT EXISTS purchase_height_id_idx ON purchase (height, id)
  592. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  593. DROP INDEX IF EXISTS purchase_feedback_height_idx
  594. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  595. CREATE INDEX IF NOT EXISTS purchase_feedback_height_id_idx ON purchase_feedback (height, id)
  596. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  597. DROP INDEX IF EXISTS purchase_public_feedback_height_idx
  598. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  599. CREATE INDEX IF NOT EXISTS purchase_public_feedback_height_id_idx ON purchase_public_feedback (height, id)
  600. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  601. DROP INDEX IF EXISTS sell_offer_height_idx
  602. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  603. CREATE INDEX IF NOT EXISTS sell_offer_height_id_idx ON sell_offer (height, id)
  604. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  605. DROP INDEX IF EXISTS tag_height_idx
  606. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  607. CREATE INDEX IF NOT EXISTS tag_height_tag_idx ON tag (height, tag)
  608. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  609. DROP INDEX IF EXISTS account_info_height_idx
  610. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  611. CREATE INDEX IF NOT EXISTS account_info_height_id_idx ON account_info (height, account_id)
  612. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  613. DROP INDEX IF EXISTS tagged_data_timestamp_height_idx
  614. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  615. CREATE INDEX IF NOT EXISTS tagged_data_timestamp_height_id_idx ON tagged_data_timestamp (height, id)
  616. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  617. CREATE INDEX IF NOT EXISTS trade_height_db_id_idx ON trade (height DESC, db_id DESC)
  618. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  619. DROP INDEX IF EXISTS prunable_source_code_idx
  620. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  621. CREATE INDEX IF NOT EXISTS exchange_height_db_id_idx ON exchange (height DESC, db_id DESC)
  622. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  623. CREATE INDEX IF NOT EXISTS prunable_source_code_block_timestamp_dbid_idx ON prunable_source_code (block_timestamp DESC, db_id DESC)
  624. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  625. CREATE TABLE IF NOT EXISTS exchange_request (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, currency_id BIGINT NOT NULL, units BIGINT NOT NULL, rate BIGINT NOT NULL, is_buy BOOLEAN NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
  626. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  627. CREATE UNIQUE INDEX IF NOT EXISTS exchange_request_id_idx ON exchange_request (id)
  628. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  629. CREATE INDEX IF NOT EXISTS exchange_request_account_currency_idx ON exchange_request (account_id, currency_id, height DESC)
  630. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  631. CREATE INDEX IF NOT EXISTS exchange_request_currency_idx ON exchange_request (currency_id, height DESC)
  632. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  633. CREATE INDEX IF NOT EXISTS exchange_request_height_db_id_idx ON exchange_request (height DESC, db_id DESC)
  634. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  635. CREATE INDEX IF NOT EXISTS exchange_request_height_idx ON exchange_request (height)
  636. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  637. CREATE TABLE IF NOT EXISTS account_supernode_deposit (db_id IDENTITY, lessor_id BIGINT NOT NULL, current_deposit_height_from INT, current_deposit_height_to INT, uris VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  638. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  639. CREATE TABLE IF NOT EXISTS account_ledger (db_id IDENTITY, account_id BIGINT NOT NULL, event_type TINYINT NOT NULL, event_id BIGINT NOT NULL, holding_type TINYINT NOT NULL, holding_id BIGINT, change BIGINT NOT NULL, balance BIGINT NOT NULL, block_id BIGINT NOT NULL, height INT NOT NULL, timestamp INT NOT NULL)
  640. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  641. CREATE INDEX IF NOT EXISTS account_ledger_id_idx ON account_ledger(account_id, db_id)
  642. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  643. CREATE INDEX IF NOT EXISTS account_ledger_height_idx ON account_ledger(height)
  644. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  645. ALTER TABLE peer ADD COLUMN IF NOT EXISTS services BIGINT
  646. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  647. TRUNCATE TABLE asset
  648. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  649. ALTER TABLE asset ADD COLUMN IF NOT EXISTS latest BOOLEAN NOT NULL DEFAULT TRUE
  650. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  651. DROP INDEX IF EXISTS asset_id_idx
  652. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  653. ALTER TABLE asset ADD COLUMN IF NOT EXISTS initial_quantity BIGINT NOT NULL
  654. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  655. CREATE TABLE IF NOT EXISTS tagged_data_extend (db_id IDENTITY, id BIGINT NOT NULL, extend_id BIGINT NOT NULL, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  656. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  657. CREATE INDEX IF NOT EXISTS tagged_data_extend_id_height_idx ON tagged_data_extend(id, height DESC)
  658. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  659. CREATE INDEX IF NOT EXISTS tagged_data_extend_height_id_idx ON tagged_data_extend(height, id)
  660. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  661. ALTER TABLE transaction ADD COLUMN IF NOT EXISTS has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE
  662. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  663. UPDATE transaction SET has_prunable_attachment = TRUE WHERE type = 6
  664. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  665. TRUNCATE TABLE account
  666. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  667. ALTER TABLE account DROP COLUMN IF EXISTS creation_height
  668. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  669. ALTER TABLE account DROP COLUMN IF EXISTS key_height
  670. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  671. DROP INDEX IF EXISTS public_key_account_id_idx
  672. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  673. ALTER TABLE public_key ADD COLUMN IF NOT EXISTS latest BOOLEAN NOT NULL DEFAULT TRUE
  674. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  675. CREATE UNIQUE INDEX IF NOT EXISTS public_key_account_id_height_idx ON public_key (account_id, height DESC)
  676. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  677. DROP INDEX IF EXISTS prunable_source_code_height_idx
  678. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  679. DROP INDEX IF EXISTS asset_height_idx
  680. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  681. DROP INDEX IF EXISTS asset_height_db_id_idx
  682. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  683. DROP INDEX IF EXISTS asset_id_height_idx
  684. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  685. CREATE UNIQUE INDEX IF NOT EXISTS asset_id_height_idx ON asset (id, height DESC)
  686. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  687. CREATE INDEX IF NOT EXISTS asset_height_id_idx ON asset (height, id)
  688. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  689. TRUNCATE TABLE account_ledger
  690. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  691. CREATE TABLE IF NOT EXISTS shuffling (db_id IDENTITY, id BIGINT NOT NULL, holding_id BIGINT NULL, holding_type TINYINT NOT NULL, issuer_id BIGINT NOT NULL, amount BIGINT NOT NULL, participant_count TINYINT NOT NULL, blocks_remaining SMALLINT NULL, stage TINYINT NOT NULL, assignee_account_id BIGINT NULL, registrant_count TINYINT NOT NULL, recipient_public_keys ARRAY, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  692. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  693. CREATE UNIQUE INDEX IF NOT EXISTS shuffling_id_height_idx ON shuffling (id, height DESC)
  694. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  695. CREATE INDEX IF NOT EXISTS shuffling_holding_id_height_idx ON shuffling (holding_id, height DESC)
  696. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  697. CREATE INDEX IF NOT EXISTS shuffling_assignee_account_id_height_idx ON shuffling (assignee_account_id, height DESC)
  698. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  699. CREATE INDEX IF NOT EXISTS shuffling_height_id_idx ON shuffling (height, id)
  700. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  701. CREATE TABLE IF NOT EXISTS shuffling_participant (db_id IDENTITY, shuffling_id BIGINT NOT NULL, account_id BIGINT NOT NULL, next_account_id BIGINT NULL, participant_index TINYINT NOT NULL, state TINYINT NOT NULL, blame_data ARRAY, key_seeds ARRAY, data_transaction_full_hash BINARY(32), height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  702. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  703. CREATE UNIQUE INDEX IF NOT EXISTS shuffling_participant_shuffling_id_account_id_idx ON shuffling_participant (shuffling_id, account_id, height DESC)
  704. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  705. CREATE INDEX IF NOT EXISTS shuffling_participant_height_idx ON shuffling_participant (height, shuffling_id, account_id)
  706. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  707. CREATE TABLE IF NOT EXISTS shuffling_data (db_id IDENTITY, shuffling_id BIGINT NOT NULL, account_id BIGINT NOT NULL, data ARRAY, transaction_timestamp INT NOT NULL, height INT NOT NULL, FOREIGN KEY (height) REFERENCES block (height) ON DELETE CASCADE)
  708. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  709. CREATE UNIQUE INDEX IF NOT EXISTS shuffling_data_id_height_idx ON shuffling_data (shuffling_id, height DESC)
  710. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  711. CREATE INDEX shuffling_data_transaction_timestamp_idx ON shuffling_data (transaction_timestamp DESC)
  712. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  713. CREATE TABLE IF NOT EXISTS phasing_poll_linked_transaction (db_id IDENTITY, transaction_id BIGINT NOT NULL, linked_full_hash BINARY(32) NOT NULL, linked_transaction_id BIGINT NOT NULL, height INT NOT NULL)
  714. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  715. CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_height_idx ON phasing_poll_linked_transaction (height)
  716. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  717. ALTER TABLE phasing_poll DROP COLUMN IF EXISTS linked_full_hashes
  718. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  719. CREATE TABLE IF NOT EXISTS account_control_phasing (db_id IDENTITY, account_id BIGINT NOT NULL, whitelist ARRAY, voting_model TINYINT NOT NULL, quorum BIGINT, min_balance BIGINT, holding_id BIGINT, min_balance_model TINYINT, max_fees BIGINT, min_duration SMALLINT, max_duration SMALLINT, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  720. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  721. ALTER TABLE account ADD COLUMN IF NOT EXISTS has_control_phasing BOOLEAN NOT NULL DEFAULT FALSE
  722. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  723. CREATE UNIQUE INDEX IF NOT EXISTS account_control_phasing_id_height_idx ON account_control_phasing (account_id, height DESC)
  724. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  725. CREATE INDEX IF NOT EXISTS account_control_phasing_height_id_idx ON account_control_phasing (height, account_id)
  726. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  727. CREATE TABLE IF NOT EXISTS account_property (db_id IDENTITY, id BIGINT NOT NULL, account_id BIGINT NOT NULL, setter_id BIGINT, property VARCHAR NOT NULL, value VARCHAR, height INT NOT NULL, latest BOOLEAN NOT NULL DEFAULT TRUE)
  728. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  729. CREATE UNIQUE INDEX IF NOT EXISTS account_property_id_height_idx ON account_property (id, height DESC)
  730. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  731. CREATE INDEX IF NOT EXISTS account_property_height_id_idx ON account_property (height, id)
  732. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  733. CREATE INDEX IF NOT EXISTS account_property_account_height_idx ON account_property (account_id, height DESC)
  734. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  735. CREATE INDEX IF NOT EXISTS account_property_setter_account_idx ON account_property (setter_id, account_id)
  736. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  737. CREATE TABLE IF NOT EXISTS asset_delete (db_id IDENTITY, id BIGINT NOT NULL, asset_id BIGINT NOT NULL, account_id BIGINT NOT NULL, quantity BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
  738. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  739. CREATE UNIQUE INDEX IF NOT EXISTS asset_delete_id_idx ON asset_delete (id)
  740. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  741. CREATE INDEX IF NOT EXISTS asset_delete_asset_id_idx ON asset_delete (asset_id, height DESC)
  742. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  743. CREATE INDEX IF NOT EXISTS asset_delete_account_id_idx ON asset_delete (account_id, height DESC)
  744. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  745. CREATE INDEX IF NOT EXISTS asset_delete_height_idx ON asset_delete (height)
  746. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  747. ALTER TABLE prunable_message ADD COLUMN IF NOT EXISTS encrypted_message VARBINARY
  748. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  749. ALTER TABLE prunable_message ADD COLUMN IF NOT EXISTS encrypted_is_text BOOLEAN DEFAULT FALSE
  750. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  751. UPDATE prunable_message SET encrypted_message = message WHERE is_encrypted IS TRUE
  752. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  753. ALTER TABLE prunable_message ALTER COLUMN message SET NULL
  754. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  755. UPDATE prunable_message SET message = NULL WHERE is_encrypted IS TRUE
  756. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  757. UPDATE prunable_message SET encrypted_is_text = TRUE WHERE is_encrypted IS TRUE AND is_text IS TRUE
  758. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  759. UPDATE prunable_message SET encrypted_is_text = FALSE WHERE is_encrypted IS TRUE AND is_text IS FALSE
  760. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  761. UPDATE prunable_message SET is_text = FALSE where is_encrypted IS TRUE
  762. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  763. ALTER TABLE prunable_message ALTER COLUMN is_text RENAME TO message_is_text
  764. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  765. ALTER TABLE prunable_message DROP COLUMN IF EXISTS is_encrypted
  766. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  767. TRUNCATE TABLE shuffling
  768. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  769. ALTER TABLE shuffling ADD COLUMN IF NOT EXISTS registrant_count TINYINT NOT NULL
  770. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  771. ALTER TABLE account_property ALTER COLUMN account_id RENAME TO recipient_id
  772. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  773. ALTER INDEX account_property_account_height_idx RENAME TO account_property_recipient_height_idx
  774. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  775. ALTER INDEX account_property_setter_account_idx RENAME TO account_property_setter_recipient_idx
  776. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  777. CREATE TABLE IF NOT EXISTS referenced_transaction (db_id IDENTITY, transaction_id BIGINT NOT NULL, FOREIGN KEY (transaction_id) REFERENCES transaction (id) ON DELETE CASCADE, referenced_transaction_id BIGINT NOT NULL)
  778. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  779. CREATE INDEX IF NOT EXISTS referenced_transaction_referenced_transaction_id_idx ON referenced_transaction (referenced_transaction_id)
  780. 2017-04-09 04:43:40 FINE: BlockchainProcessorImpl.scheduleScan: Scheduled scan starting from height 0
  781. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  782. DROP INDEX IF EXISTS phasing_poll_linked_transaction_id_link_idx
  783. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  784. CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_id_link_idx ON phasing_poll_linked_transaction (transaction_id, linked_transaction_id)
  785. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  786. DROP INDEX IF EXISTS phasing_poll_linked_transaction_link_id_idx
  787. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  788. CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_link_id_idx ON phasing_poll_linked_transaction (linked_transaction_id, transaction_id)
  789. 2017-04-09 04:43:40 FINE: BasicDb.getPooledConnection: Database connection pool current size: 3
  790. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  791. ALTER TABLE goods ADD COLUMN IF NOT EXISTS has_image BOOLEAN NOT NULL DEFAULT FALSE
  792. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  793. ALTER TABLE purchase ADD COLUMN IF NOT EXISTS goods_is_text BOOLEAN NOT NULL DEFAULT TRUE
  794. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  795. CREATE INDEX IF NOT EXISTS shuffling_blocks_remaining_height_idx ON shuffling (blocks_remaining, height DESC)
  796. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  797. CREATE TABLE IF NOT EXISTS account_fxt (id BIGINT NOT NULL, balance VARBINARY NOT NULL, height INT NOT NULL)
  798. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  799. CREATE UNIQUE INDEX IF NOT EXISTS account_fxt_id_idx ON account_fxt (id, height DESC)
  800. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  801. CREATE TABLE IF NOT EXISTS asset_dividend (db_id IDENTITY, id BIGINT NOT NULL, asset_id BIGINT NOT NULL, amount BIGINT NOT NULL, dividend_height INT NOT NULL, total_dividend BIGINT NOT NULL, num_accounts BIGINT NOT NULL, timestamp INT NOT NULL, height INT NOT NULL)
  802. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  803. CREATE UNIQUE INDEX IF NOT EXISTS asset_dividend_id_idx ON asset_dividend (id)
  804. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  805. CREATE INDEX IF NOT EXISTS asset_dividend_asset_id_idx ON asset_dividend (asset_id, height DESC)
  806. 2017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
  807. CREATE INDEX IF NOT EXISTS asset_dividend_height_idx ON asset_dividend (height)
  808. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enableTransactionRebroadcasting = "true"
  809. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.testUnconfirmedTransactions not defined, assuming false
  810. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxUnconfirmedTransactions = "2000"
  811. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableProcessTransactionsThread not defined, assuming false
  812. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableRebroadcastTransactionsThread not defined, assuming false
  813. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableRemoveUnconfirmedTransactionsThread not defined, assuming false
  814. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableProcessWaitingTransactionsThread not defined, assuming false
  815. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enablePublicKeyCache = "true"
  816. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.ledgerTrimKeep = "30000"
  817. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.ledgerAccounts = "*"
  818. 2017-04-09 04:43:40 INFO: AccountLedger.<clinit>: Account ledger is tracking all accounts
  819. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.ledgerLogUnconfirmed = "2"
  820. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.hideErrorDetails = "false"
  821. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.myPlatform not defined
  822. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.myAddress not defined
  823. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.peerServerPort = "7874"
  824. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.shareMyAddress = "true"
  825. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enablePeerUPnP = "true"
  826. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.myHallmark not defined
  827. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.adminPassword not defined
  828. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxAPIRecords = "100"
  829. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enableAPIUPnP = "false"
  830. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.apiServerIdleTimeout = "30000"
  831. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.apiServerCORS = "true"
  832. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.disabledAPIs not defined
  833. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.disabledAPITags not defined
  834. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.allowedBotHosts = "*"
  835. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enableAPIServer = "true"
  836. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.apiServerHost = "0.0.0.0"
  837. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableAdminPassword = "false"
  838. 2017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.apiSSL = "false"
  839. 2017-04-09 04:43:40 INFO: API.<clinit>: API server using HTTP port 6876
  840. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.apiResourceBase = "./html/ui"
  841. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.apiWelcomeFile = "index.html"
  842. 2017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.javadocResourceBase = "./html/doc"
  843. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxUploadFileSize not defined or not numeric, using default value 0
  844. 2017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxUploadFileSize not defined or not numeric, using default value 0
  845. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableAPIServerGZIPFilter = "false"
  846. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.apiFrameOptionsSameOrigin = "true"
  847. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfForgers = "100"
  848. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableFakeForging not defined, assuming false
  849. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableFakeForging not defined, assuming false
  850. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disableGenerateBlocksThread not defined, assuming false
  851. 2017-04-09 04:43:41 FINE: Peers.<clinit>: My peer info:
  852. {"apiPort":6876,"application":"Elastic","apiServerIdleTimeout":30000,"services":"20","version":"1.0.4","platform":"Windows Server 2012 R2 amd64","disabledAPIs":"","shareAddress":true}
  853. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.defaultTestnetPeers not defined
  854. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.testnetPeers = "ec2-52-28-123-208.eu-central-1.compute.amazonaws.com; ec2-52-57-31-137.eu-central-1.compute.amazonaws.com"
  855. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.knownBlacklistedPeers not defined
  856. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfInboundConnections = "250"
  857. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfOutboundConnections = "50"
  858. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfConnectedPublicPeers = "20"
  859. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfKnownPeers = "2000"
  860. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.minNumberOfKnownPeers = "1000"
  861. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.connectTimeout = "10000"
  862. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.readTimeout = "20000"
  863. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableHallmarkProtection = "false"
  864. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.pushThreshold = "0"
  865. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.pullThreshold = "0"
  866. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.useWebSockets = "true"
  867. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.webSocketIdleTimeout = "900000"
  868. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enablePeerServerGZIPFilter = "true"
  869. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.blacklistingPeriod = "1"
  870. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.communicationLoggingMask = "0"
  871. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.sendToPeersLimit = "10"
  872. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.usePeersDb = "true"
  873. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.savePeers = "true"
  874. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.getMorePeers = "true"
  875. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.cjdnsOnly = "false"
  876. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.ignorePeerAnnouncedAddress = "false"
  877. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disablePeerConnectingThread not defined, assuming false
  878. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disablePeerUnBlacklistingThread not defined, assuming false
  879. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disableGetMorePeersThread not defined, assuming false
  880. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerHost = "0.0.0.0"
  881. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.peerServerIdleTimeout = "30000"
  882. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enablePeerServerDoSFilter = "true"
  883. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerDoSFilter.maxRequestsPerSec = "30"
  884. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerDoSFilter.delayMs = "1000"
  885. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerDoSFilter.maxRequestMs = "300000"
  886. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableAPIProxy = "true"
  887. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.apiProxyBlacklistingPeriod = "1800000"
  888. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.forceAPIProxyServerURL not defined
  889. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.addOns not defined
  890. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.allowedUserHosts = "127.0.0.1; localhost; [0:0:0:0:0:0:0:1];"
  891. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableUIServer = "false"
  892. 2017-04-09 04:43:41 INFO: Users.<clinit>: User interface server not enabled
  893. 2017-04-09 04:43:41 INFO: Nxt$Init.<clinit>: Genesis ID: 18036849569196248673
  894. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.superNodePassphrase not defined
  895. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.autoRenewSupernode not defined, assuming false
  896. 2017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.superNodeExternalIP not defined
  897. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.connectToSupernodes = "true"
  898. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.timeMultiplier not defined or not numeric, using default value 0
  899. 2017-04-09 04:43:41 FINE: ThreadPool.start: Running 2 tasks...
  900. 2017-04-09 04:43:41 INFO: BlockchainProcessorImpl.addGenesisBlock: Genesis block (-409894504513302943) not in database, starting from scratch
  901. 2017-04-09 04:43:41 FINE: Peers$1.run: Loading known peers from the database...
  902. 2017-04-09 04:43:41 FINE: BlockchainProcessorImpl.addBlock: [!!] Redeem Statistics: 0.0 % of all XEL have been redeemed.
  903. 2017-04-09 04:43:41 INFO: BlockchainProcessorImpl.addGenesisBlock: Genesis block (-409894504513302943) recreated and added to our fresh blockchain
  904. 2017-04-09 04:43:41 FINE: BlockchainProcessorImpl.scheduleScan: Scheduled scan starting from height 0
  905. 2017-04-09 04:43:41 INFO: BlockchainProcessorImpl.scan: Scanning blockchain starting from height 0...
  906. 2017-04-09 04:43:41 FINE: BlockchainProcessorImpl.scan: Rolled back derived tables
  907. 2017-04-09 04:43:41 INFO: BlockchainProcessorImpl.lambda$new$1: processed block 0
  908. 2017-04-09 04:43:41 INFO: BlockchainProcessorImpl.scan: ...done at height 0
  909. 2017-04-09 04:43:41 FINE: ThreadPool.start: Running 2 final tasks...
  910. 2017-04-09 04:43:41 INFO: UPnP.init: Looking for UPnP gateway device...
  911. 2017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.apiServerEnforcePOST = "true"
  912. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.upnpGatewayTimeout not defined or not numeric, using default value 7000
  913. 2017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.upnpDiscoverTimeout not defined or not numeric, using default value 3000
  914. 2017-04-09 04:43:41 WARNING: THIS IS NOT A STABLE RELEASE! DO NOT USE IN PRODUCTION!
  915. 2017-04-09 04:43:41 WARNING: Download a stable release from http://download.eclipse.org/jetty/
  916. 2017-04-09 04:43:41 INFO: API.lambda$static$1: Started API server at 0.0.0.0:6876
  917. 2017-04-09 04:43:42 FINE: sun.net.www.MessageHeader@2d5e7c5a5 pairs: {GET /rootDesc.xml HTTP/1.1: null}{User-Agent: Java/1.8.0_121}{Host: 192.168.2.1:5555}{Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2}{Connection: keep-alive}
  918. 2017-04-09 04:43:42 FINE: sun.net.www.MessageHeader@204921b95 pairs: {null: HTTP/1.1 200 OK}{Content-Type: text/xml}{Connection: close}{Content-Length: 2592}{Server: <censored>}
  919. 2017-04-09 04:43:45 FINE: UPnP.lambda$init$0: UPnP gateway device found on 192.168.2.53
  920. 2017-04-09 04:43:45 FINE: sun.net.www.MessageHeader@41a189688 pairs: {POST /ctl/IPConn HTTP/1.1: null}{Content-Type: text/xml}{SOAPAction: "urn:schemas-upnp-org:service:WANIPConnection:1#GetStatusInfo"}{Connection: Close}{User-Agent: Java/1.8.0_121}{Host: 192.168.2.1:5555}{Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2}{Content-Length: 311}
  921. 2017-04-09 04:43:45 FINE: sun.net.www.MessageHeader@716ae1765 pairs: {null: HTTP/1.1 200 OK}{Content-Type: text/xml}{Connection: close}{Content-Length: 427}{Server: <censored>}
  922. 2017-04-09 04:43:45 FINE: sun.net.www.MessageHeader@56d0113c8 pairs: {POST /ctl/IPConn HTTP/1.1: null}{Content-Type: text/xml}{SOAPAction: "urn:schemas-upnp-org:service:WANIPConnection:1#GetExternalIPAddress"}{Connection: Close}{User-Agent: Java/1.8.0_121}{Host: 192.168.2.1:5555}{Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2}{Content-Length: 325}
  923. 2017-04-09 04:43:45 FINE: sun.net.www.MessageHeader@65ec4a3f5 pairs: {null: HTTP/1.1 200 OK}{Content-Type: text/xml}{Connection: close}{Content-Length: 360}{Server: <censored>}
  924. 2017-04-09 04:43:45 FINE: UPnP.init: Using UPnP gateway device on 192.168.2.53
  925. 2017-04-09 04:43:45 INFO: UPnP.init: External IP address is <censored>
  926. 2017-04-09 04:43:45 FINE: sun.net.www.MessageHeader@284b75238 pairs: {POST /ctl/IPConn HTTP/1.1: null}{Content-Type: text/xml}{SOAPAction: "urn:schemas-upnp-org:service:WANIPConnection:1#AddPortMapping"}{Connection: Close}{User-Agent: Java/1.8.0_121}{Host: 192.168.2.1:5555}{Accept: text/html, image/gif, image/jpeg, *; q=.2, */*; q=.2}{Content-Length: 635}
  927. 2017-04-09 04:43:45 FINE: sun.net.www.MessageHeader@e8c500d5 pairs: {null: HTTP/1.1 200 OK}{Content-Type: text/xml}{Connection: close}{Content-Length: 263}{Server: <censored>}
  928. 2017-04-09 04:43:45 FINE: UPnP.addPort: Mapped port [<censored>]:6874
  929. 2017-04-09 04:43:45 WARNING: THIS IS NOT A STABLE RELEASE! DO NOT USE IN PRODUCTION!
  930. 2017-04-09 04:43:45 WARNING: Download a stable release from http://download.eclipse.org/jetty/
  931. 2017-04-09 04:43:45 INFO: Peers$Init.lambda$static$0: Started peer networking server at 0.0.0.0:6874
  932. 2017-04-09 04:43:45 FINE: ThreadPool.start: Starting 9 background jobs
  933. 2017-04-09 04:43:45 FINE: ThreadPool.start: Starting 2 delayed tasks
  934. 2017-04-09 04:43:45 FINE: Peers.lambda$static$2: Known peers: 2
  935. 2017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Initialization took 6 seconds
  936. 2017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Nxt server 1.0.4 started successfully.
  937. 2017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Copyright © 2013-2016 The XEL Core Developers.
  938. 2017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Distributed under GPLv2, with ABSOLUTELY NO WARRANTY.
  939. 2017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Client UI is at http://localhost:6876/index.html
  940. 2017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: RUNNING ON TESTNET - DO NOT USE REAL ACCOUNTS!
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!