# Mysql Error RELEASE SAVEPOINT active\_record\_1

**URL:** <https://www.ruby-forum.com/t/mysql-error-release-savepoint-active-record-1/164333>\
**Category:** Rails\
**Created:** [March 31, 2009, 9:42am UTC](https://www.ruby-forum.com/t/mysql-error-release-savepoint-active-record-1/164333 "2009-03-31T09:42:26Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![bobm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@bobm](https://www.ruby-forum.com/u/bobm)\
**Post date:** [March 31, 2009, 9:42am UTC](https://www.ruby-forum.com/t/mysql-error-release-savepoint-active-record-1/164333/1 "2009-03-31T09:42:26Z")

</div>

Hi, I’m trying to upgrade an app from 2.2.2 to 2.3.2 and I get a bunch  
of Mysql Errors : Mysql::Error: You have an error in your SQL syntax;  
check the manual that corresponds to your MySQL server version for the  
right syntax to use near ‘RELEASE SAVEPOINT active\_record\_1’ at line 1:  
RELEASE SAVEPOINT active\_record\_1

Mysql version is 4.1.22 which supports save points but not the RELEASE  
SAVEPOINT command. I did a test under mysql console.

So,

- is Rails 2.3.2 incompatible with mysql 4.1.22 ?
- is there a special Mysql adapter ?

Thanks

---

<div class="post-metadata">

**Author:** ![bobm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@bobm](https://www.ruby-forum.com/u/bobm)\
**Post date:** [January 8, 2010, 10:56am UTC](https://www.ruby-forum.com/t/mysql-error-release-savepoint-active-record-1/164333/2 "2010-01-08T10:56:44Z")

</div>

Even i am searching answer for the same …  
Champs please write something … 🙂

Bob M. wrote:

> Hi, I’m trying to upgrade an app from 2.2.2 to 2.3.2 and I get a bunch  
> of Mysql Errors : Mysql::Error: You have an error in your SQL syntax;  
> check the manual that corresponds to your MySQL server version for the  
> right syntax to use near ‘RELEASE SAVEPOINT active\_record\_1’ at line 1:  
> RELEASE SAVEPOINT active\_record\_1
> 
> Mysql version is 4.1.22 which supports save points but not the RELEASE  
> SAVEPOINT command. I did a test under mysql console.
> 
> So,
> 
> - is Rails 2.3.2 incompatible with mysql 4.1.22 ?
> - is there a special Mysql adapter ?
> 
> Thanks

---

<div class="post-metadata">

**Author:** ![bobm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@bobm](https://www.ruby-forum.com/u/bobm)\
**Post date:** [January 8, 2010, 11:30am UTC](https://www.ruby-forum.com/t/mysql-error-release-savepoint-active-record-1/164333/3 "2010-01-08T11:30:08Z")

</div>

On Jan 8, 9:56Â am, Hemant B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:

> Even i am searching answer for the same …  
> Champs please write something … 🙂

If I remember correctly there is a method in mysql\_adapter that says  
it supports savepoints, you could override it and return false

Fred

---

<div class="post-metadata">

**Author:** ![bobm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@bobm](https://www.ruby-forum.com/u/bobm)\
**Post date:** [January 8, 2010, 3:08pm UTC](https://www.ruby-forum.com/t/mysql-error-release-savepoint-active-record-1/164333/4 "2010-01-08T15:08:02Z")

</div>

Where can i get this description … ?

Frederick C. wrote:

> On Jan 8, 9:56Â am, Hemant B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> 
> > Even i am searching answer for the same …  
> > Champs please write something … 🙂
> 
> If I remember correctly there is a method in mysql\_adapter that says  
> it supports savepoints, you could override it and return false
> 
> Fred

---

<div class="post-metadata">

**Author:** ![bobm](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/b/9fc348/32.png) [@bobm](https://www.ruby-forum.com/u/bobm)\
**Post date:** [March 11, 2010, 10:37am UTC](https://www.ruby-forum.com/t/mysql-error-release-savepoint-active-record-1/164333/5 "2010-03-11T10:37:43Z")

</div>

I get around this issue :

[http://my.rails-royce.org/2010/03/11/mysql-4-x-and-rails-release-savepoint-issue/](http://my.rails-royce.org/2010/03/11/mysql-4-x-and-rails-release-savepoint-issue/)

Cheers  
Hemant B. wrote:

> Where can i get this description … ?
> 
> Frederick C. wrote:
> 
> > On Jan 8, 9:56Â am, Hemant B. [removed\_email\_address@domain.invalid](mailto:removed_email_address@domain.invalid) wrote:
> > 
> > > Even i am searching answer for the same …  
> > > Champs please write something … 🙂
> > 
> > If I remember correctly there is a method in mysql\_adapter that says  
> > it supports savepoints, you could override it and return false
> > 
> > Fred