[MXS-4365] Query tab is going infinite loop, unable to use the query tab after the infinite loop Created: 2022-10-25  Updated: 2022-11-08  Resolved: 2022-11-08

Status: Closed
Project: MariaDB MaxScale
Component/s: maxgui
Affects Version/s: 22.08.2
Fix Version/s: 22.08.3

Type: Bug Priority: Major
Reporter: Naresh Chandra Assignee: Duong Thien Ly
Resolution: Fixed Votes: 0
Labels: None

Attachments: PNG File image-2022-10-25-08-53-40-998.png    
Sprint: MXS-SPRINT-170

 Description   

When we run a query without selecting the schema then query tab is going into loop and unable use the query tab to run the queries again in the same tab.

Reproducing steps:
1. Don't select any schema.
2. Type one select query any, ex: select * from test.
3. Run query more than four or five times.
4. Try to stop/run the query randomly more than five times.
5. Somewhere after 4 or 5 times then we are seeing the below error.

NOTE: After the infinite loop, even we are unable to close the query tab.

 Comments   
Comment by Duong Thien Ly [ 2022-10-26 ]

I can reproduce this by running and stopping the query intensively and fastly.

You see the 404 error is because before the query is run, it sends a request to create a new query thread and uses that thread to stop the running query.
I believe under normal circumstances, this wouldn't be a problem. However, on second thought, we can improve this.

Comment by Duong Thien Ly [ 2022-10-26 ]

I can't reproduce the latter error. i.e. to close the query tab. I can close it normaly.

Comment by Naresh Chandra [ 2022-10-26 ]

I got it Duong, but at least GUI should be improved, why because the stop/start button is simply rotating and not useful.

No, I was unable to close the query tab after the infinite loop.

Comment by Naresh Chandra [ 2022-11-01 ]

Duong, Today observed that even I select schema and I tried to run/stop query more than thrice, and the query tab went into loop. But able to close the query tab even though it's in loop.

Conclusion:
1. Without selecting schema: Tab going to infinite loop but unable to close the tab.
2. With selecting schema: Tab going to infinite loop and able to close the tab.

Comment by Duong Thien Ly [ 2022-11-01 ]

Okay, thanks for the information. Would that happens if you wait for a few seconds before running/stopping the query again?
If you're doing it too fast, you'll see the loop, but if you give break time between sessions, it won't happen. Until we fix this, that's the workaround.

Comment by Naresh Chandra [ 2022-11-01 ]

Okay got it Duong, Thanks for the update.

Generated at Thu Feb 08 04:28:06 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.