Here is my situation:

  • Website configured and running without serious problems for a couple of months in a shared server.
  • The day before yesterday I installed ACL and during the update.php the site got frozen. About an hour or two later the entire server mysql returned a "too many connections" message.
  • Today I restored the site to a previous state (previous to the installation of ACL). Then I reinstalled ACL (without problems this time) and just a couple of hours later the site seems to be frozen.
  • I bet in a couple of hours the entire server will hang up.

Anybody else with the same problem? Any idea of what should I check?

Regards.

Comments

NoRandom’s picture

NoRandom commented

Small update, it seems, something is consumming too much memory:

4259  	myuser 	93468 kB 	/usr/local/php5/bin/php
8620  	myuser 	93468 kB 	/usr/local/php5/bin/php
15788 	myuser 	93468 kB 	/usr/local/php5/bin/php
20207 	myuser 	93468 kB 	/usr/local/php5/bin/php
25880 	myuser 	93468 kB 	/usr/local/php5/bin/php
31436 	myuser 	93468 kB 	/usr/local/php5/bin/php
29393 	myuser 	93340 kB 	/usr/local/php5/bin/php
salvis’s picture

salvis
he/his
commented
Category: bug » support

I've never heard of this.

When you install ACL, you should get a message that tells you to rebuild permissions. Did you do that?

ACL by itself doesn't do anything. It's just an API module providing services for other modules and it has no user interface. What other module(s) did you install with it?

NoRandom’s picture

NoRandom commented

Yes, I've rebuilt the permissions. I'm using it with Forum Access.

Currently I've totally deleted the acl tables from db (wich comes from D5 branch) and also the module. Server seems to work fine now. Anyway, I'm not really sure about the cause since last time frozen happened when I was simply editing a node wich is not controlled by ACL. I'm going to leave this configuration for a time to check what happens.

Regards.

NoRandom’s picture

NoRandom commented

Almost one month later the site is working right without ACL but maybe the problem came from other place.

Anyway, as I said I removed totally ACL deleting the module, uninstalling it and removing remain tables from database. Now I'm reinstalling it again and just after the installation process, when you need to rebuild the content access permissions I get this error message:

user warning: Table 'mydb.acl_user' doesn't exist query: SELECT acl_id FROM acl_user WHERE uid = 1 in /home/mysite/www/sites/all/modules/acl/acl.module on line 148.

After clicking on the buttong the progress bar appears and works until the 100% and then a lot o errors appears:

# user warning: Table 'mydb.acl_user' doesn't exist query: SELECT acl_id FROM acl_user WHERE uid = 1 in /home/mysite/www/sites/all/modules/acl/acl.module on line 148.
# user warning: Table 'mydb.acl_user' doesn't exist query: SELECT acl_id FROM acl_user WHERE uid = 1 in /home/mysite/www/sites/all/modules/acl/acl.module on line 148.
# user warning: Table 'mydb.acl_node' doesn't exist query: SELECT n.*, 'acl' AS realm, n.acl_id AS gid, a.module FROM acl_node n INNER JOIN acl a ON n.acl_id = a.acl_id WHERE nid = 1 in /home/mysite/www/sites/all/modules/acl/acl.module on line 120.
# user warning: Table 'mydb.acl_node' doesn't exist query: SELECT n.*, 'acl' AS realm, n.acl_id AS gid, a.module FROM acl_node n INNER JOIN acl a ON n.acl_id = a.acl_id WHERE nid = 2 in /home/mysite/www/sites/all/modules/acl/acl.module on line 120.

Regards.

UPDATE:

Second time I reinstall the module everything seems to be right, I don't get error messages.

salvis’s picture

salvis
he/his
commented
Status: Active » Closed (won't fix)

According to http://drupal.org/project/usage/acl we have 6,609 confirmed sites running ACL 6.x-1.0, as of December 13.

Your issues are unique. There is no random behavior in ACL.

If your server is unable to predictably create a few database tables, then your server has severe problems that are outside the scope of Drupal. (Nothing will work anymore after that, of course!).

The "something" that "is consumming too much memory" is not likely to go away. I don't think there's anything I can do to help you.

If it were my server, I'd dump it and reinstall my site on a new server from scratch, taking extra care to not move any security holes / backdoors along with the data.

BTW, do not try to clear the ACL tables and hope that ACL client modules such as Forum Access would continue to work. The proper procedure to restart from scratch is to disable and uninstall the module(s) and then reinstall. Drupal will then ensure that you don't break any dependencies.

Anyway, as I said I removed totally ACL deleting the module, uninstalling it and removing remain tables from database.

You have it completely backwards. You must disable, uninstall, and finally delete the module in that order. Removing remaining tables is not necessary, because if you follow the proper sequence, no tables remain and everything is cleaned up properly. The way you manage your site, you are actively breaking it, and it's all downhill from there...

NoRandom’s picture

NoRandom commented

Thanks, salvis.

Anyway, as I said I removed totally ACL deleting the module, uninstalling it and removing remain tables from database.

Sorry, I explained it wrong but I did it in the right order.

Currently the problem persists. The site runs perfectly if it's in offline mode but it gets frozen whenever I open it.

Thanks for your suggestion, I got to check it in another server. Anyway the server is currently hosting some wordpress blogs, one vbulletin forum and another installation of Drupal 5 and they work fine.

Regards and happy new year.

NoRandom’s picture

NoRandom commented
Status: Closed (won't fix) » Closed (fixed)

Finally some light at the end of the tunnel. The site "survived" this morning to a hang up and the error logs indicate some errors related with "taxonomy filter" module.

#671552: Is Taxonomy filter saturating my site?