Massive Errors, Site Slowed to Crawl [#342193]

Hi,

I'm using Content Access for permissions as well. There was probably a conflict. On the Content Type Admin page ( /admin/help/og_content_type_admin )I got about 20 pages (if printed) worth of blood-red SQL errors that were something like this:

# user warning: Duplicate entry 'admin/build/block/configure' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/build/block/configure', '', '', 'user_access', 'a:1:{i:0;s:17:\"administer blocks\";}', 'drupal_get_form', 'a:1:{i:0;s:21:\"block_admin_configure\";}', 15, 4, '', 'admin/build/block/configure', 'Configure block', 't', '', 4, '', '', '', 0, 'modules/block/block.admin.inc') in /home/.../.../includes/menu.inc on line 2385.
# user warning: Duplicate entry 'admin/user/profile/delete' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/user/profile/delete', '', '', 'user_access', 'a:1:{i:0;s:16:\"administer users\";}', 'drupal_get_form', 'a:1:{i:0;s:20:\"profile_field_delete\";}', 15, 4, '', 'admin/user/profile/delete', 'Delete field', 't', '', 4, '', '', '', 0, 'modules/profile/profile.admin.inc') in /home/.../.../includes/menu.inc on line 2385.
# user warning: Duplicate entry 'og/delete_admin/%/%' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('og/delete_admin/%/%', 'a:2:{i:2;s:9:\"node_load\";i:3;s:9:\"user_load\";}', '', 'og_is_group_admin', 'a:1:{i:0;i:2;}', 'drupal_get_form', 'a:3:{i:0;s:23:\"og_remove_admin_confirm\";i:1;i:2;i:2;i:3;}', 12, 4, '', 'og/delete_admin/%/%', 'Delete group administrator', 't', '', 4, '', '', '', 0, '') in /home/.../.../includes/menu.inc on line 2385.

Also there were more errors in other places.

Further, normal pages took about 25 seconds to load, as compared to about 5 seconds after the module was disabled and installed.

Just letting you know, and good luck!

-glass.dimly

Comments

Comment #1

Erco CreditAttribution: Erco commented 4 December 2008 at 08:27

Subscribing,

I just installed this module on a fresh 6.6 install.

It produces the same list of errors.

I uninstalled that single module and the errors disapeared.

Erwan

Comment #2

Anonymous (not verified) CreditAttribution: Anonymous commented 17 December 2008 at 14:09

Assigned:	Unassigned	»
Status:	Active	» Postponed (maintainer needs more info)

Would you both let me know what contributed modules you have installed .

Thanks Paul

Comment #3

MGN CreditAttribution: MGN commented 19 December 2008 at 13:10

Thanks for your efforts with this module. I installed the module (Drupal 6.8, php4.3.9), configured it and worked with it for a few hours. Only once during that time did I have the "duplicate entry" warning as described in #1 - this happened when changing the membership of a group from open to private. The error was caused when updating the node. Unfortunately, I couldn't get the error to occur again, so this may be hard to track down. I can confirm that performance is really a problem with this module. All page loads were about 5 times slower when I had the module enabled....too slow for me to keep working with it right now. Thanks again - I hope this helps.

Comment #4

Anonymous (not verified) CreditAttribution: Anonymous commented 19 December 2008 at 16:55

Thanks, looking into the performance issue.

Comment #5

glass.dimly CreditAttribution: glass.dimly commented 22 December 2008 at 23:59

I have the same problem, but my list of installed modules is far longer than is sane.

Once again, great module, let me know how I can help.

Comment #6

fumbling CreditAttribution: fumbling commented 30 December 2008 at 07:40

Subscribing

Comment #7

yoyin CreditAttribution: yoyin commented 6 January 2009 at 19:03

hello, found this through the search, i have the same problem but i have og not installed. maybe this is not linked to the modul in general?
here is also a post with the same problems: http://drupal.org/node/349676

in my case the problem occurred after a modul update too.

Comment #8

fumbling CreditAttribution: fumbling commented 7 January 2009 at 14:24

Yeah, I participated in that thread and continue to get the duplicate entry errors regardless of what is installed. It's intermittent, and never seems to happen in the same situation. The error is extremely lengthy, and each error-paragraph always ends with the same: in /var/www/html/includes/menu.inc on line 2385. Hope that's of some use.

Comment #9

bejam CreditAttribution: bejam commented 8 January 2009 at 16:03

subscribing

Comment #10

Anonymous (not verified) CreditAttribution: Anonymous commented 9 January 2009 at 12:17

Assigned:

» rconstantine

@Ryan

Can you help with the performance issue ?

Best, Paul

Comment #11

brisath CreditAttribution: brisath commented 12 January 2009 at 07:04

Subscribing.

I seem to be getting similar errors.

Comment #12

yoyin CreditAttribution: yoyin commented 15 January 2009 at 09:38

Hello, I updated today my drupal 6 installation to 6.9 and got the error after I enabled all modules again after the update.

All the errors come form the "menu_router" table (i guess url aliases are stored there?) so I tried to re-do the upgrade but before starting it I deleted all URL-aliases (Iam using pathauto) and the error-count declined from 322 to only 32.

I also found this link http://drupal.org/node/69722 where one user also points out that pathauto can cause some troubles with duplicated entries.

Maybe someone who knows what menu router table is for can help us here?

I also exported the menu router table and checked "by hand" for duplicated entries, but there weren't any (so no bad changes are made to the db?).

cya mike

P.S.: Iam a newbie to drupal so maybe my assumptions are all wrong. ;)

Comment #13

fumbling CreditAttribution: fumbling commented 16 January 2009 at 00:20

Thanks for the insight. Just to confirm, are all of your errors ending with

in /home/.../.../includes/menu.inc on line 2385.

Comment #14

yoyin CreditAttribution: yoyin commented 17 January 2009 at 09:45

Hello fumbling,

Yes in both cases all errors ended with "menu.inc on line 2385".

Hope that helps to solve this problem.

Comment #15

Anonymous (not verified) CreditAttribution: Anonymous commented 22 January 2009 at 10:17

Assigned:

rconstantine

Would you let me know please if your still experiencing these problems with the latest development release.

http://drupal.org/node/330135

Thanks for all your help folks!

Best, Paul

Comment #16

brisath CreditAttribution: brisath commented 27 January 2009 at 06:37

Still getting duplicate entry errors all the time with the latest dev release.

Comment #17

Anonymous (not verified) CreditAttribution: Anonymous commented 28 January 2009 at 10:47

Version:

6.x-1.0-beta1

» 6.x-1.x-dev

I have not been able to reproduce these errors, it may be that OG CTA is not the problem.

With every page load OG CTA calls menu_rebuild() which (re)populates the database tables used by various menu functions. So if there is a problem with OG CTA then there is a problem with the calling of menu_rebuild().

My guess is that the problems reported may be caused by other modules that are making changes to the {menu_router} table directly not through menu_rebuild()

http://api.drupal.org/api/function/menu_rebuild/6
This function will clear and populate the {menu_router} table, add entries to {menu_links} for new router items, then remove stale items from {menu_links}. If called from update.php or install.php, it will also schedule a call to itself on the first real page load from menu_execute_active_handler(), because the maintenance page environment is different and leaves stale data in the menu tables.

Comment #18

brisath CreditAttribution: brisath commented 28 January 2009 at 23:10

I was hoping this problem was not from the OG Content Type Administration module because this one really fits my needs on my site. So I tried several fixes, solutions, and other module changes but none solved the duplicate entry errors that were all over my db log. I backed off this module and the error messages have ceased. I also replaced the OG Detail CTA block with the regular OG Detail so I'm not sure which change solved my problem. Also, this solved the "access denied" error problem I was getting. I hope this can be fixed because I would like to use this module in the future. Keep up the work!

Comment #19

Anonymous (not verified) CreditAttribution: Anonymous commented 4 February 2009 at 09:42

"I backed off this module and the error messages have ceased"

Does OG CTA module work fine with OG, that is with all other contributed modules disabled ?

I'll install the "Access control" module later today to see what effect this has on the operation of OG CTA.

Comment #20

Anonymous (not verified) CreditAttribution: Anonymous commented 4 February 2009 at 10:41

Status:

Postponed (maintainer needs more info)

