search

hermeznetwork / hermez-node

Hermez node Go implementation
GNU Affero General Public License v3.0
60 stars 33 forks source link

Transaction History: tx.eth_tx_hash does not exist #1134

Closed jeffprestes closed 2 years ago

jeffprestes commented 2 years ago

Summary of Bug

When request transaction history from an account the Hermez Node is returning a HTTP 500

Expected Behavior

Return transaction data

Steps to Reproduce

HTTP GET https://api.internaltestnet.hermez.io/v1/transactions-history?accountIndex=hez:HEZ:21541&order=DESC&limit=20

jeffprestes commented 2 years ago

Logs: 

[GIN] 2021/09/09 - 19:11:59 | 200 |    1.703347ms |     10.48.2.173 | GET      "/v1/exits?hezEthereumAddress=hez:0x263C3Ab7E4832eDF623fBdD66ACee71c028Ff591&onlyPendingWithdraws=true&tokenId=1&order=ASC&limit=20"
2021-09-09T19:12:00Z    WARN    api/handlers.go:20  HTTP API SQL request error: pq: column tx.eth_tx_hash does not exist
/home/ubuntu/hermez-node/db/historydb/apiqueries.go:739 github.com/hermeznetwork/hermez-node/db/historydb.(*HistoryDB).GetTxsAPI()
/home/ubuntu/hermez-node/api/txshistory.go:22 github.com/hermeznetwork/hermez-node/api.(*API).getHistoryTxs()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/context.go:165 github.com/gin-gonic/gin.(*Context).Next()
/home/ubuntu/hermez-node/metric/request.go:69 github.com/hermeznetwork/hermez-node/metric.(*Prometheus).Middleware.func1()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/context.go:165 github.com/gin-gonic/gin.(*Context).Next()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/recovery.go:99 github.com/gin-gonic/gin.CustomRecoveryWithWriter.func1()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/context.go:165 github.com/gin-gonic/gin.(*Context).Next()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/logger.go:241 github.com/gin-gonic/gin.LoggerWithConfig.func1()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/context.go:165 github.com/gin-gonic/gin.(*Context).Next()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/gin.go:489 github.com/gin-gonic/gin.(*Engine).handleHTTPRequest()
/home/ubuntu/go/pkg/mod/github.com/gin-gonic/gin@v1.7.2/gin.go:445 github.com/gin-gonic/gin.(*Engine).ServeHTTP()
/usr/local/go/src/net/http/server.go:2867 net/http.serverHandler.ServeHTTP()
/usr/local/go/src/net/http/server.go:1932 net/http.(*conn).serve()