# Strange issue between Mautic and MariaDB

**URL:** <https://forum.mautic.org/t/strange-issue-between-mautic-and-mariadb/9888>\
**Category:** General Discussion\
**Created:** [November 13, 2017, 2:15pm UTC](https://forum.mautic.org/t/strange-issue-between-mautic-and-mariadb/9888 "2017-11-13T14:15:30Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![sandrovenezuela](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/sandrovenezuela/32/9241_2.png) [@sandrovenezuela](https://forum.mautic.org/u/sandrovenezuela)\
**Post date:** [November 13, 2017, 2:15pm UTC](https://forum.mautic.org/t/strange-issue-between-mautic-and-mariadb/9888/1 "2017-11-13T14:15:30Z")

</div>

Hi all,  
  
  
  
This is my first question here at the Mautic forum.  
  
  
  
I have a strange problem between Mautic and MariaDB. I have Mautic (version 2.11.0) installed on a server with the CentOS 7 system and with MariaDB (version 5.5.56-2).  
  
  
  
When a campaign receives data from a form, the error occurs:  
  
  
  
mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘SELECT c0\_.id AS id\_0, c0\_.name AS name\_1, c0\_.description AS description\_2, c0\_.type AS type\_3, c0\_.event\_type AS event\_type\_4, c0\_.event\_order AS event\_order\_5, c0\_.properties AS properties\_6, c0\_.trigger\_date AS trigger\_date\_7, c0\_.trigger\_interval AS trigger\_interval\_8, c0\_.trigger\_interval\_unit AS trigger\_interval\_unit\_9, c0\_.trigger\_mode AS trigger\_mode\_10, c0\_.decision\_path AS decision\_path\_11, c0\_.temp\_id AS temp\_id\_12, c0\_.channel AS channel\_13, c0\_.channel\_id AS channel\_id\_14, c1\_.is\_published AS is\_published\_15, c1\_.date\_added AS date\_added\_16, c1\_.created\_by AS created\_by\_17, c1\_.created\_by\_user AS created\_by\_user\_18, c1\_.date\_modified AS date\_modified\_19, c1\_.modified\_by AS modified\_by\_20, c1\_.modified\_by\_user AS modified\_by\_user\_21, c1\_.checked\_out AS checked\_out\_22, c1\_.checked\_out\_by AS checked\_out\_by\_23, c1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_24, c1\_.id AS id\_25, c1\_.name AS name\_26, c1\_.description AS description\_27, c1\_.publish\_up AS publish\_up\_28, c1\_.publish\_down AS publish\_down\_29, c1\_.canvas\_settings AS canvas\_settings\_30, c2\_.id AS id\_31, c2\_.name AS name\_32, c2\_.description AS description\_33, c2\_.type AS type\_34, c2\_.event\_type AS event\_type\_35, c2\_.event\_order AS event\_order\_36, c2\_.properties AS properties\_37, c2\_.trigger\_date AS trigger\_date\_38, c2\_.trigger\_interval AS trigger\_interval\_39, c2\_.trigger\_interval\_unit AS trigger\_interval\_unit\_40, c2\_.trigger\_mode AS trigger\_mode\_41, c2\_.decision\_path AS decision\_path\_42, c2\_.temp\_id AS temp\_id\_43, c2\_.channel AS channel\_44, c2\_.channel\_id AS channel\_id\_45, c3\_.id AS id\_46, c3\_.name AS name\_47, c3\_.description AS description\_48, c3\_.type AS type\_49, c3\_.event\_type AS event\_type\_50, c3\_.event\_order AS event\_order\_51, c3\_.properties AS properties\_52, c3\_.trigger\_date AS trigger\_date\_53, c3\_.trigger\_interval AS trigger\_interval\_54, c3\_.trigger\_interval\_unit AS trigger\_interval\_unit\_55, c3\_.trigger\_mode AS trigger\_mode\_56, c3\_.decision\_path AS decision\_path\_57, c3\_.temp\_id AS temp\_id\_58, c3\_.channel AS channel\_59, c3\_.channel\_id AS channel\_id\_60, c4\_.is\_published AS is\_published\_61, c4\_.date\_added AS date\_added\_62, c4\_.created\_by AS created\_by\_63, c4\_.created\_by\_user AS created\_by\_user\_64, c4\_.date\_modified AS date\_modified\_65, c4\_.modified\_by AS modified\_by\_66, c4\_.modified\_by\_user AS modified\_by\_user\_67, c4\_.checked\_out AS checked\_out\_68, c4\_.checked\_out\_by AS checked\_out\_by\_69, c4\_.checked\_out\_by\_user AS checked\_out\_by\_user\_70, c4\_.id AS id\_71, c4\_.name AS name\_72, c4\_.description AS description\_73, c4\_.publish\_up AS publish\_up\_74, c4\_.publish\_down AS publish\_down\_75, c4\_.canvas\_settings AS canvas\_settings\_76 FROM campaign\_events c0\_ INNER JOIN campaigns c1\_ ON c0\_.campaign\_id = c1\_.id LEFT JOIN campaign\_events c2\_ ON c0\_.id = c2\_.parent\_id LEFT JOIN campaign\_events c3\_ ON c0\_.parent\_id = c3\_.id LEFT JOIN campaigns c4\_ ON c2\_.campaign\_id = c4\_.id WHERE c1\_.is\_published = ? AND (c1\_.publish\_down IS NULL OR c1\_.publish\_down \>= ?) AND (c1\_.publish\_up IS NULL OR c1\_.publish\_up \<= ?) AND c0\_.type = ? AND c1\_.id IN (?) AND (c0\_.id NOT IN (SELECT c5\_.id FROM campaign\_lead\_event\_log c6\_ LEFT JOIN campaign\_events c5\_ ON c6\_.event\_id = c5\_.id LEFT JOIN leads l7\_ ON c6\_.lead\_id = l7\_.id WHERE c5\_.id = c0\_.id AND l7\_.id = ?)) AND (c0\_.decision\_path \<\> ‘no’ OR c0\_.decision\_path IS NULL) ORDER BY c0\_.event\_order ASC, c2\_.event\_order ASC’ with params [1, “2017-11-13 13:24:49”, “2017-11-13 13:24:49”, “form.submit”, 1, 7]: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query” at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT c0\_.id AS id\_0, c0\_.name AS name\_1, c0\_.description AS description\_2, c0\_.type AS type\_3, c0\_.event\_type AS event\_type\_4, c0\_.event\_order AS event\_order\_5, c0\_.properties AS properties\_6, c0\_.trigger\_date AS trigger\_date\_7, c0\_.trigger\_interval AS trigger\_interval\_8, c0\_.trigger\_interval\_unit AS trigger\_interval\_unit\_9, c0\_.trigger\_mode AS trigger\_mode\_10, c0\_.decision\_path AS decision\_path\_11, c0\_.temp\_id AS temp\_id\_12, c0\_.channel AS channel\_13, c0\_.channel\_id AS channel\_id\_14, c1\_.is\_published AS is\_published\_15, c1\_.date\_added AS date\_added\_16, c1\_.created\_by AS created\_by\_17, c1\_.created\_by\_user AS created\_by\_user\_18, c1\_.date\_modified AS date\_modified\_19, c1\_.modified\_by AS modified\_by\_20, c1\_.modified\_by\_user AS modified\_by\_user\_21, c1\_.checked\_out AS checked\_out\_22, c1\_.checked\_out\_by AS checked\_out\_by\_23, c1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_24, c1\_.id AS id\_25, c1\_.name AS name\_26, c1\_.description AS description\_27, c1\_.publish\_up AS publish\_up\_28, c1\_.publish\_down AS publish\_down\_29, c1\_.canvas\_settings AS canvas\_settings\_30, c2\_.id AS id\_31, c2\_.name AS name\_32, c2\_.description AS description\_33, c2\_.type AS type\_34, c2\_.event\_type AS event\_type\_35, c2\_.event\_order AS event\_order\_36, c2\_.properties AS properties\_37, c2\_.trigger\_date AS trigger\_date\_38, c2\_.trigger\_interval AS trigger\_interval\_39, c2\_.trigger\_interval\_unit AS trigger\_interval\_unit\_40, c2\_.trigger\_mode AS trigger\_mode\_41, c2\_.decision\_path AS decision\_path\_42, c2\_.temp\_id AS temp\_id\_43, c2\_.channel AS channel\_44, c2\_.channel\_id AS channel\_id\_45, c3\_.id AS id\_46, c3\_.name AS name\_47, c3\_.description AS description\_48, c3\_.type AS type\_49, c3\_.event\_type AS event\_type\_50, c3\_.event\_order AS event\_order\_51, c3\_.properties AS properties\_52, c3\_.trigger\_date AS trigger\_date\_53, c3\_.trigger\_interval AS trigger\_interval\_54, c3\_.trigger\_interval\_unit AS trigger\_interval\_unit\_55, c3\_.trigger\_mode AS trigger\_mode\_56, c3\_.decision\_path AS decision\_path\_57, c3\_.temp\_id AS temp\_id\_58, c3\_.channel AS channel\_59, c3\_.channel\_id AS channel\_id\_60, c4\_.is\_published AS is\_published\_61, c4\_.date\_added AS date\_added\_62, c4\_.created\_by AS created\_by\_63, c4\_.created\_by\_user AS created\_by\_user\_64, c4\_.date\_modified AS date\_modified\_65, c4\_.modified\_by AS modified\_by\_66, c4\_.modified\_by\_user AS modified\_by\_user\_67, c4\_.checked\_out AS checked\_out\_68, c4\_.checked\_out\_by AS checked\_out\_by\_69, c4\_.checked\_out\_by\_user AS checked\_out\_by\_user\_70, c4\_.id AS id\_71, c4\_.name AS name\_72, c4\_.description AS description\_73, c4\_.publish\_up AS publish\_up\_74, c4\_.publish\_down AS publish\_down\_75, c4\_.canvas\_settings AS canvas\_settings\_76 FROM campaign\_events c0\_ INNER JOIN campaigns c1\_ ON c0\_.campaign\_id = c1\_.id LEFT JOIN campaign\_events c2\_ ON c0\_.id = c2\_.parent\_id LEFT JOIN campaign\_events c3\_ ON c0\_.parent\_id = c3\_.id LEFT JOIN campaigns c4\_ ON c2\_.campaign\_id = c4\_.id WHERE c1\_.is\_published = ? AND (c1\_.publish\_down IS NULL OR c1\_.publish\_down \>= ?) AND (c1\_.publish\_up IS NULL OR c1\_.publish\_up \<= ?) AND c0\_.type = ? AND c1\_.id IN (?) AND (c0\_.id NOT IN (SELECT c5\_.id FROM campaign\_lead\_event\_log c6\_ LEFT JOIN campaign\_events c5\_ ON c6\_.event\_id = c5\_.id LEFT JOIN leads l7\_ ON c6\_.lead\_id = l7\_.id WHERE c5\_.id = c0\_.id AND l7\_.id = ?)) AND (c0\_.decision\_path \<\> ‘no’ OR c0\_.decision\_path IS NULL) ORDER BY c0\_.event\_order ASC, c2\_.event\_order ASC’ with params [1, “2017-11-13 13:24:49”, “2017-11-13 13:24:49”, “form.submit”, 1, 7]:nnSQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []  
  
  
  
However, when I use version 5.5.52-1 of MariaDB, everything works normally.  
  
  
  
I think the problem is a bug in MariaDB, but version 5.5.56 is a normal CentOS update.  
  
  
  
Has anyone had this problem? The solution is to use and maintain an old version of MariaDB in CentOS?  
  
  
  
Thank you

---

<div class="post-metadata">

**Author:** ![sandrovenezuela](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/sandrovenezuela/32/9241_2.png) [@sandrovenezuela](https://forum.mautic.org/u/sandrovenezuela)\
**Post date:** [November 13, 2017, 2:15pm UTC](https://forum.mautic.org/t/strange-issue-between-mautic-and-mariadb/9888/2 "2017-11-13T14:15:30Z")

</div>

Hi all,

This is my first question here at the Mautic forum.

I have a strange problem between Mautic and MariaDB. I have Mautic (version 2.11.0) installed on a server with the CentOS 7 system and with MariaDB (version 5.5.56-2).

When a campaign receives data from a form, the error occurs:

mautic.CRITICAL: Uncaught PHP Exception DoctrineDBALExceptionDriverException: “An exception occurred while executing ‘SELECT c0\_.id AS id\_0, c0\_.name AS name\_1, c0\_.description AS description\_2, c0\_.type AS type\_3, c0\_.event\_type AS event\_type\_4, c0\_.event\_order AS event\_order\_5, c0\_.properties AS properties\_6, c0\_.trigger\_date AS trigger\_date\_7, c0\_.trigger\_interval AS trigger\_interval\_8, c0\_.trigger\_interval\_unit AS trigger\_interval\_unit\_9, c0\_.trigger\_mode AS trigger\_mode\_10, c0\_.decision\_path AS decision\_path\_11, c0\_.temp\_id AS temp\_id\_12, c0\_.channel AS channel\_13, c0\_.channel\_id AS channel\_id\_14, c1\_.is\_published AS is\_published\_15, c1\_.date\_added AS date\_added\_16, c1\_.created\_by AS created\_by\_17, c1\_.created\_by\_user AS created\_by\_user\_18, c1\_.date\_modified AS date\_modified\_19, c1\_.modified\_by AS modified\_by\_20, c1\_.modified\_by\_user AS modified\_by\_user\_21, c1\_.checked\_out AS checked\_out\_22, c1\_.checked\_out\_by AS checked\_out\_by\_23, c1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_24, c1\_.id AS id\_25, c1\_.name AS name\_26, c1\_.description AS description\_27, c1\_.publish\_up AS publish\_up\_28, c1\_.publish\_down AS publish\_down\_29, c1\_.canvas\_settings AS canvas\_settings\_30, c2\_.id AS id\_31, c2\_.name AS name\_32, c2\_.description AS description\_33, c2\_.type AS type\_34, c2\_.event\_type AS event\_type\_35, c2\_.event\_order AS event\_order\_36, c2\_.properties AS properties\_37, c2\_.trigger\_date AS trigger\_date\_38, c2\_.trigger\_interval AS trigger\_interval\_39, c2\_.trigger\_interval\_unit AS trigger\_interval\_unit\_40, c2\_.trigger\_mode AS trigger\_mode\_41, c2\_.decision\_path AS decision\_path\_42, c2\_.temp\_id AS temp\_id\_43, c2\_.channel AS channel\_44, c2\_.channel\_id AS channel\_id\_45, c3\_.id AS id\_46, c3\_.name AS name\_47, c3\_.description AS description\_48, c3\_.type AS type\_49, c3\_.event\_type AS event\_type\_50, c3\_.event\_order AS event\_order\_51, c3\_.properties AS properties\_52, c3\_.trigger\_date AS trigger\_date\_53, c3\_.trigger\_interval AS trigger\_interval\_54, c3\_.trigger\_interval\_unit AS trigger\_interval\_unit\_55, c3\_.trigger\_mode AS trigger\_mode\_56, c3\_.decision\_path AS decision\_path\_57, c3\_.temp\_id AS temp\_id\_58, c3\_.channel AS channel\_59, c3\_.channel\_id AS channel\_id\_60, c4\_.is\_published AS is\_published\_61, c4\_.date\_added AS date\_added\_62, c4\_.created\_by AS created\_by\_63, c4\_.created\_by\_user AS created\_by\_user\_64, c4\_.date\_modified AS date\_modified\_65, c4\_.modified\_by AS modified\_by\_66, c4\_.modified\_by\_user AS modified\_by\_user\_67, c4\_.checked\_out AS checked\_out\_68, c4\_.checked\_out\_by AS checked\_out\_by\_69, c4\_.checked\_out\_by\_user AS checked\_out\_by\_user\_70, c4\_.id AS id\_71, c4\_.name AS name\_72, c4\_.description AS description\_73, c4\_.publish\_up AS publish\_up\_74, c4\_.publish\_down AS publish\_down\_75, c4\_.canvas\_settings AS canvas\_settings\_76 FROM campaign\_events c0\_ INNER JOIN campaigns c1\_ ON c0\_.campaign\_id = c1\_.id LEFT JOIN campaign\_events c2\_ ON c0\_.id = c2\_.parent\_id LEFT JOIN campaign\_events c3\_ ON c0\_.parent\_id = c3\_.id LEFT JOIN campaigns c4\_ ON c2\_.campaign\_id = c4\_.id WHERE c1\_.is\_published = ? AND (c1\_.publish\_down IS NULL OR c1\_.publish\_down \>= ?) AND (c1\_.publish\_up IS NULL OR c1\_.publish\_up \<= ?) AND c0\_.type = ? AND c1\_.id IN (?) AND (c0\_.id NOT IN (SELECT c5\_.id FROM campaign\_lead\_event\_log c6\_ LEFT JOIN campaign\_events c5\_ ON c6\_.event\_id = c5\_.id LEFT JOIN leads l7\_ ON c6\_.lead\_id = l7\_.id WHERE c5\_.id = c0\_.id AND l7\_.id = ?)) AND (c0\_.decision\_path \<\> ‘no’ OR c0\_.decision\_path IS NULL) ORDER BY c0\_.event\_order ASC, c2\_.event\_order ASC’ with params [1, “2017-11-13 13:24:49”, “2017-11-13 13:24:49”, “form.submit”, 1, 7]: SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query” at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php line 115 {“exception”:"[object] (Doctrine\DBAL\Exception\DriverException(code: 0): An exception occurred while executing ‘SELECT c0\_.id AS id\_0, c0\_.name AS name\_1, c0\_.description AS description\_2, c0\_.type AS type\_3, c0\_.event\_type AS event\_type\_4, c0\_.event\_order AS event\_order\_5, c0\_.properties AS properties\_6, c0\_.trigger\_date AS trigger\_date\_7, c0\_.trigger\_interval AS trigger\_interval\_8, c0\_.trigger\_interval\_unit AS trigger\_interval\_unit\_9, c0\_.trigger\_mode AS trigger\_mode\_10, c0\_.decision\_path AS decision\_path\_11, c0\_.temp\_id AS temp\_id\_12, c0\_.channel AS channel\_13, c0\_.channel\_id AS channel\_id\_14, c1\_.is\_published AS is\_published\_15, c1\_.date\_added AS date\_added\_16, c1\_.created\_by AS created\_by\_17, c1\_.created\_by\_user AS created\_by\_user\_18, c1\_.date\_modified AS date\_modified\_19, c1\_.modified\_by AS modified\_by\_20, c1\_.modified\_by\_user AS modified\_by\_user\_21, c1\_.checked\_out AS checked\_out\_22, c1\_.checked\_out\_by AS checked\_out\_by\_23, c1\_.checked\_out\_by\_user AS checked\_out\_by\_user\_24, c1\_.id AS id\_25, c1\_.name AS name\_26, c1\_.description AS description\_27, c1\_.publish\_up AS publish\_up\_28, c1\_.publish\_down AS publish\_down\_29, c1\_.canvas\_settings AS canvas\_settings\_30, c2\_.id AS id\_31, c2\_.name AS name\_32, c2\_.description AS description\_33, c2\_.type AS type\_34, c2\_.event\_type AS event\_type\_35, c2\_.event\_order AS event\_order\_36, c2\_.properties AS properties\_37, c2\_.trigger\_date AS trigger\_date\_38, c2\_.trigger\_interval AS trigger\_interval\_39, c2\_.trigger\_interval\_unit AS trigger\_interval\_unit\_40, c2\_.trigger\_mode AS trigger\_mode\_41, c2\_.decision\_path AS decision\_path\_42, c2\_.temp\_id AS temp\_id\_43, c2\_.channel AS channel\_44, c2\_.channel\_id AS channel\_id\_45, c3\_.id AS id\_46, c3\_.name AS name\_47, c3\_.description AS description\_48, c3\_.type AS type\_49, c3\_.event\_type AS event\_type\_50, c3\_.event\_order AS event\_order\_51, c3\_.properties AS properties\_52, c3\_.trigger\_date AS trigger\_date\_53, c3\_.trigger\_interval AS trigger\_interval\_54, c3\_.trigger\_interval\_unit AS trigger\_interval\_unit\_55, c3\_.trigger\_mode AS trigger\_mode\_56, c3\_.decision\_path AS decision\_path\_57, c3\_.temp\_id AS temp\_id\_58, c3\_.channel AS channel\_59, c3\_.channel\_id AS channel\_id\_60, c4\_.is\_published AS is\_published\_61, c4\_.date\_added AS date\_added\_62, c4\_.created\_by AS created\_by\_63, c4\_.created\_by\_user AS created\_by\_user\_64, c4\_.date\_modified AS date\_modified\_65, c4\_.modified\_by AS modified\_by\_66, c4\_.modified\_by\_user AS modified\_by\_user\_67, c4\_.checked\_out AS checked\_out\_68, c4\_.checked\_out\_by AS checked\_out\_by\_69, c4\_.checked\_out\_by\_user AS checked\_out\_by\_user\_70, c4\_.id AS id\_71, c4\_.name AS name\_72, c4\_.description AS description\_73, c4\_.publish\_up AS publish\_up\_74, c4\_.publish\_down AS publish\_down\_75, c4\_.canvas\_settings AS canvas\_settings\_76 FROM campaign\_events c0\_ INNER JOIN campaigns c1\_ ON c0\_.campaign\_id = c1\_.id LEFT JOIN campaign\_events c2\_ ON c0\_.id = c2\_.parent\_id LEFT JOIN campaign\_events c3\_ ON c0\_.parent\_id = c3\_.id LEFT JOIN campaigns c4\_ ON c2\_.campaign\_id = c4\_.id WHERE c1\_.is\_published = ? AND (c1\_.publish\_down IS NULL OR c1\_.publish\_down \>= ?) AND (c1\_.publish\_up IS NULL OR c1\_.publish\_up \<= ?) AND c0\_.type = ? AND c1\_.id IN (?) AND (c0\_.id NOT IN (SELECT c5\_.id FROM campaign\_lead\_event\_log c6\_ LEFT JOIN campaign\_events c5\_ ON c6\_.event\_id = c5\_.id LEFT JOIN leads l7\_ ON c6\_.lead\_id = l7\_.id WHERE c5\_.id = c0\_.id AND l7\_.id = ?)) AND (c0\_.decision\_path \<\> ‘no’ OR c0\_.decision\_path IS NULL) ORDER BY c0\_.event\_order ASC, c2\_.event\_order ASC’ with params [1, “2017-11-13 13:24:49”, “2017-11-13 13:24:49”, “form.submit”, 1, 7]:nnSQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:93, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/html/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:91)"} []

However, when I use version 5.5.52-1 of MariaDB, everything works normally.

I think the problem is a bug in MariaDB, but version 5.5.56 is a normal CentOS update.

Has anyone had this problem? The solution is to use and maintain an old version of MariaDB in CentOS?

Thank you

---

<div class="post-metadata">

**Author:** ![jeffrey.mcateer](https://avatars.discourse-cdn.com/v4/letter/j/f05b48/32.png) [@jeffrey.mcateer](https://forum.mautic.org/u/jeffrey.mcateer)\
**Post date:** [December 1, 2017, 3:21pm UTC](https://forum.mautic.org/t/strange-issue-between-mautic-and-mariadb/9888/3 "2017-12-01T15:21:24Z")

</div>

Can confirm, I see this on a CentOS 7 box:

```auto
General error: 2013 Lost connection to MySQL server during query at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/AbstractMySQLDriver.php:115, Doctrine\DBAL\Driver\PDOException(code: HY000): SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:107, PDOException(code: HY000): SQLSTATE[HY000]: General error: 2013 Lost connection to MySQL server during query at /var/www/mautic/vendor/doctrine/dbal/lib/Doctrine/DBAL/Driver/PDOStatement.php:105)"
```

I went the other way and installed the latest version: 10.1.29-MariaDB. Instructions: [https://www.webhostingneeds.com/Install\_latest\_version\_of\_MariaDB\_on\_CentOS\_7](https://www.webhostingneeds.com/Install_latest_version_of_MariaDB_on_CentOS_7)

---

<div class="post-metadata">

**Author:** ![sandrovenezuela](https://sea2.discourse-cdn.com/flex020/user_avatar/forum.mautic.org/sandrovenezuela/32/9241_2.png) [@sandrovenezuela](https://forum.mautic.org/u/sandrovenezuela)\
**Post date:** [December 4, 2017, 7:24pm UTC](https://forum.mautic.org/t/strange-issue-between-mautic-and-mariadb/9888/4 "2017-12-04T19:24:01Z")

</div>

Hi Jeffrey, I used the same solution as you and I think it’s the only possible solution to always have everything updated.

Thanks.
