search

zettadb / Kunlun-XPanel

The fantastic tools used to manager
Apache License 2.0
3 stars 2 forks source link

cluster_mgr pg连接失败，导致句柄 #4

Open jd-zhang opened 2 years ago

jd-zhang commented 2 years ago

Issue migrated from trac ticket # 556

component: DBA GUI | priority: major

2022-04-06 17:42:08: barney created the issue

int PGSQL_CONN::connect(const char *database) { if(connected && db == database) return 0; else close_conn();

char conninfo[256]; sprintf(conninfo, "dbname=%s host=%s port=%d user=%s password=%s", database, ip.c_str(), port, user.c_str(), pwd.c_str());

conn = PQconnectdb(conninfo);

if (PQstatus(conn) != CONNECTION_OK) { syslog(Logger::ERROR, "Connected to pgsql fail: %s", PQerrorMessage(conn));

          PQfinish(conn);   //pg socket leak.
  return 1;

}

db = database; connected = true;

return 0; }