Details
-
Type:
Monitor
-
Status: Closed
-
Priority:
Major
-
Resolution: Done
-
Affects Version/s: None
-
Fix Version/s: 2021
-
Component/s: FIWARE-TECH-HELP
-
Labels:
-
HD-Enabler:Cygnus
Description
Created question in FIWARE Q/A platform on 14-12-2015 at 11:12
Please, ANSWER this question AT https://stackoverflow.com/questions/34264298/cant-use-attr-persistence-column-on-mysql-sink
Question:
Can't use attr_persistence column on mysql sink
Description:
I'm trying to use the column type with OrionMySQLSink. My agent has this code:
cygnusagent.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.OrionMySQLSink
cygnusagent.sinks.mysql-sink.channel = mysql-channel
cygnusagent.sinks.mysql-sink.enable_grouping = false
cygnusagent.sinks.mysql-sink.mysql_host = localhost
cygnusagent.sinks.mysql-sink.mysql_port = 3306
cygnusagent.sinks.mysql-sink.mysql_username = ********
cygnusagent.sinks.mysql-sink.mysql_password = *********
cygnusagent.sinks.mysql-sink.table_type = table-by-destination
cygnusagent.sinks.mysql-sink.attr_persistence = column
cygnusagent.sinks.mysql-sink.batch_size = 1
cygnusagent.sinks.mysql-sink.batch_timeout = 10
I'm having this error when I use the sink:
2015-12-14 08:43:58,118 (SinkRunner-PollingRunner-DefaultSinkProcessor) [ERROR - com.telefonica.iot.cygnus.sinks.OrionSink.process(OrionSink.java:187)] Persistence error (Unknown database 'fiw-serv')
I don't have any problem with row mode, only with column mode.
Activity
| Transition | Time In Source Status | Execution Times | Last Executer | Last Execution Date | |||||
|---|---|---|---|---|---|---|---|---|---|
|
2h 54m | 1 | Backlog Manager | 22/May/17 6:10 PM | |||||
|
3h | 1 | Backlog Manager | 22/May/17 9:10 PM |
| Fix Version/s | 2021 [ 12600 ] |
| Assignee | Backlog Manager [ backlogmanager ] |
| HD-Enabler | Cygnus [ 11304 ] | |
| Description |
Created question in FIWARE Q/A platform on 14-12-2015 at 11:12 {color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/34264298/cant-use-attr-persistence-column-on-mysql-sink +Question:+ Can't use attr_persistence column on mysql sink +Description:+ I'm trying to use the column type with OrionMySQLSink. My agent has this code: cygnusagent.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.OrionMySQLSink cygnusagent.sinks.mysql-sink.channel = mysql-channel cygnusagent.sinks.mysql-sink.enable_grouping = false cygnusagent.sinks.mysql-sink.mysql_host = localhost cygnusagent.sinks.mysql-sink.mysql_port = 3306 cygnusagent.sinks.mysql-sink.mysql_username = ******** cygnusagent.sinks.mysql-sink.mysql_password = ********* cygnusagent.sinks.mysql-sink.table_type = table-by-destination cygnusagent.sinks.mysql-sink.attr_persistence = column cygnusagent.sinks.mysql-sink.batch_size = 1 cygnusagent.sinks.mysql-sink.batch_timeout = 10 I'm having this error when I use the sink: 2015-12-14 08:43:58,118 (SinkRunner-PollingRunner-DefaultSinkProcessor) [ERROR - com.telefonica.iot.cygnus.sinks.OrionSink.process(OrionSink.java:187)] Persistence error (Unknown database 'fiw-serv') I don't have any problem with row mode, only with column mode. |
Created question in FIWARE Q/A platform on 14-12-2015 at 11:12
{color: red}Please, ANSWER this question AT{color} https://stackoverflow.com/questions/34264298/cant-use-attr-persistence-column-on-mysql-sink +Question:+ Can't use attr_persistence column on mysql sink +Description:+ I'm trying to use the column type with OrionMySQLSink. My agent has this code: cygnusagent.sinks.mysql-sink.type = com.telefonica.iot.cygnus.sinks.OrionMySQLSink cygnusagent.sinks.mysql-sink.channel = mysql-channel cygnusagent.sinks.mysql-sink.enable_grouping = false cygnusagent.sinks.mysql-sink.mysql_host = localhost cygnusagent.sinks.mysql-sink.mysql_port = 3306 cygnusagent.sinks.mysql-sink.mysql_username = ******** cygnusagent.sinks.mysql-sink.mysql_password = ********* cygnusagent.sinks.mysql-sink.table_type = table-by-destination cygnusagent.sinks.mysql-sink.attr_persistence = column cygnusagent.sinks.mysql-sink.batch_size = 1 cygnusagent.sinks.mysql-sink.batch_timeout = 10 I'm having this error when I use the sink: 2015-12-14 08:43:58,118 (SinkRunner-PollingRunner-DefaultSinkProcessor) [ERROR - com.telefonica.iot.cygnus.sinks.OrionSink.process(OrionSink.java:187)] Persistence error (Unknown database 'fiw-serv') I don't have any problem with row mode, only with column mode. |
| Resolution | Done [ 10000 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
2017-05-22 18:11|UPDATED status: transition Answer| # answers= 1, accepted answer= True
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Field | Original Value | New Value |
|---|---|---|
| Component/s | FIWARE-TECH-HELP [ 10278 ] |
2017-05-22 15:17|CREATED monitor | # answers= 1, accepted answer= True
2017-05-22 21:11|UPDATED status: transition Finish| # answers= 1, accepted answer= True