Cannot set headers after they are sent to the client

D:\le\node_modules\mysql\lib\protocol\Parser.js:80
        throw err; // Rethrow non-MySQL errors
        ^

Error [ERR_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the cli
ent
    at ServerResponse.setHeader (_http_outgoing.js:470:11)
    at ServerResponse.header (D:\le\node_modules\express\lib\response.js:767:
10)
    at ServerResponse.send (D:\le\node_modules\express\lib\response.js:170:12
)
    at ServerResponse.json (D:\le\node_modules\express\lib\response.js:267:15
)
    at ServerResponse.send (D:\le\node_modules\express\lib\response.js:158:21
)
    at D:\le\routes\cart.js:23:25
    at D:\le\models\cart.js:16:14
    at Query._callback (D:\le\models\db.js:44:22)
    at Query.Sequence.end (D:\le\node_modules\mysql\lib\protocol\sequences\Se
quence.js:88:24)
    at Query.ErrorPacket (D:\le\node_modules\mysql\lib\protocol\sequences\Que
ry.js:90:8)
npm ERR! code ELIFECYCLE
npm ERR! errno 1
npm ERR! letao@0.0.0 start: `node ./bin/www`
npm ERR! Exit status 1
npm ERR!
npm ERR! Failed at the letao@0.0.0 start script.
npm ERR! This is probably not a problem with npm. There is likely additional log
ging output above.

npm ERR! A complete log of this run can be found in:
npm ERR!     C:\Users\administrator\AppData\Roaming\npm-cache\_logs\2018-11-28T11_00_46_4
81Z-debug.log

D:\letao>

注意其中at Query._callback (D:\le\models\db.js:44:22)找到models\db.js44行

    pool.getConnection(function(err, connection) {
        if (err) {
            // callback(err);
            return callback(err);
        }
        connection.query(sqlStr, params, function(err, rows) {
            if (err) {
                // callback(err);
                return callback(err);
            }
            connection.release();
            callback.apply(null, arguments);//报错行44
        });
    });

在callback(err)前加return上述错误解决了。具体原因详见参考文章。

参考文章：

https://stackoverflow.com/questions/7042340/error-cant-set-headers-after-they-are-sent-to-the-client
https://cnodejs.org/topic/53774ffecbcc396349ca1155
https://cnodejs.org/topic/5635fed78c67728402553324
https://stackoverflow.com/questions/27658997/cant-set-headers-after-they-are-sent-on-express

 

转载于:https://www.cnblogs.com/codebook/p/10040501.html