Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

idr0033-rohban-pathways S-BIAD848 #649

Open
12 tasks done
will-moore opened this issue Feb 22, 2023 · 26 comments
Open
12 tasks done

idr0033-rohban-pathways S-BIAD848 #649

will-moore opened this issue Feb 22, 2023 · 26 comments

Comments

@will-moore
Copy link
Member

will-moore commented Feb 22, 2023

Conversion

  • 41744
  • 41744_illum_corrected
  • 41749
  • 41749_illum_corrected
  • 41754
  • 41754_illum_corrected
  • 41755
  • 41755_illum_corrected
  • 41756
  • 41756_illum_corrected
  • 41757
  • 41757_illum_corrected
@will-moore will-moore moved this to test convert in NGFF conversion Feb 22, 2023
@dominikl dominikl moved this from test convert to re-import test image in NGFF conversion Feb 27, 2023
@dominikl
Copy link
Member

dominikl commented Mar 6, 2023

Reimport still in progress on pilot-idrtesting (since 28th Feb...)

@sbesson sbesson self-assigned this Apr 26, 2023
@sbesson
Copy link
Member

sbesson commented Apr 27, 2023

Incidentally, I came across this conversion as part of a separate body of work. With the help of @melissalinkert, a workaround was found to inject additional plate metadata, let this data be recognized via the MetaXpress reader and use bioformats2raw 0.6.1 directly.

On the pilot with SSD drive

(conversion) [sbesson@pilot-zarr2-dev ~]$ time ~/bioformats2raw-0.6.1/bin/bioformats2raw -p /data/idr0033/41744/taoe005-u2os-72h-cp-a-au00044859.HTD /data/idr0033/41744.zarr
...
[3455/3] 100% │███████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████████│ 5/5 (0:00:00 / 0:00:00)

real    37m22.858s
user    132m59.999s
sys     9m5.163s
(conversion) [sbesson@pilot-zarr2-dev ~]$ du -csh /data/idr0033/41744.zarr/
51G     /data/idr0033/41744.zarr/
51G     total

If that's useful for the ongoing work, happy to upload the NGFF dataset for the first plate into a temporary idr0033 bucket and allow you to test the fileset swap and/or start the conversion of the rest of the study.

@will-moore
Copy link
Member Author

$ aws --endpoint-url https://uk1s3.embassy.ebi.ac.uk s3 mb s3://idr0033
make_bucket: idr0033
$ aws --endpoint-url https://uk1s3.embassy.ebi.ac.uk s3api put-bucket-policy --bucket idr0033 --policy file://policy.json
$ aws --endpoint-url https://uk1s3.embassy.ebi.ac.uk s3api put-bucket-cors --bucket idr0033  --cors-configuration file://cors.json

@will-moore
Copy link
Member Author

$ /home/wmoore/mc ls uk1s3/idr0033/zarr
[2023-04-27 10:06:54 UTC]     0B 41744.zarr/

https://ome.github.io/ome-ngff-validator/?source=https://uk1s3.embassy.ebi.ac.uk/idr0033/zarr/41744.zarr - currently partially uploaded

@will-moore
Copy link
Member Author

@sbesson
Copy link
Member

sbesson commented Apr 27, 2023

For reference, this is the script that was used for symlinking the source TIFFs and renaming them according to the pattern expected by the reader

import os
import re

pattern=r'(.*)(_[a-p]\d\d)(.*)'

sourcedir='/uod/idr/filesets/idr0033-rohban-pathways/20170214-original/'
targetdir='/data/idr0033/sources/'

plates = ['41744', '41749', '41754', '41755', '41756', '41757']
types = ['images', 'images_illum_corrected']
def replace(s):
    return s.groups()[0]+ s.groups()[1].upper()+s.groups()[2]

for type in types:
    for plate in plates:
        source_plate = os.path.join(sourcedir, type, plate)
        target_plate = os.path.join(targetdir, type, plate)
        tiffs = os.listdir(source_plate)
        
        for tiff in tiffs:
            new_tiff = re.sub(pattern, replace, tiff)
            os.symlink(os.path.join(source_plate, tiff), os.path.join(target_plate, new_tiff))

and the content of the metadata file which must be saved as <plate_prefix>.HTD alongside the symlinks

