Layer7 API Management

  • 1.  Exceptions in SSG Logs

    Posted Oct 31, 2016 04:31 AM

    Hi All,

     

    We have noticed below SQL exceptions in our gateway ssg logs. Do we need to take any further action to resolve below exception or shall we ignore.

     

    Could you please do let me know why these are generating if possible.

     

    org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.goid as goid33_0_, this_.propKey as propKey33_0_, this_.version as version33_0_, this_.properties as properties33_0_, this_.propValue as propValue33_0_ from cluster_properties this_]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
    java.lang.RuntimeException: Error saving MetricsBin
    Caused by: org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.goid as goid81_0_, this_.nodeid as nodeid81_0_, this_.end_time as end3_81_0_, this_.interval_size as interval4_81_0_, this_.back_max as back5_81_0_, this_.front_max as front6_81_0_, this_.back_min as back7_81_0_, this_.front_min as front8_81_0_, this_.attempted as attempted81_0_, this_.authorized as authorized81_0_, this_.completed as completed81_0_, this_.period_start as period12_81_0_, this_.resolution as resolution81_0_, this_.published_service_goid as published14_81_0_, this_.service_state as service15_81_0_, this_.start_time as start16_81_0_, this_.back_sum as back17_81_0_, this_.front_sum as front18_81_0_ from service_metrics this_ where this_.nodeid=? and this_.published_service_goid=? and this_.resolution=? and this_.period_start=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
    org.springframework.jdbc.UncategorizedSQLException: StatementCallback; uncategorized SQLException for SQL [SELECT nodeid, touched_time, version from cluster_master]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database!
    com.l7tech.objectmodel.FindException: org.hibernate.exception.GenericJDBCException: could not execute query
    Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    com.l7tech.objectmodel.FindException: org.hibernate.exception.GenericJDBCException: could not execute query
    Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    com.l7tech.objectmodel.FindException: org.hibernate.exception.GenericJDBCException: could not execute query
    Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
    at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:140)
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:128)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select messagecon0_.goid as goid27_, messagecon0_.create_time as create2_27_, messagecon0_.digested as digested27_, messagecon0_.mapping1_key as mapping4_27_, messagecon0_.mapping1_type as mapping5_27_, messagecon0_.mapping2_key as mapping6_27_, messagecon0_.mapping2_type as mapping7_27_, messagecon0_.mapping3_key as mapping8_27_, messagecon0_.mapping3_type as mapping9_27_, messagecon0_.mapping4_key as mapping10_27_, messagecon0_.mapping4_type as mapping11_27_, messagecon0_.mapping5_key as mapping12_27_, messagecon0_.mapping5_type as mapping13_27_, messagecon0_.version as version27_ from message_context_mapping_keys messagecon0_ where messagecon0_.digested=?]; SQL state [null]; error code [0]; Connections could not be acquired from the underlying database!; nested exception is java.sql.SQLException: Connections could not be acquired from the underlying database! 

     

     

    Thanks&Regards,

    Suneel



  • 2.  Re: Exceptions in SSG Logs

    Posted Oct 31, 2016 05:22 AM

    Looking at the log i think its better to check the grants, try the below command and see if all the required grants are in place

     

    mysql -e "select user,host,password from mysql.user;"