← Back to team overview

maria-discuss team mailing list archive

Re: MariaDB-10.2.11 Long Time To Start

 

On Thu, 14 Mar 2019 00:08:08 -0300
Michael Caplan <michael@xxxxxxxxxxx> wrote:

> Not user what is currently going on.  Restarting our slave.  Last
> start process was around an hour.  This time around I'm at close to 2
> hours and still waiting.  According to gbd, looks it is stuck in 
> storage/innobase/fts/fts0fts.cc:6870
> fts_check_and_drop_orphaned_tables. Not sure if I hit some infinite
> loop....
> 
> Oh boy!

Can you show:

thread apply all bt full

After a little longer do the same capture. Maybe some of the local
variables will be enough so show if there's progress or just odd values
that could cause infinite loops.



https://mariadb.com/kb/en/library/how-to-produce-a-full-stack-trace-for-mysqld/



References