Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[venus-messager和venus-miner] 使用数据库字段太小问题 #5094

Closed
8 of 20 tasks
Tracked by #5296
cloudxin opened this issue Jul 17, 2022 · 2 comments · Fixed by ipfs-force-community/sophon-miner#117, ipfs-force-community/sophon-messager#213 or #5317
Assignees
Labels
C-enhancement Category: feature enhancement CU-chain-service Venus chain service related issues P3 Low - not important right now

Comments

@cloudxin
Copy link

Checklist

  • This is not a security-related bug/issue. If it is, please follow please follow the security policy.
  • This is not a question or a support request. If you have any lotus related questions, please ask in the venus forum.
  • This is not a new feature request. If it is, please file a feature request instead.
  • This is not an enhancement request. If it is, please file a improvement suggestion instead.
  • I have searched on the issue tracker and the venus forum, and there is no existing related issue or discussion.
  • I am running the latest release, or the most recent RC(release canadiate) for the upcoming release or the dev branch(master), or have an issue updating to any of these.
  • I did not make any code changes to venus.

Venus component

  • venus daemon - chain sync
  • venus auth - authentication
  • venus gateway - chain service gateway
  • venus miner - mining and block production
  • venus sealer/worker - sealing
  • venus sealer - proving(WindowPoSt)
  • venus market - storage deal
  • venus market - retrieval deal
  • venus market - data transfer
  • venus light-weight client
  • venus JSON-RPC API
  • venus messager - message management (mpool)
  • Other

Venus Version

venus-messager -v
venus message version v1.6.0--cf66999

venus-miner -v
venus-miner version 1.6.0'+git0e99025'

Describe the Bug

venus-messager和venus-miner使用MySQL做为后端数据库;
venus-messager----tipset_key varchar(1024)
venus-miner----parent_key varchar(1000)

字段数值过小,导致tiset消息无法及时被写入到数据库中。例如: 1990936高度有17个miner出块成功,venus-messager中这个高度的消息全部无法发送上链

Logging Information

2022/07/17 14:03:28 /venus/venus-messager/models/mysql/message.go:484 Error 1406: Data too long for column 'tipset_key' at row 1
[0.343ms] [rows:0] UPDATE `messages` SET `height`=1990936,`receipt_exit_code`='Ok(0)',`receipt_gas_used`=25571809,`receipt_return_value`='',`state`='OnChainMsg',`tipset_key`='{ bafy2bzaceda2astaml3decedukibrndxgksxp7myvtc6mnp5hykipkshzvcr2 bafy2bzacebnylsy7tdhjag7dbmffny6pdtqg22s3qlzntz5gxievdgifw6xqk bafy2bzacebchp4xvxl3ko2l6tjqzue77mow5qsi2v2jv22ugv6pxic234ht7k bafy2bzaceaxoxavoiva4pt6y34uzjssu2tdct45rol6zm2zel3no6tk7d7i5k bafy2bzacechtmfnvo3p6fexmsiw6bumtnsd2xbb6zk43gl22fb4y7negbt4p4 bafy2bzacecuvs4zydif7nyfrp6ke5qjjoo5wx3udrakvrigku4ojis3tqipys bafy2bzacea2xc2llko42k4npz63xacphwlsf4zr6jv4hdwrnuyebirhvwegik bafy2bzaceddcmyse7whyjtveypazfdccjmfhrrbm4feby6ke2wltq4ywn46iu bafy2bzacedgjh5jtdbo45va65cwkizj3af7e56hyfotways7c4wnt3m4xduce bafy2bzacecki7rq4flzjk55asltxl5wwtvpptlwb3ssi4p5nyxzo6m3cg5dcg bafy2bzaceass73jugbeiwdnzpkiir77pol2vnfowatko5blhxkisla37eieck bafy2bzaceb6zqytuxl574do77wqucaryawtr4tshiki53b3umhshs6o3zvvtu bafy2bzacecaem5gbgfojktveutwut4zsczhnm36by4e2vgxmpdzxoj53kdpyu bafy2bzacecbrpm5rryfndyhhft54bjpbibr5jbwlxprrkbr7cbvnx2skp7bik bafy2bzacecntud23p6en2vhpmz5ofwbevlh5fal57qmdga3vmhn4zesd26qj2 bafy2bzacebmwfgopsdrenhh7rl3oll676jxk4vcell5haghcvmnbfmjupnj4q bafy2bzaced5yykan5sa3h3zgdhmt4z5fwfri7pkivk66okflmrqxuk3lbhq3i }',`updated_at`='2022-07-17 14:03:28.744' WHERE unsigned_cid = 'bafy2bzacea3p7z5kxsnvcanpljvexhun42rrmo5po3hqndxrmxiqjlzd6fyzy'
ERRO[2022-07-17T14:03:28+08:00] refresh message occurs unexpected error update message receipt failed, cid:bafy2bzacea3p7z5kxsnvcanpljvexhun42rrmo5po3hqndxrmxiqjlzd6fyzy failed:Error 1406: Data too long for column 'tipset_key' at row 1 
ERRO[2022-07-17T14:03:28+08:00] listen head changes errored: reconnect check error: update message receipt failed, cid:bafy2bzacea3p7z5kxsnvcanpljvexhun42rrmo5po3hqndxrmxiqjlzd6fyzy failed:Error 1406: Data too long for column 'tipset_key' at row 1 
INFO[2022-07-17T14:03:29+08:00] restarting listenHeadChanges

Repo Steps

No response

@Fatman13 Fatman13 added the CU-chain-service Venus chain service related issues label Jul 18, 2022
@Fatman13 Fatman13 added the C-enhancement Category: feature enhancement label Jul 18, 2022
@diwufeiwen
Copy link
Contributor

@simlecode
Copy link
Collaborator

@simlecode simlecode reopened this Sep 21, 2022
Repository owner moved this from Done to In Progress in Venus Project Sep 21, 2022
@simlecode simlecode added the P3 Low - not important right now label Sep 21, 2022
Repository owner moved this from In Progress to Done in Venus Project Sep 23, 2022
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment