-
Notifications
You must be signed in to change notification settings - Fork 1k
New issue
Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.
By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.
Already on GitHub? Sign in to your account
Quickstart instructions lead to error #62
Comments
hmmm. I haven't tested yet with mysql 5.6, but I've seen "Could not find first log file..." when the master is reset underneath maxwell: what's the output of both:
and
? |
+-------------------+----------+--------------+------------------+-------------------+
| server_id | binlog_file | binlog_position | |
nope, the master position pointer is back behind where maxwell thinks it should be. try doing "DELETE from maxwell.positions" and restarting maxwell. |
My [mysqld] server-id = 1 Does it need to be a faithful replication of the quickstart guide for it to work? Also, I ran the GRANT commands but with user root, and am running the maxwell command with the user as root as well. When I ran it after issuing the delete command, maxwell ran with no issues, but when I tried to insert a row into the maxwell.test table (a table I created), the row inserted successfully, but nothing came up on maxwell's end. Is something fundamentally wrong with the setup? |
maxwell should be able to run as root just fine, but by default it doesn't output any modifications that happen inside the "maxwell" database. try inserting a row into a different database/table. I'm assuming you're running with the "stdout" producer? btw, you're the first non-zendesk user, so you're hitting lots of issues :) |
Wow! I'm honored...? :) I began looking into this when we wanted to replicate MySQL and found mypipe, but wanted the logs in JSON. Maxwell does seem to be working, but I can't figure out what the pattern is. So, I created a new database, m_test, and a new table
I then inserted a row:
Is this normal? I guess I'm having difficulty in understanding exactly what I'm supposed to be seeing. Also, those create statements don't look like JSON. Is that normal too? |
let me test under 5.6 and see if there's something there that's different. From the logs it certainly looks like maxwell is working (it's processing the schema from the replication stream just fine), but you should also be seeing JSON from your inserts. |
Sounds good. Thanks! 😄 Are the create statements supposed to be the way they are appearing, or should that be JSON (but is not showing up as that) too? |
nah, they're supposed to be that way. maxwell needs to consume the CREATE/ALTER statements for its own use, but it doesn't output them onto the kafka (or stdout) bus. So those are just log lines |
I see. Okay. Thanks for the awesome support so far! |
yeah, I can reproduce this easily: 5.6 doesn't seem to work at all! stay tuned.. |
Yay? |
I have a few issues to report with the 5.6 support. What is the best way to do this? |
go ahead & create issues. |
Latest version works. Will close this now. |
After following instructions to the letter in the quickstart, I get the following error when I run the bin/maxwell command:
Slave can not handle replication events with the checksum that master is configured to log..
After googling the error, one of the solutions was to turn of binlog_checksum, which I did. Once I did that, I get this:
Could not find first log file name in binary log index file.
I'm using MySQL 5.6 on Ubuntu. What could be going wrong?
The text was updated successfully, but these errors were encountered: