#4815 (ok 4.3.13) Infinite calls to index.php
After a brief period of inactivity, PMA makes an AJAX call to index.php once a second until either the server crashes or the page is updated somehow.
This wouldn't be a problem except that for whatever reason, if I leave PMA open over night or for an extended period of time, when I come back, it has borked my server so bad that I'm forced to reboot my computer to get it working again.
I'm not sure what the request is for, but I'm pretty sure it doesn't need to run once a second until the end of time, if at all.
If I'm not doing anything on the page, just leaving it open, there should be no reason to make any AJAX calls. I understand that PMA is not a dynamically updating application, nor do I wish it to be.
If you need any other info, please let me know.
Which version?
Sorry, 4.3.12. The latest one.
I selected the wrong milestone.
Define "brief".
What's the value of your LoginCookieValidity, both in your config.inc.php and in user preferences?
What's the value of your PHP session.gc_maxlifetime ?
What happens in my case if I set one of these to a small value like 10 seconds, is that index.php is called about 3 times, then my login panel is displayed.
"brief" is about ~20 minutes.
session.gc_maxlifetime = 1440
I don't know where user preferences are, but when I got to the Settings tab, it says I have no saved settings.
I also don't have that setting in my config file, so I'm assuming it's using a default value.
I've attached my config file for reference.
Here is the call and it's contents:
Request URL:http://phpmyadmin/index.php
Cookie:pma_lang=en; pma_collation_connection=utf8_general_ci; phpMyAdmin=36o37ga6ai1vqrosv9bnrifet5342t1p; pma_console_height=92; pma_console_config=%7B%22alwaysExpand%22%3Afalse%2C%22startHistory%22%3Afalse%2C%22currentQuery%22%3Atrue%2C%22enterExecutes%22%3Afalse%7D; pma_console_mode=collapse
Form Data:ajax_request=true&token=d052dd1319cbbc8625429197d31f18f4&db=&access_time=1438&_nocache=1427122538903450655
And here are the response contents (which I've never seen this have response contents before, usually it's empty, just a 200-OK code):
http://pastebin.com/dLy0f7hy
(pastebin contents expire in a month)
Also, I can refresh the page or click a link, and this issue goes away for another brief period, but if it gets left alone for any significant amount of time (overnight), when I come back, it says that my control user and password are invalid and won't let me log in until I reboot my computer, this also affect all other scripts running on my server that require MySQL, so it seems like it's crashing the MySQL server. It may also be affecting my network, as I can then no longer reliably hit outside websites, and when I do, it will throw 404 errors for many of the assets, like CSS files. I agree it sounds very odd that PMA on my machine would be affecting outside websites, but once I reboot, everything works fine again, and if I leave PMA open and it starts throwing errors, outside websites go wonky again, so it's an extreme coincidence if that's what it is.
Fixed with https://github.com/phpmyadmin/phpmyadmin/commit/db738687c64cc14b17234363fdf81b18050d345b
Note that the fix will be part of 4.3.13 and 4.4.1.