Hi

If you really sure that your MySQL is not in read only option, better you give us the my.cnf configuration also mount result for all filesystem partition so we sure that the data MySQL is not mounted read-only

Thx

BÁRTHÁZI András wrote:

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




--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to