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


#1

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

@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?