process_controller.py 34 KB
Newer Older
1
2
# -*- coding: utf-8 -*-

3
from __future__ import (division, print_function, unicode_literals, absolute_import)
4
5
6

import numpy as np
from pandas import DataFrame
7
8
9
10
import datetime
import os
import time
from itertools import chain
11
import signal
12
import re
Daniel Scheffler's avatar
Daniel Scheffler committed
13
from typing import TYPE_CHECKING
14

15
16
from ..io import output_writer as OUT_W
from ..io import input_reader as INP_R
17
18
19
20
21
22
from ..misc import database_tools as DB_T
from ..misc import helper_functions as HLP_F
from ..misc import environment as ENV
from ..misc.path_generator import path_generator
from ..misc.logging import GMS_logger, shutdown_loggers
from ..algorithms import L1A_P, L1B_P, L1C_P, L2A_P, L2B_P, L2C_P
23
from ..model.metadata import get_LayerBandsAssignment
24
25
from ..model.gms_object import failed_GMS_object
from .pipeline import (L1A_map, L1A_map_1, L1A_map_2, L1A_map_3, L1B_map, L1C_map,
26
                       L2A_map, L2B_map, L2C_map)
27
28
from ..config import set_config, GMS_config
from .multiproc import MAP
29
from ..misc.definition_dicts import proc_chain, db_jobs_statistics_def
30

31
32
from py_tools_ds.numeric.array import get_array_tilebounds

33
if TYPE_CHECKING:
Daniel Scheffler's avatar
Daniel Scheffler committed
34
    from collections import OrderedDict  # noqa F401  # flake8 issue
35
36
37
38


__author__ = 'Daniel Scheffler'

39
40

class process_controller(object):
41
    def __init__(self, job_ID, exec_mode='Python', db_host='localhost',
42
                 parallelization_level='scenes', delete_old_output=False, job_config_kwargs=None):
43
        # type: (str, str, str, str, bool) -> None
44

45
        """gms_preprocessing process controller
46
47
48
49

        :param job_ID:                  <int> a job ID belonging to a valid database record within table 'jobs'
        :param exec_mode:               <str> choices: 'Python' - writes all intermediate data to disk
                                                       'Flink'  - keeps all intermediate data in memory
50
        :param db_host:                 <str> hostname of the host where database is hosted
51
52
        :param parallelization_level:   <str> choices: 'scenes' - parallelization on scene-level
                                                       'tiles'  - parallelisation on tile-level
53
54
        :param delete_old_output:       <bool> whether to delete previously created output of the given job ID
                                        before running the job (default = False)
55
56
57
        """

        # assertions
58
59
60
61
        if not isinstance(job_ID, int):
            raise ValueError("'job_ID' must be an integer value. Got %s." % type(job_ID))
        if exec_mode not in ['Python', 'Flink']:
            raise ValueError("Unexpected exec_mode '%s'!" % exec_mode)
62
        if parallelization_level not in ['scenes', 'tiles']:
63
            raise ValueError("Unexpected parallelization_level '%s'!" % parallelization_level)
64

65
66
        self.parallLev = parallelization_level
        self._logger = None
67
        self._DB_job_record = None
68
        self.profiler = None
69
70
71
72
73

        self.failed_objects = []
        self.L1A_newObjects = []
        self.L1B_newObjects = []
        self.L1C_newObjects = []
74
        self.L2A_tiles = []
75
76
77
78
        self.L2B_newObjects = []
        self.L2C_newObjects = []

        self.summary_detailed = None
79
        self.summary_quick = None
80
81

        # set GMS configuration
82
83
        set_config(job_ID=job_ID, exec_mode=exec_mode, db_host=db_host, reset=True, **job_config_kwargs)
        self.config = GMS_config
84
85

        # check environment
86
87
        self.GMSEnv = ENV.GMSEnvironment(self.logger)
        self.GMSEnv.check_dependencies()
88
        self.GMSEnv.check_read_write_permissions()
89

90
91
        # check if process_controller is executed by debugger
        # isdebugging = 1 if True in [frame[1].endswith("pydevd.py") for frame in inspect.stack()] else False
92
        # if isdebugging:  # override the existing settings in order to get write access everywhere
93
94
        #    pass

95
        # called_from_iPyNb = 1 if 'ipykernel/__main__.py' in sys.argv[0] else 0
96

97
        self.logger.info('Process Controller initialized for job ID %s (comment: %s).'
98
                         % (self.config.ID, self.DB_job_record.comment))
99

