The fields in SBDS need increase its length || SBDS 中需要扩容的字段

in #cn6 years ago (edited)

Some of the fields in SBDS do not fit part of the blockchain data because of programmatic issues or the malicious submission of data. The SBDS script to get the blockchain data and insert an error when the database, so that the insertion operation failed lead to data loss. However, data loss is not serious, because each time you restart the SBDS service, the program defaults to patching the missing data, which also results in the service not providing normal service right now, if a large amount of previous block information is lost.

So far only one way is to manually modify the field length.

I will show you my collections of these fields:

  • exchange_rate_base in sbds_tx_feed_publishes
  • min_to_receive in sbds_tx_limit_order_creates
  • request_id in sbds_tx_transfer_from_savings
  • body in sbds_tx_comments
  • raw in sbds_core_blocks

This is my SBDS service: http://mysql.steem-lightdb.com.



由于开发者的程序问题,或者有人故意提交恶意数据,导致某些 Mysql 中的字段现有的长度无法容纳区块链中的部分数据。这导致了同步脚本在获取到区块链数据后,插入数据库时有报错,进而使插入操作失败导致数据遗失。但数据遗失的影响并不是很严重,因为每次重启 SBDS 服务的时候,程序都会默认先去修补遗失数据,这也导致每次服务重启,如果有大量之前的块信息丢失的话,那么再次提供正常服务的时间就无限期的延长。

目前解决方案只有发现一个就手动修改一个。

这里将列出目前我发现的有问题的字段:

  • exchange_rate_base in sbds_tx_feed_publishes
  • min_to_receive in sbds_tx_limit_order_creates
  • request_id in sbds_tx_transfer_from_savings
  • body in sbds_tx_comments
  • raw in sbds_core_blocks

我运营的 SBDS 服务: http://mysql.steem-lightdb.com

Sort:  

Try adding #steemdev tag, that might help :)

Thank you for reminding.

I made a pull request a long time ago https://github.com/steemit/sbds/pull/81

Yes, I found that pull request before. But it's still not merged. I doubt if there are any other teams in the maintenance of this project. The master branch has not been maintained for more than 5 months.

Coin Marketplace

STEEM 0.36
TRX 0.12
JST 0.040
BTC 70744.80
ETH 3561.94
USDT 1.00
SBD 4.80