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

SQL timeout #659

Open
whasf opened this issue Nov 2, 2019 · 1 comment
Open

SQL timeout #659

whasf opened this issue Nov 2, 2019 · 1 comment

Comments

@whasf
Copy link

whasf commented Nov 2, 2019

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)

@whasf
Copy link
Author

whasf commented Nov 2, 2019

Getting lots of SQLException errors...

Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant