8 "github.com/jinzhu/gorm"
9 log "github.com/sirupsen/logrus"
11 "github.com/vapor/crypto/ed25519/chainkd"
12 "github.com/vapor/netsync/peers"
13 "github.com/vapor/p2p"
14 "github.com/vapor/toolbar/precog/common"
15 "github.com/vapor/toolbar/precog/config"
16 "github.com/vapor/toolbar/precog/database/orm"
19 // create or update: https://github.com/jinzhu/gorm/issues/1307
20 func (m *monitor) upSertNode(node *config.Node) error {
22 node.PublicKey = fmt.Sprintf("%v", node.XPub.PublicKey().String())
25 ormNode := &orm.Node{PublicKey: node.PublicKey}
26 if err := m.db.Where(&orm.Node{PublicKey: node.PublicKey}).First(ormNode).Error; err != nil && err != gorm.ErrRecordNotFound {
31 ormNode.Alias = node.Alias
34 ormNode.Xpub = node.XPub.String()
36 ormNode.Host = node.Host
37 ormNode.Port = node.Port
38 return m.db.Where(&orm.Node{PublicKey: ormNode.PublicKey}).
44 }).FirstOrCreate(ormNode).Error
47 func (m *monitor) processDialResults() error {
48 var ormNodes []*orm.Node
49 if err := m.db.Model(&orm.Node{}).Find(&ormNodes).Error; err != nil {
53 publicKeyMap := make(map[string]*orm.Node, len(ormNodes))
54 for _, ormNode := range ormNodes {
55 publicKeyMap[ormNode.PublicKey] = ormNode
58 connMap := make(map[string]bool, len(ormNodes))
60 for _, peer := range m.sw.GetPeers().List() {
61 xPub := &chainkd.XPub{}
62 if err := xPub.UnmarshalText([]byte(peer.Key)); err != nil {
67 publicKey := xPub.PublicKey().String()
68 connMap[publicKey] = true
69 if err := m.processConnectedPeer(publicKeyMap[publicKey], peer); err != nil {
75 for _, ormNode := range ormNodes {
76 if _, ok := connMap[ormNode.PublicKey]; ok {
80 if err := m.processOfflinePeer(ormNode); err != nil {
88 func (m *monitor) processConnectedPeer(ormNode *orm.Node, peer *p2p.Peer) error {
89 ormNodeLiveness := &orm.NodeLiveness{}
90 err := m.db.Model(&orm.NodeLiveness{}).Joins("join nodes on nodes.id = node_livenesses.node_id").
91 Where("nodes.public_key = ? AND status != ?", ormNode.PublicKey, common.NodeOfflineStatus).Last(ormNodeLiveness).Error
93 return m.db.Model(&orm.NodeLiveness{}).Where(ormNodeLiveness).UpdateColumn(&orm.NodeLiveness{
94 PingTimes: ormNodeLiveness.PingTimes + 1,
96 } else if err != gorm.ErrRecordNotFound {
100 // gorm.ErrRecordNotFound
101 return m.db.Create(&orm.NodeLiveness{
104 Status: common.NodeUnknownStatus,
108 func (m *monitor) processOfflinePeer(ormNode *orm.Node) error {
109 return m.db.Model(&orm.NodeLiveness{}).
110 Where(&orm.NodeLiveness{NodeID: ormNode.ID}).
111 UpdateColumn(&orm.NodeLiveness{
112 Status: common.NodeOfflineStatus,
116 func (m *monitor) processPeerInfos(peerInfos []*peers.PeerInfo) error {
117 for _, peerInfo := range peerInfos {
119 if err := m.processPeerInfo(dbTx, peerInfo); err != nil {
130 func (m *monitor) processPeerInfo(dbTx *gorm.DB, peerInfo *peers.PeerInfo) error {
131 xPub := &chainkd.XPub{}
132 if err := xPub.UnmarshalText([]byte(peerInfo.ID)); err != nil {
136 ormNode := &orm.Node{}
137 if err := dbTx.Model(&orm.Node{}).Where(&orm.Node{PublicKey: xPub.PublicKey().String()}).First(ormNode).Error; err != nil {
141 log.Debugf("peerInfo ping: %v", peerInfo.Ping)
142 ping, err := time.ParseDuration(peerInfo.Ping)
144 log.Debugf("parse ping time err: %v", err)
148 yesterday := now.Add(-24 * time.Hour)
149 var ormNodeLivenesses []*orm.NodeLiveness
150 if err := dbTx.Model(&orm.NodeLiveness{}).
151 Where("node_id = ? AND updated_at >= ?", ormNode.ID, yesterday).
152 Order(fmt.Sprintf("created_at %s", "DESC")).
153 Find(&ormNodeLivenesses).Error; err != nil {
157 // update latest liveness
158 latestLiveness := ormNodeLivenesses[0]
159 if latestLiveness.Status == common.NodeOfflineStatus {
160 return fmt.Errorf("node %s latest liveness status error", ormNode.PublicKey)
163 lantencyMS := ping.Nanoseconds() / 1000
165 latestLiveness.AvgLantencyMS = sql.NullInt64{
166 Int64: (latestLiveness.AvgLantencyMS.Int64*int64(latestLiveness.PongTimes) + lantencyMS) / int64(latestLiveness.PongTimes+1),
170 latestLiveness.PongTimes += 1
171 if peerInfo.Height != 0 {
172 latestLiveness.BestHeight = peerInfo.Height
174 if err := dbTx.Save(latestLiveness).Error; err != nil {
178 // calc LatestDailyUptimeMinutes
179 total := 0 * time.Minute
180 ormNodeLivenesses[0].UpdatedAt = now
181 for _, ormNodeLiveness := range ormNodeLivenesses {
182 if ormNodeLiveness.CreatedAt.Before(yesterday) {
183 ormNodeLiveness.CreatedAt = yesterday
186 total += ormNodeLiveness.UpdatedAt.Sub(ormNodeLiveness.CreatedAt)
189 return dbTx.Model(&orm.Node{}).Where(&orm.Node{PublicKey: xPub.PublicKey().String()}).
190 UpdateColumn(&orm.Node{
191 Alias: peerInfo.Moniker,
193 BestHeight: peerInfo.Height,
194 LatestDailyUptimeMinutes: uint64(total.Minutes()),
195 }).First(ormNode).Error