100
101
102
        if delete_old_output:
            self.logger.info('Deleting previously processed data...')
            self.DB_job_record.delete_procdata_of_entire_job(force=True)
103

104
105
106
107
108
    @property
    def logger(self):
        if self._logger and self._logger.handlers[:]:
            return self._logger
        else:
109
110
111
            self._logger = GMS_logger('log__%s' % self.config.ID,
                                      path_logfile=os.path.join(self.config.path_job_logs, '%s.log' % self.config.ID),
                                      log_level=self.config.log_level, append=False)
112
113
114
115
116
117
118
119
120
121
122
123
124
            return self._logger

    @logger.setter
    def logger(self, logger):
        self._logger = logger

    @logger.deleter
    def logger(self):
        if self._logger not in [None, 'not set']:
            self.logger.close()
            self.logger = None

    @property
125
126
127
128
    def DB_job_record(self):
        if self._DB_job_record:
            return self._DB_job_record
        else:
129
130
            self._DB_job_record = DB_T.GMS_JOB(self.config.conn_database)
            self._DB_job_record.from_job_ID(self.config.ID)
131
            return self._DB_job_record
132

133
134
135
    @DB_job_record.setter
    def DB_job_record(self, value):
        self._DB_job_record = value
136

137
138
139
    @property
    def sceneids_failed(self):
        return [obj.scene_ID for obj in self.failed_objects]
140

141
142
143
    @staticmethod
    def add_local_availability(dataset):
        # TODO revise this function
144
145
146
        # TODO this does not respect that all subsystems of the same scene ID must be available at the same proc level!

        # query the database and get the last written processing level and LayerBandsAssignment
147
        DB_match = DB_T.get_info_from_postgreSQLdb(
148
            GMS_config.conn_database, 'scenes_proc', ['proc_level', 'layer_bands_assignment'],
149
            dict(sceneid=dataset['scene_ID']))
150
151

        # get the corresponding logfile
152
153
        path_logfile = path_generator(
            dataset).get_path_logfile()  # FIXME this always returns the logfile for the subsystem.
154

155
156
        # FIXME -> merged logfiles (L2A+) are ignored
        # FIXME -> for subsystems the highest start procL is L2A
157

158
        def get_AllWrittenProcL_dueLog(path_log):  # TODO replace this by database query + os.path.exists
159
160
            """Returns all processing level that have been successfully written according to logfile."""

161
            if not os.path.exists(path_log):
162
                print("No logfile named '%s' found for %s at %s. Dataset has to be reprocessed."
163
164
165
166
167
168
                      % (os.path.basename(path_log), dataset['entity_ID'], os.path.dirname(path_log)))
                AllWrittenProcL_dueLog = []
            else:
                logfile = open(path_log, 'r').read()
                AllWrittenProcL_dueLog = re.findall(":*(\S*\s*) data successfully saved.", logfile, re.I)
                if not AllWrittenProcL_dueLog:  # AllWrittenProcL_dueLog = []
169
                    print('%s: According to logfile no completely processed data exist at any processing level. '
170
171
172
173
174
                          'Dataset has to be reprocessed.' % dataset['entity_ID'])
                else:
                    AllWrittenProcL_dueLog = HLP_F.sorted_nicely(list(set(AllWrittenProcL_dueLog)))
            return AllWrittenProcL_dueLog

175
        # check if there are not multiple database records for this dataset
176
        if len(DB_match) == 1 or DB_match == [] or DB_match == 'database connection fault':
177
178

            # get all processing level that have been successfully written
179
180
            AllWrittenProcL = get_AllWrittenProcL_dueLog(path_logfile)
            dataset['proc_level'] = None  # default (dataset has to be reprocessed)
181
182

            # loop through all the found proc. levels and find the one that fulfills all requirements
183
            for ProcL in reversed(AllWrittenProcL):
184
185
                if dataset['proc_level']:
                    break  # proc_level found; no further searching for lower proc_levels
186
                assumed_path_GMS_file = '%s_%s.gms' % (os.path.splitext(path_logfile)[0], ProcL)
187
188

                # check if there is also a corresponding GMS_file on disk
189
190
                if os.path.isfile(assumed_path_GMS_file):
                    GMS_file_dict = INP_R.GMSfile2dict(assumed_path_GMS_file)
191
                    target_LayerBandsAssignment = \
