title: My SQL error #1015 - Can't lock file (errno: 165 - Table is read only) innodb engine only
body: <p>My SQL error </p>
  
  <pre><code>#1015 - Can't lock file (errno: 165 - Table is read only)
  </code></pre>
  
  <p>innodb engine only </p>
  
  <p>first the MySql start to stop work and needed restart almost every day</p>
  
  <p>then it's start to work in read only mode </p>
  
  <p>MySQL version is 5.6</p>
  
  <p>my.cnf content</p>
  
  <pre><code>[mysqld]
  innodb_file_per_table=1
  default-storage-engine=MyISAM
  max_allowed_packet=268435456
  innodb_buffer_pool_size=134217728
  innodb_force_recovery=4
  </code></pre>
  
  <p>my log</p>
  
  <pre><code>140819 05:48:57 mysqld_safe mysqld from pid file /var/lib/mysql/server1.mohdev.com.pid ended
  140819 05:48:58 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql
  2014-08-19 05:48:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
  2014-08-19 05:48:59 9876 [Note] Plugin 'FEDERATED' is disabled.
  2014-08-19 05:48:59 9876 [Note] InnoDB: Started in read only mode
  2014-08-19 05:48:59 9876 [Note] InnoDB: Using atomics to ref count buffer pool pages
  2014-08-19 05:48:59 9876 [Note] InnoDB: The InnoDB memory heap is disabled
  2014-08-19 05:48:59 9876 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
  2014-08-19 05:48:59 9876 [Note] InnoDB: Compressed tables use zlib 1.2.3
  2014-08-19 05:48:59 9876 [Note] InnoDB: Using Linux native AIO
  2014-08-19 05:48:59 9876 [Note] InnoDB: Using CPU crc32 instructions
  2014-08-19 05:48:59 9876 [Note] InnoDB: Disabling background IO write threads.
  2014-08-19 05:48:59 9876 [Note] InnoDB: Initializing buffer pool, size = 128.0M
  2014-08-19 05:48:59 9876 [Note] InnoDB: Completed initialization of buffer pool
  2014-08-19 05:48:59 9876 [Note] InnoDB: Highest supported file format is Barracuda.
  2014-08-19 05:48:59 9876 [Note] InnoDB: 5.6.17 started; log sequence number 2706168115
  2014-08-19 05:48:59 9876 [Note] InnoDB: !!! innodb_force_recovery is set to 4 !!!
  2014-08-19 05:48:59 9876 [Note] Server hostname (bind-address): '*'; port: 3306
  2014-08-19 05:48:59 9876 [Note] IPv6 is not available.
  2014-08-19 05:48:59 9876 [Note]   - '0.0.0.0' resolves to '0.0.0.0';
  2014-08-19 05:48:59 9876 [Note] Server socket created on IP: '0.0.0.0'.
  2014-08-19 05:48:59 9876 [Note] Event Scheduler: Loaded 0 events
  2014-08-19 05:48:59 9876 [Note] /usr/sbin/mysqld: ready for connections.
  Version: '5.6.17'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server (GPL)
  2014-08-19 05:49:22 9876 [ERROR] InnoDB: Failed to find tablespace for table '"epl_mdb"."jpxsqzjy_options"' in the cache. Attempting to load the tablespace with space id 1156.
  2014-08-19 05:49:22 9876 [Warning] InnoDB: Allocated tablespace 1156, old maximum was 0
  2014-08-19 05:49:22 9876 [ERROR] InnoDB: Failed to find tablespace for table '"epl_mdb"."jpxsqzjy_posts"' in the cache. Attempting to load the tablespace with space id 584.
  2014-08-19 05:49:23 9876 [ERROR] InnoDB: Failed to find tablespace for table '"epl_mdb"."jpxsqzjy_term_taxonomy"' in the cache. Attempting to load the tablespace with space id 591.
  2014-08-19 05:54:26 9876 [Note] /usr/sbin/mysqld: Normal shutdown
  
  2014-08-19 05:54:26 9876 [Note] Giving 1 client threads a chance to die gracefully
  2014-08-19 05:54:26 9876 [Note] Event Scheduler: Purging the queue. 0 events
  2014-08-19 05:54:26 9876 [Note] Shutting down slave threads
  2014-08-19 05:54:28 9876 [Note] Forcefully disconnecting 1 remaining clients
  2014-08-19 05:54:28 9876 [Warning] /usr/sbin/mysqld: Forcing close of thread 3  user: 'leechprotect'
  </code></pre>
  
  <p>i tried to add</p>
  
  <pre><code>innodb-read-only=0
  </code></pre>
  
  <p>in my.cnf but no luck
  any suggestions
  thanks</p>