you have 3 options to understand this issue:
1 - open another session and check top
, see if process is actually running:
31570 test+ 20 0 753532 127000 51552 S 1.7 3.3 0:27.43 php bin/magento migrate:data -a /home/testmigration/public_html/vendor/magento/data-migration-tool/etc/opensource-to+
2 - starce
process 31570
:
strace -p 31570 -s 99999
you will see whats going on inside, something like this:
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\1V\0\0\2\3def\2mg$catalog_product_entity_media_gallery\tentity_id\tentity_id\f?\0\n\0\0\0\3)@\0\0\0\5\0\0\3\376\0\0\2\0\5\0\0\4\0041189\5\0\0\5\376\0\0\2\0", 17222, MSG_DONTWAIT, NULL, NULL) = 122
sendto(11, "i\0\0\0\3SELECT `mg`.`entity_id` FROM `catalog_product_entity_media_gallery` AS `mg` WHERE (mg.value_id = '8221')", 109, MSG_DONTWAIT, NULL, 0) = 109
poll([{fd=11, events=POLLIN|POLLERR|POLLHUP}], 1, 1471228928) = 1 ([{fd=11, revents=POLLIN}])
recvfrom(11, "\1\0\0\1\1V\0\0\2\3def\2mg$catalog_product_entity_media_gallery\tentity_id\tentity_id\f?\0\n\0\0\0\3)@\0\0\0\5\0\0\3\376\0\0\2\0\5\0\0\4\0041189\5\0\0\5\376\0\0\2\0", 17100, MSG_DONTWAIT, NULL, NULL) = 122
3 - install mytop
and see database transactions.
MySQL on localhost (5.7.21-20) load 0.37 0.14 0.13 4/401 31777 up 2+16:11:30 [10:39:50]
Queries: 43.2k qps: 0 Slow: 0.0 Se/In/Up/De(%): 11/26/01/00
Sorts: 0 qps now: 1 Slow qps: 0.0 Threads: 2 ( 2/ 4) 00/14/00/00
Key Efficiency: 92.6% Bps in/out: 90.8/ 58.2 Now in/out: 546.1k/535.6k
Id User Host/IP DB Time Cmd State Query
-- ---- ------- -- ---- --- ----- ----------
262 m2u_ localhost m2d_ 1 Query update INSERT INTO report_event (`event_id`,`logged_at`,`event_type_id`,`object_id`,`subject_id`,`subtype`,`store_i
264 root localhost mysql 0 Query starting show full processlist
obviously some migrations can take long time, depends on data amount, connection speed and server specs
p.s. truncate logs, events, reports and other non-important or
temporary data that you dont need in magento 2.