192
                        get_LayerBandsAssignment(dict(
193
194
195
196
197
                            image_type=dataset['image_type'],
                            Satellite=dataset['satellite'],
                            Sensor=dataset['sensor'],
                            Subsystem=dataset['subsystem'],
                            proc_level=ProcL,  # must be respected because LBA changes after atm. Corr.
198
                            dataset_ID=dataset['dataset_ID'],
199
200
201
202
                            logger=None), nBands=(1 if dataset['sensormode'] == 'P' else None))

                    # check if the LayerBandsAssignment of the written dataset on disk equals the
                    # desired LayerBandsAssignment
203
                    if target_LayerBandsAssignment == GMS_file_dict['LayerBandsAssignment']:
204
205

                        # update the database record if the dataset could not be found in database
206
                        if DB_match == [] or DB_match == 'database connection fault':
207
208
                            print('The dataset %s is not included in the database of processed data but according to '
                                  'logfile %s has been written successfully. Recreating missing database entry.'
209
210
                                  % (dataset['entity_ID'], ProcL))
                            DB_T.data_DB_updater(GMS_file_dict)
211

212
                            dataset['proc_level'] = ProcL
213
214

                        # if the dataset could be found in database
215
216
                        elif len(DB_match) == 1:
                            try:
217
                                print('Found a matching %s dataset for %s. Processing skipped until %s.'
218
                                      % (ProcL, dataset['entity_ID'], proc_chain[proc_chain.index(ProcL) + 1]))
219
                            except IndexError:
220
                                print('Found a matching %s dataset for %s. Processing already done.'
221
                                      % (ProcL, dataset['entity_ID']))
222

223
224
225
226
                            if DB_match[0][0] == ProcL:
                                dataset['proc_level'] = DB_match[0][0]
                            else:
                                dataset['proc_level'] = ProcL
227

228
                    else:
229
                        print('Found a matching dataset for %s but with a different LayerBandsAssignment. '
230
231
232
233
234
                              'Dataset has to be reprocessed.' % dataset['entity_ID'])
                else:
                    print('%s for dataset %s has been written due to logfile but no corresponding dataset has been '
                          'found.' % (ProcL, dataset['entity_ID']) + ' Searching for lower processing level...'
                          if AllWrittenProcL.index(ProcL) != 0 else '')
235

236
        elif len(DB_match) > 1:
237
            print('According to database there are multiple matches for the dataset %s. Dataset has to be reprocessed.'
238
239
                  % dataset['entity_ID'])
            dataset['proc_level'] = None
240

241
242
243
244
245
        else:
            dataset['proc_level'] = None

        return dataset

246
247
    @staticmethod
    def _is_inMEM(GMS_objects, dataset):
Daniel Scheffler's avatar
Daniel Scheffler committed
248
        # type: (list, OrderedDict) -> bool
249
250
251
252
        """Checks whether a dataset within a dataset list has been processed in the previous processing level.
        :param GMS_objects: <list> a list of GMS objects that has been recently processed
        :param dataset:     <collections.OrderedDict> as generated by L0A_P.get_data_list_of_current_jobID()
        """
253
        # check if the scene ID of the given dataset is in the scene IDs of the previously processed datasets
254
255
256
257
        return dataset['scene_ID'] in [obj.scene_ID for obj in GMS_objects]

    @staticmethod
    def _is_already_present(dataset, procLvl):
258
259
260
261
262
263
        """Checks if the given dataset is already available on disk.

        :param dataset:     <GMS object>
        :param procLvl:     <str> processing level to be checked
        :return:            <bool>
        """
264
265
266
        return HLP_F.proc_level_already_present(dataset['proc_level'], procLvl)

    def _get_processor_data_list(self, procLvl, prevLvl_objects=None):
267
        """Returns a list of datasets that have to be read from disk and then processed by a specific processor.
268
269
270
271
272

        :param procLvl:
        :param prevLvl_objects:
        :return:
        """
273
274
        def is_already_present(dataset):
            return HLP_F.proc_level_already_present(dataset['proc_level'], target_lvl=procLvl)
275
276

        if prevLvl_objects is None:
277
            return [dataset for dataset in self.config.data_list if not is_already_present(dataset)]  # TODO generator?
278
        else:
279
            return [dataset for dataset in self.config.data_list if not is_already_present(dataset) and
280
                    not self._is_inMEM(prevLvl_objects + self.failed_objects, dataset)]
