Hi, I have a problem with my drupal installation. I need to set memory_limit to 140MB for my site. I don't understand how drupal can eat all this ram.

I have no module like gallery.

I have see that the function that eat memory is "db_fetch_object". Ok this is not possible, but a function that call this function is the problem. So I have insert "print_r(debug_backtrace());" into this function and the result is 5391 times of this piece of code lines:

Array
(
    [0] => Array
        (
            [file] => /opt/www/www3/modules/category/category.inc
            [line] => 842
            [function] => db_fetch_object
            [args] => Array
                (
                    [0] => Resource id #108
                )

        )

    [1] => Array
        (
            [file] => /opt/www/www3/modules/category/category.module
            [line] => 888
            [function] => category_node_get_categories
            [args] => Array
                (
                    [0] => 38839
                )

        )

    [2] => Array
        (
            [file] => /opt/www/www3/modules/node.module
            [line] => 317
            [function] => category_nodeapi
            [args] => Array
                (
                    [0] => stdClass Object
                        (
                            [nid] => 38839
                            [vid] => 38839
                            [type] => zbnews
                            [status] => 1
                            [created] => 1193211738
                            [changed] => 1193211738
                            [comment] => 2
                            [promote] => 1
                            [moderate] => 0
                            [sticky] => 0
                            [revision_timestamp] => 1193211738
                            [title] => Il primo sito del web (correva l'anno 1991)
                            [body] => Nel 1991 Tim Berners-Lee metteva online il primo sito del web e iniziava così la rivoluzione WWW
                            [teaser] => Nel 1991 Tim Berners-Lee metteva online il primo sito del web e iniziava così la rivoluzione WWW
                            [log] => 
                            [format] => 0
                            [uid] => 7049
                            [name] => killerapp
                            [picture] => 
                            [data] => a:5:{s:6:"submit";s:18:"Crea nuovo profilo";s:7:"form_id";s:13:"user_register";s:18:"subscriptions_auto";i:1;s:7:"contact";i:1;s:10:"form_token";s:32:"a9d49463826b9d19a57e5ce1e8ce7ef6";}
                            [url] => http://www.tecnoduo.com/2007/10/23/il-primo-sito-del-web-correva-lanno-1991/
                            [clicks] => 0
                            [nickname] => 
                            [mail] => 
                        )

                    [1] => load
                    [2] => 
                    [3] => 
                )

        )

    [3] => Array
        (
            [file] => /opt/www/www3/modules/node.module
            [line] => 385
            [function] => node_invoke_nodeapi
            [args] => Array
                (
                    [0] => stdClass Object
                        (
                            [nid] => 38839
                            [vid] => 38839
                            [type] => zbnews
                            [status] => 1
                            [created] => 1193211738
                            [changed] => 1193211738
                            [comment] => 2
                            [promote] => 1
                            [moderate] => 0
                            [sticky] => 0
                            [revision_timestamp] => 1193211738
                            [title] => Il primo sito del web (correva l'anno 1991)
                            [body] => Nel 1991 Tim Berners-Lee metteva online il primo sito del web e iniziava così la rivoluzione WWW
                            [teaser] => Nel 1991 Tim Berners-Lee metteva online il primo sito del web e iniziava così la rivoluzione WWW
                            [log] => 
                            [format] => 0
                            [uid] => 7049
                            [name] => killerapp
                            [picture] => 
                            [data] => a:5:{s:6:"submit";s:18:"Crea nuovo profilo";s:7:"form_id";s:13:"user_register";s:18:"subscriptions_auto";i:1;s:7:"contact";i:1;s:10:"form_token";s:32:"a9d49463826b9d19a57e5ce1e8ce7ef6";}
                            [url] => http://www.tecnoduo.com/2007/10/23/il-primo-sito-del-web-correva-lanno-1991/
                            [clicks] => 0
                            [nickname] => 
                            [mail] => 
                        )

                    [1] => load
                )

        )

    [4] => Array
        (
            [file] => /opt/www/www3/modules/node.module
            [line] => 2015
            [function] => node_load
            [args] => Array
                (
                    [0] => 38839
                )

        )

    [5] => Array
        (
            [file] => /opt/www/www3/modules/node.module
            [line] => 2109
            [function] => node_page_default
            [args] => Array
                (
                )

        )

    [6] => Array
        (
            [function] => node_page
            [args] => Array
                (
                )

        )

    [7] => Array
        (
            [file] => /opt/www/www3/includes/menu.inc
            [line] => 418
            [function] => call_user_func_array
            [args] => Array
                (
                    [0] => node_page
                    [1] => Array
                        (
                        )

                )

        )

    [8] => Array
        (
            [file] => /opt/www/www3/index.php
            [line] => 15
            [function] => menu_execute_active_handler
            [args] => Array
                (
                )

        )

)

I think that there is a problem in the code or in my modules.

Any help ???

Tnx.

Comments

ziobudda’s picture

Hi, I have installed a path for see who use my server memory and I see:

Modules,11261448
Bootstrap,118521416

Eh???? Bootstrap get more than 100MB of memory ???

Why ? How ?

M.

Freelancer Senior Drupal Developer -- http://www.ziobuddalabs.it

gpk’s picture

Does the problem occur during a cron run or during a normal pageview, and if so, which URL?

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

ziobudda’s picture

Normal page view. Only for the root.

You can see the output of the patch here: www3.ziobudda.net (at the end of the page).

M.

Freelancer Senior Drupal Developer -- http://www.ziobuddalabs.it

Heine’s picture

It's the category module. Did you accidentally create a cyclic graph with node 38839?
--
The Manual | Troubleshooting FAQ | Tips for posting | How to report a security issue.

ziobudda’s picture

Sorry, I have not understand what do you mean with cyclic, but You are in rigth: it's category module!!! GRRRR!!!!

Now I disable it. GRRRRRRR...
SHIT!!!

Tnx for all.

Freelancer Senior Drupal Developer -- http://www.ziobuddalabs.it