Error when running event-based scenario risk

[Karim Farokhnia]

Dear Admins

I see the below error when I run event-based scenario risk on my exposure. I have been tring to understand the reason of the error but no luck yet. Could you please guide me through this? 

[2015-04-25 15:47:02,482 risk job #233 - WARNING MainProcess/2643] Revoking 1 tasks

Traceback (most recent call last):

  File "/usr/bin/oq-engine", line 9, in <module>

    load_entry_point('openquake.engine==1.2.1', 'console_scripts', 'oq-engine')()

  File "/usr/lib/python2.7/dist-packages/openquake/engine/bin/openquake_cli.py", line 480, in main

    hazard_calculation_id=args.hazard_calculation_id)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/engine.py", line 362, in run_job

    run_calc(job, log_level, log_file, exports)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/engine.py", line 179, in run_calc

    _do_run_calc(calculator, exports)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/engine.py", line 216, in _do_run_calc

    calc.execute()

  File "/usr/lib/python2.7/dist-packages/openquake/engine/performance.py", line 45, in newmeth

    return method(self, *args)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/calculators/risk/base.py", line 256, in execute

    name=self.core.__name__)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/utils/tasks.py", line 131, in apply_reduce

    return starmap(task, task_args, logs.LOG.progress, name).reduce(agg, acc)

  File "/usr/lib/python2.7/dist-packages/openquake/commonlib/parallel.py", line 288, in reduce

    agg_result = self.aggregate_result_set(agg_and_percent, acc)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/utils/tasks.py", line 92, in aggregate_result_set

    acc = agg(acc, result.unpickle())

  File "/usr/lib/python2.7/dist-packages/openquake/commonlib/parallel.py", line 280, in agg_and_percent

    raise RuntimeError(val)

RuntimeError: 

  File "/usr/lib/python2.7/dist-packages/openquake/commonlib/parallel.py", line 84, in safely_call

    res = func(*args), None

  File "/usr/lib/python2.7/dist-packages/openquake/engine/utils/tasks.py", line 177, in wrapped

    task_id=tsk.request.id).delete()

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 460, in delete

    collector.collect(del_query)

  File "/usr/lib/python2.7/dist-packages/django/db/models/deletion.py", line 146, in collect

    reverse_dependency=reverse_dependency)

  File "/usr/lib/python2.7/dist-packages/django/db/models/deletion.py", line 91, in add

    if not objs:

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 129, in __nonzero__

    iter(self).next()

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 117, in _result_iter

    self._fill_cache()

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 811, in _fill_cache

    self._result_cache.append(self._iter.next())

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 289, in iterator

    for row in compiler.results_iter():

  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 680, in results_iter

    for rows in self.execute_sql(MULTI):

  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 735, in execute_sql

    cursor.execute(sql, params)

  File "/usr/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute

    return self.cursor.execute(query, args)

DatabaseError: current transaction is aborted, commands ignored until end of transaction block

Thank you

[Daniele Viganò]

Dear Karim,

make sure you don't have more than one celeryd instance running on the same machine.

You can kill all the instances running

sudo killall -9 celeryd

If needed also restart PostgreSQL to close all the pending connections

sudo service postgresql-server restart

Cheers,
Daniele

--
You received this message because you are subscribed to the Google Groups "OpenQuake Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to openquake-use...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--

DANIELE VIGANÒ | System Administrator | Skype dennyv85 | +39-0382-5169882

GLOBAL EARTHQUAKE MODEL | working together to assess risk

GEM - globalquakemodel.org | T - @GEMwrld | F - GEMwrld

[Karim Farokhnia]

Dear Daniele,

Thank you for your email. I applied what you suggested to kill all the instances and to restart PostgreSQL. But unfortunately, I still have the same error.

Let me copy the whole process I have done for the event bases risk scenario (both hazard and risk calculations). Could you see any other way to proceed?

Sorry in advance for the lengthy email.

openquake@ubuntu-32:~/GEM/oq-demos/risk/ScenarioRisk/Shiraz$ oq-engine --run-hazard job_hazard.ini

