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
I can be sure, because usually these inserts are working well. And all
the other databases and tables are working well, too. All the databases
are on the same partition, in the same directory.
[mysqld]
user = mysql
server-id = 1
pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock
port = 3306
log = /var/log/mysql.log
log-bin = /backup/mysql-binlog/wish-bin
basedir = /usr
datadir = /data/database
tmpdir = /tmp
language = /usr/local/mysql/share/mysql/english
skip-locking
query_cache_limit = 2M
query_cache_size = 64M
query_cache_type = 1
set-variable = key_buffer=512K
set-variable = sort_buffer=16K
set-variable = table_cache=2048
set-variable = read_buffer=8K
set-variable = thread_stack=64K
set-variable = max_connections=199
set-variable = flush_time=20
set-variable = net_buffer_length=128K
character-sets-dir=/usr/local/mysql/share/mysql/charsets
default-character-set = latin2
default-collation = latin2_hungarian_ci
set-variable = ft_min_word_len=2
set-variable = max_allowed_packet=2M
/dev/hdc1 /data ext3 defaults 0 2
-rw-rw---- 1 mysql mysql 8700 már 8 2005 sessions.frm
-rw-rw---- 1 mysql mysql 9177628 feb 1 20:26 sessions.MYD
-rw-rw---- 1 mysql mysql 11057152 feb 1 20:26 sessions.MYI
Debian Linux, MySQL 5.0.18, PHP 4.4.2, Apache 1.3.34 (all the latest)
CREATE TABLE `sessions` (
`uid` int(10) unsigned NOT NULL default '0',
`sid` varchar(32) NOT NULL default '',
`hostname` varchar(128) NOT NULL default '',
`timestamp` int(11) NOT NULL default '0',
`session` longtext,
PRIMARY KEY (`sid`),
KEY `uid` (`uid`),
KEY `sid` (`sid`(4)),
KEY `timestamp` (`timestamp`)
) ENGINE=MyISAM DEFAULT CHARSET=latin2;
No memory (1GB+256MB swap) and no disk space problem (just 44% used).
Bye,
Andras
----
[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.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
