Bienvenue, Invité
Nom d'utilisateur : Mot de passe :
This Help forum is for issues relates to the latest release (1.7.8). For issues related to beta or github version please use their own Help forum.
Before asking for help please read "How to request help" by clicking on that tab above here."
  • Page :
  • 1

SUJET :

Certain individuals take long to open il y a 4 ans 9 mois #1

  • figi4
  • Portrait de figi4 Auteur du sujet
  • Visiteur
  • Visiteur
I was wondering if it is a known problem or if I just have a glitch in my tree (or its just my pc)? My tree loads pretty fast except for some individuals. Often I will click on their name and then just go to another tab to research something else while that individual loads.

This one is fast:

J Bunch

This one is slow:

C Figueroa

Connexion ou Créer un compte pour participer à la conversation.

Certain individuals take long to open il y a 4 ans 9 mois #2

  • bertkoor
  • Portrait de bertkoor
  • Hors Ligne
  • Membre platinium
  • Membre platinium
  • Greetings from Utrecht, Holland
  • Messages : 2360
The difference is mainly that Mr Bunch is related to just a few public persons while Mr Figueroa is member of a lot of families that have lots of private individuals.
Privacy calculations can take a lot of time indeed.
stamboom.BertKoor.nl runs on webtrees v1.7.13

Connexion ou Créer un compte pour participer à la conversation.

Certain individuals take long to open il y a 4 ans 9 mois #3

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrateur
  • Administrateur
  • Messages : 14715
Looking in the page source, I find the following stack dump

#0 unknown:unknown ErrorException("/home/445/95445/public_html/webtrees/app/Statement.php:82 PDOStatement::execute(): MySQL server has gone away")
#1 /app/Statement.php:82 execute()
#2 /app/Individual.php:62 execute([array])
#3 /app/Family.php:45 load([Tree], [array])
#4 /app/GedcomRecord.php:205 __construct('F17', '0 @F17@ FAM 1 HUSB @P55@ 1 WIF…', [NULL], [Tree])
#5 /app/Fact.php:97 getInstance('F17', [Tree])
#6 /app/Individual.php:858 getTarget()
#7 /app/Module/IndividualFactsTabModule.php:421 getChildFamilies()
#8 /app/Module/IndividualFactsTabModule.php:389 parentFacts([Individual P11@2], 3)
#9 /app/Module/IndividualFactsTabModule.php:109 parentFacts([Individual P6@2], 1)
#10 /app/Controller/IndividualController.php:118 getTabContent()
#11 /individual.php:42 ajaxRequest()

The "MySQL server has gone away" error *may* be a red herring.
What value do you have for "wait_timeout" in your MySQL configuration. (Control panel, server information).
Greg Roach - Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser. - fisharebest.webtrees.net

Connexion ou Créer un compte pour participer à la conversation.

Certain individuals take long to open il y a 4 ans 9 mois #4

  • figi4
  • Portrait de figi4 Auteur du sujet
  • Visiteur
  • Visiteur
Yes I get a lot of MySQL errors. One is "too many connections" when I have ftp or more that 2 tabs open in the browser. Another I got 4 times yesterday when I was trying to upload my 3mb gedcom was something about I'd reached my maximum limit for the hour. I'd had to leave it and come back later to try again, a little more of the gedcom would load and then the error again.

I'll have to read up on MySQL because I'm not really familiar with it only having used it once before about 5 years ago.

For wait_timeout I have 600. Do you suggest something else?

Connexion ou Créer un compte pour participer à la conversation.

Certain individuals take long to open il y a 4 ans 9 mois #5

  • figi4
  • Portrait de figi4 Auteur du sujet
  • Visiteur
  • Visiteur
Well, it seems that I would need to have super user to make any changes anyway. I wonder if if I could get support to change that for me or would that affect their other customers on that server too?

Connexion ou Créer un compte pour participer à la conversation.

Certain individuals take long to open il y a 4 ans 9 mois #6

  • fisharebest
  • Portrait de fisharebest
  • Hors Ligne
  • Administrateur
  • Administrateur
  • Messages : 14715
600 seconds is a perfectly reasonable setting for this value.

The error "MySQL has gone away" is very difficult to diagnose. It means that the database closed the connection without giving a reason. The two most common reasons are that you sent a large query "max_allowed_packet" or you waited too long between queries "wait_timeout". Neither seems to be the case here.

The server could have closed the connection because it had too many connections, too few resources, etc.
But since you say that your problem happens consistently with specific pages only, then these sorts of reasons are unlikely.

Do you, perhaps, have any duplicate or otherwise "unusual" family structures? It could be that the privacy calculations are getting stuck in a loop. (e.g. if your father married your son, then you are your own grand-parent, etc.)

Or, it could simply be that your server is *very* slow, and can't cope with the privacy calculations...
Greg Roach - Cette adresse e-mail est protégée contre les robots spammeurs. Vous devez activer le JavaScript pour la visualiser. - fisharebest.webtrees.net

Connexion ou Créer un compte pour participer à la conversation.

Certain individuals take long to open il y a 4 ans 9 mois #7

  • figi4
  • Portrait de figi4 Auteur du sujet
  • Visiteur
  • Visiteur
Well there is one where the same man is/was both stepfather and father-in-law at different times.

I just finished installing webtrees on a different webhost and it runs a lot better so Im thinking that it was more the server problem.

Connexion ou Créer un compte pour participer à la conversation.

[SOLVED] Certain individuals take long to open il y a 4 ans 9 mois #8

  • figi4
  • Portrait de figi4 Auteur du sujet
  • Visiteur
  • Visiteur
Problem solved.

Connexion ou Créer un compte pour participer à la conversation.

Avez-vous besoin d'une solution d'hébergement web pour votre site webtrees ?
Si vous préférez un hébergeur spécialisé de webtrees, la page suivante en liste quelques-uns capables de vous offrir ce type de service :
  • Page :
  • 1
Propulsé par Kunena