# Wait for GTID thread to start timed out

**URL:** <https://forums.percona.com/t/wait-for-gtid-thread-to-start-timed-out/18750>\
**Category:** MySQL & MariaDB\
**Tags:** mysql\
**Created:** [November 24, 2022, 1:24pm UTC](https://forums.percona.com/t/wait-for-gtid-thread-to-start-timed-out/18750 "2022-11-24T13:24:03Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\
**Post date:** [November 24, 2022, 1:24pm UTC](https://forums.percona.com/t/wait-for-gtid-thread-to-start-timed-out/18750/1 "2022-11-24T13:24:03Z")

</div>

Hi there ,  
Facing the below issue when starting the mysql ,It is taking much time to start the mysql ,1 hour and more …  
What could be the issue…?

**Note : DATA SIZE IS 6 TB**

```auto
2022-11-24T18:06:29.603786+05:30 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-24T18:06:52.463542+05:30 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2022-11-24T18:12:09.806834+05:30 0 [ERROR] [MY-011975] [InnoDB] Wait for GTID thread to start timed out

```

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [November 24, 2022, 2:38pm UTC](https://forums.percona.com/t/wait-for-gtid-thread-to-start-timed-out/18750/2 "2022-11-24T14:38:18Z")

</div>

Hi, there is a known [bug](https://bugs.mysql.com/bug.php?id=98889) related to this message. Which version f mysql are you running?

---

<div class="post-metadata">

**Author:** ![AneeshBabu](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/aneeshbabu/32/1393_2.png) [@AneeshBabu](https://forums.percona.com/u/AneeshBabu)\
**Post date:** [November 24, 2022, 4:14pm UTC](https://forums.percona.com/t/wait-for-gtid-thread-to-start-timed-out/18750/3 "2022-11-24T16:14:41Z")

</div>

Hi ,  
We are running `MySQL 8.0.20-11 Version`.  
`OS version - Ubuntu 18.04.5 LTS(Bionic Beaver)`  
Is there any workaround for this bug… or any solution ?

**below is the Error.log**

```auto

2022-11-24T12:22:40.016654+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 6218
2022-11-24T12:22:40.025602+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T12:37:17.736667+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 6843
2022-11-24T12:37:17.745663+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T12:50:15.776633+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 7269
2022-11-24T12:50:15.785691+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T12:50:25.264572+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 7351
2022-11-24T12:50:25.273539+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T12:53:53.776637+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 8027
2022-11-24T12:53:53.785722+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T12:55:37.516644+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 8363
2022-11-24T12:55:37.525589+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T12:58:22.516656+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 8608
2022-11-24T12:58:22.525576+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:02:27.016685+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 8929
2022-11-24T13:02:27.025600+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:08:04.776614+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 9311
2022-11-24T13:08:04.785558+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:12:43.516640+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 9601
2022-11-24T13:12:43.525708+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:15:40.436630+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 10039
2022-11-24T13:15:40.445605+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:23:34.384641+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 10919
2022-11-24T13:23:34.393617+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:27:32.864580+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 11202
2022-11-24T13:27:32.873421+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:33:40.696534+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 11737
2022-11-24T13:33:40.705217+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T13:42:59.364657+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 12192
2022-11-24T13:42:59.373536+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T14:03:01.516552+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 12888
2022-11-24T14:03:01.525375+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T14:23:03.776513+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 13474
2022-11-24T14:23:03.785303+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T14:43:06.016694+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 14019
2022-11-24T14:43:06.025747+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T15:42:16.853854+05:30 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-24T15:42:58.132820+05:30 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2022-11-24T15:48:15.577650+05:30 0 [ERROR] [MY-011975] [InnoDB] Wait for GTID thread to start timed out
2022-11-24T17:03:57.016668+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 24236
2022-11-24T17:03:57.025692+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T17:05:21.784608+05:30 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.20-11) starting as process 24529
2022-11-24T17:05:21.793566+05:30 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
2022-11-24T18:06:29.603786+05:30 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
2022-11-24T18:06:52.463542+05:30 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060
2022-11-24T18:12:09.806834+05:30 0 [ERROR] [MY-011975] [InnoDB] Wait for GTID thread to start timed out

```

---

<div class="post-metadata">

**Author:** ![Ivan\_Groenewold](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/ivan_groenewold/32/6299_2.png) [@Ivan\_Groenewold](https://forums.percona.com/u/Ivan_Groenewold)\
**Post date:** [November 24, 2022, 5:36pm UTC](https://forums.percona.com/t/wait-for-gtid-thread-to-start-timed-out/18750/4 "2022-11-24T17:36:46Z")

</div>

I suggest testing a newer release of 8.0 as the bug doesn’t seem to be solved.