Forum Stats

  • 3,851,407 Users
  • 2,263,973 Discussions
  • 7,904,699 Comments

Discussions

297 - Database access problem. Killing off all remaining connections in the connection pool. SQL Sta

user10361386
user10361386 Member Posts: 3
edited Jun 13, 2016 8:33AM in MySQL Community Space

I am getting below error with MYSQL 5.6.25, i did google it but none of them fixes this error.

When we are using the hostname everything works fine but as soon as we use the VIP gets the below error,Can any one share if someone was able to resolve this error?

297 - Database access problem. Killing off all remaining connections in the connection pool. SQL State = 08S01

ERROR] 16-02-05 21:12:00 [JdbcDBImpl] 204 - insert sql fail:insert into DumpFlag(TaskId,JobName,TableName,StartTime,EndTime,Flag) VALUES (?,?,?,?,?,?)  ON DUPLICATE KEY UPDATE TaskId=VALUES(TaskId),StartTime=VALUES(StartTime),EndTime=VALUES(EndTime),Flag=VALUES(Flag)

[ERROR] 16-02-05 21:12:00 [JdbcDBImpl] 204 - insert sql fail:insert into DumpFlag(TaskId,JobName,TableName,StartTime,EndTime,Flag) VALUES (?,?,?,?,?,?)  ON DUPLICATE KEY UPDATE TaskId=VALUES(TaskId),StartTime=VALUES(StartTime),EndTime=VALUES(EndTime),Flag=VALUES(Flag)

[ERROR] 16-02-05 21:12:00 [JdbcDBImpl] 205 - insert sql fail:Could not retrieve transation read-only status server

[ERROR] 16-02-05 21:12:00 [JdbcDBImpl] 205 - insert sql fail:Could not retrieve transation read-only status server

[INFO] 16-02-05 21:12:00 [FeedLoader] 1076 - loadAllFundBaseInfoToDB begin!

[INFO] 16-02-05 21:12:00 [FeedLoader] 1015 - loadAllStockBaseInfo begin!

[ERROR] 16-02-05 21:12:00 [ConnectionHandle] 297 - Database access problem. Killing off all remaining connections in the connection pool. SQL State = 08S01

Answers