what does this error indicate?

[lauren]

75% of the times i try to save a template i get this infernal error:

(when clicking 'save all changes')

(ironically it saves the template half the time despite this error)

(when clicking 'save and exit')


obviously i need to make some changes within the server environment, but im not sure what i should look at first.
any ideas?

 

[Paul B]

How many styles do you have installed?

 

[lauren]

there are 7 child styles of the default.

 

[Jake Bunce]

If you have root access to the server then you can edit the my.cnf file (usually at /etc/my.cnf) to increase the value of innodb_lock_wait_timeout. Increasing this limit should avoid that error.

Or as Brogan intimated, the number of styles might be causing it to hit the timeout. You can try removing some styles.

 

[lauren]

i do have root access!
i checked my.cnf and there is no innodb_lock_wait_timeout. i did find that restarting the mysql server allowed me to save the template, but the errors started again.
then i reduced the number of styles down to a total of 4 (from a total of 8) and that did stop the problem from reoccurring.
thanks for the help