281
282
283
284
285
286
287
288
289
290
291
292
293

    def get_DB_objects(self, procLvl, prevLvl_objects=None, parallLev=None, blocksize=None):
        """
        Returns a list of GMS objects for datasets available on disk that have to be processed by the current processor.

        :param procLvl:         <str> processing level oof the current processor
        :param prevLvl_objects: <list> of in-mem GMS objects produced by the previous processor
        :param parallLev:       <str> parallelization level ('scenes' or 'tiles')
                                -> defines if full cubes or blocks are to be returned
        :param blocksize:       <tuple> block size in case blocks are to be returned, e.g. (2000,2000)
        :return:
        """
        # TODO get prevLvl_objects automatically from self
294
        if procLvl == 'L1A':
295
296
297
298
            return []
        else:
            # handle input parameters
            parallLev = parallLev if parallLev else self.parallLev
299
            blocksize = blocksize if blocksize else self.config.tiling_block_size_XY
300
            prevLvl = proc_chain[proc_chain.index(procLvl) - 1]  # TODO replace by enum
301
302

            # get GMSfile list
303
            dataset_dicts = self._get_processor_data_list(procLvl, prevLvl_objects)
304
305
306
307
308
            GMSfile_list_prevLvl_inDB = INP_R.get_list_GMSfiles(dataset_dicts, prevLvl)

            # create GMS objects from disk with respect to parallelization level and block size
            if parallLev == 'scenes':
                # get input parameters for creating GMS objects as full cubes
309
                work = [[GMS, ['cube', None]] for GMS in GMSfile_list_prevLvl_inDB]
310
311
            else:
                # define tile positions and size
312
                def get_tilepos_list(GMSfile):
313
314
                    return get_array_tilebounds(array_shape=INP_R.GMSfile2dict(GMSfile)['shape_fullArr'],
                                                tile_shape=blocksize)
315
316
317

                # get input parameters for creating GMS objects as blocks
                work = [[GMSfile, ['block', tp]] for GMSfile in GMSfile_list_prevLvl_inDB
318
                        for tp in get_tilepos_list(GMSfile)]
319

320
321
322
323
            # create GMS objects for the found files on disk
            # NOTE: DON'T multiprocess that with MAP(GMS_object(*initargs).from_disk, work)
            # in case of multiple subsystems GMS_object(*initargs) would always point to the same object in memory
            # -> subsystem attribute will be overwritten each time
324
            def init_GMS_obj(): return HLP_F.parentObjDict[prevLvl](*HLP_F.initArgsDict[prevLvl])
325
326
            DB_objs = [init_GMS_obj().from_disk(tuple_GMS_subset=w) for w in work]  # init

327
328
329
330
331
            if DB_objs:
                DB_objs = list(chain.from_iterable(DB_objs)) if list in [type(i) for i in DB_objs] else list(DB_objs)

            return DB_objs

332
333
334
335
    def run_all_processors(self, custom_data_list=None):
        """
        Run all processors at once.
        """
336

337
        signal.signal(signal.SIGINT, self.stop)  # enable clean shutdown possibility
338

339
        # noinspection PyBroadException
340
        try:
341
            if self.config.profiling:
342
343
344
345
                from pyinstrument import Profiler
                self.profiler = Profiler()  # or Profiler(use_signal=False), see below
                self.profiler.start()

346
            self.logger.info('Execution of entire GeoMultiSens pre-processing chain started for job ID %s...'
347
                             % self.config.ID)
348
            self.DB_job_record.reset_job_progress()  # updates attributes of DB_job_record and related DB entry
349
            self.config.status = 'running'
350
            self.update_DB_job_record()  # TODO implement that into job.status.setter
351
352
353
354
355

            self.failed_objects = []

            # get list of datasets to be processed
            if custom_data_list:
356
                self.config.data_list = custom_data_list
357
358

            # add local availability
359
360
            self.config.data_list = MAP(self.add_local_availability, self.config.data_list)
            self.update_DB_job_statistics(self.config.data_list)
361
362
363
364
365
366
367
368
369
370
371
372

            self.L1A_processing()
            self.L1B_processing()
            self.L1C_processing()
            self.L2A_processing()
            self.L2B_processing()
            self.L2C_processing()

            # create summary
            self.create_job_summary()

            self.logger.info('Execution finished.')
373
            # TODO implement failed_with_warnings:
374
375
376
377
            self.config.status = 'finished' if not self.failed_objects else 'finished_with_errors'
            self.config.end_time = datetime.datetime.now()
            self.config.computation_time = self.config.end_time - self.config.start_time
            self.logger.info('Time for execution: %s' % self.config.computation_time)
378
379
380
381

            # update database entry of current job
            self.update_DB_job_record()

382
            if self.config.profiling:
383
384
385
386
387
                self.profiler.stop()
                print(self.profiler.output_text(unicode=True, color=True))

            shutdown_loggers()

388
        except Exception:  # noqa E722  # bare except
389
            if self.config.profiling:
390
391
392
                self.profiler.stop()
                print(self.profiler.output_text(unicode=True, color=True))

393
            self.config.status = 'failed'
394
395
            self.update_DB_job_record()

396
            if not self.config.disable_exception_handler:
397
                self.logger.error('Execution failed with an error:', exc_info=True)
398
399
                shutdown_loggers()
            else:
400
                self.logger.error('Execution failed with an error:')
401
402
                shutdown_loggers()
                raise
403

404
405
    def stop(self, signum, frame):
        """Interrupt the running process controller gracefully."""
406

407
        self.config.status = 'canceled'
408
409
        self.update_DB_job_record()

410
        self.logger.warning('Process controller stopped by user.')
411
412
        del self.logger
        shutdown_loggers()
413

414
        raise KeyboardInterrupt  # terminate execution and show traceback
415

416
417
418
419
    def benchmark(self):
        """
        Run a benchmark.
        """
420
        data_list_bench = self.config.data_list
421
422
423
424
        for count_datasets in range(len(data_list_bench)):
            t_processing_all_runs, t_IO_all_runs = [], []
            for count_run in range(10):
                current_data_list = data_list_bench[0:count_datasets + 1]
425
426
                if os.path.exists(self.config.path_database):
                    os.remove(self.config.path_database)
427
428
429
430
431
432
433
434
435
436
                t_start = time.time()
                self.run_all_processors(current_data_list)
                t_processing_all_runs.append(time.time() - t_start)
                t_IO_all_runs.append(globals()['time_IO'])

            assert current_data_list, 'Empty data list.'
            OUT_W.write_global_benchmark_output(t_processing_all_runs, t_IO_all_runs, current_data_list)

    def L1A_processing(self):
        """
437
        Run Level 1A processing: Data import and metadata homogenization
438
        """
439
        if self.config.exec_L1AP[0]:
440
            self.logger.info('\n\n##### Level 1A Processing started - raster format and metadata homogenization ####\n')
441

442
443
444
445
            datalist_L1A_P = self._get_processor_data_list('L1A')

            if self.parallLev == 'scenes':
                # map
446
                L1A_resObjects = MAP(L1A_map, datalist_L1A_P, CPUs=12)
447
            else:  # tiles
448
449
                all_L1A_tiles_map1 = MAP(L1A_map_1, datalist_L1A_P,
                                         flatten_output=True)  # map_1 # merge results to new list of splits
450

451
452
453
                L1A_obj_tiles = MAP(L1A_map_2, all_L1A_tiles_map1)  # map_2
                grouped_L1A_Tiles = HLP_F.group_objects_by_attributes(
                    L1A_obj_tiles, 'scene_ID', 'subsystem')  # group results
454

455
                L1A_objects = MAP(L1A_P.L1A_object().from_tiles, grouped_L1A_Tiles)  # reduce
456

457
                L1A_resObjects = MAP(L1A_map_3, L1A_objects)  # map_3
458

459
            self.L1A_newObjects = [obj for obj in L1A_resObjects if isinstance(obj, L1A_P.L1A_object)]
460
            self.failed_objects += [obj for obj in L1A_resObjects if isinstance(obj, failed_GMS_object) and
461
462
463
464
465
466
                                    obj.scene_ID not in self.sceneids_failed]

        return self.L1A_newObjects

    def L1B_processing(self):
        """
467
        Run Level 1B processing: calculation of geometric shifts
468
469
470
471
        """
        # TODO implement check for running spatial index mediator server
        # run on full cubes

472
        if self.config.exec_L1BP[0]:
473
            self.logger.info('\n\n####### Level 1B Processing started - detection of geometric displacements #######\n')
474

475
476
            L1A_DBObjects = self.get_DB_objects('L1B', self.L1A_newObjects, parallLev='scenes')
            L1A_Instances = self.L1A_newObjects + L1A_DBObjects  # combine newly and earlier processed L1A data
477

478
            L1B_resObjects = MAP(L1B_map, L1A_Instances)
479

480
481
482
            self.L1B_newObjects = [obj for obj in L1B_resObjects if isinstance(obj, L1B_P.L1B_object)]
            self.failed_objects += [obj for obj in L1B_resObjects if isinstance(obj, failed_GMS_object) and
                                    obj.scene_ID not in self.sceneids_failed]