"HTSInfoFile", Version 1.0
"Description", "BBBC037 41749"
"PlateType", 1
"TimePoints", 1
"ZSeries", FALSE
"ZSteps", 1
"ZProjection", FALSE
"XWells", 24
"YWells", 16
"WellsSelection1", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection2", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection3", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection4", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection5", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection6", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection7", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection8", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection9", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection10", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection11", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection12", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection13", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection14", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection15", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"WellsSelection16", TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE, TRUE
"Sites", TRUE
"XSites", 3
"YSites", 3
"SiteSelection1", TRUE, TRUE, TRUE
"SiteSelection2", TRUE, TRUE, TRUE
"SiteSelection3", TRUE, TRUE, TRUE
"Waves", TRUE
"NWavelengths", 5
"WaveName1", "Hoechst"
"WaveName2", "ERSyto"
"WaveName3", "ERSytoBleed"
"WaveName4", "PhGolgi"
"WaveName5", "Mito"
"WaveCollect1", 1
"WaveCollect2", 1
"WaveCollect3", 1
"WaveCollect4", 1
"WaveCollect5", 1
"UniquePlateIdentifier", "abc123"
"EndFile"

With the above, Bio-Formats correctly detects the plate as MetaXpress and the bioformats2raw conversion utility can be used natively to generate NGFF

@will-moore
Copy link
Member Author

will-moore commented Apr 27, 2023

Started import of metadata-only plate on idr0125-pilot - uploading nearly 4 hours... - Import took > 8 hours.
Following #656

#  tail -f /tmp/41744.zarr.err 

2023-04-27 11:01:49,972 20637      [      main] INFO       ome.formats.OMEROMetadataStoreClient - Server: 5.6.7
2023-04-27 11:01:49,972 20637      [      main] INFO       ome.formats.OMEROMetadataStoreClient - Client: 5.6.2
2023-04-27 11:01:49,972 20637      [      main] INFO       ome.formats.OMEROMetadataStoreClient - Java Version: 11.0.13
2023-04-27 11:01:49,972 20637      [      main] INFO       ome.formats.OMEROMetadataStoreClient - OS Name: Linux
2023-04-27 11:01:49,972 20637      [      main] INFO       ome.formats.OMEROMetadataStoreClient - OS Arch: amd64
2023-04-27 11:01:49,972 20637      [      main] INFO       ome.formats.OMEROMetadataStoreClient - OS Version: 3.10.0-1160.45.1.el7.x86_64
2023-04-27 11:01:50,112 20777      [2-thread-1] INFO   ormats.importer.cli.LoggingImportMonitor - FILESET_UPLOAD_PREPARATION

...

2023-04-27 19:35:18,024 30828689   [l.Client-4] INFO   ormats.importer.cli.LoggingImportMonitor - IMPORT_DONE Imported file: /ngff/idr0033/41744.zarr/OME/METADATA.ome.xml
Other imported objects:
Fileset:5286991

==> Summary
21525 files uploaded, 1 fileset, 1 plate created, 3456 images imported, 0 errors in 8:33:28.125

@will-moore
Copy link
Member Author

will-moore commented Apr 28, 2023

$ python scripts/managed_repo_symlinks.py Fileset:5286991 /idr0033/zarr --report
Render Image 14778952

Fileset: 5286991 /data/OMERO/ManagedRepository/demo_2/Blitz-0-Ice.ThreadPool.Server-25/2023-04/27/11-01-50.951/
fs_contents ['41744.zarr']
Link from /data/OMERO/ManagedRepository/demo_2/Blitz-0-Ice.ThreadPool.Server-25/2023-04/27/11-01-50.951/41744.zarr to /idr0033/zarr/41744.zarr

Plate Images are viewable on pilot-idr0125: http://localhost:1080/webclient/?show=plate-10388

@will-moore
Copy link
Member Author

@sbesson - you're currently converting the rest of the plates and uploading to s3 bucket?

I'll update the status of this issue...
I see these ones done so far: 👍

[wmoore@pilot-zarr2-dev ~]$ /home/wmoore/mc ls uk1s3/idr0033/zarr
[2023-04-28 10:48:18 UTC]     0B 41744.zarr/
[2023-04-28 10:48:18 UTC]     0B 41749.zarr/
[2023-04-28 10:48:18 UTC]     0B 41754.zarr/
[2023-04-28 10:48:18 UTC]     0B 41755.zarr/
[2023-04-28 10:48:18 UTC]     0B 41756.zarr/
[2023-04-28 10:48:18 UTC]     0B 41757.zarr/

