douhu5837 2016-05-24 08:14
浏览 436

mySql Connection不断关闭

Hello guys I need some help my app keeps closing my connection and I can't seem to fix it "Error: Connection lost: The server closed the connection." I need to handle reconnecting but I don't know how.

This is my output (ERROR)

C:\Users\qw\Desktop\bot>node bot1.js
[SERVER] The Bot has logged in!
[SERVER] Loading Prices - API prices loaded!
[SERVER] The web cookies have been set!
events.js:141
      throw er; // Unhandled 'error' event
      ^

Error: Connection lost: The server closed the connection.
    at Protocol.end (C:\Users\qw\Desktop\bot
ode_modules\mysql\lib\protocol\Pro
tocol.js:103:13)
    at Socket.<anonymous> (C:\Users\qw\Desktop\bot
ode_modules\mysql\lib\Connec
tion.js:102:28)
    at emitNone (events.js:72:20)
    at Socket.emit (events.js:166:7)
    at endReadableNT (_stream_readable.js:905:12)
    at nextTickCallbackWith2Args (node.js:474:9)
    at process._tickCallback (node.js:388:17)

C:\Users\qw\Desktop\bot>pause
Press any key to continue . . .

MY CODE

var Steam = require('steam');
var SteamUser = require('steam-user');
var TradeOfferManager = require('steam-tradeoffer-manager');
var SteamTotp = require('steam-totp');
var TOTP = require('onceler').TOTP;
var request = require('request');
var SteamCommunity = require('steamcommunity');
var community = new SteamCommunity();
var fs = require('node-fs');

// GENERAL INFORMATION  
var sitepath;
sitepath = ""; 
var sitename;
sitename = ""; 

var apik = ""; 
var admin = ''; 
var botsteamid = ''; 
var identitysecret = ''; 
var sharedsecret = ''; 
var polling_interval  = 10000;
var rsecret='';
var snipetimer=5; 

var GameTime = 120; 

var p2=false; 

var playersRequired=2; 



var details = {
    "accountName"   : "",
    "password"      : "",
    "twoFactorCode" : SteamTotp.generateAuthCode(sharedsecret)
};


var client = new SteamUser();
var manager = new TradeOfferManager({
    "steam"    : client,
    "domain"   : "localhost",
    "language" : "en"
})


var mysql = require('mysql');
var sql_host="";
var sql_user="";
var sql_password="";
var sql_database="";
  • 写回答

0条回答 默认 最新

    报告相同问题?

    悬赏问题

    • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
    • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?
    • ¥15 乘性高斯噪声在深度学习网络中的应用
    • ¥15 运筹学排序问题中的在线排序
    • ¥15 关于docker部署flink集成hadoop的yarn,请教个问题 flink启动yarn-session.sh连不上hadoop,这个整了好几天一直不行,求帮忙看一下怎么解决
    • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
    • ¥15 C++ 头文件/宏冲突问题解决
    • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
    • ¥50 安卓adb backup备份子用户应用数据失败
    • ¥20 有人能用聚类分析帮我分析一下文本内容嘛