我有一个使用将数据加载到amazon RDS PostgreSQL实例中的node.js ETL系统。突然之间,我开始在向数据库中插入记录时看到随机的超时错误:
TimeoutError: ResourceRequest timed out
at ResourceRequest._fireTimeout (/home/ubuntu/myproject/etl/node_modules/generic-pool/lib/ResourceRequest.js:62:17)
at Timeout.bound (/home/ubuntu/myproject/etl/node_modul
我写了一个节点程序,批量插入到数据库中,并为每个完成的插入做一个控制台日志。
function insert(){
var sql = "insert into todo (user, content) values (xx, xx);" +
"insert into todo (user, content) values (xx, xx);" +
"insert into todo (user, content) values (xx, xx);" +
(..
我目前正在通过以下方式将我的ec2服务器连接到rds:
self.conn = MySQLdb.connect (
host = settings.DATABASES['default']['HOST'],
port = 3306,
user = settings.DATABASES['default']['USER'],
p