Closed scottg1965 closed 3 years ago
Can you control your bed through the app (turn off bluetooth to make sure it is using wifi) or access it at https://sleepiq.sleepnumber.com/? I have not seen this error before.
Yes. Just checked with app connected through WiFi. These errors don’t seem to be causing an issue just showing up in the log. I don’t have a foot warmer.
I’m having more issues with the no responses that I mentioned since iOS 14. Hoping that is resolved with a homebridge and/or iOS update.
On Sep 23, 2020, at 5:44 PM, DeeeeLAN notifications@github.com wrote:
Can you control your bed through the app (turn off bluetooth to make sure it is using wifi) or access it at https://sleepiq.sleepnumber.com/? I have not seen this error before.
— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub, or unsubscribe.
Okay, well keep an eye out, and if you can post a full debug log that would be beneficial. If anybody else has this same issue please do the same, I will see if it is something on my end that needs to be addressed. I am glad everything still works though.
@DeeeeLAN
The flex controls were not working correctly this morning and checked the logs. Found the following errors in the log.
[9/24/2020, 7:17:23 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
[9/24/2020, 7:17:23 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
[9/24/2020, 7:17:37 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
[9/24/2020, 7:17:37 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
[9/24/2020, 7:17:52 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
[9/24/2020, 7:17:52 AM] [SleepIQ] Failed to fetch outlet status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
[9/24/2020, 7:18:09 AM] [SleepIQ] SleepIQ authentication failed with an unknown error code. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
[9/24/2020, 7:19:06 AM] [SleepIQ] Failed to retrieve bed pause mode: StatusCodeError: 418 - "{\"Error\":{\"Code\":418,\"Message\":\"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException\"}}"
at new StatusCodeError (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/errors.js:32:15)
at Request.plumbing.callback (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/plumbing.js:104:33)
at Request.RP$callback [as _callback] (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/plumbing.js:46:31)
at Request.self.callback (/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:185:22)
at Request.emit (events.js:315:20)
at Request.<anonymous> (/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:1154:10)
at Request.emit (events.js:315:20)
at IncomingMessage.<anonymous> (/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:1076:12)
at Object.onceWrapper (events.js:421:28)
at IncomingMessage.emit (events.js:327:22)
at endReadableNT (_stream_readable.js:1220:12)
at processTicksAndRejections (internal/process/task_queues.js:84:21) {
statusCode: 418,
error: '{"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}',
options: {
jar: true,
method: 'GET',
uri: 'https://api.sleepiq.sleepnumber.com/rest/bed/-9223372027576545248/pauseMode',
qs: { _k: '1CRnsEgvhEuwZ' },
callback: [Function: RP$callback],
transform: undefined,
simple: true,
resolveWithFullResponse: false,
transform2xxOnly: false
},
response: IncomingMessage {
_readableState: ReadableState {
objectMode: false,
highWaterMark: 16384,
buffer: BufferList { head: null, tail: null, length: 0 },
length: 0,
pipes: null,
pipesCount: 0,
flowing: true,
ended: true,
endEmitted: true,
reading: false,
sync: false,
needReadable: false,
emittedReadable: false,
readableListening: false,
resumeScheduled: false,
emitClose: true,
autoDestroy: false,
destroyed: false,
defaultEncoding: 'utf8',
awaitDrainWriters: null,
multiAwaitDrain: false,
readingMore: false,
decoder: null,
encoding: null,
[Symbol(kPaused)]: false
},
readable: false,
_events: [Object: null prototype] {
end: [Array],
close: [Array],
data: [Function],
error: [Function]
},
_eventsCount: 4,
_maxListeners: undefined,
socket: TLSSocket {
_tlsOptions: [Object],
_secureEstablished: true,
_securePending: false,
_newSessionPending: false,
_controlReleased: true,
secureConnecting: true,
_SNICallback: null,
servername: 'api.sleepiq.sleepnumber.com',
alpnProtocol: false,
authorized: true,
authorizationError: null,
encrypted: true,
_events: [Object: null prototype],
_eventsCount: 10,
connecting: false,
_hadError: false,
_parent: null,
_host: 'api.sleepiq.sleepnumber.com',
_readableState: [ReadableState],
readable: true,
_maxListeners: undefined,
_writableState: [WritableState],
writable: false,
allowHalfOpen: false,
_sockname: null,
_pendingData: null,
_pendingEncoding: '',
server: undefined,
_server: null,
ssl: [TLSWrap],
_requestCert: true,
_rejectUnauthorized: true,
parser: null,
_httpMessage: [ClientRequest],
[Symbol(res)]: [TLSWrap],
[Symbol(verified)]: true,
[Symbol(pendingSession)]: null,
[Symbol(asyncId)]: 28770,
[Symbol(kHandle)]: [TLSWrap],
[Symbol(kSetNoDelay)]: false,
[Symbol(lastWriteQueueSize)]: 0,
[Symbol(timeout)]: null,
[Symbol(kBuffer)]: null,
[Symbol(kBufferCb)]: null,
[Symbol(kBufferGen)]: null,
[Symbol(kCapture)]: false,
[Symbol(kBytesRead)]: 0,
[Symbol(kBytesWritten)]: 0,
[Symbol(connect-options)]: [Object]
},
connection: TLSSocket {
_tlsOptions: [Object],
_secureEstablished: true,
_securePending: false,
_newSessionPending: false,
_controlReleased: true,
secureConnecting: true,
_SNICallback: null,
servername: 'api.sleepiq.sleepnumber.com',
alpnProtocol: false,
authorized: true,
authorizationError: null,
encrypted: true,
_events: [Object: null prototype],
_eventsCount: 10,
connecting: false,
_hadError: false,
_parent: null,
_host: 'api.sleepiq.sleepnumber.com',
_readableState: [ReadableState],
readable: true,
_maxListeners: undefined,
_writableState: [WritableState],
writable: false,
allowHalfOpen: false,
_sockname: null,
_pendingData: null,
_pendingEncoding: '',
server: undefined,
_server: null,
ssl: [TLSWrap],
_requestCert: true,
_rejectUnauthorized: true,
parser: null,
_httpMessage: [ClientRequest],
[Symbol(res)]: [TLSWrap],
[Symbol(verified)]: true,
[Symbol(pendingSession)]: null,
[Symbol(asyncId)]: 28770,
[Symbol(kHandle)]: [TLSWrap],
[Symbol(kSetNoDelay)]: false,
[Symbol(lastWriteQueueSize)]: 0,
[Symbol(timeout)]: null,
[Symbol(kBuffer)]: null,
[Symbol(kBufferCb)]: null,
[Symbol(kBufferGen)]: null,
[Symbol(kCapture)]: false,
[Symbol(kBytesRead)]: 0,
[Symbol(kBytesWritten)]: 0,
[Symbol(connect-options)]: [Object]
},
httpVersionMajor: 1,
httpVersionMinor: 1,
httpVersion: '1.1',
complete: true,
headers: {
date: 'Thu, 24 Sep 2020 12:19:38 GMT',
'content-type': 'application/json;charset=UTF-8',
'transfer-encoding': 'chunked',
connection: 'close',
'set-cookie': [Array],
server: 'Apache-Coyote/1.1',
'strict-transport-security': 'max-age=2628000',
'cache-control': 'no-cache, no-store',
'x-frame-options': 'Deny',
'content-security-policy': "frame-ancestors 'none'"
},
rawHeaders: [
'Date',
'Thu, 24 Sep 2020 12:19:38 GMT',
'Content-Type',
'application/json;charset=UTF-8',
'Transfer-Encoding',
'chunked',
'Connection',
'close',
'Set-Cookie',
'AWSALB=zHlgE+SAoOs/E2BUdyJAufZMmaONGy3T+OOvSzHbJP0i5Co5oN/oDPu9zUq3NUcm8xi6OHdKWgkzdak2q3ognswA0DSlHsVX+atx+Z6VzB1h8QO63hphFXFFKoNM; Expires=Thu, 01 Oct 2020 12:19:21 GMT; Path=/',
'Set-Cookie',
'AWSALBCORS=zHlgE+SAoOs/E2BUdyJAufZMmaONGy3T+OOvSzHbJP0i5Co5oN/oDPu9zUq3NUcm8xi6OHdKWgkzdak2q3ognswA0DSlHsVX+atx+Z6VzB1h8QO63hphFXFFKoNM; Expires=Thu, 01 Oct 2020 12:19:21 GMT; Path=/; SameSite=None; Secure',
'Server',
'Apache-Coyote/1.1',
'Strict-Transport-Security',
'max-age=2628000',
'Cache-Control',
'no-cache, no-store',
'X-Frame-Options',
'Deny',
'Content-Security-Policy',
"frame-ancestors 'none'"
],
trailers: {},
rawTrailers: [],
aborted: false,
upgrade: false,
url: '',
method: null,
statusCode: 418,
statusMessage: '',
client: TLSSocket {
_tlsOptions: [Object],
_secureEstablished: true,
_securePending: false,
_newSessionPending: false,
_controlReleased: true,
secureConnecting: true,
_SNICallback: null,
servername: 'api.sleepiq.sleepnumber.com',
alpnProtocol: false,
authorized: true,
authorizationError: null,
encrypted: true,
_events: [Object: null prototype],
_eventsCount: 10,
connecting: false,
_hadError: false,
_parent: null,
_host: 'api.sleepiq.sleepnumber.com',
_readableState: [ReadableState],
readable: true,
_maxListeners: undefined,
_writableState: [WritableState],
writable: false,
allowHalfOpen: false,
_sockname: null,
_pendingData: null,
_pendingEncoding: '',
server: undefined,
_server: null,
ssl: [TLSWrap],
_requestCert: true,
_rejectUnauthorized: true,
parser: null,
_httpMessage: [ClientRequest],
[Symbol(res)]: [TLSWrap],
[Symbol(verified)]: true,
[Symbol(pendingSession)]: null,
[Symbol(asyncId)]: 28770,
[Symbol(kHandle)]: [TLSWrap],
[Symbol(kSetNoDelay)]: false,
[Symbol(lastWriteQueueSize)]: 0,
[Symbol(timeout)]: null,
[Symbol(kBuffer)]: null,
[Symbol(kBufferCb)]: null,
[Symbol(kBufferGen)]: null,
[Symbol(kCapture)]: false,
[Symbol(kBytesRead)]: 0,
[Symbol(kBytesWritten)]: 0,
[Symbol(connect-options)]: [Object]
},
_consuming: true,
_dumped: false,
req: ClientRequest {
_events: [Object: null prototype],
_eventsCount: 5,
_maxListeners: undefined,
outputData: [],
outputSize: 0,
writable: true,
_last: true,
chunkedEncoding: false,
shouldKeepAlive: false,
useChunkedEncodingByDefault: false,
sendDate: false,
_removedConnection: false,
_removedContLen: false,
_removedTE: false,
_contentLength: 0,
_hasBody: true,
_trailer: '',
finished: true,
_headerSent: true,
socket: [TLSSocket],
connection: [TLSSocket],
_header: 'GET /rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ HTTP/1.1\r\n' +
'host: api.sleepiq.sleepnumber.com\r\n' +
'cookie: AWSALB=v5FjXvYfvzi5nu3RgrWcW9GVZSBW0MZVzBaoMpCjkxDHgt18Cjgc3je+k+KPl4PZMVHEj6PVOxB07adKEFrmw9LCesBPJksoQqPv9D6SkrXcpSLHBqlh+0nJw1fD; AWSALBCORS=v5FjXvYfvzi5nu3RgrWcW9GVZSBW0MZVzBaoMpCjkxDHgt18Cjgc3je+k+KPl4PZMVHEj6PVOxB07adKEFrmw9LCesBPJksoQqPv9D6SkrXcpSLHBqlh+0nJw1fD; JSESSIONID=3B71F5DFF2995C322587D2773D362023\r\n' +
'Connection: close\r\n' +
'\r\n',
_onPendingData: [Function: noopPendingOutput],
agent: [Agent],
socketPath: undefined,
method: 'GET',
insecureHTTPParser: undefined,
path: '/rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ',
_ended: true,
res: [Circular],
aborted: false,
timeoutCb: null,
upgradeOrConnect: false,
parser: null,
maxHeadersCount: null,
reusedSocket: false,
[Symbol(kCapture)]: false,
[Symbol(kNeedDrain)]: false,
[Symbol(corked)]: 0,
[Symbol(kOutHeaders)]: [Object: null prototype]
},
request: Request {
_events: [Object: null prototype],
_eventsCount: 5,
_maxListeners: undefined,
method: 'GET',
uri: [Url],
callback: [Function],
readable: true,
writable: true,
explicitMethod: true,
_qs: [Querystring],
_auth: [Auth],
_oauth: [OAuth],
_multipart: [Multipart],
_redirect: [Redirect],
_tunnel: [Tunnel],
_rp_resolve: [Function],
_rp_reject: [Function],
_rp_promise: [Promise],
_rp_callbackOrig: [Function: bound ],
_rp_options: [Object],
headers: [Object],
setHeader: [Function],
hasHeader: [Function],
getHeader: [Function],
removeHeader: [Function],
localAddress: undefined,
pool: {},
dests: [],
__isRequestRequest: true,
_callback: [Function: RP$callback],
proxy: null,
tunnel: true,
setHost: true,
originalCookieHeader: undefined,
_jar: true,
port: 443,
host: 'api.sleepiq.sleepnumber.com',
url: [Url],
path: '/rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ',
httpModule: [Object],
agentClass: [Function: Agent],
agent: [Agent],
_started: true,
href: 'https://api.sleepiq.sleepnumber.com/rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ',
req: [ClientRequest],
ntick: true,
response: [Circular],
originalHost: 'api.sleepiq.sleepnumber.com',
originalHostHeaderName: 'host',
responseContent: [Circular],
_destdata: true,
_ended: true,
_callbackCalled: true,
[Symbol(kCapture)]: false
},
toJSON: [Function: responseToJSON],
caseless: Caseless { dict: [Object] },
body: '{"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}',
[Symbol(kCapture)]: false
}
}
[9/24/2020, 7:19:16 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
[9/24/2020, 7:19:16 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
[9/24/2020, 7:22:10 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
[9/24/2020, 7:22:10 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
[9/24/2020, 7:46:01 AM] [SleepIQ] Failed to fetch outlet status: Error: connect ETIMEDOUT 107.20.110.64:443
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1141:16) {
errno: 'ETIMEDOUT',
code: 'ETIMEDOUT',
syscall: 'connect',
address: '107.20.110.64',
port: 443
}
[9/24/2020, 7:46:02 AM] [SleepIQ] Failed to fetch lightstrip status: Error: connect ETIMEDOUT 107.20.110.64:443
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1141:16) {
errno: 'ETIMEDOUT',
code: 'ETIMEDOUT',
syscall: 'connect',
address: '107.20.110.64',
port: 443
}
[9/24/2020, 7:46:05 AM] [SleepIQ] Failed to fetch outlet status: Error: connect ETIMEDOUT 107.20.110.64:443
at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1141:16) {
errno: 'ETIMEDOUT',
code: 'ETIMEDOUT',
syscall: 'connect',
address: '107.20.110.64',
port: 443
}
I restarted homebridge and flex controls are working again, and see the following in the log:
[9/24/2020, 8:14:49 AM] [SleepIQ] No foot warmer detected
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0 privacy already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide occupancy already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide number control already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide flex foundation already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide outlet already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide lightstrip already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide occupancy already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide number control already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide flex foundation already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide outlet already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide lightstrip already added from cache
[9/24/2020, 8:14:49 AM] [SleepIQ] bed0anySide occupancy already added from cache
[9/24/2020, 8:16:20 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
[9/24/2020, 8:16:20 AM] [SleepIQ] Failed to fetch outlet status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
I can add I had the same thing, I did grab some of the log, but I need to review it for content before posting, but the HOOBS server was in a services stopped state again this morning & the log was so full of these quite similar messages.
I will post my logs in as well, a bit later on this afternoon...
RM
Sent from my iPad
On Sep 24, 2020, at 6:23 AM, David Peak notifications@github.com wrote:
@DeeeeLAN
The flex controls were not working correctly this morning and checked the logs. Found the following errors in the log.
[9/24/2020, 7:17:23 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new [9/24/2020, 7:17:23 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}} [9/24/2020, 7:17:37 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new [9/24/2020, 7:17:37 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}} [9/24/2020, 7:17:52 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new [9/24/2020, 7:17:52 AM] [SleepIQ] Failed to fetch outlet status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}} [9/24/2020, 7:18:09 AM] [SleepIQ] SleepIQ authentication failed with an unknown error code. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new [9/24/2020, 7:19:06 AM] [SleepIQ] Failed to retrieve bed pause mode: StatusCodeError: 418 - "{\"Error\":{\"Code\":418,\"Message\":\"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException\"}}" at new StatusCodeError (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/errors.js:32:15) at Request.plumbing.callback (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/plumbing.js:104:33) at Request.RP$callback [as _callback] (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/plumbing.js:46:31) at Request.self.callback (/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:185:22) at Request.emit (events.js:315:20) at Request.
(/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:1154:10) at Request.emit (events.js:315:20) at IncomingMessage. (/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:1076:12) at Object.onceWrapper (events.js:421:28) at IncomingMessage.emit (events.js:327:22) at endReadableNT (_stream_readable.js:1220:12) at processTicksAndRejections (internal/process/task_queues.js:84:21) { statusCode: 418, error: '{"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}', options: { jar: true, method: 'GET', uri: 'https://api.sleepiq.sleepnumber.com/rest/bed/-9223372027576545248/pauseMode', qs: { _k: '1CRnsEgvhEuwZ' }, callback: [Function: RP$callback], transform: undefined, simple: true, resolveWithFullResponse: false, transform2xxOnly: false }, response: IncomingMessage { _readableState: ReadableState { objectMode: false, highWaterMark: 16384, buffer: BufferList { head: null, tail: null, length: 0 }, length: 0, pipes: null, pipesCount: 0, flowing: true, ended: true, endEmitted: true, reading: false, sync: false, needReadable: false, emittedReadable: false, readableListening: false, resumeScheduled: false, emitClose: true, autoDestroy: false, destroyed: false, defaultEncoding: 'utf8', awaitDrainWriters: null, multiAwaitDrain: false, readingMore: false, decoder: null, encoding: null, }, readable: false, _events: [Object: null prototype] { end: [Array], close: [Array], data: [Function], error: [Function] }, _eventsCount: 4, _maxListeners: undefined, socket: TLSSocket { _tlsOptions: [Object], _secureEstablished: true, _securePending: false, _newSessionPending: false, _controlReleased: true, secureConnecting: true, _SNICallback: null, servername: 'api.sleepiq.sleepnumber.com', alpnProtocol: false, authorized: true, authorizationError: null, encrypted: true, _events: [Object: null prototype], _eventsCount: 10, connecting: false, _hadError: false, _parent: null, _host: 'api.sleepiq.sleepnumber.com', _readableState: [ReadableState], readable: true, _maxListeners: undefined, _writableState: [WritableState], writable: false, allowHalfOpen: false, _sockname: null, _pendingData: null, _pendingEncoding: '', server: undefined, _server: null, ssl: [TLSWrap], _requestCert: true, _rejectUnauthorized: true, parser: null, _httpMessage: [ClientRequest], [Symbol(res)]: [TLSWrap], [Symbol(verified)]: true, [Symbol(pendingSession)]: null, [Symbol(asyncId)]: 28770, [Symbol(kHandle)]: [TLSWrap], [Symbol(kSetNoDelay)]: false, [Symbol(lastWriteQueueSize)]: 0, [Symbol(timeout)]: null, [Symbol(kBuffer)]: null, [Symbol(kBufferCb)]: null, [Symbol(kBufferGen)]: null, [Symbol(kCapture)]: false, [Symbol(kBytesRead)]: 0, [Symbol(kBytesWritten)]: 0, [Symbol(connect-options)]: [Object] }, connection: TLSSocket { _tlsOptions: [Object], _secureEstablished: true, _securePending: false, _newSessionPending: false, _controlReleased: true, secureConnecting: true, _SNICallback: null, servername: 'api.sleepiq.sleepnumber.com', alpnProtocol: false, authorized: true, authorizationError: null, encrypted: true, _events: [Object: null prototype], _eventsCount: 10, connecting: false, _hadError: false, _parent: null, _host: 'api.sleepiq.sleepnumber.com', _readableState: [ReadableState], readable: true, _maxListeners: undefined, _writableState: [WritableState], writable: false, allowHalfOpen: false, _sockname: null, _pendingData: null, _pendingEncoding: '', server: undefined, _server: null, ssl: [TLSWrap], _requestCert: true, _rejectUnauthorized: true, parser: null, _httpMessage: [ClientRequest], [Symbol(res)]: [TLSWrap], [Symbol(verified)]: true, [Symbol(pendingSession)]: null, [Symbol(asyncId)]: 28770, [Symbol(kHandle)]: [TLSWrap], [Symbol(kSetNoDelay)]: false, [Symbol(lastWriteQueueSize)]: 0, [Symbol(timeout)]: null, [Symbol(kBuffer)]: null, [Symbol(kBufferCb)]: null, [Symbol(kBufferGen)]: null, [Symbol(kCapture)]: false, [Symbol(kBytesRead)]: 0, [Symbol(kBytesWritten)]: 0, [Symbol(connect-options)]: [Object] }, httpVersionMajor: 1, httpVersionMinor: 1, httpVersion: '1.1', complete: true, headers: { date: 'Thu, 24 Sep 2020 12:19:38 GMT', 'content-type': 'application/json;charset=UTF-8', 'transfer-encoding': 'chunked', connection: 'close', 'set-cookie': [Array], server: 'Apache-Coyote/1.1', 'strict-transport-security': 'max-age=2628000', 'cache-control': 'no-cache, no-store', 'x-frame-options': 'Deny', 'content-security-policy': "frame-ancestors 'none'" }, rawHeaders: [ 'Date', 'Thu, 24 Sep 2020 12:19:38 GMT', 'Content-Type', 'application/json;charset=UTF-8', 'Transfer-Encoding', 'chunked', 'Connection', 'close', 'Set-Cookie', 'AWSALB=zHlgE+SAoOs/E2BUdyJAufZMmaONGy3T+OOvSzHbJP0i5Co5oN/oDPu9zUq3NUcm8xi6OHdKWgkzdak2q3ognswA0DSlHsVX+atx+Z6VzB1h8QO63hphFXFFKoNM; Expires=Thu, 01 Oct 2020 12:19:21 GMT; Path=/', 'Set-Cookie', 'AWSALBCORS=zHlgE+SAoOs/E2BUdyJAufZMmaONGy3T+OOvSzHbJP0i5Co5oN/oDPu9zUq3NUcm8xi6OHdKWgkzdak2q3ognswA0DSlHsVX+atx+Z6VzB1h8QO63hphFXFFKoNM; Expires=Thu, 01 Oct 2020 12:19:21 GMT; Path=/; SameSite=None; Secure', 'Server', 'Apache-Coyote/1.1', 'Strict-Transport-Security', 'max-age=2628000', 'Cache-Control', 'no-cache, no-store', 'X-Frame-Options', 'Deny', 'Content-Security-Policy', "frame-ancestors 'none'" ], trailers: {}, rawTrailers: [], aborted: false, upgrade: false, url: '', method: null, statusCode: 418, statusMessage: '', client: TLSSocket { _tlsOptions: [Object], _secureEstablished: true, _securePending: false, _newSessionPending: false, _controlReleased: true, secureConnecting: true, _SNICallback: null, servername: 'api.sleepiq.sleepnumber.com', alpnProtocol: false, authorized: true, authorizationError: null, encrypted: true, _events: [Object: null prototype], _eventsCount: 10, connecting: false, _hadError: false, _parent: null, _host: 'api.sleepiq.sleepnumber.com', _readableState: [ReadableState], readable: true, _maxListeners: undefined, _writableState: [WritableState], writable: false, allowHalfOpen: false, _sockname: null, _pendingData: null, _pendingEncoding: '', server: undefined, _server: null, ssl: [TLSWrap], _requestCert: true, _rejectUnauthorized: true, parser: null, _httpMessage: [ClientRequest], [Symbol(res)]: [TLSWrap], [Symbol(verified)]: true, [Symbol(pendingSession)]: null, [Symbol(asyncId)]: 28770, [Symbol(kHandle)]: [TLSWrap], [Symbol(kSetNoDelay)]: false, [Symbol(lastWriteQueueSize)]: 0, [Symbol(timeout)]: null, [Symbol(kBuffer)]: null, [Symbol(kBufferCb)]: null, [Symbol(kBufferGen)]: null, [Symbol(kCapture)]: false, [Symbol(kBytesRead)]: 0, [Symbol(kBytesWritten)]: 0, [Symbol(connect-options)]: [Object] }, _consuming: true, _dumped: false, req: ClientRequest { _events: [Object: null prototype], _eventsCount: 5, _maxListeners: undefined, outputData: [], outputSize: 0, writable: true, _last: true, chunkedEncoding: false, shouldKeepAlive: false, useChunkedEncodingByDefault: false, sendDate: false, _removedConnection: false, _removedContLen: false, _removedTE: false, _contentLength: 0, _hasBody: true, _trailer: '', finished: true, _headerSent: true, socket: [TLSSocket], connection: [TLSSocket], _header: 'GET /rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ HTTP/1.1\r\n' + 'host: api.sleepiq.sleepnumber.com\r\n' + 'cookie: AWSALB=v5FjXvYfvzi5nu3RgrWcW9GVZSBW0MZVzBaoMpCjkxDHgt18Cjgc3je+k+KPl4PZMVHEj6PVOxB07adKEFrmw9LCesBPJksoQqPv9D6SkrXcpSLHBqlh+0nJw1fD; AWSALBCORS=v5FjXvYfvzi5nu3RgrWcW9GVZSBW0MZVzBaoMpCjkxDHgt18Cjgc3je+k+KPl4PZMVHEj6PVOxB07adKEFrmw9LCesBPJksoQqPv9D6SkrXcpSLHBqlh+0nJw1fD; JSESSIONID=3B71F5DFF2995C322587D2773D362023\r\n' + 'Connection: close\r\n' + '\r\n', _onPendingData: [Function: noopPendingOutput], agent: [Agent], socketPath: undefined, method: 'GET', insecureHTTPParser: undefined, path: '/rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ', _ended: true, res: [Circular], aborted: false, timeoutCb: null, upgradeOrConnect: false, parser: null, maxHeadersCount: null, reusedSocket: false, [Symbol(kCapture)]: false, [Symbol(kNeedDrain)]: false, [Symbol(corked)]: 0, [Symbol(kOutHeaders)]: [Object: null prototype] }, request: Request { _events: [Object: null prototype], _eventsCount: 5, _maxListeners: undefined, method: 'GET', uri: [Url], callback: [Function], readable: true, writable: true, explicitMethod: true, _qs: [Querystring], _auth: [Auth], _oauth: [OAuth], _multipart: [Multipart], _redirect: [Redirect], _tunnel: [Tunnel], _rp_resolve: [Function], _rp_reject: [Function], _rp_promise: [Promise], _rp_callbackOrig: [Function: bound ], _rp_options: [Object], headers: [Object], setHeader: [Function], hasHeader: [Function], getHeader: [Function], removeHeader: [Function], localAddress: undefined, pool: {}, dests: [], __isRequestRequest: true, _callback: [Function: RP$callback], proxy: null, tunnel: true, setHost: true, originalCookieHeader: undefined, _jar: true, port: 443, host: 'api.sleepiq.sleepnumber.com', url: [Url], path: '/rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ', httpModule: [Object], agentClass: [Function: Agent], agent: [Agent], _started: true, href: 'https://api.sleepiq.sleepnumber.com/rest/bed/-9223372027576545248/pauseMode?_k=1CRnsEgvhEuwZ', req: [ClientRequest], ntick: true, response: [Circular], originalHost: 'api.sleepiq.sleepnumber.com', originalHostHeaderName: 'host', responseContent: [Circular], _destdata: true, _ended: true, _callbackCalled: true, [Symbol(kCapture)]: false }, toJSON: [Function: responseToJSON], caseless: Caseless { dict: [Object] }, body: '{"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}', [Symbol(kCapture)]: false
} } [9/24/2020, 7:19:16 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new [9/24/2020, 7:19:16 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}} [9/24/2020, 7:22:10 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new [9/24/2020, 7:22:10 AM] [SleepIQ] Failed to fetch lightstrip status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}} [9/24/2020, 7:46:01 AM] [SleepIQ] Failed to fetch outlet status: Error: connect ETIMEDOUT 107.20.110.64:443 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1141:16) { errno: 'ETIMEDOUT', code: 'ETIMEDOUT', syscall: 'connect', address: '107.20.110.64', port: 443 } [9/24/2020, 7:46:02 AM] [SleepIQ] Failed to fetch lightstrip status: Error: connect ETIMEDOUT 107.20.110.64:443 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1141:16) { errno: 'ETIMEDOUT', code: 'ETIMEDOUT', syscall: 'connect', address: '107.20.110.64', port: 443 } [9/24/2020, 7:46:05 AM] [SleepIQ] Failed to fetch outlet status: Error: connect ETIMEDOUT 107.20.110.64:443 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1141:16) { errno: 'ETIMEDOUT', code: 'ETIMEDOUT', syscall: 'connect', address: '107.20.110.64', port: 443 } I restarted homebridge and flex controls are working again, and see the following in the log:
[9/24/2020, 8:14:49 AM] [SleepIQ] No foot warmer detected [9/24/2020, 8:14:49 AM] [SleepIQ] bed0 privacy already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide occupancy already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide number control already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide flex foundation already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide outlet already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0leftSide lightstrip already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide occupancy already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide number control already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide flex foundation already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide outlet already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0rightSide lightstrip already added from cache [9/24/2020, 8:14:49 AM] [SleepIQ] bed0anySide occupancy already added from cache [9/24/2020, 8:16:20 AM] [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new [9/24/2020, 8:16:20 AM] [SleepIQ] Failed to fetch outlet status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}} — You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or unsubscribe.
Hmm, well that is certainly a new error. Here is what wikipedia has to say about status code 418:
418 I'm a teapot (RFC 2324, RFC 7168) This code was defined in 1998 as one of the traditional IETF April Fools' jokes, in RFC 2324, Hyper Text Coffee Pot Control Protocol, and is not expected to be implemented by actual HTTP servers. The RFC specifies this code should be returned by teapots requested to brew coffee. This HTTP status is used as an Easter egg in some websites, such as Google.com's I'm a teapot easter egg.
So this is going to be fun to figure out. My first guess is there was just a server side error. If the errors resolve themselves and go away, that would be the likely answer. If you are getting the errors and something is not working, try controlling from your phone (on wifi not bluetooth) to see if it is failing there as well. That would be the easiest way to determine if it is an issue on our end or theirs.
As follow up, here are my logs.
This is not the entire log, but a pretty good chunk of it.
This was working when I went to bed last night under the latest plugin update yesterday, but somewhere later on in the night, these errors populate in the log & when I am up in the morning, tho HOOBS is still running, “Services” have crashed & are no long er running until I reboot…
Here is the log paste below..
FYI..
Randy
9/23/2020, 8:21:54 PM [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
9/23/2020, 8:21:54 PM [SleepIQ] Failed to fetch foot warmer status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
9/23/2020, 8:22:11 PM [SleepIQ] Unknown error occurred when checking the outlet status. See previous output for more details. If it persists, please report this incident at https://github.com/DeeeeLAN/homebridge-sleepiq/issues/new
9/23/2020, 8:22:11 PM [SleepIQ] Failed to fetch foot warmer status: {"Error":{"Code":418,"Message":"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException"}}
9/23/2020, 8:22:11 PM [SleepIQ] Failed to retrieve bed pause mode: StatusCodeError: 418 - "{\"Error\":{\"Code\":418,\"Message\":\"Could not open JPA EntityManager for transaction; nested exception is javax.persistence.PersistenceException: org.hibernate.exception.JDBCConnectionException: Could not open connection-CannotCreateTransactionException\"}}"
at new StatusCodeError (/home/hoobs/.hoobs/node_modules/request-promise-core/lib/errors.js:32:15)
at Request.plumbing.callback (/home/hoobs/.hoobs/node_modules/request-promise-core/lib/plumbing.js:104:33)
at Request.RP$callback [as _callback] (/home/hoobs/.hoobs/node_modules/request-promise-core/lib/plumbing.js:46:31)
at Request.self.callback (/home/hoobs/.hoobs/node_modules/request/request.js:185:22)
at Request.emit (events.js:310:20)
at Request.
The only errors I'm currently seeing are:
[10/3/2020, 7:14:03 AM] [SleepIQ] No foot warmer detected [10/3/2020, 7:14:03 AM] [SleepIQ] Failed to fetch foot warmer status: {"Error":{"Code":404,"Message":"Foot Warmer is not connected or not working properly"}} [10/3/2020, 7:14:07 AM] [SleepIQ] No foot warmer detected [10/3/2020, 7:14:07 AM] [SleepIQ] Failed to fetch foot warmer status: {"Error":{"Code":404,"Message":"Foot Warmer is not connected or not working properly"}}
I do not have a foot warmer. Could an option be added to set "foot warmer = false" in settings so it will bypass all foot warmer calls? Also remove the foot warmer accessories added to HomeKit sine they aren't needed?
@scottg1965 yep I will add that once I implement #33. The plug-in will do an initial check for the foot warmers, but it shouldn’t repeat them once it determines they don’t exist. Some bases report they exist even if they don’t, and those will need the filter for sure, but if they are giving a 404 like that, they shouldn’t be showing up in HomeKit. Are those errors repeatedly showing up?
@DeeeeLAN Yes, these errors show up repeatedly and sporadically.
I also have under bed lighting. Is that the same as the light strip? I also get
[10/2/2020, 2:58:19 AM] [SleepIQ] No lightstrip detected
I’m seeing the following errors in my status log under homebridge version 1.2.3 and SleepIQ 4.1.16.
I’m also seeing continuous “No Response” errors for all my homebridge accessories after upgrading to iOS and TVOS 14. I think that is a homebridge issue but including it for completeness.
[9/23/2020, 9:55:23 PM] [SleepIQ] Failed to fetch foundation status: Error: read ECONNRESET at TLSWrap.onStreamRead (internal/stream_base_commons.js:201:27) { errno: 'ECONNRESET', code: 'ECONNRESET', syscall: 'read' } [9/23/2020, 10:16:59 PM] [SleepIQ] Failed to fetch foot warmer status: Error: read ECONNRESET at TLSWrap.onStreamRead (internal/stream_base_commons.js:201:27) { errno: 'ECONNRESET', code: 'ECONNRESET', syscall: 'read' } [9/23/2020, 10:29:33 PM] [SleepIQ] Failed to retrieve bed pause mode: RequestError: Error: read ECONNRESET at new RequestError (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/errors.js:14:15) at Request.plumbing.callback (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/plumbing.js:87:29) at Request.RP$callback [as _callback] (/homebridge/node_modules/homebridge-sleepiq/node_modules/request-promise-core/lib/plumbing.js:46:31) at self.callback (/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:185:22) at Request.emit (events.js:210:5) at Request.onRequestError (/homebridge/node_modules/homebridge-sleepiq/node_modules/request/request.js:877:8) at ClientRequest.emit (events.js:210:5) at TLSSocket.socketErrorListener (_http_client.js:406:9) at TLSSocket.emit (events.js:210:5) at emitErrorNT (internal/streams/destroy.js:92:8) at emitErrorAndCloseNT (internal/streams/destroy.js:60:3) at processTicksAndRejections (internal/process/task_queues.js:80:21) { name: 'RequestError', message: 'Error: read ECONNRESET', cause: Error: read ECONNRESET at TLSWrap.onStreamRead (internal/stream_base_commons.js:201:27) { errno: 'ECONNRESET', code: 'ECONNRESET', syscall: 'read' }, error: Error: read ECONNRESET at TLSWrap.onStreamRead (internal/stream_base_commons.js:201:27) { errno: 'ECONNRESET', code: 'ECONNRESET', syscall: 'read' }, options: { jar: true, method: 'GET', uri: 'https://api.sleepiq.sleepnumber.com/rest/bed/-9223372019472236968/pauseMode', qs: { _k: 'jsumKpfgpcG1V' }, callback: [Function: RP$callback], transform: undefined, simple: true, resolveWithFullResponse: false, transform2xxOnly: false }, response: undefined }