Thread: SQL Issue

Results 1 to 4 of 4
  1. #1 SQL Issue 
    Registered Member
    Join Date
    Mar 2012
    Posts
    710
    Thanks given
    19
    Thanks received
    5
    Rep Power
    37
    Hello,

    I keep getting this in my server CMD every now and then.
    Anyone know what it's saying?

    Code:
    java.sql.SQLException: Connections could not be acquired from the underlying database!
            at com.mchange.v2.sql.SqlUtils.toSQLException(SqlUtils.java:118)
            at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:690)
            at com.mchange.v2.c3p0.impl.AbstractPoolBackedDataSource.getConnection(AbstractPoolBackedDataSource.java:140)
            at osv.database.ConnectionPool.getConnection(ConnectionPool.java:32)
            at osv.database.Query.setupConnection(Query.java:67)
            at osv.database.Query.executeWaitOnResponse(Query.java:48)
            at osv.database.Query.run(Query.java:58)
            at java.lang.Thread.run(Unknown Source)
    Caused by: com.mchange.v2.resourcepool.CannotAcquireResourceException: A ResourcePool could not acquire a resource from its primary factory or source.
            at com.mchange.v2.resourcepool.BasicResourcePool.awaitAvailable(BasicResourcePool.java:1463)
            at com.mchange.v2.resourcepool.BasicResourcePool.prelimCheckoutResource(BasicResourcePool.java:639)
            at com.mchange.v2.resourcepool.BasicResourcePool.checkoutResource(BasicResourcePool.java:549)
            at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutAndMarkConnectionInUse(C3P0PooledConnectionPool.java:756)
            at com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool.checkoutPooledConnection(C3P0PooledConnectionPool.java:683)
            ... 6 more
    java.lang.NullPointerException
            at osv.database.Query.executeQuery(Query.java:85)
            at osv.database.Query.executeWaitOnResponse(Query.java:49)
            at osv.database.Query.run(Query.java:58)
            at java.lang.Thread.run(Unknown Source)
    Reply With Quote  
     

  2. #2  
    Registered Member
    Join Date
    Dec 2016
    Posts
    57
    Thanks given
    19
    Thanks received
    34
    Rep Power
    0
    Code:
    The database configuration details you entered are incorrect or have changed. For example, the database name or database username/password for your Confluence database. Confirm that the database username, password, and connection URL in <confluence-home>/confluence.cfg.xml are incorrect, and if not update them accordingly.
    The URL for the database is incorrect. For example, if the database connection is jdbc:mysql://yma/confluence?autoReconnect=true, does the host 'yma' exist and is the database server installed on 'yma'? Check <confluence-home>/confluence.cfg.xml to find this entry.
    The database server is not running. If your database server is down, restart it and check the logs to see why it had failed or stopped.
    The network is down (or there is a firewall in between Confluence and its database) and the connection to the database cannot be established. If your network is down, or a new firewall is installed, consult with your System Administrator for further troubleshooting.
    Your database password has expired. If your password has expired (and you will only discover this if you try to connect to your database via your database client or an external database tool such as DbVisualizer), update your password. You may want to deactivate expiring passwords for your Confluence database user to prevent the problem from happening again. Be sure to consult with your DBA about this.
    Postgres specific issue: the Postgres encryption method has been altered or changed when migrating or upgrading Confluence, the environment, etc. Check the pg_hba.conf file. If the method is set to ident change it to md5.
    MySQL specific issue: there are too many connection requests that triggered MySQL server to block Confluence from making any requests. See this MySQL article for resolution.
    Source: [Only registered and activated users can see links. ]
    Reply With Quote  
     

  3. #3  
    Registered Member
    Join Date
    Mar 2012
    Posts
    710
    Thanks given
    19
    Thanks received
    5
    Rep Power
    37
    Quote Originally Posted by FaladorPS View Post
    Code:
    The database configuration details you entered are incorrect or have changed. For example, the database name or database username/password for your Confluence database. Confirm that the database username, password, and connection URL in <confluence-home>/confluence.cfg.xml are incorrect, and if not update them accordingly.
    The URL for the database is incorrect. For example, if the database connection is jdbc:mysql://yma/confluence?autoReconnect=true, does the host 'yma' exist and is the database server installed on 'yma'? Check <confluence-home>/confluence.cfg.xml to find this entry.
    The database server is not running. If your database server is down, restart it and check the logs to see why it had failed or stopped.
    The network is down (or there is a firewall in between Confluence and its database) and the connection to the database cannot be established. If your network is down, or a new firewall is installed, consult with your System Administrator for further troubleshooting.
    Your database password has expired. If your password has expired (and you will only discover this if you try to connect to your database via your database client or an external database tool such as DbVisualizer), update your password. You may want to deactivate expiring passwords for your Confluence database user to prevent the problem from happening again. Be sure to consult with your DBA about this.
    Postgres specific issue: the Postgres encryption method has been altered or changed when migrating or upgrading Confluence, the environment, etc. Check the pg_hba.conf file. If the method is set to ident change it to md5.
    MySQL specific issue: there are too many connection requests that triggered MySQL server to block Confluence from making any requests. See this MySQL article for resolution.
    Source: [Only registered and activated users can see links. ]
    The database information is most likely incorrect, but what is calling the server to connect to that database?
    And where can I find the database information in the classes?
    Reply With Quote  
     

  4. #4  
    Registered Member
    arch337's Avatar
    Join Date
    Sep 2008
    Posts
    2,699
    Thanks given
    170
    Thanks received
    285
    Discord
    Arch337#1337
    Rep Power
    590
    Quote Originally Posted by i am here View Post
    The database information is most likely incorrect, but what is calling the server to connect to that database?
    And where can I find the database information in the classes?
    TRy look for the "com.mchange.v2.sql.SqlUtils.toSQLException" import.


    "A fail act is something you do regular, but a dumb act is something you can learn from"
    Spoiler for Problem?:
    Reply With Quote  
     


Thread Information
Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


User Tag List

Similar Threads

  1. SQL Issue
    By Kane The Whale in forum Help
    Replies: 4
    Last Post: 12-09-2016, 02:35 PM
  2. Sql Issues
    By Antwharn in forum Help
    Replies: 4
    Last Post: 09-04-2015, 12:26 PM
  3. sql issue
    By glaiven-rsps in forum Help
    Replies: 5
    Last Post: 01-21-2015, 12:32 PM
  4. SQL Issue
    By nathanrr44 in forum Help
    Replies: 5
    Last Post: 03-27-2011, 08:26 PM
  5. Sql Scape!
    By meiscooldude in forum Downloads
    Replies: 33
    Last Post: 09-16-2008, 03:24 AM
Posting Permissions
  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •