prestodb / presto

The official home of the Presto distributed SQL query engine for big data
http://prestodb.io
Apache License 2.0
15.92k stars 5.33k forks source link

TestQueryManager.testQueryCountMetrics hangs #23365

Open rschlussel opened 1 month ago

rschlussel commented 1 month ago

2024-08-02T00:51:41.9099942Z com.facebook.presto.tests.TestQueryManager::testQueryCountMetrics() running for 35.65m. Full thread dump in the logs: https://productionresultssa15.blob.core.windows.net/actions-results/7e268ee1-ca23-42bb-9e3d-22ff28b5bbe9/workflow-job-run-a127d11a-9747-58b9-8901-2782a89a30d7/logs/job/job-logs.txt?rsct=text%2Fplain&se=2024-08-02T13%3A54%3A26Z&sig=7P%2FSnuMMxM68zoxx35ywjuImrbn5XA4nwZIgc%2Fj2tg8%3D&ske=2024-08-02T23%3A28%3A03Z&skoid=ca7593d4-ee42-46cd-af88-8b886a2f84eb&sks=b&skt=2024-08-02T11%3A28%3A03Z&sktid=398a6654-997b-47e9-b12b-9515b896b4de&skv=2024-05-04&sp=r&spr=https&sr=b&st=2024-08-02T13%3A44%3A21Z&sv=2024-05-04

misterjpapa commented 1 month ago

@rschlussel - could your system clock have been wrong when running the tests? The full error log shows AuthenticationFailed

Server failed to authenticate the request. Make sure the value of Authorization header is formed correctly including the signature. RequestId:fa0a0dc9-801e-003d-4b7e-e77ec7000000 Time:2024-08-05T21:30:30.2962947Z Signature not valid in the specified time frame: Start [Fri, 02 Aug 2024 13:44:21 GMT] - Expiry [Fri, 02 Aug 2024 13:54:26 GMT] - **Current [Mon, 05 Aug 2024 21:30:30 GMT]**

which would indicate that the request was made to authenticate with a timeframe that was more than 3 days in advance of running the test.

rschlussel commented 1 month ago

I should have copied out the full error log, the log retention must have expired, so the link doesn't work anymore.

misterjpapa commented 1 month ago

I should have copied out the full error log, the log retention must have expired, so the link doesn't work anymore.

That makes more sense. If you see the failure again, you can copy the full error log so folks can debug.