got error while running query

[jayarajmohan]

Dear All,

Error : Got error -1 from storage engine

This is the error while i am executing the delete query in zimbra mysql db..

I am logged in as zimbra user in mysql..

Let me waiting for your idea's ?

Thanks

[phoenix]

Originally Posted by jayarajmohan

Let me waiting for your idea's ?

My idea would be not to delete records from, nor modify in any way, the Zimbra MySQL database as you'll most likely break your system and any modification will probably not be retained during any upgrades. What exactly are you trying to do (and why) and what are the errors in the log files?

[jayarajmohan]

I need to take backup by own code.. cant take backup/restore from the wiki method.. so i planned to take it by my php code.. i can connect db and can exe selection query .. but only i cant run delete row from the table..

I have full rights for my user in mysql.. but still same error..

can u resolve it ?

[phoenix]

Originally Posted by jayarajmohan

I need to take backup by own code.. cant take backup/restore from the wiki method.. so i planned to take it by my php code.. i can connect db and can exe selection query .. but only i cant run delete row from the table..

You still haven't explained why you're deleting data from the tables.

[jayarajmohan]

i need to restore the old data to the user mailbox. So i want to delete the unwanted mails.. thats y i need to delete ..

[jayarajmohan]

While i am executing the query (update query) in zimbra mysql i got this error

ERROR 1030 (HY000): Got error -1 from storage engine

What it means ?

[uxbod]

What query were you trying to perform on the Zimbra MySQL instance ? I would recommend you also check /var/log/messages for any errors as well.

[jayarajmohan]

i didnt see any mysql error in the /var/log/messages ..

just i want to update the mail_item table.. like i want to run :

update mail_item set subject='testingquery' WHERE id=4068

[uxbod]

Do you have anything in /opt/zimbra/log/mysql_error.log ?

[phoenix]

Originally Posted by jayarajmohan

i didnt see any mysql error in the /var/log/messages ..

just i want to update the mail_item table.. like i want to run :

update mail_item set subject='testingquery' WHERE id=4068

Don't create duplicate threads in the forums on the same topic, it makes it difficult to follow-up your posts - I'll merge the threads.