ERROR: ERROR: SIGNAL ID NOT FOUND (FlexCDC consumer is likely behind)

[GuyPaddock]

I am able to set-up an incremental MV from a query just fine, but when I try to refresh it using:

call flexviews.refresh(flexviews.get_id('theredpool_drupal', 'mv_user_round_summary')); 

I get:

ERROR 1054 (42S22): Unknown column 'ERROR: ERROR: SIGNAL ID NOT FOUND (FlexCDC consumer is likely behind)' in 'field list'

Even though I have verified that consumer_safe.sh is running.

[GuyPaddock]

Looks like I had two issues:

1. The path to mysqlbinlog in the consumer.ini is the path to the mysqlbinlog program, not the path to the binary log itself. I corrected that one.

2. I'm now getting this error dumped to flexcdc.err:

   SQL_ERROR IN STATEMENT:
   INSERT INTO flexviews.mvlog_cfc464d29e4659bfed08e3402c65c745 VALUES (-1, @fv_uow_id, 1,17,'node','share',0,2272885,2272914,'und',0,'000000001.000000000.000000000')
   COULD NOT EXEC SQL:
   INSERT INTO flexviews.mvlog_cfc464d29e4659bfed08e3402c65c745 VALUES
   Incorrect decimal value: '000000001.000000000.000000000' for column 'field_share_difficulty_value' at row 1

Here's the table definition:

+------------------------------+------------------+------+-----+---------+-------+
| Field                        | Type             | Null | Key | Default | Extra |
+------------------------------+------------------+------+-----+---------+-------+
| dml_type                     | int(11)          | YES  |     | 0       |       |
| uow_id                       | bigint(20)       | YES  | MUL | NULL    |       |
| fv$server_id                 | int(10) unsigned | YES  |     | NULL    |       |
| fv$gsn                       | bigint(20)       | YES  |     | NULL    |       |
| entity_type                  | varchar(128)     | YES  |     | NULL    |       |
| bundle                       | varchar(128)     | YES  |     | NULL    |       |
| deleted                      | tinyint(4)       | YES  |     | NULL    |       |
| entity_id                    | int(10) unsigned | YES  |     | NULL    |       |
| revision_id                  | int(10) unsigned | YES  |     | NULL    |       |
| language                     | varchar(32)      | YES  |     | NULL    |       |
| delta                        | int(10) unsigned | YES  |     | NULL    |       |
| field_share_difficulty_value | decimal(32,10)   | YES  |     | NULL    |       |
+------------------------------+------------------+------+-----+---------+-------+

[greenlion]

Compile and use mysqlbinlog from MySQL 5.7. I can link to the bug I filed with MySQL. I have asked for back port of the fix to 5.6 but it hasn't happened yet.

You don't need the rest of 5.7, just mysqlbinlog. This is a bug in DECIMAL processing in mysqlbinlog.

Sent from my iPhone

On Nov 27, 2013, at 3:24 PM, Guy Paddock notifications@github.com wrote:

Looks like I had two issues:

The path to mysqlbinlog in the consumer.ini is the path to the mysqlbinlog program, not the path to the binary log itself. I corrected that one.

I'm now getting this error dumped to flexcdc.err:

SQL_ERROR IN STATEMENT:
INSERT INTO flexviews.mvlog_cfc464d29e4659bfed08e3402c65c745 VALUES (-1, @fv_uow_id, 1,17,'node','share',0,2272885,2272914,'und',0,'000000001.000000000.000000000')
COULD NOT EXEC SQL:
INSERT INTO flexviews.mvlog_cfc464d29e4659bfed08e3402c65c745 VALUES
Incorrect decimal value: '000000001.000000000.000000000' for column 'field_share_difficulty_value' at row 1

Here's the table definition:

+------------------------------+------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------------------------+------------------+------+-----+---------+-------+
| dml_type | int(11) | YES | | 0 | |
| uow_id | bigint(20) | YES | MUL | NULL | |
| fv$server_id | int(10) unsigned | YES | | NULL | |
| fv$gsn | bigint(20) | YES | | NULL | |
| entity_type | varchar(128) | YES | | NULL | |
| bundle | varchar(128) | YES | | NULL | |
| deleted | tinyint(4) | YES | | NULL | |
| entity_id | int(10) unsigned | YES | | NULL | |
| revision_id | int(10) unsigned | YES | | NULL | |
| language | varchar(32) | YES | | NULL | |
| delta | int(10) unsigned | YES | | NULL | |
| field_share_difficulty_value | decimal(32,10) | YES | | NULL | |
+------------------------------+------------------+------+-----+---------+-------+
—
Reply to this email directly or view it on GitHub.

[GuyPaddock]

Just stumbled across the very same bug... I'm actually in the middle of a 5.7 upgrade right now.

Thanks!

[GuyPaddock]

Okay, so, got past that error, but flexviews_mview_signal is still empty despite the consumer running fine. Suggestions?

[greenlion]

I think you were having timestamp issues and reported that separately.

[jamiejackson]

Is this the MySQL bug you mentioned, @greenlion? I'm guessing that this is what's giving me the same error (Error Code: 1644. ERROR: SIGNAL ID NOT FOUND (FlexCDC consumer is likely behind)) on MariaDB 5.5.44.

Hmm, never mind, I guess GuyPaddock's original issue (that corresponded to the title error) was due to an ini configuration problem. I'll play with that.

[greenlion]

Hi,

Yes, though there is a second error reported by someone else with a
slightly different but related problem. A modern 5.6 mysqlbinlog will fix
the problem, even if you are using mariadb. just get the binary tarball
and set mysqlbinlog=/path/to/5.6/mysqlbinlog in your consumer.ini. You
/may/ have to set Flexviews back up again. Just drop the flexviews
database and re-setup FlexCDC and Flexviews.

--justin

On Tue, Sep 8, 2015 at 9:08 AM, Jamie Jackson notifications@github.com
wrote:

Is this https://bugs.mysql.com/bug.php?id=65812 the MySQL bug you
mentioned, @greenlion https://github.com/greenlion? I'm guessing that
this is what's giving me the same error (Error Code: 1644. ERROR: SIGNAL
ID NOT FOUND (FlexCDC consumer is likely behind)) on MariaDB 5.5.44.

—
Reply to this email directly or view it on GitHub
#41 (comment)
.