Processes tab hanging/freezing while displaying long queries

tnovak's profile image tnovak posted 4 weeks ago in General Permalink

Hi!

In latest builds I'm experiencing weird issue with Processes tab. It was OK some time before 12.7 release. Long queries are not displayed in Info column and entire program is freezing/hanging for several seconds while rendering the tab.

Description

The tooltip (when hovering mouse over it) correctly shows query preview. And Process SQL window is displaying the query correctly too.

So the problems are the hanging/freezing and empty Info column.

Thank you.

ansgar's profile image ansgar posted 4 weeks ago Permalink

I already pushed a change after the 12.7 release which could probably fix something here. Please try with the latest build (Help > Check for updates > Download and install build xyz)

tnovak's profile image tnovak posted 4 weeks ago Permalink

Hi!

I'm sorry, but this report is from (I think) last build, 12.7.0.6858.

Thank you.

ansgar's profile image ansgar posted 4 weeks ago Permalink

Yes, 6858 is currently the latest, and has my commit:6e9be764fd965da021b2187dc5fd93d29aba791c.

If that's still an issue in the processlist, there is probably some different issue.

Do you have any information about the long query, or about its length? If I should have a look at that I will need to reproduce.

tnovak's profile image tnovak posted 4 weeks ago Permalink

Hi!

The affected queries are usually very long, more then 50000 characters.

Actually it's from database used by gallery software Piwigo where is many images and so lot of items for example in IN ():

SELECT 'piwigo_images'.* FROM 'piwigo_categories' INNER JOIN 'piwigo_image_category' ON 'category_id' = 'piwigo_categories'.'id' INNER JOIN 'piwigo_images' ON image_id = 'piwigo_images'.'id' WHERE image_id = 3021263 AND (category_id NOT IN (270,323,325,390,391,471,473,509,512,513,514,515,516,517,518,519,520,521,522,523,524,525,526,527,528,529,530,531,532,533,534,535,536,537,538,539,541,542,543,544,545,546,547,548,611,871,920,980,1079,1080,1203,1761,1762,1763,1764,1765,1766,1767,1777,1779,1780,1781,1782,1783,1786,1787,1790,1791,1793,1794,1795,1796,1797,1798,1809,1817,1818,1820,1829,1831,1842,1853,1864,....,222055);

I don't expect to see entire query, but now I can't use the Processes tab anymore, because every F5 while some long query is running freezes the program.

Thank you.

tnovak's profile image tnovak posted 4 weeks ago Permalink

Hi! The commit is maybe really involved. But, not as a fix, but as a cause of the bug... Because I now tested previous build 6850 and it's OK... And build 6851 is hanging...

Thank you.

Code modification/commit d383089 from Ansgar Becker <anse@heidisql.com>, 4 weeks ago, revision 12.7.0.6859
Issue #1897: initialize nodes with vsMultiLine only if toGridExtensions option is set, so the host subtabs do not suffer from other bugs. See https://www.heidisql.com/forum.php?t=42191
ansgar's profile image ansgar posted 4 weeks ago Permalink

Should be fixed in the next build.

tnovak's profile image tnovak posted 4 weeks ago Permalink

Hi!

Thank you, it's fixed now! (in 6859)

Please login to leave a reply, or register at first.