Details

    • Type: extRequest
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Fix Version/s: 2021
    • Component/s: None
    • Labels:
      None
    • HD-Enabler:
      Cygnus

      Description

      Dear Andrés,

      After updating the component, the error remains similar:

      18/05/29 14:06:36 INFO mortbay.log: Started SelectChannelConnector@0.0.0.0:8081
      18/05/29 14:06:42 INFO handlers.NGSIRestHandler: [NGSIRestHandler] Starting internal transaction (716624ec-09e3-48a7-a0b4-a0ba6d00ed09)
      18/05/29 14:06:42 INFO handlers.NGSIRestHandler: [NGSIRestHandler] Received data ({ "subscriptionId" : "5b0d5e72cb1aeaf960c0cfe5", "originator" : "localhost", "contextResponses" : [ { "contextElement" : { "type" : "Alert", "isPattern" : "false", "id" : "Alert1", "attributes" : [

      { "name" : "humidity", "type" : "double", "value" : "60.0" }

      ,

      { "name" : "temperature", "type" : "double", "value" : "18.0" }

      ] }, "statusCode" :

      { "code" : "200", "reasonPhrase" : "OK" }

      } ]})
      18/05/29 14:07:05 WARN interceptors.CygnusGroupingRules: No grouping rules have been read. Details: /usr/cygnus/conf/grouping_rules.conf (No such file or directory)
      18/05/29 14:07:05 INFO sinks.NGSIMySQLSink: [mysql-sink] Persisting data at NGSIMySQLSink. Database (hannover), Table (Messe_Alert1_Alert), Fields ((recvTimeTs,recvTime,fiwareServicePath,entityId,entityType,attrName,attrType,attrValue,attrMd)), Values (('1527602802737','2018-05-29T14:06:42.737','/Messe','Alert1','Alert','humidity','double','60.0','[]'),('1527602802737','2018-05-29T14:06:42.737','/Messe','Alert1','Alert','temperature','double','18.0','[]'))
      18/05/29 14:07:05 ERROR sinks.NGSISink: Persistence error. Message: SQLException, Could not create connection to database server., Stack trace: [com.telefonica.iot.cygnus.backends.mysql.MySQLBackendImpl$MySQLDriver.getConnection(MySQLBackendImpl.java:416), com.telefonica.iot.cygnus.backends.mysql.MySQLBackendImpl.createDatabase(MySQLBackendImpl.java:86), com.telefonica.iot.cygnus.sinks.NGSIMySQLSink.persistAggregation(NGSIMySQLSink.java:546), com.telefonica.iot.cygnus.sinks.NGSIMySQLSink.persistBatch(NGSIMySQLSink.java:200), com.telefonica.iot.cygnus.sinks.NGSISink.processNewBatches(NGSISink.java:523), com.telefonica.iot.cygnus.sinks.NGSISink.process(NGSISink.java:368), org.apache.flume.sink.DefaultSinkProcessor.process(DefaultSinkProcessor.java:68), org.apache.flume.SinkRunner$PollingRunner.run(SinkRunner.java:147), java.lang.Thread.run(Thread.java:748)]
      18/05/29 14:07:05 INFO sinks.NGSISink: Rollbacking (8391063a-6349-11e8-91c7-fa163eb3484f), 1 retries will be done
      18/05/29 14:07:10 INFO sinks.NGSIMySQLSink: [mysql-sink] Persisting data at NGSIMySQLSink. Database (hannover), Table (Messe_Alert1_Alert), Fields ((recvTimeTs,recvTime,fiwareServicePath,entityId,entityType,attrName,attrType,attrValue,attrMd)), Values (('1527602802737','2018-05-29T14:06:42.737','/Messe','Alert1','Alert','humidity','double','60.0','[]'),('1527602802737','2018-05-29T14:06:42.737','/Messe','Alert1','Alert','temperature','double','18.0','[]'))
      18/05/29 14:07:10 ERROR sinks.NGSISink: Persistence error. Message: SQLException, Could not create connection to database server., Stack trace: [com.telefonica.iot.cygnus.backends.mysql.MySQLBackendImpl$MySQLDriver.getConnection(MySQLBackendImpl.java:416), com.telefonica.iot.cygnus.backends.mysql.MySQLBackendImpl.createDatabase(MySQLBackendImpl.java:86), com.telefonica.iot.cygnus.sinks.NGSIMySQLSink.persistAggregation(NGSIMySQLSink.java:546), com.telefonica.iot.cygnus.sinks.NGSIMySQLSink.persistBatch(NGSIMySQLSink.java:200), com.telefonica.iot.cygnus.sinks.NGSISink.processRollbackedBatches(NGSISink.java:387), com.telefonica.iot.cygnus.sinks.NGSISink.process(NGSISink.java:370), org.apache.flume.sink.DefaultSinkProcessor.process(DefaultSinkProcessor.java:68), org.apache.flume.SinkRunner$PollingRunner.run(SinkRunner.java:147), java.lang.Thread.run(Thread.java:748)]

      Un saludo.

      This e-mail and the documents attached are confidential and intended solely for the addressee; it may also be privileged. If you receive this e-mail in error, please notify the sender immediately and destroy it.
      As its integrity cannot be secured on the Internet, the Atos group liability cannot be triggered for the message content. Although the sender endeavors to maintain a computer virus-free network, the sender does not warrant that this transmission is virus-free and will not be liable for any damages resulting from any virus transmitted.

      Este mensaje y los ficheros adjuntos pueden contener información confidencial destinada solamente a la(s) persona(s) mencionadas anteriormente y pueden estar protegidos por secreto profesional.
      Si usted recibe este correo electrónico por error, gracias por informar inmediatamente al remitente y destruir el mensaje.
      Al no estar asegurada la integridad de este mensaje sobre la red, Atos no se hace responsable por su contenido. Su contenido no constituye ningún compromiso para el grupo Atos, salvo ratificación escrita por ambas partes.
      Aunque se esfuerza al máximo por mantener su red libre de virus, el emisor no puede garantizar nada al respecto y no será responsable de cualesquiera daños que puedan resultar de una transmisión de virus.

      [Created via e-mail received from: "Hitado Simarro, Javier" <javier.hitadosimarro@atos.net>]

      1. mysql_agent.conf
        6 kB
        FW External User
      2. log.txt
        9 kB
        FW External User
      3. database.txt
        0.9 kB
        FW External User

        Activity

          People

          • Assignee:
            andres.munoza Andres Muñoz
            Reporter:
            fw.ext.user FW External User
          • Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved: