[Maria-discuss] The relay-log is not fluashed after the slave-relay-log.999999 showed
Hello, dear users. I am using MariaDB 10.0.14 at CentOS 6.5. And, as I mentioned at the title of this question, the relay-log is not flushed after the slave-relay-log.999999 showed when using "Salve_parallel_threads:10" setting. like showed blow. - binlog_format: ROW - Slave_parallel_threads:10 Everything are working fine except the "slave-relay-log.******" files continue to exist at the disk which will finally cause the disk full. If I change the value of Slave_parallel_threads setting from 10 to 0, the log will be flushed. Howevery "PK duplicate warning" error logs come next. Is there any setting should be used with Slave_parallel_threads setting? Any help will be great. Best regareds, - Jasung
Gmail <next1009@gmail.com> writes:
And, as I mentioned at the title of this question, the relay-log is not flushed after the slave-relay-log.999999 showed when using "Salve_parallel_threads:10" setting. like showed blow.
- binlog_format: ROW - Slave_parallel_threads:10
Everything are working fine except the "slave-relay-log.******" files continue to exist at the disk which will finally cause the disk full. If I change the value of Slave_parallel_threads setting from 10 to 0, the log will be flushed. Howevery "PK duplicate warning" error logs come next.
Ok, thanks for reporting this. It's probably a bug that parallel replication behaves differently from non-parallel. I'll try to look into it when I have time. I could imagine that there are more bugs lurking when the log counter overflows... I'm not sure this is well tested. I wonder what the "correct" behaviour is? Should it just continue with slave-relay-log.1000000 ? Thanks, - Kristian.
Hi, Kristian. Frist of all, thanks for your quick reply. I think what you mentioned is the right way to go. In other words, the slave-relay-log.****** files should be flushed as same as when using "Slave_parallel_threads:0" setting. If there is any progress, please let me know. Thank you again. Best regards, - Jasung 2015-01-05 오후 6:38에 Kristian Nielsen 이(가) 쓴 글:
Gmail <next1009@gmail.com> writes:
And, as I mentioned at the title of this question, the relay-log is not flushed after the slave-relay-log.999999 showed when using "Salve_parallel_threads:10" setting. like showed blow.
- binlog_format: ROW - Slave_parallel_threads:10
Everything are working fine except the "slave-relay-log.******" files continue to exist at the disk which will finally cause the disk full. If I change the value of Slave_parallel_threads setting from 10 to 0, the log will be flushed. Howevery "PK duplicate warning" error logs come next. Ok, thanks for reporting this. It's probably a bug that parallel replication behaves differently from non-parallel. I'll try to look into it when I have time.
I could imagine that there are more bugs lurking when the log counter overflows... I'm not sure this is well tested. I wonder what the "correct" behaviour is? Should it just continue with slave-relay-log.1000000 ?
Thanks,
- Kristian.
participants (2)
-
Gmail -
Kristian Nielsen