Hi all,
There are several threads in the forum with import, stat & touch, most of them are older.
Just a similar experience on this case(7.11.11 yet to be upgraded to 7.11.12) on CentOS with php 7.3, memory_limit=512M and timeouts adjusted for long durations.
I have started import of 14K Accounts to a fresh installation.
-
I have experienced dropdown error for Account type for an account. At the end Import showed on screen for the record which has incorrect drop down value for account type. So I received Step 5: View Import Results screen with 1 error.
-
I have corrected error and tried to run Import again for only new records and expected to import only one account but no it took like first import and Step 5: View Import Results Screen shown. When I check accounts I see that it has imported all records against the setting and I had 29K accounts all with duplicates.
So no View Import Results and duplicates created.
- I have deleted all the accounts(and duplicates) and re-tried with the file which I have corrected account type for a record and it took 16mins to import all 14K accounts in a single run. Step 5 View Import Results shown as usual. I have checked the Accounts, all are OK, Security Groups and users are correctly assigned for accounts.
But the suitecrm.log has following error lines from the beginning of process, not the end:
Mon Feb 17 12:51:41 2020 [3864][1][ERROR] File upload://IMPORT_Account_1-0 cannot be touched
Mon Feb 17 12:51:41 2020 [3864][1][ERROR] File upload://import/dupes_1.csv cannot be touched
Mon Feb 17 12:51:41 2020 [3864][1][ERROR] File upload://import/dupesdisplay_1.csv cannot be touched
Mon Feb 17 12:51:41 2020 [3864][1][ERROR] File upload://import/errorrecords_1.csv cannot be touched
Mon Feb 17 12:51:41 2020 [3864][1][ERROR] File upload://import/errorrecordsonly_1.csv cannot be touched
Mon Feb 17 12:51:41 2020 [3864][1][ERROR] File upload://IMPORT_Account_1-1 cannot be touched
Mon Feb 17 12:51:41 2020 [3864][1][ERROR] File upload://IMPORT_Account_1-2 cannot be touched
…
…
Mon Feb 17 12:51:43 2020 [3864][1][ERROR] File upload://IMPORT_Account_1-86 cannot be touched
Mon Feb 17 12:51:43 2020 [3864][1][ERROR] File upload://IMPORT_Account_1-87 cannot be touched
Mon Feb 17 12:52:00 2020 [3862][1][FATAL] Caught error: stat(): stat failed for upload/import/status_1.csv
Mon Feb 17 12:52:00 2020 [3862][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Mon Feb 17 12:52:00 2020 [3862][1][ERROR] File upload://import/status_1.csv cannot be touched
So, if import file contains incorrect dropdown value, it tells about it but the option to import only the new ones, not the duplicates not affected and it imported all again and if this is the case, the duplicates created, Import summary is not shown. I cannot reproduce this with smaller import file.
- After that I have tried to import Contracts of these accounts. It was OK but the suitecrm .log has following additionaly:(similar stat and touch errors)
Mon Feb 17 13:12:59 2020 [17082][1][ERROR] File upload://IMPORT_AOS_Contracts_1-0 cannot be touched
Mon Feb 17 13:12:59 2020 [17082][1][ERROR] File upload://import/dupes_1.csv cannot be touched
Mon Feb 17 13:12:59 2020 [17082][1][ERROR] File upload://import/dupesdisplay_1.csv cannot be touched
Mon Feb 17 13:12:59 2020 [17082][1][ERROR] File upload://import/errorrecords_1.csv cannot be touched
Mon Feb 17 13:12:59 2020 [17082][1][ERROR] File upload://import/errorrecordsonly_1.csv cannot be touched
Mon Feb 17 13:12:59 2020 [17082][1][ERROR] File upload://IMPORT_AOS_Contracts_1-1 cannot be touched
Mon Feb 17 13:12:59 2020 [17082][1][ERROR] File upload://IMPORT_AOS_Contracts_1-2 cannot be touched
Mon Feb 17 13:13:09 2020 [3893][1][FATAL] Caught error: stat(): stat failed for upload/import/status_1.csv
Mon Feb 17 13:13:09 2020 [3893][1][FATAL] Caught error: touch(): UploadStream::stream_metadata is not implemented!
Mon Feb 17 13:13:09 2020 [3893][1][ERROR] File upload://import/status_1.csv cannot be touched
But the Contracts successfully created and related to the corresponding accounts, no issues.
So, any ideas about this stat and touch errors ?