Processes tab hanging/freezing while displaying long queries

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.

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.

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)

Hi!

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

Thank you.

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.

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.

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.

Should be fixed in the next build.

Hi!

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