1. Guest, as per the stickied thread, this forum has not been in use since 2014. All bugs and feature requests should be posted to JIRA.

java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned.

Discussion in 'Bugs & Feature Requests' started by SexyMime, Aug 31, 2013.

Thread Status:
Not open for further replies.
  1. Any idea?


    Code (Text):

    java.sql.SQLException: Unsuccessfully waited [1000] millis for a connection to be returned. No connections are free. You need to Increase the max connections of [250] or look for a connection pool leak using datasource.xxx.capturestacktrace=true
     
  2. joehot200

    Supporter

     
  3. Already tried this and rebooted MYSQL...
     
  4. jtaylor69

    jtaylor69 Retired Moderator
    Retired

    and this?
     
  5. How can I locate the cause?
     
  6. jtaylor69

    jtaylor69 Retired Moderator
    Retired

    Using Scoreboard stats?
     
  7. yep
     
  8. jtaylor69

    jtaylor69 Retired Moderator
    Retired

    That uses SQLite and so therefore it will be a SQLite problem.
    Also the plugin has often, in my case, been the root of problems; shutdowns, lots of disk usage, errors etc.
    I removed it and never had an issue ever since.
     
  9. How can I increase max connections with SQLite
     
  10. jtaylor69

    jtaylor69 Retired Moderator
    Retired

  11. The bigger problem is that 1 plugin is opening that many connections. 1 plugin only needs 1 connection. Not 1k.
     
  12. md_5

    Administrator Developer

    STOP OPENING STUFF AS A SPIGOT BUG WHEN IT IS CLEARLY NOT, SPIGOT DOES NOT EVEN USE SQL, HOW CAN I GET THIS MESSAGE ACROSS TO YOU, PLEASE USE THE APPROPRIATE PLUGIN HELP SUBFORUMS, OR YOU WILL GET BANNED FROM REPORTING BUGS FULLSTOP, I DONT THINK YOU HAVE EVER REPORTED A LEGIT BUG.

    /THREAD
     
    • Agree Agree x 3
Thread Status:
Not open for further replies.