Page 1 of 2 12 LastLast
Results 1 to 10 of 17

Thread: got error while running query

  1. #1
    jayarajmohan is offline Special Member
    Join Date
    Nov 2008
    Location
    Coimbatore,Tamil Nadu, India.
    Posts
    131
    Rep Power
    6

    Exclamation got error while running query

    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

  2. #2
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,568
    Rep Power
    57

    Default

    Quote Originally Posted by jayarajmohan View Post
    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?
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  3. #3
    jayarajmohan is offline Special Member
    Join Date
    Nov 2008
    Location
    Coimbatore,Tamil Nadu, India.
    Posts
    131
    Rep Power
    6

    Default

    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 ?

  4. #4
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,568
    Rep Power
    57

    Default

    Quote Originally Posted by jayarajmohan View Post
    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.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

  5. #5
    jayarajmohan is offline Special Member
    Join Date
    Nov 2008
    Location
    Coimbatore,Tamil Nadu, India.
    Posts
    131
    Rep Power
    6

    Default

    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 ..

  6. #6
    jayarajmohan is offline Special Member
    Join Date
    Nov 2008
    Location
    Coimbatore,Tamil Nadu, India.
    Posts
    131
    Rep Power
    6

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

    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 ?

  7. #7
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

    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.

  8. #8
    jayarajmohan is offline Special Member
    Join Date
    Nov 2008
    Location
    Coimbatore,Tamil Nadu, India.
    Posts
    131
    Rep Power
    6

    Default

    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

  9. #9
    uxbod's Avatar
    uxbod is offline Moderator
    Join Date
    Nov 2006
    Location
    UK
    Posts
    8,017
    Rep Power
    24

    Default

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

  10. #10
    phoenix is offline Zimbra Consultant & Moderator
    Join Date
    Sep 2005
    Location
    Vannes, France
    Posts
    23,568
    Rep Power
    57

    Default

    Quote Originally Posted by jayarajmohan View Post
    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.
    Regards


    Bill


    Acompli: A new adventure for Co-Founder KevinH.

Page 1 of 2 12 LastLast

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. zmmailboxdctl is stopped frequently..
    By tamilnandhu in forum Installation
    Replies: 13
    Last Post: 04-12-2008, 08:59 AM
  2. Can't seem to get global in BES
    By sdemeyer in forum Zimbra Connector for BlackBerry
    Replies: 12
    Last Post: 03-19-2008, 08:22 AM
  3. Replies: 4
    Last Post: 11-14-2007, 02:19 PM
  4. Post instsallation problems
    By Assaf in forum Installation
    Replies: 14
    Last Post: 01-29-2007, 11:38 AM
  5. Trouble sending mail from Outlook
    By czaveri in forum Users
    Replies: 15
    Last Post: 07-24-2006, 11:01 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •