Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
N/A
-
None
Description
During text files import using load data infile, I have observed thread state reading file:
Id: 7894
|
User: dba
|
Host: localhost
|
db: NULL
|
Command: Query
|
Time: 0
|
State: reading file
|
Info: load data local infile '/tmp/my-fifo' into table tmp_table
|
Progress: 0.000
|
This general thread state is not documented:
https://mariadb.com/kb/en/mariadb/general-thread-states/
Similar state is observed when looking into innodb monitor
---TRANSACTION 626967607, ACTIVE 7 sec inserting
|
mysql tables in use 1, locked 1
|
2 lock struct(s), heap size 360, 0 row lock(s), undo log entries 45306
|
MySQL thread id 8045, OS thread handle 0x7fd89b567700, query id 6271789 localhost dba reading file
|
load data local infile '/tmp/my-fifo' into table tmp_table
|
Trx #rec lock waits 0 #table lock waits 0
|