@will-moore will-moore moved this from re-import test image to convert all data to NGFF in NGFF conversion Apr 28, 2023
@sbesson
Copy link
Member

sbesson commented Apr 28, 2023

Yes converting and updating the checklist as a new dataset is uploaded to the bucket

@sbesson sbesson moved this from convert all data to NGFF to upload data to s3 in NGFF conversion Jun 12, 2023
@will-moore will-moore moved this from upload data to s3 to create new Fileset to replace original Fileset in NGFF conversion Jun 23, 2023
@will-moore
Copy link
Member Author

Checked all plates on s3 with ome-ngff-validator 👍

@will-moore will-moore moved this from create new Fileset to replace original Fileset to Zip and upload to BioStudies in NGFF conversion Jun 26, 2023
@will-moore will-moore moved this from Zip and upload to BioStudies to upload some data to s3 and test in NGFF conversion Jun 26, 2023
@will-moore will-moore moved this from upload some data to s3 and test to Zip and upload to BioStudies in NGFF conversion Jun 28, 2023
@sbesson sbesson removed their assignment Jun 28, 2023
@will-moore
Copy link
Member Author

@sbesson Where are the .zarr for idr0033?
I couldn't find them on pilot-zarr1-dev or pilot-zarr2-dev? Thx

@sbesson
Copy link
Member

sbesson commented Jul 3, 2023

On idr-ftp downloaded the plates from the S3 bucket and zipped them in place with for i in $(ls .); do zip -rm $i.zip $i; done:

(base) [sbesson@idrftp-ftp idr0033]$ pwd
/data/idr0033
(base) [sbesson@idrftp-ftp idr0033]$ ls -alh
total 435G
drwxr-xr-x. 2 sbesson root    4.0K Jul  1 05:51 .
drwxr-xr-x. 6 root    root     143 Jun 29 12:00 ..
-rw-rw-r--. 1 sbesson sbesson  36G Jun 29 20:27 41744_illum_corrected.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jun 29 23:27 41744.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  36G Jun 30 02:31 41749_illum_corrected.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jun 30 05:30 41749.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jun 30 08:34 41754_illum_corrected.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jun 30 11:33 41754.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jun 30 14:38 41755_illum_corrected.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jun 30 17:35 41755.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  36G Jun 30 20:38 41756_illum_corrected.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jun 30 23:42 41756.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  36G Jul  1 02:48 41757_illum_corrected.zarr.zip
-rw-rw-r--. 1 sbesson sbesson  37G Jul  1 05:50 41757.zarr.zip

Ready for the next phase and the upload

@will-moore will-moore moved this from Zip and upload to BioStudies to BioStudies Submission in NGFF conversion Aug 7, 2023
@will-moore will-moore assigned francesw and unassigned will-moore Aug 7, 2023
@francesw francesw moved this from BioStudies Submission to Data on Embassy s3 in NGFF conversion Aug 15, 2023
@francesw francesw changed the title idr0033-rohban-pathways to NGFF idr0033-rohban-pathways S-BIAD848 Aug 15, 2023
@francesw francesw removed their assignment Aug 15, 2023
@francesw francesw moved this from Data on Embassy s3 to BioStudies Submission in NGFF conversion Aug 16, 2023
@francesw francesw removed their assignment Aug 17, 2023
@will-moore
Copy link
Member Author

@francesw francesw moved this from BioStudies Submission to Data on Embassy s3 in NGFF conversion Aug 18, 2023
@francesw francesw moved this from Data on Embassy s3 to BioStudies Submission in NGFF conversion Aug 18, 2023
@will-moore will-moore moved this from BioStudies Submission to Data on Embassy s3 in NGFF conversion Aug 22, 2023
@francesw francesw moved this from Data on Embassy s3 to BioStudies Submission in NGFF conversion Aug 23, 2023
@francesw francesw moved this from BioStudies Submission to Data on Embassy s3 in NGFF conversion Aug 24, 2023
@will-moore
Copy link
Member Author

Testing mkngff on idr0125-pilot.

