Ensure APCu functions have been enabled in your PHP install

@derrickhand300
6 years ago
1,353 posts

Hello- I was just in System update and saw the following error which i have never seen before
I have contacted my server to check this- just wondering if its something that came out with the new core and what it means?
Everything on the site seems to be working fine despite this error so i was curious
Thanks

updated by @derrickhand300: 06/02/18 11:59:07PM

@derrickhand300
6 years ago
1,353 posts

Its kinda weird...my performance check awhile back was 2600...now its 151 and none of the data for "users online" is showing up?
Otherwise despite these numbers the site is still lightning fast just as it was when it was at 2600

updated by @derrickhand300: 03/02/18 10:34:06AM

@ukdenny
6 years ago
304 posts

I hadthe same error and contacted my server who fixed it for me. I provided them with a link that Jamroom gave me
http://us2.php.net/manual/en/function.apcu-add.php
I have just installed another site with the same issue and they fixed that for me also.

@brian
6 years ago
10,148 posts

derrickhand300:
just wondering if its something that came out with the new core and what it means?
Everything on the site seems to be working fine despite this error so i was curious

It's optional, but helpful to get it installed. APCu provides a small, persistent "RAM cache" on the server that Jamroom will use for the locks that it needs when managing multiple processes (mainly around the queue system). I'd recommend getting the APCu support installed if you can - it will help a bit on your site if you get slammed with 25,000 viewers again

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Great Brian- thanks! ( i want 50,000 this time)

@derrickhand300
6 years ago
1,353 posts

ukdenny:
I hadthe same error and contacted my server who fixed it for me. I provided them with a link that Jamroom gave me
http://us2.php.net/manual/en/function.apcu-add.php
I have just installed another site with the same issue and they fixed that for me also.

Thank you!

@derrickhand300
6 years ago
1,353 posts

@brian
My performance check is still down in the 100 range...site is really fast...keeps showing Mysql scores in the 30's
with the site working so fast just seems like it cant be correct- any thoughts on this?

@derrickhand300
6 years ago
1,353 posts

Also- the server just enabled the APCu function...now if you look at the System Check- the actual check is completely missing
Does this only show up in the check if there is an error/

@derrickhand300
6 years ago
1,353 posts

I just cleared the error log- then ran a complete integrity check- then returned to the error log- thought posting it might be helpful



[02-Mar-2018 13:06:15 America/Tegucigalpa] PHP Notice: Undefined offset: 1 in /home/rough/public_html/modules/jrInject-release-1.0.0/include.php on line 58 [27]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined offset: 0 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 53 [2]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined offset: 0 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 117 [2]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined offset: 0 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 148 [6]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined offset: 1 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 53 [2]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined offset: 1 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 117 [2]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined offset: 1 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 148 [2]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined index: st in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^bb2e021a90edfa8e2433692d4ac5d9f986191c02_1.file.895226f6986bf5ac2d5e79cf2b858e40^xxrnc^header.tpl.php on line 120 [2]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Trying to get property of non-object in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^bb2e021a90edfa8e2433692d4ac5d9f986191c02_1.file.895226f6986bf5ac2d5e79cf2b858e40^xxrnc^header.tpl.php on line 120 [2]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined index: _children in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^339e3faecba99fff9a6a2aa73e085d17a62216e7_1.file.6f9c2e87d63833c1934b3da325faa91e^jrSiteBuilder^menu.tpl.php on line 40 [12]
[02-Mar-2018 13:06:44 America/Tegucigalpa] PHP Notice: Undefined index: _children in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^339e3faecba99fff9a6a2aa73e085d17a62216e7_1.file.6f9c2e87d63833c1934b3da325faa91e^jrSiteBuilder^menu.tpl.php on line 58 [22]
[02-Mar-2018 13:10:33 America/Tegucigalpa] PHP Notice: Undefined offset: 2 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 53 [1]
[02-Mar-2018 13:10:33 America/Tegucigalpa] PHP Notice: Undefined offset: 2 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 117 [1]
[02-Mar-2018 13:10:33 America/Tegucigalpa] PHP Notice: Undefined offset: 2 in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^ad688249a4fae03fb983fcd631804101d96b9ceb_1.file.b745c9fd695fcbdc841c926acc385e42^jrSiteBuilder^page_row_column.tpl.php on line 148 [4]
[02-Mar-2018 13:10:33 America/Tegucigalpa] PHP Notice: Undefined index: module_url in /home/rough/public_html/data/cache/xxrnc/bc34165f88b89f9cda9eb705aff5ed62^339e3faecba99fff9a6a2aa73e085d17a62216e7_1.file.6f9c2e87d63833c1934b3da325faa91e^jrSiteBuilder^menu.tpl.php on line 28 [9]

updated by @derrickhand300: 03/02/18 11:13:52AM

@derrickhand300
6 years ago
1,353 posts

Just noticed
Memory used- 5 minute load and users online are also not working? and performance check is around 150
here is another screenshot

Black-Eagle
@black-eagle
6 years ago
57 posts

