List:General Discussion« Previous MessageNext Message »
From:BÁRTHÁZI András Date:January 31 2006 7:37pm
Subject:Error: server is running,with the --read-only option
View as plain text  
Hi,

I get these errors:

----
[31-Jan-2006 17:25:59] PHP Fatal error:  The MySQL server is running
with the --read-only option so it cannot execute this statement
query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES
('22177a73e9b93b88e376c2226d000f7b', 0, '68.142.250.172', 1138724759) in
/data/.../database.mysql.inc on line 66
----
[31-Jan-2006 18:29:02] PHP Fatal error:  The MySQL server is running
with the --read-only option so it cannot execute this statement
query: INSERT INTO sessions (sid, uid, hostname, timestamp) VALUES
('bf2de39170b0e02952cf1ab9cf7af6b0', 0, '68.142.250.46', 1138728542) in
/data/.../database.mysql.inc on line 66
----

The database is NOT read-only. I get this error every 10-60 minutes, but 
the MySQL server used continously (on this particular web page, there 
are ~30.000 hits a day). It's a MASTER server in replication. I don't 
know about any LOCK situation (but I think if it would be LOCK, then the 
error would be about LOCK).

Any ideas, why this happens? Google gave me no results.

Bye,
   Andras
Thread
Error: server is running,with the --read-only optionBÁRTHÁZI András31 Jan
  • Re: Error: server is running,with the --read-only optionAdy Wicaksono1 Feb
    • Re: Error: server is running,with the --read-only optionBÁRTHÁZI András1 Feb