Hi,
sometimes particularly if new members subscribe to my site they get exactly following information
"Access denied for user: 'Name of Database%' to database 'Name of Database' query: LOCK TABLES sequences WRITE in /var/htdocs/www.orthopoint.de/htdocs/websit e/includes/database.mysql.inc on line 66"
Is this a problem of permissions ? Can I solve this problem via FTP ?
Thank´s
Albrecht
Hi
"Access denied for user: 'Name of Database%' to database 'Name of Database' query: LOCK TABLES sequences WRITE in /var/htdocs/www.orthopoint.de/htdocs/websit e/includes/database.mysql.inc on line 66"
Is this a problem of permissions ? Can I solve this problem via FTP ?
This look like you don't have "GRANT LOCK" on your database. It can be solved if you have the GRANT permission on your MySQL db. But, since you may use an ISP hosting, you may don't have this right. Ask your ISP if you can have the right to make locks on your tables if not, you can either change ISP :( or comment the 2 lines in database.mysql.inc that make this lock : line 151 : db_query('LOCK TABLES {sequences} WRITE'); and db_query('UNLOCK TABLES'); Regards
Nicolas
Thank´s for your help.
I am a child in my knowledge about databases and PHP and it´s not my future job. But I will understand what is going on in this area.
Is it a critical problem ? Or could I leave it until I get help from an expert ?
Kind Regards,
Albrecht
----- Original Message ----- From: "Nicolas Tostin" nicolast@logis.com.mx To: drupal-support@drupal.org Sent: Tuesday, August 09, 2005 4:35 PM Subject: Re: [drupal-support] Error Report
Hi
"Access denied for user: 'Name of Database%' to database 'Name of Database' query: LOCK TABLES sequences WRITE in /var/htdocs/www.orthopoint.de/htdocs/websit e/includes/database.mysql.inc on line 66"
Is this a problem of permissions ? Can I solve this problem via FTP ?
This look like you don't have "GRANT LOCK" on your database. It can be solved if you have the GRANT permission on your MySQL db. But, since you may use an ISP hosting, you may don't have this right. Ask your ISP if you can have the right to make locks on your tables if not, you can either change ISP :( or comment the 2 lines in database.mysql.inc that
make
this lock : line 151 : db_query('LOCK TABLES {sequences} WRITE'); and db_query('UNLOCK TABLES'); Regards
Nicolas
-- [ Drupal support list | http://lists.drupal.org/ ]
On 8/10/05, Albrecht Marignoni ukstart2003@gmx.de wrote:
Thank´s for your help.
I am a child in my knowledge about databases and PHP and it´s not my future job. But I will understand what is going on in this area.
Is it a critical problem ? Or could I leave it until I get help from an expert ?
not critical... but it is annoying... to see this on the logs...
to remove this from been called just add: // at the beginning of the lines mentioned by Tostin.... no expertize needed for that.. good luck...
Kind Regards,
Albrecht
----- Original Message ----- From: "Nicolas Tostin" nicolast@logis.com.mx To: drupal-support@drupal.org Sent: Tuesday, August 09, 2005 4:35 PM Subject: Re: [drupal-support] Error Report
Hi
"Access denied for user: 'Name of Database%' to database 'Name of Database' query: LOCK TABLES sequences WRITE in /var/htdocs/www.orthopoint.de/htdocs/websit e/includes/database.mysql.inc on line 66"
Is this a problem of permissions ? Can I solve this problem via FTP ?
This look like you don't have "GRANT LOCK" on your database. It can be solved if you have the GRANT permission on your MySQL db. But, since you may use an ISP hosting, you may don't have this right. Ask your ISP if you can have the right to make locks on your tables if not, you can either change ISP :( or comment the 2 lines in database.mysql.inc that
make
this lock : line 151 : db_query('LOCK TABLES {sequences} WRITE'); and db_query('UNLOCK TABLES'); Regards
Nicolas
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Thanks.
I am happy about this list and Drupal.
Albrecht ----- Original Message ----- From: "Carlos Rivero" serverleader@gmail.com To: drupal-support@drupal.org Sent: Wednesday, August 10, 2005 2:52 PM Subject: Re: [drupal-support] Error Report
On 8/10/05, Albrecht Marignoni ukstart2003@gmx.de wrote:
Thank´s for your help.
I am a child in my knowledge about databases and PHP and it´s not my future job. But I will understand what is going on in this area.
Is it a critical problem ? Or could I leave it until I get help from an expert ?
not critical... but it is annoying... to see this on the logs...
to remove this from been called just add: // at the beginning of the lines mentioned by Tostin.... no expertize needed for that.. good luck...
Kind Regards,
Albrecht
----- Original Message ----- From: "Nicolas Tostin" nicolast@logis.com.mx To: drupal-support@drupal.org Sent: Tuesday, August 09, 2005 4:35 PM Subject: Re: [drupal-support] Error Report
Hi
"Access denied for user: 'Name of Database%' to database 'Name of Database' query: LOCK TABLES sequences WRITE in /var/htdocs/www.orthopoint.de/htdocs/websit e/includes/database.mysql.inc on line 66"
Is this a problem of permissions ? Can I solve this problem via FTP ?
This look like you don't have "GRANT LOCK" on your database. It can be solved if you have the GRANT permission on your MySQL db. But, since you may use an ISP hosting, you may don't have this right. Ask
your
ISP if you can have the right to make locks on your tables if not, you
can
either change ISP :( or comment the 2 lines in database.mysql.inc that
make
this lock : line 151 : db_query('LOCK TABLES {sequences} WRITE'); and db_query('UNLOCK TABLES'); Regards
Nicolas
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
-- [ Drupal support list | http://lists.drupal.org/ ]
Thanks.
I am happy about this list and Drupal.
That's great ;)
Regarding the removal of the two lines I mention you, your Drupal installation would behave in a perfect normal way. BUT (and there's always a little but ) if you would have a very (I mean very) busy website regarding the creation of nodes/users etc... You may encounter some problems (but I don't think it will happens).
To make you understand the meaning of this LOCK, is to prevent that 2 people simultany make 2 select from the sequence table (the one who give users/nodes their ids) before the update occurs and increment id. So those people would create a user/node with the same id and this is a Database problem. This kind of races shouldn't occur if you have a normal traffic website (IMHO).
Regards
Tostinni
Dear Nicolas,
thank´s twice.
Well I expect 1000 user per day in November/December.
But a college of mine will set up the applications twice. I will only learn to understand was is going on. I must say that all this stuff is very interesting and there is a need for being very accurate....
----- Original Message ----- From: "Nicolas Tostin" nicolast@logis.com.mx To: drupal-support@drupal.org Sent: Wednesday, August 10, 2005 7:02 PM Subject: Re: [drupal-support] Error Report
Thanks.
I am happy about this list and Drupal.
That's great ;)
Regarding the removal of the two lines I mention you, your Drupal installation would behave in a perfect normal way. BUT (and there's always a little but ) if you would have a very (I mean very) busy website regarding the creation of nodes/users etc... You may encounter some problems (but I don't think it will happens).
To make you understand the meaning of this LOCK, is to prevent that 2
people
simultany make 2 select from the sequence table (the one who give users/nodes their ids) before the update occurs and increment id. So those people would create a user/node with the same id and this is a Database problem. This kind of races shouldn't occur if you have a normal traffic website (IMHO).
Regards
Tostinni
-- [ Drupal support list | http://lists.drupal.org/ ]
Hi Albrecht
thank´s twice.
You're welcome, I face the same problem, so if I can give feedback for user, that's a pleasure, and it also helps me to understand better drupal internals
Well I expect 1000 user per day in November/December.
In fact, the problem may occurs during node/user creation, but if there is not so much I don't think you encouter this issue. And as I told you it's a race DB problem, so it's very very rare for this to happens, but it's better to put the LOCK to avoid this kind of problems. If you want to go deeper, I would suggest to have a look at the post that made jeremy about file-based locking : http://drupal.org/node/21556 it's a little complex but talk about the race problem making DB locks...
Well, hope you will have good time using drupal, feel free to ask more support.
Regards
Nicolas
I'm hiring a new Linux box because I just got tired of problems at my old Linux hosting provider.
The new provider gives me 2 choices for Linux flavors:
CentOS 3 Enterprise Linux Fedora Linux Core 3
Any preference or recommendation on which to choose?
-
Albrecht Marignoni -
Carlos Miranda Levy -
Carlos Rivero -
Nicolas Tostin