ESPRI-Mod / synda

ESGF Downloader (this is a deprecated repository, the tool has now moved to https://github.com/ESGF/esgf-download)
https://espri-mod.github.io/synda/
21 stars 11 forks source link

Error : "duplicate column name: selection_file_checksum" #119

Closed senesis closed 5 years ago

senesis commented 5 years ago

After a fresh DEB ubuntu16 install (on Ubuntu 16.04 LTS) , my first trial leads to that error :

root@pavilion-stephane:~# synda search atmos tas CMIP5

Error occured at 2019-07-24 14:58:35.197236

Traceback (most recent call last): File "/usr/bin/synda", line 130, in stream=syndautils.get_stream(subcommand=args.subcommand,parameter=args.parameter,selection_file=args.selection_file,no_default=args.no_default) File "/usr/share/python/synda/sdt/bin/syndautils.py", line 34, in get_stream import sdbuffer, sdparse, sdstream, sdconfig, sddeferredbefore, sdexception File "/usr/share/python/synda/sdt/bin/sdbuffer.py", line 20, in from sdtypes import Buffer File "/usr/share/python/synda/sdt/bin/sdtypes.py", line 25, in import sdmts File "/usr/share/python/synda/sdt/bin/sdmts.py", line 25, in import sddbpagination File "/usr/share/python/synda/sdt/bin/sddbpagination.py", line 26, in import sddb File "/usr/share/python/synda/sdt/bin/sddb.py", line 148, in sddbversion.check_version(conn) # this call upgrade the database schema if database version does not match binary version File "/usr/share/python/synda/sdt/bin/sddbversion.py", line 47, in check_version upgrade_db(conn,current_db_version,sdapp.version) File "/usr/share/python/synda/sdt/bin/sddbversion.py", line 59, in upgrade_db upgrade_procsv File "/usr/share/python/synda/sdt/bin/sddbversion.py", line 92, in upgrade_35 conn.execute("alter table history add column selection_file_checksum TEXT") OperationalError: duplicate column name: selection_file_checksum root@pavilion-stephane:~# whoami root

senesis commented 5 years ago

Version 3.10 solved the issue