bulk-importer Errors

[user_0094e]

*️⃣ Must open one ticket per issue. If you are experiencing multiple issues don't hesitate to create multiple tickets for each issue.

▶ Reproduction steps

1. Run the following command (/usr/local/php81/bin/php /home/admin/domains/XXX.COM/public_html/app/bin/legacy -C bulk-importer) to "DirectAdmin Panel - Cron Jobs" import content to Chevereto.
2. Chevereto - Bulk importer - ./importing/parse-users - auto start.

😢 Unexpected result

After completing the import sequence of more than 30,000 pictures, many error logs appeared.

Dear Rodolfo, can you help me to see if these errors are serious? Need to deal with it or ignore it?

📃 Error log message

1670429162 - [Thread #0] PDOException SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '/home/admin/domains/XXX.COM/public_html/importing/pars...' for key 'importing_path' ~ #0 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/G/DB.php(151): PDOStatement->execute()
#1 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/G/DB.php(356): Chevereto\Legacy\G\DB->exec()
#2 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/Classes/DB.php(111): Chevereto\Legacy\G\DB::insert()
#3 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/Classes/Import.php(403): Chevereto\Legacy\Classes\DB::insert()
#4 /home/admin/domains/XXX.COM/public_html/app/legacy/commands/bulk-importer.php(41): Chevereto\Legacy\Classes\Import->process()
#5 /home/admin/domains/XXX.COM/public_html/app/legacy/entrypoints/cli.php(53): require_once('...')
#6 /home/admin/domains/XXX.COM/public_html/app/bin/legacy(13): require_once('...')
#7 {main}

1670432612 - [Thread #0] PDOException SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '/home/admin/domains/XXX.COM/public_html/importing/pars...' for key 'importing_path' ~ #0 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/G/DB.php(151): PDOStatement->execute()
#1 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/G/DB.php(356): Chevereto\Legacy\G\DB->exec()
#2 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/Classes/DB.php(111): Chevereto\Legacy\G\DB::insert()
#3 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/Classes/Import.php(403): Chevereto\Legacy\Classes\DB::insert()
#4 /home/admin/domains/XXX.COM/public_html/app/legacy/commands/bulk-importer.php(41): Chevereto\Legacy\Classes\Import->process()
#5 /home/admin/domains/XXX.COM/public_html/app/legacy/entrypoints/cli.php(53): require_once('...')
#6 /home/admin/domains/XXX.COM/public_html/app/bin/legacy(13): require_once('...')
#7 {main}

1670432735 - [Thread #0] PDOException SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '/home/admin/domains/XXX.COM/public_html/importing/pars...' for key 'importing_path' ~ #0 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/G/DB.php(151): PDOStatement->execute()
#1 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/G/DB.php(356): Chevereto\Legacy\G\DB->exec()
#2 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/Classes/DB.php(111): Chevereto\Legacy\G\DB::insert()
#3 /home/admin/domains/XXX.COM/public_html/app/src/Legacy/Classes/Import.php(403): Chevereto\Legacy\Classes\DB::insert()
#4 /home/admin/domains/XXX.COM/public_html/app/legacy/commands/bulk-importer.php(41): Chevereto\Legacy\Classes\Import->process()
#5 /home/admin/domains/XXX.COM/public_html/app/legacy/entrypoints/cli.php(53): require_once('...')
#6 /home/admin/domains/XXX.COM/public_html/app/bin/legacy(13): require_once('...')
#7 {main}

 

[Rodolfo]

You should ignore these, seems to be a race condition.