Question

Getting this error when updating smartform database with updater

could not execute SQL statement:

Error 1036 (HY000): Table 'daily_jockeys_insights' is read only

Press Enter/Return to close

Answer 1

Hi,

This looks like a local issue with regard to permissions on your local database, specifically the daily_jockeys_insights table, so needs local troubleshooting.    To be sure, did the updates work before but now do not?   You can isolate the issue to a table level by checking that updates work on an individual feed, eg. run

smartfofrm-updater daily

Is it a single table issue or global?

There are many reasons why this might have occurred, including that the system disk is full so MySQL switched to read only mode.

If it's a single table issue, you can try repair table or re-installing that particular table.  If global, you can check system level issues (such as disk) or global settings in MySQL for permissions.

Comments

Its read only on all insights tables and non_runners, the other tables are ok - disk space is ok aswell

---

There's no server side explanation for this.  Presumably the other tables were updating ok before today?   It's worth checking permissions locally for "read only" on an SQL or directory level, and you could try changing these.  If all else fails, try re-installing the tables one by one and see if that fixes it for you.

---

strange thing is looking at mysql database using workbench all the tables that update are MyISAM engines and the ones that dont update are InnoDB engines, I dont know why there are 2 engines - all was working yesterday

---

There are 2 engines depending on when the tables were created but that is a characteristic of the dbase and isn't a problem in itself.  Potentially your lcoal InnoDB engine might have had issues since yesterday.  Try SHOW VARIABLES LIKE 'innodb_force_recovery';