0

I am trying to send post request to update state of a record in database. I'm using pg-pool to talk to database. My code is failing in the second query where I get 'This socket has been ended by other party'. Even though I get run state update response I still get the error.

router.post('/cancel', function(reg, res, next { 
db.getclient('tasksys', function(err, client, done){
  if(err){
    done();
    return next(err);
  }
 var statement = "select * from runs";
 let runId;
 client.query (statement, function(err, result){ 
  done () ;
  if(err) 
   return next(err);
  } else{
  runId = result.rows [0][' id']
   var statement= "update runs set state 'pending' where id=$1";
   var args = [runId];
   client.query(statement, args, function(err, result){
   done()
   if(err){
   return next(err);
   }else{
    return res.send('Run state updated')
   }
  });
  }
 });
});
});

Error:This socker has been ended by other party
at Scoket.writeafterFIN [as write]
at Connection.end(...connection.js)
at Client end(...lib/client.js)
atPool.remove (...pg-pool/index.js)
at Timeout(...pg-pool/index.js)
at listenOnTimeout(<node_internal/internal/timer.js)
at processTimers(internal/timers.js){code:'EPIPE', stack:'Error:This socket has been ended by the other party'}```
ilaunchpad
  • 1,283
  • 3
  • 16
  • 32

0 Answers0