What steps will reproduce the problem?
1. php ./setup_flexcdc.php --ini=consumer.ini
2. ./consumer_safe.sh --ini=consumer.ini &
3. php add_table.php --schema=bbb --table=aaa
4. flexview.create(...'INCREMENTAL')...flexview.enable()
5. The materialized view is created but I cannot refresh it -> ERROR 1054
(42S22): Unknown column 'ERROR: ERROR: SIGNAL ID NOT FOUND (FlexCDC consumer is
likely behind)' in 'field list'
What is the expected output? What do you see instead?
View refreshed
What version of the product are you using? On what operating system?
1.8.0
Please provide any additional information below.
Everything looks good, When I change my tables I can see the respective table
updated with the changes I made.
I know that this has something to do with the 'flexviews_mview_signal' being
empty. I also can see that the mvlogs table has an active row for
'flexviews_mview_signal'. Can you tell me how is this table populated so I can
try to debug this problem?
Also, I think I find an error in flexcdc.php line 141
if(!empty($settings['flexcdc']['only_database'])) should be
if(!empty($settings['flexcdc']['only_databases'])) right?
Thank you in advance for your help.
Original issue reported on code.google.com by joyce.wo...@gmail.com on 3 Aug 2013 at 7:15
Original issue reported on code.google.com by
joyce.wo...@gmail.comon 3 Aug 2013 at 7:15