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

in #utopian-io7 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

Sort:  

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.

Coin Marketplace

STEEM 0.19
TRX 0.15
JST 0.029
BTC 63126.02
ETH 2553.49
USDT 1.00
SBD 2.78