Skip to content
This repository was archived by the owner on Apr 4, 2023. It is now read-only.
This repository was archived by the owner on Apr 4, 2023. It is now read-only.

SQL timeout #659

@whasf

Description

@whasf

Verify the following before opening an issue:

  • [x ] You followed the Nest Developer documentation here? Nest Developer Account Creation
  • [ x] That OAuth is Enabled for the SmartApp under the IDE.
  • [x ] The SmartApps and ALL (5) Devices Handlers are using the latest code available.
  • [ x] You have reviewed the NST Manager Wiki for potential fixes.
  • [x ] That ALL SmartApps and Device Handlers have been Published for You in the IDE.

About Your Setup:

  • How many Thermostats?:1
  • How many Protects?2
  • How many Cameras?0
  • Using the Nest Presence Device?No
  • Using the Nest Weather Device?Yes
  • iOS or Android?:iOS
  • Mobile App Version:

Context

Please include a copy of your log under the IDE if possible

Is this a SmartThings issue?

6:23:07 PM: debug Battery rawValue = 22
6:23:01 PM: error org.springframework.jdbc.UncategorizedSQLException: Hibernate operation: could not execute query; uncategorized SQLException for SQL [select this_.id as id27_0_, this_.version as version27_0_, this_.data as data27_0_, this_.date_created as date4_27_0_, this_.device_id as device5_27_0_, this_.filter_events as filter6_27_0_, this_.handler as handler27_0_, this_.hub_id as hub8_27_0_, this_.installed_smart_app_id as installed9_27_0_, this_.last_updated as last10_27_0_, this_.location_id as location11_27_0_, this_.name as name27_0_ from event_subscription this_ where this_.installed_smart_app_id=?]; SQL state [null]; error code [0]; [SimpleAsyncTaskExecutor-45] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:50; busy:11; idle:0; lastwait:30000].; nested exception is org.apache.tomcat.jdbc.pool.PoolExhaustedException: [SimpleAsyncTaskExecutor-45] Timeout: Pool empty. Unable to fetch a connection in 30 seconds, none available[size:50; busy:11; idle:0; lastwait:30000]. @line 570 (initAutoApp)
6:22:41 PM: debug NST Automations (NestMode) | scheduleAutomationEval: Skipping Schedule Change: (30sec) because (-387sec) Left
6:22:40 PM: info ||| NST Automations (NestMode) | Automation Label: NST Automations (NestMode)
6:22:39 PM: info ||| NST Automations (NestMode) | nMode scheduled (28 8/30 * * * ?)
6:22:16 PM: debug NST Manager (v5.6.4) | Found: Nest vThermostat - Hallway with (Id: v-zCScc6EwgvD__PJxJA6CrxyESDAgs4Q) exists
6:22:16 PM: debug NST Manager (v5.6.4) | atomicState.vThermostats: [v-zCScc6EwgvD__PJxJA6CrxyESDAgs4Q:Hallway] dni: v-zCScc6EwgvD__PJxJA6CrxyESDAgs4Q=Hallway dni.key: v-zCScc6EwgvD__PJxJA6CrxyESDAgs4Q dni.value: Hallway
6:22:16 PM: debug NST Manager (v5.6.4) | Found: Nest Weather (70791) with (Id: NestWeather | RiseiYh5tJT4LIlC-nwlDBY70hnfRgyz8yJvwC1B3T9ELveBkE0aog) exists
6:22:16 PM: debug NST Manager (v5.6.4) | Found: Nest Protect - Dining Room with (Id: PKFuNft_pdKeEBSyqwJOhbxyESDAgs4Q) exists
6:22:16 PM: debug NST Manager (v5.6.4) | Found: Nest Protect - server room with (Id: PKFuNft_pdI2cSFQyfKWnLxyESDAgs4Q) exists
6:22:16 PM: debug NST Manager (v5.6.4) | Found: Nest Thermostat - Hallway with (Id: -zCScc6EwgvD__PJxJA6CrxyESDAgs4Q) exists
6:22:04 PM: trace | NST Manager (v5.6.4) | stateCleanup
6:22:01 PM: error java.util.concurrent.TimeoutException: Execution time exceeded 20 app execution seconds: 794660184873450 @line -1 (doCall)

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions