Skip to content

GitLab

  • Menu
Projects Groups Snippets
    • Loading...
  • Help
    • Help
    • Support
    • Community forum
    • Submit feedback
    • Contribute to GitLab
  • Sign in
  • E ew2openapi
  • Project information
    • Project information
    • Activity
    • Labels
    • Planning hierarchy
    • Members
  • Repository
    • Repository
    • Files
    • Commits
    • Branches
    • Tags
    • Contributors
    • Graph
    • Compare
  • Issues 1
    • Issues 1
    • List
    • Boards
    • Service Desk
    • Milestones
  • Merge requests 0
    • Merge requests 0
  • CI/CD
    • CI/CD
    • Pipelines
    • Jobs
    • Schedules
  • Deployments
    • Deployments
    • Environments
    • Releases
  • Monitor
    • Monitor
    • Incidents
  • Analytics
    • Analytics
    • Value stream
    • CI/CD
    • Repository
  • Wiki
    • Wiki
  • Activity
  • Graph
  • Create a new issue
  • Jobs
  • Commits
  • Issue Boards
Collapse sidebar
  • earthworm
  • ew2openapi
  • Issues
  • #33

Closed
Open
Created Jul 04, 2020 by Valentino Lauciani@valentino.laucianiMaintainer

Discrepanza tempo d'inserimento stesso evento tra "seisev" e "eventdb"

@matteo.quintiliani

con @raffaele.distefano ci siamo accorti di un problema tra il tempo d'inserimento di un evento in SeisEv e quello in EventDB (lo chiamo eventdb in quanto su HGP6 c'e' ancora quest'ultimo).

Come si vede dalle query sotto:

  • in eventdb l'evento e' stato creato (inserted) alle 2020-07-04 14:28:50
  • in seisev l'evento e' stato creato alle 2020-07-04 13:43:58

perché su eventdb c'e' un ritardo di 45min!?!?!? Potresti controllare i log con cui chiami l'API se tutto e' ok?

1) eventdb su hgp6

mysql>
mysql> SELECT * FROM event e JOIN provenance p ON e.fk_provenance=p.id WHERE e.id_locator=249499 AND p.instance='hew10_mole' \G
*************************** 1. row ***************************
             id: 22108430
     id_locator: 249499
    fk_pref_hyp: 67087982
    fk_pref_mag: 69368656
fk_events_group: 22108397
     type_group: 0
  fk_type_event: 1
  fk_provenance: 1778
       modified: 2020-07-04 14:32:55
       inserted: 2020-07-04 14:28:50
             id: 1778
           name: INST_INGV
       instance: hew10_mole
   softwarename: MOD_EQASSEMBLE
       username: ew
       hostname: hew10
    description: NULL
       priority: 0
       modified: 2019-02-12 14:44:55
       inserted: 2019-02-12 14:44:55
1 row in set (0.00 sec)

mysql>

2) seisev su hdbrm

mysql>
mysql> SELECT * FROM event e JOIN writer w ON e.fk_writer=w.id WHERE e.id_locator=249499 AND w.short LIKE 'hew10_mole%' \G
*************************** 1. row ***************************
             id: 24775461
    ingv_writer: NULL
     id_locator: 249499
 web_id_locator: 4024775461
        pro_civ: u
    fk_pref_hyp: NULL
fk_events_group: NULL
  fk_type_event: 1
      fk_writer: 1401
       modified: 2020-07-04 13:43:58
             id: 1401
          short: hew10_mole#MOD_EQASSEMBLE
           name: Sistema Automatico Earthworm-10
       modified: 2019-06-13 12:47:12
1 row in set (0.00 sec)

mysql>
mysql>```

Grazie.
Edited Jul 15, 2020 by Valentino Lauciani
Assignee
Assign to
Time tracking