dpbdjvcb

12017-04-09 04:43:39 INFO: nxt.enableStackTraces = "true"
22017-04-09 04:43:39 INFO: nxt.enableLogTraceback = "true"
32017-04-09 04:43:39 INFO: Logger.<clinit>: logging enabled
42017-04-09 04:43:39 INFO: Nxt.getStringProperty: socksProxyHost not defined
52017-04-09 04:43:39 INFO: Nxt.getStringProperty: socksProxyPort not defined
62017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.version = 1.8.0_121
72017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vm.version = 25.121-b13
82017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vm.name = Java HotSpot(TM) 64-Bit Server VM
92017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vendor = Oracle Corporation
102017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.vm.vendor = Oracle Corporation
112017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.home = C:\Java\jdk1.8.0_121\jre
122017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.library.path = <censored>
132017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.class.path = E:\apache-maven-3.3.9\boot\plexus-classworlds-2.5.2.jar
142017-04-09 04:43:39 FINE: Nxt.logSystemProperties: os.arch = amd64
152017-04-09 04:43:39 FINE: Nxt.logSystemProperties: sun.arch.data.model = 64
162017-04-09 04:43:39 FINE: Nxt.logSystemProperties: os.name = Windows Server 2012 R2
172017-04-09 04:43:39 FINE: Nxt.logSystemProperties: file.encoding = Cp1252
182017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.security.policy = null
192017-04-09 04:43:39 FINE: Nxt.logSystemProperties: java.security.manager = null
202017-04-09 04:43:39 FINE: Nxt.logSystemProperties: nxt.runtime.mode = null
212017-04-09 04:43:39 FINE: Nxt.logSystemProperties: nxt.runtime.dirProvider = null
222017-04-09 04:43:39 FINE: Nxt.logSystemProperties: availableProcessors = 8
232017-04-09 04:43:39 FINE: Nxt.logSystemProperties: maxMemory = 954728448
242017-04-09 04:43:39 FINE: Nxt.logSystemProperties: processId = 2672
252017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.isTestnet = "true"
262017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.isOffline = "false"
272017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.isLightClient = "false"
282017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.maxRollback = "800"
292017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.testnetGuaranteedBalanceConfirmations = "10"
302017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.testnetLeasingDelay not defined or not numeric, using default value 1440
312017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testnetMinForgingBalance not defined
322017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.forgingDelay = "20"
332017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.forgingSpeedup = "3"
342017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.maxPrunableLifetime = "7776000"
352017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.includeExpiredPrunable = "true"
362017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.supernodeBinding not defined or not numeric, using default value 20
372017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.correctInvalidFees = "false"
382017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.statementLogThreshold = "10000"
392017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.transactionLogThreshold = "15000"
402017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.transactionLogInterval = "15"
412017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbCacheKB = "0"
422017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbUrl not defined
432017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbType = "h2"
442017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbDir = "./elastic_test_db/nxt"
452017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbParams = "DB_CLOSE_ON_EXIT=FALSE;MVCC=TRUE;MV_STORE=FALSE"
462017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbUsername = "sa"
472017-04-09 04:43:39 INFO: Nxt.getStringProperty: nxt.testDbPassword = "{not logged}"
482017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.maxDbConnections = "30"
492017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbLoginTimeout = "70"
502017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbDefaultLockTimeout = "60"
512017-04-09 04:43:39 INFO: Nxt.getIntProperty: nxt.dbMaxMemoryRows = "1000000"
522017-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
532017-04-09 04:43:39 INFO: Nxt.getBooleanProperty: nxt.useStrongSecureRandom = "false"
542017-04-09 04:43:40 FINE: BasicDb.getPooledConnection: Database connection pool current size: 1
552017-04-09 04:43:40 INFO: DbVersion.init: Initializing an empty database
562017-04-09 04:43:40 FINE: BasicDb.getPooledConnection: Database connection pool current size: 2
572017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
58CREATE 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))
592017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
60CREATE UNIQUE INDEX IF NOT EXISTS block_id_idx ON block (id)
612017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
62CREATE 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)
632017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
64CREATE UNIQUE INDEX IF NOT EXISTS transaction_id_idx ON transaction (id)
652017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
66CREATE UNIQUE INDEX IF NOT EXISTS block_height_idx ON block (height)
672017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
68CREATE UNIQUE INDEX IF NOT EXISTS transaction_snid_idx ON transaction (sncleanid)
692017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
70CREATE INDEX IF NOT EXISTS block_generator_id_idx ON block (generator_id)
712017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
72CREATE INDEX IF NOT EXISTS transaction_sender_id_idx ON transaction (sender_id)
732017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
74CREATE INDEX IF NOT EXISTS transaction_recipient_id_idx ON transaction (recipient_id)
752017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
76CREATE 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) 
772017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
78CREATE 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)
792017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
80CREATE 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)
812017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
82CREATE TABLE IF NOT EXISTS peer (address VARCHAR PRIMARY KEY, last_updated INT, services BIGINT)
832017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
84CREATE INDEX IF NOT EXISTS transaction_block_timestamp_idx ON transaction (block_timestamp DESC)
852017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
86CREATE 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)
872017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
88CREATE UNIQUE INDEX IF NOT EXISTS alias_id_height_idx ON alias (id, height DESC)
892017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
90CREATE INDEX IF NOT EXISTS alias_account_id_idx ON alias (account_id, height DESC)
912017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
92CREATE INDEX IF NOT EXISTS alias_name_lower_idx ON alias (alias_name_lower)
932017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
94CREATE 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)
952017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
96CREATE UNIQUE INDEX IF NOT EXISTS alias_offer_id_height_idx ON alias_offer (id, height DESC)
972017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
98CREATE 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)
992017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
100CREATE INDEX IF NOT EXISTS asset_account_id_idx ON asset (account_id)
1012017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
102CREATE 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)
1032017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
104CREATE INDEX IF NOT EXISTS trade_asset_id_idx ON trade (asset_id, height DESC)
1052017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
106CREATE INDEX IF NOT EXISTS trade_seller_id_idx ON trade (seller_id, height DESC)
1072017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
108CREATE INDEX IF NOT EXISTS trade_buyer_id_idx ON trade (buyer_id, height DESC)
1092017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
110CREATE 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)
1112017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
112CREATE UNIQUE INDEX IF NOT EXISTS ask_order_id_height_idx ON ask_order (id, height DESC)
1132017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
114CREATE INDEX IF NOT EXISTS ask_order_account_id_idx ON ask_order (account_id, height DESC)
1152017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
116CREATE INDEX IF NOT EXISTS ask_order_asset_id_price_idx ON ask_order (asset_id, price)
1172017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
118CREATE 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)
1192017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
120CREATE UNIQUE INDEX IF NOT EXISTS bid_order_id_height_idx ON bid_order (id, height DESC)
1212017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
122CREATE INDEX IF NOT EXISTS bid_order_account_id_idx ON bid_order (account_id, height DESC)
1232017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
124CREATE INDEX IF NOT EXISTS bid_order_asset_id_price_idx ON bid_order (asset_id, price DESC)
1252017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
126CREATE 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)
1272017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
128CREATE UNIQUE INDEX IF NOT EXISTS goods_id_height_idx ON goods (id, height DESC)
1292017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
130CREATE INDEX IF NOT EXISTS goods_seller_id_name_idx ON goods (seller_id, name)
1312017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
132CREATE INDEX IF NOT EXISTS goods_timestamp_idx ON goods (timestamp DESC, height DESC)
1332017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
134CREATE 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)
1352017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
136CREATE UNIQUE INDEX IF NOT EXISTS purchase_id_height_idx ON purchase (id, height DESC)
1372017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
138CREATE INDEX IF NOT EXISTS purchase_buyer_id_height_idx ON purchase (buyer_id, height DESC)
1392017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
140CREATE INDEX IF NOT EXISTS purchase_seller_id_height_idx ON purchase (seller_id, height DESC)
1412017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
142CREATE INDEX IF NOT EXISTS purchase_deadline_idx ON purchase (deadline DESC, height DESC)
1432017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
144CREATE 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)
1452017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
146CREATE UNIQUE INDEX IF NOT EXISTS account_id_height_idx ON account (id, height DESC)
1472017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
148CREATE 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)
1492017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
150CREATE UNIQUE INDEX IF NOT EXISTS account_asset_id_height_idx ON account_asset (account_id, asset_id, height DESC)
1512017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
152CREATE TABLE IF NOT EXISTS account_guaranteed_balance (db_id IDENTITY, account_id BIGINT NOT NULL, additions BIGINT NOT NULL, height INT NOT NULL)
1532017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
154CREATE UNIQUE INDEX IF NOT EXISTS account_guaranteed_balance_id_height_idx ON account_guaranteed_balance (account_id, height DESC)
1552017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
156CREATE 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)
1572017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
158CREATE INDEX IF NOT EXISTS purchase_feedback_id_height_idx ON purchase_feedback (id, height DESC)
1592017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
160CREATE 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)
1612017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
162CREATE INDEX IF NOT EXISTS purchase_public_feedback_id_height_idx ON purchase_public_feedback (id, height DESC)
1632017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
164CREATE 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)
1652017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
166CREATE UNIQUE INDEX IF NOT EXISTS unconfirmed_transaction_id_idx ON unconfirmed_transaction (id)
1672017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
168CREATE UNIQUE INDEX IF NOT EXISTS unconfirmed_transaction_snid_idx ON unconfirmed_transaction (sncleanid)
1692017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
170CREATE 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)
1712017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
172CREATE UNIQUE INDEX IF NOT EXISTS asset_transfer_id_idx ON asset_transfer (id)
1732017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
174CREATE INDEX IF NOT EXISTS asset_transfer_asset_id_idx ON asset_transfer (asset_id, height DESC)
1752017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
176CREATE INDEX IF NOT EXISTS asset_transfer_sender_id_idx ON asset_transfer (sender_id, height DESC)
1772017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
178CREATE INDEX IF NOT EXISTS asset_transfer_recipient_id_idx ON asset_transfer (recipient_id, height DESC)
1792017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
180CREATE INDEX IF NOT EXISTS account_asset_quantity_idx ON account_asset (quantity DESC)
1812017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
182CREATE INDEX IF NOT EXISTS purchase_timestamp_idx ON purchase (timestamp DESC, id)
1832017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
184CREATE INDEX IF NOT EXISTS ask_order_creation_idx ON ask_order (creation_height DESC)
1852017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
186CREATE INDEX IF NOT EXISTS bid_order_creation_idx ON bid_order (creation_height DESC)
1872017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
188CREATE UNIQUE INDEX IF NOT EXISTS block_timestamp_idx ON block (timestamp DESC)
1892017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
190ALTER TABLE goods ADD COLUMN IF NOT EXISTS parsed_tags ARRAY
1912017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
192CREATE 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)
1932017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
194CREATE UNIQUE INDEX IF NOT EXISTS tag_tag_idx ON tag (tag, height DESC)
1952017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
196CREATE INDEX IF NOT EXISTS tag_in_stock_count_idx ON tag (in_stock_count DESC, height DESC)
1972017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
198CREATE 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)
1992017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
200CREATE UNIQUE INDEX IF NOT EXISTS currency_id_height_idx ON currency (id, height DESC)
2012017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
202CREATE INDEX IF NOT EXISTS currency_account_id_idx ON currency (account_id)
2032017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
204CREATE 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)
2052017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
206CREATE UNIQUE INDEX IF NOT EXISTS account_currency_id_height_idx ON account_currency (account_id, currency_id, height DESC)
2072017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
208CREATE 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)
2092017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
210CREATE UNIQUE INDEX IF NOT EXISTS currency_founder_currency_id_idx ON currency_founder (currency_id, account_id, height DESC)
2112017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
212CREATE 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)
2132017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
214CREATE UNIQUE INDEX IF NOT EXISTS currency_mint_currency_id_account_id_idx ON currency_mint (currency_id, account_id, height DESC)
2152017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
216CREATE 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)
2172017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
218CREATE UNIQUE INDEX IF NOT EXISTS buy_offer_id_idx ON buy_offer (id, height DESC)
2192017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
220CREATE INDEX IF NOT EXISTS buy_offer_currency_id_account_id_idx ON buy_offer (currency_id, account_id, height DESC)
2212017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
222CREATE 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)
2232017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
224CREATE UNIQUE INDEX IF NOT EXISTS sell_offer_id_idx ON sell_offer (id, height DESC)
2252017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
226CREATE INDEX IF NOT EXISTS sell_offer_currency_id_account_id_idx ON sell_offer (currency_id, account_id, height DESC)
2272017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
228CREATE 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)
2292017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
230CREATE UNIQUE INDEX IF NOT EXISTS exchange_offer_idx ON exchange (transaction_id, offer_id)
2312017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
232CREATE INDEX IF NOT EXISTS exchange_currency_id_idx ON exchange (currency_id, height DESC)
2332017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
234CREATE INDEX IF NOT EXISTS exchange_seller_id_idx ON exchange (seller_id, height DESC)
2352017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
236CREATE INDEX IF NOT EXISTS exchange_buyer_id_idx ON exchange (buyer_id, height DESC)
2372017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
238CREATE 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)
2392017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
240CREATE UNIQUE INDEX IF NOT EXISTS currency_transfer_id_idx ON currency_transfer (id)
2412017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
242CREATE INDEX IF NOT EXISTS currency_transfer_currency_id_idx ON currency_transfer (currency_id, height DESC)
2432017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
244CREATE INDEX IF NOT EXISTS currency_transfer_sender_id_idx ON currency_transfer (sender_id, height DESC)
2452017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
246CREATE INDEX IF NOT EXISTS currency_transfer_recipient_id_idx ON currency_transfer (recipient_id, height DESC)
2472017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
248CREATE INDEX IF NOT EXISTS account_currency_units_idx ON account_currency (units DESC)
2492017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
250CREATE INDEX IF NOT EXISTS currency_name_idx ON currency (name_lower, height DESC)
2512017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
252CREATE INDEX IF NOT EXISTS currency_code_idx ON currency (code, height DESC)
2532017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
254CREATE INDEX IF NOT EXISTS buy_offer_rate_height_idx ON buy_offer (rate DESC, creation_height ASC)
2552017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
256CREATE INDEX IF NOT EXISTS sell_offer_rate_height_idx ON sell_offer (rate ASC, creation_height ASC)
2572017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
258DROP INDEX IF EXISTS unconfirmed_transaction_height_fee_timestamp_idx
2592017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
260ALTER TABLE unconfirmed_transaction DROP COLUMN IF EXISTS timestamp
2612017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
262ALTER TABLE unconfirmed_transaction ADD COLUMN IF NOT EXISTS arrival_timestamp BIGINT NOT NULL DEFAULT 0
2632017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
264CREATE INDEX IF NOT EXISTS unconfirmed_transaction_height_fee_timestamp_idx ON unconfirmed_transaction (transaction_height ASC, fee_per_byte DESC, arrival_timestamp ASC)
2652017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.trimDerivedTables = "true"
2662017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.testnetNumberOfForkConfirmations = "1"
2672017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.simulateEndlessDownload not defined, assuming false
2682017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.trimFrequency = "1000"
2692017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableGetMoreBlocksThread not defined, assuming false
2702017-04-09 04:43:40 INFO: BlockDb.deleteAll: Deleting blockchain...
2712017-04-09 04:43:40 FINE: TransactionalDb.endTransaction: Average database transaction time is 0.003 seconds
2722017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
273ALTER TABLE transaction ADD COLUMN IF NOT EXISTS transaction_index SMALLINT NOT NULL
2742017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
275TRUNCATE TABLE ask_order
2762017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
277ALTER TABLE ask_order ADD COLUMN IF NOT EXISTS transaction_index SMALLINT NOT NULL
2782017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
279TRUNCATE TABLE bid_order
2802017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
281ALTER TABLE bid_order ADD COLUMN IF NOT EXISTS transaction_index SMALLINT NOT NULL
2822017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
283CREATE TABLE IF NOT EXISTS scan (rescan BOOLEAN NOT NULL DEFAULT FALSE, height INT NOT NULL DEFAULT 0, validate BOOLEAN NOT NULL DEFAULT FALSE)
2842017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
285INSERT INTO scan (rescan, height, validate) VALUES (false, 0, false)
2862017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
287CREATE INDEX IF NOT EXISTS currency_creation_height_idx ON currency (creation_height DESC)
2882017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
289CREATE 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)
2902017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
291CREATE UNIQUE INDEX IF NOT EXISTS currency_supply_id_height_idx ON currency_supply (id, height DESC)
2922017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
293TRUNCATE TABLE currency
2942017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
295ALTER TABLE currency DROP COLUMN IF EXISTS current_supply
2962017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
297ALTER TABLE currency DROP COLUMN IF EXISTS current_reserve_per_unit_nqt
2982017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
299CREATE 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)
3002017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
301ALTER TABLE account DROP COLUMN IF EXISTS public_key
3022017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
303ALTER TABLE block DROP COLUMN IF EXISTS generator_public_key
3042017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
305ALTER TABLE transaction DROP COLUMN IF EXISTS sender_public_key
3062017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
307CREATE INDEX IF NOT EXISTS account_guaranteed_balance_height_idx ON account_guaranteed_balance(height)
3082017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
309CREATE INDEX IF NOT EXISTS asset_transfer_height_idx ON asset_transfer(height)
3102017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
311CREATE INDEX IF NOT EXISTS currency_transfer_height_idx ON currency_transfer(height)
3122017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
313CREATE INDEX IF NOT EXISTS exchange_height_idx ON exchange(height)
3142017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
315CREATE INDEX IF NOT EXISTS trade_height_idx ON trade(height)
3162017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
317DROP TABLE IF EXISTS poll
3182017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
319DROP TABLE IF EXISTS vote
3202017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
321CREATE 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)
3222017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
323CREATE UNIQUE INDEX IF NOT EXISTS vote_id_idx ON vote (id)
3242017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
325CREATE UNIQUE INDEX IF NOT EXISTS vote_poll_id_idx ON vote (poll_id, voter_id)
3262017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
327CREATE 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)
3282017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
329CREATE TABLE IF NOT EXISTS poll_result (db_id IDENTITY, poll_id BIGINT NOT NULL, result BIGINT, weight BIGINT NOT NULL, height INT NOT NULL)
3302017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
331ALTER TABLE transaction ADD COLUMN IF NOT EXISTS phased BOOLEAN NOT NULL DEFAULT FALSE
3322017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
333CREATE 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)
3342017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
335CREATE 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)
3362017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
337CREATE TABLE IF NOT EXISTS phasing_poll_voter (db_id IDENTITY, transaction_id BIGINT NOT NULL, voter_id BIGINT NOT NULL, height INT NOT NULL)
3382017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
339CREATE INDEX IF NOT EXISTS vote_height_idx ON vote(height)
3402017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
341CREATE UNIQUE INDEX IF NOT EXISTS poll_id_idx ON poll(id)
3422017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
343CREATE INDEX IF NOT EXISTS poll_height_idx ON poll(height)
3442017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
345CREATE INDEX IF NOT EXISTS poll_account_idx ON poll(account_id)
3462017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
347CREATE INDEX IF NOT EXISTS poll_finish_height_idx ON poll(finish_height DESC)
3482017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
349CREATE INDEX IF NOT EXISTS poll_result_poll_id_idx ON poll_result(poll_id)
3502017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
351CREATE INDEX IF NOT EXISTS poll_result_height_idx ON poll_result(height)
3522017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
353CREATE UNIQUE INDEX IF NOT EXISTS phasing_poll_id_idx ON phasing_poll(id)
3542017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
355CREATE INDEX IF NOT EXISTS phasing_poll_height_idx ON phasing_poll(height)
3562017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
357CREATE INDEX IF NOT EXISTS phasing_poll_account_id_idx ON phasing_poll(account_id, height DESC)
3582017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
359CREATE INDEX IF NOT EXISTS phasing_poll_holding_id_idx ON phasing_poll(holding_id, height DESC)
3602017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
361CREATE UNIQUE INDEX IF NOT EXISTS phasing_vote_transaction_voter_idx ON phasing_vote(transaction_id, voter_id)
3622017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
363CREATE UNIQUE INDEX IF NOT EXISTS phasing_poll_voter_transaction_voter_idx ON phasing_poll_voter(transaction_id, voter_id)
3642017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
365CREATE 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)
3662017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
367CREATE UNIQUE INDEX IF NOT EXISTS phasing_poll_result_id_idx ON phasing_poll_result(id)
3682017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
369CREATE INDEX IF NOT EXISTS phasing_poll_result_height_idx ON phasing_poll_result(height)
3702017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
371CREATE INDEX IF NOT EXISTS currency_founder_account_id_idx ON currency_founder (account_id, height DESC)
3722017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
373TRUNCATE TABLE trade
3742017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
375ALTER TABLE trade ADD COLUMN IF NOT EXISTS is_buy BOOLEAN NOT NULL
3762017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
377CREATE INDEX IF NOT EXISTS phasing_poll_voter_height_idx ON phasing_poll_voter(height)
3782017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
379TRUNCATE TABLE ask_order
3802017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
381ALTER TABLE ask_order ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
3822017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
383TRUNCATE TABLE bid_order
3842017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
385ALTER TABLE bid_order ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
3862017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
387TRUNCATE TABLE buy_offer
3882017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
389ALTER TABLE buy_offer ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
3902017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
391TRUNCATE TABLE sell_offer
3922017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
393ALTER TABLE sell_offer ADD COLUMN IF NOT EXISTS transaction_height INT NOT NULL
3942017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
395CREATE INDEX IF NOT EXISTS phasing_vote_height_idx ON phasing_vote(height)
3962017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
397DROP INDEX IF EXISTS transaction_full_hash_idx
3982017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
399DROP INDEX IF EXISTS trade_ask_bid_idx
4002017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
401CREATE INDEX IF NOT EXISTS trade_ask_idx ON trade (ask_order_id, height DESC)
4022017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
403CREATE INDEX IF NOT EXISTS trade_bid_idx ON trade (bid_order_id, height DESC)
4042017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
405CREATE 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)
4062017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
407CREATE UNIQUE INDEX IF NOT EXISTS account_info_id_height_idx ON account_info (account_id, height DESC)
4082017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
409ALTER TABLE account DROP COLUMN IF EXISTS name
4102017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
411ALTER TABLE account DROP COLUMN IF EXISTS description
4122017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
413ALTER TABLE account DROP COLUMN IF EXISTS message_pattern_regex
4142017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
415ALTER TABLE account DROP COLUMN IF EXISTS message_pattern_flags
4162017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
417TRUNCATE TABLE poll
4182017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
419ALTER TABLE poll ADD COLUMN IF NOT EXISTS timestamp INT NOT NULL
4202017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
421CREATE 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)
4222017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
423CREATE 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)
4242017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
425CREATE 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)
4262017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
427CREATE UNIQUE INDEX IF NOT EXISTS prunable_message_id_idx ON prunable_message (id)
4282017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
429CREATE INDEX IF NOT EXISTS prunable_message_expiration_idx ON prunable_message (expiration DESC)
4302017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
431ALTER TABLE transaction ADD COLUMN IF NOT EXISTS has_prunable_message BOOLEAN NOT NULL DEFAULT FALSE
4322017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
433TRUNCATE TABLE unconfirmed_transaction
4342017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
435ALTER TABLE unconfirmed_transaction ADD COLUMN IF NOT EXISTS prunable_json VARCHAR
4362017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
437CREATE INDEX IF NOT EXISTS prunable_message_sender_idx ON prunable_message (sender_id)
4382017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
439CREATE INDEX IF NOT EXISTS prunable_message_recipient_idx ON prunable_message (recipient_id)
4402017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
441CREATE INDEX IF NOT EXISTS prunable_source_code_workid_idx ON prunable_source_code (work_id)
4422017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
443ALTER TABLE transaction ADD COLUMN IF NOT EXISTS has_prunable_encrypted_message BOOLEAN NOT NULL DEFAULT FALSE
4442017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
445CREATE UNIQUE INDEX IF NOT EXISTS prunable_source_code_id_idx ON prunable_source_code (id)
4462017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
447ALTER TABLE prunable_message ALTER COLUMN expiration RENAME TO transaction_timestamp
4482017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
449UPDATE prunable_message SET transaction_timestamp = SELECT timestamp FROM transaction WHERE prunable_message.id = transaction.id
4502017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
451ALTER INDEX prunable_message_expiration_idx RENAME TO prunable_message_transaction_timestamp_idx
4522017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
453ALTER TABLE prunable_message ALTER COLUMN timestamp RENAME TO block_timestamp
4542017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
455DROP INDEX IF EXISTS prunable_message_timestamp_idx
4562017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
457CREATE INDEX IF NOT EXISTS prunable_message_block_timestamp_dbid_idx ON prunable_message (block_timestamp DESC, db_id DESC)
4582017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
459DROP INDEX IF EXISTS prunable_message_height_idx
4602017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
461DROP INDEX IF EXISTS public_key_height_idx
4622017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
463CREATE 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)
4642017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
465CREATE UNIQUE INDEX IF NOT EXISTS tagged_data_id_height_idx ON tagged_data (id, height DESC)
4662017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
467CREATE INDEX IF NOT EXISTS tagged_data_expiration_idx ON tagged_data (transaction_timestamp DESC)
4682017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
469CREATE INDEX IF NOT EXISTS tagged_data_account_id_height_idx ON tagged_data (account_id, height DESC)
4702017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
471CREATE INDEX IF NOT EXISTS tagged_data_block_timestamp_height_db_id_idx ON tagged_data (block_timestamp DESC, height DESC, db_id DESC)
4722017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
473CREATE INDEX IF NOT EXISTS prunable_source_code_expiration_idx ON prunable_source_code (expiration DESC)
4742017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
475CREATE 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)
4762017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
477CREATE UNIQUE INDEX IF NOT EXISTS data_tag_tag_height_idx ON data_tag (tag, height DESC)
4782017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
479CREATE INDEX IF NOT EXISTS data_tag_count_height_idx ON data_tag (tag_count DESC, height DESC)
4802017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
481CREATE 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)
4822017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
483CREATE UNIQUE INDEX IF NOT EXISTS tagged_data_timestamp_id_height_idx ON tagged_data_timestamp (id, height DESC)
4842017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
485ALTER TABLE prunable_source_code ALTER COLUMN expiration RENAME TO transaction_timestamp
4862017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
487UPDATE prunable_source_code SET transaction_timestamp = SELECT timestamp FROM transaction WHERE prunable_source_code.id = transaction.id
4882017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
489ALTER INDEX prunable_source_code_expiration_idx RENAME TO prunable_source_code_transaction_timestamp_idx
4902017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
491ALTER TABLE prunable_source_code ALTER COLUMN timestamp RENAME TO block_timestamp
4922017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
493ALTER TABLE tagged_data ADD COLUMN IF NOT EXISTS channel VARCHAR
4942017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
495CREATE INDEX IF NOT EXISTS tagged_data_channel_idx ON tagged_data (channel, height DESC)
4962017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
497ALTER TABLE peer ADD COLUMN IF NOT EXISTS last_updated INT
4982017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
499DROP INDEX IF EXISTS account_current_lessee_id_leasing_height_idx
5002017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
501TRUNCATE TABLE account
5022017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
503ALTER TABLE account ADD COLUMN IF NOT EXISTS active_lessee_id BIGINT
5042017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
505ALTER TABLE account DROP COLUMN IF EXISTS current_leasing_height_from
5062017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
507ALTER TABLE account DROP COLUMN IF EXISTS current_leasing_height_to
5082017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
509ALTER TABLE account DROP COLUMN IF EXISTS current_lessee_id
5102017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
511ALTER TABLE account DROP COLUMN IF EXISTS next_leasing_height_from
5122017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
513ALTER TABLE account DROP COLUMN IF EXISTS next_leasing_height_to
5142017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
515ALTER TABLE account DROP COLUMN IF EXISTS next_lessee_id
5162017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
517CREATE INDEX IF NOT EXISTS account_active_lessee_id_idx ON account (active_lessee_id)
5182017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
519CREATE 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)
5202017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
521CREATE UNIQUE INDEX IF NOT EXISTS account_lease_lessor_id_height_idx ON account_lease (lessor_id, height DESC)
5222017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
523CREATE INDEX IF NOT EXISTS account_lease_current_leasing_height_from_idx ON account_lease (current_leasing_height_from)
5242017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
525CREATE INDEX IF NOT EXISTS account_lease_current_leasing_height_to_idx ON account_lease (current_leasing_height_to)
5262017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
527CREATE INDEX IF NOT EXISTS account_lease_height_id_idx ON account_lease (height, lessor_id)
5282017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
529CREATE INDEX IF NOT EXISTS account_asset_asset_id_idx ON account_asset (asset_id)
5302017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
531CREATE INDEX IF NOT EXISTS account_currency_currency_id_idx ON account_currency (currency_id)
5322017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
533CREATE INDEX IF NOT EXISTS currency_issuance_height_idx ON currency (issuance_height)
5342017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
535CREATE INDEX IF NOT EXISTS unconfirmed_transaction_expiration_idx ON unconfirmed_transaction (expiration DESC)
5362017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
537DROP INDEX IF EXISTS account_height_idx
5382017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
539CREATE INDEX IF NOT EXISTS account_height_id_idx ON account (height, id)
5402017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
541DROP INDEX IF EXISTS account_asset_height_idx
5422017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
543CREATE INDEX IF NOT EXISTS account_asset_height_id_idx ON account_asset (height, account_id, asset_id)
5442017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
545DROP INDEX IF EXISTS account_currency_height_idx
5462017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
547CREATE INDEX IF NOT EXISTS account_currency_height_id_idx ON account_currency (height, account_id, currency_id)
5482017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
549DROP INDEX IF EXISTS alias_height_idx
5502017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
551CREATE INDEX IF NOT EXISTS alias_height_id_idx ON alias (height, id)
5522017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
553DROP INDEX IF EXISTS alias_offer_height_idx
5542017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
555CREATE INDEX IF NOT EXISTS alias_offer_height_id_idx ON alias_offer (height, id)
5562017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
557DROP INDEX IF EXISTS ask_order_height_idx
5582017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
559CREATE INDEX IF NOT EXISTS ask_order_height_id_idx ON ask_order (height, id)
5602017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
561DROP INDEX IF EXISTS bid_order_height_idx
5622017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
563CREATE INDEX IF NOT EXISTS bid_order_height_id_idx ON bid_order (height, id)
5642017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
565DROP INDEX IF EXISTS buy_offer_height_idx
5662017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
567CREATE INDEX IF NOT EXISTS buy_offer_height_id_idx ON buy_offer (height, id)
5682017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
569DROP INDEX IF EXISTS currency_height_idx
5702017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
571CREATE INDEX IF NOT EXISTS currency_height_id_idx ON currency (height, id)
5722017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
573DROP INDEX IF EXISTS currency_founder_height_idx
5742017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
575CREATE INDEX IF NOT EXISTS currency_founder_height_id_idx ON currency_founder (height, currency_id, account_id)
5762017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
577DROP INDEX IF EXISTS currency_mint_height_idx
5782017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
579CREATE INDEX IF NOT EXISTS currency_mint_height_id_idx ON currency_mint (height, currency_id, account_id)
5802017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
581DROP INDEX IF EXISTS currency_supply_height_idx
5822017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
583CREATE INDEX IF NOT EXISTS currency_supply_height_id_idx ON currency_supply (height, id)
5842017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
585DROP INDEX IF EXISTS goods_height_idx
5862017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
587CREATE INDEX IF NOT EXISTS goods_height_id_idx ON goods (height, id)
5882017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
589DROP INDEX IF EXISTS purchase_height_idx
5902017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
591CREATE INDEX IF NOT EXISTS purchase_height_id_idx ON purchase (height, id)
5922017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
593DROP INDEX IF EXISTS purchase_feedback_height_idx
5942017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
595CREATE INDEX IF NOT EXISTS purchase_feedback_height_id_idx ON purchase_feedback (height, id)
5962017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
597DROP INDEX IF EXISTS purchase_public_feedback_height_idx
5982017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
599CREATE INDEX IF NOT EXISTS purchase_public_feedback_height_id_idx ON purchase_public_feedback (height, id)
6002017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
601DROP INDEX IF EXISTS sell_offer_height_idx
6022017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
603CREATE INDEX IF NOT EXISTS sell_offer_height_id_idx ON sell_offer (height, id)
6042017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
605DROP INDEX IF EXISTS tag_height_idx
6062017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
607CREATE INDEX IF NOT EXISTS tag_height_tag_idx ON tag (height, tag)
6082017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
609DROP INDEX IF EXISTS account_info_height_idx
6102017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
611CREATE INDEX IF NOT EXISTS account_info_height_id_idx ON account_info (height, account_id)
6122017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
613DROP INDEX IF EXISTS tagged_data_timestamp_height_idx
6142017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
615CREATE INDEX IF NOT EXISTS tagged_data_timestamp_height_id_idx ON tagged_data_timestamp (height, id)
6162017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
617CREATE INDEX IF NOT EXISTS trade_height_db_id_idx ON trade (height DESC, db_id DESC)
6182017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
619DROP INDEX IF EXISTS prunable_source_code_idx
6202017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
621CREATE INDEX IF NOT EXISTS exchange_height_db_id_idx ON exchange (height DESC, db_id DESC)
6222017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
623CREATE INDEX IF NOT EXISTS prunable_source_code_block_timestamp_dbid_idx ON prunable_source_code (block_timestamp DESC, db_id DESC)
6242017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
625CREATE 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)
6262017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
627CREATE UNIQUE INDEX IF NOT EXISTS exchange_request_id_idx ON exchange_request (id)
6282017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
629CREATE INDEX IF NOT EXISTS exchange_request_account_currency_idx ON exchange_request (account_id, currency_id, height DESC)
6302017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
631CREATE INDEX IF NOT EXISTS exchange_request_currency_idx ON exchange_request (currency_id, height DESC)
6322017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
633CREATE INDEX IF NOT EXISTS exchange_request_height_db_id_idx ON exchange_request (height DESC, db_id DESC)
6342017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
635CREATE INDEX IF NOT EXISTS exchange_request_height_idx ON exchange_request (height)
6362017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
637CREATE 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)
6382017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
639CREATE 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)
6402017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
641CREATE INDEX IF NOT EXISTS account_ledger_id_idx ON account_ledger(account_id, db_id)
6422017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
643CREATE INDEX IF NOT EXISTS account_ledger_height_idx ON account_ledger(height)
6442017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
645ALTER TABLE peer ADD COLUMN IF NOT EXISTS services BIGINT
6462017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
647TRUNCATE TABLE asset
6482017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
649ALTER TABLE asset ADD COLUMN IF NOT EXISTS latest BOOLEAN NOT NULL DEFAULT TRUE
6502017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
651DROP INDEX IF EXISTS asset_id_idx
6522017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
653ALTER TABLE asset ADD COLUMN IF NOT EXISTS initial_quantity BIGINT NOT NULL
6542017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
655CREATE 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)
6562017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
657CREATE INDEX IF NOT EXISTS tagged_data_extend_id_height_idx ON tagged_data_extend(id, height DESC)
6582017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
659CREATE INDEX IF NOT EXISTS tagged_data_extend_height_id_idx ON tagged_data_extend(height, id)
6602017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
661ALTER TABLE transaction ADD COLUMN IF NOT EXISTS has_prunable_attachment BOOLEAN NOT NULL DEFAULT FALSE
6622017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
663UPDATE transaction SET has_prunable_attachment = TRUE WHERE type = 6
6642017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
665TRUNCATE TABLE account
6662017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
667ALTER TABLE account DROP COLUMN IF EXISTS creation_height
6682017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
669ALTER TABLE account DROP COLUMN IF EXISTS key_height
6702017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
671DROP INDEX IF EXISTS public_key_account_id_idx
6722017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
673ALTER TABLE public_key ADD COLUMN IF NOT EXISTS latest BOOLEAN NOT NULL DEFAULT TRUE
6742017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
675CREATE UNIQUE INDEX IF NOT EXISTS public_key_account_id_height_idx ON public_key (account_id, height DESC)
6762017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
677DROP INDEX IF EXISTS prunable_source_code_height_idx
6782017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
679DROP INDEX IF EXISTS asset_height_idx
6802017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
681DROP INDEX IF EXISTS asset_height_db_id_idx
6822017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
683DROP INDEX IF EXISTS asset_id_height_idx
6842017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
685CREATE UNIQUE INDEX IF NOT EXISTS asset_id_height_idx ON asset (id, height DESC)
6862017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
687CREATE INDEX IF NOT EXISTS asset_height_id_idx ON asset (height, id)
6882017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
689TRUNCATE TABLE account_ledger
6902017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
691CREATE 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)
6922017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
693CREATE UNIQUE INDEX IF NOT EXISTS shuffling_id_height_idx ON shuffling (id, height DESC)
6942017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
695CREATE INDEX IF NOT EXISTS shuffling_holding_id_height_idx ON shuffling (holding_id, height DESC)
6962017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
697CREATE INDEX IF NOT EXISTS shuffling_assignee_account_id_height_idx ON shuffling (assignee_account_id, height DESC)
6982017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
699CREATE INDEX IF NOT EXISTS shuffling_height_id_idx ON shuffling (height, id)
7002017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
701CREATE 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)
7022017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
703CREATE UNIQUE INDEX IF NOT EXISTS shuffling_participant_shuffling_id_account_id_idx ON shuffling_participant (shuffling_id, account_id, height DESC)
7042017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
705CREATE INDEX IF NOT EXISTS shuffling_participant_height_idx ON shuffling_participant (height, shuffling_id, account_id)
7062017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
707CREATE 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)
7082017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
709CREATE UNIQUE INDEX IF NOT EXISTS shuffling_data_id_height_idx ON shuffling_data (shuffling_id, height DESC)
7102017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
711CREATE INDEX shuffling_data_transaction_timestamp_idx ON shuffling_data (transaction_timestamp DESC)
7122017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
713CREATE 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)
7142017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
715CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_height_idx ON phasing_poll_linked_transaction (height)
7162017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
717ALTER TABLE phasing_poll DROP COLUMN IF EXISTS linked_full_hashes
7182017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
719CREATE 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)
7202017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
721ALTER TABLE account ADD COLUMN IF NOT EXISTS has_control_phasing BOOLEAN NOT NULL DEFAULT FALSE
7222017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
723CREATE UNIQUE INDEX IF NOT EXISTS account_control_phasing_id_height_idx ON account_control_phasing (account_id, height DESC)
7242017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
725CREATE INDEX IF NOT EXISTS account_control_phasing_height_id_idx ON account_control_phasing (height, account_id)
7262017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
727CREATE 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)
7282017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
729CREATE UNIQUE INDEX IF NOT EXISTS account_property_id_height_idx ON account_property (id, height DESC)
7302017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
731CREATE INDEX IF NOT EXISTS account_property_height_id_idx ON account_property (height, id)
7322017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
733CREATE INDEX IF NOT EXISTS account_property_account_height_idx ON account_property (account_id, height DESC)
7342017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
735CREATE INDEX IF NOT EXISTS account_property_setter_account_idx ON account_property (setter_id, account_id)
7362017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
737CREATE 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)
7382017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
739CREATE UNIQUE INDEX IF NOT EXISTS asset_delete_id_idx ON asset_delete (id)
7402017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
741CREATE INDEX IF NOT EXISTS asset_delete_asset_id_idx ON asset_delete (asset_id, height DESC)
7422017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
743CREATE INDEX IF NOT EXISTS asset_delete_account_id_idx ON asset_delete (account_id, height DESC)
7442017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
745CREATE INDEX IF NOT EXISTS asset_delete_height_idx ON asset_delete (height)
7462017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
747ALTER TABLE prunable_message ADD COLUMN IF NOT EXISTS encrypted_message VARBINARY
7482017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
749ALTER TABLE prunable_message ADD COLUMN IF NOT EXISTS encrypted_is_text BOOLEAN DEFAULT FALSE
7502017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
751UPDATE prunable_message SET encrypted_message = message WHERE is_encrypted IS TRUE
7522017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
753ALTER TABLE prunable_message ALTER COLUMN message SET NULL
7542017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
755UPDATE prunable_message SET message = NULL WHERE is_encrypted IS TRUE
7562017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
757UPDATE prunable_message SET encrypted_is_text = TRUE WHERE is_encrypted IS TRUE AND is_text IS TRUE
7582017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
759UPDATE prunable_message SET encrypted_is_text = FALSE WHERE is_encrypted IS TRUE AND is_text IS FALSE
7602017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
761UPDATE prunable_message SET is_text = FALSE where is_encrypted IS TRUE
7622017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
763ALTER TABLE prunable_message ALTER COLUMN is_text RENAME TO message_is_text
7642017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
765ALTER TABLE prunable_message DROP COLUMN IF EXISTS is_encrypted
7662017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
767TRUNCATE TABLE shuffling
7682017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
769ALTER TABLE shuffling ADD COLUMN IF NOT EXISTS registrant_count TINYINT NOT NULL
7702017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
771ALTER TABLE account_property ALTER COLUMN account_id RENAME TO recipient_id
7722017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
773ALTER INDEX account_property_account_height_idx RENAME TO account_property_recipient_height_idx
7742017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
775ALTER INDEX account_property_setter_account_idx RENAME TO account_property_setter_recipient_idx
7762017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
777CREATE 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)
7782017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
779CREATE INDEX IF NOT EXISTS referenced_transaction_referenced_transaction_id_idx ON referenced_transaction (referenced_transaction_id)
7802017-04-09 04:43:40 FINE: BlockchainProcessorImpl.scheduleScan: Scheduled scan starting from height 0
7812017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
782DROP INDEX IF EXISTS phasing_poll_linked_transaction_id_link_idx
7832017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
784CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_id_link_idx ON phasing_poll_linked_transaction (transaction_id, linked_transaction_id)
7852017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
786DROP INDEX IF EXISTS phasing_poll_linked_transaction_link_id_idx
7872017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
788CREATE INDEX IF NOT EXISTS phasing_poll_linked_transaction_link_id_idx ON phasing_poll_linked_transaction (linked_transaction_id, transaction_id)
7892017-04-09 04:43:40 FINE: BasicDb.getPooledConnection: Database connection pool current size: 3
7902017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
791ALTER TABLE goods ADD COLUMN IF NOT EXISTS has_image BOOLEAN NOT NULL DEFAULT FALSE
7922017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
793ALTER TABLE purchase ADD COLUMN IF NOT EXISTS goods_is_text BOOLEAN NOT NULL DEFAULT TRUE
7942017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
795CREATE INDEX IF NOT EXISTS shuffling_blocks_remaining_height_idx ON shuffling (blocks_remaining, height DESC)
7962017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
797CREATE TABLE IF NOT EXISTS account_fxt (id BIGINT NOT NULL, balance VARBINARY NOT NULL, height INT NOT NULL)
7982017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
799CREATE UNIQUE INDEX IF NOT EXISTS account_fxt_id_idx ON account_fxt (id, height DESC)
8002017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
801CREATE 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)
8022017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
803CREATE UNIQUE INDEX IF NOT EXISTS asset_dividend_id_idx ON asset_dividend (id)
8042017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
805CREATE INDEX IF NOT EXISTS asset_dividend_asset_id_idx ON asset_dividend (asset_id, height DESC)
8062017-04-09 04:43:40 FINE: DbVersion.apply: Will apply sql:
807CREATE INDEX IF NOT EXISTS asset_dividend_height_idx ON asset_dividend (height)
8082017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enableTransactionRebroadcasting = "true"
8092017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.testUnconfirmedTransactions not defined, assuming false
8102017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxUnconfirmedTransactions = "2000"
8112017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableProcessTransactionsThread not defined, assuming false
8122017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableRebroadcastTransactionsThread not defined, assuming false
8132017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableRemoveUnconfirmedTransactionsThread not defined, assuming false
8142017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableProcessWaitingTransactionsThread not defined, assuming false
8152017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enablePublicKeyCache = "true"
8162017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.ledgerTrimKeep = "30000"
8172017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.ledgerAccounts = "*"
8182017-04-09 04:43:40 INFO: AccountLedger.<clinit>: Account ledger is tracking all accounts
8192017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.ledgerLogUnconfirmed = "2"
8202017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.hideErrorDetails = "false"
8212017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.myPlatform not defined
8222017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.myAddress not defined
8232017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.peerServerPort = "7874"
8242017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.shareMyAddress = "true"
8252017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enablePeerUPnP = "true"
8262017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.myHallmark not defined
8272017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.adminPassword not defined
8282017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxAPIRecords = "100"
8292017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enableAPIUPnP = "false"
8302017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.apiServerIdleTimeout = "30000"
8312017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.apiServerCORS = "true"
8322017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.disabledAPIs not defined
8332017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.disabledAPITags not defined
8342017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.allowedBotHosts = "*"
8352017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.enableAPIServer = "true"
8362017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.apiServerHost = "0.0.0.0"
8372017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.disableAdminPassword = "false"
8382017-04-09 04:43:40 INFO: Nxt.getBooleanProperty: nxt.apiSSL = "false"
8392017-04-09 04:43:40 INFO: API.<clinit>: API server using HTTP port 6876
8402017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.apiResourceBase = "./html/ui"
8412017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.apiWelcomeFile = "index.html"
8422017-04-09 04:43:40 INFO: Nxt.getStringProperty: nxt.javadocResourceBase = "./html/doc"
8432017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxUploadFileSize not defined or not numeric, using default value 0
8442017-04-09 04:43:40 INFO: Nxt.getIntProperty: nxt.maxUploadFileSize not defined or not numeric, using default value 0
8452017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableAPIServerGZIPFilter = "false"
8462017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.apiFrameOptionsSameOrigin = "true"
8472017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfForgers = "100"
8482017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableFakeForging not defined, assuming false
8492017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableFakeForging not defined, assuming false
8502017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disableGenerateBlocksThread not defined, assuming false
8512017-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}
8532017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.defaultTestnetPeers not defined
8542017-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"
8552017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.knownBlacklistedPeers not defined
8562017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfInboundConnections = "250"
8572017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfOutboundConnections = "50"
8582017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfConnectedPublicPeers = "20"
8592017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.maxNumberOfKnownPeers = "2000"
8602017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.minNumberOfKnownPeers = "1000"
8612017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.connectTimeout = "10000"
8622017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.readTimeout = "20000"
8632017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableHallmarkProtection = "false"
8642017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.pushThreshold = "0"
8652017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.pullThreshold = "0"
8662017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.useWebSockets = "true"
8672017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.webSocketIdleTimeout = "900000"
8682017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enablePeerServerGZIPFilter = "true"
8692017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.blacklistingPeriod = "1"
8702017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.communicationLoggingMask = "0"
8712017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.sendToPeersLimit = "10"
8722017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.usePeersDb = "true"
8732017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.savePeers = "true"
8742017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.getMorePeers = "true"
8752017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.cjdnsOnly = "false"
8762017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.ignorePeerAnnouncedAddress = "false"
8772017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disablePeerConnectingThread not defined, assuming false
8782017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disablePeerUnBlacklistingThread not defined, assuming false
8792017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.disableGetMorePeersThread not defined, assuming false
8802017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerHost = "0.0.0.0"
8812017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.peerServerIdleTimeout = "30000"
8822017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enablePeerServerDoSFilter = "true"
8832017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerDoSFilter.maxRequestsPerSec = "30"
8842017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerDoSFilter.delayMs = "1000"
8852017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.peerServerDoSFilter.maxRequestMs = "300000"
8862017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableAPIProxy = "true"
8872017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.apiProxyBlacklistingPeriod = "1800000"
8882017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.forceAPIProxyServerURL not defined
8892017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.addOns not defined
8902017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.allowedUserHosts = "127.0.0.1; localhost; [0:0:0:0:0:0:0:1];"
8912017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.enableUIServer = "false"
8922017-04-09 04:43:41 INFO: Users.<clinit>: User interface server not enabled
8932017-04-09 04:43:41 INFO: Nxt$Init.<clinit>: Genesis ID: 18036849569196248673
8942017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.superNodePassphrase not defined
8952017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.autoRenewSupernode not defined, assuming false
8962017-04-09 04:43:41 INFO: Nxt.getStringProperty: nxt.superNodeExternalIP not defined
8972017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.connectToSupernodes = "true"
8982017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.timeMultiplier not defined or not numeric, using default value 0
8992017-04-09 04:43:41 FINE: ThreadPool.start: Running 2 tasks...
9002017-04-09 04:43:41 INFO: BlockchainProcessorImpl.addGenesisBlock: Genesis block (-409894504513302943) not in database, starting from scratch
9012017-04-09 04:43:41 FINE: Peers$1.run: Loading known peers from the database...
9022017-04-09 04:43:41 FINE: BlockchainProcessorImpl.addBlock: [!!] Redeem Statistics: 0.0 % of all XEL have been redeemed.
9032017-04-09 04:43:41 INFO: BlockchainProcessorImpl.addGenesisBlock: Genesis block (-409894504513302943) recreated and added to our fresh blockchain
9042017-04-09 04:43:41 FINE: BlockchainProcessorImpl.scheduleScan: Scheduled scan starting from height 0
9052017-04-09 04:43:41 INFO: BlockchainProcessorImpl.scan: Scanning blockchain starting from height 0...
9062017-04-09 04:43:41 FINE: BlockchainProcessorImpl.scan: Rolled back derived tables
9072017-04-09 04:43:41 INFO: BlockchainProcessorImpl.lambda$new$1: processed block 0
9082017-04-09 04:43:41 INFO: BlockchainProcessorImpl.scan: ...done at height 0
9092017-04-09 04:43:41 FINE: ThreadPool.start: Running 2 final tasks...
9102017-04-09 04:43:41 INFO: UPnP.init: Looking for UPnP gateway device...
9112017-04-09 04:43:41 INFO: Nxt.getBooleanProperty: nxt.apiServerEnforcePOST = "true"
9122017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.upnpGatewayTimeout not defined or not numeric, using default value 7000
9132017-04-09 04:43:41 INFO: Nxt.getIntProperty: nxt.upnpDiscoverTimeout not defined or not numeric, using default value 3000
9142017-04-09 04:43:41 WARNING: THIS IS NOT A STABLE RELEASE! DO NOT USE IN PRODUCTION!
9152017-04-09 04:43:41 WARNING: Download a stable release from http://download.eclipse.org/jetty/
9162017-04-09 04:43:41 INFO: API.lambda$static$1: Started API server at 0.0.0.0:6876
9172017-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}
9182017-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>}
9192017-04-09 04:43:45 FINE: UPnP.lambda$init$0: UPnP gateway device found on 192.168.2.53
9202017-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}
9212017-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>}
9222017-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}
9232017-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>}
9242017-04-09 04:43:45 FINE: UPnP.init: Using UPnP gateway device on 192.168.2.53
9252017-04-09 04:43:45 INFO: UPnP.init: External IP address is <censored>
9262017-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}
9272017-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>}
9282017-04-09 04:43:45 FINE: UPnP.addPort: Mapped port [<censored>]:6874
9292017-04-09 04:43:45 WARNING: THIS IS NOT A STABLE RELEASE! DO NOT USE IN PRODUCTION!
9302017-04-09 04:43:45 WARNING: Download a stable release from http://download.eclipse.org/jetty/
9312017-04-09 04:43:45 INFO: Peers$Init.lambda$static$0: Started peer networking server at 0.0.0.0:6874
9322017-04-09 04:43:45 FINE: ThreadPool.start: Starting 9 background jobs
9332017-04-09 04:43:45 FINE: ThreadPool.start: Starting 2 delayed tasks
9342017-04-09 04:43:45 FINE: Peers.lambda$static$2: Known peers: 2
9352017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Initialization took 6 seconds
9362017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Nxt server 1.0.4 started successfully.
9372017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Copyright © 2013-2016 The XEL Core Developers.
9382017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Distributed under GPLv2, with ABSOLUTELY NO WARRANTY.
9392017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: Client UI is at http://localhost:6876/index.html
9402017-04-09 04:43:45 INFO: Nxt$Init.<clinit>: RUNNING ON TESTNET - DO NOT USE REAL ACCOUNTS!