Discussion related to cado-nfs

[Mehrshad Alipour <mehrati2019@outlook.com>]

I used a gui sqlite db manager to edit c155.db after removing last wu records which have right Null column, my problem solved.

I should also mention that cado-nfs can't handle corrupted relation data gzipped files because of unwanted shutdown usually occurs through power outage.

On 7/28/25 19:56, Mehrshad Alipour wrote:

In the name of GOD, the merciful, the compassionate

Peace be upon you

I gets error after resume, it passed unwanted shutdown because of power outage in my region

Info:root: No database exists yet
Info:Database: Database URI is db:sqlite3:///home/mehrati2019/Documents/Math/yafu3.0/40001_271/cadoWorkDir/c155.db
Info:Database: Opened connection to database /home/mehrati2019/Documents/Math/yafu3.0/40001_271/cadoWorkDir/c155.db
Info:root: tasks.threads = 8 [via tasks.threads]
Info:root: tasks.polyselect.threads = 2 [via tasks.polyselect.threads]
Info:root: tasks.sieve.las.threads = 2 [via tasks.sieve.las.threads]
Info:root: tasks.linalg.bwc.threads = 8 [via tasks.threads]
Info:root: tasks.sqrt.threads = 8 [via tasks.threads]
Info:root: Command line parameters: ./bin/cado-nfs.py /home/mehrati2019/Documents/Math/yafu3.0/40001_271/cadoWorkDir/c155.parameters_snapshot.1
Info:root: If this computation gets interrupted, it can be resumed with ./bin/cado-nfs.py /home/mehrati2019/Documents/Math/yafu3.0/40001_271/cadoWorkDir/c155.parameters_snapshot.2
Info:Server Launcher: Adding mehrati2019-System-Version to whitelist to allow clients on localhost to connect
Info:API server: server whitelist is ['127.0.0.1/32', '192.168.1.5/32', '192.168.1.6/32', '127.0.1.1/32']
Info:API server: Running from werkzeug (1 thread(s))
Info:Lattice Sieving: param rels_wanted is 164000000
Info:Complete Factorization / Discrete logarithm: Factoring 2006106171389221826114774082858599916926157243776747366009264614373218534487488979202408372706298862940266277514795599017758715484594070110092340964353721
Info:API server: Running on https://localhost:35653 (Press CTRL+C to quit))
Info:API server: You can start additional cado-nfs-client.py scripts with parameters: --server=https://localhost:35653 --certsha1=2d6a8771d5f24348a51f4c548e563eb92d5103ea
Info:API server: If you want to start additional clients, remember to add their hosts to server.whitelist
Info:Client Launcher: Starting client id localhost on host localhost
Info:Client Launcher: Starting client id localhost+2 on host localhost
Info:Client Launcher: Starting client id localhost+3 on host localhost
Info:Client Launcher: Starting client id localhost+4 on host localhost
Info:Client Launcher: Running clients: localhost (Host localhost, PID 5275), localhost+2 (Host localhost, PID 5284), localhost+3 (Host localhost, PID 5296), localhost+4 (Host localhost, PID 5308)
Info:Polynomial Selection (size optimized): Starting
Info:Polynomial Selection (size optimized): 72 polynomials in queue from previous run, worst exp_E 41.290000
Info:Polynomial Selection (size optimized): Already finished - nothing to do
Info:Complete Factorization / Discrete logarithm: Polynomial Selection (size optimized)
Info:Polynomial Selection (size optimized): Aggregate statistics:
Info:Polynomial Selection (size optimized): potential collisions: 197037
Info:Polynomial Selection (size optimized): raw lognorm (nr/min/av/max/std): 187086/47.390/57.661/70.520/2.531
Info:Polynomial Selection (size optimized): optimized lognorm (nr/min/av/max/std): 159319/45.370/50.112/61.410/1.439
Info:Polynomial Selection (size optimized): Total time: 114097
Info:Polynomial Selection (root optimized): Starting
Info:Polynomial Selection (root optimized): Best polynomial previously has Murphy_E = 3.881e-07
Info:Polynomial Selection (root optimized): Already finished - nothing to do
Info:Polynomial Selection (root optimized): Best overall polynomial was 7-th in list after size optimization
Info:Complete Factorization / Discrete logarithm: Polynomial Selection (root optimized)
Info:Polynomial Selection (root optimized): Aggregate statistics:
Info:Polynomial Selection (root optimized): Total time: 7154.01
Info:Polynomial Selection (root optimized): Rootsieve time: 7198.95
Info:Generate Factor Base: Starting
Info:Complete Factorization / Discrete logarithm: Generate Factor Base
Info:Generate Factor Base: Total cpu/real time for makefb: 16.07/2.77252
Info:Generate Free Relations: Starting
Info:Complete Factorization / Discrete logarithm: Generate Free Relations
Info:Generate Free Relations: Total cpu/real time for freerel: 962.51/121.92
Info:Lattice Sieving: Starting
Info:Lattice Sieving: We want 164000000 relation(s)
Info:Lattice Sieving: Adding workunit c155_sieving_14300000-14320000 to database
Info:API server: Got notification to stop serving Workunits
Info:Generate Free Relations: Total cpu/real time for freerel: 962.51/121.92
Info:Polynomial Selection (root optimized): Aggregate statistics:
Info:Polynomial Selection (root optimized): Total time: 7154.01
Info:Polynomial Selection (root optimized): Rootsieve time: 7198.95
Info:Polynomial Selection (size optimized): Aggregate statistics:
Info:Polynomial Selection (size optimized): potential collisions: 197037
Info:Polynomial Selection (size optimized): raw lognorm (nr/min/av/max/std): 187086/47.390/57.661/70.520/2.531
Info:Polynomial Selection (size optimized): optimized lognorm (nr/min/av/max/std): 159319/45.370/50.112/61.410/1.439
Info:Polynomial Selection (size optimized): Total time: 114097
Info:Generate Factor Base: Total cpu/real time for makefb: 16.07/2.77252
Info:Client Launcher: Stopped client localhost (Host localhost, PID 5275)
Info:Client Launcher: Stopped client localhost+2 (Host localhost, PID 5284)
Info:Client Launcher: Stopped client localhost+3 (Host localhost, PID 5296)
Info:Client Launcher: Stopped client localhost+4 (Host localhost, PID 5308)
Info:API server: Shutting down server on exception UNIQUE constraint failed: workunits.wuid
Traceback (most recent call last):
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/./bin/cado-nfs.py", line 210, in <module>
    factors = factorjob.run()
              ^^^^^^^^^^^^^^^
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/cadotask.py", line 7192, in run
    last_status = task.run()
                  ^^^^^^^^^^
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/cadotask.py", line 3859, in run
    self.submit_command(p, "%d-%d" % (q0, q1), commit=False)
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/cadotask.py", line 1909, in submit_command
    self.submit_wu(wutext, commit=commit)
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/cadotask.py", line 1806, in submit_wu
    self.wuar.create(wu, commit=commit)
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/wudb.py", line 394, in create
    self.conn.harness_transaction(EXCLUSIVE,
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/database/base.py", line 109, in harness_transaction
    return transaction(cursor, *args, **kwargs)
           ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/database/table.py", line 69, in insert
    values[self.primarykey] = cursor.insert(self.tablename, d)
                              ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/database/base.py", line 335, in insert
    self._exec(command, values)
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/database/base.py", line 262, in _exec
    self.try_catch_execute(command, values)
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/database/sqlite3.py", line 27, in try_catch_execute
    super().try_catch_execute(command, values)
  File "/home/mehrati2019/Documents/Math/cado-nfs/installed/lib/cado-nfs-3.0.0/scripts/cadofactor/database/base.py", line 274, in try_catch_execute
    self.cursor.execute(command, values)
sqlite3.IntegrityError: UNIQUE constraint failed: workunits.wuid