search

sudharsan-selvaraj / appium-dashboard-plugin

Appium plugin that provides complete test logs, video recording of test and device logs(logcat and syslogs) for easy debugging.
116 stars 28 forks source link

Random SQLITE_ERROR: unrecognized token while handling command #147

Open roirh opened 5 months ago

roirh commented 5 months ago

Hi I'm getting random errors when starting a session with appium. Usually it happens when calling the timeouts command just after creating the session.

Using the appium 2.5.1 with lastest version of this plugins:

[Appium] Welcome to Appium v2.5.1
[Appium] Non-default server args:
[Appium] { keepAliveTimeout: 800,
[Appium]   usePlugins: [ 'device-farm', 'appium-dashboard' ],

Error log:

6347348-[XCUITestDriver@a106 (5a852975)] Cached the protocol value 'W3C' for the new session 5a852975-f202-4bba-ba63-6fda4abab149
6347349-[XCUITestDriver@a106 (5a852975)] Responding to client with driver.createSession() result: {"capabilities":{"webStorageEnabled":false,"locationContextEnabled":false,"browserName":"","platform":"MAC","javascriptEnabled":true,"databaseEnabled":false,"takesScreenshot":true,"networkConnectionEnabled":false,"dashboard:name":"114-AUTs. Pin2Bankia. Psd2Postlogin Error de datos y firmar OK hasta dashboard","platformName":"IOS","automationName":"XCuiTest","forceAppLaunch":true,"app":"/tmp/qamigo/downloads/564c265dd0e81de36e632cdf72411265.ipa","noReset":true,"shouldTerminateApp":true,"eventTimings":true,"clearDeviceLogsOnStart":true,"nativeWebScreenshot":true,"udid":"00008030-001D09C43463802E","deviceName":"iPhone SE (2)","platformVersion":"17.3.1","wdaLocalPort":58884,"mjpegServerPort":58885,"derivedDataPath":"/Users/jenkins/Library/Developer/Xcode/DerivedData/WebDriverAgent-00008030-001D09C43463802E"}}
6347350-[HTTP] <-- POST /session 200 13767 ms - 877
6347351-[HTTP] 
6347352-[HTTP] --> POST /session/5a852975-f202-4bba-ba63-6fda4abab149/timeouts
6347353-[HTTP] {"implicit":500}
6347354-[device-farm-main] Updating lastCmdExecutedAt for device 00008030-001D09C43463802E in session 5a852975-f202-4bba-ba63-6fda4abab149
6347355-[XCUITestDriver@a106 (5a852975)] Calling AppiumDriver.timeouts() with args: [null,null,null,null,500,"5a852975-f202-4bba-ba63-6fda4abab149"]
6347356-[AppiumDriver@fd9e] Clearing new command timeout pre-emptively since plugin(s) will handle this command
6347357-[AppiumDriver@fd9e] Plugins which can handle cmd 'timeouts': device-farm,appium-dashboard
6347358-[AppiumDriver@fd9e] Plugin appium-dashboard is now handling cmd 'timeouts'
6347359-[AppiumDriver@fd9e] Command 'timeouts' was *not* handled by the following behaviours or plugins, even though they were registered to handle it: ["default","device-farm"]. The command *was* handled by these: ["appium-dashboard"].
6347360-[AppiumDriver@fd9e] Restarting new command timeout via umbrella driver since plugin did not allow default handler to execute
6347361:[XCUITestDriver@a106 (5a852975)] Encountered internal error running command: SQLITE_ERROR: unrecognized token: "'                AssetSignature = "MIIVIgYJKoZIhvcNAQcCoIIVEzCCFQ8CAQMxDTALBglghkgBZQMEAgEwCwYJKoZIhvcNAQcBoIIIYzCCAywwggLToAMCAQICCDDa+p0dunLbMAoGCCqGSM49BAMCMHIxJjAkBgNVBAMMHUFwcGxlIFN5c3RlbSBJbnRlZ3JhdGlvbiBDQSA1MSYwJAYDVQQLDB1BcHBsZSBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eTETMBEGA1UECgwKQXBwbGUgSW5jLjELMAkGA1UEBhMCVVMwHhcNMjMwMTI2MjMxNTE3WhcNMjQwMjI1MjMxNTE2WjBCMR4wHAYDVQQDDBVBc3NldCBSZWNlaXB0IFNpZ25pbmcxEzARBgNVBAoMCkFwcGxlIEluYy4xCzAJBgNVBAYTAlVTMFkwEwYHKoZIzj0CAQYIKoZIzj0DAQcDQgAEKZ1slvSfDjEqc4mmpBJLzRXu8AagbQrbvxpUg6/7bvmJ6NbpquXZaseQTHD1paF0IugNXbJckfmigmCbNjj47aOCAYEwggF9MAwGA1UdEwEB/wQCMAAwHwYDVR0jBBgwFoAUGGmk+b2NQ7xc7+IJ7/QLOiNp3nQwQQYIKwYBBQUHAQEENTAzMDEGCCsGAQUFBzABhiVodHRwOi8vb2NzcC5hcHBsZS5jb20vb2NzcDAzLWFzaWNhNTAxMIGWBgNVHSAEgY4wgYswgYgGCSqGSIb3Y2QFATB7MHkGCCsGAQUFBwICMG0Ma1RoaXMgY2VydGlmaWNhdGUgaXMgdG8gYmUgdXNlZCBleGNsdXNpdmVseSBmb3IgZnVuY3Rpb25zIGludGVybmFsIHRvIEFwcGxlIFByb2R1Y3RzIGFuZC9vciBBcHBsZSBwcm9jZXNzZXMuMDAGA1UdHwQpMCcwJaAjoCGGH2h0dHA6Ly9jcmwuYXBwbGUuY29tL2FzaWNhNS5jcmwwHQYDVR0OBBYEFIyuiGxkJLHiuTmL9MZwic5RsMIFMA4GA1UdDwEB/wQEAwIHgDAPBgkqhkiG92NkBj0EAgUAMAoGCCqGSM49BAMCA0cAMEQCIA21gosNZm4mDZ38XEd1gkwWbU/zy9uVNsZvbN8A8BUxAiA2RlGnnfDwfbxdBEhXWk9hWB9MTp7Yyas98KcK4bU5uTCCAugwggJtoAMCAQICCE8KG/NchBZYMAoGCCqGSM49BAMDMGcxGzAZBgNVBAMMEkFwcGxlIFJvb3QgQ0EgLSBHMzEmMCQGA1UECwwdQXBwbGUgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxEzARBgNVBAoMCkFwcGxlIEluYy4xCzAJBgNVBAYTAlVTMB4XDTE4MTEyODAwMTk0MFoXDTMzMTExNjAwMDAwMFowcjEmMCQGA1UEAwwdQXBwbGUgU3lzdGVtIEludGVncmF0aW9uIENBIDUxJjAkBgNVBAsMHUFwcGxlIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MRMwEQYDVQQKDApBcHBsZSBJbmMuMQswCQYDVQQGEwJVUzBZMBMGByqGSM49AgEGCCqGSM49AwEHA0IABCeg0nr9F513u2+djm9snR0xzLchYzqM3RC1aS2yPBfSfgB4AOaiL+ryulc8KxSAtQcywLvffX21AVQVR+zCqLejgfcwgfQwDwYDVR0TAQH/BAUwAwEB/zAfBgNVHSMEGDAWgBS7sN6hWDOImqSKmd6+veuv2sskqzBGBggrBgEFBQcBAQQ6MDgwNgYIKwYBBQUHMAGGKmh0dHA6Ly9vY3NwLmFwcGxlLmNvbS9vY3NwMDMtYXBwbGVyb290Y2FnMzA3BgNVHR8EMDAuMCygKqAohiZodHRwOi8vY3JsLmFwcGxlLmNvbS9hcHBsZXJvb3RjYWczLmNybDAdBgNVHQ4EFgQUGGmk+b2NQ7xc7+IJ7/QLOiNp3nQwDgYDVR0PAQH/BAQDAgEGMBAGCiqGSIb3Y2QGAgoEAgUAMAoGCCqGSM49BAMDA2kAMGYCMQCR/TB5S7mXRRXoBB9KQKm0wA9bFEaKJPvJjPY9hUNTcJSN9/K4Zb60DmvIFn3qvtYCMQDIgc/jp3Bz8DxcwrS0MUSjxAEguaa7hoG3PlyhEAZrEDYtiBsxi/kJeToRssMCzBAwggJDMIIByaADAgECAggtxfyI0sVLlTAKBggqhkjOPQQDAzBnMRswGQYDVQQDDBJBcHBsZSBSb290IENBIC0gRzMxJjAkBgNVBAsMHUFwcGxlIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MRMwEQYDVQQKDApBcHBsZSBJbmMuMQswCQYDVQQGEwJVUzAeFw0xNDA0MzAxODE5MDZaFw0zOTA0MzAxODE5MDZaMGcxGzAZBgNVBAMMEkFwcGxlIFJvb3QgQ0EgLSBHMzEmMCQGA1UECwwdQXBwbGUgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxEzARBgNVBAoMCkFwcGxlIEluYy4xCzAJBgNVBAYTAlVTMHYwEAYHKoZIzj0CAQYFK4EEACIDYgAEmOkvPUBypO2TInKBExzdEJXxxaNOcdwUFtkO5aYFKndke19OONO7HES1f/UftjJiXcnphFtPME8RWgD9WFgMpfUPLE0HRxN12peXl28xXO0rnXsgO9i5VNlemaQ6UQoxo0IwQDAdBgNVHQ4EFgQUu7DeoVgziJqkipnevr3rr9rLJKswDwYDVR0TAQH/BAUwAwEB/zAOBgNVHQ8BAf8EBAMCAQYwCgYIKoZIzj0EAwMDaAAwZQIxAIPpwcQWXhpdNBjZ7e/0bA4ARku437JGEcUP/eZ6jKGma87CA9Sc9ZPGdLhq36ojFQIwbWaKEMrUDdRPzY1DPrSKY6UzbuNt2he3ZB/IUyb5iGJ0OQsXW8tRqAzoGAPnorIoMYIMhTCCDIECAQOgFgQUjK6IbGQkseK5OYv0xnCJzlGwwgUwCwYJYIZIAWUDBAIBoGkwGAYJKoZIhvcNAQkDMQsGCSqGSIb3DQEHATAvBgkqhkiG9w0BCQQxIgQgV7pEDF2mhIbVcSpzTuOWUCTgcpXNCjFNBkN42dPMSiQwHAYJKoZIhvdjZAkDMQ8XDTA5MTAwODE4MzAwMFowCgYIKoZIzj0EAwIESDBGAiEAikPSh+s+FmIgyZXXMHbLJZnejD0Q4PxLvapmv1M3wUACIQD1eopH56gTyH/JNAbi0H6jtMuVwX7BKea6VLgsc1Gm86GCC5QwgguQBgsqhkiG9w0BCRACDjGCC38wggt7BgkqhkiG9w0BBwKgggtsMIILaAIBAzEPMA0GCWCGSAFlAwQCAQUAMG0GCyqGSIb3DQEJEAEEoF4EXDBaAgEBBgIqAzAxMA0GCWCGSAFlAwQCAQUABCCeZjvm05cIWHj3IomiFFc6vh4585wweiujmpxCneODLQIIORukQsMzrjIYDzIwMjMxMjA2MDAzNTA2WjADAgEBoIIIpjCCAkMwggHJoAMCAQICCC3F/IjSxUuVMAoGCCqGSM49BAMDMGcxGzAZBgNVBAMMEkFwcGxlIFJvb3QgQ0EgLSBHMzEmMCQGA1UECwwdQXBwbGUgQ2VydGlmaWNhdGlvbiBBdXRob3JpdHkxEzARBgNVBAoMCkFwcGxlIEluYy4xCzAJBgNVBAYTAlVTMB4XDTE0MDQzMDE4MTkwNloXDTM5MDQzMDE4MTkwNlowZzEbMBkGA1UEAwwSQXBwbGUgUm9vdCBDQSAtIEczMSYwJAYDVQQLDB1BcHBsZSBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eTETMBEGA1UECgwKQXBwbGUgSW5jLjELMAkGA1UEBhMCVVMwdjAQBgcqhkjOPQIBBgUrgQQAIgNiAASY6S89QHKk7ZMicoETHN0QlfHFo05x3BQW2Q7lpgUqd2R7X04407scRLV/9R+2MmJdyemEW08wTxFaAP1YWAyl9Q8sTQdHE3Xal5eXbzFc7SudeyA72LlU2V6ZpDpRCjGjQjBAMB0GA1UdDgQWBBS7sN6hWDOImqSKmd6+veuv2sskqzAPBgNVHRMBAf8EBTADAQH/MA4GA1UdDwEB/wQEAwIBBjAKBggqhkjOPQQDAwNoADBlAjEAg+nBxBZeGl00GNnt7/RsDgBGS7jfskYRxQ/95nqMoaZrzsID1Jz1k8Z0uGrfqiMVAjBtZooQytQN1E/NjUM+tIpjpTNu423aF7dkH8hTJvmIYnQ5Cxdby1GoDOgYA+eisigwggLeMIICZKADAgECAggE4ysL+gojATAKBggqhkjOPQQDAzBnMRswGQYDVQQDDBJBcHBsZSBSb290IENBIC0gRzMxJjAkBgNVBAsMHUFwcGxlIENlcnRpZmljYXRpb24gQXV0aG9yaXR5MRMwEQYDVQQKDApBcHBsZSBJbmMuMQswCQYDVQQGEwJVUzAeFw0xODExMjgwMDEwMzJaFw0zMzExMTYwMDAwMDBaMGkxHTAbBgNVBAMMFEFwcGxlIFRpbWVzdGFtcCBDQSAyMSYwJAYDVQQLDB1BcHBsZSBDZXJ0aWZpY2F0aW9uIEF1dGhvcml0eTETMBEGA1UECgwKQXBwbGUgSW5jLjELMAkGA1UEBhMCVVMwWTATBgcqhkjOPQIBBggqhkjOPQMBBwNCAATFBBzyFC1DMlvO00COa0xSGapDOFXDNvmAxGa6OlevXL2R5MFvu5/3JHbAf92iLeIzRSaIf/8UPrOJ/iaKldNeo4H3MIH0MA8GA1UdEwEB/wQFMAMBAf8wHwYDVR0jBBgwFoAUu7DeoVgziJqkipnevr3rr9rLJKswRgYIKwYBBQUHAQEEOjA4MDYGCCsGAQUFBzABhipodHRwOi8vb2NzcC5hcHBsZS5jb20vb2NzcDAzLWFwcGxlcm9vdGNhZzMwNwYDVR0fBDAwLjAsoCqgKIYmaHR0cDovL2NybC5hcHBsZS5jb20vYXBwbGVyb290Y2FnMy5jcmwwHQYDVR0OBBYEFFxluQ6mdNBo0z4D5YTEgHWLwRx4MA4GA1UdDwEB/wQEAwIBBj"
6347362-[XCUITestDriver@a106 (5a852975)] Error: 
6347363-[XCUITestDriver@a106 (5a852975)]     at Database.<anonymous> (/Users/jenkins/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:236:27)
6347364-[XCUITestDriver@a106 (5a852975)]     at /Users/jenkins/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:234:50
6347365-[XCUITestDriver@a106 (5a852975)]     at new Promise (<anonymous>)
6347366-[XCUITestDriver@a106 (5a852975)]     at Query.run (/Users/jenkins/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/sqlite/query.js:234:12)
6347367-[XCUITestDriver@a106 (5a852975)]     at /Users/jenkins/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/sequelize.js:650:28
6347368-[XCUITestDriver@a106 (5a852975)]     at processTicksAndRejections (node:internal/process/task_queues:95:5)
6347369-[XCUITestDriver@a106 (5a852975)]     at SQLiteQueryInterface.bulkInsert (/Users/jenkins/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/dialects/abstract/query-interface.js:881:21)
6347370-[XCUITestDriver@a106 (5a852975)]     at recursiveBulkCreate (/Users/jenkins/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/model.js:2851:25)
6347371-[XCUITestDriver@a106 (5a852975)]     at Function.bulkCreate (/Users/jenkins/.appium/node_modules/appium-dashboard/node_modules/sequelize/src/model.js:2977:12)
6347372-[HTTP] <-- POST /session/5a852975-f202-4bba-ba63-6fda4abab149/timeouts 500 216 ms - 10820
6347373-[HTTP] 
6347374-[XCUITestDriver@c153 (51263b35)] Got response with status 200: {"value":null,"sessionId":"01F6AAEC-86D2-4BBF-BD02-AAF5193FA19E"}
6347375-[HTTP] --> GET /session/5a852975-f202-4bba-ba63-6fda4abab149/screenshot
6347376-[HTTP] {}