TiDB Dashboard SQL Statement Analysis Function Error

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

Original topic: TiDB Dashboard SQL语句分析功能报错

| username: magdb

[TiDB Usage Environment] Production Environment
[TiDB Version] v7.1.1
[Reproduction Path] Operations performed that led to the issue
[Encountered Issue: Symptoms and Impact]
Login to Dashboard → SQL Statement Analysis reports an error
Errors

  • Error 1105 (HY000): runtime error: invalid memory address or nil pointer dereference
  • common.bad_request

[Resource Configuration]

[Attachments: Screenshots/Logs/Monitoring]
PD logs are as follows

| username: Fly-bird | Original post link

Check the cluster status in tiup and restart the monitoring.

| username: magdb | Original post link

Is restarting the monitoring the same as restarting the PD node?

| username: 有猫万事足 | Original post link

I suggest referring to this. Check if directly querying INFORMATION_SCHEMA.CLUSTER_STATEMENTS_SUMMARY_HISTORY also results in an error.

If it does, I recommend saving the execution site information and submitting a bug issue on GitHub. Wait for further resolution.

| username: magdb | Original post link

Yes, executing this SQL also reports ERROR 1105 (HY000): runtime error: invalid memory address or nil pointer dereference.

| username: zhanggame1 | Original post link

In the tiup cluster tidb-test display, there is a PD with a status of L. You can restart it using tiup cluster restart tidb-test -N IP:2379.

| username: magdb | Original post link

Do you know in which version this bug is fixed? :joy:

| username: 有猫万事足 | Original post link

I’m not very sure either, I couldn’t find the issue number.

| username: magdb | Original post link

Okay, thank you :pray:

| username: srstack | Original post link

You can try upgrading to 7.1.2 and see~

| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.