Replies: 14 comments
-
cc @dain |
Beta Was this translation helpful? Give feedback.
-
This config work for me, version 334
|
Beta Was this translation helpful? Give feedback.
-
@tchunwei I want multiple LDAP users to access the UI not just single user |
Beta Was this translation helpful? Give feedback.
-
in v1/jmx/mbean i can see QueuedQueries and RunningQueries but nothing about BlockedQueries |
Beta Was this translation helpful? Give feedback.
-
Cluster stats were added only for the UI, and are considered a private detail of the web UI. As part of the recent web UI changes all of the internal details of the UI were moved under the I would suggest that a new interface be designed for what is needed instead of starting with the stuff we added to make the UI look good :) |
Beta Was this translation helpful? Give feedback.
-
We had some automation to bring down the cluster , based on the information available in /v1/cluster. Seems/v1/cluster end point is moved to /ui/api/stat and we are unable to access the /ui/api/stat from any automation jobs due to 401. |
Beta Was this translation helpful? Give feedback.
-
right, would be nice to have a 'breaking changes' section in the release notes! |
Beta Was this translation helpful? Give feedback.
-
+1 on a breaking changes section of the release notes, this is a problem for anyone using the open source Presto helm chart which uses the Do any presto devs have a suggested endpoint to use as a healtcheck instead? @dain Preferably something that would not require auth. edit: asked in slack, and |
Beta Was this translation helpful? Give feedback.
-
Exactly. And since #3428 |
Beta Was this translation helpful? Give feedback.
-
The older version of prestosql (pre-trino) we use in some clusters still has crappy stats for queued queries/etc in prometheus. But the web UI works. I wrote this in bash which can mine out the metrics for anyone else who needs to do the same. Good enough to dump some info to a text file for a prometheus exporter or whatever. % COOKIE_VALUE=$(curl --location --request POST 'https://some.cluster.com/ui/login' \
--data-urlencode 'username=john.humphreys' \
--data-urlencode 'password=<password>' --cookie-jar - --output /dev/null --silent | awk '{print $7}' | tail -1l)
curl 'https://some.cluster.com/ui/api/stats' -H $''"Cookie: Presto-UI-Token=$COOKIE_VALUE"'' | jq --color-output
{
"runningQueries": 8,
"blockedQueries": 0,
"queuedQueries": 0,
"activeCoordinators": 1,
"activeWorkers": 35,
"runningDrivers": 3957,
"totalAvailableProcessors": 2450,
"reservedMemory": 2770000473,
"totalInputRows": 1133212564136,
"totalInputBytes": 10872687401451,
"totalCpuTimeSecs": 777021
} |
Beta Was this translation helpful? Give feedback.
-
@johnwhumphreys Thanks for your reply and I fixed it the same way. |
Beta Was this translation helpful? Give feedback.
-
@johnwhumphreys Thanks for your good idea. New version Trino need to replace Presto-UI-Token with Trino-UI-Token |
Beta Was this translation helpful? Give feedback.
-
I am also using the snippet from @johnwhumphreys but Trino should definitely expose a "stable" endpoint to get query state instead of querying the UI endpoints. We need this to properly implement graceful shutdown for coordinators using the https://github.com/lyft/presto-gateway. |
Beta Was this translation helpful? Give feedback.
-
Just in case its useful to someone trino now has metrics exporting build it, at time of writing some of the metrics appear to be missing but @mattstep assures us that a fix for this is coming soon Details in comments here: |
Beta Was this translation helpful? Give feedback.
-
Previously could do a curl to v1/cluster and get a response like:
Now the endpoint has changed to ui/api/stats, it works fine for interactive user in the browser (after going via form login page), but non-interactive commands by generic user (with valid credentials) are blocked :(
Can below code be removed?
https://github.com/prestosql/presto/blob/master/presto-main/src/main/java/io/prestosql/server/ui/FormWebUiAuthenticationManager.java#L141-L146
Update: even commenting out that block did not solve it :(
Beta Was this translation helpful? Give feedback.
All reactions