# MySQL Workbench crashes on 8.0.29 when running full database search

**URL:** <https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754>\
**Category:** Percona Server for MySQL\
**Created:** [July 26, 2022, 7:55am UTC](https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754 "2022-07-26T07:55:31Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![mbashevoy](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@mbashevoy](https://forums.percona.com/u/mbashevoy)\
**Post date:** [July 26, 2022, 7:55am UTC](https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754/1 "2022-07-26T07:55:31Z")

</div>

Used to be able to search all tables in the database using MySQL Workbench on 5.7 version, but now it crashes with the following error in the logs:

17:10:58 [ERR][GRTDispatcher]: exception in grt execute\_task, continuing: Exception: 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 ‘rows LIKE ‘%test%’ , rows, ‘’) AS rows FROM WHERE create’ at line 1  
17:10:58 [ERR][GRTDispatcher]: worker: task ‘Search’ has failed with 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 ‘rows LIKE ‘%test%’ , rows, ‘’) AS rows FROM

 WHERE create’ at line 1

Anyone else having this issue?

---

<div class="post-metadata">

**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\
**Post date:** [July 26, 2022, 1:40pm UTC](https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754/2 "2022-07-26T13:40:20Z")

</div>

You said this used to work on MySQL 5.7, but now doesn’t. I’m guessing you upgraded to MySQL 8? Did you also upgrade to the latest Workbench? If you did, then you probably need to file a bug with MySQL regarding broken workbench software.

---

<div class="post-metadata">

**Author:** ![mbashevoy](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@mbashevoy](https://forums.percona.com/u/mbashevoy)\
**Post date:** [July 26, 2022, 1:46pm UTC](https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754/3 "2022-07-26T13:46:59Z")

</div>

Hi Matt, thank you for your reply. I did upgrade to MySQL 8, you are right. I tried the latest versions of the Workbench and several previous versions (same issue). Was hoping to find out that it wasn’t a bug in workbench that went unfixed in several versions.

Thanks again

---

<div class="post-metadata">

**Author:** ![mbashevoy](https://avatars.discourse-cdn.com/v4/letter/m/aeb1de/32.png) [@mbashevoy](https://forums.percona.com/u/mbashevoy)\
**Post date:** [July 26, 2022, 1:53pm UTC](https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754/4 "2022-07-26T13:53:57Z")

</div>

Submitted here: [MySQL Bugs: #107983: MySQL Workbench crashes on 8.0.29 when running full database search](https://bugs.mysql.com/bug.php?id=107983&thanks=4)

---

<div class="post-metadata">

**Author:** ![josephwillion](https://avatars.discourse-cdn.com/v4/letter/j/6de8d8/32.png) [@josephwillion](https://forums.percona.com/u/josephwillion)\
**Post date:** [September 15, 2022, 1:31pm UTC](https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754/5 "2022-09-15T13:31:14Z")

</div>

You said this used to work on MySQL 5.7, but now doesn’t. I’m guessing you upgraded to MySQL 8? Did you also upgrade to the latest Workbench? If you d[i](https://kanyewestclothing.com/)d, then you probably need to file a bug with MySQL regarding broken workbench software.

---

<div class="post-metadata">

**Author:** ![hafiz\_jee](https://avatars.discourse-cdn.com/v4/letter/h/2acd7d/32.png) [@hafiz\_jee](https://forums.percona.com/u/hafiz_jee)\
**Post date:** [September 29, 2022, 8:44am UTC](https://forums.percona.com/t/mysql-workbench-crashes-on-8-0-29-when-running-full-database-search/16754/6 "2022-09-29T08:44:43Z")

</div>

As you mentioned, this used to work on MySQL 5.7, but it no longer works on that version. [I](https://essentialshoodie.co/) am assuming that you have upgraded to MySQL 8 at this point? Did you also upgrade to the latest version of the Workbench at the same time? It is likely that you will need to file a bug with MySQL regarding the broken workbench software if you did that.
