1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

XF 1.2 Error Messages

Discussion in 'Troubleshooting and Problems' started by Inkman, Sep 29, 2013.

  1. Inkman

    Inkman Active Member

    I have just been un-installing two addons and i done one and got an error so refreshed and it was fine so started uninstalling the next and that made an error and then went onto the next one and in the middle of it it came up with:
    The other error was:
    And now cannot do anything on my site, can anyone help please? Never had this happen before :(
     
  2. Inkman

    Inkman Active Member

    Just a little update i cant even try and login it just keeps going back to the server error please try again later. and if i try and go to my admin login it comes up with the second error message above.
     
  3. Digital Doctor

    Digital Doctor Well-Known Member

    Deadlock error: [info]
     
  4. Digital Doctor

    Digital Doctor Well-Known Member

    Mysqli prepare error: Table doesn't exist [info]

     
  5. Inkman

    Inkman Active Member

    No definitely not clearing with a refresh, like i said in my last post i cant even try and login it just keeps going back to the server error please try again later. and if i try and go to my admin login it comes up with the second error message above. So the deadlock error seemed to be just from un-installing an addon... So gutted just dont know what to do now :(
     
  6. Inkman

    Inkman Active Member

    I wasn't upgrading i was un-installing an addon :s
     
  7. Jeremy

    Jeremy XenForo Moderator Staff Member

    Try restarting your MySQL server to clear a deadlock.
     
  8. Inkman

    Inkman Active Member

    How would you do that @Jeremy ? Sorry dont know my way around this type of thing that well. :(
     
  9. Jeremy

    Jeremy XenForo Moderator Staff Member

    Do you have root access? Your host should be able to.
     
  10. Inkman

    Inkman Active Member

    Can you do that through phpmyadmin?
     
  11. Jeremy

    Jeremy XenForo Moderator Staff Member

    No. Or not that I know of.
     
  12. Inkman

    Inkman Active Member

    Its ok @Mike helped me and got it resolved.
    Thanks to everyone that tried to help.
     
  13. Digital Doctor

    Digital Doctor Well-Known Member

    What did he do ... so others in the future can be helped ?

    I read this on stackoverflow ... it's how to avoid deadlocks from a programming perspective ... so I guess it won't help. :(

    If you are using InnoDB or any row-level transactional RDBMS, then it is possible that any write transaction can cause a deadlock, even in perfectly normal situations. Larger tables, larger writes, and long transaction blocks will often increase the likelihood of deadlocks occurring. In your situation, it's probably a combination of these.

    The only way to truly handle deadlocks is to write your code to expect them. This generally isn't very difficult if your database code is well written. Often you can just put a try/catch around the query execution logic and look for a deadlock when errors occur. If you catch one, the normal thing to do is just attempt to execute the failed query again.

    I highly recommend you read this page in the MySQL manual. It has a list of things to do to help cope with deadlocks and reduce their frequency.

    this page is ..
    http://dev.mysql.com/doc/refman/5.0/en/innodb-deadlocks.html

    Deadlocks are a classic problem in transactional databases, but they are not dangerous unless they are so frequent that you cannot run certain transactions at all. Normally, you must write your applications so that they are always prepared to re-issue a transaction if it gets rolled back because of a deadlock.

    InnoDB uses automatic row-level locking. You can get deadlocks even in the case of transactions that just insert or delete a single row. That is because these operations are not really “atomic”; they automatically set locks on the (possibly several) index records of the row inserted or deleted.

    Sounds like these deadlocks are inevitable.
     
  14. Inkman

    Inkman Active Member

    He asked me to disable the add-ons and then to make sure the add-on i was getting error messages for (xentrader) was un-installed totally and then to re-install it again and then once that was done, finally un-install it again and funnily enough it worked. Simple but effective lol.
     

Share This Page