[MDEV-12456] load data not show process bar in MariaDB 10.2.5? Created: 2017-04-06  Updated: 2017-07-02  Resolved: 2017-07-02

Status: Closed
Project: MariaDB Server
Component/s: Server
Affects Version/s: 10.2.5
Fix Version/s: 10.2.7

Type: Bug Priority: Major
Reporter: sysdljr Assignee: Sergei Golubchik
Resolution: Fixed Votes: 0
Labels: None
Environment:

CentOS 6.7 , MariaDB 10.2.5


 Description   

Hi,
In MariaDB 10.2.5, load data not show process bar , MariaDB 10.1.22 is normal.
please confirm. 

MariaDB [test]> select version();
 
+--------------------+
 
| version()          |
 
+--------------------+
 
| 10.2.5-MariaDB-log |
 
+--------------------+
 
 
 
MariaDB [test]> load data infile '/tmp/test.txt' into table test01;
 
Query OK, 7087224 rows affected (6 min 59.14 sec)
 
 
 
MariaDB [(none)]> select version();
 
+-----------------+
 
| version()       |
 
+-----------------+
 
| 10.1.22-MariaDB |
 
+-----------------+
 
 
 
MariaDB [test]> load data infile '/tmp/test.txt' into table test01;
 
Stage: 1 of 2 'reading file'   95.3% of stage done
 
...
 
Query OK, 7087224 rows affected (7 min 19.83 sec)



 Comments   
Comment by Sergei Golubchik [ 2017-06-24 ]

I cannot repeat it:

MariaDB [test]> load data infile 'foo.csv' into table t2;
 
Stage: 1 of 2 'reading file'   38.2% of stage done
 
...
 
Query OK, 10000000 rows affected (12.86 sec)         
Records: 10000000  Deleted: 0  Skipped: 0  Warnings: 0
 
 
 
MariaDB [test]> select version();
 
+----------------------+
 
| version()            |
 
+----------------------+
 
| 10.2.7-MariaDB-debug |
 
+----------------------+
 
1 row in set (0.00 sec)

Comment by Elena Stepanova [ 2017-06-24 ]

I can still reproduce it both on current local builds, but more importantly on release binary tarballs, 10.2.6 vs 10.1.24 (I suppose that's what we can use to get some certainty, as our local builds can differ). I use glibc_214 tarballs. Dynamic links seem identical between the versions.

10.2.6

 
Server version: 10.2.6-MariaDB MariaDB Server
 
 
 
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [test]> create table t1 (c varchar(8));
 
Query OK, 0 rows affected (0.41 sec)
 
 
 
MariaDB [test]> load data infile '/data/jira-eventum/mdev12456/foo.csv' into table t1;
 
Query OK, 10000000 rows affected (46.11 sec)
 
Records: 10000000  Deleted: 0  Skipped: 0  Warnings: 0

10.1.24

 
Server version: 10.1.24-MariaDB MariaDB Server
 
 
 
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
 
 
 
Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
 
 
 
MariaDB [test]> create table t1 (c varchar(8));
 
Query OK, 0 rows affected (0.25 sec)
 
 
 
MariaDB [test]> load data infile '/data/jira-eventum/mdev12456/foo.csv' into table t1;
 
Stage: 1 of 2 'reading file'  0.009% of stage done
 
...
 
Stage: 1 of 2 'reading file'   65.9% of stage done
 
...
 
Query OK, 10000000 rows affected (48.54 sec)         
Records: 10000000  Deleted: 0  Skipped: 0  Warnings: 0

Comment by Sergei Golubchik [ 2017-07-02 ]

Repeated on deb packages built from mariadb-10.2.6, could not repeat on deb packages from the latest 10.2.

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