Mass Important Problem

[arslancb]

Hi,

I mass imported around 27000 contacts. Due to a misconfiguration on the server, it got timed out at first as I forgot to check big data import option.

So I re-imported with correct option.

Now it's been a whole day, import is still on, there are 5 duplicates of each record and it keeps increasing. I don't know how to stop this process and remove duplicates, please please help.

Total records are so far 54647 and by the time I post this message it will be increased to 54680


P.S Import status is still 'Processing'

[tanya]

Hello
After import status comes complete, revert import result (don't remember if this button is available, if status is in process)
Do you import in idle mode?

[arslancb]

Yes, I imported this in Idle mode. I am waiting for it to finish.

[tanya]

Could you check how many and what the status (interested in Pending and Running) is for jobs with 'service_name' => 'Import', 'method' => 'runIdleImport'?

[arslancb]

And where do I check them?

[arslancb]

If that's what you are asking for? I am not sure...from job table

+-------------------+------+---------+--------+---------------------+--------------+---------------+----------+-----------------+---------------------+---------------------+
| id | name | deleted | status | execute_time | service_name | method | attempts | failed_attempts | created_at | modified_at |
+-------------------+------+---------+--------+---------------------+--------------+---------------+----------+-----------------+---------------------+---------------------+
| 5a30d19c0cff8a0b3 | NULL | 0 | Failed | 2017-12-13 07:07:08 | Import | runIdleImport | 0 | 3 | 2017-12-13 07:07:08 | 2017-12-13 09:20:03 |
+-------------------+------+---------+--------+---------------------+--------------+---------------+----------+-----------------+---------------------+---------------------+

[arslancb]

I restarted all services, including Mysql now it has stopped. Finally. reverting.