» Closed (won't fix)

Couldn't reproduce these errors with "Access control" module enabled.

Please let me know if you have any further information or wish to clarify further something that has already been said.

Best, Paul

Comment #21

held69 CreditAttribution: held69 commented 17 February 2009 at 07:40

Hi there,
i'm having simular problems with og CTA.
http://drupal.org/node/374730

With "Access control" do you mean this module?
http://drupal.org/project/nodeaccess

Comment #22

holymountainchicago CreditAttribution: holymountainchicago commented 1 March 2009 at 23:31

I am having the same PHP duplicate entry errors on 6.10 with no contributed modules installed, but all the core optional modules enabled. The last time it happened was when I first tried to add a new URL alias for a feed aggregator category. It did not work. Then I clicked over to look at my modules admin page and got the errors.

It seems that I get an identical "duplicate entry" error for each theme that I have installed (though I was not doing anything with themes at the time).

It looks like this:

Duplicate entry 'themes/garland/minnelli/minnelli.info' for key 1 query: INSERT INTO system (name, owner, info, type, filename, status, throttle, bootstrap) VALUES ('minnelli', 'themes/engines/phptemplate/phptemplate.engine', 'a:14:{s:4:\"name\";s:8:\"Minnelli\";s:11:\"description\";s:56:\"Tableless, recolorable, multi-column, fixed width theme.\";s:7:\"version\";s:4:\"6.10\";s:4:\"core\";s:3:\"6.x\";s:10:\"base theme\";s:7:\"garland\";s:11:\"stylesheets\";a:1:{s:3:\"all\";a:1:{s:12:\"minnelli.css\";s:36:\"themes/garland/minnelli/minnelli.css\";}}s:7:\"project\";s:6:\"drupal\";s:9:\"datestamp\";s:10:\"1235596218\";s:7:\"regions\";a:5:{s:4:\"left\";s:12:\"Left sidebar\";s:5:\"right\";s:13:\"Right sidebar\";s:7:\"content\";s:7:\"Content\";s:6:\"header\";s:6:\"Header\";s:6:\"footer\";s:6:\"Footer\";}s:8:\"features\";a:10:{i:0;s:20:\"comment_user_picture\";i:1;s:7:\"favicon\";i:2;s:7:\"mission\";i:3;s:4:\"logo\";i:4;s:4:\"name\";i:5;s:17:\"node_user_picture\";i:6;s:6:\"search\";i:7;s:6:\"slogan\";i:8;s:13:\"primary_links\";i:9;s:15:\"secondary_links\";}s:7:\"scripts\";a:1:{s:9:\"script.js\";s:33:\"themes/garland/minnelli/script.js\";}s:10:\"screenshot\";s:38:\"themes/garland/minnelli/screenshot.png\";s:3:\"php\";s:5:\"4.3.5\";s:6:\"engine\";s:11:\"phptemplate\";}', 'theme', 'themes/garland/minnelli/minnelli.info', 0, 0, 0) in /home/holyals2/public_html/behindtheveil/modules/system/system.module on line 821.

Comment #23

kobnim CreditAttribution: kobnim commented 2 March 2009 at 00:33

Hi Paul,
I'm experiencing a similar problem.
Logged in as admin, I get "access denied" when I try to create cck content.
If I disable "OG CTA", the problem goes away.
If I enable "OG CTA" and disable "OG Access Control", the problem reappears.

Is there some other information I might be able to supply, that might be helpful in diagnosing the problem?

Thanks,
Mindy

Comment #24

SocialNicheGuru CreditAttribution: SocialNicheGuru commented 7 March 2009 at 19:10

Hi,

My system slowed to a crawl and I found there were a few modules to blame.
OG garden (it added about 9 sec)
OG actions and OG content access added about 4 seconds each

I tested this by loading the admin/build/modules page with dev set.

Each of these was built on the same basic group of modules.

OG actions and OG Content Access add several seconds to the execution.

I would love to use these modules but it slows down the administration of my system.

Og actions- added about 4 sec
*********

Og
Executed 6323 queries in 5862.24 milliseconds.

OG + OG ACTIONS
Executed 6291 queries in 9541.68 milliseconds.

OG content access- added about 4 sec
***************

Og + Og views
Executed 6349 queries in 6546.63 milliseconds

Og + og views + titles
ed 6355 queries in 5649.21 milliseconds

og + og views + titles + subgroups
Executed 6360 queries in 5982.43 milliseconds.

og + og views + titles + subgroups + group permissions
Executed 6358 queries in 6126.93 milliseconds

og + og views + titles + subgroups + group permissions + content type admin (adds four seconds)
Executed 8700 queries in 10315.36 milliseconds.

Chris

Comment #25

toddchris CreditAttribution: toddchris commented 15 March 2009 at 23:19

I'm getting the "access denied" errors as well as admin, and it seems to be on every content type. Usually if you reload once or twice it will finally let you submit the content.

Comment #26

socketwench CreditAttribution: socketwench commented 22 April 2009 at 06:16

Subscribing.

I was experiencing similar errors and applied a menu.inc patch here: http://drupal.org/node/246653#comment-1482178

After a few days, my menu_router issues stopped. Now I'm having errors with panels_page_router_store. Could this be related?

Comment #27

jmpalomar CreditAttribution: jmpalomar commented 18 July 2009 at 08:52

Subscribing.

Comment #28

hal2 CreditAttribution: hal2 commented 4 December 2009 at 23:03

Yeah I have many similar errors of:
user warning: Duplicate entry 'admin/store/settings/countries/edit/formats' for key 1 query: INSERT INTO menu_router (path, load_functions, to_arg_functions, access_callback, access_arguments, page_callback, page_arguments, fit, number_parts, tab_parent, tab_root, title, title_callback, title_arguments, type, block_callback, description, position, weight, file) VALUES ('admin/store/settings/countries/edit/formats', '', '', 'user_access', 'a:1:{i:0;s:16:\"administer store\";}', 'drupal_get_form', 'a:1:{i:0;s:23:\"uc_country_formats_form\";}', 63, 6, 'admin/store/settings/countries/edit', 'admin/store/settings/countries', 'Country formats', 't', '', 128, '', 'Edit the country specific format settings.', '', -5, 'sites/all/modules/ubercart/uc_store/uc_store.admin.inc') in /home/www/mysite.net/includes/menu.inc on line 2423.

Maybe it has something to do with 128 and countries from ubercart, maybe not.

Some other errors were overcome by deleting older folders of the same duplicate name, like in the acquia folder where I didn't think to look before.

Comment #29

nfw CreditAttribution: nfw commented 31 December 2009 at 21:23

subscribing - having the same issue

Comment #30

locomo CreditAttribution: locomo commented 17 January 2010 at 21:16

subscribing

Comment #31

joshmccormack CreditAttribution: joshmccormack commented 27 July 2010 at 23:03

I just had the "Access Denied. You are not authorized to access this page" issue. I checked permissions, rebuilt them, turned off modules, etc. until I found this thread. I shut off OG Content Type Administration and I'm back in business. What a pain.