Appium Dashboard and device farm crashes frequently

[samagarw]

Appium server is crashing frequently with the following logs :

^[[38;5;16m[appium-dashboard]^[[0m Unable to save http logs in database
^[[38;5;16m[appium-dashboard]^[[0m Unable to save http logs in database
^[[38;5;16m[appium-dashboard]^[[0m Error:
^[[38;5;16m[appium-dashboard]^[[0m at Database. (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:227:27)
^[[38;5;16m[appium-dashboard]^[[0m Error:
^[[38;5;16m[appium-dashboard]^[[0m at Database. (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:227:27)
^[[38;5;16m[appium-dashboard]^[[0m at /Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:225:50
^[[38;5;16m[appium-dashboard]^[[0m at new Promise ()
^[[38;5;16m[appium-dashboard]^[[0m at Query.run (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:225:12)
^[[38;5;16m[appium-dashboard]^[[0m at /Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/sequelize.js:649:28
^[[38;5;16m[appium-dashboard]^[[0m at /Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:225:50
^[[38;5;16m[appium-dashboard]^[[0m at new Promise ()
^[[38;5;16m[appium-dashboard]^[[0m at Query.run (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:225:12)
^[[38;5;16m[appium-dashboard]^[[0m at /Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/sequelize.js:649:28
^[[38;5;16m[appium-dashboard]^[[0m at SQLiteQueryInterface.bulkInsert (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/abstract/query-interface.js:881:21)
^[[38;5;16m[appium-dashboard]^[[0m at recursiveBulkCreate (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/model.js:2803:25)
^[[38;5;16m[appium-dashboard]^[[0m at SQLiteQueryInterface.bulkInsert (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/abstract/query-interface.js:881:21)
^[[38;5;16m[appium-dashboard]^[[0m at recursiveBulkCreate (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/model.js:2803:25)
^[[38;5;16m[appium-dashboard]^[[0m at Function.bulkCreate (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/model.js:2929:12)
^[[38;5;16m[appium-dashboard]^[[0m at Function.bulkCreate (/Users/mobilelab/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/model.js:2929:12)

Also getting session is either terminated :

debug] [AppiumDriver@7e7b] Encountered internal error running command: NoSuchDriverError: A session is either terminated or not started
[debug] [AppiumDriver@7e7b] at asyncHandler (/Users/mobilelab/.nvm/versions/node/v18.7.0/lib/node_modules/appium/node_modules/@appium/base-driver/lib/protocol/protocol.js:268:15)
[debug] [AppiumDriver@7e7b] at /Users/mobilelab/.nvm/versions/node/v18.7.0/lib/node_modules/appium/node_modules/@appium/base-driver/lib/protocol/protocol.js:462:15
[debug] [AppiumDriver@7e7b] at Layer.handle [as handle_request] (/Users/mobilelab/.nvm/versions/node/v18.7.0/lib/node_modules/appium/node_modules/express/lib/router/layer.js:95:5)
[debug] [AppiumDriver@7e7b] at next (/Users/mobilelab/.nvm/versions/node/v18.7.0/lib/node_modules/appium/node_modules/express/lib/router/route.js:144:13)
[debug] [AppiumDriver@7e7b] at Route.dispatch (/Users/mobilelab/.nvm/versions/node/v18.7.0/lib/node_modules/appium/node_modules/express/lib/router/route.js:114:3)
[debug] [AppiumDriver@7e7b] at Layer.handle [as handle_request] (/Users/mobilelab/.nvm/versions/node/v18.7.0/lib/node_modules/appium/node_modules/express/lib/router/layer.js:95:5)
[debug] [AppiumDriver@7e7b] at /Users/mobilelab/.nvm/versions/node/v18.7.0/lib/node_modules/appium/node_modules/express/lib/router/index.js:284:15
[debug] [AppiumDriver@7e7b] at param

Is there a way we can point to external data base instead of sqlite ?