Unexpected error when pulling ssh remote storage

[tommilyytinen]

I set up a basic SSH remote and successfully pushed the initial material. However, when I tried to pull from another location, I encountered the following error message:
`dvc pull -v
2025-02-26 14:16:57,570 DEBUG: v3.59.1 (conda), CPython 3.11.11 on Linux-4.18.0-425.10.1.el8_7.x86_64-x86_64-with-glibc2.28
2025-02-26 14:16:57,570 DEBUG: command: /home/toltommi/miniconda3/envs/dvc_env/bin/dvc pull -v
Collecting |0.00 [00:00, ?entry/s]
2025-02-26 14:16:58,427 DEBUG: Preparing to transfer data from 'ssh://espnr097.ad.vtt.fi/home/toltommi/dvc_stellarator_storage/files/md5' to '/export/home/toltommi/work/stellarator_work/stellarator_neutronics/.dvc/cache/files/md5'
2025-02-26 14:16:58,427 DEBUG: Preparing to collect status from '/export/home/toltommi/work/stellarator_work/stellarator_neutronics/.dvc/cache/files/md5'
2025-02-26 14:16:58,428 DEBUG: Collecting status from '/export/home/toltommi/work/stellarator_work/stellarator_neutronics/.dvc/cache/files/md5'
2025-02-26 14:16:58,437 DEBUG: Preparing to collect status from '/home/toltommi/dvc_stellarator_storage/files/md5'
2025-02-26 14:16:58,437 DEBUG: Collecting status from '/home/toltommi/dvc_stellarator_storage/files/md5'
2025-02-26 14:16:58,438 DEBUG: Querying 1 oids via object_exists
2025-02-26 14:16:58,453 DEBUG: Indexing new .dir '0da0b93e7513bdc07a38313b7bbf1b8c.dir' with '2480' nested files
Fetching
2025-02-26 14:16:58,454 ERROR: unexpected error - no such column: "size" - should this be a string literal in single-quotes?
Traceback (most recent call last):
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc/cli/init.py", line 211, in main
ret = cmd.do_run()
^^^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc/cli/command.py", line 27, in do_run
return self.run()
^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc/commands/data_sync.py", line 35, in run
stats = self.repo.pull(
^^^^^^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc/repo/init.py", line 58, in wrapper
return f(repo, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc/repo/pull.py", line 30, in pull
processed_files_count = self.fetch(
^^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc/repo/init.py", line 58, in wrapper
return f(repo, *args, **kwargs)
^^^^^^^^^^^^^^^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc/repo/fetch.py", line 184, in fetch
fetch_transferred, fetch_failed = ifetch(
^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc_data/index/fetch.py", line 129, in fetch
result = transfer(
^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc_data/hashfile/transfer.py", line 203, in transfer
status = compare_status(
^^^^^^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc_data/hashfile/status.py", line 190, in compare_status
src_exists, src_missing = status(
^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc_data/hashfile/status.py", line 139, in status
exists = hashes.intersection(
^^^^^^^^^^^^^^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc_data/hashfile/status.py", line 82, in indexed_dir_hashes
index.update([dir_hash], file_hashes)
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/dvc_data/hashfile/db/index.py", line 138, in update
self.index[hash] = True
~~~~~~~~~~^^^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/diskcache/persistent.py", line 802, in setitem
self._cache[key] = value
~~~~~~~~~~~^^^^^
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/diskcache/core.py", line 823, in setitem
self.set(key, value, retry=True)
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/diskcache/core.py", line 808, in set
self._row_insert(db_key, raw, now, columns)
File "/home/toltommi/miniconda3/envs/dvc_env/lib/python3.11/site-packages/diskcache/core.py", line 857, in _row_insert
sql(
sqlite3.OperationalError: no such column: "size" - should this be a string literal in single-quotes?

2025-02-26 14:16:58,470 DEBUG: Version info for developers:
DVC version: 3.59.1 (conda)

Platform: Python 3.11.11 on Linux-4.18.0-425.10.1.el8_7.x86_64-x86_64-with-glibc2.28
Subprojects:
dvc_data = 3.16.9
dvc_objects = 5.1.0
dvc_render = 1.0.2
dvc_task = 0.40.2
scmrepo = 3.3.10
Supports:
http (aiohttp = 3.11.13, aiohttp-retry = 2.8.3),
https (aiohttp = 3.11.13, aiohttp-retry = 2.8.3),
ssh (sshfs = 2025.2.0)
Config:
Global: /home/toltommi/.config/dvc
System: /etc/xdg/dvc
Cache types: https://error.dvc.org/no-dvc-cache
Caches: local
Remotes: ssh
Workspace directory: xfs on /dev/sda1
Repo: dvc, git
Repo.site_cache_dir: /var/tmp/dvc/repo/68f4ffb1d5b6afcee28f7eba7ebf17c9

Having any troubles? Hit us up at https://dvc.org/support, we are always happy to help!
2025-02-26 14:16:58,471 DEBUG: Analytics is enabled.
2025-02-26 14:16:58,498 DEBUG: Trying to spawn ['daemon', 'analytics', '/tmp/tmptymf6bgu', '-v']
2025-02-26 14:16:58,503 DEBUG: Spawned ['daemon', 'analytics', '/tmp/tmptymf6bgu', '-v'] with pid 3136926`

[skshetry]

PTAL at #10692 (comment).