Import a lot of users to Zammad issue

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

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)

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.

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