By ddease2 on

Sorry folks, I'm a newbie to Drupal. Can anyone tell me what this error message is getting at? I've searched and searched and I must not be looking in the right place.

Out of memory (Needed 1610496 bytes) query: SELECT DISTINCT u.uid, u.name, s.timestamp FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.timestamp >= 1198126333 AND s.uid > 0 ORDER BY s.timestamp DESC in /hermes/web05/b656/pow.ddease2/htdocs/includes/database.mysql.inc on line 172.

I'm getting a barrage of these, so it looks like I've hit some sort of limit. Any advice?

Thanks, all.

ddease2

⋅ Categories: Drupal 5.x

Comments

missym’s picture

missym commented

What are you running on? How much RAM and free disk space to you have?

ddease2’s picture

ddease2 commented

I'm running on OSX Leopard w 2gig of ram.

Here's my Drupal info:

Drupal 5.5
Configuration file Protected
Cron maintenance tasks Last run 4 min 24 sec ago
Database schema Up to date
File system Writable (private download method)
GD library bundled (2.0.28 compatible)
MySQL database 5.0.45
PHP 4.4.7
Unicode library PHP Mbstring Extension
Web server Apache

gpk’s picture

gpk commented

Is this being flagged as a PHP error or a MySQL error? If the former then you may need to increase your PHP memory limit: http://drupal.org/node/76156.

gpk
----
www.alexoria.co.uk

gpk
----
www.alexoria.co.uk

ddease2’s picture

ddease2 commented

Strangely enough, I haven't gotten this error message lately. I did check my php.ini and here's what it says:

;;;;;;;;;;;;;;;;;;;
; Resource Limits ;
;;;;;;;;;;;;;;;;;;;

max_execution_time = 30 ; Maximum execution time of each script, in seconds
max_input_time = 60 ; Maximum amount of time each script may spend parsing request data
memory_limit = 36M ; Maximum amount of memory a script may consume (8MB)

So I should have plenty of memory.

Not sure if this was just an isolated incidence, or if it was an issue with Powweb.com.

In any event, thanks for the help!

DRD2