# mysql\_db single\_transaction breaks import

**URL:** <https://forum.ansible.com/t/mysql-db-single-transaction-breaks-import/21643>\
**Category:** Ansible Project\
**Created:** [June 2, 2016, 1:17pm UTC](https://forum.ansible.com/t/mysql-db-single-transaction-breaks-import/21643 "2016-06-02T13:17:04Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Chris\_Short](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@Chris\_Short](https://forum.ansible.com/u/Chris_Short)\
**Post date:** [June 2, 2016, 1:17pm UTC](https://forum.ansible.com/t/mysql-db-single-transaction-breaks-import/21643/1 "2016-06-02T13:17:04Z")

</div>

Out of curiosity I have a mysql\_db play in a playbook that imports a database into a pre-production environment. I added single\_transaction=yes to it and the import never fully finished. Not sure if this is a bug or some external issue but since this is new functionality I’d be willing to aid in testing it.

---

<div class="post-metadata">

**Author:** ![Johannes\_Kastl](https://avatars.discourse-cdn.com/v4/letter/j/bbe5ce/32.png) [@Johannes\_Kastl](https://forum.ansible.com/u/Johannes_Kastl)\
**Post date:** [June 2, 2016, 3:03pm UTC](https://forum.ansible.com/t/mysql-db-single-transaction-breaks-import/21643/2 "2016-06-02T15:03:43Z")

</div>

Care to share your playbook? And the exact error messages?

Johannes

---

<div class="post-metadata">

**Author:** ![Chris\_Short](https://avatars.discourse-cdn.com/v4/letter/c/ac8455/32.png) [@Chris\_Short](https://forum.ansible.com/u/Chris_Short)\
**Post date:** [June 2, 2016, 3:14pm UTC](https://forum.ansible.com/t/mysql-db-single-transaction-breaks-import/21643/3 "2016-06-02T15:14:51Z")

</div>



---

<div class="post-metadata">

**Author:** ![Johannes\_Kastl](https://avatars.discourse-cdn.com/v4/letter/j/bbe5ce/32.png) [@Johannes\_Kastl](https://forum.ansible.com/u/Johannes_Kastl)\
**Post date:** [June 2, 2016, 3:18pm UTC](https://forum.ansible.com/t/mysql-db-single-transaction-breaks-import/21643/4 "2016-06-02T15:18:01Z")

</div>

I had that sometimes, then I killed the process on the target host,  
and voilá I had some error message on the controller running the  
ansible task (I run with -v, to get more output).

I would guess it waits for input. Forever.

Johannes