StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POPHP Out of Memory - Crashes Apache?
primarykey
Id
1990216
data
AcceptedAnswerId
2009150
AnswerCount
5
ClosedDate
CommentCount
4
CommunityOwnedDate
CreationDate
2010-01-02T00:59:28.373
FavoriteCount
3
LastActivityDate
2013-04-11T10:50:42.990
LastEditDate
2010-01-05T16:35:32.983
LastEditorUserId
4228
OwnerUserId
51649
ParentId
0
PostTypeId
1
Score
7
ViewCount
10257
LastEditorDisplayName
text
Body
<p>I am running PHP version 5.3.0 and Apache: 2.2.11</p> <p>When I run PHP scripts that consume a lot of memory (I think) - large loops etc. My Apache web server reports a crash?!</p> <pre><code>[Sat Jan 02 00:51:30 2010] [notice] Parent: child process exited with status 255 -- Restarting. </code></pre> <p>Do I need to increase memory somewhere? I currently have memory set to</p> <pre><code>memory_limit = 512M </code></pre> <p>PHP hasn't complained about this so I am thinking its something else?</p> <p>Thanks all</p> <h2>Update</h2> <p>This error has been logged by my windows machine in the event viewer:</p> <blockquote> <p>Faulting application httpd.exe, version 2.2.11.0, time stamp 0x493f5d44, faulting module php5ts.dll, version 5.3.0.0, time stamp 0x4a4922e7, exception code 0xc0000005, fault offset 0x00083655, process id 0x1588, application start time 0x01ca8b46e4925f90.</p> </blockquote> <h2>Update 2</h2> <p>Script in question. I've removed the URL.</p> <pre><code><?php error_reporting(E_ALL); set_time_limit(300000); echo 'start<br>'; include_once('simple_html_dom.php'); $FileHandle = fopen('tech-statistics3.csv', 'a+') or die("can't open file"); for($i =1; $i < 101; $i ++){ // Create DOM from URL $html = file_get_html("http://www.x.com/$i"); foreach($html->find('div[class=excerpt]') as $article) { $item0 = $article->children(1)->children(1)->children[0]->plaintext; $item1 = $article->children(1)->children(1)->children[0]->plaintext; $item2 = $article->children(1)->children(0)->children(0)->children(0)->plaintext; //$item3 = $article->children(1)->children(0)->children(0)->children[1]->children(0)->next_sibling(); $stringa = trim($item0).",".trim($item1).",".trim($item2)."\r\n"; fwrite($FileHandle, $stringa); echo $stringa.'<br>'; echo '------------>'.$i; } } fclose($FileHandle); echo '<b>End<br>'; ?> </code></pre> <h2>Update 3</h2> <p>I am using the PHP Simple HTML DOM Parser and I have just found this:</p> <p><a href="http://simplehtmldom.sourceforge.net/manual_faq.htm#memory_leak" rel="noreferrer">http://simplehtmldom.sourceforge.net/manual_faq.htm#memory_leak</a></p> <p>I think I should be clearing memory otherwise it will crash. Testing now.</p> <h2>Update4</h2> <p>Yep, it was a memory leak! :)</p>
Tags
<php><apache><memory>
Title
PHP Out of Memory - Crashes Apache?
singulars
PostAcceptedAnswerId
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
PostParentId
1. This table or related slice is empty.
PostTypePostTypeId
1. PTQuestion
UserLastEditorUserId
1. USraven
UserOwnerUserId
1. USAbs
plurals
PostLinksPostIdRelatedPostId
1. This table or related slice is empty.
PostLinksRelatedPostIdPostId
1. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
2. PL
  singulars
  LinkTypeLinkTypeId
  LTLinked
PostsAcceptedAnswerId
1. This table or related slice is empty.
PostsParentIdCreationDate
1. PO
  singulars
  PostTypePostTypeId
  PTAnswer
2. PO
  singulars
  PostTypePostTypeId
  PTAnswer
3. PO
  singulars
  PostTypePostTypeId
  PTAnswer
VotesPostIdCreationDate
1. VO
  singulars
  PostPostId
  POPHP Out of Memory - Crashes Apache?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
2. VO
  singulars
  PostPostId
  POPHP Out of Memory - Crashes Apache?
  UserUserId
  USTMG
  VoteTypeVoteTypeId
  VTFavorite
3. VO
  singulars
  PostPostId
  POPHP Out of Memory - Crashes Apache?
  UserUserId
  This table or related slice is empty.
  VoteTypeVoteTypeId
  VTUpMod
CommentsPostId

Querying!

Guidance

A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.