483
484
485
486
487

        return self.L1B_newObjects

    def L1C_processing(self):
        """
488
        Run Level 1C processing: atmospheric correction
489
        """
490
        if self.config.exec_L1CP[0]:
491
            self.logger.info('\n\n############## Level 1C Processing started - atmospheric correction ##############\n')
492

493
            if self.parallLev == 'scenes':
494
495
496
497
                L1B_DBObjects = self.get_DB_objects('L1C', self.L1B_newObjects)
                L1B_Instances = self.L1B_newObjects + L1B_DBObjects  # combine newly and earlier processed L1B data

                # group by scene ID (all subsystems belonging to the same scene ID must be processed together)
498
                grouped_L1B_Instances = HLP_F.group_objects_by_attributes(L1B_Instances, 'scene_ID')
499

500
501
                L1C_resObjects = MAP(L1C_map, grouped_L1B_Instances, flatten_output=True,
                                     CPUs=15)  # FIXME CPUs set to 15 for testing
502

503
            else:  # tiles
504
505
                raise NotImplementedError("Tiled processing is not yet completely implemented for L1C processor. Use "
                                          "parallelization level 'scenes' instead!")
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
                # blocksize = (5000, 5000)
                # """if newly processed L1A objects are present: cut them into tiles"""
                # L1B_newTiles = []
                # if self.L1B_newObjects:
                #     tuples_obj_blocksize = [(obj, blocksize) for obj in self.L1B_newObjects]
                #     L1B_newTiles = MAP(HLP_F.cut_GMS_obj_into_blocks, tuples_obj_blocksize, flatten_output=True)
                #
                # """combine newly and earlier processed L1B data"""
                # L1B_newDBTiles = self.get_DB_objects('L1C', self.L1B_newObjects, blocksize=blocksize)
                # L1B_tiles = L1B_newTiles + L1B_newDBTiles
                #
                # # TODO merge subsets of S2/Aster in order to provide all bands for atm.correction
                # L1C_tiles = MAP(L1C_map, L1B_tiles)
                # grouped_L1C_Tiles = \
                #     HLP_F.group_objects_by_attributes(L1C_tiles, 'scene_ID', 'subsystem')  # group results
                # [L1C_tiles_group[0].delete_tempFiles() for L1C_tiles_group in grouped_L1C_Tiles]
                # L1C_resObjects = MAP(L1C_P.L1C_object().from_tiles, grouped_L1C_Tiles)  # reduce

            self.L1C_newObjects = [obj for obj in L1C_resObjects if isinstance(obj, L1C_P.L1C_object)]
525
            self.failed_objects += [obj for obj in L1C_resObjects if isinstance(obj, failed_GMS_object) and
526
527
528
529
530
531
                                    obj.scene_ID not in self.sceneids_failed]

        return self.L1C_newObjects

    def L2A_processing(self):
        """
532
        Run Level 2A processing: geometric homogenization
533
        """
534
        if self.config.exec_L2AP[0]:
535
536
            self.logger.info(
                '\n\n#### Level 2A Processing started - shift correction / geometric homogenization ####\n')
537

538
            """combine newly and earlier processed L1C data"""
539
540
            L1C_DBObjects = self.get_DB_objects('L2A', self.L1C_newObjects, parallLev='scenes')
            L1C_Instances = self.L1C_newObjects + L1C_DBObjects  # combine newly and earlier processed L1C data
541
542
543
544

            # group by scene ID (all subsystems belonging to the same scene ID must be processed together)
            grouped_L1C_Instances = HLP_F.group_objects_by_attributes(L1C_Instances, 'scene_ID')

545
            L2A_resTiles = MAP(L2A_map, grouped_L1C_Instances, flatten_output=True)
546

547
            self.L2A_tiles = [obj for obj in L2A_resTiles if isinstance(obj, L2A_P.L2A_object)]
548
            self.failed_objects += [obj for obj in L2A_resTiles if isinstance(obj, failed_GMS_object) and
549
550
551
552
553
554
                                    obj.scene_ID not in self.sceneids_failed]

        return self.L2A_tiles

    def L2B_processing(self):
        """
555
        Run Level 2B processing: spectral homogenization
556
        """
557
        if self.config.exec_L2BP[0]:
558
            self.logger.info('\n\n############# Level 2B Processing started - spectral homogenization ##############\n')
559

560
561
            if self.parallLev == 'scenes':
                # don't know if scenes makes sense in L2B processing because full objects are very big!
