ETY001 avatar

Data too long for column 'raw' when insert into sbds_core_blocks table

ety001

Published: 16 Jan 2018 › Updated: 16 Jan 2018Data too long for column 'raw' when insert into sbds_core_blocks table

Data too long for column 'raw' when insert into sbds_core_blocks table

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

Leave Data too long for column 'raw' when insert into sbds_core_blocks table to:

Written by

A developer, freelancer, witness

Read more #utopian-io posts


Best Posts From ETY001

We have not curated any of ety001's posts yet. But you can encourage our curation team to review posts by visiting them regularly and by referring other readers. Because we give priority to frequently read content.

More Posts From ETY001