Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL Rollback Issues

Discussion in 'General Discussion' started by Xyrael, Mar 5, 2006.

  1. Xyrael

    Xyrael Member

    Joined:
    Oct 10, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    151
    All of a sudden, a user is getting this message spouted by phpbb2:
    Code:
    SQL Error : 1196 Warning: Some non-transactional changed tables couldn't be rolled back
    I don't know where it has come from, but suspect that it may have come from a upcp run recently - has anyone else been experiencing the problem? Thanks.
     
  2. shashank

    shashank Well-Known Member
    PartnerNOC

    Joined:
    Apr 12, 2003
    Messages:
    159
    Likes Received:
    1
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    What mysql version do you have ?

    http://dev.mysql.com/doc/refman/5.0/en/non-transactional-tables.html shows :

    If you receive the following message when trying to perform a ROLLBACK, it means that one or more of the tables you used in the transaction do not support transactions:

    Warning: Some non-transactional changed tables couldn't be rolled back
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  3. Xyrael

    Xyrael Member

    Joined:
    Oct 10, 2005
    Messages:
    22
    Likes Received:
    0
    Trophy Points:
    151
    Code:
    [email]sean@silentflame.com[/email] [~]# mysql -V
    mysql  Ver 12.22 Distrib 4.0.25, for pc-linux-gnu (i686)
    
    Thanks for your help :)
     
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice