Discussions

Expand all | Collapse all

mapd is crashing while decribing tables

  • 1.  mapd is crashing while decribing tables

    Posted 09-25-2019 04:03
    Hi,
    i have a table named m5d8aef2f_IntlShipments
    i tried to describe this table but its getting this error as core dumped

    ```mapdql> \d m5d8aef2f_IntlShipments
    CREATE TABLE m5d8aef2f_IntlShipments (
    WARNING: Logging before InitGoogleLogging() is written to STDERR
    F0925 16:26:49.224895 22998 ThriftTypesConvert.h:164] Check failed: false
    *** Check failure stack trace: ***
    m_acct TEXT ENCODING DICT(32)Aborted (core dumped)```

    can someone suggest on above issue
    #Core
    #Immerse
    #General


  • 2.  RE: mapd is crashing while decribing tables

    Posted 09-25-2019 05:16
    Hi,

    it's abnormal behavior, can you share the original DDLs and operation you did on the table (add, drop, rename columns) and the version of the omnisci server you are using? (have you did an upgrade after you created the table? If yes, from which version?)
    thanks in advance



  • 3.  RE: mapd is crashing while decribing tables

    Posted 09-26-2019 04:00
    Hi,
    i just created table using create command we have not done any (add,drop,rename) commands before we were using cpu 
    currently we are using  GPU 4.7.1 version 


  • 4.  RE: mapd is crashing while decribing tables

    Posted 09-26-2019 04:01
    Hi,

    Could you share the DDLs? I can't reproduce the issue


  • 5.  RE: mapd is crashing while decribing tables

    Posted 10-18-2019 05:13
    Edited by Nagulan Santhi 10-18-2019 05:15
    i have crated using mapd thrift program
    if i create in mapd core its working fine
    is there any way to describe a table other than \d in mapd client


  • 6.  RE: mapd is crashing while decribing tables

    Posted 10-18-2019 05:50
    Hi @Omnisci user,

    for debugging purpose you can run this query on the database catalog.

    so log in on the host where Omnisci server is installed, and try to run sqlite3 to check the command is installed; if it's not installed, install it with a command like that

    apt install sqlite3
    then move in the omnisci server data directory and type

    sqlite3 mapd_catalog/[name of the database where you created the table]

    then run this query

    select mapd_columns.* from mapd_columns join mapd_tables on mapd_columns.tableid = mapd_tables.tableid where mapd_tables.name='defective table';

    run the same query on the other table and compare the datatypes

    or run this one to get the differences between thrift and omnisql's created table

    select mapd_columns.name , coltype, colsubtype, coldim , colscale, is_notnull from mapd_columns join mapd_tables on mapd_columns.tableid = mapd_tables.tableid where mapd_tables.name='defective table' except select mapd_columns.name , coltype, colsubtype, coldim , colscale, is_notnull from mapd_columns join mapd_tables on mapd_columns.tableid = mapd_tables.tableid where mapd_tables.name='good table'

    If you are having trouble decoding the results post them here.