idr0033/41749.ome.zarr,S-BIAD848/19d861dc-22ca-4739-9b6c-ac0fa179d8f5,23109
idr0033/41754.ome.zarr,S-BIAD848/1a0ebc8d-5969-4062-b0c9-b27913ce13a2,23111
idr0033/41757_illum_corrected.ome.zarr,S-BIAD848/1d6d3d59-ddfb-4625-819e-5d0f139de895,23122
idr0033/41744.ome.zarr,S-BIAD848/40b32e31-413f-4f2e-b034-e6fe89e30efb,23108
idr0033/41755.ome.zarr,S-BIAD848/5a2838f8-6489-4d47-a92b-5808127c170b,23112
for r in $(cat idr0033.csv); do
  biapath=$(echo $r | cut -d',' -f2)
  uuid=$(echo $biapath | cut -d'/' -f2)
  fsid=$(echo $r | cut -d',' -f3)
  omero mkngff sql --symlink_repo /data/OMERO/ManagedRepository --secret=$SECRET $fsid "/bia-integrator-data/$biapath/$uuid.zarr" > "$fsid.sql"
done

@will-moore
Copy link
Member Author

will-moore commented Aug 25, 2023

After about 50 mins, only the first 2 Filesets are done, 3rd in progress (lots of files to walk in these Plates)...

Took nearly 2 hours in total - about 20 mins per Fileset.

Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
Found prefix demo_2/2017-03/06 // 18-49-06.418 for fileset 23109
Checking for prefix_dir /data/OMERO/ManagedRepository/demo_2/2017-03/06/18-49-06.418
Creating dir at /data/OMERO/ManagedRepository/demo_2/2017-03/06/18-49-06.418_converted/bia-integrator-data/S-BIAD848/19d861dc-22ca-4739-9b6c-ac0fa179d8f5
Creating symlink /data/OMERO/ManagedRepository/demo_2/2017-03/06/18-49-06.418_converted/bia-integrator-data/S-BIAD848/19d861dc-22ca-4739-9b6c-ac0fa179d8f5/19d861dc-22ca-4739-9b6c-ac0fa179d8f5.zarr -> /bia-integrator-data/S-BIAD848/19d861dc-22ca-4739-9b6c-ac0fa179d8f5/19d861dc-22ca-4739-9b6c-ac0fa179d8f5.zarr
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
Found prefix demo_2/2017-03/06 // 23-31-46.781 for fileset 23111
Checking for prefix_dir /data/OMERO/ManagedRepository/demo_2/2017-03/06/23-31-46.781
Creating dir at /data/OMERO/ManagedRepository/demo_2/2017-03/06/23-31-46.781_converted/bia-integrator-data/S-BIAD848/1a0ebc8d-5969-4062-b0c9-b27913ce13a2
Creating symlink /data/OMERO/ManagedRepository/demo_2/2017-03/06/23-31-46.781_converted/bia-integrator-data/S-BIAD848/1a0ebc8d-5969-4062-b0c9-b27913ce13a2/1a0ebc8d-5969-4062-b0c9-b27913ce13a2.zarr -> /bia-integrator-data/S-BIAD848/1a0ebc8d-5969-4062-b0c9-b27913ce13a2/1a0ebc8d-5969-4062-b0c9-b27913ce13a2.zarr
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
Found prefix demo_2/2017-03/08 // 10-31-00.187 for fileset 23122
Checking for prefix_dir /data/OMERO/ManagedRepository/demo_2/2017-03/08/10-31-00.187
Creating dir at /data/OMERO/ManagedRepository/demo_2/2017-03/08/10-31-00.187_converted/bia-integrator-data/S-BIAD848/1d6d3d59-ddfb-4625-819e-5d0f139de895
Creating symlink /data/OMERO/ManagedRepository/demo_2/2017-03/08/10-31-00.187_converted/bia-integrator-data/S-BIAD848/1d6d3d59-ddfb-4625-819e-5d0f139de895/1d6d3d59-ddfb-4625-819e-5d0f139de895.zarr -> /bia-integrator-data/S-BIAD848/1d6d3d59-ddfb-4625-819e-5d0f139de895/1d6d3d59-ddfb-4625-819e-5d0f139de895.zarr
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
Found prefix demo_2/2017-03/06 // 14-24-32.180 for fileset 23108
Checking for prefix_dir /data/OMERO/ManagedRepository/demo_2/2017-03/06/14-24-32.180
Creating dir at /data/OMERO/ManagedRepository/demo_2/2017-03/06/14-24-32.180_converted/bia-integrator-data/S-BIAD848/40b32e31-413f-4f2e-b034-e6fe89e30efb
Creating symlink /data/OMERO/ManagedRepository/demo_2/2017-03/06/14-24-32.180_converted/bia-integrator-data/S-BIAD848/40b32e31-413f-4f2e-b034-e6fe89e30efb/40b32e31-413f-4f2e-b034-e6fe89e30efb.zarr -> /bia-integrator-data/S-BIAD848/40b32e31-413f-4f2e-b034-e6fe89e30efb/40b32e31-413f-4f2e-b034-e6fe89e30efb.zarr
Using session for demo@localhost:4064. Idle timeout: 10 min. Current group: Public
Found prefix demo_2/2017-03/07 // 04-03-26.724 for fileset 23112
Checking for prefix_dir /data/OMERO/ManagedRepository/demo_2/2017-03/07/04-03-26.724
Creating dir at /data/OMERO/ManagedRepository/demo_2/2017-03/07/04-03-26.724_converted/bia-integrator-data/S-BIAD848/5a2838f8-6489-4d47-a92b-5808127c170b
Creating symlink /data/OMERO/ManagedRepository/demo_2/2017-03/07/04-03-26.724_converted/bia-integrator-data/S-BIAD848/5a2838f8-6489-4d47-a92b-5808127c170b/5a2838f8-6489-4d47-a92b-5808127c170b.zarr -> /bia-integrator-data/S-BIAD848/5a2838f8-6489-4d47-a92b-5808127c170b/5a2838f8-6489-4d47-a92b-5808127c170b.zarr

