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

in utopian-io •  7 years ago  (edited)

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

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

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

Yes, it 's the same issue.

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]

OK, that's fine. I'll check the issue list first next time, thanks.