Discussions

Expand all | Collapse all

Thrift error: write() send(): Broken pipe

  • 1.  Thrift error: write() send(): Broken pipe

    Posted 02-14-2019 05:53

    Hello team,

    We are facing below issue when executing a query in mapd db

    query:


    SELECT cast(date_trunc(day, cdr_date) as date),SID,CID,RAT,APN,SGSN_ADDR,PNAME,RATE_GRP,STAT_COMMT,IPCG,CHARGE_RID, SUM(CASE when CRID_CONF_BYTES in (’-1’) then 0 else CRID_CONF_BYTES end),PID,PARENT_MSISDN,A.CHARGE_RULE_NAME,A.QOS,b.package_name FROM WDBS_package_mast b,wdbs_Cdr c,wdbs_charging_rules a WHERE MSISDN = ‘*******’ AND CDR_DATE between ‘2019-01-02 00:00’ AND ‘2019-01-31 23:00’ AND CHARGE_RID NOT IN (’-1’) and b.package_id=c.pid and c.CHARGE_RID=a.charge_rule_id GROUP BY cast(date_trunc(day, cdr_date) as date),SID,CID,RAT,APN,SGSN_ADDR,PNAME,RATE_GRP,STAT_COMMT,IPCG,CHARGE_RID,PID,PARENT_MSISDN,A.CHARGE_RULE_NAME,A.QOS,b.package_name order by cast(date_trunc(day, cdr_date) as date),SID,PNAME,RATE_GRP,CHARGE_RID,PID;

    response:


    Thrift: Thu Feb 14 22:13:54 2019 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe
    Thrift error: write() send(): Broken pipe
    Thrift connection error: write() send(): Broken pipe
    Retrying connection
    Thrift: Thu Feb 14 22:13:56 2019 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe
    Thrift error: write() send(): Broken pipe
    Thrift connection error: write() send(): Broken pipe
    Retrying connection
    Thrift: Thu Feb 14 22:14:00 2019 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe
    Thrift error: write() send(): Broken pipe
    Thrift connection error: write() send(): Broken pipe
    Retrying connection
    Thrift: Thu Feb 14 22:14:08 2019 TSocket::write_partial() send() <Host: localhost Port: 9091>Broken pipe
    Thrift error: write() send(): Broken pipe
    Thrift connection error: write() send(): Broken pipe
    Retrying connection
    Cannot connect to MapD Server.


    kindly assist,

    pranav km



  • 2.  RE: Thrift error: write() send(): Broken pipe

    Posted 02-15-2019 12:33

    @pranav i don’t know if it’s relevant, but for troubleshooting, can you tell me more about your environment and your version? This looks like a local installation, right?



  • 3.  RE: Thrift error: write() send(): Broken pipe

    Posted 02-18-2019 02:11

    hello Eric,

    Yes, you are correct, as of now it is a local installation. Or in other words, we are undergoing a testing process to introduce the mapdb to production system.

    we are using the github version of omnisci. (mapd-4.4.0dev_20181123_-1.x86_64).

    1. linux version : CentOS Linux release 7.5.1804 (Core)
      2: disk size 200GB
    2. RAM :25 GB

    kindly let me know if any specific informations are needed.

    regards
    pranav km