search

FlipsideCrypto / terra-models

Data models for the Terra blockchain, originally built by the MetricsDAO community.
https://flipsidecrypto.github.io/terra-models/
MIT License
0 stars 5 forks source link

Column Data Duplication in Msgs and Msg Attributes #65

Closed forgxyz closed 1 year ago

forgxyz commented 1 year ago 
20:03:10  Completed with 2 errors and 0 warnings:
20:03:10  
20:03:10  Database Error in model silver__msgs (models/silver/silver__msgs.sql)
20:03:10    100090 (42P18): Duplicate row detected during DML action
20:03:10    Row Values: ["799EEA2329AFBB88D60C4DDB1F6324F63FAA2A6E5AA3BD2B559FCA18BD326E0F-1", 2660643, 1669736863421000000, "terra", "phoenix-1", "799EEA2329AFBB88D60C4DDB1F6324F63FAA2A6E5AA3BD2B559FCA18BD326E0F", 1, "1:0", 1, "message", "���
20:03:10    attributes���:�key�action�value�$/cosmwasm.wasm.v1.MsgExecuteContract��key�module�value�wasm�B�key�sender�value�,terra1mth59aqaxrjv8lf0056vwfte7ja9glar424fdz�type�message", 1669737512322417467, 1669737515149000000]
20:03:10    compiled SQL at target/run/terra/models/silver/silver__msgs.sql
20:03:10  
20:03:10  Database Error in model silver__msg_attributes (models/silver/silver__msg_attributes.sql)
20:03:10    100090 (42P18): Duplicate row detected during DML action
20:03:10    Row Values: ["799EEA2329AFBB88D60C4DDB1F6324F63FAA2A6E5AA3BD2B559FCA18BD326E0F-2-5", 2660643, 1669736863421000000, "terra", "phoenix-1", "799EEA2329AFBB88D60C4DDB1F6324F63FAA2A6E5AA3BD2B559FCA18BD326E0F", 1, "1:0", 2, "wasm", 5, "to", "terra1mth59aqaxrjv8lf0056vwfte7ja9glar424fdz", 1669737512322417467, 1669737515149000000]
20:03:10    compiled SQL at target/run/terra/models/silver/silver__msg_attributes.sql

Discussion in Discord here

forgxyz commented 1 year ago

Solved with #71