The problem is that mysql server restarts itself. I
read in mysql list that the possible reason is some
bad query. I understand that I can find it in the
mysqlbinlog. There is 3 queries in it and I repair
one, but others were from module Apache::Session. One
was this and looks OK but what is the r
Hello there!
I'm using Apache-Session module and it seems that
everything work properly, but in bin log is this
query:
DO
RELEASE_LOCK("Apache-Session-0c47492fccde576b180ea37fa07de395");
What could be wrong in it?
Please help!
Kosyo
__
On Mon, Feb 11, 2002 at 04:37:39AM -0800, Konstantin Yotov wrote:
> Hello there!
>
> I'm using Apache-Session module and it seems that everything work
> properly, but in bin log is this query:
>
> DO
> RELEASE_LOCK("Apache-Session-0c47492fccde576b180ea37fa07de395
Hello there!
I'm using Apache-Session module and it seems that
everything work properly, but in bin log is this
query:
DO
RELEASE_LOCK("Apache-Session-0c47492fccde576b180ea37fa07de395");
What could be wrong in it?
Please help!
Kosyo
__
Anton kornexl writes:
> >Description:
> If i call get_lock('kornexl',10) in the master (Version 3.23.47), and
> release_lock('kornexl') later, there are no errors in the master.
> The slave (Version 3.23.44) stops with the following error:
>Description:
If i call get_lock('kornexl',10) in the master (Version 3.23.47), and
release_lock('kornexl') later, there are no errors in the master.
The slave (Version 3.23.44) stops with the following error:
ERROR: 1064 You have an error in y
On 22-Jun-01 Carsten H. Pedersen wrote:
> Has anyone successfully passed the get_lock()
> and release_lock() commands to a MySQL
> server using PHP? If so, how did you go about it?
Yes;
mysql_query("SELECT GET_LOCK('signups',20)");
fillsignups();
m
Hello.
I am not using PHP, so take my comment with a grain of salt.
PHP doesn't need explicit support for GET_LOCK and RELEASE_LOCK as
they are both just simply SQL functions. So I am not sure what you
problem is, just execute the following query:
SELECT GET_LOCK('whatever'
Has anyone successfully passed the get_lock()
and release_lock() commands to a MySQL
server using PHP? If so, how did you go about it?
PHP does not seem to implement these functions
despite the fact that they have been around since
sometime in March/April 1998.
/ Carsten
--
Natural selection
