Strange mysql errors in Apache Error log
I just updated to 3791 and I’m getting a lot of errors in my logs. It’s mostly the same few errors just over and over. I came upon these because my web interface is now painfully slow with no transfer speed graph, so I was looking for an explanation.
The one’s I’m concerned with are:
[Wed Jul 15 12:46:19.720780 2015] [:error] [pid 2859] [client 192.168.18.178:50999] PHP Warning: mysqli::query(): Couldn't fetch mysqli in /var/www/html/fog/lib/db/MySQL.class.php on line 59
[Wed Jul 15 12:38:11.719432 2015] [:error] [pid 4615] [client 192.168.36.151:56046] PHP Warning: mysqli::poll(): No stream arrays were passed in /var/www/html/fog/lib/db/MySQL.class.php on line 67
[Wed Jul 15 12:39:13.171305 2015] [:error] [pid 13853] [client 192.168.10.147:63836] PHP Warning: mysqli::mysqli(): (HY000/2002): Connection timed out in /var/www/html/fog/lib/db/MySQL.class.php on line 37 [Wed Jul 15 12:39:13.171392 2015] [:error] [pid 13853] [client 192.168.10.147:63836] PHP Warning: mysqli::query() expects parameter 2 to be long, string given in /var/www/html/fog/lib/db/MySQL.class.php on line 59
BFD: /var/www/html/fog/service/ipxe/bzImage: Warning: Ignoring section flag IMAGE_SCN_MEM_NOT_PAGED in section .bss
It looks to me like there is some miscommunication going on with MySQL, but I’m too unfamiliar with it all to know where to start looking. As far as I know all my DB stuff is correct.
OK thanks for the info. Doesn’t sound like anything major.
The couldn’t fetch errors might happen from time to time. This, and mind you I’m only guessing, is the link gets lost which is in part of why you’re seeing the mysqli::poll() errors.
The mysqli::poll() errors typically occur due to too many connections to the database. My guess is you could try correcting it by editing the /etc/mysql/my.cnf (or maybe /etc/my.cnf) and look for the [mysqld] portion, under it set something like max_connections = 100 and restart mysql. This should help alleviate the mysqli::poll() errors.
These next set of errors (mysqli::mysqli()/mysqli::query() are probably related to what I stated above.
The BFD: /var/www/html/fog/service/ipxe/bzImage: Warning: Ignoring section flag IMAGE_SCN_MEM_NOT_PAGED in section.bss is non-impacting at all. Usually you will see this on Debian based systems and it’s due to the calls made by FOG Configuration Page where it displays the kernels versions.
Your config is likely correct. Give the @Developers some time.