Import a lot of users to Zammad issue

[andylug]

Infos:

• Used Zammad version: 3.3.x
• Used Zammad installation source: (source, package, …) Ubuntu package
• Operating system: Ubuntu 18.04.4
• Browser + version:

Expected behavior:

• I’m trying to import about 10000 users to Zammad via script and csv file:

result = User.csv_import(
file: ‘/home/user/Users.5.csv’,
parse_params: {
col_sep: ‘,’,
},
try: false,
)

and csv like:

login,firstname,lastname,email,phone,active,roles
xxx-00247324,true,Customer

Actual behavior:

• The script runs for about 15 minutes. I see 10000 messages in /var/log/zammad/production.log like:

I, [2020-03-12T13:50:37.906041 #32252-47459346023920] INFO – : Enqueued SearchIndexAssociationsJob (Job ID: 0eceb992-433d-40bf-878a-09e5616ee3c0) to DelayedJob(default) with arguments: “User”, 443640

Nothing happens after that. No user added and job list 0:

irb(main):096:0> Delayed::Job.count
=> 0

When I try to add 10 users, then everything is fine.

Steps to reproduce the behavior:

Thanks,
Andy

[MrGeneration]

Maybe the output of the script you run itself might be usefull?
Feels like information are missing.

Beside of searchindexing you can check if the users are there via User.find_by(login: 'xxx-00247324') (as example). You could check 2-3 random entries all over your list.

If you find your users via rails, you have an issue with your searchindex. (I doubt that, because then your delayed-job count should be higher)

[andylug]

As I wrote, problem appearing then I trying to do mass import of users (for example 50000). Then I importing about 5000, everything is fine.
Do you have any restriction to perfome mass users import?

Thank you.

[MrGeneration]

@andylug

Do you have any restriction to perfome mass users import?

As far as I’m aware, we do not limit those kind of actions.