[2015-04-26 13:08:33,227 hazard job #278 - PROGRESS MainProcess/2337] **  pre_executing (hazard)

[2015-04-26 13:10:46,523 hazard job #278 - PROGRESS MainProcess/2337] **  initializing sites

[2015-04-26 13:10:51,872 hazard job #278 - PROGRESS MainProcess/2337] **  initializing site collection

[2015-04-26 13:10:51,892 hazard job #278 - INFO MainProcess/2337] Expected output size=15023000

[2015-04-26 13:10:53,849 hazard job #278 - PROGRESS MainProcess/2337] **  executing (hazard)

[2015-04-26 13:10:53,853 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #1

[2015-04-26 13:10:54,103 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #2

[2015-04-26 13:10:54,627 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #3

[2015-04-26 13:10:55,187 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #4

[2015-04-26 13:10:55,647 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #5

[2015-04-26 13:10:56,111 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #6

[2015-04-26 13:10:56,520 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #7

[2015-04-26 13:10:56,961 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #8

[2015-04-26 13:10:57,424 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #9

[2015-04-26 13:10:57,935 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #10

[2015-04-26 13:10:58,369 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #11

[2015-04-26 13:10:58,787 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #12

[2015-04-26 13:10:59,259 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #13

[2015-04-26 13:10:59,707 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #14

[2015-04-26 13:11:00,256 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #15

[2015-04-26 13:11:00,736 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #16

[2015-04-26 13:11:01,195 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #17

[2015-04-26 13:11:01,631 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #18

[2015-04-26 13:11:02,063 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #19

[2015-04-26 13:11:02,483 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #20

[2015-04-26 13:11:02,972 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #21

[2015-04-26 13:11:03,467 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #22

[2015-04-26 13:11:04,016 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #23

[2015-04-26 13:11:04,492 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #24

[2015-04-26 13:11:04,912 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #25

[2015-04-26 13:11:05,416 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #26

[2015-04-26 13:11:05,879 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #27

[2015-04-26 13:11:06,396 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #28

[2015-04-26 13:11:06,876 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #29

[2015-04-26 13:11:07,344 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #30

[2015-04-26 13:11:07,820 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #31

[2015-04-26 13:11:08,255 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #32

[2015-04-26 13:11:08,725 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #33

[2015-04-26 13:11:09,194 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #34

[2015-04-26 13:11:09,644 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #35

[2015-04-26 13:11:10,079 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #36

[2015-04-26 13:11:10,530 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #37

[2015-04-26 13:11:11,051 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #38

[2015-04-26 13:11:11,479 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #39

[2015-04-26 13:11:11,996 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #40

[2015-04-26 13:11:12,441 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #41

[2015-04-26 13:11:12,871 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #42

[2015-04-26 13:11:13,371 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #43

[2015-04-26 13:11:13,818 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #44

[2015-04-26 13:11:14,311 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #45

[2015-04-26 13:11:14,747 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #46

[2015-04-26 13:11:15,179 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #47

[2015-04-26 13:11:15,656 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #48

[2015-04-26 13:11:16,107 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #49

[2015-04-26 13:11:16,583 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #50

[2015-04-26 13:11:17,054 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #51

[2015-04-26 13:11:17,504 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #52

[2015-04-26 13:11:18,439 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #53

[2015-04-26 13:11:18,907 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #54

[2015-04-26 13:11:19,402 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #55

[2015-04-26 13:11:19,843 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #56

[2015-04-26 13:11:20,271 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #57

[2015-04-26 13:11:20,666 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #58

[2015-04-26 13:11:21,127 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #59

[2015-04-26 13:11:21,551 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #60

[2015-04-26 13:11:21,959 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #61

[2015-04-26 13:11:22,426 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #62

[2015-04-26 13:11:22,880 hazard job #278 - PROGRESS MainProcess/2337] **  Submitting task calc_gmfs #63

[2015-04-26 13:11:23,303 hazard job #278 - PROGRESS MainProcess/2337] **  Sent 55M of data

[2015-04-26 13:11:23,304 hazard job #278 - PROGRESS MainProcess/2337] **  spawned 63 tasks of kind calc_gmfs

[2015-04-26 13:11:24,622 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs   1%

[2015-04-26 13:11:24,809 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs   3%

[2015-04-26 13:11:24,968 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs   4%

[2015-04-26 13:11:25,171 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs   6%

[2015-04-26 13:11:25,337 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs   7%

[2015-04-26 13:11:25,502 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs   9%

[2015-04-26 13:11:25,699 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  11%

[2015-04-26 13:11:25,867 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  12%

[2015-04-26 13:11:26,093 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  14%

[2015-04-26 13:11:26,629 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  15%

[2015-04-26 13:11:28,017 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  17%

[2015-04-26 13:11:29,400 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  19%

[2015-04-26 13:11:30,871 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  20%

[2015-04-26 13:11:32,198 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  22%

[2015-04-26 13:11:33,780 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  23%

[2015-04-26 13:11:35,278 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  25%

[2015-04-26 13:11:36,554 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  26%

[2015-04-26 13:11:37,956 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  28%

[2015-04-26 13:11:39,338 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  30%

[2015-04-26 13:11:40,587 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  31%

[2015-04-26 13:11:41,975 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  33%

[2015-04-26 13:11:43,808 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  34%

[2015-04-26 13:11:45,340 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  36%

[2015-04-26 13:11:46,749 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  38%

[2015-04-26 13:11:48,001 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  39%

[2015-04-26 13:11:49,353 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  41%

[2015-04-26 13:11:50,641 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  42%

[2015-04-26 13:11:52,102 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  44%

[2015-04-26 13:11:53,810 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  46%

[2015-04-26 13:11:55,222 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  47%

[2015-04-26 13:11:56,662 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  49%

[2015-04-26 13:11:57,969 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  50%

[2015-04-26 13:11:59,320 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  52%

[2015-04-26 13:12:00,720 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  53%

[2015-04-26 13:12:02,113 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  55%

[2015-04-26 13:12:03,844 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  57%

[2015-04-26 13:12:05,298 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  58%

[2015-04-26 13:12:06,499 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  60%

[2015-04-26 13:12:07,705 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  61%

[2015-04-26 13:12:09,080 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  63%

[2015-04-26 13:12:10,452 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  65%

[2015-04-26 13:12:11,889 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  66%

[2015-04-26 13:12:13,780 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  68%

[2015-04-26 13:12:15,159 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  69%

[2015-04-26 13:12:16,542 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  71%

[2015-04-26 13:12:17,990 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  73%

[2015-04-26 13:12:19,444 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  74%

[2015-04-26 13:12:20,921 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  76%

[2015-04-26 13:12:22,431 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  77%

[2015-04-26 13:12:24,313 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  79%

[2015-04-26 13:12:25,738 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  80%

[2015-04-26 13:12:27,125 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  82%

[2015-04-26 13:12:28,500 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  84%

[2015-04-26 13:12:29,901 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  85%

[2015-04-26 13:12:31,352 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  87%

[2015-04-26 13:12:32,574 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  88%

[2015-04-26 13:12:34,288 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  90%

[2015-04-26 13:12:35,888 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  92%

[2015-04-26 13:12:37,366 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  93%

[2015-04-26 13:12:38,810 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  95%

[2015-04-26 13:12:40,111 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  96%

[2015-04-26 13:12:41,433 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs  98%

[2015-04-26 13:12:42,299 hazard job #278 - PROGRESS MainProcess/2337] **  calc_gmfs 100%

[2015-04-26 13:12:43,249 hazard job #278 - PROGRESS MainProcess/2337] **  Received 114M of data

[2015-04-26 13:12:43,328 hazard job #278 - PROGRESS MainProcess/2337] **  post_executing (hazard)

[2015-04-26 13:13:59,823 hazard job #278 - PROGRESS MainProcess/2337] **  post_processing (hazard)

[2015-04-26 13:13:59,860 hazard job #278 - PROGRESS MainProcess/2337] **  export (hazard)

[2015-04-26 13:13:59,889 hazard job #278 - PROGRESS MainProcess/2337] **  clean_up (hazard)

[2015-04-26 13:13:59,911 hazard job #278 - PROGRESS MainProcess/2337] **  complete (hazard)

Calculation 278 completed in 326 seconds. Results:

  id | output_type | name

 463 | Ground Motion Field | GMF

openquake@ubuntu-32:~/GEM/oq-demos/risk/ScenarioRisk/Shiraz$ oq-engine --run-risk job_risk.ini --hazard-output-id 463

[2015-04-26 13:14:36,512 risk job #279 - PROGRESS MainProcess/2387] **  pre_executing (risk)

[2015-04-26 13:14:38,627 risk job #279 - INFO MainProcess/2387] Considering 15023 assets of 8 distinct taxonomies

[2015-04-26 13:14:38,634 risk job #279 - PROGRESS MainProcess/2387] **  executing (risk)

[2015-04-26 13:14:38,806 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #1

[2015-04-26 13:14:38,826 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #2

[2015-04-26 13:14:38,880 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #3

[2015-04-26 13:14:38,947 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #4

[2015-04-26 13:14:38,983 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #5

[2015-04-26 13:14:39,028 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #6

[2015-04-26 13:14:39,060 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #7

[2015-04-26 13:14:39,111 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task prepare_risk #8

[2015-04-26 13:14:39,168 risk job #279 - PROGRESS MainProcess/2387] **  Sent 0M of data

[2015-04-26 13:14:39,169 risk job #279 - PROGRESS MainProcess/2387] **  spawned 8 tasks of kind prepare_risk

[2015-04-26 13:14:39,639 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk  12%

[2015-04-26 13:14:39,813 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk  25%

[2015-04-26 13:14:40,260 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk  37%

[2015-04-26 13:14:42,561 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk  50%

[2015-04-26 13:14:45,423 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk  62%

[2015-04-26 13:14:50,831 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk  75%

[2015-04-26 13:15:11,907 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk  87%

[2015-04-26 13:15:38,023 risk job #279 - PROGRESS MainProcess/2387] **  prepare_risk 100%

[2015-04-26 13:15:38,151 risk job #279 - PROGRESS MainProcess/2387] **  Received 0M of data

[2015-04-26 13:15:38,757 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #1

[2015-04-26 13:15:38,795 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #2

[2015-04-26 13:15:38,897 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #3

[2015-04-26 13:15:38,968 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #4

[2015-04-26 13:15:39,053 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #5

[2015-04-26 13:15:39,139 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #6

[2015-04-26 13:15:39,234 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #7

[2015-04-26 13:15:39,310 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #8

[2015-04-26 13:15:39,402 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #9

[2015-04-26 13:15:39,545 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #10

[2015-04-26 13:15:39,624 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #11

[2015-04-26 13:15:39,705 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #12

[2015-04-26 13:15:39,786 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #13

[2015-04-26 13:15:39,916 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #14

[2015-04-26 13:15:40,036 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #15

[2015-04-26 13:15:40,140 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #16

[2015-04-26 13:15:40,198 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #17

[2015-04-26 13:15:40,333 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #18

[2015-04-26 13:15:40,407 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #19

[2015-04-26 13:15:40,488 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #20

[2015-04-26 13:15:40,566 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #21

[2015-04-26 13:15:40,655 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #22

[2015-04-26 13:15:40,725 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #23

[2015-04-26 13:15:40,853 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #24

[2015-04-26 13:15:40,993 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #25

[2015-04-26 13:15:41,079 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #26

[2015-04-26 13:15:41,201 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #27

[2015-04-26 13:15:41,331 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #28

[2015-04-26 13:15:41,457 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #29

[2015-04-26 13:15:41,545 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #30

[2015-04-26 13:15:41,606 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #31

[2015-04-26 13:15:41,724 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #32

[2015-04-26 13:15:41,794 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #33

[2015-04-26 13:15:41,920 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #34

[2015-04-26 13:15:41,996 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #35

[2015-04-26 13:15:42,081 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #36

[2015-04-26 13:15:42,162 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #37

[2015-04-26 13:15:42,259 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #38

[2015-04-26 13:15:42,336 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #39

[2015-04-26 13:15:42,464 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #40

[2015-04-26 13:15:42,581 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #41

[2015-04-26 13:15:42,647 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #42

[2015-04-26 13:15:42,735 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #43

[2015-04-26 13:15:42,818 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #44

[2015-04-26 13:15:42,922 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #45

[2015-04-26 13:15:43,015 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #46

[2015-04-26 13:15:43,090 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #47

[2015-04-26 13:15:43,165 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #48

[2015-04-26 13:15:43,261 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #49

[2015-04-26 13:15:43,336 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #50

[2015-04-26 13:15:43,442 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #51

[2015-04-26 13:15:43,523 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #52

[2015-04-26 13:15:43,644 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #53

[2015-04-26 13:15:43,743 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #54

[2015-04-26 13:15:43,824 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #55

[2015-04-26 13:15:43,913 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #56

[2015-04-26 13:15:44,004 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #57

[2015-04-26 13:15:44,099 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #58

[2015-04-26 13:15:44,191 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #59

[2015-04-26 13:15:44,270 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #60

[2015-04-26 13:15:44,351 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #61

[2015-04-26 13:15:44,448 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #62

[2015-04-26 13:15:44,584 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #63

[2015-04-26 13:15:44,672 risk job #279 - PROGRESS MainProcess/2387] **  Submitting task scenario #64

[2015-04-26 13:15:44,744 risk job #279 - PROGRESS MainProcess/2387] **  Sent 3M of data

[2015-04-26 13:15:44,746 risk job #279 - PROGRESS MainProcess/2387] **  spawned 64 tasks of kind scenario

[2015-04-26 13:15:46,435 risk job #279 - WARNING MainProcess/2387] Revoking 1 tasks

Thank you

[Michele Simionato]

The error is here:

  File "/usr/lib/python2.7/dist-packages/openquake/engine/utils/tasks.py", line 177, in wrapped

    task_id=tsk.request.id).delete()

The worker node is not able to delete a row in the postgres database. Why it is so? Wrong permissions? An inconsistent database?

An error before which broke the transaction?

It is impossible to know from here. However I suggest you to run the risk computation with the --no-distribute option, so that part of the

code will not be run:

oq-engine --run-risk job_risk.ini --hazard-output-id 463  --no-distribute

See if this way it works or if at least if you get a clear error.

[Karim Farokhnia]

Dear Michele,

Thank you for your help. Here is what I get after running the risk computation with the --no-distribute option; (again both hazard and risk calculation are copied). Do you see where the error come from?

openquake@ubuntu-32:~/GEM/oq-demos/risk/ScenarioRisk/Shiraz$ oq-engine --run-hazard job_hazard.ini

[2015-04-27 15:37:13,359 hazard job #280 - PROGRESS MainProcess/2307] **  pre_executing (hazard)

[2015-04-27 15:39:26,355 hazard job #280 - PROGRESS MainProcess/2307] **  initializing sites

[2015-04-27 15:39:32,113 hazard job #280 - PROGRESS MainProcess/2307] **  initializing site collection

[2015-04-27 15:39:32,136 hazard job #280 - INFO MainProcess/2307] Expected output size=15023000

[2015-04-27 15:39:34,397 hazard job #280 - PROGRESS MainProcess/2307] **  executing (hazard)

[2015-04-27 15:39:34,401 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #1

[2015-04-27 15:39:34,645 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #2

[2015-04-27 15:39:35,154 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #3

[2015-04-27 15:39:35,607 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #4

[2015-04-27 15:39:36,136 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #5

[2015-04-27 15:39:36,545 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #6

[2015-04-27 15:39:37,019 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #7

[2015-04-27 15:39:37,435 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #8

[2015-04-27 15:39:37,851 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #9

[2015-04-27 15:39:38,383 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #10

[2015-04-27 15:39:38,879 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #11

[2015-04-27 15:39:39,371 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #12

[2015-04-27 15:39:39,827 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #13

[2015-04-27 15:39:40,307 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #14

[2015-04-27 15:39:40,811 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #15

[2015-04-27 15:39:41,371 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #16

[2015-04-27 15:39:41,876 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #17

[2015-04-27 15:39:42,355 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #18

[2015-04-27 15:39:42,907 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #19

[2015-04-27 15:39:43,427 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #20

[2015-04-27 15:39:44,100 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #21

[2015-04-27 15:39:44,691 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #22

[2015-04-27 15:39:45,152 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #23

[2015-04-27 15:39:45,683 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #24

[2015-04-27 15:39:46,179 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #25

[2015-04-27 15:39:46,671 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #26

[2015-04-27 15:39:47,167 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #27

[2015-04-27 15:39:47,647 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #28

[2015-04-27 15:39:48,135 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #29

[2015-04-27 15:39:48,648 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #30

[2015-04-27 15:39:49,159 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #31

[2015-04-27 15:39:49,635 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #32

[2015-04-27 15:39:50,127 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #33

[2015-04-27 15:39:50,619 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #34

[2015-04-27 15:39:51,180 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #35

[2015-04-27 15:39:51,674 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #36

[2015-04-27 15:39:52,131 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #37

[2015-04-27 15:39:52,627 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #38

[2015-04-27 15:39:53,127 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #39

[2015-04-27 15:39:53,675 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #40

[2015-04-27 15:39:54,160 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #41

[2015-04-27 15:39:54,599 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #42

[2015-04-27 15:39:55,068 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #43

[2015-04-27 15:39:55,526 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #44

[2015-04-27 15:39:56,075 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #45

[2015-04-27 15:39:56,563 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #46

[2015-04-27 15:39:57,079 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #47

[2015-04-27 15:39:57,551 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #48

[2015-04-27 15:39:58,039 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #49

[2015-04-27 15:39:58,563 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #50

[2015-04-27 15:39:59,020 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #51

[2015-04-27 15:39:59,715 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #52

[2015-04-27 15:40:00,203 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #53

[2015-04-27 15:40:00,680 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #54

[2015-04-27 15:40:01,203 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #55

[2015-04-27 15:40:01,689 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #56

[2015-04-27 15:40:02,347 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #57

[2015-04-27 15:40:02,847 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #58

[2015-04-27 15:40:03,660 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #59

[2015-04-27 15:40:04,291 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #60

[2015-04-27 15:40:04,807 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #61

[2015-04-27 15:40:05,291 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #62

[2015-04-27 15:40:05,733 hazard job #280 - PROGRESS MainProcess/2307] **  Submitting task calc_gmfs #63

[2015-04-27 15:40:06,211 hazard job #280 - PROGRESS MainProcess/2307] **  Sent 55M of data

[2015-04-27 15:40:06,211 hazard job #280 - PROGRESS MainProcess/2307] **  spawned 63 tasks of kind calc_gmfs

[2015-04-27 15:40:07,352 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs   1%

[2015-04-27 15:40:07,585 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs   3%

[2015-04-27 15:40:07,725 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs   4%

[2015-04-27 15:40:07,952 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs   6%

[2015-04-27 15:40:08,141 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs   7%

[2015-04-27 15:40:08,318 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs   9%

[2015-04-27 15:40:08,525 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  11%

[2015-04-27 15:40:08,785 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  12%

[2015-04-27 15:40:09,341 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  14%

[2015-04-27 15:40:10,600 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  15%

[2015-04-27 15:40:11,877 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  17%

[2015-04-27 15:40:13,165 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  19%

[2015-04-27 15:40:14,659 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  20%

[2015-04-27 15:40:15,959 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  22%

[2015-04-27 15:40:17,613 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  23%

[2015-04-27 15:40:18,996 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  25%

[2015-04-27 15:40:20,359 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  26%

[2015-04-27 15:40:21,807 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  28%

[2015-04-27 15:40:23,226 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  30%

[2015-04-27 15:40:24,632 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  31%

[2015-04-27 15:40:25,853 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  33%

[2015-04-27 15:40:27,629 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  34%

[2015-04-27 15:40:28,974 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  36%

[2015-04-27 15:40:30,431 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  38%

[2015-04-27 15:40:31,998 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  39%

[2015-04-27 15:40:33,415 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  41%

[2015-04-27 15:40:35,117 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  42%

[2015-04-27 15:40:36,489 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  44%

[2015-04-27 15:40:38,298 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  46%

[2015-04-27 15:40:39,659 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  47%

[2015-04-27 15:40:41,165 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  49%

[2015-04-27 15:40:42,368 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  50%

[2015-04-27 15:40:43,716 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  52%

[2015-04-27 15:40:45,164 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  53%

[2015-04-27 15:40:46,665 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  55%

[2015-04-27 15:40:48,535 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  57%

[2015-04-27 15:40:49,925 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  58%

[2015-04-27 15:40:51,179 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  60%

[2015-04-27 15:40:52,541 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  61%

[2015-04-27 15:40:53,872 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  63%

[2015-04-27 15:40:55,186 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  65%

[2015-04-27 15:40:56,466 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  66%

[2015-04-27 15:40:58,399 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  68%

[2015-04-27 15:40:59,698 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  69%

[2015-04-27 15:41:01,111 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  71%

[2015-04-27 15:41:02,539 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  73%

[2015-04-27 15:41:03,966 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  74%

[2015-04-27 15:41:05,607 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  76%

[2015-04-27 15:41:07,333 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  77%

[2015-04-27 15:41:09,288 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  79%

[2015-04-27 15:41:10,856 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  80%

[2015-04-27 15:41:12,390 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  82%

[2015-04-27 15:41:14,103 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  84%

[2015-04-27 15:41:15,573 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  85%

[2015-04-27 15:41:17,190 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  87%

[2015-04-27 15:41:18,580 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  88%

[2015-04-27 15:41:20,410 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  90%

[2015-04-27 15:41:21,877 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  92%

[2015-04-27 15:41:23,433 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  93%

[2015-04-27 15:41:24,952 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  95%

[2015-04-27 15:41:26,629 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  96%

[2015-04-27 15:41:28,094 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs  98%

[2015-04-27 15:41:29,048 hazard job #280 - PROGRESS MainProcess/2307] **  calc_gmfs 100%

[2015-04-27 15:41:30,098 hazard job #280 - PROGRESS MainProcess/2307] **  Received 114M of data

[2015-04-27 15:41:30,164 hazard job #280 - PROGRESS MainProcess/2307] **  post_executing (hazard)

[2015-04-27 15:43:03,373 hazard job #280 - PROGRESS MainProcess/2307] **  post_processing (hazard)

[2015-04-27 15:43:03,410 hazard job #280 - PROGRESS MainProcess/2307] **  export (hazard)

[2015-04-27 15:43:03,445 hazard job #280 - PROGRESS MainProcess/2307] **  clean_up (hazard)

[2015-04-27 15:43:03,476 hazard job #280 - PROGRESS MainProcess/2307] **  complete (hazard)

Calculation 280 completed in 350 seconds. Results:

  id | output_type | name

 468 | Ground Motion Field | GMF

openquake@ubuntu-32:~/GEM/oq-demos/risk/ScenarioRisk/Shiraz$ oq-engine --run-risk job_risk.ini --hazard-output-id 468 --no-distribute

[2015-04-27 15:47:09,279 risk job #281 - PROGRESS MainProcess/2364] **  pre_executing (risk)

[2015-04-27 15:47:11,518 risk job #281 - INFO MainProcess/2364] Considering 15023 assets of 8 distinct taxonomies

[2015-04-27 15:47:11,527 risk job #281 - PROGRESS MainProcess/2364] **  executing (risk)

[2015-04-27 15:47:11,703 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #1

[2015-04-27 15:47:11,873 risk job #281 - INFO MainProcess/2364] Building (1, 1000) epsilons for taxonomy C2H-HighCode

[2015-04-27 15:47:12,081 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #2

[2015-04-27 15:47:12,151 risk job #281 - INFO MainProcess/2364] Building (1, 1000) epsilons for taxonomy S2H-HighCode

[2015-04-27 15:47:12,177 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #3

[2015-04-27 15:47:12,291 risk job #281 - INFO MainProcess/2364] Building (55, 1000) epsilons for taxonomy S2L-PreCode

[2015-04-27 15:47:12,709 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #4

[2015-04-27 15:47:12,934 risk job #281 - INFO MainProcess/2364] Building (537, 1000) epsilons for taxonomy C2L-PreCode

[2015-04-27 15:47:15,064 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #5

[2015-04-27 15:47:15,260 risk job #281 - INFO MainProcess/2364] Building (622, 1000) epsilons for taxonomy S2L-HighCode

[2015-04-27 15:47:17,635 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #6

[2015-04-27 15:47:17,923 risk job #281 - INFO MainProcess/2364] Building (1409, 1000) epsilons for taxonomy RM1L-HighCode

[2015-04-27 15:47:23,588 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #7

[2015-04-27 15:47:24,441 risk job #281 - INFO MainProcess/2364] Building (5313, 1000) epsilons for taxonomy C2L-HighCode

[2015-04-27 15:47:45,769 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task prepare_risk #8

[2015-04-27 15:47:47,083 risk job #281 - INFO MainProcess/2364] Building (7085, 1000) epsilons for taxonomy RM1L-PreCode

[2015-04-27 15:48:16,166 risk job #281 - PROGRESS MainProcess/2364] **  Sent 0M of data

[2015-04-27 15:48:16,167 risk job #281 - PROGRESS MainProcess/2364] **  spawned 8 tasks of kind prepare_risk

[2015-04-27 15:48:16,169 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk  12%

[2015-04-27 15:48:16,170 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk  25%

[2015-04-27 15:48:16,171 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk  37%

[2015-04-27 15:48:16,172 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk  50%

[2015-04-27 15:48:16,173 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk  62%

[2015-04-27 15:48:16,174 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk  75%

[2015-04-27 15:48:16,176 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk  87%

[2015-04-27 15:48:16,180 risk job #281 - PROGRESS MainProcess/2364] **  prepare_risk 100%

[2015-04-27 15:48:16,181 risk job #281 - PROGRESS MainProcess/2364] **  Received 0M of data

[2015-04-27 15:48:16,706 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #1

[2015-04-27 15:48:17,004 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #2

[2015-04-27 15:48:17,025 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #3

[2015-04-27 15:48:17,028 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #4

[2015-04-27 15:48:17,039 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #5

[2015-04-27 15:48:17,043 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #6

[2015-04-27 15:48:17,048 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #7

[2015-04-27 15:48:17,055 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #8

[2015-04-27 15:48:17,062 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #9

[2015-04-27 15:48:17,075 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #10

[2015-04-27 15:48:17,079 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #11

[2015-04-27 15:48:17,088 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #12

[2015-04-27 15:48:17,095 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #13

[2015-04-27 15:48:17,103 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #14

[2015-04-27 15:48:17,110 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #15

[2015-04-27 15:48:17,114 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #16

[2015-04-27 15:48:17,119 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #17

[2015-04-27 15:48:17,123 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #18

[2015-04-27 15:48:17,129 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #19

[2015-04-27 15:48:17,136 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #20

[2015-04-27 15:48:17,145 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #21

[2015-04-27 15:48:17,148 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #22

[2015-04-27 15:48:17,152 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #23

[2015-04-27 15:48:17,159 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #24

[2015-04-27 15:48:17,167 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #25

[2015-04-27 15:48:17,171 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #26

[2015-04-27 15:48:17,174 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #27

[2015-04-27 15:48:17,181 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #28

[2015-04-27 15:48:17,188 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #29

[2015-04-27 15:48:17,191 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #30

[2015-04-27 15:48:17,203 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #31

[2015-04-27 15:48:17,206 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #32

[2015-04-27 15:48:17,215 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #33

[2015-04-27 15:48:17,225 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #34

[2015-04-27 15:48:17,229 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #35

[2015-04-27 15:48:17,235 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #36

[2015-04-27 15:48:17,238 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #37

[2015-04-27 15:48:17,246 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #38

[2015-04-27 15:48:17,251 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #39

[2015-04-27 15:48:17,259 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #40

[2015-04-27 15:48:17,265 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #41

[2015-04-27 15:48:17,271 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #42

[2015-04-27 15:48:17,274 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #43

[2015-04-27 15:48:17,358 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #44

[2015-04-27 15:48:17,362 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #45

[2015-04-27 15:48:17,365 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #46

[2015-04-27 15:48:17,372 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #47

[2015-04-27 15:48:17,377 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #48

[2015-04-27 15:48:17,380 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #49

[2015-04-27 15:48:17,384 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #50

[2015-04-27 15:48:17,390 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #51

[2015-04-27 15:48:17,396 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #52

[2015-04-27 15:48:17,404 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #53

[2015-04-27 15:48:17,409 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #54

[2015-04-27 15:48:17,416 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #55

[2015-04-27 15:48:17,418 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #56

[2015-04-27 15:48:17,422 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #57

[2015-04-27 15:48:17,427 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #58

[2015-04-27 15:48:17,433 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #59

[2015-04-27 15:48:17,435 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #60

[2015-04-27 15:48:17,444 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #61

[2015-04-27 15:48:17,451 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #62

[2015-04-27 15:48:17,453 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #63

[2015-04-27 15:48:17,456 risk job #281 - PROGRESS MainProcess/2364] **  Submitting task scenario #64

[2015-04-27 15:48:17,465 risk job #281 - PROGRESS MainProcess/2364] **  Sent 0M of data

[2015-04-27 15:48:17,465 risk job #281 - PROGRESS MainProcess/2364] **  spawned 64 tasks of kind scenario

Traceback (most recent call last):

  File "/usr/bin/oq-engine", line 9, in <module>

    load_entry_point('openquake.engine==1.2.1', 'console_scripts', 'oq-engine')()

  File "/usr/lib/python2.7/dist-packages/openquake/engine/bin/openquake_cli.py", line 480, in main

    hazard_calculation_id=args.hazard_calculation_id)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/engine.py", line 362, in run_job

    run_calc(job, log_level, log_file, exports)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/engine.py", line 179, in run_calc

    _do_run_calc(calculator, exports)

  File "/usr/lib/python2.7/contextlib.py", line 35, in __exit__

    self.gen.throw(type, value, traceback)

  File "/usr/lib/python2.7/dist-packages/openquake/engine/engine.py", line 116, in job_stats

    job.save()

  File "/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 460, in save

    self.save_base(using=using, force_insert=force_insert, force_update=force_update)

  File "/usr/lib/python2.7/dist-packages/django/db/models/base.py", line 522, in save_base

    manager.using(using).filter(pk=pk_val).exists())):

  File "/usr/lib/python2.7/dist-packages/django/db/models/query.py", line 512, in exists

    return self.query.has_results(using=self.db)

  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/query.py", line 424, in has_results

    return bool(compiler.execute_sql(SINGLE))

  File "/usr/lib/python2.7/dist-packages/django/db/models/sql/compiler.py", line 735, in execute_sql

    cursor.execute(sql, params)

  File "/usr/lib/python2.7/dist-packages/django/db/backends/postgresql_psycopg2/base.py", line 44, in execute

    return self.cursor.execute(query, args)

django.db.utils.DatabaseError: current transaction is aborted, commands ignored until end of transaction block

Thank you

[Michele Simionato]

On Monday, April 27, 2015 at 3:57:58 PM UTC+2, Karim Farokhnia wrote:

Dear Michele,

Thank you for your help. Here is what I get after running the risk computation with the --no-distribute option; (again both hazard and risk calculation are copied). Do you see where the error come from?

No. If you need more help you must send us the input files you are using (all of them). 

[Karim Farokhnia]

Thanks, Michele. That would be a great help. Which email address should I send the files to?

[Michele Simionato]

in...@openquake.org

[Karim Farokhnia]

Dear Michele,

I sent all the files to the email address you mentioned. I appreciate your time in advance.

Best,

[Michele Simionato]

I cannot reproduce your error. Instead I get a different error which is easy to fix. Your job_risk.ini file has a line

time_event = night

but in your exposure the time event is spelled "Night" (capital "N").

After setting

time_event = Night

it works for me.

[Karim Farokhnia]

Thanks, Michele! That was a great help. I did the same, and now it works.

Best