# precondition problem mysql

**URL:** <https://forum.liquibase.org/t/precondition-problem-mysql/3035>\
**Category:** General Discussion\
**Created:** [June 20, 2014, 4:49am UTC](https://forum.liquibase.org/t/precondition-problem-mysql/3035 "2014-06-20T04:49:00Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![aorb38](https://avatars.discourse-cdn.com/v4/letter/a/ecc23a/32.png) [@aorb38](https://forum.liquibase.org/u/aorb38)\
**Post date:** [June 20, 2014, 4:49am UTC](https://forum.liquibase.org/t/precondition-problem-mysql/3035/1 "2014-06-20T04:49:00Z")

</div>

Hi

I am having a problem with this changeset

&nbsp;  
&nbsp;&nbsp;&nbsp; &nbsp;   
&nbsp;

&nbsp;&nbsp;&nbsp; \<createSequence incrementBy="1"  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; sequenceName="startpoint"  
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; startValue="1"/\>

When I run this against MySQL database, it still tries to run. Is this a known bug.

John

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [June 20, 2014, 4:49am UTC](https://forum.liquibase.org/t/precondition-problem-mysql/3035/2 "2014-06-20T04:49:00Z")

</div>

It is working for me on 3.2.1. Can you try the newest version? (3.2.1 should be out later today or monday)

Nathan

---

<div class="post-metadata">

**Author:** ![un1401921318163r72id](https://avatars.discourse-cdn.com/v4/letter/u/dbc845/32.png) [@un1401921318163r72id](https://forum.liquibase.org/u/un1401921318163r72id)\
**Post date:** [June 20, 2014, 4:49am UTC](https://forum.liquibase.org/t/precondition-problem-mysql/3035/3 "2014-06-20T04:49:00Z")

</div>

Just tried latest version, I am still getting&nbsp;the error.

 

liquibase: liquibase.statement.core.CreateSequenceStatement is not supported on mysql, but createSequence will still execute

 

SEVERE: null liquibase.exception.ValidationFailedException: Validation Failed: &nbsp;&nbsp;&nbsp;&nbsp; 1 changes have validation failures &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; createSequence is not supported on mysql, ./changelog.xml::1::author

 

 

Then execution of the xml stops processing. I am using MySQL 5.6.17

 

 

Is this caused by the fact that the docs say it is not supported for MySQL?

---

<div class="post-metadata">

**Author:** ![nvoxland](https://avatars.discourse-cdn.com/v4/letter/n/87869e/32.png) [@nvoxland](https://forum.liquibase.org/u/nvoxland)\
**Post date:** [June 20, 2014, 4:49am UTC](https://forum.liquibase.org/t/precondition-problem-mysql/3035/4 "2014-06-20T04:49:00Z")

</div>

Yes, sequences are not supported by mysql which is causing the problem. Previous versions allowed it assuming you knew they wouldn’t get created but a better route is to add a dbms attribute to explicitly handle it.

Nathan