• Priority: 0
  • Status: Closed
  • Theme: Alysum
  • Assigned To: Marek
  • Private: No
  • Open Date: 13.02.19, 07:15
  • Opened by: Alessio
  • Closed by: Marek
  • Closed on: 30.03.19, 22:16
  • Reason: Closed
  • Comment: Glad to help!

Ticket #13735 - Page builder infinty loading

I have this problem with page builder…{{}}

Comments

Marek 13 Feb 2019, 10:54

Hi, Anna Luisa Bataloni.
Please fill out all necessary fields in your profile https://support.promokit.eu/index.php?do=myprofile to access to your back office

Alessio 13 Feb 2019, 11:28

ok!

Marek 13 Feb 2019, 11:49

I’m not able to login with provided details

Alessio 13 Feb 2019, 12:43

now is ok

Marek 13 Feb 2019, 21:39

I see javascript error in the gamification module. Try to disable it

Alessio 14 Feb 2019, 07:56

I disable the gamification module but it didn’t don’t work!

Marek 14 Feb 2019, 10:58

Yes, I see. Working on that…

Marek 14 Feb 2019, 12:54

I have found out the error

User dbo729778790 already has more than 'max_user_connections' active connections

You have to configure more connections on mysql config file on the server. If you don’t have this access, ask the support to do it or change for a hosting company with more connections allowed!
Here is similar problem on PrestaShop forum https://www.prestashop.com/forums/topic/565338-hosting-max_user_connections-problem/

Alessio 14 Feb 2019, 15:47

we have 134 max_user_connection

Marek 14 Feb 2019, 15:47

Ok, try to increase it up to 300

Alessio 14 Feb 2019, 15:59

initially it worked very well, I would not want there to be a programming problem.

we can also change hosting but if the number of connected maximum users increases over time it will still create a problem

Marek 14 Feb 2019, 16:02

I have never seen such problem before. I suppose you just have very low “max_user_connection” value, just try to increase it

Alessio 20 Feb 2019, 08:55

when we click on page building from the back office the queries fail and it is not a problem of max_user_connection{{}}

Alessio 20 Feb 2019, 08:57

Problem:
Too many clients have been interrupted.

Notice:
Client connections are usually terminated when they do not properly terminate their MySQL connections. This could be caused by network problems or by code that does not terminate the connections correctly. Check network and code.

Justification:
The interrupt frequency of client connections is 4.5 per hour, this value should be less than 1 per hour

Variable / formula used:
Aborted_clients / Uptime

Test:
value * 60 * 60> 1

Close

Alessio 20 Feb 2019, 08:58

Problem:
Too many connections have been interrupted.

Notice:
Connections are usually interrupted when they can not be authorized. This article will help you trace the source.

Justification:
The rate of broken connections is 12.13 per hour, this value should be less than 1 per hour

Variable / formula used:
Aborted_connects / Uptime

Test:
value * 60 * 60> 1

Alessio 20 Feb 2019, 09:04

This problem makes useless to customize the theme … we need assistance …

Marek 20 Feb 2019, 10:17

Hi, Anna.
Thank you for your report, I have to investigate that, I’ll back to you as soon as possible. This problem has highest priority

Marek 11 Mar 2019, 13:06

We have make a lot of tests with page builder and “max_user_connection” option of MYSQL settings. in our case it was working even with limitation in 10 connections

Alessio 30 Mar 2019, 22:11

Thanks, you’re great!
Nice work!

Marek 30 Mar 2019, 22:15

You are welcome