@will-moore
Copy link
Member Author

for r in $(cat idr0033.csv); do
  fsid=$(echo $r | cut -d',' -f3)
  psql -U omero -d idr -h 192.168.10.231 -f "$fsid.sql"
done

BEGIN
psql:23109.sql:39216: ERROR:  cannot set original repo property without secret key
CONTEXT:  PL/pgSQL function _protect_originalfile_repo_insert() line 28 at RAISE
SQL statement "insert into originalfile
          (id, permissions, creation_id, group_id, owner_id, update_id, mimetype, repo, path, name)
          values (nextval('seq_originalfile'), old_perms, new_event, old_group, old_owner, new_event,
            info[i][3], repo, info[i][1], uuid || info[i][2])
          returning id"
PL/pgSQL function mkngff_fileset(bigint,character varying,character varying,character varying,text[]) line 42 at SQL statement
ROLLBACK

But this certainly has the correct secret:

$ cat 23109.sql | grep 4b358149-af39-49f0-882d-10884fab7133
      '4b358149-af39-49f0-882d-10884fab7133',

psql -U omero -d idr -h 192.168.10.102 -c "select uuid from (select * from session where node = 0 and owner = 0 and defaulteventtype = 'Sessions' order by id desc limit 1) x order by x.id asc limit 1;"
                 uuid                 
--------------------------------------
 4b358149-af39-49f0-882d-10884fab7133
(1 row)

@will-moore
Copy link
Member Author

As @sbesson noted, I have the wrong host in that psql query for secret!

@will-moore
Copy link
Member Author

will-moore commented Aug 30, 2023

https://uk1s3.embassy.ebi.ac.uk/bia-integrator-data/pages/S-BIAD848.html
now has 8 out of 12 plates viewable...

idr0033/41749.ome.zarr,S-BIAD848/19d861dc-22ca-4739-9b6c-ac0fa179d8f5,23109
idr0033/41754.ome.zarr,S-BIAD848/1a0ebc8d-5969-4062-b0c9-b27913ce13a2,23111
idr0033/41757_illum_corrected.ome.zarr,S-BIAD848/1d6d3d59-ddfb-4625-819e-5d0f139de895,23122
idr0033/41744.ome.zarr,S-BIAD848/40b32e31-413f-4f2e-b034-e6fe89e30efb,23108
idr0033/41755.ome.zarr,S-BIAD848/5a2838f8-6489-4d47-a92b-5808127c170b,23112
idr0033/41756.ome.zarr,S-BIAD848/68d2d088-a48b-4e78-81c1-c59b0acc1f73,23114
idr0033/41749_illum_corrected.ome.zarr,S-BIAD848/8bafd83a-e4f3-4dd5-9ddc-6094012a390f,23118
idr0033/41754_illum_corrected.ome.zarr,S-BIAD848/9c1a5073-3ebd-4e04-894c-900022e554e1,23119

