[MDEV-9376] General thread state 'reading file' is not documented Created: 2016-01-06  Updated: 2016-11-19  Resolved: 2016-11-19

Status: Closed
Project: MariaDB Server
Component/s: Documentation
Affects Version/s: N/A
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: aftab khan Assignee: Ian Gilfillan
Resolution: Fixed Votes: 1
Labels: 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



 Comments   
Comment by Ian Gilfillan [ 2016-11-19 ]

Added to the documentation.

Generated at Thu Feb 08 07:34:12 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.