Hi,
Something strange happens when I run caUtils create-ngrams:
- There is a PHP warning at beginning of execution.
- The percentage increase exceeds 100.0%!
- The script terminates with a fatal error.
The script is launched with sudo command.
PHP 7.4.33 (cli) (built: Apr 12 2024 00:02:16) ( NTS )
Here is an extract of execution: (I removed all lines between 15.0% and 97.0%)
CollectiveAccess 1.7.17 (158/RELEASE) Utilities
(c) 2013-2019 Whirl-i-Gig
PHP Warning: Invalid argument supplied for foreach() in /var/www/collections/ca/app/lib/Utils/CLIUtils.php on line 2736
1ffabb072e5b0fda52f9263b3ff70455 en cours de traitement 10.0% 2765/28346 ETC: 5 mins, 33 secs. Elapsed: 36 secs [==> ]
1 en cours de traitement 10.0% 2766/28346 ETC: 5 mins, 32 secs. Elapsed: 36 secs [==> ]
1373 en cours de traitement 14.0% 3967/28346 ETC: 3 mins, 53 secs. Elapsed: 38 secs [====> ]
63
1373 en cours de traitement 14.0% 3968/28346 ETC: 3 mins, 53 secs. Elapsed: 38 secs [====> ]
63
1442 en cours de traitement 15.0% 4173/28346 ETC: 3 mins, 40 secs. Elapsed: 38 secs [====> ]
14429 en cours de traitement 15.0% 4174/28346 ETC: 3 mins, 40 secs.
...
...
...
étudiants et professeur en licence de droit à la villa (1961) (2) en cours de trai...97.0% 27581/28346 ETC: 1 secs. Elapsed: 1 mins, 10 secs [=============================> ]
étudiants et professeur en licence de droit à la villa (1963) (1) en cours de trai...97.0% 27582/28346 ETC: 1 secs. Elapsed: 1 mins, 10 secs [=============================> ]
fr/2015/05/22/la-villa-est-a-vendre en cours de traitement 103.0% 29161/28346 ETC: - 2 secs. Elapsed: 1 mins, 12 secs [==============================!]
fr/2016/02/11/un-auditorium-en-projet-2270984-4018 en cour... 103.0% 29162/28346 ETC: - 2 secs. Elapsed: 1 mins, 12 secs [==============================!]
fr/collections/les-collections-de/ en cours de traitement 103.0% 29197/28346 ETC: - 2 secs. Elapsed: 1 mins, 12 secs [==============================!]
f en cours de traitement 103.0% 29198/28346 ETC: - 2 secs. Elapsed: 1 mins, 12 secs [==============================!]PHP Fatal error: Uncaught DatabaseException: Out of range value for column 'seq' at row 84 in /var/www/collections/ca/app/lib/Db/mysqli.php:316
Stack trace:
#0 /var/www/collections/ca/app/lib/Db/DbStatement.php(151): Db_mysqli->execute()
#1 /var/www/collections/ca/app/lib/Db.php(261): DbStatement->executeWithParamsAsArray()
#2 /var/www/collections/ca/app/lib/Utils/CLIUtils.php(2785): Db->query()
#3 /var/www/collections/ca/support/bin/caUtils(167): CLIUtils::create_ngrams()
#4 {main}
thrown in /var/www/collections/ca/app/lib/Db/mysqli.php on line 316
Any idea?
