DB failed

[GoogleCodeExporter]

when I tried updating the install node it gives me this:

DBD::mysql::st execute failed: Table 'syslogs_index_40007096' is read only at 
/usr/local/elsa/node/Indexer.pm line 1317.
DBD::mysql::st execute failed: Table 'syslogs_index_40007096' is read only at 
/usr/local/elsa/node/Indexer.pm line 1317.
test_elsa FAIL

I tried to repair the table but it gives an error:

[root@elsa ficheiros_guardar]# mysql -uroot -e "REPAIR TABLE 
syslog_data.syslogs_index_40007096"
+------------------------------------+--------+----------+----------------------
-----------------------+
| Table                              | Op     | Msg_type | Msg_text             
                       |
+------------------------------------+--------+----------+----------------------
-----------------------+
| syslog_data.syslogs_index_40007096 | repair | Error    | Table 
'syslogs_index_40007096' is read only |
| syslog_data.syslogs_index_40007096 | repair | error    | Corrupt              
                       |
+------------------------------------+--------+----------+----------------------
-----------------------+

Can you help me solve this problem? thank you

Original issue reported on code.google.com by raquel.b...@gmail.com on 31 Jul 2013 at 10:52

[GoogleCodeExporter]

That's bad news, it means you'll have to drop the table.  The logs should still 
be available in the archive table, so they are there if you need them for 
posterity.  To drop the table, issue:

mysql -uroot -e "DROP TABLE syslog_data.syslogs_index_40007096"

Run the install.sh updates for node and web again, and you should be set.

Original comment by mchol...@gmail.com on 31 Jul 2013 at 8:39

• Added labels: Type-Other
• Removed labels: Type-Defect

[GoogleCodeExporter]

thanks :) solved it

Original comment by raquel.b...@gmail.com on 1 Aug 2013 at 2:23

[GoogleCodeExporter]

Original comment by mchol...@gmail.com on 2 Aug 2013 at 3:17

• Changed state: Done