derrickhand300:
@brian
My performance check is still down in the 100 range...site is really fast...keeps showing Mysql scores in the 30's
with the site working so fast just seems like it cant be correct- any thoughts on this?

Hello.
I have the same problem on my website.
;(

@derrickhand300
6 years ago
1,353 posts

Black-Eagle:

derrickhand300:
@brian
My performance check is still down in the 100 range...site is really fast...keeps showing Mysql scores in the 30's
with the site working so fast just seems like it cant be correct- any thoughts on this?

Hello.
I have the same problem on my website.
;(

Thank you

Black-Eagle
@black-eagle
6 years ago
57 posts

The database is slowest ?

@brian
6 years ago
10,148 posts

derrickhand300:
I just cleared the error log- then ran a complete integrity check- then returned to the error log- thought posting it might be helpful

[02-Mar-2018 13:06:15 America/Tegucigalpa] PHP Notice: Undefined offset: 1 in /home/rough/public_html/modules/jrInject-release-1.0.0/include.php on line 58 [27]

These are just notices - you should NOT see these - make sure you are not running in Developer Mode.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@brian
6 years ago
10,148 posts

Black-Eagle:
The database is slowest ?

Yeah that is a pretty bad DB score. As long as caching is enabled it will help, but ultimately if it stays that slow your site will be slow.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@brian
6 years ago
10,148 posts

derrickhand300:
Also- the server just enabled the APCu function...now if you look at the System Check- the actual check is completely missing
Does this only show up in the check if there is an error/

Correct - you only see the notice if it is not working.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Thanks brian...I just checked-I am not running in developer mode...the server is working fine as far as speed (performance check has been broke a few weeks) Now i notice other monitoring stuff not working
In the dashboard
1- 5 Minute Load does not work
2-Users online does not work
3- memory Used does not work

The site is extremely fast despite these scores in the 100 range over the last 2 weeks- here is a screenshot from the ACPu cache- everything look ok there?

Also here is a screenshot the day it crashed...see the one on bottom that is around 2200? Well i ran one after that which for some reason is not displaying here- it was 2600+...then a few minutes later i ran it again and i was in the 200's...I think 2600+ tach'ed out the performance monitor and thrashed it

Anyway something happened all at once...but the site continues to run at the same pace as the 2600 test even though most the performance monitor stuff is broke...so its not a critical issue- just the tools are not working- sites running fine

updated by @derrickhand300: 03/02/18 01:11:09PM

@derrickhand300
6 years ago
1,353 posts

My DB is v 5.6.38
do you happen to have a set of values as a txt file or something that can be submitted to the managed server to optimise this version for jamroom?
I once updated to maria DB and Litespeed...then after an update to one of them it crashed my site and the server could nt resolve it-they are waiting for the next updated version of them to come out so they can reinstall and test..
updated by @derrickhand300: 03/02/18 01:15:54PM

@derrickhand300
6 years ago
1,353 posts

brian:

Black-Eagle:
The database is slowest ?

Yeah that is a pretty bad DB score. As long as caching is enabled it will help, but ultimately if it stays that slow your site will be slow.

When i hit 2600 and everything broke my DB score was aunder "3"..now its over 30. even though i am not aware of ANY server changes...thats whats throwing me off...I dont do much on my fully managed server...and they dont do much unless i ask...so its strange
updated by @derrickhand300: 03/02/18 01:28:44PM

@brian
6 years ago
10,148 posts

Something has changed on your server - if you're not seeing the load values anymore, then it means that the system() function call is no longer working (or being blocked). I have a feeling a server update might have been performed on your server - I would double check with your hosting provider. Nothing has changed in regards to the load levels in the dashboard in a really long time, so if that just stopped working then something on the server changed.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Thanks for that Brian as i troubleshoot.
I just updated mysql to maria DB 10.1.xx
and upgraded to Litespeed
Moving to maria DB my score went from 30 to 42 ( should be around a 3)
Would this likely indicate my problems are in my PHP settings?
Sorry Im confused and trying to figure out how this works...My thinking was that if i move completely from mysql to mariaDB and that does not fix the prob then maybe its not on the server end?

@derrickhand300
6 years ago
1,353 posts

The size of my homepage is WAY over whats considered the correct size at almost 4 MB...but still I get a speed score of 78 at pingdom tools with my server settings...so its not slow

@derrickhand300
6 years ago
1,353 posts

Litespeed /mariaDB got everything in the dashboard working again....but even with MariaDB my score is 200 and a 40 for the DB...still trying to resolve that...

@brian
6 years ago
10,148 posts

derrickhand300:
Litespeed /mariaDB got everything in the dashboard working again....but even with MariaDB my score is 200 and a 40 for the DB...still trying to resolve that...

So:

MariaDB = fork of MySQL
LiteSpeed - fork of Apache

Just changing to MariaDB will buy you a little speed (since it's a bit faster in SOME ways than MySQL). I can't speak about LiteSpeed since we don't use it.

I would not expect just changing to MariaDB to do anything much for speed - sounds like you need to optimize your database config. How much memory do you have on your server? What does your current /etc/mysql/my.cnf file look like?

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Thanks Brian
The issue seems to be something in my /store folder. When I shut it off my main public.html site goes down
I am seeing a Fatal Php error in the /store logs- not sure why the store would take down the main site- but I will work on that php php error
Thank you
updated by @derrickhand300: 03/03/18 06:08:58AM

@brian
6 years ago
10,148 posts

derrickhand300:
Thanks Brian
The issue seems to be something in my /store folder. When I shut it off my main public.html site goes down
I am seeing a Fatal Php error in the /store logs- not sure why the store would take down the main site- but I will work on that php php error
Thank you

Yeah - I saw your error log post before you edited it, and it was issues coming from the /store directory, so glad you found that.

Thanks!

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Thanks!- yes I edited it when i realized it was unrelated to JR

I really believe somehow this store error is causing the probs with the performance tools...I will let you know..
updated by @derrickhand300: 03/03/18 06:40:20AM

@derrickhand300
6 years ago
1,353 posts

Ok I got those errors fixed...but performance check still seems to be broke as well as users online...( dashboard) which shows 1....but if you click on the tab you see many....
Sites working fine- would just like the monitoring stuff to work but think i will leave it as is and move on
Thanks again

@brian
6 years ago
10,148 posts

So this is where it can get more complex depending on your setup. Since you are only seeing 1 user, it means the IP address for all your visitors is the SAME, which means your web server is not forwarding the IP address of the user over to your PHP install as $_SERVER['REMOTE_ADDR'] - so you need to have your web admin ensure the remote ip address is coming through. If the web server is behind any kind of proxy, then the HTTP_X_FORWARDED_FOR header needs to be set as well.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net
updated by @brian: 03/03/18 07:26:51AM

@derrickhand300
6 years ago
1,353 posts

Thank you brian...I have submitted what you wrote to support- again i really appreciate the help! I really like for this stuff to work- i use it a lot during high load times...to see whats going on

@derrickhand300
6 years ago
1,353 posts

I saved my PHP configuration using system tools to a html file then zipped it here...thought this might work to show my php settings if interested..

Here are the settings for what you stated..
$_SERVER['REMOTE_ADDR'] 216.198.163.158

updated by @derrickhand300: 03/03/18 08:41:06AM

@brian
6 years ago
10,148 posts

I can see in this that $_SERVER['REMOTE_ADDR'] and $_SERVER['SERVER_ADDR'] are different, so that's good - that means YOUR ip address is not coming in as the server address. So I think your online users _should_ be good. Do you still only see 1 online user?

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Yes only 1 user online

@derrickhand300
6 years ago
1,353 posts

well...i take that back...it just started working...not sure what the server support is doing at the moment but Performance check still broken
updated by @derrickhand300: 03/03/18 08:44:48AM

@brian
6 years ago
10,148 posts

OK - I'm just heading out here for the day for a family function - so I likely won't be online again until tomorrow AM - I can check it out then if needed.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Thanks im also headed to a funeral...thanks again hope you have a great saturday!

@derrickhand300
6 years ago
1,353 posts

How should the following be optimized for jamroom
/etc/my.cnf file:--
key_buffer = 256M
max_allowed_packet = 32M
table_open_cache = 1536
table_definition_cache = 1536
open_files_limit = 10240
tmp_table_size = 256M
max_heap_table_size = 256M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 768K
max_connections = 200
innodb_buffer_pool_size = 1G
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 0
ft_min_word_len = 3
ft_stopword_file = ""
--

@michael
6 years ago
7,744 posts

Tempted to say "Hey, just use Jamroom Hosting!"

Here's the guide for jamroom my.cnf optimizations:
https://www.jamroom.net/brian/documentation/guides/1265/optional-mysql-optimizations-for-larger-servers

@derrickhand300
6 years ago
1,353 posts

I am glad you didnt give into temptation

As you know if JR hosting allowed me root access and the ability to host my wordpress and other sites i would be there in a matter of minutes

My time with JR Hosting in the past has been some of the most cherished memories of my life

( if you are going to plug something-thats how you do it

)

@brian
6 years ago
10,148 posts

derrickhand300:
How should the following be optimized for jamroom
/etc/my.cnf file:--
key_buffer = 256M
max_allowed_packet = 32M
table_open_cache = 1536
table_definition_cache = 1536
open_files_limit = 10240
tmp_table_size = 256M
max_heap_table_size = 256M
sort_buffer_size = 2M
read_buffer_size = 2M
read_rnd_buffer_size = 768K
max_connections = 200
innodb_buffer_pool_size = 1G
innodb_flush_method = O_DIRECT
innodb_flush_log_at_trx_commit = 0
ft_min_word_len = 3
ft_stopword_file = ""
--

This is good for the size of your server - MySQL should be running really well with this config.

--
Brian Johnson
Founder and Lead Developer - Jamroom
https://www.jamroom.net

@derrickhand300
6 years ago
1,353 posts

Thanks Brian

solved Ensure APCu functions have been enabled in your PHP install

Tags