The total number of locks exceeds the lock table size
Permalink
Hello,
I am trying to add a page to my blog and I am getting the following error: (most of the text is the blog entry, that is supposed to get inserted)
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1206: The total number of locks exceeds the lock table size] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values ('exceptions', 'Exception Occurred: /home/razorbaby/dylanvalentine/public/dylanvalentine.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysql error: [1206: The total number of locks exceeds the lock table size] in EXECUTE("UPDATE btContentLocal SET content=\'<p>I have been working on a small python script that logs to a mysql database. But as the story goes... I wanted to put it on my macbook (osx 10.6) so that I could bring it home and do some work after dinner. Unfortunately, I spent the evening troubleshooting MySQLdb-python. It was one of those scenarios, where solving one problem just unveiled another. But I persevered (with a lot of help from stackoverflow.com).</p>\\r\\n<p> </p>\\r\\n<p>The first issue was when trying to install MySQLdb-pyth in /home/razorbaby/dylanvalentine/public/dylanvalentine.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I really don't even know where to begin troubleshooting.
I have 20 or so other pages in the blog already. I don't know why it's not working today. Nothing has been changed since I installed C5.
can anyone help?
thanks,
Dylan
I am trying to add a page to my blog and I am getting the following error: (most of the text is the blog entry, that is supposed to get inserted)
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1206: The total number of locks exceeds the lock table size] in EXECUTE("insert into Logs (logType, logText, logIsInternal, logUserID) values ('exceptions', 'Exception Occurred: /home/razorbaby/dylanvalentine/public/dylanvalentine.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php:78 mysql error: [1206: The total number of locks exceeds the lock table size] in EXECUTE("UPDATE btContentLocal SET content=\'<p>I have been working on a small python script that logs to a mysql database. But as the story goes... I wanted to put it on my macbook (osx 10.6) so that I could bring it home and do some work after dinner. Unfortunately, I spent the evening troubleshooting MySQLdb-python. It was one of those scenarios, where solving one problem just unveiled another. But I persevered (with a lot of help from stackoverflow.com).</p>\\r\\n<p> </p>\\r\\n<p>The first issue was when trying to install MySQLdb-pyth in /home/razorbaby/dylanvalentine/public/dylanvalentine.com/concrete/libraries/3rdparty/adodb/adodb-exceptions.inc.php on line 78
I really don't even know where to begin troubleshooting.
I have 20 or so other pages in the blog already. I don't know why it's not working today. Nothing has been changed since I installed C5.
can anyone help?
thanks,
Dylan
Thanks for the quick response. I haven't tried messing with my host settings yet, but I quick work around I found was to:
-hit back in the browser, to go back to composer.
-thank someone all my text was still in the editor.
-copy all the text.
-refresh composer page.
-paste text back into editor.
-publish changes as normal.
I am realizing I may have caused this myself, by starting the edit on one network (at home) and trying to finish on another (coffee shop).
I can only imagine there are all kinds of connections and checks that get interrupted when I do this.
-hit back in the browser, to go back to composer.
-thank someone all my text was still in the editor.
-copy all the text.
-refresh composer page.
-paste text back into editor.
-publish changes as normal.
I am realizing I may have caused this myself, by starting the edit on one network (at home) and trying to finish on another (coffee shop).
I can only imagine there are all kinds of connections and checks that get interrupted when I do this.
I can't see any reason why starting an entry on one computer and finishing on another would cause this. I still believe it's some temporary over-loading issue on your server. Can you faithfully replicate this issue or has it only happened once?
Just wanted to send a final Thank-You on this post.
I still haven't tried updating my.cnf. (I am on VPN, so I do have access).
But the issue has yet to show a second time.
Currently, the entire datacenter is down due to 'increasing power fluctuations' frying two routers.
So, it's entirely possible that I was just experiencing the start of what has now been 4 or 5 days of interruption.
Now, if i can just get access to my data....
I still haven't tried updating my.cnf. (I am on VPN, so I do have access).
But the issue has yet to show a second time.
Currently, the entire datacenter is down due to 'increasing power fluctuations' frying two routers.
So, it's entirely possible that I was just experiencing the start of what has now been 4 or 5 days of interruption.
Now, if i can just get access to my data....
http://stackoverflow.com/questions/6901108/the-total-number-of-lock...