forgot to update idr0033.csv so only first 5 of those got used...

$ for r in $(cat $IDRID.csv); do
  fsid=$(echo $r | cut -d',' -f3)
  psql -U omero -d idr -h $DBHOST -f "$fsid.sql"
done

BEGIN
 mkngff_fileset 
----------------
        5287482
(1 row)
COMMIT
BEGIN
 mkngff_fileset 
----------------
        5287483
(1 row)
COMMIT
BEGIN
 mkngff_fileset 
----------------
        5287484
(1 row)
COMMIT
BEGIN
 mkngff_fileset 
----------------
        5287485
(1 row)
COMMIT
BEGIN
 mkngff_fileset 
----------------
        5287486
(1 row)
COMMIT

UPDATE: after "19 hours" images are still not visible (checking plate 41749), due to memo file still being generated?

@will-moore
Copy link
Member Author

Still checking http://localhost:1080/webclient/?show=image-3201293 and no image showing yet after > 24 hours

@will-moore will-moore moved this from Data on Embassy s3 to create new Filesets in idr-next in NGFF conversion Sep 4, 2023
@will-moore
Copy link
Member Author

will-moore commented Sep 12, 2023

Testing on idr-testing:omeroreadwrite with todays OMEZarrReader.jar including ome/ZarrReader#64

Started mkngff on 12 Plates (see IDR/idr-utils@504b9d9) at 13:09...

@will-moore
Copy link
Member Author

All sql generated overnight...

drwxr-xr-x.  2 omero-server omero-server  210 Sep 13 03:33 .
drwxr-xr-x. 12 omero-server root         4.0K Sep 12 12:09 ..
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 17:41 23108.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 13:34 23109.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 14:57 23111.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 20:31 23112.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 21:57 23114.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 13 03:33 23115.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 13 04:57 23116.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 13 00:42 23118.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 13 02:09 23119.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 23:20 23120.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 19:04 23121.sql
-rw-r--r--.  1 omero-server omero-server 5.0M Sep 12 16:19 23122.sql

last one completed at 04:57(GMT) (~6am BST) - 18 hours - 1.5 hours each.

@will-moore
Copy link
Member Author

After sql update, viewing Image in first plate to init memo file... http://localhost:1080/webclient/?show=image-3191231

@will-moore
Copy link
Member Author

[wmoore@test120-omeroreadwrite ~]$ grep -A 2 "saved memo" /opt/omero/server/OMERO.server/var/log/Blitz-0.log | grep -A 2 "14-24-32.180_mkngff"
2023-09-14 09:07:32,288 DEBUG [                   loci.formats.Memoizer] (l.Server-2) saved memo file: /data/OMERO/BioFormatsCache/data/OMERO/ManagedRepository/demo_2/2017-03/06/14-24-32.180_mkngff/40b32e31-413f-4f2e-b034-e6fe89e30efb.zarr/OME/.METADATA.ome.xml.bfmemo (11691040 bytes)
2023-09-14 09:07:32,288 DEBUG [                   loci.formats.Memoizer] (l.Server-2) start[1694595772741] time[86679547] tag[loci.formats.Memoizer.setId]
2023-09-14 09:07:32,288 INFO  [                ome.io.nio.PixelsService] (l.Server-2) Creating BfPixelBuffer: /data/OMERO/ManagedRepository/demo_2/2017-03/06/14-24-32.180_mkngff/40b32e31-413f-4f2e-b034-e6fe89e30efb.zarr/OME/METADATA.ome.xml Series: 0

Memo file creation (black images) took 86679547 ms which is 24 hours for a Plate.

@will-moore will-moore moved this from check_pixels to check_pixels in progress in NGFF conversion Dec 4, 2023
@will-moore will-moore moved this from check_pixels in progress to pixels validated in NGFF conversion Dec 11, 2023
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
Status: NGFF studies
Development

No branches or pull requests

4 participants