geomesa

How to restore geomesa index table in accumulo?


In my accumulo db 2 index tables are lost: ...02726, ...02727. My namespace does not have it but in geomesa tables they are present. Why this can happen and how to restore them? I can't get data through the util

geomesa-accumulo export

My accumulo data

root@accumulo myNamespace.geomesa> tables -ns myNamespace
geomesa
geomesa_SignalBuilder_attr_cam_time_v8_02712
geomesa_SignalBuilder_attr_cam_time_v8_02716
geomesa_SignalBuilder_attr_cam_time_v8_02723
geomesa_SignalBuilder_attr_cam_time_v8_02724
geomesa_SignalBuilder_attr_cam_time_v8_02725
geomesa_SignalBuilder_z2_geo_v5_02712
geomesa_SignalBuilder_z2_geo_v5_02716
geomesa_SignalBuilder_z2_geo_v5_02723
geomesa_SignalBuilder_z2_geo_v5_02724
geomesa_SignalBuilder_z2_geo_v5_02725
geomesa_SignalBuilder_z3_geo_time_v7_02712
geomesa_SignalBuilder_z3_geo_time_v7_02716
geomesa_SignalBuilder_z3_geo_time_v7_02723
geomesa_SignalBuilder_z3_geo_time_v7_02724
geomesa_SignalBuilder_z3_geo_time_v7_02725
geomesa_stats
root@accumulo myNamespace.geomesa> 
root@accumulo myNamespace.geomesa> 
root@accumulo myNamespace.geomesa> 
root@accumulo myNamespace.geomesa> table myNamespace.geomesa
root@accumulo myNamespace.geomesa> scan
SignalBuilder~attributes : []    *geo:Point,time:Date,cam:String:keep-stats=true,imei:String,dir:Double,alt:Double,vlc:Double,sl:Integer,ds:Integer,dir_y:Double,poi_azimuth_x:Double,poi_azimuth_y:Double;geomesa.stats.enable='true',geomesa.feature.expiry='time(30 days)',geomesa.z.splits='4',geomesa.table.partition='time',geomesa.index.dtg='time',geomesa.attr.splits='4',geomesa.indices='z3:7:3:geo:time,z2:5:3:geo,attr:8:3:cam:time',geomesa.z3.interval='week'
SignalBuilder~stats-date : []    2022-04-11T10:11:14.134Z
SignalBuilder~table.attr.cam.time.v8.02712 : []    myNamespace.geomesa_SignalBuilder_attr_cam_time_v8_02712
SignalBuilder~table.attr.cam.time.v8.02716 : []    myNamespace.geomesa_SignalBuilder_attr_cam_time_v8_02716
SignalBuilder~table.attr.cam.time.v8.02723 : []    myNamespace.geomesa_SignalBuilder_attr_cam_time_v8_02723
SignalBuilder~table.attr.cam.time.v8.02724 : []    myNamespace.geomesa_SignalBuilder_attr_cam_time_v8_02724
SignalBuilder~table.attr.cam.time.v8.02725 : []    myNamespace.geomesa_SignalBuilder_attr_cam_time_v8_02725
SignalBuilder~table.attr.cam.time.v8.02726 : []    myNamespace.geomesa_SignalBuilder_attr_cam_time_v8_02726
SignalBuilder~table.attr.cam.time.v8.02727 : []    myNamespace.geomesa_SignalBuilder_attr_cam_time_v8_02727
SignalBuilder~table.z2.geo.v5.02712 : []    myNamespace.geomesa_SignalBuilder_z2_geo_v5_02712
SignalBuilder~table.z2.geo.v5.02716 : []    myNamespace.geomesa_SignalBuilder_z2_geo_v5_02716
SignalBuilder~table.z2.geo.v5.02723 : []    myNamespace.geomesa_SignalBuilder_z2_geo_v5_02723
SignalBuilder~table.z2.geo.v5.02724 : []    myNamespace.geomesa_SignalBuilder_z2_geo_v5_02724
SignalBuilder~table.z2.geo.v5.02725 : []    myNamespace.geomesa_SignalBuilder_z2_geo_v5_02725
SignalBuilder~table.z2.geo.v5.02726 : []    myNamespace.geomesa_SignalBuilder_z2_geo_v5_02726
SignalBuilder~table.z2.geo.v5.02727 : []    myNamespace.geomesa_SignalBuilder_z2_geo_v5_02727
SignalBuilder~table.z3.geo.time.v7.02712 : []    myNamespace.geomesa_SignalBuilder_z3_geo_time_v7_02712
SignalBuilder~table.z3.geo.time.v7.02716 : []    myNamespace.geomesa_SignalBuilder_z3_geo_time_v7_02716
SignalBuilder~table.z3.geo.time.v7.02723 : []    myNamespace.geomesa_SignalBuilder_z3_geo_time_v7_02723
SignalBuilder~table.z3.geo.time.v7.02724 : []    myNamespace.geomesa_SignalBuilder_z3_geo_time_v7_02724
SignalBuilder~table.z3.geo.time.v7.02725 : []    myNamespace.geomesa_SignalBuilder_z3_geo_time_v7_02725
SignalBuilder~table.z3.geo.time.v7.02726 : []    myNamespace.geomesa_SignalBuilder_z3_geo_time_v7_02726
SignalBuilder~table.z3.geo.time.v7.02727 : []    myNamespace.geomesa_SignalBuilder_z3_geo_time_v7_02727
root@accumulo myNamespace.geomesa> 

Solution

  • It's hard to say why the tables are not there, I would guess something went wrong with your cluster as GeoMesa does not delete tables AFAIK.

    To restore the export functionality, delete the references to the missing tables out of your catalog through the Accumulo shell, or create new empty tables that match the expected names.