Published: 16 Jan 2018 › Updated: 16 Jan 2018

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:
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.