562
                """if newly processed L2A objects are present: merge them to scenes"""
563
564
                grouped_L2A_Tiles = HLP_F.group_objects_by_attributes(self.L2A_tiles, 'scene_ID')  # group results
                # reduce # will be too slow because it has to pickle back really large L2A_newObjects
565
                # L2A_newObjects  = MAP(HLP_F.merge_GMS_tiles_to_GMS_obj, grouped_L2A_Tiles)
566
                L2A_newObjects = [L2A_P.L2A_object().from_tiles(tileList) for tileList in grouped_L2A_Tiles]
567

568
                """combine newly and earlier processed L2A data"""
569
570
                L2A_DBObjects = self.get_DB_objects('L2B', self.L2A_tiles)
                L2A_Instances = L2A_newObjects + L2A_DBObjects  # combine newly and earlier processed L2A data
571

572
                L2B_resObjects = MAP(L2B_map, L2A_Instances)
573
574

            else:  # tiles
575
                L2A_newTiles = self.L2A_tiles  # tiles have the block size specified in L2A_map_2
576
577

                """combine newly and earlier processed L2A data"""
578
579
580
                blocksize = (2048, 2048)  # must be equal to the blocksize of L2A_newTiles specified in L2A_map_2
                L2A_newDBTiles = self.get_DB_objects('L2B', self.L2A_tiles, blocksize=blocksize)
                L2A_tiles = L2A_newTiles + L2A_newDBTiles
581

582
                L2B_tiles = MAP(L2B_map, L2A_tiles)
583
584

                grouped_L2B_Tiles = \
585
586
                    HLP_F.group_objects_by_attributes(L2B_tiles,
                                                      'scene_ID')  # group results # FIXME nötig an dieser Stelle?
587
588
                [L2B_tiles_group[0].delete_tempFiles() for L2B_tiles_group in grouped_L2B_Tiles]

589
                L2B_resObjects = [L2B_P.L2B_object().from_tiles(tileList) for tileList in grouped_L2B_Tiles]
590

591
            self.L2B_newObjects = [obj for obj in L2B_resObjects if isinstance(obj, L2B_P.L2B_object)]
592
            self.failed_objects += [obj for obj in L2B_resObjects if isinstance(obj, failed_GMS_object) and
593
594
595
596
597
598
                                    obj.scene_ID not in self.sceneids_failed]

        return self.L2B_newObjects

    def L2C_processing(self):
        """
599
        Run Level 2C processing: accurracy assessment and MGRS tiling
600
        """
601
        # FIXME only parallelization_level == 'scenes' implemented
602
        if self.config.exec_L2CP[0]:
603
            self.logger.info('\n\n########## Level 2C Processing started - calculation of quality layers ###########\n')
604

605
            """combine newly and earlier processed L2A data"""
606
607
            L2B_DBObjects = self.get_DB_objects('L2C', self.L2B_newObjects, parallLev='scenes')
            L2B_Instances = self.L2B_newObjects + L2B_DBObjects  # combine newly and earlier processed L2A data
608

609
            L2C_resObjects = MAP(L2C_map, L2B_Instances, CPUs=8)  # FIXME 8 workers due to heavy IO
610
            # FIXME in Flink mode results are too big to be back-pickled
611
            self.L2C_newObjects = [obj for obj in L2C_resObjects if isinstance(obj, L2C_P.L2C_object)]
612
            self.failed_objects += [obj for obj in L2C_resObjects if isinstance(obj, failed_GMS_object) and
613
614
615
616
617
618
619
620
                                    obj.scene_ID not in self.sceneids_failed]

        return self.L2C_newObjects

    def update_DB_job_record(self):
        """
        Update the database records of the current job (table 'jobs').
        """
621
        # TODO move this method to config.Job
622
623
        # update 'failed_sceneids' column of job record within jobs table
        sceneids_failed = list(set([obj.scene_ID for obj in self.failed_objects]))
624
        DB_T.update_records_in_postgreSQLdb(
625
            self.config.conn_database, 'jobs',
626
            {'failed_sceneids': sceneids_failed,  # update 'failed_sceneids' column
627
628
629
             'finishtime': self.config.end_time,  # add job finish timestamp
             'status': self.config.status},  # update 'job_status' column
            {'id': self.config.ID})
630

631
632
633
634
635
    def update_DB_job_statistics(self, usecase_datalist):
        """
        Update job statistics of the running job in the database.
        """
        # TODO move this method to config.Job
636
        already_updated_IDs = []
