Upgrading Failed from V1.3 to V2

Dear Sen4Cap and @cudroiu,

We are running Sen4Cap in our own VM and we are trying to upgrade to version 2.0 but it’s failed with below error. We noticed that generating L2A also stopped working. Please help to solve it out.

Thanks and Regards,
Henry

Error at the beginning

BEGIN
psql:migrations/sen4cap/migration-1.2-1.3.sql:249: NOTICE: running migrations
psql:migrations/sen4cap/migration-1.2-1.3.sql:249: NOTICE:
INSERT INTO processor (id, name, short_name, label) VALUES (3, ‘L3B Vegetation Status’,‘l3b’, 'L3B — LAI/FAPAR/FCOVER/NDVI ') on conflict(id) DO UPDATE SET name = ‘L3B Vegetation Status’, short_name = ‘l3b’, label = ‘L3B — LAI/FAPAR/FCOVER/NDVI’;

            DELETE FROM config WHERE key = 'processor.l3b.lai.link_l3c_to_l3b';
            DELETE FROM config WHERE key = 'processor.l3b_lai.sub_products';

            DELETE FROM config WHERE key = 'executor.processor.l3b_lai.slurm_qos';
            DELETE FROM config WHERE key = 'general.scratch-path.l3b_lai';
            INSERT INTO config(key, site_id, value) VALUES ('executor.processor.l3b.slurm_qos', NULL, 'qoslai') on conflict DO nothing;
            INSERT INTO config(key, site_id, value) VALUES ('general.scratch-path.l3b', NULL, '/mnt/archive/orchestrator_temp/l3b/{job_id}/{                                                                                             task_id}-{module}') on conflict DO nothing;

Error at the end

PL/pgSQL function inline_code_block line 784 at EXECUTE
ROLLBACK
Key processor.l2a.maja.gipp-path found with value /mnt/archive/gipp_maja. Copying UserConfiguration into this location …
Copying reference data
Installing conda …
/home/sen2agri-service/miniconda3/etc/profile.d/conda.sh found …
Miniconda already installed for user sen2agri-service. Nothing to do …
Setting report_errors to false…
sen4cap conda environment already exists. Checking for pyarrow installation …
Requirement already satisfied: pyarrow in ./miniconda3/envs/sen4cap/lib/python3.6/site-packages (3.0.0)
Requirement already satisfied: numpy>=1.16.6 in ./miniconda3/envs/sen4cap/lib/python3.6/site-packages (from pyarrow) (1.19.5)
Environments:

conda environments:

base * /home/sen2agri-service/miniconda3
sen4cap /home/sen2agri-service/miniconda3/envs/sen4cap

Updating R packages…

Hi Henry,

Could you provide me the full installation log, if possible (or at least all the log concerning the database updates)? The relevant error message is probably somewhere between the messages you provided.

Best regards,
Cosmin

Dear @cudroiu,

Please see log i can retrieveupgrading failed log.txt (103.6 KB) in the attachment. I can try updating again if u need full log.

Thanks and Regards,
Henry

Hi Henry,

That is weird. Could you provide also the content of the config table, please?

Best regards,
Cosmin

Dear Cosmin,

Yes indeed. it’s weird. Please see config table in the attachment. config.txt (50.9 KB)

Best Regards,
Henry

Please execute:

psql -U admin se4cap -c “delete from config where key in (‘processor.l2a.maja.launcher’, ‘processor.l2a.maja.gipp-path’)”

And then run the “update.sh” again. Not sure why you already have these keys in your config table.

Please let me know.

Best regards,
Cosmin

1 Like

Dear Cosmin,

It’s worked like a magic. Thanks a lot for your support as always.

Best Regards,
Henry