[BUDI-7516] "Name or password is incorrect" on app-service pod - 2.10.8

[marcAnfuso]

Hosting

• Self
  -K8s
  -Versión 2.10.8 from helmchart

Describe the bug
I'm trying to run budibase on my k8s cluster with argocd and helmchart, 2.10.8 version.
All pods are running OK except app-service (bbaps). It's logging something like username or password is incorrect.

To Reproduce
Steps to reproduce the behavior:
Try to run budibase 2.10.8 with helm and k8s

Expected behavior
Running OK bbaps (app-service) pod.

Screenshots

App Export
yarn run v1.22.19
20
$ node dist/index.js
19
{"level":"INFO","timestamp":"2023-09-19T17:57:25.080Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Budibase running on {"address":"::","family":"IPv6","port":4002}"}
18
{"level":"ERROR","timestamp":"2023-09-19T17:57:25.158Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"(node:30) NOTE: We are formalizing our plans to enter AWS SDK for JavaScript (v2) into maintenance mode in 2023.\n\nPlease migrate your code to use AWS SDK for JavaScript (v3).\nFor more information, check the migration guide at https://a.co/7PzMCcy\n(Use node --trace-warnings ... to show where the warning was created)"}
17
{"level":"INFO","timestamp":"2023-09-19T17:57:25.671Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Checking migrations"}
16
{"level":"ERROR","timestamp":"2023-09-19T17:57:26.152Z","service":"@budibase/server","err":{"type":"Error","message":"Name or password is incorrect.","stack":"Error: Name or password is incorrect.\n at responseHandler (/app/dist/index.js:21327:24)\n at /app/dist/index.js:21517:17\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","scope":"couch","statusCode":401,"request":{"method":"put","headers":{"content-type":"application/json","accept":"application/json","user-agent":"@budibase/nano/10.1.2 (Node.js v18.17.1)","Accept-Encoding":"deflate, gzip","Authorization":"Basic YWRtaW46Tm8wTWhBVWxmUTdFVEkxR09IeUM="},"qsStringifyOptions":{"arrayFormat":"repeat"},"url":"http://dev-budibase-svc-couchdb:5984/global-db","paramsSerializer":{},"maxRedirects":0,"httpAgent":{"_events":{},"_eventsCount":2,"defaultPort":80,"protocol":"http:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{"dev-budibase-svc-couchdb:5984:":[{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0}]},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":1,"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}},"httpsAgent":{"_events":{},"_eventsCount":2,"defaultPort":443,"protocol":"https:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":0,"maxCachedSessions":100,"_sessionCache":{"map":{},"list":[]},"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}}},"headers":{"uri":"http://dev-budibase-svc-couchdb:5984/global-db","statusCode":401,"cache-control":"must-revalidate","content-type":"application/json","date":"Tue, 19 Sep 2023 17:57:25 GMT","x-couch-request-id":"f4df9e5654","x-couchdb-body-time":"0"},"errid":"non_200","name":"Error","description":"Name or password is incorrect.","error":"unauthorized","reason":"Name or password is incorrect."},"pid":30,"tenantId":"default","msg":""}
15
{"level":"ERROR","timestamp":"2023-09-19T17:57:26.154Z","service":"@budibase/server","err":{"type":"Error","message":"Name or password is incorrect.","stack":"Error: Name or password is incorrect.\n at responseHandler (/app/dist/index.js:21327:24)\n at /app/dist/index.js:21517:17\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","scope":"couch","statusCode":401,"request":{"method":"put","headers":{"content-type":"application/json","accept":"application/json","user-agent":"@budibase/nano/10.1.2 (Node.js v18.17.1)","Accept-Encoding":"deflate, gzip","Authorization":"Basic YWRtaW46Tm8wTWhBVWxmUTdFVEkxR09IeUM="},"qsStringifyOptions":{"arrayFormat":"repeat"},"url":"http://dev-budibase-svc-couchdb:5984/global-db","paramsSerializer":{},"maxRedirects":0,"httpAgent":{"_events":{},"_eventsCount":2,"defaultPort":80,"protocol":"http:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{"dev-budibase-svc-couchdb:5984:":[{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0}]},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":1,"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}},"httpsAgent":{"_events":{},"_eventsCount":2,"defaultPort":443,"protocol":"https:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":0,"maxCachedSessions":100,"_sessionCache":{"map":{},"list":[]},"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}}},"headers":{"uri":"http://dev-budibase-svc-couchdb:5984/global-db","statusCode":401,"cache-control":"must-revalidate","content-type":"application/json","date":"Tue, 19 Sep 2023 17:57:25 GMT","x-couch-request-id":"f4df9e5654","x-couchdb-body-time":"0"},"errid":"non_200","name":"Error","description":"Name or password is incorrect.","error":"unauthorized","reason":"Name or password is incorrect."},"pid":30,"tenantId":"default","msg":"[Migration: user_email_view_casing] [DB: global-db] Error: "}
14
{"level":"WARN","timestamp":"2023-09-19T17:57:26.154Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"lock error"}
13
{"level":"ERROR","timestamp":"2023-09-19T17:57:26.155Z","service":"@budibase/server","err":{"type":"Error","message":"Name or password is incorrect.","stack":"Error: Name or password is incorrect.\n at responseHandler (/app/dist/index.js:21327:24)\n at /app/dist/index.js:21517:17\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","scope":"couch","statusCode":401,"request":{"method":"put","headers":{"content-type":"application/json","accept":"application/json","user-agent":"@budibase/nano/10.1.2 (Node.js v18.17.1)","Accept-Encoding":"deflate, gzip","Authorization":"Basic YWRtaW46Tm8wTWhBVWxmUTdFVEkxR09IeUM="},"qsStringifyOptions":{"arrayFormat":"repeat"},"url":"http://dev-budibase-svc-couchdb:5984/global-db","paramsSerializer":{},"maxRedirects":0,"httpAgent":{"_events":{},"_eventsCount":2,"defaultPort":80,"protocol":"http:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{"dev-budibase-svc-couchdb:5984:":[{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0}]},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":1,"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}},"httpsAgent":{"_events":{},"_eventsCount":2,"defaultPort":443,"protocol":"https:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":0,"maxCachedSessions":100,"_sessionCache":{"map":{},"list":[]},"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}}},"headers":{"uri":"http://dev-budibase-svc-couchdb:5984/global-db","statusCode":401,"cache-control":"must-revalidate","content-type":"application/json","date":"Tue, 19 Sep 2023 17:57:25 GMT","x-couch-request-id":"f4df9e5654","x-couchdb-body-time":"0"},"errid":"non_200","name":"Error","description":"Name or password is incorrect.","error":"unauthorized","reason":"Name or password is incorrect."},"pid":30,"tenantId":"default","msg":""}
12
{"level":"ERROR","timestamp":"2023-09-19T17:57:26.156Z","service":"@budibase/server","err":{"type":"Error","message":"Name or password is incorrect.","stack":"Error: Name or password is incorrect.\n at responseHandler (/app/dist/index.js:21327:24)\n at /app/dist/index.js:21517:17\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","scope":"couch","statusCode":401,"request":{"method":"put","headers":{"content-type":"application/json","accept":"application/json","user-agent":"@budibase/nano/10.1.2 (Node.js v18.17.1)","Accept-Encoding":"deflate, gzip","Authorization":"Basic YWRtaW46Tm8wTWhBVWxmUTdFVEkxR09IeUM="},"qsStringifyOptions":{"arrayFormat":"repeat"},"url":"http://dev-budibase-svc-couchdb:5984/global-db","paramsSerializer":{},"maxRedirects":0,"httpAgent":{"_events":{},"_eventsCount":2,"defaultPort":80,"protocol":"http:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{"dev-budibase-svc-couchdb:5984:":[{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0}]},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":1,"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}},"httpsAgent":{"_events":{},"_eventsCount":2,"defaultPort":443,"protocol":"https:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":0,"maxCachedSessions":100,"_sessionCache":{"map":{},"list":[]},"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}}},"headers":{"uri":"http://dev-budibase-svc-couchdb:5984/global-db","statusCode":401,"cache-control":"must-revalidate","content-type":"application/json","date":"Tue, 19 Sep 2023 17:57:25 GMT","x-couch-request-id":"f4df9e5654","x-couchdb-body-time":"0"},"errid":"non_200","name":"Error","description":"Name or password is incorrect.","error":"unauthorized","reason":"Name or password is incorrect."},"pid":30,"tenantId":"default","msg":"bb-alert: Error performing migrations. Exiting."}
11
{"level":"INFO","timestamp":"2023-09-19T17:57:26.158Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Server Closed"}
10
{"level":"ERROR","timestamp":"2023-09-19T17:57:26.176Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Failed server startup - Cannot read properties of undefined (reading 'init')"}
9
{"level":"ERROR","timestamp":"2023-09-19T17:57:26.255Z","service":"@budibase/server","err":{"type":"Error","message":"This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason "Cannot connect to CouchDB instance".","stack":"UnhandledPromiseRejection: This error originated either by throwing inside of an async function without a catch block, or by rejecting a promise which was not handled with .catch(). The promise rejected with the reason "Cannot connect to CouchDB instance".","code":"ERR_UNHANDLED_REJECTION"},"pid":30,"tenantId":"default","msg":"bb-alert: Uncaught exception."}
8
{"level":"ERROR","timestamp":"2023-09-19T17:57:26.260Z","service":"@budibase/server","err":{"type":"Error","message":"Connection is closed.","stack":"Error: Connection is closed.\n at Redis.sendCommand (/app/node_modules/bull/node_modules/ioredis/built/redis/index.js:636:24)\n at Script.execute (/app/node_modules/bull/node_modules/ioredis/built/script.js:27:34)\n at Redis.updateDelaySet (/app/node_modules/bull/node_modules/ioredis/built/commander.js:158:27)\n at Object.updateDelaySet (/app/node_modules/bull/lib/scripts.js:399:25)\n at Queue.updateDelayTimer (/app/node_modules/bull/lib/queue.js:949:6)\n at /app/node_modules/bull/lib/queue.js:378:21\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)"},"pid":30,"tenantId":"default","bull":{"eventType":"automation-event","event":"error"},"msg":"[BULL] automation-event=error"}
7
{"level":"INFO","timestamp":"2023-09-19T17:57:27.962Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Queues shutdown"}
6
{"level":"INFO","timestamp":"2023-09-19T17:57:27.962Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"REDIS SHUTDOWN"}
5
{"level":"INFO","timestamp":"2023-09-19T17:57:27.963Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Redis shutdown"}
4
{"level":"INFO","timestamp":"2023-09-19T17:57:27.963Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Events shutdown"}
3
{"level":"INFO","timestamp":"2023-09-19T17:57:27.964Z","service":"@budibase/server","pid":30,"tenantId":"default","msg":"Threads shutdown"}
2
error Command failed with exit code 255.

My DEV values:
base:
budibase:

Default values for budibase.

This is a YAML-formatted file.

Declare variables to be passed into your templates.

secrets:
  internalApiKey: AgAIiggF2QfFsCr3CK0pSqkD7pAMhIKBAV/4eJCWBrJv16/ZgM11KuJ9Zh+x49r6luo7Z3Lf/FsK3wJ3IsHR1dvjoxSdHuBB+uHrLn4uBvOcjkiS4271Wi0HAyoZ8U5EChoSEXV/zp+m4lw6ICJw6imwhazzVbrXWn+75BpNMRVJ7/tODxMmZEQ8lv8Dkt1ea8Bi9hkjHWVGdmtiDoEF1mMuzF+YB2Fvt8f+eAYX5OykZOFJcl/f0ZGZisj8eDZ3orjhI3jEbHdxc4UaFDcjR2BWyhSmaFFTPYqH1EXdaP932PLm6lg9j9Zo4f2IwSwM+W2ZkmrmSz9KxzN8mMTP/Vux7nr+87J6fmbusgXXckhFrupXRwYgUv8JFg0GDCuk/+wfLkcdn6EKeewL6sugjXd0PHW9oN3CQUhK2jLgvIADvyqWsOyTAf599zb8w7qf3bGnhFo7Xqj68OJL3p2urnjTfyo0RjlgpxKHmAuNCRkQT+Ux2nzKJRWqp4EpVnqRrPP/S9a15mw/jeGKY5vrtJQX/lGDjwEWkV5qOFlOaUsmjmXokyIEsO+sGIVsUxYIFzCO3tKyI8Vj6iuQnCqMIvPUiq4Zo7nlxV6tD3wbv90VrWDHboQy1vSVEBpRWyahY0OL+EehJ7J/0JI52RVM9stL2KUgRQbn0Gv7MGdAGv/boRgtE+wJuM1X/FJrPrD8M78KP4M3zPrWwFxVrjE68P0Epi1g==
  jwtSecret: AgBCxHaT6iEgtKt/hgsd3if9PVWy/VmlBYqrlg9RP/nYWIi3nO46pht1zXHEzvakc8x3XgI9CJH4uRK8xjacYEpGRufYOTjQ0HfiugPPLemVBbum+p19FcGpOrUfkMB+DuGrYqIixgPfnp3xBsurcxfyHH+lHaAJrKn7Ob+othowrixXojA3SMSoQhdWM3JPzoUQ863/WU6Lyd3fWIbEpq0yreknI2sIV/Qe7NyO/Cf4RVZsILPb5D1V76ahIYgP1BED3AsGsMHLUYcxOGaaGp6QPAbR2Jewqk3PZKO3+W6vUpJkc9KPkaUQLdtSYkKtRexqYiSj2olt/oPLCttqR3RPBuVQ7IA3iZcePU4O3SZhTW2AIkrDqDQ5PgwTE/tWJQU1XWzStxLpohw0ZC4yHDYQzbAqbgpWM1V7xmHNXMc2xxS8ADD59uBfURIRVDzFos4q1GUwvHkJ5g6pE/1+I/ZDmxOJjUlOpb2pSzFw7uOEyp01EHo6S6b7yK8bFfEF/esC0yAsqe0eSqi9fFnUn4frBzEGkzuaR/ExwqLZK7VnACOjNyfwBHLdbhHZgwVEC7KleuUzphNJso5jQLWKceVnIpUY+0EVdAULeTW6Y6G6Nd5sgkxXyq1nZyL01KU6Oeq0aQboyCXJ/W4948+pu99mZ/cKi2pmxYQIyFFNU8t88rUcWEXAeeGBWdLzUADQIX+/NnhUDBpeB2SWj0W0zrsMAFKQ==
  objectStoreAccess: AgBfGvcl2chyxHyr3l2IRzlcPOL4zuzZT9N4yUdRhhrZ6duujrcaf8SaYIobd/RAcM3wFc93Bb5G71/USywIotuzHKGLCI4CUHnAWsk3OJBsq6sG6awn7gnpebJxVGd54h/HzQ+CiBmZFfyC+beuUX51OIKT13A6FTsZk4gZFGqYZwSB/og0gESlgnw3tyB4o6LiWdd9pRqRREHjwbcf8PF8P6FcWz9qqwoE2Bsq/1H7lAvUwoMRWNfUmiR7o7qU6qu7+ZWPBsmD4jLqdABuITAfqU89D2rvxOuliGw7OCybHX6RzLzmS/VZqjjQssGPRNbGs3EcH7gNGnED/23XVhJIXdVOR3JC/I30q3MAOZ3KswY3K1yHQ9KQW1/ePfrbuGs6Q643v2SU7wU25DGTe6/QF2GONV1vu9l5ufUMkabtACasauLwjTuq+WoYO3vSkHIkHcZT+TlPrKyVHnowGamY++ZCwd0oGQP6PVx1AmvhyMq3rjR+khv98po2lmhXBgbQckl3Qb+fmTqA7mgs9ZU8oHs4RK8rspdEiF19aZOjbzMFhVeoJ6+QhEFmAvRd8vkY25Vlb+4oanF+kG2YuK5Y++gmFNdsEU3UTHv+cS11dkr6WipItgm9xqtztepRE7R/y0RVCAv6Ca1zQA7DZfgmwIFtV+UusLhT6uu+Q9aq+SY/SzhRFJj2LGFvaccWWnSdH7p9zLMVYYbpTHLZj4MLWKca/g==
  objectStoreSecret: AgCNN/Na6Qc4TkoaSiT8ul/rpvLsJF3uD+klHkLsl99fny1pq1Y93OdbZXQlGSo5kgB9YEkg9dahzImDK2pHwDj4P68wHdVURkoJ4tEXC9cYivGu6wmXsoAVHXFtmydQRdEXKmS0cTaJ55MyJ9jyQ3D+8z5yJfqf1iEFX5Ln0ni9wuUK7mS4uzVLKp67+/WAWpEE2zxHLYGh8/+0p6iwcUbUjEBzB3tMiDGj3IFjWoh+Bf1iBqEs7iMs+c8/S6nxqpHOupYTlUSI21L3SmkY+kmLLcCbtV74knq+QBMVolnfuN5Gi49HqO5MmRDYFp1MHInEDJUGvhhM4gJz/sMH4Iv9IcU1huNcVAZSvq939hmQsuWiNldt+CvTwz7t3UqHrOkr4cQ0Ff+mDPKXspGxZlAGBPB0ISQjHik5PUZfTOF2h8dPvhuwK5L5kXu7qqt+WZVgVPG5n8f/4xTaDL57YtI0RoRGnR9Jm1Gh0WKqZM14ruSu9P1/DBnpYFIJc6iCqe8RDnGoNXolNYqXhWVEeebZUXtNKapInNsPDk6AWjDoelB5gXGuxgsWe5Vno7K6U5hTy5BVWKjZp2hG3YpvbdXSAQoDgWMYuLNaQ2mKLlk0evfW3i/b2erLwW8BLprJdeer/t0+GRJjLLBQ2e6okkp4Zj6+/6298TciPVqCHN+XEzURbAt3vGONi0GUSoQmAU5QrmxGLhFZkoITsvppfHcUjJ9Q== 
  smtp_password: AgA7GkEKBn31YIpeY2S2Eg/8JBEMr4kFYH8MHptVHkcLSWO6EbCLZ+lNYwE+pyTNwF87BWlt7x8jMR7WteXU+dlT0wOFiO0MiyrSyVUikvPwNWbxmE0ctd9JJwDXdSHJAYb9lBIc39Tu3CS8wGuCZqtpeJWl1CzbcAbbCIxx4YXqCA0Wd41cs/6zSvXh5vffTSehGICLDK9FStF3HO7xuhHv0H8PUPUogICUnm/uO8Muh7D5tt9u+9EHy0a6Qv86rUzfraOAq6pHaMntXVWum/ic71Ngf1Jb89KdwV2UxSfXx4+WhYSHYottaqV+8hXA7Ng43/kfQoqeoXNBwHO0LJEn5IwLyhvXfI7gglLboOztl4qC7qy//tqKRjmzH79CCdlNTUx7nchR6odCbOa0qbw0iHusUAlCMNGqVMOEllnzsZKverdlZwkoarqQ5jX0w3cNgVKvdQMGrCMNtxix/CLn0TAy1swh//okazTMwOaGBCXayqxggPbRfILx5pGI6OpV739LM98r0VR1sMKV78KdV3gfqh06L8RcOrZSdrAaLW+J6iAdAchdUqLPeDz077VWugzUEpO5FMo6ur3zGL9Nt2JkiaIqW58m+uzqapjxgTkwFuniSwZWBvtnahHdek3VSOl4sQ+uUbEA5/3IMGElyAMZpNqOgEu/4J6t605afqSc6D+r46hXon4wxrXd+/8yC7PItLDtUyo8ezQoo0j+N3PScXiyAKmgqx28NIfrWD3NvmpmZR9HEu5Q==
  smtp_username: AgCtHIr9E7VVjZ92Xx/BqeU00fYBgAH/f5RFwBcT0iUtG9ZAtDNX2HVfvotYxToyPCrMidgCDhn325vqfhdu669T6pX8FPF3HgvhDWbMLm0699kyFL6T8dl9+vVdPJFXCUtmuX73FAG6pFqVAecvBxTXW0ZfTDm3lK8aLlnf+SFgCyCRJESO8h2hYESmAUo8xvfh+C2y0Wq6tTOrlfcshmN+7a46HZtJ8LdaAJboc4R2V1B1GKLp9desU7w17i9kxG8vl2z7CQ555IHwfZQXA1DxekgD4lyBgXFH75yw8FvO2uoKDrBhPTlfbWYA/OBswlFoHPn6w4gddB7o8JHGEVTuDXE53vihGe4O8CuTBqcyFIDOXtJVD9feTrRupBexfNwH4+g3dwykKHCRY8NFUapkLM0UwNJjJ9LiJBqc0VtXs0FPECmd4djj1RnffOwSxK+88bCL9+XVhaHihyEkCizvStIKRrz6OXz7viMy0jSsi8T5oWqrpwXZ9n7eiPKW0Vo6PZpiW7DZnEANes1drRBFBv2rf8ZPdkoGe+jCrtyCdQObRVmtlGo70eZtWy9J4U+F6HGXeNYINNbxdKfcYDuG3kO86snHA058wZpjs+dj6avaZa7+rymxkrQq8QWRUyrmKJShHIyOqj/LqsqPGog1rN1ZjGkilCg5aewR5+2ayBowCP74h2SdsByMMEUWqJS1aSrd/s1f5mkOxwoV2uHNNlqQ==

ingress:
  nginx: false
  certificateArn: ""
  # className: "nginx-internal"
  annotations:
    kubernetes.io/ingress.class: 'nginx-internal'
  hosts:
    - host: budibase.dev.int.hcam.com
      paths:
      - path: /
        pathType: Prefix
        backend:
          service:
            name: proxy-service
            port:
              number: 10000     

# Override values in couchDB subchart
couchdb:

#   secretsCouchdb:
#     adminUsername: AgAUkYg6Q1uzgT85bneFS5qyTO/J5qKh7QKEJZrJDJpj1hfteld5NVj43qMRXL4L7pHoFZJs2p25mey3E55bHYQxYl1o7JE+kQBZSZS4dHh2PBqx3uXTggX40bQHMlnPqjTR0ScNCM7xi4ISYJHRnSA8nJKL9KjOFzfAmlrI35G96Vgt/xXPGT9I5RSk9YIBKBFGGHpV2c6XOQdBknh2xZYVs4Ad71QCmu9u5/ABSPSDGRTKuOrBgwpTcYSLqtMY5tl45jecC+oJB/mbVEuYx3k9iBRWIL8iEFwY4x9IrKbb2Xe1Ul8r9l9vjfuDerUtIw5iv00RwJfm5wDtCfdHQMW3v4NbmKknPvqY5LTbP3prDwe/Z0NZB5zCCvsNWR/uzWVboeWgdiZ3Xe1ahTrf1/WBKjiinWHQ2dfQQOebvqitX2l8wsiBbEhgsP4KuuUc88orbRnqHAEz6LGefUUHzPZzxcIWjzS+HWeiZAKanitPO3EGz5ucgYIWk1KnY/hzlsBaPhml3wiJoa15Udu1I+tYSDAjQfkZYYXzRIOBMrUpnTZWfVnPU5qMqLw2M81sFJfQxs+mMWn15uCzkiS69l1Cifst3lCEnUjrVOj2AGMn2VYJUrdNtKbWXgvo/HI6kRWBTWqImSBRN+gjn1aO7siG07KyQyfkfRVZ/xhrqoK0lpev+eyvsNhFj2cOWBHyj+T8uoT8UA==
#     adminPassword: AgAl98VhosDB8DaQdz0a6C6GS1RY2WSkLWnqhPjTBSwgai+QTbXFpMVwBtXV6aNSEqqRyuqKh505f35urTwMOQZeGtQXO1LmylDGFUEg3sYIoelkSJ5Hb2GhXH4wSprcJaAanXa96Nv81Hnz3Hdo5R7mxHorNWm5NgBg76a9NgI1X0Mudhqda14alTPe5lP62p8Y2kktO/SFVAjdgbHqjUZRbfKlACvth6VV6haPPhSj7BFtn+IGNWqAV4lJ9gCuLg7N+rdR2eEiTRE0SlflvVlaQ+CNLhtUxuqujEM1j4rII7h3PLKetS6R0loHqvbnYczU3JQLbSotdk11Pl+5T1uP38nHxixTJRvgycaQgyyL/ojFBmFIJj+HCdWHwczhen1xZ+mrGYj/371XWLUKWlNEvWRhEdXaJLrT3O/pWwfAl8p//zVlARaMiyEAoPhF80kEpIV0ApgbRsyclZIPZmRDY8YzrQpi7OK8A9YVuhNZdwdTZ4cZmcIS9lgavh90eAZl4B2bGNyQt3wVzDQWbC1WmGLQ8JL8hK0L0+Vtnk3OvuIRcZNpcjZh+HnN7xpXdK4q9cGlkuqQteMKSH7bOrM90e/ldecqY/m7HAcs+YAm1fNO+lI0VbSV69g+IrMRv6iaWiVOFezc1/3r+4/ZhZxrlXbVt3PNaOlgkg90cjexVbUHaEf7CkH98BRqeepIbcG72S43e9ZdgUUw5E1DLzkAo9s8Lw==
#     erlangCookie: AgB6GNnI/pHzBWE0p7szBPrpip4Sxe4ThTQVO6VtEwZFGIvstniB78PTkxxvvO5hGTT9gZ6koFMtGmxWxeTDTgXOWhiuzBkrR8pqhHlCrw7X3uM5m2fWXSqMiPkImHXZLLILiSmjGXAKHSFwN/TBuKXjzpAG4gdArgYsqXNLvIdk+ZTXwaQB3hwrFJVbqrpsddf+pyeyUSEiVsOevsBXipmKFM/rJoeaXO8yLNggPxJxdCcEAP5B/4+WqbojgCmdZCqM3wtT997P1Ju/lkCNmwU7ks3uriQCh4/w5N4Wc9jS7LxvsPyw92mZDLZEidZvuP1BbdXBb8u7M6iZeliZEv1GRfJoUyp3mdKCQGkF3W9A6LPi3ygiCZzSEF/CFgEUPo5DLZZbPqI7ngOWl2bJB7CtX7L2hDJWd/21q8GM+h+uo6x15KcxS+6TkHAd9hznqGe7WxabrDv4YpVvyI3fa0IjvWnco227OhOK0NgLSJWoQ1FXmrERXFy4Dle+abbEISPj//ggoJTi2uaRvcAmagU1iDrINYOazbVpzHvKjnsj6Ll7bM2RMr6z4+bAS1VJ42aUndd80FYz7ZhwseFJ94LRrZnzw5S4fzzxkIVZR/l40/i+qVI3HRLTygQ07eIJ6W6+OU2gRzfboxqEIxmgFTv4pCvdd+oC/mpMYMfxlrXMVlt6/O5N5Iy2l7p83p+xurlnEzh+Dlpr
#     cookieAuthSecret: AgBoAXeraalUBTYPTN+uG5hIj+ICuk+TABiRlMpQiR0J+pVmIBcwabItGirwg3r2OJ/GkfA2QF9CNp2yG5Bk+0QSxoaI+bp89yNKwpn49vc7yK5AimZQxLNzL7xgmnwlHm8zQ8eAuAWfvHdjIV9/waHGCrGVjQOAfUPL+LsSzWsTNFgqVRZ2FqqLyd4epQg/ED+FKAfh0v5wlAphz1Nyhu3OniOnB3LTtIBITCYqmah+vADHS+WfZGFVcmVqdEFMKDXBKumzh+/FtejmQ/2DxSa81XWWpM1AdRb94Qzjw6pPizNkLBx/4yrfFv7qMfrduPg9jqUvDQjs7EtApmV8qCOu3wKuaACh2sGzuinC7H9dg9BViHaO0qSlqEc151Wj+hlWLZzsYUfLt7po6zv2SmUwrF9NrBnvsXQuG+y3VerN4QVc8u3YoV/TB2BqZG42jLZT+mMRKPJbPH3yTSjzVmjr//qEH1wewiKkwuTVLlHiZhLdKmBuUH3vYL3dYVvaNtAyMSNxCCDM4GfUkLXLnrhHoticb0N8BlCUSpKvZy3en68Q/UkJ5T+0foToowJh5/3WcO859Gfm5S9Ox+vm+xrS+CXUb+xXLj3Dz2SDxkXZe61Bkgw4ySO0HsrnMC0G8j8vi0LJn2va0rKJrynqwN71T16j6axQipNp43p/N7taVuIowe/3wlczMeJ1Soiv8CBSgP8HV9W+6H8W/z3A3acB5EWyLQ==

  ## The storage volume used by each Pod in the StatefulSet. If a
  ## persistentVolume is not enabled, the Pods will use `emptyDir` ephemeral
  ## local storage. Setting the storageClass attribute to "-" disables dynamic
  ## provisioning of  Persistent Volumes; leaving it unset will invoke the default
  ## provisioner.
  persistentVolume:
    enabled: true

  # ## Optional resource requests and limits for the CouchDB container
  # ## ref: http://kubernetes.io/docs/user-guide/compute-resources/
  # resources:
  #   requests:
  #     cpu: 50m
  #     memory: 256Mi
  #   limits:
  #     cpu: 1
  #     memory: 400Mi

_BUDI-7516

[marcAnfuso]

Hello @melohagan

I found a solution. Just delete PVC and pod of CouchDB and then restart app-service pod, worker-service pod.
Or, the best solutions, delete PVCs and restart the complete deployment.

But, I have another problem now. Running the 2.10.8 version, I'm facing an issue when trying to load a table from a RDS MySQL DB. The error is: "Invalid Time value". What Can I do? Can you help me, please?
I know this table has more than one column with dates. But this same table was working fine on the first version of BudiBase (1.x).

Thank you.

[melohagan]

Hi @marcAnfuso

First make sure you are completely up-to-date, latest version is 2.10.10. There was a fix relating to an error like this very recently.

If that does not help, could you please provide some further information:

• SQL schema of your table
• Recording / screenshot of the reproduction

[marcAnfuso]

Hi @marcAnfuso

First make sure you are completely up-to-date, latest version is 2.10.10. There was a fix relating to an error like this very recently.

If that does not help, could you please provide some further information:

• SQL schema of your table
• Recording / screenshot of the reproduction

Thank you so much for your fast answer.

I upgraded to 2.10.10 just right now and the issue is still here.

SQL Schema of my table:

[melohagan]

Hey @marcAnfuso

Would you be able to open the console and network tabs (Fn+F12 on Chrome) and share any errors you find in there please?

[marcAnfuso]

Hey @marcAnfuso

Would you be able to open the console and network tabs (Fn+F12 on Chrome) and share any errors you find in there please?

Yes, of course!

There's just one error about "search":

[melohagan]

Thanks @marcAnfuso , and for that screenshot of the 500 error, could you also show me the contents of the 'Payload' and 'Response' tabs please?

[marcAnfuso]

Thanks @marcAnfuso , and for that screenshot of the 500 error, could you also show me the contents of the 'Payload' and 'Response' tabs please?

Yes! And I'll let you some errors that I found on the app-service pod, too.

Payload:

Response:

Errors in pod:

{"level":"INFO","timestamp":"2023-09-22T13:38:34.415Z","service":"@budibase/server","req":{"method":"GET","url":"/api/applications?status=all","correlationId":"5308904a-a8d8-46f6-9b81-ee692742924e"},"res":{"status":200},"responseTime":29,"msg":"request completed"} 6 {"level":"ERROR","timestamp":"2023-09-22T13:38:34.624Z","service":"@budibase/server","err":{"type":"Error","message":"missing","stack":"Error: missing\n at responseHandler (/app/dist/index.js:21327:24)\n at /app/dist/index.js:21517:17\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)","scope":"couch","statusCode":404,"request":{"method":"get","headers":{"content-type":"application/json","accept":"application/json","user-agent":"@budibase/nano/10.1.2 (Node.js v18.17.1)","Accept-Encoding":"deflate, gzip","Authorization":"Basic YWRtaW46dWRTQnFGS3RZZm95T2l1enU2dHY="},"qsStringifyOptions":{"arrayFormat":"repeat"},"url":"http://dev-budibase-svc-couchdb:5984/app_dev_ae571611bbb94c7397f0ad1420fe6f5b/deployments","paramsSerializer":{},"maxRedirects":0,"httpAgent":{"_events":{},"_eventsCount":2,"defaultPort":80,"protocol":"http:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{"dev-budibase-svc-couchdb:5984:":[{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0},{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0},{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0},{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0},{"connecting":false,"_hadError":false,"_parent":null,"_host":"dev-budibase-svc-couchdb","_closeAfterHandlingError":false,"_readableState":{"objectMode":false,"highWaterMark":16384,"buffer":{"head":null,"tail":null,"length":0},"length":0,"pipes":[],"flowing":true,"ended":false,"endEmitted":false,"reading":true,"constructed":true,"sync":false,"needReadable":true,"emittedReadable":false,"readableListening":false,"resumeScheduled":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"destroyed":false,"errored":null,"closed":false,"closeEmitted":false,"defaultEncoding":"utf8","awaitDrainWriters":null,"multiAwaitDrain":false,"readingMore":false,"dataEmitted":true,"decoder":null,"encoding":null},"_events":{},"_eventsCount":6,"_writableState":{"objectMode":false,"highWaterMark":16384,"finalCalled":false,"needDrain":false,"ending":false,"ended":false,"finished":false,"destroyed":false,"decodeStrings":false,"defaultEncoding":"utf8","length":0,"writing":false,"corked":0,"sync":false,"bufferProcessing":false,"writecb":null,"writelen":0,"afterWriteTickInfo":null,"buffered":[],"bufferedIndex":0,"allBuffers":true,"allNoop":true,"pendingcb":0,"constructed":true,"prefinished":false,"errorEmitted":false,"emitClose":false,"autoDestroy":true,"errored":null,"closed":false,"closeEmitted":false},"allowHalfOpen":false,"_sockname":null,"_pendingData":null,"_pendingEncoding":"","server":null,"_server":null,"parser":null,"_httpMessage":null,"timeout":0}]},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":5,"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}},"httpsAgent":{"_events":{},"_eventsCount":2,"defaultPort":443,"protocol":"https:","options":{"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]},"keepAlive":true,"maxSockets":50,"keepAliveMsecs":30000,"noDelay":true,"path":null},"requests":{},"sockets":{},"freeSockets":{},"keepAliveMsecs":30000,"keepAlive":true,"maxSockets":50,"maxFreeSockets":256,"scheduling":"lifo","maxTotalSockets":null,"totalSocketCount":0,"maxCachedSessions":100,"_sessionCache":{"map":{},"list":[]},"jar":{"version":"tough-cookie@4.1.2","storeType":"MemoryCookieStore","rejectPublicSuffixes":true,"enableLooseMode":false,"allowSpecialUseDomain":true,"prefixSecurity":"silent","cookies":[]}}},"headers":{"uri":"http://dev-budibase-svc-couchdb:5984/app_dev_ae571611bbb94c7397f0ad1420fe6f5b/deployments","statusCode":404,"cache-control":"must-revalidate","content-type":"application/json","date":"Fri, 22 Sep 2023 13:38:34 GMT","x-couch-request-id":"58afeba344","x-couchdb-body-time":"0"},"errid":"non_200","name":"Error","description":"missing","error":"not_found","reason":"missing","status":404},"pid":30,"tenantId":"default","appId":"app_dev_ae571611bbb94c7397f0ad1420fe6f5b","identityId":"us_f266e78cd48d49278fadada627189970","identityType":"user","correlationId":"eac939ae-df11-473b-9705-acf33adaf720","msg":""} 5 {"level":"INFO","timestamp":"2023-09-22T13:38:34.625Z","service":"@budibase/server","req":{"method":"GET","url":"/api/deployments","correlationId":"eac939ae-df11-473b-9705-acf33adaf720"},"res":{"status":200},"responseTime":29,"msg":"request completed"} 4 {"level":"INFO","timestamp":"2023-09-22T13:38:34.870Z","service":"@budibase/server","req":{"method":"GET","url":"/builder/fonts/source-sans-pro/files/source-sans-pro-latin-700-normal.woff2","correlationId":"a8ade316-8e35-4b78-842d-3678e746534c"},"res":{"status":200},"responseTime":11,"msg":"request completed"} 3 {"level":"INFO","timestamp":"2023-09-22T13:38:34.915Z","service":"@budibase/server","req":{"method":"GET","url":"/api/tables/datasource_plus_e86492856cca4697aa78510f54064c41__restapi_camera","correlationId":"98814ae4-8ecc-47ae-b073-0e1632baa336"},"res":{"status":200},"responseTime":64,"msg":"request completed"} 2 {"level":"ERROR","timestamp":"2023-09-22T13:38:35.492Z","service":"@budibase/server","err":{"type":"RangeError","message":"Invalid time value","stack":"RangeError: Invalid time value\n at Date.toISOString (<anonymous>)\n at processDates (/app/dist/index.js:160444:41)\n at ExternalRequest.outputProcessing (/app/dist/index.js:180199:25)\n at ExternalRequest.run (/app/dist/index.js:180465:29)\n at process.processTicksAndRejections (node:internal/process/task_queues:95:5)\n at async Object.search4 (/app/dist/index.js:180664:17)\n at async tryIncrement (/app/dist/index.js:155144:18)\n at async search7 (/app/dist/index.js:185011:14)\n at async /app/node_modules/koa-compress/lib/index.js:38:5\n at async errorHandling (/app/dist/index.js:146694:5)\n at async /app/node_modules/koa-mount/index.js:52:26\n at async userAgent (/app/node_modules/koa-useragent/dist/index.js:12:5)"},"pid":30,"tenantId":"default","correlationId":"238aeab1-cd36-40db-b1fc-5ec5153254e3","msg":""} 1 {

[melohagan]

Thanks @marcAnfuso this is very helpful. Still not able to reproduce, ideally could you provide me with the actual create script for your table.

This can easily be exported as shown here: https://docs.budibase.com/docs/troubleshooting-sql#exporting-your-schema

An insert statement for a problematic row would also be useful. It's possible that a date value is in an unexpected format in your database, or there's a non-date value that is incorrectly being cast as a date.

[marcAnfuso]

Thanks @marcAnfuso this is very helpful. Still not able to reproduce, ideally could you provide me with the actual create script for your table.

This can easily be exported as shown here: https://docs.budibase.com/docs/troubleshooting-sql#exporting-your-schema

An insert statement for a problematic row would also be useful. It's possible that a date value is in an unexpected format in your database, or there's a non-date value that is incorrectly being cast as a date.

Hi! I'm sorry for the delay. Here's the dump of the DB Schema:

MySQL-dump.sql.gz

[melohagan]

Hey @marcAnfuso tested the restapi_camera table and had no issues creating a row within Budibase.

Could you please provide an insert statement of a row that will reproduce the issue, or provide a screen recording of the exact steps required to reproduce the error toast.

[marcAnfuso]

Hey @marcAnfuso tested the restapi_camera table and had no issues creating a row within Budibase.

Could you please provide an insert statement of a row that will reproduce the issue, or provide a screen recording of the exact steps required to reproduce the error toast.

Hello! I ran this version on my PROD environment, with the Production Database and it doesnt crashes like on DEV.
So, I'm guessing that maybe some field NULL or with an incorrect value on dev invironment is causing this issue.

Do you still want to look around this?