637
        for ds in usecase_datalist:
638
639
            if ds['proc_level'] is not None and ds['scene_ID'] not in already_updated_IDs:
                # update statistics column of jobs table
640
                DB_T.increment_decrement_arrayCol_in_postgreSQLdb(
641
                    self.config.conn_database, 'jobs', 'statistics', cond_dict={'id': self.config.ID},
642
643
644
                    idx_val2decrement=db_jobs_statistics_def['downloaded'],
                    idx_val2increment=db_jobs_statistics_def[ds['proc_level']])

645
646
647
                # avoid double updating in case of subsystems belonging to the same scene ID
                already_updated_IDs.append(ds['scene_ID'])

648
649
650
651
    def create_job_summary(self):
        """
        Create job success summary
        """
652
653
654

        # get objects with highest requested processing level
        highest_procL_Objs = []
655
        for pL in reversed(proc_chain):
656
            if getattr(self.config, 'exec_%sP' % pL)[0]:
657
                highest_procL_Objs = getattr(self, '%s_newObjects' % pL) if pL != 'L2A' else self.L2A_tiles
658
659
                break

660
661
662
663
        gms_objects2summarize = highest_procL_Objs + self.failed_objects
        if gms_objects2summarize:
            # create summaries
            detailed_JS, quick_JS = get_job_summary(gms_objects2summarize)
664
665
666
            detailed_JS.to_excel(os.path.join(self.config.path_job_logs, '%s_summary.xlsx' % self.config.ID))
            detailed_JS.to_csv(os.path.join(self.config.path_job_logs, '%s_summary.csv' % self.config.ID), sep='\t')
            self.logger.info('\nQUICK JOB SUMMARY (ID %s):\n' % self.config.ID + quick_JS.to_string())
667
668

            self.summary_detailed = detailed_JS
669
            self.summary_quick = quick_JS
670
671
672
673
674

        else:
            # TODO implement check if proc level with lowest procL has to be processed at all (due to job.exec_L1X)
            # TODO otherwise it is possible that get_job_summary receives an empty list
            self.logger.warning("Job summary skipped because get_job_summary() received an empty list of GMS objects.")
675
676
677
678
679
680

    def clear_lists_procObj(self):
        self.failed_objects = []
        self.L1A_newObjects = []
        self.L1B_newObjects = []
        self.L1C_newObjects = []
681
        self.L2A_tiles = []
682
        self.L2B_newObjects = []
683
684
685
686
687
        self.L2C_newObjects = []


def get_job_summary(list_GMS_objects):
    # get detailed job summary
688
689
    DJS_cols = ['GMS_object', 'scene_ID', 'entity_ID', 'satellite', 'sensor', 'subsystem', 'image_type', 'proc_level',
                'arr_shape', 'arr_pos', 'failedMapper', 'ExceptionType', 'ExceptionValue', 'ExceptionTraceback']
690
691
692
693
    DJS = DataFrame(columns=DJS_cols)
    DJS['GMS_object'] = list_GMS_objects

    for col in DJS_cols[1:]:
694
695
        def get_val(obj): return getattr(obj, col) if hasattr(obj, col) else None
        DJS[col] = list(DJS['GMS_object'].map(get_val))
696
697

    del DJS['GMS_object']
698
    DJS = DJS.sort_values(by=['satellite', 'sensor', 'entity_ID'])
699
700

    # get quick job summary
701
702
703
704
    QJS = DataFrame(columns=['satellite', 'sensor', 'count', 'proc_successfully', 'proc_failed'])
    all_sat, all_sen = zip(*[i.split('__') for i in (np.unique(DJS['satellite'] + '__' + DJS['sensor']))])
    QJS['satellite'] = all_sat
    QJS['sensor'] = all_sen
705
    # count objects with the same satellite/sensor/sceneid combination
706
707
    QJS['count'] = [len(DJS[(DJS['satellite'] == sat) & (DJS['sensor'] == sen)]['scene_ID'].unique())
                    for sat, sen in zip(all_sat, all_sen)]
708
    QJS['proc_successfully'] = [len(DJS[(DJS['satellite'] == sat) &
709
710
                                        (DJS['sensor'] == sen) &
                                        (DJS['failedMapper'].isnull())]['scene_ID'].unique())
711
                                for sat, sen in zip(all_sat, all_sen)]
712
    QJS['proc_failed'] = QJS['count'] - QJS['proc_successfully']
713
714
    QJS = QJS.sort_values(by=['satellite', 'sensor'])
    return DJS, QJS