Memory error on Forum reply

Started by Tripredacus, May 11, 2011, 12:59:48 PM

previous topic - next topic
Go Down

Tripredacus

May 11, 2011, 12:59:48 PM Last Edit: December 31, 1969, 04:00:00 PM by Guest
While replying to a topic, I received this full error (meaning no page parts visible)

Quote
Fatal error: Out of memory (allocated 1048576) (tried to allocate 1245184 bytes) in //snip//
I was able to (obviously) post this thread, and also click the back button from that error screen and click the reply button to post.

IM me to get full path and line number reported.

Also, when trying to post THIS thread got an Error 500.

Wajo357

#1
May 11, 2011, 05:59:17 PM Last Edit: December 31, 1969, 04:00:00 PM by Guest
yeah... today has been plagued with memory issues. Hopefully that has been resolved.
<a href="http://www.shmax.com/img/sigs/signature.swf?user_id=853" target="_blank" class="new_win">http://www.shmax.com/img/sigs/signature.swf?user_id=853</a>

shmax

#2
May 11, 2011, 08:29:01 PM Last Edit: December 31, 1969, 04:00:00 PM by Guest
Not yet, but we've put our best Canadian on it!

spaceharfang

#3
May 11, 2011, 09:33:02 PM Last Edit: December 31, 1969, 04:00:00 PM by Guest
Added a new feature in the query generation allowing for large fields to be left out of the data sorting on mysql. In short, queries will use less memory with it and be faster. I measured a gain of 50% in the sku browse page with the form category. For now, only a single field has been marked as large which was by far the largest. I'll update with a few more fields declared as large to further gain on the change.

Wajo357

#4
May 12, 2011, 02:29:33 AM Last Edit: December 31, 1969, 04:00:00 PM by Guest
now I'm getting a lot of the following errors for the forums:

General Error
SQL ERROR [ mysqli ]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (12) [2002]

An sql error occurred while fetching this page. Please contact an administrator if this problem persists.


I had to refresh a few times just so I can see this page.
<a href="http://www.shmax.com/img/sigs/signature.swf?user_id=853" target="_blank" class="new_win">http://www.shmax.com/img/sigs/signature.swf?user_id=853</a>

spaceharfang

#5
May 12, 2011, 05:20:54 AM Last Edit: December 31, 1969, 04:00:00 PM by Guest
Yeah, the internal connection count.

The good news is that the server no longer trips on memory shortage.
The bad news is that now  it trips on internal connection shortage.

Yay!

Tripredacus

#6
May 12, 2011, 08:54:58 AM Last Edit: December 31, 1969, 04:00:00 PM by Guest
Have any recent code logic changes been made that could be causing a loop somewhere on the site? I wouldn't imagine that the memory error was caused by the forum, but we were just unfortunate enough to see it while on the forum. Then again, I have no experience with this forum version.

spaceharfang

#7
May 12, 2011, 06:51:18 PM Last Edit: December 31, 1969, 04:00:00 PM by Guest
The memory error we had yesterday was coming from the main site.  We queries that handle a lot of data.  Apparently over 200 MB.

But for the connection part, I'm starting to suspect the forums as well.

Go Up