I found this error in my running sbds service.
ame": "INFO", "asctime": "2018-01-16T02:39:32.1516070372GMT", "filename": "__init__.py", "module": "__init__", "funcName": "adaptive_insert", "lineno": 158, "msecs": 464.51401710510254, "message": "safe_insert_many failed (_mysql_exceptions.DataError) (1406, \"Data too long for column 'raw' at row 1\") [SQL: 'INSERT INTO sbds_core_blocks (raw, block_num, previous, timestamp, witness, witness_signature, transaction_merkle_root) VALUES (%s, %s, %s, %s, %s, %s, %s)'] [parameters: (('{\"block_id\": \"002fae785f5f64565adcf462704774b4f763cbd8\", \"witness_signature\": \"1f37122ed3c6337c32a07534cf2269b1fe1a836439a2ea150cede035dcef2bfbc468ac ... (1316 characters truncated) ... ay\", \"transaction_merkle_root\": \"40c884eb786a3f9874f52bb75f6dfa6f2c5419c4\", \"extensions\": [], \"previous\": \"002fae772b9afaecd25b777f32408feab15f2af6\"}', 3124856, '002fae772b9afaecd25b777f32408feab15f2af6', datetime.datetime(2016, 7, 12, 5, 47, 12), 'jabbasteem', '1f37122ed3c6337c32a07534cf2269b1fe1a836439a2ea150cede035dcef2bfbc468aca6762c1ae7a3a0e40c8e40265b488f00014e45abb50a0ba2fb0f87c1deef', '40c884eb786a3f9874f52bb75f6dfa6f2c5419c4'), ('{\"block_id\": \"002fae7936d5d32ee9464b73e20dba07dae733c0\", \"witness_signature\": \"1f5f96c865d2ddf0d7fe236a926da1e5d78eb0abd3019d9f7a628db2903f78e2685f8e ... (691 characters truncated) ... he\", \"transaction_merkle_root\": \"7bdb35f62ec10bfb93d54c9fe6dbb54353c04136\", \"extensions\": [], \"previous\": \"002fae785f5f64565adcf462704774b4f763cbd8\"}', 3124857, '002fae785f5f64565adcf462704774b4f763cbd8', datetime.datetime(2016, 7, 12, 5, 47, 15), 'kushed', '1f5f96c865d2ddf0d7fe236a926da1e5d78eb0abd3019d9f7a628db2903f78e2685f8e1855450a52cfc1a31069aba12bbf34e244bd828225ccd64fb23a10486081', '7bdb35f62ec10bfb93d54c9fe6dbb54353c04136'), ('{\"block_id\": \"002fae7a95d9d74350478637fd9580e4a4933061\", \"witness_signature\": \"1f19cf4b5502b2afc2a320d60e7766b2e7788025a356a43398c91f62a7e4301e0d295a ... (238 characters truncated) ... KQ\", \"transaction_merkle_root\": \"0000000000000000000000000000000000000000\", \"extensions\": [], \"previous\": \"002fae7936d5d32ee9464b73e20dba07dae733c0\"}', 3124858, '002fae7936d5d32ee9464b73e20dba07dae733c0', datetime.datetime(2016, 7, 12, 5, 47, 18), 'smooth.witness', '1f19cf4b5502b2afc2a320d60e7766b2e7788025a356a43398c91f62a7e4301e0d295a24ac9fbb41dfb85f51bd4d43d75cfc131594492230eacad13744d1a09d84', '0000000000000000000000000000000000000000'), ('{\"block_id\": \"002fae7d5b18111231f7d39893d67e5a24be16e1\", \"witness_signature\": \"1f5e89d4c057312cb089aee1065b8acde587d6511b887e6192e53f48e0ec652ea83ffd ... (2097 characters truncated) ... Ez\", \"transaction_merkle_root\": \"663930673c56ac64b80b87ef349e16b37ef547a7\", \"extensions\": [], \"previous\": \"002fae7c822677276c04d1e9f496a2e4dbc39a54\"}', 3124861, '002fae7c822677276c04d1e9f496a2e4dbc39a54', datetime.datetime(2016, 7, 12, 5, 47, 27), 'blocktrades', '1f5e89d4c057312cb089aee1065b8acde587d6511b887e6192e53f48e0ec652ea83ffd14e930ed7e97108d9570c3eff4edc50d94ada5206cda18f72a8d999bdbf5', '663930673c56ac64b80b87ef349e16b37ef547a7'), ('{\"block_id\": \"002fae7e8c693a8afdb1ef2410419aaa1c8663d1\", \"witness_signature\": \"1f6bc0d258712b77dc18106d3b7aab62cbe94ea1d9cb3362307aa2e0a48762d17e1cd2 ... (2132 characters truncated) ... S2\", \"transaction_merkle_root\": \"04a9c191f56f3475e5da6211c2d6a38dfcf70dfe\", \"extensions\": [], \"previous\": \"002fae7d5b18111231f7d39893d67e5a24be16e1\"}', 3124862, '002fae7d5b18111231f7d39893d67e5a24be16e1', datetime.datetime(2016, 7, 12, 5, 47, 30), 'steemed', '1f6bc0d258712b77dc18106d3b7aab62cbe94ea1d9cb3362307aa2e0a48762d17e1cd2c0bc4494fde98cdf454e16b9ce9c28a67eca3aa57054c7ac1408c45e4d20', '04a9c191f56f3475e5da6211c2d6a38dfcf70dfe'), ('{\"block_id\": \"002fae80c00760da4df8f7b1177dda860a0e5bbb\", \"witness_signature\": \"1f79fca46bc31cb51d83480539b94977488284387f9ba43867defb1f97efd159ca2916 ... (1557 characters truncated) ... S2\", \"transaction_merkle_root\": \"2d43d430eed0deaf56ad558cb749687e7f0eebda\", \"extensions\": [], \"previous\": \"002fae7f00051538487fcab6b72a834bbece4b35\"}', 3124864, '002fae7f00051538487fcab6b72a834bbece4b35', datetime.datetime(2016, 7, 12, 5, 47, 36), 'steemed', '1f79fca46bc31cb51d83480539b94977488284387f9ba43867defb1f97efd159ca2916d1e420a669584b576bb53093faf28678fc050067adca2322d72d29f90c75', '2d43d430eed0deaf56ad558cb749687e7f0eebda'), ('{\"block_id\": \"002fae81cadce32f7ac9496d8e5f8480c25cc27a\", \"witness_signature\": \"2072e81b772439104da084556ae91cce771f3d654f08391274e4b2c1fe8fc658364bf5 ... (2970 characters truncated) ... EP\", \"transaction_merkle_root\": \"89ac8cde91fb5599bbd64ec13ab9dd1c38b79d5a\", \"extensions\": [], \"previous\": \"002fae80c00760da4df8f7b1177dda860a0e5bbb\"}', 3124865, '002fae80c00760da4df8f7b1177dda860a0e5bbb', datetime.datetime(2016, 7, 12, 5, 47, 39), 'steempty', '2072e81b772439104da084556ae91cce771f3d654f08391274e4b2c1fe8fc658364bf5d716d4e1ce7afe4bff14b2e46daa37497ba591b913b8793929c365bbc97e', '89ac8cde91fb5599bbd64ec13ab9dd1c38b79d5a'), ('{\"block_id\": \"002fae8212b170ab87f20e4efcf4d2a14483a75f\", \"witness_signature\": \"20382b9a2272079eadb673dc1bfe20b811b7ec784b71808ba14932b160d2393d726d4a ... (230 characters truncated) ... he\", \"transaction_merkle_root\": \"0000000000000000000000000000000000000000\", \"extensions\": [], \"previous\": \"002fae81cadce32f7ac9496d8e5f8480c25cc27a\"}', 3124866, '002fae81cadce32f7ac9496d8e5f8480c25cc27a', datetime.datetime(2016, 7, 12, 5, 47, 42), 'kushed', '20382b9a2272079eadb673dc1bfe20b811b7ec784b71808ba14932b160d2393d726d4ad6e25aa7df80fecc887a0c69d12afb279dca8b27719d7198b1fa31c11898', '0000000000000000000000000000000000000000') ... displaying 10 of 1000 total bound parameter sets ... ('{\"block_id\": \"002fb25dcd53bcf2afb330dedd7675ac6b279205\", \"witness_signature\": \"202904e6a5f9a4da65c1decae04809540dbc1a8fc65ddbb78328cad9842b194e83699b ... (1181 characters truncated) ... S2\", \"transaction_merkle_root\": \"21a40a32a24d5e87c082321163b49961235d901c\", \"extensions\": [], \"previous\": \"002fb25c4cf9c79a30691db7e023dc19bff1fc64\"}', 3125853, '002fb25c4cf9c79a30691db7e023dc19bff1fc64', datetime.datetime(2016, 7, 12, 6, 37, 18), 'steemed', '202904e6a5f9a4da65c1decae04809540dbc1a8fc65ddbb78328cad9842b194e83699befde1a2217b494fbb0a2eee277f58ebaf33968b88848dfa7af948ff63de3', '21a40a32a24d5e87c082321163b49961235d901c'), ('{\"block_id\": \"002fb25fbfcef001f8cb933cf68c23a1760c9bc2\", \"witness_signature\": \"1f5995f8f14dcf651c30a9594659511a31c6c7132dd83c58e87fbf69ce1117b58c65da ... (234 characters truncated) ... n3\", \"transaction_merkle_root\": \"0000000000000000000000000000000000000000\", \"extensions\": [], \"previous\": \"002fb25ebf9ebee4e00546ca762c32f76c0b73f3\"}', 3125855, '002fb25ebf9ebee4e00546ca762c32f76c0b73f3', datetime.datetime(2016, 7, 12, 6, 37, 24), 'badger3165', '1f5995f8f14dcf651c30a9594659511a31c6c7132dd83c58e87fbf69ce1117b58c65da7e311f255929259d7801661283986274670f621955a438e541574444d5d0', '0000000000000000000000000000000000000000'))]", "name": "sbds.storages.db", "pathname": "/usr/local/lib/python3.5/dist-packages/sbds/storages/db/__init__.py", "process": 37, "processName": "ForkPoolWorker-1", "threadName": "MainThread"}
The service got an error that is Data too long for column 'raw'
. I think the raw
column in sbds_core_blocks
table should change text
type to mediumtext
type or longtext
type.
There is also another column body
and json_metadata
in sbds_tx_comments
table to edit.
Posted on Utopian.io - Rewarding Open Source Contributors
Welcome to utopian and thanks for contributing.
Do you mean this here
Seems like this issue got fixed much before.
You can contact us on Discord.
utopian-moderator
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Yes, it 's the same issue.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Your contribution cannot be approved because it is a duplicate. It is very similar to a contribution that was already accepted here.
You can contact us on Discord.
[utopian-moderator]
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
OK, that's fine. I'll check the issue list first next time, thanks.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit