Error Exporting Data from Dashboard Statement Analysis

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: dashboard语句分析导出数据报错

| username: TiDBer_OzwiOwPc

[TiDB Usage Environment] Production Environment
[TiDB Version] 7.1.1
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Problem Symptoms and Impact] Error when exporting SQL statement analysis from the dashboard, Prometheus has been restarted

| username: TiDBer_嘎嘣脆 | Original post link

The session has expired, it seems like a login authentication error.

| username: 小龙虾爱大龙虾 | Original post link

Directly accessing this interface would result in an error, right? The dashboard can only be accessed after authentication, correct?

| username: DBAER | Original post link

The dashboard is deployed in etc. Which feature export is causing the error? Cluster inspection?

| username: tidb菜鸟一只 | Original post link

Are other functions of the dashboard working normally, and only this one page is abnormal?

| username: Soysauce520 | Original post link

Does the user not have permission?

| username: changpeng75 | Original post link

It should still be a permission issue without authentication.

| username: xiaoqiao | Original post link

Authentication

| username: 健康的腰间盘 | Original post link

Check the permissions.

| username: zhang_2023 | Original post link

It looks like a permission issue based on the error message.

| username: 友利奈绪 | Original post link

It looks like a permission issue based on the error message.

| username: TiDBer_OzwiOwPc | Original post link

The error occurs when exporting from the SQL statement analysis page. Where do I grant permissions for the root account? Does it need separate authorization? Are there any related posts? Thank you.

| username: tidb菜鸟一只 | Original post link

This does not require separate authorization.

| username: TiDBer_OzwiOwPc | Original post link

Yes, so now I don’t know how to successfully export it.

| username: 呢莫不爱吃鱼 | Original post link

Permission issue

| username: stephanie | Original post link

It looks like a permissions issue. Do you have more detailed logs?

| username: TiDBer_QYr0vohO | Original post link

Permission issue

| username: yidailatiao | Original post link

Permission issue