Closed roadscape closed 7 years ago
Query stats from process_blocks 15841154 - 15842154:
2823.38ms, 8126 calls -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (:fr, :fg, :at, :state) ON DUPLICATE KEY UPDATE state = :state
1564.63ms, 2665 calls -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
1544.92ms, 3727 calls -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
1339.35ms, 3329 calls -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (:a, :b, :c, :d, :e, :f, :g, :h)
932.88ms, 3329 calls -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
876.40ms, 3401 calls -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
516.20ms, 1938 calls -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
291.68ms, 1000 calls -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (:a, :b, :c, :d, :e)
213.74ms, 390 calls -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
121.59ms, 373 calls -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (:a, :pid, :date)
17.73ms, 72 calls -- INSERT INTO hive_accounts (name, created_at) VALUES (:a, :b)
10.97ms, 17 calls -- DELETE FROM hive_posts_cache WHERE post_id = :id
5.02ms, 17 calls -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
0.47ms, 1 calls -- SHOW TABLES
0.42ms, 1 calls -- START TRANSACTION
0.40ms, 2 calls -- SELECT MAX(num) FROM hive_blocks
0.24ms, 1 calls -- SELECT (SELECT IFNULL(MAX(id), 0) FROM hive_posts) - (SELECT IFNULL(MAX(post_id), 0) FROM hive_posts_cache)
0.23ms, 1 calls -- SELECT 1 FROM hive_posts_cache LIMIT 1
Previous results were w/ hive_feed_cache disabled. With it enabled as a MEMORY table:
20121.51ms, 17 calls -- DELETE FROM hive_feed_cache WHERE post_id = :id
2808.13ms, 8126 calls -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (:fr, :fg, :at, :state) ON DUPLICATE KEY UPDATE state = :state
1719.02ms, 2665 calls -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
1376.73ms, 3329 calls -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (:a, :b, :c, :d, :e, :f, :g, :h)
1325.78ms, 3727 calls -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
950.81ms, 3329 calls -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
900.51ms, 3401 calls -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
522.76ms, 1938 calls -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
300.33ms, 1000 calls -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (:a, :b, :c, :d, :e)
213.15ms, 664 calls -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (:account, :id, :created_at)
209.65ms, 390 calls -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
116.48ms, 373 calls -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (:account, :id, :created_at)
114.05ms, 373 calls -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (:a, :pid, :date)
16.87ms, 72 calls -- INSERT INTO hive_accounts (name, created_at) VALUES (:a, :b)
6.41ms, 1 calls -- SHOW TABLES
5.66ms, 17 calls -- DELETE FROM hive_posts_cache WHERE post_id = :id
4.75ms, 17 calls -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
0.75ms, 2 calls -- SELECT MAX(num) FROM hive_blocks
0.60ms, 1 calls -- SELECT 1 FROM hive_posts_cache LIMIT 1
0.48ms, 1 calls -- SELECT (SELECT IFNULL(MAX(id), 0) FROM hive_posts) - (SELECT IFNULL(MAX(post_id), 0) FROM hive_posts_cache)
0.32ms, 1 calls -- START TRANSACTION
And it can be rebuilt in ~90s.
Using innodb, hive_feed_cache takes ~203s to rebuild but much cheaper to edit
3483.04ms, 8126 calls -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (:fr, :fg, :at, :state) ON DUPLICATE KEY UPDATE state = :state
2236.29ms, 2665 calls -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
1787.36ms, 3727 calls -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
1612.38ms, 3329 calls -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (:a, :b, :c, :d, :e, :f, :g, :h)
1088.30ms, 3401 calls -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
1060.77ms, 3329 calls -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
604.36ms, 1938 calls -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
338.56ms, 1000 calls -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (:a, :b, :c, :d, :e)
273.19ms, 390 calls -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
203.58ms, 664 calls -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (:account, :id, :created_at)
124.88ms, 373 calls -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (:a, :pid, :date)
100.08ms, 373 calls -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (:account, :id, :created_at)
23.33ms, 72 calls -- INSERT INTO hive_accounts (name, created_at) VALUES (:a, :b)
12.32ms, 17 calls -- DELETE FROM hive_posts_cache WHERE post_id = :id
10.97ms, 1 calls -- SELECT 1 FROM hive_posts_cache LIMIT 1
6.54ms, 17 calls -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
6.30ms, 1 calls -- SELECT (SELECT IFNULL(MAX(id), 0) FROM hive_posts) - (SELECT IFNULL(MAX(post_id), 0) FROM hive_posts_cache)
4.32ms, 17 calls -- DELETE FROM hive_feed_cache WHERE post_id = :id
1.02ms, 2 calls -- SELECT MAX(num) FROM hive_blocks
0.49ms, 1 calls -- SHOW TABLES
0.28ms, 1 calls -- START TRANSACTION
Here's a python profile over the same 1000-block period:
7477768 function calls (7269708 primitive calls) in 22.371 seconds
Ordered by: cumulative time
ncalls tottime percall cumtime percall filename:lineno(function)
2 0.000 0.000 22.433 11.216 core.py:1(<module>)
354/1 0.015 0.000 22.433 22.433 {built-in method builtins.exec}
1 0.000 0.000 21.965 21.965 core.py:435(run)
1 0.001 0.001 21.943 21.943 core.py:323(sync_from_steemd)
1 0.006 0.006 13.642 13.642 core.py:283(process_blocks)
1000 0.078 0.000 13.635 0.014 core.py:211(process_block)
29444 0.172 0.000 12.946 0.000 methods.py:25(query)
29447 0.037 0.000 11.555 0.000 base.py:879(execute)
29444 0.031 0.000 11.507 0.000 elements.py:261(_execute_on_connection)
29444 0.142 0.000 11.476 0.000 base.py:1009(_execute_clauseelement)
29447 0.202 0.000 9.752 0.000 base.py:1104(_execute_context)
1000 0.059 0.000 9.004 0.009 core.py:89(register_posts)
1 0.001 0.001 8.287 8.287 utils.py:64(get_blocks_range)
1 0.000 0.000 8.285 8.285 utils.py:85(__exec_batch)
1001 0.003 0.000 8.285 0.008 http_client.py:242(exec_multi_with_futures)
1001 0.007 0.000 8.276 0.008 _base.py:173(as_completed)
997 0.004 0.000 8.235 0.008 threading.py:533(wait)
997 0.007 0.000 8.229 0.008 threading.py:263(wait)
5040 8.220 0.002 8.220 0.002 {method 'acquire' of '_thread.lock' objects}
29450 0.032 0.000 7.605 0.000 default.py:469(do_execute)
29455 0.227 0.000 7.574 0.000 cursors.py:204(execute)
15455 0.025 0.000 7.293 0.000 methods.py:50(query_row)
29455 0.027 0.000 6.484 0.000 cursors.py:410(_query)
29455 0.078 0.000 6.361 0.000 cursors.py:371(_do_query)
29455 5.960 0.000 5.965 0.000 connections.py:268(query)
8501 0.077 0.000 3.982 0.000 core.py:143(process_json_follow_op)
6734 0.019 0.000 2.294 0.000 methods.py:60(query_one)
88644 0.491 0.000 1.702 0.000 {method 'sub' of '_sre.SRE_Pattern' objects}
29447 0.049 0.000 1.502 0.000 elements.py:373(compile)
29447 0.047 0.000 1.453 0.000 elements.py:438(_compiler)
29447 0.173 0.000 1.406 0.000 compiler.py:376(__init__)
29447 0.080 0.000 1.193 0.000 compiler.py:177(__init__)
3401 0.008 0.000 1.153 0.000 core.py:26(get_account_id)
131701/29447 0.103 0.000 1.113 0.000 compiler.py:241(process)
131712/29447 0.143 0.000 1.084 0.000 visitors.py:75(_compiler_dispatch)
29444 0.352 0.000 1.043 0.000 default.py:554(_init_compiled)
29445 0.070 0.000 1.026 0.000 compiler.py:737(visit_textclause)
29444 0.026 0.000 0.900 0.000 <string>:1(text)
29444 0.050 0.000 0.874 0.000 elements.py:1240(_create_text)
29445 0.041 0.000 0.824 0.000 elements.py:1225(__init__)
29447 0.045 0.000 0.823 0.000 default.py:889(_setup_crud_result_proxy)
102248 0.119 0.000 0.679 0.000 compiler.py:738(do_bindparam)
3329 0.004 0.000 0.668 0.000 community.py:121(is_community_post_valid)
1938 0.007 0.000 0.664 0.000 community.py:168(get_community)
29447 0.042 0.000 0.608 0.000 default.py:873(get_result_proxy)
29447 0.051 0.000 0.566 0.000 result.py:646(__init__)
102248 0.168 0.000 0.551 0.000 connections.py:303(literal)
102248 0.181 0.000 0.532 0.000 elements.py:1232(repl)
29447 0.057 0.000 0.515 0.000 result.py:671(_init_metadata)
73039/73007 0.102 0.000 0.508 0.000 langhelpers.py:761(__get__)
95% of total time is spent in
ncalls tottime percall cumtime percall filename:lineno(function)
1 0.006 0.006 13.642 13.642 core.py:283(process_blocks)
29444 0.172 0.000 12.946 0.000 └ methods.py:25(query)
29447 0.037 0.000 11.555 0.000 └ base.py:879(execute)
1 0.001 0.001 8.287 8.287 utils.py:64(get_blocks_range)
1001 0.003 0.000 8.285 0.008 └ http_client.py:242(exec_multi_with_futures)
query
(89% of which is spent in execute
)http_client
(to local steemd-0.19.2)process_blocks
but outside of query
innodb_buffer_pool_size
should be set to ~75% of available RAM
innodb_log_buffer_size
should be set to 500M-1GB
Also testing
innodb_doublewrite=OFF
innodb_flush_method=O_DIRECT
innodb_flush_log_at_trx_commit=0
sync_binlog=0
worth exploring as well, during import
FTR here's some profiles from various periods in sync:
Oct 3 18:08:41 | [SYNC] Got block 1969000 (1605.7/s, 9568rps 1929wps) -- 145.77m remaining
Oct 3 18:08:41 | [SYNC] Got block 1970000 (1448.4/s, 9585rps 1706wps) -- 161.58m remaining
Oct 3 18:08:42 | [SYNC] Got block 1971000 (1563.6/s, 10209rps 1846wps) -- 149.67m remaining
Oct 3 18:08:43 | [SYNC] Got block 1972000 (1771.2/s, 10288rps 2139wps) -- 132.12m remaining
Oct 3 18:08:43 | [SYNC] Got block 1973000 (1623.6/s, 10297rps 1927wps) -- 144.12m remaining
Oct 3 18:08:44 | [SYNC] Got block 1974000 (1614.9/s, 9811rps 1933wps) -- 144.88m remaining
Oct 3 18:08:44 | [SYNC] Got block 1975000 (1718.1/s, 10673rps 2047wps) -- 136.17m remaining
Oct 3 18:08:45 | [SYNC] Got block 1976000 (1619.3/s, 10488rps 1914wps) -- 144.47m remaining
Oct 3 18:08:46 | [DEBUG] total SQL time: 900000ms
Oct 3 18:08:46 | 90.2% 812015.02ms 0.41avg 1976865x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 18:08:46 | 4.7% 42166.79ms 0.38avg 111683x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 18:08:46 | 1.0% 8775.07ms 0.41avg 21287x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:08:46 | 0.9% 8427.05ms 0.55avg 15388x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 18:08:46 | 0.9% 8026.69ms 4.06avg 1976x -- COMMIT
Oct 3 18:08:46 | 0.7% 6144.57ms 0.40avg 15388x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:08:46 | 0.5% 4167.74ms 0.43avg 9716x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:08:46 | 0.5% 4063.02ms 0.38avg 10668x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 18:08:46 | 0.3% 2926.69ms 0.41avg 7212x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 18:08:46 | 0.3% 2396.87ms 0.42avg 5672x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 18:08:46 | 0.1% 888.60ms 0.45avg 1977x -- START TRANSACTION
Oct 3 18:08:46 | 0.0% 0.80ms 0.40avg 2x -- SELECT MAX(num) FROM hive_blocks
Oct 3 18:08:46 | 0.0% 0.72ms 0.72avg 1x -- SHOW TABLES
Oct 3 18:08:46 | 0.0% 0.50ms 0.50avg 1x -- SELECT 1 FROM hive_posts_cache LIMIT 1
Oct 3 18:08:46 | [SYNC] Got block 1977000 (1601.7/s, 10573rps 1887wps) -- 146.05m remaining
Oct 3 18:08:46 | [SYNC] Got block 1978000 (1616.9/s, 10170rps 1922wps) -- 144.67m remaining
Oct 3 18:08:47 | [SYNC] Got block 1979000 (1524.8/s, 9108rps 1831wps) -- 153.39m remaining
Oct 3 18:08:48 | [SYNC] Got block 1980000 (1610.1/s, 10319rps 1907wps) -- 145.26m remaining
Oct 3 18:08:48 | [SYNC] Got block 1981000 (1684.5/s, 10576rps 2003wps) -- 138.83m remaining
Oct 3 18:27:59 | [SYNC] Got block 3317000 (394.1/s, 3530rps 443wps) -- 536.95m remaining
Oct 3 18:28:01 | [SYNC] Got block 3318000 (417.3/s, 3632rps 471wps) -- 507.0m remaining
Oct 3 18:28:03 | [SYNC] Got block 3319000 (440.0/s, 3386rps 505wps) -- 480.84m remaining
Oct 3 18:28:06 | [SYNC] Got block 3320000 (422.7/s, 3266rps 485wps) -- 500.45m remaining
Oct 3 18:28:06 | [DEBUG] total SQL time: 900000ms
Oct 3 18:28:06 | 62.1% 559158.05ms 0.42avg 1343199x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 18:28:06 | 8.1% 73207.80ms 0.38avg 194848x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 18:28:06 | 7.2% 65111.09ms 0.41avg 158073x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:28:06 | 6.9% 62163.86ms 0.54avg 115653x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 18:28:06 | 5.2% 47092.19ms 0.41avg 115652x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:28:06 | 4.0% 35640.51ms 0.43avg 82293x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:28:06 | 2.7% 24600.34ms 0.41avg 60489x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 18:28:06 | 1.5% 13204.23ms 0.40avg 33391x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 18:28:06 | 0.7% 6278.91ms 0.37avg 16971x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 18:28:06 | 0.6% 5690.31ms 4.23avg 1344x -- COMMIT
Oct 3 18:28:06 | 0.6% 5272.30ms 0.47avg 11323x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 18:28:06 | 0.1% 675.93ms 0.50avg 1344x -- START TRANSACTION
Oct 3 18:28:06 | 0.1% 532.53ms 0.43avg 1249x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:28:06 | 0.1% 500.08ms 0.40avg 1249x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 18:28:06 | 0.0% 423.66ms 0.34avg 1249x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 18:28:06 | 0.0% 419.86ms 0.34avg 1249x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 18:28:06 | 0.0% 16.08ms 0.50avg 32x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 18:28:06 | 0.0% 12.43ms 0.39avg 32x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 18:28:08 | [SYNC] Got block 3321000 (442.6/s, 3125rps 515wps) -- 477.88m remaining
Oct 3 18:28:10 | [SYNC] Got block 3322000 (443.6/s, 3406rps 509wps) -- 476.83m remaining
Oct 3 18:28:12 | [SYNC] Got block 3323000 (440.9/s, 3008rps 516wps) -- 479.67m remaining
Oct 3 18:28:14 | [SYNC] Got block 3324000 (518.3/s, 4171rps 591wps) -- 408.01m remaining
Oct 3 18:46:42 | [SYNC] Got block 3713000 (304.0/s, 2668rps 343wps) -- 674.39m remaining
Oct 3 18:46:45 | [SYNC] Got block 3714000 (322.9/s, 2983rps 362wps) -- 634.79m remaining
Oct 3 18:46:48 | [SYNC] Got block 3715000 (361.1/s, 3110rps 408wps) -- 567.66m remaining
Oct 3 18:46:50 | [SYNC] Got block 3716000 (375.2/s, 3212rps 424wps) -- 546.17m remaining
Oct 3 18:46:51 | [DEBUG] total SQL time: 900000ms
Oct 3 18:46:51 | 18.9% 169958.30ms 0.43avg 396136x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 18:46:51 | 16.9% 151860.56ms 0.41avg 368988x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:46:51 | 16.3% 146815.52ms 0.54avg 270653x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 18:46:51 | 12.7% 114378.60ms 0.37avg 305181x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 18:46:51 | 12.3% 110993.32ms 0.41avg 270654x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:46:51 | 10.5% 94296.23ms 0.44avg 216735x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:46:51 | 7.4% 67049.86ms 0.41avg 164542x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 18:46:51 | 2.4% 21430.42ms 0.40avg 53993x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 18:46:51 | 1.2% 10557.46ms 0.45avg 23348x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 18:46:51 | 0.7% 5989.08ms 0.37avg 16232x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 18:46:51 | 0.2% 1559.75ms 3.94avg 396x -- COMMIT
Oct 3 18:46:51 | 0.1% 1319.91ms 0.42avg 3155x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 18:46:51 | 0.1% 1290.92ms 0.41avg 3155x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 18:46:51 | 0.1% 1108.00ms 0.35avg 3155x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 18:46:51 | 0.1% 1061.79ms 0.34avg 3155x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 18:46:51 | 0.0% 263.35ms 0.67avg 396x -- START TRANSACTION
Oct 3 18:46:51 | 0.0% 37.74ms 0.51avg 74x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 18:46:51 | 0.0% 29.40ms 0.40avg 74x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 18:46:53 | [SYNC] Got block 3717000 (372.5/s, 3047rps 424wps) -- 550.13m remaining
Oct 3 18:46:55 | [SYNC] Got block 3718000 (429.5/s, 3263rps 494wps) -- 477.1m remaining
Oct 3 19:05:42 | [SYNC] Got block 4167000 (382.9/s, 2411rps 455wps) -- 515.55m remaining
Oct 3 19:05:44 | [SYNC] Got block 4168000 (377.5/s, 2665rps 439wps) -- 522.99m remaining
Oct 3 19:05:46 | [DEBUG] total SQL time: 900000ms
Oct 3 19:05:46 | 21.7% 195335.80ms 0.43avg 452226x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 19:05:46 | 14.8% 133632.26ms 0.55avg 243512x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 19:05:46 | 14.4% 129168.55ms 0.42avg 309111x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:05:46 | 12.2% 109771.50ms 0.38avg 289092x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 19:05:46 | 11.2% 101192.12ms 0.42avg 243512x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:05:46 | 9.7% 87732.22ms 0.44avg 199753x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:05:46 | 6.9% 61848.21ms 0.41avg 150343x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 19:05:46 | 5.5% 49720.41ms 0.46avg 109235x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 19:05:46 | 1.9% 17419.10ms 0.40avg 43806x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 19:05:46 | 1.0% 9111.49ms 0.37avg 24530x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 19:05:46 | 0.2% 1876.19ms 4.15avg 452x -- COMMIT
Oct 3 19:05:46 | 0.1% 797.72ms 0.42avg 1890x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:05:46 | 0.1% 782.20ms 0.41avg 1890x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 19:05:46 | 0.1% 640.89ms 0.34avg 1890x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 19:05:46 | 0.1% 639.18ms 0.34avg 1890x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 19:05:46 | 0.0% 290.05ms 0.64avg 452x -- START TRANSACTION
Oct 3 19:05:46 | 0.0% 24.01ms 0.52avg 46x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 19:05:46 | 0.0% 18.30ms 0.40avg 46x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 19:05:47 | [SYNC] Got block 4169000 (389.2/s, 2794rps 452wps) -- 507.22m remaining
Oct 3 19:05:50 | [SYNC] Got block 4170000 (324.7/s, 2598rps 371wps) -- 607.8m remaining
Oct 3 19:24:44 | [SYNC] Got block 4681000 (417.7/s, 2256rps 512wps) -- 452.17m remaining
Oct 3 19:24:46 | [SYNC] Got block 4682000 (465.8/s, 2850rps 556wps) -- 405.44m remaining
Oct 3 19:24:48 | [DEBUG] total SQL time: 900000ms
Oct 3 19:24:48 | 24.9% 224159.45ms 0.44avg 514541x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 19:24:48 | 12.9% 116103.27ms 0.55avg 210468x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 19:24:48 | 12.5% 112729.89ms 0.42avg 267991x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:24:48 | 12.1% 108705.90ms 0.46avg 237168x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 19:24:48 | 10.6% 95702.62ms 0.38avg 249489x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 19:24:48 | 9.8% 88049.29ms 0.42avg 210468x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:24:48 | 8.5% 76622.04ms 0.44avg 172474x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:24:48 | 5.7% 51226.31ms 0.41avg 123509x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 19:24:48 | 1.7% 15388.89ms 0.40avg 38024x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 19:24:48 | 0.6% 5386.73ms 0.36avg 14767x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 19:24:48 | 0.2% 2200.19ms 4.28avg 514x -- COMMIT
Oct 3 19:24:48 | 0.1% 949.28ms 0.42avg 2244x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:24:48 | 0.1% 902.39ms 0.40avg 2244x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 19:24:48 | 0.1% 771.32ms 0.34avg 2244x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 19:24:48 | 0.1% 750.84ms 0.33avg 2244x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 19:24:48 | 0.0% 315.77ms 0.61avg 514x -- START TRANSACTION
Oct 3 19:24:48 | 0.0% 23.79ms 0.77avg 31x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 19:24:48 | 0.0% 12.08ms 0.39avg 31x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 19:24:48 | [SYNC] Got block 4683000 (409.7/s, 2554rps 487wps) -- 460.91m remaining
Oct 3 19:24:50 | [SYNC] Got block 4684000 (499.3/s, 3966rps 571wps) -- 378.12m remaining
Oct 3 19:25:30 | [SYNC] Got block 4706000 (500.7/s, 4095rps 570wps) -- 376.32m remaining
Oct 3 19:25:32 | [SYNC] Got block 4707000 (480.1/s, 3162rps 565wps) -- 392.51m remaining
Oct 3 19:25:32 | blocks = steemd.get_blocks_range(lbound, to)
Oct 3 19:25:32 | File "/app/hive/indexer/utils.py", line 79, in get_blocks_range
Oct 3 19:25:32 | for block in self.__exec_batch('get_block', [[i] for i in missing]):
Oct 3 19:25:32 | File "/app/hive/indexer/utils.py", line 95, in __exec_batch
Oct 3 19:25:32 | return list(self._client.exec_batch(method, params, batch_size=500))
Oct 3 19:25:32 | File "/app/hive/indexer/http_client.py", line 268, in exec_batch
Oct 3 19:25:32 | assert batch_response, "batch_response was empty"
Oct 3 19:25:32 | AssertionError: batch_response was empty
Oct 3 19:25:32 | [DEBUG] total SQL time: 34150ms
Oct 3 19:25:32 | 31.5% 10754.37ms 0.45avg 24033x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 19:25:32 | 12.3% 4200.01ms 0.57avg 7415x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 19:25:32 | 11.7% 3987.15ms 0.43avg 9315x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:25:32 | 11.2% 3813.68ms 0.40avg 9569x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 19:25:32 | 8.8% 3009.24ms 0.41avg 7415x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:25:32 | 8.1% 2768.73ms 0.45avg 6195x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:25:32 | 8.1% 2764.70ms 0.46avg 5973x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 19:25:32 | 5.1% 1748.46ms 0.40avg 4323x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 19:25:32 | 1.4% 492.86ms 0.40avg 1221x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 19:25:32 | 1.1% 371.33ms 0.37avg 1014x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 19:25:32 | 0.3% 103.29ms 4.13avg 25x -- COMMIT
Oct 3 19:25:32 | 0.1% 35.63ms 0.43avg 82x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:25:32 | 0.1% 32.33ms 0.39avg 82x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 19:25:32 | 0.1% 27.17ms 0.33avg 82x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 19:25:32 | 0.1% 26.88ms 0.33avg 82x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 19:25:32 | 0.0% 13.90ms 0.58avg 24x -- START TRANSACTION
Oct 3 19:25:32 | 0.0% 0.46ms 0.46avg 1x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 19:25:32 | 0.0% 0.36ms 0.36avg 1x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 19:25:33 | Starting hivemind...
Oct 3 19:47:29 | [SYNC] Got block 5352000 (705.2/s, 3924rps 859wps) -- 252.0m remaining
Oct 3 19:47:31 | [SYNC] Got block 5353000 (619.9/s, 3509rps 752wps) -- 286.63m remaining
Oct 3 19:47:32 | [SYNC] Got block 5354000 (610.4/s, 4224rps 713wps) -- 291.08m remaining
Oct 3 19:47:33 | [DEBUG] total SQL time: 900000ms
Oct 3 19:47:33 | 30.6% 275470.92ms 0.43avg 647099x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 19:47:33 | 11.9% 107367.02ms 0.55avg 195998x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 19:47:33 | 11.3% 101776.85ms 0.41avg 247221x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:47:33 | 10.6% 94989.07ms 0.45avg 211560x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 19:47:33 | 10.0% 90139.53ms 0.37avg 241152x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 19:47:33 | 8.9% 80459.35ms 0.41avg 195998x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:47:33 | 7.7% 69656.07ms 0.44avg 159627x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:47:33 | 4.9% 44444.26ms 0.41avg 109307x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 19:47:33 | 1.6% 14430.58ms 0.40avg 36407x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 19:47:33 | 0.6% 5141.98ms 0.37avg 14056x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 19:47:33 | 0.5% 4284.13ms 0.43avg 9998x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 19:47:33 | 0.4% 3527.77ms 0.42avg 8316x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 19:47:33 | 0.4% 3325.09ms 0.40avg 8316x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 19:47:33 | 0.3% 2741.08ms 4.24avg 647x -- COMMIT
Oct 3 19:47:33 | 0.1% 671.22ms 0.40avg 1680x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 19:47:33 | 0.1% 595.48ms 0.35avg 1680x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 19:47:33 | 0.1% 556.65ms 0.33avg 1680x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 19:47:33 | 0.0% 389.45ms 0.60avg 648x -- START TRANSACTION
Oct 3 19:47:33 | 0.0% 18.07ms 0.52avg 35x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 19:47:33 | 0.0% 13.67ms 0.39avg 35x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 19:47:33 | 0.0% 0.81ms 0.81avg 1x -- SHOW TABLES
Oct 3 19:47:33 | 0.0% 0.76ms 0.38avg 2x -- SELECT MAX(num) FROM hive_blocks
Oct 3 19:47:33 | 0.0% 0.43ms 0.43avg 1x -- SELECT 1 FROM hive_posts_cache LIMIT 1
Oct 3 19:47:34 | [SYNC] Got block 5355000 (578.9/s, 3222rps 705wps) -- 306.88m remaining
Oct 3 19:47:36 | [SYNC] Got block 5356000 (689.2/s, 3067rps 889wps) -- 257.73m remaining
Oct 3 20:07:35 | [SYNC] Got block 6104000 (876.3/s, 5620rps 1038wps) -- 188.49m remaining
Oct 3 20:07:36 | [SYNC] Got block 6105000 (847.7/s, 4312rps 1055wps) -- 194.84m remaining
Oct 3 20:07:37 | [SYNC] Got block 6106000 (1020.1/s, 4320rps 1335wps) -- 161.89m remaining
Oct 3 20:07:38 | [SYNC] Got block 6107000 (874.7/s, 3625rps 1152wps) -- 188.78m remaining
Oct 3 20:07:39 | [DEBUG] total SQL time: 900000ms
Oct 3 20:07:39 | 35.9% 323531.56ms 0.43avg 753356x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 20:07:39 | 10.8% 97210.75ms 0.55avg 176022x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 20:07:39 | 10.5% 94331.88ms 0.42avg 225770x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:07:39 | 9.2% 83028.82ms 0.38avg 220503x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 20:07:39 | 9.0% 80912.00ms 0.46avg 177209x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 20:07:39 | 8.1% 72578.52ms 0.41avg 176022x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:07:39 | 6.9% 61758.50ms 0.44avg 140666x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:07:39 | 4.2% 38200.71ms 0.41avg 93414x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 20:07:39 | 1.6% 13950.30ms 0.39avg 35382x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 20:07:39 | 1.1% 9627.46ms 0.44avg 22107x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:07:39 | 0.9% 8180.47ms 0.40avg 20357x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 20:07:39 | 0.9% 8090.32ms 0.40avg 20357x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 20:07:39 | 0.3% 3123.98ms 0.37avg 8456x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 20:07:39 | 0.3% 3110.11ms 4.13avg 753x -- COMMIT
Oct 3 20:07:39 | 0.1% 704.39ms 0.40avg 1750x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 20:07:39 | 0.1% 581.02ms 0.33avg 1750x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 20:07:39 | 0.1% 579.53ms 0.33avg 1750x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 20:07:39 | 0.1% 475.81ms 0.63avg 753x -- START TRANSACTION
Oct 3 20:07:39 | 0.0% 13.72ms 0.51avg 27x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 20:07:39 | 0.0% 10.38ms 0.38avg 27x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 20:07:39 | [SYNC] Got block 6108000 (810.4/s, 4455rps 990wps) -- 203.73m remaining
Oct 3 20:07:40 | [SYNC] Got block 6109000 (803.9/s, 4209rps 993wps) -- 205.36m remaining
Oct 3 20:27:42 | [SYNC] Got block 6936000 (763.9/s, 4066rps 940wps) -- 198.07m remaining
Oct 3 20:27:44 | [SYNC] Got block 6937000 (507.9/s, 3207rps 603wps) -- 297.85m remaining
Oct 3 20:27:44 | [DEBUG] total SQL time: 900000ms
Oct 3 20:27:44 | 39.8% 358371.09ms 0.43avg 829813x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 20:27:44 | 10.6% 95521.11ms 0.56avg 171319x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 20:27:44 | 9.9% 89468.06ms 0.42avg 212284x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:27:44 | 9.2% 83046.22ms 0.38avg 216439x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 20:27:44 | 8.0% 71555.60ms 0.42avg 171319x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:27:44 | 6.9% 62044.94ms 0.44avg 140795x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:27:44 | 5.8% 52371.93ms 0.47avg 111674x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 20:27:44 | 4.4% 39870.21ms 0.41avg 96935x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 20:27:44 | 1.4% 12237.09ms 0.40avg 30537x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 20:27:44 | 1.1% 10075.00ms 0.44avg 23059x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:27:44 | 1.0% 8557.29ms 0.41avg 20879x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 20:27:44 | 0.9% 8341.06ms 0.40avg 20879x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 20:27:44 | 0.4% 3521.83ms 4.24avg 830x -- COMMIT
Oct 3 20:27:44 | 0.2% 2095.60ms 0.36avg 5768x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 20:27:44 | 0.1% 911.53ms 0.42avg 2180x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 20:27:44 | 0.1% 776.49ms 0.36avg 2180x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 20:27:44 | 0.1% 727.26ms 0.33avg 2180x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 20:27:44 | 0.1% 496.85ms 0.60avg 830x -- START TRANSACTION
Oct 3 20:27:44 | 0.0% 6.36ms 0.49avg 13x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 20:27:44 | 0.0% 4.87ms 0.37avg 13x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 20:27:45 | [SYNC] Got block 6938000 (886.3/s, 3713rps 1164wps) -- 170.68m remaining
Oct 3 20:27:46 | [SYNC] Got block 6939000 (684.4/s, 2664rps 921wps) -- 220.99m remaining
Oct 3 20:27:47 | [SYNC] Got block 6940000 (843.2/s, 4282rps 1049wps) -- 179.37m remaining
Oct 3 20:47:48 | [SYNC] Got block 7706000 (721.8/s, 4181rps 872wps) -- 191.84m remaining
Oct 3 20:47:50 | [SYNC] Got block 7707000 (624.4/s, 2989rps 789wps) -- 221.76m remaining
Oct 3 20:47:51 | [SYNC] Got block 7708000 (690.7/s, 3174rps 882wps) -- 200.43m remaining
Oct 3 20:47:52 | [DEBUG] total SQL time: 900000ms
Oct 3 20:47:52 | 37.3% 335415.32ms 0.44avg 770830x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 20:47:52 | 11.1% 99875.22ms 0.56avg 177858x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 20:47:52 | 10.3% 92377.16ms 0.43avg 217151x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:47:52 | 9.4% 84802.14ms 0.38avg 222511x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 20:47:52 | 8.4% 75292.26ms 0.42avg 177857x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:47:52 | 7.2% 64639.84ms 0.44avg 145343x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:47:52 | 6.3% 56465.24ms 0.46avg 123333x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 20:47:52 | 4.6% 41103.83ms 0.42avg 99045x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 20:47:52 | 1.4% 12900.27ms 0.40avg 32539x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 20:47:52 | 1.2% 10689.23ms 0.44avg 24288x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 20:47:52 | 1.0% 9404.95ms 0.40avg 23326x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 20:47:52 | 1.0% 9335.13ms 0.40avg 23326x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 20:47:52 | 0.3% 3123.91ms 4.05avg 771x -- COMMIT
Oct 3 20:47:52 | 0.3% 3043.15ms 0.38avg 8053x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 20:47:52 | 0.1% 478.16ms 0.62avg 771x -- START TRANSACTION
Oct 3 20:47:52 | 0.0% 386.29ms 0.40avg 962x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 20:47:52 | 0.0% 327.71ms 0.34avg 962x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 20:47:52 | 0.0% 318.49ms 0.33avg 962x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 20:47:52 | 0.0% 12.37ms 0.52avg 24x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 20:47:52 | 0.0% 9.34ms 0.39avg 24x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 20:47:53 | [SYNC] Got block 7709000 (649.0/s, 4774rps 751wps) -- 213.3m remaining
Oct 3 20:47:54 | [SYNC] Got block 7710000 (800.6/s, 4487rps 974wps) -- 172.87m remaining
Oct 3 20:47:55 | [SYNC] Got block 7711000 (820.9/s, 5144rps 976wps) -- 168.58m remaining
Oct 3 21:07:40 | [SYNC] Got block 8503000 (520.5/s, 2626rps 649wps) -- 240.53m remaining
Oct 3 21:07:42 | [SYNC] Got block 8504000 (525.6/s, 2834rps 645wps) -- 238.15m remaining
Oct 3 21:07:44 | [SYNC] Got block 8505000 (568.0/s, 2731rps 717wps) -- 220.37m remaining
Oct 3 21:07:46 | [DEBUG] total SQL time: 900000ms
Oct 3 21:07:46 | 39.0% 350686.70ms 0.44avg 797753x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 21:07:46 | 11.2% 101135.02ms 0.57avg 178852x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 21:07:46 | 10.4% 93973.32ms 0.43avg 217250x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:07:46 | 9.7% 86956.52ms 0.39avg 223510x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 21:07:46 | 8.5% 76243.15ms 0.43avg 178853x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:07:46 | 7.3% 65568.68ms 0.45avg 146676x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:07:46 | 4.8% 42937.55ms 0.46avg 92570x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 21:07:46 | 4.5% 40836.83ms 0.41avg 98457x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 21:07:46 | 1.5% 13233.48ms 0.41avg 32192x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 21:07:46 | 0.8% 7633.27ms 0.43avg 17596x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:07:46 | 0.8% 6898.03ms 0.41avg 16768x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 21:07:46 | 0.8% 6888.46ms 0.41avg 16768x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 21:07:46 | 0.4% 3244.33ms 4.07avg 797x -- COMMIT
Oct 3 21:07:46 | 0.3% 2307.40ms 0.37avg 6189x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 21:07:46 | 0.1% 478.16ms 0.60avg 797x -- START TRANSACTION
Oct 3 21:07:46 | 0.0% 361.40ms 0.44avg 828x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 21:07:46 | 0.0% 329.86ms 0.40avg 828x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 21:07:46 | 0.0% 274.71ms 0.33avg 828x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 21:07:46 | 0.0% 7.46ms 0.50avg 15x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 21:07:46 | 0.0% 5.73ms 0.38avg 15x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 21:07:46 | [SYNC] Got block 8506000 (475.7/s, 2930rps 567wps) -- 263.06m remaining
Oct 3 21:07:48 | [SYNC] Got block 8507000 (479.9/s, 3498rps 556wps) -- 260.73m remaining
Oct 3 21:07:50 | [SYNC] Got block 8508000 (524.5/s, 3580rps 614wps) -- 238.52m remaining
Oct 3 21:27:52 | [SYNC] Got block 9256000 (513.4/s, 3349rps 606wps) -- 219.4m remaining
Oct 3 21:27:54 | [SYNC] Got block 9257000 (511.6/s, 3848rps 590wps) -- 220.13m remaining
Oct 3 21:27:56 | [DEBUG] total SQL time: 900000ms
Oct 3 21:27:56 | 37.0% 333426.02ms 0.44avg 752050x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 21:27:56 | 11.6% 104451.20ms 0.57avg 183151x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 21:27:56 | 10.6% 95008.54ms 0.43avg 220775x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:27:56 | 9.8% 87913.05ms 0.39avg 224726x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 21:27:56 | 8.7% 78084.77ms 0.43avg 183150x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:27:56 | 7.5% 67071.81ms 0.45avg 147927x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:27:56 | 5.3% 47435.61ms 0.47avg 100349x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 21:27:56 | 4.6% 41012.50ms 0.42avg 98181x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 21:27:56 | 1.6% 14613.41ms 0.41avg 35255x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 21:27:56 | 1.0% 8906.94ms 0.45avg 19690x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:27:56 | 0.8% 7623.40ms 0.41avg 18542x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 21:27:56 | 0.8% 7573.18ms 0.41avg 18542x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 21:27:56 | 0.3% 2978.29ms 3.96avg 752x -- COMMIT
Oct 3 21:27:56 | 0.2% 2158.10ms 0.40avg 5336x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 21:27:56 | 0.1% 474.18ms 0.63avg 752x -- START TRANSACTION
Oct 3 21:27:56 | 0.1% 467.33ms 0.41avg 1148x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 21:27:56 | 0.0% 388.12ms 0.34avg 1148x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 21:27:56 | 0.0% 383.16ms 0.33avg 1148x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 21:27:56 | 0.0% 17.94ms 0.54avg 33x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 21:27:56 | 0.0% 12.85ms 0.39avg 33x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 21:27:56 | [SYNC] Got block 9258000 (526.1/s, 3700rps 613wps) -- 214.03m remaining
Oct 3 21:27:58 | [SYNC] Got block 9259000 (644.4/s, 2584rps 858wps) -- 174.71m remaining
Oct 3 21:48:44 | [SYNC] Got block 10046000 (678.6/s, 2698rps 906wps) -- 146.6m remaining
Oct 3 21:48:45 | [SYNC] Got block 10047000 (737.4/s, 2931rps 985wps) -- 134.87m remaining
Oct 3 21:48:46 | [DEBUG] total SQL time: 900000ms
Oct 3 21:48:46 | 39.0% 351195.77ms 0.44avg 790018x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 21:48:46 | 11.0% 99313.67ms 0.58avg 172527x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 21:48:46 | 10.2% 92131.64ms 0.44avg 211174x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:48:46 | 9.5% 85833.33ms 0.39avg 218524x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 21:48:46 | 8.3% 74642.13ms 0.43avg 172528x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:48:46 | 6.9% 61925.49ms 0.45avg 136669x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:48:46 | 5.7% 51380.69ms 0.48avg 106098x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 21:48:46 | 4.3% 38512.35ms 0.42avg 91126x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 21:48:46 | 1.6% 14471.36ms 0.40avg 35886x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 21:48:46 | 1.0% 8647.93ms 0.44avg 19511x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 21:48:46 | 0.8% 7569.03ms 0.41avg 18321x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 21:48:46 | 0.8% 7480.79ms 0.41avg 18321x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 21:48:46 | 0.4% 3191.95ms 4.04avg 790x -- COMMIT
Oct 3 21:48:46 | 0.2% 1853.14ms 0.38avg 4815x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 21:48:46 | 0.1% 534.33ms 0.68avg 790x -- START TRANSACTION
Oct 3 21:48:46 | 0.1% 489.38ms 0.41avg 1190x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 21:48:46 | 0.0% 407.97ms 0.34avg 1190x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 21:48:46 | 0.0% 396.22ms 0.33avg 1190x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 21:48:46 | 0.0% 12.85ms 0.49avg 26x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 21:48:46 | 0.0% 10.12ms 0.39avg 26x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 21:48:47 | [SYNC] Got block 10048000 (654.3/s, 3888rps 786wps) -- 151.97m remaining
Oct 3 21:48:48 | [SYNC] Got block 10049000 (605.1/s, 3265rps 742wps) -- 164.31m remaining
Oct 3 22:09:17 | [SYNC] Got block 10704000 (808.9/s, 5014rps 964wps) -- 109.42m remaining
Oct 3 22:09:18 | [SYNC] Got block 10705000 (776.5/s, 4931rps 921wps) -- 113.96m remaining
Oct 3 22:09:18 | [DEBUG] total SQL time: 900000ms
Oct 3 22:09:18 | 32.4% 292013.13ms 0.44avg 657107x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 22:09:18 | 12.7% 114343.34ms 0.57avg 198967x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 22:09:18 | 11.3% 101823.65ms 0.43avg 235446x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:09:18 | 10.3% 92372.32ms 0.39avg 234904x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 22:09:18 | 9.6% 86048.59ms 0.43avg 198967x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:09:18 | 8.0% 71814.43ms 0.45avg 159809x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:09:18 | 5.5% 49397.87ms 0.47avg 104938x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 22:09:18 | 4.9% 44353.28ms 0.42avg 106094x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 22:09:18 | 1.8% 16179.02ms 0.41avg 39178x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 22:09:18 | 1.0% 8873.74ms 0.44avg 20216x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:09:18 | 0.9% 8022.30ms 0.43avg 18773x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 22:09:18 | 0.8% 7638.66ms 0.41avg 18773x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 22:09:18 | 0.3% 2655.98ms 4.04avg 658x -- COMMIT
Oct 3 22:09:18 | 0.3% 2423.95ms 0.36avg 6649x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 22:09:18 | 0.1% 582.89ms 0.40avg 1443x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 22:09:18 | 0.1% 494.19ms 0.34avg 1443x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 22:09:18 | 0.1% 479.53ms 0.33avg 1443x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 22:09:18 | 0.1% 463.76ms 0.70avg 658x -- START TRANSACTION
Oct 3 22:09:18 | 0.0% 11.15ms 0.53avg 21x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 22:09:18 | 0.0% 8.61ms 0.41avg 21x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 22:09:19 | [SYNC] Got block 10706000 (897.9/s, 5107rps 1089wps) -- 98.53m remaining
Oct 3 22:09:20 | [SYNC] Got block 10707000 (863.0/s, 3110rps 1194wps) -- 102.5m remaining
Oct 3 22:29:12 | [SYNC] Got block 11455000 (653.8/s, 4016rps 780wps) -- 116.22m remaining
Oct 3 22:29:13 | [SYNC] Got block 11456000 (611.6/s, 3673rps 733wps) -- 124.22m remaining
Oct 3 22:29:13 | [DEBUG] total SQL time: 900000ms
Oct 3 22:29:13 | 37.9% 341495.13ms 0.45avg 751008x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 22:29:13 | 11.8% 105820.02ms 0.58avg 182150x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 22:29:13 | 10.7% 96626.98ms 0.44avg 217382x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:29:13 | 9.0% 80763.24ms 0.44avg 182150x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:29:13 | 8.3% 74522.25ms 0.39avg 189491x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 22:29:13 | 7.6% 68260.97ms 0.47avg 146234x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:29:13 | 4.7% 42205.67ms 0.48avg 87121x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 22:29:13 | 4.5% 40594.83ms 0.43avg 95278x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 22:29:13 | 1.7% 15011.25ms 0.42avg 35921x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 22:29:13 | 1.1% 10252.06ms 0.49avg 20753x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:29:13 | 0.9% 8385.55ms 0.43avg 19575x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 22:29:13 | 0.9% 8116.01ms 0.41avg 19575x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 22:29:13 | 0.3% 3141.64ms 4.18avg 751x -- COMMIT
Oct 3 22:29:13 | 0.3% 2668.93ms 0.36avg 7336x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 22:29:13 | 0.1% 678.59ms 0.58avg 1178x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 22:29:13 | 0.1% 603.99ms 0.51avg 1178x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 22:29:13 | 0.1% 458.36ms 0.61avg 751x -- START TRANSACTION
Oct 3 22:29:13 | 0.0% 390.22ms 0.33avg 1178x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 22:29:13 | 0.0% 2.64ms 0.53avg 5x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 22:29:13 | 0.0% 1.97ms 0.39avg 5x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 22:29:15 | [SYNC] Got block 11457000 (610.2/s, 5061rps 693wps) -- 124.48m remaining
Oct 3 22:29:16 | [SYNC] Got block 11458000 (688.8/s, 4862rps 802wps) -- 110.25m remaining
Oct 3 22:48:43 | [SYNC] Got block 11906000 (257.2/s, 1750rps 301wps) -- 266.27m remaining
Oct 3 22:48:47 | [SYNC] Got block 11907000 (273.7/s, 1829rps 321wps) -- 250.15m remaining
Oct 3 22:48:49 | [DEBUG] total SQL time: 900000ms
Oct 3 22:48:49 | 22.5% 202412.63ms 0.45avg 451542x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 22:48:49 | 13.7% 123614.70ms 0.57avg 215581x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 22:48:49 | 12.1% 108457.16ms 0.43avg 253189x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:48:49 | 11.9% 106929.20ms 0.47avg 228392x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 22:48:49 | 10.4% 93669.29ms 0.43avg 215581x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:48:49 | 9.7% 87424.42ms 0.39avg 223441x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 22:48:49 | 8.8% 79131.52ms 0.45avg 174601x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:48:49 | 5.3% 47785.99ms 0.42avg 114039x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 22:48:49 | 1.9% 16672.76ms 0.41avg 41014x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 22:48:49 | 1.1% 10098.13ms 0.45avg 22298x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 22:48:49 | 1.0% 8879.75ms 0.42avg 21374x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 22:48:49 | 1.0% 8756.74ms 0.41avg 21374x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 22:48:49 | 0.3% 3023.93ms 0.39avg 7826x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 22:48:49 | 0.2% 1791.57ms 3.97avg 451x -- COMMIT
Oct 3 22:48:49 | 0.0% 378.30ms 0.41avg 924x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 22:48:49 | 0.0% 328.07ms 0.73avg 451x -- START TRANSACTION
Oct 3 22:48:49 | 0.0% 308.34ms 0.33avg 924x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 22:48:49 | 0.0% 307.95ms 0.33avg 924x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 22:48:49 | 0.0% 16.91ms 0.50avg 34x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 22:48:49 | 0.0% 13.08ms 0.38avg 34x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 22:48:50 | [SYNC] Got block 11908000 (287.6/s, 1847rps 340wps) -- 237.94m remaining
Oct 3 22:48:53 | [SYNC] Got block 11909000 (339.4/s, 1786rps 418wps) -- 201.63m remaining
Oct 3 22:48:56 | [SYNC] Got block 11910000 (359.7/s, 1731rps 454wps) -- 190.16m remaining
Oct 3 23:07:51 | [SYNC] Got block 12152000 (209.3/s, 1083rps 259wps) -- 307.5m remaining
Oct 3 23:07:57 | [SYNC] Got block 12153000 (156.0/s, 1096rps 181wps) -- 412.49m remaining
Oct 3 23:07:59 | [DEBUG] total SQL time: 900000ms
Oct 3 23:07:59 | 17.9% 160803.21ms 0.47avg 342739x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 23:07:59 | 14.6% 131773.88ms 0.57avg 231585x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 23:07:59 | 12.8% 115321.93ms 0.43avg 270544x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:07:59 | 12.0% 108329.81ms 0.44avg 245525x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 23:07:59 | 10.8% 97198.37ms 0.42avg 231585x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:07:59 | 10.3% 92324.56ms 0.39avg 239745x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 23:07:59 | 9.2% 83194.71ms 0.45avg 185251x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:07:59 | 5.9% 53119.81ms 0.43avg 124959x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 23:07:59 | 2.1% 18528.66ms 0.40avg 46352x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 23:07:59 | 1.4% 12174.75ms 0.43avg 28083x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:07:59 | 1.2% 10976.46ms 0.40avg 27241x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 23:07:59 | 1.2% 10837.18ms 0.40avg 27241x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 23:07:59 | 0.4% 3235.43ms 0.40avg 8144x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 23:07:59 | 0.1% 1043.89ms 4.24avg 246x -- COMMIT
Oct 3 23:07:59 | 0.0% 336.97ms 0.40avg 842x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 23:07:59 | 0.0% 283.89ms 0.34avg 842x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 23:07:59 | 0.0% 283.05ms 0.34avg 842x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 23:07:59 | 0.0% 217.06ms 0.88avg 246x -- START TRANSACTION
Oct 3 23:07:59 | 0.0% 9.29ms 0.52avg 18x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 23:07:59 | 0.0% 7.12ms 0.40avg 18x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 23:08:03 | [SYNC] Got block 12154000 (170.9/s, 1115rps 201wps) -- 376.46m remaining
Oct 3 23:08:09 | [SYNC] Got block 12155000 (161.0/s, 1247rps 184wps) -- 399.65m remaining
Oct 3 23:26:50 | [SYNC] Got block 12375000 (197.2/s, 1223rps 235wps) -- 307.66m remaining
Oct 3 23:26:55 | [SYNC] Got block 12376000 (216.5/s, 1412rps 255wps) -- 280.06m remaining
Oct 3 23:26:58 | [DEBUG] total SQL time: 900000ms
Oct 3 23:26:58 | 15.8% 142474.09ms 0.57avg 249509x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 23:26:58 | 14.0% 125626.51ms 0.47avg 268278x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 23:26:58 | 13.6% 122219.01ms 0.42avg 287675x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:26:58 | 11.9% 107531.72ms 0.43avg 249509x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:26:58 | 11.1% 99699.61ms 0.45avg 223593x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 23:26:58 | 10.8% 96969.12ms 0.38avg 254082x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 23:26:58 | 10.2% 91924.16ms 0.45avg 206242x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:26:58 | 6.4% 57901.30ms 0.42avg 138941x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 23:26:58 | 2.0% 18206.10ms 0.42avg 43282x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 23:26:58 | 1.3% 11876.84ms 0.44avg 27028x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:26:58 | 1.2% 10989.83ms 0.42avg 26228x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 23:26:58 | 1.2% 10451.00ms 0.40avg 26228x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 23:26:58 | 0.2% 1866.71ms 0.41avg 4558x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 23:26:58 | 0.1% 993.40ms 4.45avg 223x -- COMMIT
Oct 3 23:26:58 | 0.1% 462.17ms 0.58avg 800x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 23:26:58 | 0.0% 325.02ms 0.41avg 800x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 23:26:58 | 0.0% 270.32ms 0.34avg 800x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 23:26:58 | 0.0% 199.51ms 0.89avg 223x -- START TRANSACTION
Oct 3 23:26:58 | 0.0% 7.89ms 0.53avg 15x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 23:26:58 | 0.0% 5.96ms 0.40avg 15x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 23:26:59 | [SYNC] Got block 12377000 (246.4/s, 1854rps 284wps) -- 246.06m remaining
Oct 3 23:27:04 | [SYNC] Got block 12378000 (203.6/s, 1440rps 237wps) -- 297.66m remaining
Oct 3 23:27:09 | [SYNC] Got block 12379000 (189.0/s, 1601rps 214wps) -- 320.54m remaining
Oct 3 23:45:29 | [SYNC] Got block 12564000 (90.0/s, 769rps 101wps) -- 638.76m remaining
Oct 3 23:45:41 | [SYNC] Got block 12565000 (82.1/s, 649rps 94wps) -- 700.02m remaining
Oct 3 23:45:47 | [DEBUG] total SQL time: 900000ms
Oct 3 23:45:47 | 15.9% 143274.13ms 0.58avg 248888x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 3 23:45:47 | 15.1% 136188.12ms 0.46avg 293041x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 3 23:45:47 | 13.3% 119858.60ms 0.42avg 285277x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:45:47 | 11.9% 106694.74ms 0.43avg 248888x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:45:47 | 11.1% 99662.27ms 0.39avg 258276x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 3 23:45:47 | 10.5% 94212.75ms 0.45avg 209733x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:45:47 | 9.4% 84316.63ms 0.45avg 188797x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 3 23:45:47 | 6.6% 59785.55ms 0.42avg 142163x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 3 23:45:47 | 1.8% 15829.58ms 0.40avg 39174x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 23:45:47 | 1.4% 13028.60ms 0.47avg 27763x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 3 23:45:47 | 1.2% 11002.05ms 0.41avg 26965x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 3 23:45:47 | 1.2% 10761.27ms 0.40avg 26965x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 3 23:45:47 | 0.4% 3487.66ms 0.37avg 9369x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 3 23:45:47 | 0.1% 849.28ms 4.49avg 189x -- COMMIT
Oct 3 23:45:47 | 0.0% 322.04ms 0.40avg 798x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 3 23:45:47 | 0.0% 268.35ms 0.34avg 798x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 3 23:45:47 | 0.0% 267.85ms 0.34avg 798x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 3 23:45:47 | 0.0% 173.74ms 0.92avg 189x -- START TRANSACTION
Oct 3 23:45:47 | 0.0% 9.28ms 0.49avg 19x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 3 23:45:47 | 0.0% 7.74ms 0.41avg 19x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 3 23:45:51 | [SYNC] Got block 12566000 (98.7/s, 929rps 110wps) -- 582.53m remaining
Oct 3 23:45:59 | [SYNC] Got block 12567000 (119.4/s, 1085rps 134wps) -- 481.25m remaining
Oct 3 23:46:07 | [SYNC] Got block 12568000 (126.4/s, 1184rps 141wps) -- 454.35m remaining
Oct 4 00:04:11 | [SYNC] Got block 12689000 (98.6/s, 887rps 110wps) -- 562.35m remaining
Oct 4 00:04:19 | [SYNC] Got block 12690000 (116.3/s, 764rps 137wps) -- 476.38m remaining
Oct 4 00:04:21 | [DEBUG] total SQL time: 900000ms
Oct 4 00:04:21 | 19.7% 177645.64ms 0.47avg 381267x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 00:04:21 | 15.8% 141921.06ms 0.58avg 244200x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 00:04:21 | 13.3% 119698.55ms 0.43avg 278828x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 00:04:21 | 11.6% 104540.22ms 0.43avg 244200x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 00:04:21 | 10.7% 96373.58ms 0.39avg 247696x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 00:04:21 | 10.4% 93215.63ms 0.45avg 208190x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 00:04:21 | 6.7% 60304.33ms 0.42avg 142476x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 00:04:21 | 6.2% 55635.60ms 0.45avg 124705x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 00:04:21 | 1.6% 14483.79ms 0.40avg 36027x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 00:04:21 | 1.4% 12408.19ms 0.47avg 26628x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 00:04:21 | 1.2% 10564.55ms 0.41avg 25749x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 00:04:21 | 1.1% 10246.29ms 0.40avg 25749x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 00:04:21 | 0.1% 1288.17ms 0.37avg 3479x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 00:04:21 | 0.1% 546.96ms 4.38avg 125x -- COMMIT
Oct 4 00:04:21 | 0.0% 366.47ms 0.42avg 879x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 00:04:21 | 0.0% 299.00ms 0.34avg 879x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 00:04:21 | 0.0% 297.25ms 0.34avg 879x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 00:04:21 | 0.0% 149.30ms 1.19avg 125x -- START TRANSACTION
Oct 4 00:04:21 | 0.0% 8.64ms 0.51avg 17x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 00:04:21 | 0.0% 7.22ms 0.42avg 17x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 00:04:26 | [SYNC] Got block 12691000 (150.9/s, 1016rps 177wps) -- 367.13m remaining
Oct 4 00:04:33 | [SYNC] Got block 12692000 (151.2/s, 1209rps 172wps) -- 366.14m remaining
Oct 4 00:04:41 | [SYNC] Got block 12693000 (116.2/s, 1001rps 131wps) -- 476.3m remaining
Oct 4 01:06:51 | [SYNC] Got block 12896000 (109.4/s, 1479rps 118wps) -- 475.94m remaining
Oct 4 01:07:02 | [SYNC] Got block 12897000 (89.5/s, 1238rps 96wps) -- 581.86m remaining
Oct 4 01:07:11 | [DEBUG] total SQL time: 900000ms
Oct 4 01:07:11 | 19.3% 173885.24ms 0.46avg 376134x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 01:07:11 | 16.3% 146551.96ms 0.57avg 254980x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 01:07:11 | 13.4% 120735.08ms 0.42avg 289198x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:07:11 | 11.9% 106868.40ms 0.42avg 254980x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:07:11 | 11.1% 99757.36ms 0.38avg 263357x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 01:07:11 | 10.8% 96793.72ms 0.45avg 217157x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:07:11 | 6.9% 61755.29ms 0.41avg 149641x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 01:07:11 | 4.7% 42378.78ms 0.45avg 93905x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 01:07:11 | 1.7% 15325.60ms 0.40avg 37845x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 01:07:11 | 1.2% 11118.63ms 0.43avg 25672x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:07:11 | 1.1% 10118.23ms 0.41avg 24841x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 01:07:11 | 1.1% 9969.83ms 0.40avg 24841x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 01:07:11 | 0.4% 3239.99ms 0.39avg 8355x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 01:07:11 | 0.0% 435.69ms 4.68avg 93x -- COMMIT
Oct 4 01:07:11 | 0.0% 358.98ms 0.43avg 831x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 01:07:11 | 0.0% 284.66ms 0.34avg 831x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 01:07:11 | 0.0% 284.38ms 0.34avg 831x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 01:07:11 | 0.0% 117.17ms 1.25avg 94x -- START TRANSACTION
Oct 4 01:07:11 | 0.0% 11.08ms 0.53avg 21x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 01:07:11 | 0.0% 8.38ms 0.40avg 21x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 01:07:11 | 0.0% 0.74ms 0.74avg 1x -- SHOW TABLES
Oct 4 01:07:11 | 0.0% 0.68ms 0.34avg 2x -- SELECT MAX(num) FROM hive_blocks
Oct 4 01:07:11 | 0.0% 0.37ms 0.37avg 1x -- SELECT 1 FROM hive_posts_cache LIMIT 1
Oct 4 01:07:12 | [SYNC] Got block 12898000 (102.0/s, 1234rps 111wps) -- 510.24m remaining
Oct 4 01:07:22 | [SYNC] Got block 12899000 (95.8/s, 1258rps 103wps) -- 543.07m remaining
Oct 4 01:24:40 | [SYNC] Got block 12990000 (44.2/s, 540rps 48wps) -- 1143.12m remaining
Oct 4 01:25:04 | [SYNC] Got block 12991000 (41.2/s, 514rps 44wps) -- 1226.49m remaining
Oct 4 01:25:11 | [DEBUG] total SQL time: 900000ms
Oct 4 01:25:11 | 19.0% 170963.29ms 0.46avg 368034x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 01:25:11 | 16.5% 148382.28ms 0.58avg 255347x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 01:25:11 | 13.5% 121316.67ms 0.42avg 289489x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:25:11 | 11.8% 106597.49ms 0.42avg 255347x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:25:11 | 11.1% 99936.78ms 0.38avg 261845x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 01:25:11 | 10.9% 97700.50ms 0.45avg 219355x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:25:11 | 7.0% 62636.42ms 0.41avg 151462x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 01:25:11 | 4.7% 42094.79ms 0.45avg 93268x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 01:25:11 | 1.6% 14718.01ms 0.41avg 36008x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 01:25:11 | 1.3% 11356.69ms 0.44avg 25624x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:25:11 | 1.1% 10186.50ms 0.41avg 24793x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 01:25:11 | 1.1% 10150.55ms 0.41avg 24793x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 01:25:11 | 0.3% 2435.93ms 0.38avg 6481x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 01:25:11 | 0.1% 461.94ms 4.91avg 94x -- COMMIT
Oct 4 01:25:11 | 0.0% 342.46ms 0.41avg 831x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 01:25:11 | 0.0% 286.14ms 0.34avg 831x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 01:25:11 | 0.0% 284.30ms 0.34avg 831x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 01:25:11 | 0.0% 132.75ms 1.41avg 94x -- START TRANSACTION
Oct 4 01:25:11 | 0.0% 9.06ms 0.50avg 18x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 01:25:11 | 0.0% 7.47ms 0.42avg 18x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 01:25:29 | [SYNC] Got block 12992000 (40.0/s, 441rps 43wps) -- 1261.83m remaining
Oct 4 01:42:34 | [SYNC] Got block 13050000 (42.6/s, 558rps 46wps) -- 1163.31m remaining
Oct 4 01:42:55 | [SYNC] Got block 13051000 (46.9/s, 627rps 50wps) -- 1054.58m remaining
Oct 4 01:43:05 | [DEBUG] total SQL time: 900000ms
Oct 4 01:43:05 | 19.0% 171125.81ms 0.47avg 364495x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 01:43:05 | 17.0% 152836.03ms 0.59avg 260262x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 01:43:05 | 13.7% 123436.26ms 0.42avg 295268x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:43:05 | 12.1% 109107.16ms 0.42avg 260262x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:43:05 | 11.2% 100936.44ms 0.38avg 265008x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 01:43:05 | 10.9% 98250.40ms 0.45avg 219520x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:43:05 | 7.2% 64369.75ms 0.42avg 154662x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 01:43:05 | 3.1% 27654.51ms 0.46avg 60221x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 01:43:05 | 1.9% 16694.44ms 0.41avg 40767x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 01:43:05 | 1.3% 11530.54ms 0.44avg 26329x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 01:43:05 | 1.2% 10424.70ms 0.41avg 25374x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 01:43:05 | 1.2% 10376.36ms 0.41avg 25373x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 01:43:05 | 0.2% 1779.46ms 0.38avg 4722x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 01:43:05 | 0.0% 402.74ms 0.42avg 953x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 01:43:05 | 0.0% 329.19ms 0.35avg 953x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 01:43:05 | 0.0% 328.69ms 0.34avg 953x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 01:43:05 | 0.0% 296.29ms 4.94avg 60x -- COMMIT
Oct 4 01:43:05 | 0.0% 97.49ms 1.62avg 60x -- START TRANSACTION
Oct 4 01:43:05 | 0.0% 13.37ms 0.56avg 24x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 01:43:05 | 0.0% 10.41ms 0.43avg 24x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 01:43:16 | [SYNC] Got block 13052000 (47.7/s, 639rps 51wps) -- 1036.32m remaining
Oct 4 02:00:22 | [SYNC] Got block 13106000 (40.9/s, 545rps 44wps) -- 1186.58m remaining
Oct 4 02:00:48 | [SYNC] Got block 13107000 (39.2/s, 467rps 42wps) -- 1240.36m remaining
Oct 4 02:01:03 | [DEBUG] total SQL time: 900000ms
Oct 4 02:01:03 | 25.5% 229694.42ms 0.47avg 488025x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 02:01:03 | 15.5% 139896.89ms 0.59avg 237210x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 02:01:03 | 12.7% 113928.87ms 0.42avg 271030x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:01:03 | 11.1% 99966.79ms 0.42avg 237210x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:01:03 | 10.4% 93620.21ms 0.38avg 244416x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 02:01:03 | 9.8% 88517.07ms 0.45avg 197283x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:01:03 | 6.5% 58784.36ms 0.42avg 140700x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 02:01:03 | 2.9% 26093.91ms 0.46avg 56190x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 02:01:03 | 1.8% 16510.75ms 0.41avg 39954x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:01:03 | 1.1% 10257.51ms 0.44avg 23244x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:01:03 | 1.0% 9202.49ms 0.41avg 22220x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 02:01:03 | 1.0% 9121.28ms 0.41avg 22221x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:01:03 | 0.3% 2754.53ms 0.38avg 7179x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 02:01:03 | 0.1% 561.53ms 0.55avg 1024x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 02:01:03 | 0.0% 356.70ms 0.35avg 1024x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 02:01:03 | 0.0% 353.95ms 0.35avg 1024x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 02:01:03 | 0.0% 251.21ms 4.49avg 56x -- COMMIT
Oct 4 02:01:03 | 0.0% 103.00ms 1.84avg 56x -- START TRANSACTION
Oct 4 02:01:03 | 0.0% 13.76ms 0.53avg 26x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 02:01:03 | 0.0% 10.84ms 0.42avg 26x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 02:01:12 | [SYNC] Got block 13108000 (41.3/s, 525rps 44wps) -- 1174.75m remaining
Oct 4 02:01:33 | [SYNC] Got block 13109000 (46.5/s, 594rps 50wps) -- 1042.59m remaining
Oct 4 02:18:25 | [SYNC] Got block 13164000 (48.9/s, 597rps 53wps) -- 972.8m remaining
Oct 4 02:18:47 | [SYNC] Got block 13165000 (45.8/s, 565rps 49wps) -- 1039.16m remaining
Oct 4 02:18:59 | [DEBUG] total SQL time: 900000ms
Oct 4 02:18:59 | 24.8% 222906.89ms 0.47avg 475671x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 02:18:59 | 15.7% 141685.03ms 0.59avg 241288x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 02:18:59 | 12.9% 115682.52ms 0.42avg 274554x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:18:59 | 11.3% 101653.78ms 0.42avg 241287x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:18:59 | 10.4% 93327.83ms 0.38avg 243638x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 02:18:59 | 10.2% 92107.56ms 0.45avg 204801x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:18:59 | 6.7% 60454.72ms 0.42avg 144850x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 02:18:59 | 3.0% 26741.76ms 0.46avg 57905x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 02:18:59 | 1.7% 15122.75ms 0.41avg 36505x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:18:59 | 1.1% 10175.23ms 0.45avg 22489x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:18:59 | 1.0% 8891.43ms 0.41avg 21469x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 02:18:59 | 1.0% 8788.95ms 0.41avg 21469x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:18:59 | 0.1% 923.43ms 0.40avg 2332x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 02:18:59 | 0.0% 420.14ms 0.41avg 1020x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 02:18:59 | 0.0% 355.53ms 0.35avg 1020x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 02:18:59 | 0.0% 352.50ms 0.35avg 1020x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 02:18:59 | 0.0% 282.11ms 4.86avg 58x -- COMMIT
Oct 4 02:18:59 | 0.0% 110.00ms 1.90avg 58x -- START TRANSACTION
Oct 4 02:18:59 | 0.0% 10.11ms 0.53avg 19x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 02:18:59 | 0.0% 8.07ms 0.42avg 19x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 02:19:11 | [SYNC] Got block 13166000 (41.5/s, 568rps 44wps) -- 1147.68m remaining
Oct 4 02:19:35 | [SYNC] Got block 13167000 (41.3/s, 486rps 45wps) -- 1153.01m remaining
Oct 4 02:36:41 | [SYNC] Got block 13219000 (43.8/s, 518rps 47wps) -- 1065.11m remaining
Oct 4 02:36:50 | --- no python application found, check your startup logs for errors ---
Oct 4 02:36:51 | --- no python application found, check your startup logs for errors ---
Oct 4 02:37:00 | [DEBUG] total SQL time: 900000ms
Oct 4 02:37:00 | 23.2% 208777.91ms 0.47avg 440253x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 02:37:00 | 16.2% 145567.10ms 0.59avg 245258x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 02:37:00 | 13.0% 116895.80ms 0.42avg 278606x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:37:00 | 11.5% 103367.64ms 0.42avg 245258x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:37:00 | 10.7% 96654.16ms 0.38avg 252600x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 02:37:00 | 10.2% 92022.91ms 0.45avg 204852x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:37:00 | 6.8% 60942.59ms 0.42avg 145750x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 02:37:00 | 2.8% 25236.14ms 0.47avg 54224x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 02:37:00 | 1.9% 16840.28ms 0.42avg 40432x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:37:00 | 1.2% 10494.79ms 0.44avg 23822x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:37:00 | 1.0% 9405.09ms 0.41avg 22854x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 02:37:00 | 1.0% 9363.04ms 0.41avg 22854x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:37:00 | 0.3% 2828.07ms 0.39avg 7316x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 02:37:00 | 0.0% 432.97ms 0.45avg 968x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 02:37:00 | 0.0% 360.28ms 6.67avg 54x -- COMMIT
Oct 4 02:37:00 | 0.0% 337.20ms 0.35avg 968x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 02:37:00 | 0.0% 331.37ms 0.34avg 968x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 02:37:00 | 0.0% 117.59ms 2.18avg 54x -- START TRANSACTION
Oct 4 02:37:00 | 0.0% 13.81ms 0.53avg 26x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 02:37:00 | 0.0% 11.43ms 0.44avg 26x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 02:37:06 | --- no python application found, check your startup logs for errors ---
Oct 4 02:37:06 | --- no python application found, check your startup logs for errors ---
Oct 4 02:37:07 | [SYNC] Got block 13220000 (38.3/s, 491rps 41wps) -- 1218.64m remaining
Oct 4 02:37:21 | --- no python application found, check your startup logs for errors ---
Oct 4 02:37:21 | --- no python application found, check your startup logs for errors ---
Oct 4 02:37:32 | [SYNC] Got block 13221000 (40.4/s, 498rps 43wps) -- 1156.4m remaining
Oct 4 02:54:18 | [SYNC] Got block 13275000 (51.0/s, 720rps 54wps) -- 897.03m remaining
Oct 4 02:54:21 | --- no python application found, check your startup logs for errors ---
Oct 4 02:54:22 | --- no python application found, check your startup logs for errors ---
Oct 4 02:54:36 | --- no python application found, check your startup logs for errors ---
Oct 4 02:54:37 | --- no python application found, check your startup logs for errors ---
Oct 4 02:54:38 | [SYNC] Got block 13276000 (49.4/s, 596rps 53wps) -- 926.67m remaining
Oct 4 02:54:51 | --- no python application found, check your startup logs for errors ---
Oct 4 02:54:52 | --- no python application found, check your startup logs for errors ---
Oct 4 02:54:59 | [DEBUG] total SQL time: 900003ms
Oct 4 02:54:59 | 21.7% 195394.04ms 0.48avg 407542x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 02:54:59 | 16.6% 148965.92ms 0.60avg 247788x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 02:54:59 | 13.2% 118851.77ms 0.42avg 280914x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:54:59 | 11.6% 104689.63ms 0.42avg 247789x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:54:59 | 10.8% 97380.13ms 0.38avg 253031x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 02:54:59 | 10.5% 94442.63ms 0.45avg 209185x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:54:59 | 7.0% 63193.02ms 0.42avg 150826x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 02:54:59 | 3.0% 27226.48ms 0.48avg 57179x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 02:54:59 | 1.8% 16132.58ms 0.42avg 38623x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:54:59 | 1.2% 10752.15ms 0.44avg 24346x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 02:54:59 | 1.1% 9780.75ms 0.42avg 23394x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 02:54:59 | 1.1% 9730.64ms 0.42avg 23394x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 02:54:59 | 0.2% 1998.85ms 0.38avg 5223x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 02:54:59 | 0.0% 396.02ms 0.42avg 952x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 02:54:59 | 0.0% 337.28ms 0.35avg 952x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 02:54:59 | 0.0% 330.13ms 0.35avg 952x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 02:54:59 | 0.0% 277.16ms 4.86avg 57x -- COMMIT
Oct 4 02:54:59 | 0.0% 104.06ms 1.83avg 57x -- START TRANSACTION
Oct 4 02:54:59 | 0.0% 11.03ms 0.55avg 20x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 02:54:59 | 0.0% 8.82ms 0.44avg 20x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 02:55:01 | [SYNC] Got block 13277000 (43.2/s, 528rps 47wps) -- 1058.91m remaining
Oct 4 02:55:06 | --- no python application found, check your startup logs for errors ---
Oct 4 02:55:07 | --- no python application found, check your startup logs for errors ---
Oct 4 02:55:11 | #033[93m[SQL][232ms] INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (:fr, :fg, :at, :state) ON DUPLICATE KEY UPDATE state = :state#033[0m
Oct 4 02:55:21 | --- no python application found, check your startup logs for errors ---
Oct 4 02:55:22 | --- no python application found, check your startup logs for errors ---
Oct 4 02:55:23 | [SYNC] Got block 13278000 (45.6/s, 537rps 49wps) -- 1002.63m remaining
Oct 4 03:12:41 | [SYNC] Got block 13337000 (45.9/s, 546rps 50wps) -- 975.08m remaining
Oct 4 03:12:52 | --- no python application found, check your startup logs for errors ---
Oct 4 03:12:52 | --- no python application found, check your startup logs for errors ---
Oct 4 03:13:01 | [DEBUG] total SQL time: 900000ms
Oct 4 03:13:01 | 24.1% 216751.02ms 0.47avg 457345x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 03:13:01 | 16.0% 143692.55ms 0.60avg 240472x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 03:13:01 | 12.8% 114857.20ms 0.42avg 272692x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:13:01 | 11.4% 102276.81ms 0.43avg 240471x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:13:01 | 10.4% 93717.43ms 0.38avg 244777x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 03:13:01 | 10.2% 91358.14ms 0.45avg 202630x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:13:01 | 6.8% 61290.82ms 0.42avg 146687x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 03:13:01 | 3.1% 28103.61ms 0.46avg 61079x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 03:13:01 | 1.8% 15954.01ms 0.42avg 37864x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 03:13:01 | 1.1% 10318.52ms 0.44avg 23452x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:13:01 | 1.0% 9302.98ms 0.41avg 22512x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 03:13:01 | 1.0% 9243.08ms 0.41avg 22512x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 03:13:01 | 0.2% 1620.83ms 0.38avg 4283x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 03:13:01 | 0.0% 397.86ms 0.42avg 940x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 03:13:01 | 0.0% 331.01ms 0.35avg 940x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 03:13:01 | 0.0% 322.84ms 0.34avg 940x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 03:13:01 | 0.0% 317.57ms 5.21avg 61x -- COMMIT
Oct 4 03:13:01 | 0.0% 122.96ms 2.02avg 61x -- START TRANSACTION
Oct 4 03:13:01 | 0.0% 11.77ms 0.53avg 22x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 03:13:01 | 0.0% 9.09ms 0.41avg 22x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 03:13:02 | [SYNC] Got block 13338000 (48.0/s, 589rps 52wps) -- 931.97m remaining
Oct 4 03:13:07 | --- no python application found, check your startup logs for errors ---
Oct 4 03:13:08 | --- no python application found, check your startup logs for errors ---
Oct 4 03:13:22 | --- no python application found, check your startup logs for errors ---
Oct 4 03:13:23 | --- no python application found, check your startup logs for errors ---
Oct 4 03:13:24 | [SYNC] Got block 13339000 (45.4/s, 548rps 49wps) -- 983.66m remaining
Oct 4 03:30:47 | [SYNC] Got block 13395000 (53.6/s, 551rps 59wps) -- 816.07m remaining
Oct 4 03:30:53 | --- no python application found, check your startup logs for errors ---
Oct 4 03:30:53 | --- no python application found, check your startup logs for errors ---
Oct 4 03:31:06 | [SYNC] Got block 13396000 (53.0/s, 606rps 58wps) -- 825.15m remaining
Oct 4 03:31:08 | --- no python application found, check your startup logs for errors ---
Oct 4 03:31:08 | --- no python application found, check your startup logs for errors ---
Oct 4 03:31:10 | [DEBUG] total SQL time: 900000ms
Oct 4 03:31:10 | 26.4% 237390.62ms 0.47avg 500559x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 03:31:10 | 15.4% 138946.23ms 0.60avg 233464x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 03:31:10 | 12.3% 111099.50ms 0.42avg 263555x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:31:10 | 10.9% 98483.25ms 0.42avg 233465x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:31:10 | 10.1% 90766.26ms 0.38avg 237464x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 03:31:10 | 9.7% 87697.63ms 0.45avg 195578x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:31:10 | 6.6% 59544.39ms 0.42avg 142924x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 03:31:10 | 3.0% 26915.95ms 0.46avg 58152x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 03:31:10 | 1.8% 15973.82ms 0.42avg 37902x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 03:31:10 | 1.2% 10939.77ms 0.45avg 24358x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:31:10 | 1.1% 9615.70ms 0.41avg 23401x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 03:31:10 | 1.1% 9578.56ms 0.41avg 23401x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 03:31:10 | 0.2% 1523.56ms 0.38avg 3984x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 03:31:10 | 0.0% 400.04ms 0.42avg 955x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 03:31:10 | 0.0% 332.84ms 0.35avg 955x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 03:31:10 | 0.0% 326.49ms 0.34avg 955x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 03:31:10 | 0.0% 308.47ms 5.23avg 59x -- COMMIT
Oct 4 03:31:10 | 0.0% 141.90ms 2.41avg 59x -- START TRANSACTION
Oct 4 03:31:10 | 0.0% 8.98ms 0.56avg 16x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 03:31:10 | 0.0% 6.36ms 0.40avg 16x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 03:31:23 | --- no python application found, check your startup logs for errors ---
Oct 4 03:31:23 | --- no python application found, check your startup logs for errors ---
Oct 4 03:31:26 | [SYNC] Got block 13397000 (50.3/s, 572rps 55wps) -- 868.7m remaining
Oct 4 03:31:38 | --- no python application found, check your startup logs for errors ---
Oct 4 03:31:38 | --- no python application found, check your startup logs for errors ---
Oct 4 03:31:49 | [SYNC] Got block 13398000 (43.9/s, 446rps 48wps) -- 996.39m remaining
Oct 4 03:49:03 | [SYNC] Got block 13460000 (73.3/s, 956rps 79wps) -- 582.53m remaining
Oct 4 03:49:05 | #033[93m[SQL][206ms] SELECT id FROM hive_accounts WHERE name = :n LIMIT 1#033[0m
Oct 4 03:49:09 | --- no python application found, check your startup logs for errors ---
Oct 4 03:49:09 | --- no python application found, check your startup logs for errors ---
Oct 4 03:49:16 | [SYNC] Got block 13461000 (78.1/s, 1023rps 84wps) -- 546.05m remaining
Oct 4 03:49:18 | [DEBUG] total SQL time: 900000ms
Oct 4 03:49:18 | 22.7% 204551.02ms 0.47avg 433061x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 03:49:18 | 16.2% 145517.44ms 0.59avg 244819x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 03:49:18 | 12.9% 116337.38ms 0.42avg 277188x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:49:18 | 11.4% 102882.01ms 0.42avg 244819x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:49:18 | 10.5% 94324.82ms 0.38avg 245941x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 03:49:18 | 10.4% 93267.59ms 0.45avg 205831x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:49:18 | 7.1% 63777.02ms 0.42avg 152301x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 03:49:18 | 3.3% 30024.86ms 0.46avg 64901x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 03:49:18 | 1.8% 16052.31ms 0.41avg 39015x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 03:49:18 | 1.2% 11219.44ms 0.45avg 25060x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 03:49:18 | 1.1% 10023.78ms 0.42avg 24064x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 03:49:18 | 1.1% 9950.85ms 0.41avg 24064x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 03:49:18 | 0.0% 430.49ms 0.39avg 1096x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 03:49:18 | 0.0% 409.53ms 0.41avg 995x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 03:49:18 | 0.0% 407.13ms 6.26avg 65x -- COMMIT
Oct 4 03:49:18 | 0.0% 347.48ms 0.35avg 995x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 03:49:18 | 0.0% 340.59ms 0.34avg 995x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 03:49:18 | 0.0% 112.85ms 1.74avg 65x -- START TRANSACTION
Oct 4 03:49:18 | 0.0% 13.08ms 0.50avg 26x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 03:49:18 | 0.0% 10.34ms 0.40avg 26x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 03:49:18 | #033[93m[SQL][218ms] SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p#033[0m
Oct 4 03:49:24 | --- no python application found, check your startup logs for errors ---
Oct 4 03:49:24 | --- no python application found, check your startup logs for errors ---
Oct 4 03:49:30 | [SYNC] Got block 13462000 (72.2/s, 944rps 78wps) -- 591.04m remaining
Oct 4 03:49:39 | --- no python application found, check your startup logs for errors ---
Oct 4 03:49:39 | --- no python application found, check your startup logs for errors ---
Oct 4 03:49:44 | [SYNC] Got block 13463000 (70.8/s, 710rps 78wps) -- 602.31m remaining
Oct 4 04:07:07 | [SYNC] Got block 13529000 (66.5/s, 827rps 72wps) -- 624.61m remaining
Oct 4 04:07:10 | --- no python application found, check your startup logs for errors ---
Oct 4 04:07:10 | --- no python application found, check your startup logs for errors ---
Oct 4 04:07:23 | [SYNC] Got block 13530000 (62.1/s, 646rps 68wps) -- 668.21m remaining
Oct 4 04:07:25 | --- no python application found, check your startup logs for errors ---
Oct 4 04:07:25 | --- no python application found, check your startup logs for errors ---
Oct 4 04:07:33 | [DEBUG] total SQL time: 900000ms
Oct 4 04:07:33 | 24.2% 217968.75ms 0.48avg 457341x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 04:07:33 | 15.6% 140512.43ms 0.60avg 235562x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 04:07:33 | 12.5% 112522.70ms 0.42avg 266341x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:07:33 | 11.1% 99668.16ms 0.42avg 235562x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:07:33 | 10.3% 93117.93ms 0.38avg 242071x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 04:07:33 | 9.9% 89405.76ms 0.45avg 197408x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:07:33 | 6.9% 62189.81ms 0.42avg 148098x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 04:07:33 | 3.6% 32716.84ms 0.47avg 69394x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 04:07:33 | 1.8% 15926.05ms 0.42avg 38214x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 04:07:33 | 1.3% 11270.68ms 0.44avg 25610x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:07:33 | 1.1% 10124.48ms 0.42avg 24374x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 04:07:33 | 1.1% 10100.82ms 0.41avg 24374x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 04:07:33 | 0.3% 2443.73ms 0.38avg 6449x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 04:07:33 | 0.1% 511.72ms 0.41avg 1234x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 04:07:33 | 0.1% 455.01ms 6.59avg 69x -- COMMIT
Oct 4 04:07:33 | 0.0% 440.50ms 0.36avg 1234x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 04:07:33 | 0.0% 424.36ms 0.34avg 1234x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 04:07:33 | 0.0% 135.62ms 1.97avg 69x -- START TRANSACTION
Oct 4 04:07:33 | 0.0% 38.76ms 0.64avg 61x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 04:07:33 | 0.0% 26.01ms 0.43avg 61x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 04:07:40 | --- no python application found, check your startup logs for errors ---
Oct 4 04:07:40 | --- no python application found, check your startup logs for errors ---
Oct 4 04:07:44 | [SYNC] Got block 13531000 (47.8/s, 554rps 52wps) -- 867.5m remaining
Oct 4 04:07:55 | --- no python application found, check your startup logs for errors ---
Oct 4 04:07:55 | --- no python application found, check your startup logs for errors ---
Oct 4 04:08:03 | [SYNC] Got block 13532000 (53.6/s, 603rps 58wps) -- 773.63m remaining
Oct 4 04:25:29 | [SYNC] Got block 13593000 (41.3/s, 446rps 45wps) -- 980.26m remaining
Oct 4 04:25:49 | [DEBUG] total SQL time: 900000ms
Oct 4 04:25:49 | 24.0% 215978.76ms 0.48avg 449620x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 04:25:49 | 16.0% 143644.86ms 0.60avg 239394x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 04:25:49 | 12.6% 113652.84ms 0.42avg 270572x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:25:49 | 11.3% 102076.21ms 0.43avg 239394x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:25:49 | 10.3% 93043.28ms 0.38avg 242375x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 04:25:49 | 10.1% 90809.07ms 0.45avg 200453x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:25:49 | 6.9% 62534.57ms 0.42avg 149340x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 04:25:49 | 3.3% 29452.28ms 0.46avg 63420x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 04:25:49 | 1.8% 16272.36ms 0.42avg 39015x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 04:25:49 | 1.2% 10646.36ms 0.45avg 23425x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:25:49 | 1.1% 9519.21ms 0.43avg 22008x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 04:25:49 | 1.0% 9139.53ms 0.42avg 22008x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 04:25:49 | 0.1% 1103.17ms 0.38avg 2908x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 04:25:49 | 0.1% 588.54ms 0.42avg 1416x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 04:25:49 | 0.1% 501.48ms 0.35avg 1416x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 04:25:49 | 0.1% 485.46ms 0.34avg 1416x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 04:25:49 | 0.0% 342.03ms 5.43avg 63x -- COMMIT
Oct 4 04:25:49 | 0.0% 141.47ms 2.25avg 63x -- START TRANSACTION
Oct 4 04:25:49 | 0.0% 38.81ms 0.53avg 73x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 04:25:49 | 0.0% 29.80ms 0.41avg 73x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 04:25:52 | [SYNC] Got block 13594000 (42.2/s, 462rps 46wps) -- 958.09m remaining
Oct 4 04:44:10 | [SYNC] Got block 13661000 (71.8/s, 641rps 80wps) -- 547.79m remaining
Oct 4 04:44:12 | --- no python application found, check your startup logs for errors ---
Oct 4 04:44:12 | --- no python application found, check your startup logs for errors ---
Oct 4 04:44:17 | [DEBUG] total SQL time: 900014ms
Oct 4 04:44:17 | 22.6% 203851.72ms 0.48avg 428963x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 04:44:17 | 16.1% 145025.23ms 0.60avg 243344x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 04:44:17 | 12.8% 115234.55ms 0.42avg 274021x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:44:17 | 11.4% 102486.43ms 0.42avg 243343x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:44:17 | 10.5% 94885.96ms 0.38avg 247969x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 04:44:17 | 10.3% 92616.08ms 0.45avg 204257x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:44:17 | 7.1% 64066.98ms 0.42avg 153427x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 04:44:17 | 3.5% 31465.40ms 0.46avg 67739x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 04:44:17 | 1.8% 16590.45ms 0.42avg 39149x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 04:44:17 | 1.2% 10697.13ms 0.44avg 24397x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 04:44:17 | 1.1% 9883.79ms 0.43avg 23145x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 04:44:17 | 1.1% 9497.75ms 0.41avg 23145x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 04:44:17 | 0.2% 1776.92ms 0.39avg 4562x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 04:44:17 | 0.1% 523.94ms 0.42avg 1252x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 04:44:17 | 0.0% 444.56ms 0.36avg 1252x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 04:44:17 | 0.0% 430.92ms 0.34avg 1252x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 04:44:17 | 0.0% 348.69ms 5.13avg 68x -- COMMIT
Oct 4 04:44:17 | 0.0% 128.40ms 1.89avg 68x -- START TRANSACTION
Oct 4 04:44:17 | 0.0% 33.53ms 0.53avg 63x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 04:44:17 | 0.0% 26.17ms 0.42avg 63x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 04:44:22 | [SYNC] Got block 13662000 (82.3/s, 927rps 90wps) -- 477.46m remaining
Oct 4 04:44:27 | --- no python application found, check your startup logs for errors ---
Oct 4 04:44:27 | --- no python application found, check your startup logs for errors ---
Oct 4 04:44:35 | [SYNC] Got block 13663000 (76.7/s, 664rps 86wps) -- 512.07m remaining
Oct 4 04:44:37 | #033[93m[SQL][307ms] SELECT id FROM hive_accounts WHERE name = :n LIMIT 1#033[0m
Oct 4 04:44:42 | --- no python application found, check your startup logs for errors ---
Oct 4 04:44:42 | --- no python application found, check your startup logs for errors ---
Oct 4 04:44:49 | [SYNC] Got block 13664000 (68.6/s, 826rps 74wps) -- 572.78m remaining
Oct 4 05:02:21 | [SYNC] Got block 13734000 (60.8/s, 570rps 68wps) -- 626.96m remaining
Oct 4 05:02:23 | #033[93m[SQL][325ms] INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (:fr, :fg, :at, :state) ON DUPLICATE KEY UPDATE state = :state#033[0m
Oct 4 05:02:28 | --- no python application found, check your startup logs for errors ---
Oct 4 05:02:28 | --- no python application found, check your startup logs for errors ---
Oct 4 05:02:33 | [SYNC] Got block 13735000 (81.5/s, 763rps 91wps) -- 467.32m remaining
Oct 4 05:02:35 | #033[93m[SQL][323ms] INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (:is_valid, :parent_id, :author, :permlink, :category, :community, :depth, :date)#033[0m
Oct 4 05:02:43 | --- no python application found, check your startup logs for errors ---
Oct 4 05:02:43 | --- no python application found, check your startup logs for errors ---
Oct 4 05:02:44 | [DEBUG] total SQL time: 900000ms
Oct 4 05:02:44 | 21.9% 197004.58ms 0.48avg 413357x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 05:02:44 | 16.1% 144984.89ms 0.59avg 244194x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 05:02:44 | 12.9% 116527.10ms 0.42avg 274766x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:02:44 | 11.5% 103642.32ms 0.42avg 244195x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:02:44 | 10.7% 96065.98ms 0.39avg 249467x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 05:02:44 | 10.2% 91974.32ms 0.45avg 204678x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:02:44 | 7.3% 66021.70ms 0.42avg 157823x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 05:02:44 | 3.8% 34178.04ms 0.46avg 74233x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 05:02:44 | 1.8% 16408.88ms 0.41avg 39565x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:02:44 | 1.2% 10447.85ms 0.44avg 23736x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:02:44 | 1.1% 9606.48ms 0.43avg 22533x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:02:44 | 1.0% 9289.75ms 0.41avg 22533x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 05:02:44 | 0.2% 1993.92ms 0.38avg 5225x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 05:02:44 | 0.1% 498.21ms 0.41avg 1203x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 05:02:44 | 0.0% 429.54ms 0.36avg 1203x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 05:02:44 | 0.0% 413.29ms 0.34avg 1203x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 05:02:44 | 0.0% 344.43ms 4.65avg 74x -- COMMIT
Oct 4 05:02:44 | 0.0% 119.66ms 1.62avg 74x -- START TRANSACTION
Oct 4 05:02:44 | 0.0% 29.11ms 0.61avg 48x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 05:02:44 | 0.0% 20.03ms 0.42avg 48x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 05:02:46 | [SYNC] Got block 13736000 (76.6/s, 790rps 84wps) -- 497.11m remaining
Oct 4 05:02:58 | --- no python application found, check your startup logs for errors ---
Oct 4 05:02:58 | --- no python application found, check your startup logs for errors ---
Oct 4 05:03:02 | [SYNC] Got block 13737000 (65.8/s, 594rps 74wps) -- 578.21m remaining
Oct 4 05:20:55 | [SYNC] Got block 13812000 (88.8/s, 810rps 99wps) -- 414.53m remaining
Oct 4 05:20:59 | --- no python application found, check your startup logs for errors ---
Oct 4 05:20:59 | --- no python application found, check your startup logs for errors ---
Oct 4 05:21:09 | [SYNC] Got block 13813000 (71.2/s, 597rps 80wps) -- 516.83m remaining
Oct 4 05:21:11 | [DEBUG] total SQL time: 900000ms
Oct 4 05:21:11 | 20.5% 184211.95ms 0.48avg 381481x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 05:21:11 | 16.4% 147379.47ms 0.60avg 244108x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 05:21:11 | 13.3% 119721.01ms 0.44avg 274735x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:21:11 | 11.7% 105685.21ms 0.43avg 244108x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:21:11 | 10.7% 96446.30ms 0.39avg 248892x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 05:21:11 | 10.4% 93516.21ms 0.46avg 203664x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:21:11 | 7.1% 64087.81ms 0.42avg 152039x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 05:21:11 | 4.2% 37489.96ms 0.49avg 77227x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 05:21:11 | 1.9% 17020.06ms 0.42avg 40514x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:21:11 | 1.2% 11111.36ms 0.46avg 24260x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:21:11 | 1.1% 10015.79ms 0.43avg 23205x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:21:11 | 1.1% 9698.31ms 0.42avg 23205x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 05:21:11 | 0.2% 1839.15ms 0.39avg 4713x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 05:21:11 | 0.0% 440.97ms 0.42avg 1055x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 05:21:11 | 0.0% 382.28ms 0.36avg 1055x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 05:21:11 | 0.0% 369.63ms 4.74avg 78x -- COMMIT
Oct 4 05:21:11 | 0.0% 367.04ms 0.35avg 1055x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 05:21:11 | 0.0% 135.04ms 1.73avg 78x -- START TRANSACTION
Oct 4 05:21:11 | 0.0% 53.28ms 0.75avg 71x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 05:21:11 | 0.0% 29.29ms 0.41avg 71x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 05:21:14 | --- no python application found, check your startup logs for errors ---
Oct 4 05:21:14 | --- no python application found, check your startup logs for errors ---
Oct 4 05:21:22 | [SYNC] Got block 13814000 (76.7/s, 580rps 88wps) -- 479.29m remaining
Oct 4 05:21:29 | --- no python application found, check your startup logs for errors ---
Oct 4 05:21:29 | --- no python application found, check your startup logs for errors ---
Oct 4 05:21:34 | [SYNC] Got block 13815000 (81.5/s, 689rps 92wps) -- 451.19m remaining
Oct 4 05:39:04 | [SYNC] Got block 13882000 (48.9/s, 480rps 54wps) -- 729.6m remaining
Oct 4 05:39:15 | --- no python application found, check your startup logs for errors ---
Oct 4 05:39:15 | --- no python application found, check your startup logs for errors ---
Oct 4 05:39:22 | [SYNC] Got block 13883000 (56.3/s, 511rps 63wps) -- 632.42m remaining
Oct 4 05:39:30 | --- no python application found, check your startup logs for errors ---
Oct 4 05:39:30 | --- no python application found, check your startup logs for errors ---
Oct 4 05:39:36 | [DEBUG] total SQL time: 900000ms
Oct 4 05:39:36 | 21.6% 194189.52ms 0.48avg 405918x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 05:39:36 | 16.2% 146158.09ms 0.60avg 242491x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 05:39:36 | 13.1% 117527.19ms 0.43avg 273844x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:39:36 | 11.5% 103479.77ms 0.43avg 242490x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:39:36 | 10.7% 96187.45ms 0.39avg 247770x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 05:39:36 | 10.4% 93358.52ms 0.46avg 202903x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:39:36 | 7.2% 64811.97ms 0.43avg 151902x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 05:39:36 | 3.7% 33001.24ms 0.47avg 70706x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 05:39:36 | 1.8% 16591.22ms 0.42avg 39638x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:39:36 | 1.2% 10860.84ms 0.44avg 24538x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:39:36 | 1.1% 10107.46ms 0.43avg 23285x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 05:39:36 | 1.1% 9726.41ms 0.42avg 23285x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:39:36 | 0.2% 1994.80ms 0.38avg 5228x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 05:39:36 | 0.1% 525.53ms 0.42avg 1253x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 05:39:36 | 0.1% 453.88ms 0.36avg 1253x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 05:39:36 | 0.0% 440.82ms 0.35avg 1253x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 05:39:36 | 0.0% 394.09ms 5.63avg 70x -- COMMIT
Oct 4 05:39:36 | 0.0% 143.81ms 2.05avg 70x -- START TRANSACTION
Oct 4 05:39:36 | 0.0% 26.36ms 0.52avg 51x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 05:39:36 | 0.0% 21.32ms 0.42avg 51x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 05:39:40 | [SYNC] Got block 13884000 (55.5/s, 518rps 62wps) -- 642.21m remaining
Oct 4 05:39:45 | --- no python application found, check your startup logs for errors ---
Oct 4 05:39:45 | --- no python application found, check your startup logs for errors ---
Oct 4 05:39:58 | [SYNC] Got block 13885000 (56.2/s, 529rps 62wps) -- 633.24m remaining
Oct 4 05:57:54 | [SYNC] Got block 13954000 (73.9/s, 841rps 81wps) -- 466.02m remaining
Oct 4 05:57:56 | #033[93m[SQL][355ms] SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p#033[0m
Oct 4 05:58:01 | --- no python application found, check your startup logs for errors ---
Oct 4 05:58:01 | --- no python application found, check your startup logs for errors ---
Oct 4 05:58:02 | [DEBUG] total SQL time: 900000ms
Oct 4 05:58:02 | 22.3% 200879.12ms 0.48avg 416765x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 05:58:02 | 16.1% 144742.62ms 0.60avg 239283x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 05:58:02 | 13.0% 117039.64ms 0.43avg 270727x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:58:02 | 11.5% 103332.29ms 0.43avg 239284x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:58:02 | 10.4% 93557.91ms 0.39avg 242518x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 05:58:02 | 10.1% 91226.84ms 0.46avg 199451x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:58:02 | 7.2% 64377.81ms 0.43avg 151426x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 05:58:02 | 3.8% 33810.09ms 0.48avg 70854x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 05:58:02 | 1.9% 16735.95ms 0.42avg 39881x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:58:02 | 1.3% 11301.44ms 0.46avg 24655x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 05:58:02 | 1.1% 10117.36ms 0.43avg 23504x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 05:58:02 | 1.1% 9806.44ms 0.42avg 23504x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 05:58:02 | 0.1% 1230.14ms 0.39avg 3187x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 05:58:02 | 0.1% 481.76ms 0.42avg 1151x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 05:58:02 | 0.0% 411.84ms 0.36avg 1151x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 05:58:02 | 0.0% 399.21ms 0.35avg 1151x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 05:58:02 | 0.0% 372.75ms 5.25avg 71x -- COMMIT
Oct 4 05:58:02 | 0.0% 131.05ms 1.85avg 71x -- START TRANSACTION
Oct 4 05:58:02 | 0.0% 26.02ms 0.54avg 48x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 05:58:02 | 0.0% 19.91ms 0.41avg 48x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 05:58:08 | [SYNC] Got block 13955000 (75.3/s, 859rps 82wps) -- 457.34m remaining
Oct 4 05:58:09 | #033[93m[SQL][361ms] SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p#033[0m
Oct 4 05:58:16 | --- no python application found, check your startup logs for errors ---
Oct 4 05:58:16 | --- no python application found, check your startup logs for errors ---
Oct 4 05:58:20 | [SYNC] Got block 13956000 (78.2/s, 866rps 85wps) -- 440.36m remaining
Oct 4 06:16:18 | [SYNC] Got block 14014000 (71.5/s, 583rps 81wps) -- 468.04m remaining
Oct 4 06:16:20 | #033[93m[SQL][390ms] INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (:is_valid, :parent_id, :author, :permlink, :category, :community, :depth, :date)#033[0m
Oct 4 06:16:32 | --- no python application found, check your startup logs for errors ---
Oct 4 06:16:32 | --- no python application found, check your startup logs for errors ---
Oct 4 06:16:33 | [SYNC] Got block 14015000 (67.1/s, 699rps 74wps) -- 498.32m remaining
Oct 4 06:16:35 | [DEBUG] total SQL time: 900000ms
Oct 4 06:16:35 | 22.7% 203930.09ms 0.49avg 420099x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 06:16:35 | 16.3% 146701.35ms 0.61avg 240508x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 06:16:35 | 13.0% 116846.51ms 0.43avg 270494x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:16:35 | 11.3% 101787.84ms 0.42avg 240508x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:16:35 | 10.6% 95535.65ms 0.39avg 247296x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 06:16:35 | 10.2% 91780.18ms 0.46avg 201297x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:16:35 | 7.1% 64272.72ms 0.42avg 152702x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 06:16:35 | 3.2% 28894.05ms 0.48avg 60455x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 06:16:35 | 1.8% 16538.23ms 0.42avg 39259x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 06:16:35 | 1.2% 10798.92ms 0.46avg 23347x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:16:35 | 1.0% 9273.69ms 0.42avg 22173x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 06:16:35 | 1.0% 9154.11ms 0.41avg 22173x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 06:16:35 | 0.3% 2618.90ms 0.39avg 6740x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 06:16:35 | 0.1% 511.41ms 0.44avg 1174x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 06:16:35 | 0.0% 416.25ms 0.35avg 1174x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 06:16:35 | 0.0% 410.99ms 0.35avg 1174x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 06:16:35 | 0.0% 335.62ms 5.50avg 61x -- COMMIT
Oct 4 06:16:35 | 0.0% 134.92ms 2.21avg 61x -- START TRANSACTION
Oct 4 06:16:35 | 0.0% 37.29ms 0.78avg 48x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 06:16:35 | 0.0% 21.52ms 0.45avg 48x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 06:16:47 | --- no python application found, check your startup logs for errors ---
Oct 4 06:16:47 | --- no python application found, check your startup logs for errors ---
Oct 4 06:16:49 | [SYNC] Got block 14016000 (59.7/s, 527rps 67wps) -- 560.16m remaining
Oct 4 06:34:48 | [SYNC] Got block 14082000 (49.9/s, 464rps 55wps) -- 647.07m remaining
Oct 4 06:35:03 | --- no python application found, check your startup logs for errors ---
Oct 4 06:35:03 | --- no python application found, check your startup logs for errors ---
Oct 4 06:35:07 | [SYNC] Got block 14083000 (54.1/s, 470rps 61wps) -- 597.49m remaining
Oct 4 06:35:10 | [DEBUG] total SQL time: 900000ms
Oct 4 06:35:10 | 22.6% 203010.99ms 0.48avg 424175x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 06:35:10 | 16.2% 145547.74ms 0.61avg 238477x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 06:35:10 | 12.9% 115830.51ms 0.43avg 271631x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:35:10 | 11.3% 101867.80ms 0.43avg 238477x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:35:10 | 10.6% 95038.22ms 0.39avg 243489x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 06:35:10 | 10.0% 89568.07ms 0.46avg 196049x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:35:10 | 7.1% 63587.71ms 0.43avg 148775x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 06:35:10 | 3.5% 31932.60ms 0.47avg 68013x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 06:35:10 | 2.0% 17952.23ms 0.42avg 42488x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 06:35:10 | 1.3% 11414.53ms 0.45avg 25631x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:35:10 | 1.1% 10159.82ms 0.42avg 24274x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 06:35:10 | 1.1% 10134.01ms 0.42avg 24274x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 06:35:10 | 0.2% 1903.59ms 0.38avg 4953x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 06:35:10 | 0.1% 568.63ms 0.42avg 1357x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 06:35:10 | 0.1% 487.47ms 0.36avg 1357x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 06:35:10 | 0.1% 470.05ms 0.35avg 1357x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 06:35:10 | 0.0% 335.26ms 4.93avg 68x -- COMMIT
Oct 4 06:35:10 | 0.0% 133.66ms 1.97avg 68x -- START TRANSACTION
Oct 4 06:35:10 | 0.0% 31.99ms 0.53avg 60x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 06:35:10 | 0.0% 25.51ms 0.43avg 60x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 06:35:18 | --- no python application found, check your startup logs for errors ---
Oct 4 06:35:18 | --- no python application found, check your startup logs for errors ---
Oct 4 06:35:26 | [SYNC] Got block 14084000 (51.5/s, 456rps 58wps) -- 626.49m remaining
Oct 4 06:53:21 | [SYNC] Got block 14159000 (74.6/s, 760rps 82wps) -- 415.83m remaining
Oct 4 06:53:34 | --- no python application found, check your startup logs for errors ---
Oct 4 06:53:34 | --- no python application found, check your startup logs for errors ---
Oct 4 06:53:36 | [SYNC] Got block 14160000 (69.9/s, 569rps 79wps) -- 443.95m remaining
Oct 4 06:53:40 | #033[93m[SQL][412ms] INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (:fr, :fg, :at, :state) ON DUPLICATE KEY UPDATE state = :state#033[0m
Oct 4 06:53:43 | [DEBUG] total SQL time: 900000ms
Oct 4 06:53:43 | 23.7% 213652.36ms 0.48avg 442604x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 06:53:43 | 15.6% 140757.62ms 0.61avg 232396x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 06:53:43 | 12.6% 113845.17ms 0.43avg 264041x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:53:43 | 11.3% 102056.34ms 0.44avg 232396x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:53:43 | 10.1% 91202.17ms 0.39avg 233379x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 06:53:43 | 9.8% 88610.93ms 0.46avg 192910x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:53:43 | 7.1% 63485.22ms 0.43avg 149030x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 06:53:43 | 4.1% 36452.41ms 0.47avg 77443x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 06:53:43 | 1.8% 16466.42ms 0.42avg 39533x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 06:53:43 | 1.2% 11191.66ms 0.44avg 25212x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 06:53:43 | 1.1% 10082.98ms 0.42avg 24141x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 06:53:43 | 1.1% 10047.82ms 0.42avg 24141x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 06:53:43 | 0.1% 467.66ms 0.44avg 1071x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 06:53:43 | 0.0% 383.77ms 0.36avg 1071x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 06:53:43 | 0.0% 382.06ms 4.96avg 77x -- COMMIT
Oct 4 06:53:43 | 0.0% 368.13ms 0.34avg 1071x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 06:53:43 | 0.0% 364.74ms 0.39avg 939x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 06:53:43 | 0.0% 138.65ms 1.80avg 77x -- START TRANSACTION
Oct 4 06:53:43 | 0.0% 24.62ms 0.52avg 47x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 06:53:43 | 0.0% 19.45ms 0.41avg 47x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 06:53:49 | --- no python application found, check your startup logs for errors ---
Oct 4 06:53:49 | --- no python application found, check your startup logs for errors ---
Oct 4 06:53:49 | [SYNC] Got block 14161000 (73.5/s, 782rps 81wps) -- 421.98m remaining
Oct 4 07:12:05 | [SYNC] Got block 14229000 (64.7/s, 539rps 73wps) -- 461.81m remaining
Oct 4 07:12:20 | --- no python application found, check your startup logs for errors ---
Oct 4 07:12:20 | [SYNC] Got block 14230000 (68.6/s, 723rps 75wps) -- 434.89m remaining
Oct 4 07:12:20 | --- no python application found, check your startup logs for errors ---
Oct 4 07:12:26 | [DEBUG] total SQL time: 900000ms
Oct 4 07:12:26 | 22.8% 204962.44ms 0.49avg 420980x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 07:12:26 | 16.0% 144175.58ms 0.61avg 237321x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 07:12:26 | 12.8% 115582.60ms 0.43avg 268639x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:12:26 | 11.2% 100870.40ms 0.43avg 237321x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:12:26 | 10.5% 94546.39ms 0.39avg 243520x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 07:12:26 | 10.0% 89644.39ms 0.46avg 196499x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:12:26 | 7.0% 63448.42ms 0.43avg 148540x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 07:12:26 | 3.7% 32964.79ms 0.47avg 69789x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 07:12:26 | 1.9% 17447.19ms 0.43avg 40872x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 07:12:26 | 1.3% 11788.21ms 0.46avg 25502x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:12:26 | 1.1% 10251.11ms 0.42avg 24340x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 07:12:26 | 1.1% 10138.83ms 0.42avg 24340x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 07:12:26 | 0.3% 2327.02ms 0.38avg 6152x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 07:12:26 | 0.1% 503.11ms 0.43avg 1162x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 07:12:26 | 0.0% 414.91ms 0.36avg 1162x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 07:12:26 | 0.0% 398.51ms 0.34avg 1162x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 07:12:26 | 0.0% 356.82ms 5.10avg 70x -- COMMIT
Oct 4 07:12:26 | 0.0% 133.21ms 1.90avg 70x -- START TRANSACTION
Oct 4 07:12:26 | 0.0% 25.99ms 0.53avg 49x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 07:12:26 | 0.0% 20.26ms 0.41avg 49x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 07:12:35 | --- no python application found, check your startup logs for errors ---
Oct 4 07:12:35 | [SYNC] Got block 14231000 (65.3/s, 513rps 74wps) -- 456.62m remaining
Oct 4 07:12:35 | --- no python application found, check your startup logs for errors ---
Oct 4 07:12:50 | --- no python application found, check your startup logs for errors ---
Oct 4 07:12:50 | --- no python application found, check your startup logs for errors ---
Oct 4 07:12:52 | [SYNC] Got block 14232000 (59.9/s, 510rps 67wps) -- 498.06m remaining
Oct 4 07:30:57 | [SYNC] Got block 14307000 (70.9/s, 576rps 80wps) -- 402.81m remaining
Oct 4 07:30:59 | #033[93m[SQL][431ms] SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p#033[0m
Oct 4 07:31:06 | --- no python application found, check your startup logs for errors ---
Oct 4 07:31:06 | --- no python application found, check your startup logs for errors ---
Oct 4 07:31:09 | [DEBUG] total SQL time: 900000ms
Oct 4 07:31:09 | 19.5% 175449.96ms 0.49avg 355145x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 07:31:09 | 16.9% 151977.14ms 0.63avg 242582x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 07:31:09 | 13.4% 120649.40ms 0.44avg 274661x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:31:09 | 11.8% 106647.07ms 0.44avg 242582x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:31:09 | 10.8% 96830.45ms 0.39avg 246778x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 07:31:09 | 10.3% 92681.95ms 0.46avg 200967x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:31:09 | 7.1% 63891.83ms 0.43avg 149481x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 07:31:09 | 4.2% 37668.99ms 0.49avg 77350x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 07:31:09 | 2.1% 18561.35ms 0.45avg 41703x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 07:31:09 | 1.2% 11187.99ms 0.45avg 24847x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:31:09 | 1.2% 10786.04ms 0.46avg 23672x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 07:31:09 | 1.1% 10019.09ms 0.42avg 23672x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 07:31:09 | 0.2% 1621.28ms 0.39avg 4110x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 07:31:09 | 0.1% 508.02ms 0.43avg 1175x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 07:31:09 | 0.0% 438.65ms 5.70avg 77x -- COMMIT
Oct 4 07:31:09 | 0.0% 430.65ms 0.37avg 1175x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 07:31:09 | 0.0% 409.98ms 0.35avg 1175x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 07:31:09 | 0.0% 153.38ms 1.99avg 77x -- START TRANSACTION
Oct 4 07:31:09 | 0.0% 49.85ms 0.56avg 89x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 07:31:09 | 0.0% 37.18ms 0.42avg 89x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 07:31:14 | [SYNC] Got block 14308000 (58.3/s, 716rps 63wps) -- 489.55m remaining
Oct 4 07:31:21 | --- no python application found, check your startup logs for errors ---
Oct 4 07:31:21 | --- no python application found, check your startup logs for errors ---
Oct 4 07:31:32 | Invalid community @netuoso/witnesses-in-top-100-on-old-hardfork-versions-of-steemd-and-their-voters-1501936972 -- witness watchdog
Oct 4 07:31:33 | [SYNC] Got block 14309000 (53.2/s, 343rps 62wps) -- 535.92m remaining
Oct 4 07:49:33 | [SYNC] Got block 14378000 (59.7/s, 370rps 71wps) -- 458.7m remaining
Oct 4 07:49:37 | --- no python application found, check your startup logs for errors ---
Oct 4 07:49:37 | --- no python application found, check your startup logs for errors ---
Oct 4 07:49:39 | Invalid community @mozammel14/top-interesting-bitcoin-facts-you-need-to-know-201787t223155828z -- steemQL
Oct 4 07:49:39 | Invalid community @jammey/job-needed-201787t223332511z -- steemQL
Oct 4 07:49:48 | [DEBUG] total SQL time: 900000ms
Oct 4 07:49:48 | 21.9% 197138.83ms 0.49avg 406386x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 07:49:48 | 16.1% 145026.93ms 0.61avg 238049x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 07:49:48 | 13.2% 118746.82ms 0.44avg 267993x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:49:48 | 11.3% 101787.10ms 0.43avg 238049x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:49:48 | 10.4% 93805.47ms 0.47avg 199278x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:49:48 | 10.4% 93410.43ms 0.39avg 239820x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 07:49:48 | 7.2% 64865.75ms 0.43avg 151847x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 07:49:48 | 3.8% 34395.22ms 0.48avg 71213x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 07:49:48 | 1.8% 16192.20ms 0.42avg 38825x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 07:49:48 | 1.3% 11987.65ms 0.49avg 24562x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 07:49:48 | 1.1% 10272.22ms 0.44avg 23450x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 07:49:48 | 1.1% 9868.95ms 0.42avg 23450x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 07:49:48 | 0.1% 671.74ms 0.39avg 1728x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 07:49:48 | 0.1% 479.44ms 0.43avg 1112x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 07:49:48 | 0.0% 402.56ms 0.36avg 1112x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 07:49:48 | 0.0% 382.12ms 0.34avg 1112x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 07:49:48 | 0.0% 363.30ms 5.12avg 71x -- COMMIT
Oct 4 07:49:48 | 0.0% 144.37ms 2.03avg 71x -- START TRANSACTION
Oct 4 07:49:48 | 0.0% 36.68ms 0.68avg 54x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 07:49:48 | 0.0% 22.47ms 0.42avg 54x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 07:49:50 | [SYNC] Got block 14379000 (57.5/s, 373rps 68wps) -- 475.71m remaining
Oct 4 07:49:52 | --- no python application found, check your startup logs for errors ---
Oct 4 07:49:52 | --- no python application found, check your startup logs for errors ---
Oct 4 07:50:05 | [SYNC] Got block 14380000 (68.1/s, 319rps 86wps) -- 401.65m remaining
Oct 4 08:08:31 | [SYNC] Got block 14437000 (56.4/s, 405rps 65wps) -- 467.94m remaining
Oct 4 08:08:38 | --- no python application found, check your startup logs for errors ---
Oct 4 08:08:38 | --- no python application found, check your startup logs for errors ---
Oct 4 08:08:45 | [SYNC] Got block 14438000 (73.5/s, 449rps 87wps) -- 358.73m remaining
Oct 4 08:08:53 | --- no python application found, check your startup logs for errors ---
Oct 4 08:08:53 | --- no python application found, check your startup logs for errors ---
Oct 4 08:08:54 | [DEBUG] total SQL time: 900000ms
Oct 4 08:08:54 | 33.0% 296837.08ms 0.49avg 607894x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 08:08:54 | 14.0% 125849.72ms 0.61avg 204760x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 08:08:54 | 11.0% 99396.46ms 0.43avg 230913x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:08:54 | 9.8% 88011.75ms 0.43avg 204760x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:08:54 | 9.0% 80795.77ms 0.39avg 209427x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 08:08:54 | 8.9% 80139.69ms 0.47avg 170071x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:08:54 | 6.2% 55623.42ms 0.43avg 130137x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 08:08:54 | 3.2% 29227.69ms 0.49avg 59916x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 08:08:54 | 1.6% 14666.96ms 0.42avg 34734x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 08:08:54 | 1.0% 9365.21ms 0.45avg 20712x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:08:54 | 0.9% 8281.72ms 0.42avg 19666x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 08:08:54 | 0.9% 8259.95ms 0.42avg 19666x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 08:08:54 | 0.2% 1820.54ms 0.39avg 4629x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 08:08:54 | 0.1% 460.95ms 0.44avg 1046x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 08:08:54 | 0.0% 375.92ms 0.36avg 1046x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 08:08:54 | 0.0% 365.64ms 0.35avg 1046x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 08:08:54 | 0.0% 334.20ms 5.57avg 60x -- COMMIT
Oct 4 08:08:54 | 0.0% 144.43ms 2.41avg 60x -- START TRANSACTION
Oct 4 08:08:54 | 0.0% 23.89ms 0.53avg 45x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 08:08:54 | 0.0% 19.22ms 0.43avg 45x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 08:08:56 | [SYNC] Got block 14439000 (88.1/s, 709rps 100wps) -- 299.25m remaining
Oct 4 08:09:08 | --- no python application found, check your startup logs for errors ---
Oct 4 08:09:08 | --- no python application found, check your startup logs for errors ---
Oct 4 08:09:10 | [SYNC] Got block 14440000 (73.6/s, 475rps 87wps) -- 358.12m remaining
Oct 4 08:27:52 | [SYNC] Got block 14506000 (80.2/s, 699rps 90wps) -- 314.68m remaining
Oct 4 08:27:54 | --- no python application found, check your startup logs for errors ---
Oct 4 08:27:54 | #033[93m[SQL][593ms] SELECT id FROM hive_posts WHERE author = :a AND permlink = :p#033[0m
Oct 4 08:27:54 | --- no python application found, check your startup logs for errors ---
Oct 4 08:27:59 | [DEBUG] total SQL time: 900000ms
Oct 4 08:27:59 | 29.0% 261378.13ms 0.49avg 538808x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 08:27:59 | 14.5% 130491.00ms 0.61avg 214545x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 08:27:59 | 11.7% 105732.81ms 0.44avg 241798x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:27:59 | 10.6% 95062.08ms 0.44avg 214545x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:27:59 | 9.8% 88381.76ms 0.41avg 218215x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 08:27:59 | 9.2% 83178.44ms 0.47avg 177742x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:27:59 | 6.2% 55575.12ms 0.42avg 131218x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 08:27:59 | 3.7% 33029.71ms 0.49avg 67690x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 08:27:59 | 1.7% 15687.08ms 0.43avg 36840x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 08:27:59 | 1.1% 10152.26ms 0.45avg 22575x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:27:59 | 1.0% 9122.81ms 0.42avg 21553x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 08:27:59 | 1.0% 9100.21ms 0.42avg 21553x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 08:27:59 | 0.2% 1430.73ms 0.39avg 3640x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 08:27:59 | 0.0% 448.38ms 0.44avg 1022x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 08:27:59 | 0.0% 376.73ms 0.37avg 1022x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 08:27:59 | 0.0% 352.41ms 0.34avg 1022x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 08:27:59 | 0.0% 318.99ms 4.69avg 68x -- COMMIT
Oct 4 08:27:59 | 0.0% 145.75ms 2.14avg 68x -- START TRANSACTION
Oct 4 08:27:59 | 0.0% 20.20ms 0.55avg 37x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 08:27:59 | 0.0% 15.70ms 0.42avg 37x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 08:28:07 | [SYNC] Got block 14507000 (66.4/s, 660rps 73wps) -- 380.07m remaining
Oct 4 08:28:09 | --- no python application found, check your startup logs for errors ---
Oct 4 08:28:09 | --- no python application found, check your startup logs for errors ---
Oct 4 08:28:22 | [SYNC] Got block 14508000 (66.6/s, 455rps 78wps) -- 378.42m remaining
Oct 4 08:47:00 | [SYNC] Got block 14581000 (96.5/s, 711rps 111wps) -- 248.64m remaining
Oct 4 08:47:03 | #033[93m[SQL][590ms] SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p#033[0m
Oct 4 08:47:10 | --- no python application found, check your startup logs for errors ---
Oct 4 08:47:10 | --- no python application found, check your startup logs for errors ---
Oct 4 08:47:12 | [SYNC] Got block 14582000 (85.0/s, 623rps 98wps) -- 282.03m remaining
Oct 4 08:47:14 | #033[93m[SQL][592ms] INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (:fr, :fg, :at, :state) ON DUPLICATE KEY UPDATE state = :state#033[0m
Oct 4 08:47:16 | [DEBUG] total SQL time: 900000ms
Oct 4 08:47:16 | 27.7% 248898.59ms 0.49avg 504480x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 08:47:16 | 14.9% 133733.37ms 0.62avg 217415x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 08:47:16 | 12.0% 107716.58ms 0.44avg 247158x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:47:16 | 10.5% 94666.16ms 0.44avg 217415x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:47:16 | 9.6% 86825.65ms 0.40avg 218505x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 08:47:16 | 9.3% 84134.18ms 0.48avg 175744x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:47:16 | 6.4% 57941.15ms 0.43avg 135016x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 08:47:16 | 4.0% 35927.22ms 0.47avg 75698x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 08:47:16 | 2.0% 17764.79ms 0.43avg 41724x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 08:47:16 | 1.2% 10775.18ms 0.45avg 24029x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 08:47:16 | 1.1% 9650.86ms 0.42avg 22834x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 08:47:16 | 1.1% 9635.92ms 0.42avg 22834x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 08:47:16 | 0.1% 518.63ms 0.43avg 1194x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 08:47:16 | 0.0% 431.42ms 0.36avg 1194x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 08:47:16 | 0.0% 416.46ms 0.35avg 1194x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 08:47:16 | 0.0% 395.96ms 0.38avg 1042x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 08:47:16 | 0.0% 362.81ms 4.77avg 76x -- COMMIT
Oct 4 08:47:16 | 0.0% 154.35ms 2.03avg 76x -- START TRANSACTION
Oct 4 08:47:16 | 0.0% 28.66ms 0.54avg 53x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 08:47:16 | 0.0% 22.72ms 0.43avg 53x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 08:47:22 | Invalid community @netuoso/memo-spammers-1502761002 -- spammer watchdog
Oct 4 08:47:25 | --- no python application found, check your startup logs for errors ---
Oct 4 08:47:25 | --- no python application found, check your startup logs for errors ---
Oct 4 08:47:26 | [SYNC] Got block 14583000 (73.8/s, 623rps 83wps) -- 324.53m remaining
Oct 4 09:06:06 | [SYNC] Got block 14654000 (51.7/s, 375rps 59wps) -- 440.84m remaining
Oct 4 09:06:11 | --- no python application found, check your startup logs for errors ---
Oct 4 09:06:11 | --- no python application found, check your startup logs for errors ---
Oct 4 09:06:21 | [DEBUG] total SQL time: 900000ms
Oct 4 09:06:21 | 25.3% 227568.55ms 0.49avg 461145x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 09:06:21 | 15.6% 139995.53ms 0.62avg 224282x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 09:06:21 | 12.5% 112886.10ms 0.44avg 255978x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:06:21 | 10.6% 95061.01ms 0.42avg 224282x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:06:21 | 10.2% 91368.24ms 0.40avg 229434x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 09:06:21 | 9.5% 85272.46ms 0.46avg 184041x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:06:21 | 6.6% 59739.76ms 0.43avg 139659x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 09:06:21 | 3.9% 35036.45ms 0.48avg 72679x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 09:06:21 | 2.0% 18177.64ms 0.45avg 40286x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 09:06:21 | 1.2% 10911.24ms 0.45avg 24249x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:06:21 | 1.2% 10412.07ms 0.45avg 23147x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 09:06:21 | 1.1% 9761.16ms 0.42avg 23147x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 09:06:21 | 0.2% 1987.63ms 0.39avg 5110x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 09:06:21 | 0.1% 473.89ms 0.43avg 1102x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 09:06:21 | 0.0% 400.51ms 0.36avg 1102x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 09:06:21 | 0.0% 382.38ms 0.35avg 1102x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 09:06:21 | 0.0% 366.19ms 5.09avg 72x -- COMMIT
Oct 4 09:06:21 | 0.0% 147.41ms 2.05avg 72x -- START TRANSACTION
Oct 4 09:06:21 | 0.0% 33.21ms 0.74avg 45x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 09:06:21 | 0.0% 18.85ms 0.42avg 45x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 09:06:24 | [SYNC] Got block 14655000 (56.3/s, 406rps 65wps) -- 404.16m remaining
Oct 4 09:06:26 | --- no python application found, check your startup logs for errors ---
Oct 4 09:06:26 | --- no python application found, check your startup logs for errors ---
Oct 4 09:06:41 | --- no python application found, check your startup logs for errors ---
Oct 4 09:06:41 | [SYNC] Got block 14656000 (57.9/s, 571rps 64wps) -- 392.67m remaining
Oct 4 09:25:05 | [SYNC] Got block 14740000 (73.7/s, 474rps 87wps) -- 289.75m remaining
Oct 4 09:25:07 | #033[93m[SQL][611ms] SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p#033[0m
Oct 4 09:25:12 | --- no python application found, check your startup logs for errors ---
Oct 4 09:25:12 | --- no python application found, check your startup logs for errors ---
Oct 4 09:25:16 | [DEBUG] total SQL time: 900000ms
Oct 4 09:25:16 | 21.5% 193447.52ms 0.50avg 383896x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 09:25:16 | 16.0% 143837.90ms 0.63avg 229329x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 09:25:16 | 13.1% 117627.25ms 0.45avg 261640x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:25:16 | 11.3% 101343.44ms 0.44avg 229329x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:25:16 | 10.6% 95057.81ms 0.40avg 235812x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 09:25:16 | 9.9% 88660.92ms 0.48avg 184757x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:25:16 | 7.0% 63101.99ms 0.44avg 142201x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 09:25:16 | 4.5% 40867.80ms 0.47avg 86050x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 09:25:16 | 2.1% 18895.11ms 0.42avg 44643x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 09:25:16 | 1.3% 12070.24ms 0.47avg 25688x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:25:16 | 1.1% 10282.59ms 0.42avg 24378x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 09:25:16 | 1.1% 10125.00ms 0.42avg 24378x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 09:25:16 | 0.3% 2475.39ms 0.39avg 6418x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 09:25:16 | 0.1% 554.12ms 0.42avg 1310x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 09:25:16 | 0.1% 508.76ms 5.92avg 86x -- COMMIT
Oct 4 09:25:16 | 0.1% 469.61ms 0.36avg 1310x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 09:25:16 | 0.1% 450.96ms 0.34avg 1310x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 09:25:16 | 0.0% 153.69ms 1.79avg 86x -- START TRANSACTION
Oct 4 09:25:16 | 0.0% 39.00ms 0.55avg 71x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 09:25:16 | 0.0% 31.33ms 0.44avg 71x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 09:25:17 | [SYNC] Got block 14741000 (77.4/s, 661rps 87wps) -- 275.74m remaining
Oct 4 09:25:27 | --- no python application found, check your startup logs for errors ---
Oct 4 09:25:27 | --- no python application found, check your startup logs for errors ---
Oct 4 09:25:33 | [SYNC] Got block 14742000 (63.9/s, 414rps 75wps) -- 333.76m remaining
Oct 4 09:44:20 | [SYNC] Got block 14815000 (61.2/s, 421rps 71wps) -- 328.54m remaining
Oct 4 09:44:28 | --- no python application found, check your startup logs for errors ---
Oct 4 09:44:28 | --- no python application found, check your startup logs for errors ---
Oct 4 09:44:34 | [DEBUG] total SQL time: 900000ms
Oct 4 09:44:34 | 26.9% 242443.19ms 0.49avg 499560x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 09:44:34 | 15.1% 136141.26ms 0.62avg 220840x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 09:44:34 | 12.2% 110197.93ms 0.44avg 251176x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:44:34 | 10.5% 94253.31ms 0.43avg 220840x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:44:34 | 10.1% 90752.17ms 0.40avg 226801x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 09:44:34 | 9.1% 81795.74ms 0.46avg 177925x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:44:34 | 6.4% 57576.85ms 0.42avg 136192x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 09:44:34 | 4.0% 35792.49ms 0.48avg 75064x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 09:44:34 | 2.0% 18160.09ms 0.42avg 42980x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 09:44:34 | 1.1% 10328.02ms 0.45avg 23121x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 09:44:34 | 1.0% 9231.42ms 0.42avg 22026x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 09:44:34 | 1.0% 9218.17ms 0.42avg 22026x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 09:44:34 | 0.2% 2248.18ms 0.38avg 5901x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 09:44:34 | 0.1% 459.53ms 0.42avg 1095x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 09:44:34 | 0.0% 397.48ms 5.30avg 75x -- COMMIT
Oct 4 09:44:34 | 0.0% 393.98ms 0.36avg 1095x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 09:44:34 | 0.0% 380.47ms 0.35avg 1095x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 09:44:34 | 0.0% 169.64ms 2.26avg 75x -- START TRANSACTION
Oct 4 09:44:34 | 0.0% 33.48ms 0.52avg 64x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 09:44:34 | 0.0% 26.77ms 0.42avg 64x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 09:44:35 | [SYNC] Got block 14816000 (66.3/s, 416rps 78wps) -- 302.68m remaining
Oct 4 10:03:52 | [SYNC] Got block 14883000 (58.5/s, 372rps 69wps) -- 324.46m remaining
Oct 4 10:03:59 | --- no python application found, check your startup logs for errors ---
Oct 4 10:03:59 | --- no python application found, check your startup logs for errors ---
Oct 4 10:04:01 | [DEBUG] total SQL time: 900000ms
Oct 4 10:04:01 | 30.7% 276416.06ms 0.49avg 566030x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 10:04:01 | 14.3% 128412.06ms 0.62avg 207879x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 10:04:01 | 11.7% 105183.23ms 0.45avg 235257x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 10:04:01 | 10.1% 90767.51ms 0.44avg 207879x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 10:04:01 | 9.2% 82903.69ms 0.39avg 213139x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 10:04:01 | 8.8% 79069.73ms 0.47avg 168454x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 10:04:01 | 6.2% 55948.06ms 0.43avg 129389x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 10:04:01 | 3.6% 32100.42ms 0.48avg 67422x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 10:04:01 | 1.9% 16848.56ms 0.43avg 39500x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 10:04:01 | 1.1% 10255.70ms 0.46avg 22507x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 10:04:01 | 1.0% 9081.40ms 0.43avg 21303x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 10:04:01 | 1.0% 8985.61ms 0.42avg 21303x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 10:04:01 | 0.2% 2029.84ms 0.39avg 5188x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 10:04:01 | 0.1% 507.80ms 0.42avg 1204x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 10:04:01 | 0.0% 438.37ms 0.36avg 1204x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 10:04:01 | 0.0% 416.25ms 0.35avg 1204x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 10:04:01 | 0.0% 373.88ms 5.50avg 68x -- COMMIT
Oct 4 10:04:01 | 0.0% 166.93ms 2.45avg 68x -- START TRANSACTION
Oct 4 10:04:01 | 0.0% 61.61ms 0.81avg 76x -- UPDATE hive_posts SET is_valid = :is_valid, is_deleted = 0, parent_id = :parent_id, category = :category, community = :community, depth = :depth WHERE id = :id
Oct 4 10:04:01 | 0.0% 33.82ms 0.45avg 76x -- DELETE FROM hive_feed_cache WHERE account = :account AND post_id = :id
Oct 4 10:04:12 | [SYNC] Got block 14884000 (50.2/s, 358rps 58wps) -- 377.72m remaining
Oct 4 10:04:14 | --- no python application found, check your startup logs for errors ---
Oct 4 10:04:14 | --- no python application found, check your startup logs for errors ---
Oct 4 10:04:29 | --- no python application found, check your startup logs for errors ---
Oct 4 10:04:29 | --- no python application found, check your startup logs for errors ---
Oct 4 10:04:33 | [SYNC] Got block 14885000 (48.1/s, 281rps 58wps) -- 393.25m remaining
Oct 4 11:25:04 | KeyError: 'block_id'
Oct 4 11:25:04 | [DEBUG] total SQL time: 48682ms
Oct 4 11:25:04 | 34.2% 16634.83ms 0.45avg 36881x -- INSERT IGNORE INTO hive_follows (follower, following, created_at, state) VALUES (...) ON DUPLICATE KEY UPDATE state = :state
Oct 4 11:25:04 | 13.1% 6387.25ms 0.56avg 11490x -- INSERT INTO hive_posts (is_valid, parent_id, author, permlink, category, community, depth, created_at) VALUES (...)
Oct 4 11:25:04 | 11.1% 5383.63ms 0.42avg 12955x -- SELECT id, is_deleted FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 11:25:04 | 9.8% 4748.01ms 0.41avg 11490x -- SELECT id FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 11:25:04 | 9.0% 4389.55ms 0.38avg 11652x -- SELECT id FROM hive_accounts WHERE name = :n LIMIT 1
Oct 4 11:25:04 | 8.8% 4269.60ms 0.45avg 9581x -- SELECT id, depth, category, community FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 11:25:04 | 6.1% 2965.52ms 0.41avg 7219x -- SELECT * FROM hive_communities WHERE name = :n LIMIT 1
Oct 4 11:25:04 | 3.6% 1758.91ms 0.44avg 4000x -- INSERT INTO hive_blocks (num, hash, prev, txs, created_at) VALUES (...)
Oct 4 11:25:04 | 1.6% 768.65ms 0.40avg 1909x -- INSERT INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 11:25:04 | 0.9% 441.41ms 0.43avg 1018x -- SELECT id, depth FROM hive_posts WHERE author = :a AND permlink = :p
Oct 4 11:25:04 | 0.8% 397.31ms 0.41avg 966x -- INSERT IGNORE INTO hive_feed_cache (account, post_id, created_at) VALUES (...)
Oct 4 11:25:04 | 0.8% 389.62ms 0.40avg 966x -- INSERT IGNORE INTO hive_reblogs (account, post_id, created_at) VALUES (...)
Oct 4 11:25:04 | 0.1% 60.32ms 0.37avg 163x -- INSERT INTO hive_accounts (name, created_at) VALUES (...)
Oct 4 11:25:04 | 0.0% 21.80ms 0.42avg 52x -- UPDATE hive_posts SET is_deleted = 1 WHERE id = :id
Oct 4 11:25:04 | 0.0% 20.94ms 5.23avg 4x -- COMMIT
Oct 4 11:25:04 | 0.0% 18.95ms 0.36avg 52x -- DELETE FROM hive_feed_cache WHERE post_id = :id
Oct 4 11:25:04 | 0.0% 17.63ms 0.34avg 52x -- DELETE FROM hive_posts_cache WHERE post_id = :id
Oct 4 11:25:04 | 0.0% 6.84ms 1.71avg 4x -- START TRANSACTION
Oct 4 11:25:04 | 0.0% 0.82ms 0.82avg 1x -- SHOW TABLES
Oct 4 11:25:04 | 0.0% 0.70ms 0.35avg 2x -- SELECT MAX(num) FROM hive_blocks
Oct 4 11:25:04 | 0.0% 0.37ms 0.37avg 1x -- SELECT 1 FROM hive_posts_cache LIMIT 1
Oct 4 11:25:04 | --- no python application found, check your startup logs for errors ---
Oct 4 11:25:04 | Starting hivemind...
Oct 4 11:25:04 | [INIT] *** Initial sync ***
Oct 4 11:25:04 | [SYNC] 961608 blocks to batch sync
table stats:
hive_feed_cache
works well with MEMORY engine. had to set: