Comments (7)
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 INTOflexviews
.mvlog_cfc464d29e4659bfed08e3402c65c745
VALUES (-1, @fv_uow_id, 1,17,'node','share',0,2272885,2272914,'und',0,'000000001.000000000.000000000')
COULD NOT EXEC SQL:
INSERT INTOflexviews
.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 | |
+------------------------------+------------------+------+-----+---------+-------+
from swanhart-tools.
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 [email protected] 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 INTOflexviews
.mvlog_cfc464d29e4659bfed08e3402c65c745
VALUES (-1, @fv_uow_id, 1,17,'node','share',0,2272885,2272914,'und',0,'000000001.000000000.000000000')
COULD NOT EXEC SQL:
INSERT INTOflexviews
.mvlog_cfc464d29e4659bfed08e3402c65c745
VALUES
Incorrect decimal value: '000000001.000000000.000000000' for column 'field_share_difficulty_value' at row 1Here'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.
from swanhart-tools.
Just stumbled across the very same bug... I'm actually in the middle of a 5.7 upgrade right now.
Thanks!
from swanhart-tools.
Okay, so, got past that error, but flexviews_mview_signal is still empty despite the consumer running fine. Suggestions?
from swanhart-tools.
I think you were having timestamp issues and reported that separately.
from swanhart-tools.
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.
from swanhart-tools.
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 [email protected]
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)
.
from swanhart-tools.
Related Issues (20)
- [fv-request] Procedure to materialize system tables HOT 1
- Refreshing w/ Group By seems to cause problems HOT 1
- Installing on MySQL 5.7 (fresh ubuntu lts 16.04 server) HOT 2
- Row updates not getting inserted into flexviews tables. HOT 12
- Shard-Query: sq_helper procedure doesn't work HOT 11
- Flexviews stores database passwords in config file, any alternative? HOT 10
- shardquery.com Not Available HOT 1
- Potential Misconfiguration HOT 1
- expected behavior on consumer_safe.sh being restarted HOT 1
- Unexpected results refreshing views without aggregation
- Help with installation for MariaDB
- Table 'flexviews.mvlogs' doesn't exist
- COMPLETE refresh bugs? enable(), disable(), add_expr() does not work properly HOT 1
- gtid_mode ON, insert transactions of table mvlog_987afa1acfd5a2aae3d2c567091e09dd failed to commit HOT 1
- unrecognized MySQL version '10.3.12-MariaDB-log'." HOT 3
- COMPUTE dies after inserting rows with dml_type 1 (so before inserting -1) HOT 2
- shardquery.com no longer exists HOT 1
- Seeing this in flexviews error logs `Unknown column 'INF' in 'field list'` HOT 4
- Two identical Flexviews setups, but I'm seeing different `dml_type` values? HOT 6
- FlexCDC does not work with MariaDB 10.4+
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from swanhart-tools.