ERROR: raise NoSuchRowError() / block_id = self.db.get_val('SELECT id FROM blocks WHERE hash=?', (hash_,))

[Michael Conrad]

I'm testing s3ql out, installed via apt, with a newer trio installed on Ubuntu 21.10

I'm getting the following when trying to copy files to the mount which results in needing to umount and fsck the mount.

Suggestions?

trio                     0.19.0

dpkg --list | grep s3ql
ii  s3ql                                               3.7.0+dfsg-2build1

2021-12-22 15:02:58.115 1807134:MainThread root.excepthook: Uncaught top-level exception:
Traceback (most recent call last):
  File "/usr/lib/s3ql/s3ql/database.py", line 143, in get_row
    row = next(res)
StopIteration

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/lib/s3ql/s3ql/block_cache.py", line 472, in upload_if_dirty
    block_id = self.db.get_val('SELECT id FROM blocks WHERE hash=?', (hash_,))
  File "/usr/lib/s3ql/s3ql/database.py", line 127, in get_val
    return self.get_row(*a, **kw)[0]
  File "/usr/lib/s3ql/s3ql/database.py", line 145, in get_row
    raise NoSuchRowError()
s3ql.database.NoSuchRowError: Query produced 0 result rows

During handling of the above exception, another exception occurred:

Traceback (most recent call last):
  File "/usr/bin/mount.s3ql", line 33, in <module>
    sys.exit(load_entry_point('s3ql==3.7.0', 'console_scripts', 'mount.s3ql')())
  File "/usr/lib/s3ql/s3ql/mount.py", line 131, in main
    trio.run(main_async, options, stdout_log_handler)
  File "/usr/local/lib/python3.9/dist-packages/trio/_core/_run.py", line 1932, in run
    raise runner.main_task_outcome.error
  File "/usr/lib/s3ql/s3ql/mount.py", line 289, in main_async
    unmount_clean = True
  File "/usr/local/lib/python3.9/dist-packages/trio/_core/_run.py", line 815, in __aexit__
    raise combined_error_from_nursery
  File "/usr/lib/s3ql/s3ql/mount.py", line 749, in run
    await self.block_cache.upload_if_dirty(el)
  File "/usr/lib/s3ql/s3ql/block_cache.py", line 491, in upload_if_dirty
    await self._queue_upload((el, obj_id))
  File "/usr/lib/s3ql/s3ql/block_cache.py", line 536, in _queue_upload
    raise NoWorkerThreads('no upload threads')
s3ql.block_cache.NoWorkerThreads: no upload threads

[Daniel Jagszent]

Hello Michael,

> I'm testing s3ql out, installed via apt, with a newer trio installed
> on Ubuntu 21.10
>

> [...]

>
> dpkg --list | grep s3ql
> ii  s3ql                                               3.7.0+dfsg-2build1
>
> 2021-12-22 15:02:58.115 1807134:MainThread root.excepthook: Uncaught
> top-level exception:
> Traceback (most recent call last):
>   File "/usr/lib/s3ql/s3ql/database.py", line 143, in get_row
>     row = next(res)
> StopIteration

You need a newer version, see
https://groups.google.com/g/s3ql/c/CJjXsOo9Ago/m/Ylmb_O7LBQAJ