Help! I got this message from my webservice!
Hello,
Some of your php, and specifically your descendancy.php script seems to
be using too much memory and is directly or indirectly causing the web
server machine to run out of memory and crash. We will be applying some
memory restrictions on the Apache server to keep the machine from
crashing and it looks like it will prevent that script from running
correctly. It will have to be modified to be less memory intensive.
My program ran perfectly until now. Now I cannot access it! Can you help me?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Sounds to me more like the host doesn't know how to setup their server properly. :( It is very hard to crash a server using PHP.
PHP won't use more memory than the max_memory setting in the php.ini file. If it does use up that much memory, PHP will terminate.
First thing is to try is limiting the "Maximum Descendancy Generations" in the gedcom configuration to something like 5 and see if that will let you in.
Are you using relationship privacy? (Are you still using legacy to privatize your file?) Do you use Index files or MySQL? Index files use a lot more memory.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I privatize in my Legacy program. I index files, my son was not sure about how much trouble we would have setting up MySQL although we have the option of that on the website. I cannot get into my program now to set up anything! :-( They had to set the ini file to a longer time limit so I could index the files in the original program. It used to take several minutes, but now indexes in only seconds, it seems. The website seems to be very popular, and the hits have increased continually until this happened. I don't know if this has contributed to the problem. My son is trying to see what he can do with the company since this is his website that I have my domain on. It seems like they have totally shut down my php access.... Nothing works. The program does not even start, and I don't think that is all the fault of how long it takes to run! The opening page should show up, since it is not that much display. I don't even have people log in, or host more than one gedcom, although it is a large one! Really, it seems like I have scaled it down from what it could be. Is it hard to set up MySql compared to indexing? I am not very experienced in this. We are supposed to be allowed to use MySql on the website.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Switching to MySQL will probably solve this problem with your host.
It is very easy to switch to MySQL. Just go to the Admin->Configuration screen and select MySQL instead of Index files.
Enter in the appropriate MySQL connection paramters. Your host should provide you with these. On the average host these will be:
Mysql Host: localhost
Mysql Username: your account username
Mysql password: your account password
Mysql database: your account username
You will need to recreate your users and reimport all of your gedcom files after saving the configuration. Everything else will work exactly the same as before.
--John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
We got mysql set up and I got it "working." Everything was uploaded. I had it import the gedcom, but it only seems to allow it to execute 6 seconds! I don't think it has time to set up the program, and it doesn't work. Nothing shows up except a few locations. One error is an undefined variable alpha in famlist.php on line 51. :-(
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Now to add something more to the mix I found later in the day yesterday. Sometimes it was executing for longer sometimes, but it always stopped indexing at the same record! I tried recreating the gedcom, using Netscape instead on IE, etc. and found it always would hang on the same record. I tried some file maintenance in Legacy (eliminated unused locations and such, compacting it...) and recreated the gedcom. I tried the new gedcom. It now always hangs on a different person! I tried a much smaller test gedcom and it works perfectly. When I cick on the individual list or family list, I get the above error on line 51 of indilist.php or famlist.php. I don't know if this is a problem with the server, my gedcom, or the program. It indexed perfectly when I used indexes! I had it indexing as long as 65 seconds on the mysql version, but it was very quick in the regular indexes type version. I can see nothing in the gedcom that should flag these particular records. They look the same as the others to me. :-(
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Not that I can assist with this matter much, but would it be worth a try to load your Gedcom file onto one of the other webhotels the rest of us are using?
I'd be happy to load your gedcom up in both MySQL and Index mode for your testing. I think I could even set you up with an ftp to the said locations.
Just a thought, as I use Legacy and have no issues. Main difference is our gedcoms, and web hotels.
John (The other John)
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I would like to try the gedcom on another service to see if it would work elsewhere or if it is a problem with our service. My gedcom is too large to e-mail. Maybe if there is a way we could communicate offline, I could give you a location for a download from my site.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you for the offer, John, but we have now figured out that the problem is with the server. It must have been timing out somehow. My son was able to build it on his machine while linking to the mysql server on the website, and it took a long time even with his fast connection, but he was able to build the tables and get the website working. He thinks it will work and satisfy the web host now. It makes it very hard to update the page, however, and I am afraid that will not happen very often now! :-(
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Anonymous
-
2003-12-21
Hello,
you can upload the file to my ftp server. The address is: botak.nl and username anonymous@botak.nl
Then you can place your file in the folder incoming.
When it is there I can get it and try here to see what happens.
Regards,
Roland
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Unfortunately, I've optimized PhpGedView for Speed not for Memory and it is generally hard to have speed and low memory because they tend to be mutually exclusive. The more things that you can cache in memory the faster they tend to run.
I'm glad that your son was able to build the database remotely.
-John
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Thank you for the offer Roland, but I think we have the problem figured out. As long as we are with this webservice, I guess it will have to be worked out on my son's machine since I can only get a dial up connection where I live. One thing that does concern me, however, is that even though I have it set to only show something like four generations in the descendancy chart, for some reason it is showing many more. Since that is what the web service specifically mentioned, it has me a bit concerned. My son seems to think things will be OK, now, however, and I hope he is right! I guess this is my penalty for having a large database to post!
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Help! I got this message from my webservice!
Hello,
Some of your php, and specifically your descendancy.php script seems to
be using too much memory and is directly or indirectly causing the web
server machine to run out of memory and crash. We will be applying some
memory restrictions on the Apache server to keep the machine from
crashing and it looks like it will prevent that script from running
correctly. It will have to be modified to be less memory intensive.
My program ran perfectly until now. Now I cannot access it! Can you help me?
Sounds to me more like the host doesn't know how to setup their server properly. :( It is very hard to crash a server using PHP.
PHP won't use more memory than the max_memory setting in the php.ini file. If it does use up that much memory, PHP will terminate.
First thing is to try is limiting the "Maximum Descendancy Generations" in the gedcom configuration to something like 5 and see if that will let you in.
Are you using relationship privacy? (Are you still using legacy to privatize your file?) Do you use Index files or MySQL? Index files use a lot more memory.
--John
I privatize in my Legacy program. I index files, my son was not sure about how much trouble we would have setting up MySQL although we have the option of that on the website. I cannot get into my program now to set up anything! :-( They had to set the ini file to a longer time limit so I could index the files in the original program. It used to take several minutes, but now indexes in only seconds, it seems. The website seems to be very popular, and the hits have increased continually until this happened. I don't know if this has contributed to the problem. My son is trying to see what he can do with the company since this is his website that I have my domain on. It seems like they have totally shut down my php access.... Nothing works. The program does not even start, and I don't think that is all the fault of how long it takes to run! The opening page should show up, since it is not that much display. I don't even have people log in, or host more than one gedcom, although it is a large one! Really, it seems like I have scaled it down from what it could be. Is it hard to set up MySql compared to indexing? I am not very experienced in this. We are supposed to be allowed to use MySql on the website.
Switching to MySQL will probably solve this problem with your host.
It is very easy to switch to MySQL. Just go to the Admin->Configuration screen and select MySQL instead of Index files.
Enter in the appropriate MySQL connection paramters. Your host should provide you with these. On the average host these will be:
Mysql Host: localhost
Mysql Username: your account username
Mysql password: your account password
Mysql database: your account username
You will need to recreate your users and reimport all of your gedcom files after saving the configuration. Everything else will work exactly the same as before.
--John
We got mysql set up and I got it "working." Everything was uploaded. I had it import the gedcom, but it only seems to allow it to execute 6 seconds! I don't think it has time to set up the program, and it doesn't work. Nothing shows up except a few locations. One error is an undefined variable alpha in famlist.php on line 51. :-(
Now to add something more to the mix I found later in the day yesterday. Sometimes it was executing for longer sometimes, but it always stopped indexing at the same record! I tried recreating the gedcom, using Netscape instead on IE, etc. and found it always would hang on the same record. I tried some file maintenance in Legacy (eliminated unused locations and such, compacting it...) and recreated the gedcom. I tried the new gedcom. It now always hangs on a different person! I tried a much smaller test gedcom and it works perfectly. When I cick on the individual list or family list, I get the above error on line 51 of indilist.php or famlist.php. I don't know if this is a problem with the server, my gedcom, or the program. It indexed perfectly when I used indexes! I had it indexing as long as 65 seconds on the mysql version, but it was very quick in the regular indexes type version. I can see nothing in the gedcom that should flag these particular records. They look the same as the others to me. :-(
Not that I can assist with this matter much, but would it be worth a try to load your Gedcom file onto one of the other webhotels the rest of us are using?
I'd be happy to load your gedcom up in both MySQL and Index mode for your testing. I think I could even set you up with an ftp to the said locations.
Just a thought, as I use Legacy and have no issues. Main difference is our gedcoms, and web hotels.
John (The other John)
I would like to try the gedcom on another service to see if it would work elsewhere or if it is a problem with our service. My gedcom is too large to e-mail. Maybe if there is a way we could communicate offline, I could give you a location for a download from my site.
Thank you for the offer, John, but we have now figured out that the problem is with the server. It must have been timing out somehow. My son was able to build it on his machine while linking to the mysql server on the website, and it took a long time even with his fast connection, but he was able to build the tables and get the website working. He thinks it will work and satisfy the web host now. It makes it very hard to update the page, however, and I am afraid that will not happen very often now! :-(
Hello,
you can upload the file to my ftp server. The address is: botak.nl and username anonymous@botak.nl
Then you can place your file in the folder incoming.
When it is there I can get it and try here to see what happens.
Regards,
Roland
Man, what a bummer! :'(
Unfortunately, I've optimized PhpGedView for Speed not for Memory and it is generally hard to have speed and low memory because they tend to be mutually exclusive. The more things that you can cache in memory the faster they tend to run.
I'm glad that your son was able to build the database remotely.
-John
Thank you for the offer Roland, but I think we have the problem figured out. As long as we are with this webservice, I guess it will have to be worked out on my son's machine since I can only get a dial up connection where I live. One thing that does concern me, however, is that even though I have it set to only show something like four generations in the descendancy chart, for some reason it is showing many more. Since that is what the web service specifically mentioned, it has me a bit concerned. My son seems to think things will be OK, now, however, and I hope he is right! I guess this is my penalty for having a large database to post!