[FX.php List] Memory Error

[Karstyn McCoy]

This was code originated by someone else - and the original
methodology was to first delete all portal records, then add them back
in so edits where captured. I know, not exactly a best practice!

I'm aware the record locking could have or would have come into play.
But I think for the testing it was not part of the equation as no one
else 'should' have been on any of the records.


--Karstyn



On Thu, Dec 10, 2009 at 10:28 AM, Joel Shapiro <jsfmp at earthlink.net> wrote:
> hmm... just a thought...  If you were editing lots of records through
> portals with one FMEdit call, I wonder if this could have had anything to do
> with record locking, since I believe the main/parent record can't be
> committed if any of the related records are open by another user.  I'm not
> sure what would happen in that case, but it's what popped into my head when
> I read your description.
>
> -Joel
>
>
> On Dec 10, 2009, at 7:45 AM, Karstyn McCoy wrote:
>
>> Thought I would get back and say what the problem turned out to be.
>>
>> The web page was a long registration form that updated a bunch of FM
>> portals - which ended up being the issue. The errors were sporadic in
>> that if one portal and/or a document upload section were commented out
>> then the page worked fine. It didn't seem to matter what portal
>> section was commented out, just that one or more were. The errors
>> could be different as well, and the memory allocation in the error
>> message never jived with the php.ini or phpinfo settings - so a bit of
>> a red herring  there.
>>
>> So changing the design to just go to a base layout to work through,
>> instead of working through portals, settled everything down.
>>
>> Thanks for all the suggestions!
>>
>> --Karstyn
>>
>>
>>
>> On Thu, Dec 3, 2009 at 6:24 PM, Dale Bengston <dbengston at tds.net> wrote:
>>>
>>> Another way to have this happen is to accidentally retrieve all the
>>> records out of a table. If you submit a query to FX that has no search
>>> terms, it's like doing a findall. I found this out the hard way on a table
>>> with 300K line items.
>>>
>>> Dale
>>>
>>> On Dec 3, 2009, at 7:18 PM, Karstyn McCoy wrote:
>>>
>>>> Thanks Guys.
>>>>
>>>> I'll do some more debugging to check for endless loops or a
>>>> malfunctioning part of the script.
>>>>
>>>> Thanks,
>>>>
>>>> --Karstyn
>>>>
>>>>
>>>>
>>>> On Thu, Dec 3, 2009 at 5:11 PM, Jonathan Schwartz
>>>> <jschwartz at exit445.com> wrote:
>>>>>
>>>>> Kartsyn,
>>>>>
>>>>> While you *could* have a script that requires more memory than has been
>>>>> allocated, a more common source of the problem is an endless loop of a
>>>>> script that normally doesn't need extra memory.
>>>>>
>>>>> Is the problem attributed to just one script?  Is it a new script? Are
>>>>> you
>>>>> doing operations similar to other scripts that have no memory issues?
>>>>>
>>>>> If the answer to these questions is "Yes", than look for a
>>>>> malfunctionaing
>>>>> script rather than a memory issue.
>>>>>
>>>>> Hope that helps,
>>>>>
>>>>> Jonthan
>>>>>
>>>>>
>>>>>> Not strictly an FX question but definitly PHP - so thought I try this
>>>>>> list for some good ideas.
>>>>>>
>>>>>> Here is the issue:
>>>>>> I get a following error when I execute a php script
>>>>>> Fatal error: Allowed memory size of 12582912 bytes exhausted (tried to
>>>>>> allocate 89727 bytes)
>>>>>>
>>>>>> I have normally fixed this by doing the following
>>>>>> - Increase the memory size in php.ini file
>>>>>> - added a line ini_set('memory_limit', -1)
>>>>>> - restarting the web server and checking phpinfo to validate the
>>>>>> change
>>>>>>
>>>>>> But I still get the error.
>>>>>>
>>>>>> --Karstyn
>>>>>> _______________________________________________
>>>>>> FX.php_List mailing list
>>>>>> FX.php_List at mail.iviking.org
>>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>
>>>>>
>>>>> --
>>>>> Jonathan Schwartz
>>>>> Exit 445 Group
>>>>> jonathan at exit445.com
>>>>> http://www.exit445.com
>>>>> 415-370-5011
>>>>> _______________________________________________
>>>>> FX.php_List mailing list
>>>>> FX.php_List at mail.iviking.org
>>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>>>
>>>> _______________________________________________
>>>> FX.php_List mailing list
>>>> FX.php_List at mail.iviking.org
>>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>>> _______________________________________________
>>> FX.php_List mailing list
>>> FX.php_List at mail.iviking.org
>>> http://www.iviking.org/mailman/listinfo/fx.php_list
>>>
>> _______________________________________________
>> FX.php_List mailing list
>> FX.php_List at mail.iviking.org
>> http://www.iviking.org/mailman/listinfo/fx.php_list
>
> _______________________________________________
> FX.php_List mailing list
> FX.php_List at mail.iviking.org
> http://www.iviking.org/mailman/listinfo/fx.php_list
>