[MCOL-4207] Cross storage engine replication innodb - ColumnStore Created: 2020-07-23 Updated: 2021-01-14 Resolved: 2021-01-14 |
|
| Status: | Closed |
| Project: | MariaDB ColumnStore |
| Component/s: | MariaDB Server |
| Affects Version/s: | 1.5.2 |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Minor |
| Reporter: | Matias Sanchez | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 1 |
| Labels: | None | ||
| Environment: |
Ubuntu 18.04 with single cluster columnstore |
||
| Description |
|
Hi !! We're on process of implementing an cross storage engine native replication between Innodb and Columnstore having source database as Mariadb Server 10.5.4 and target database as Mariadb Server 10.5.4 with Columnstore storage engine plugin 1.5.2, these are latests release on both products. In the process we adapt tables syntax and import data on target columnstore with cpimport, but once the replication is configured in this cross-storage engine manner, it works correctly for a little while but eventually gets crashed with following errors: ............. _ To report this bug, see https://mariadb.com/kb/en/reporting-bugs We will try our best to scrape up some info that will hopefully help Server version: 10.5.4-MariaDB-1:10.5.4+maria~bionic-log Thread pointer: 0x7f00700008e8 After this happens, MariaDB target replication tries crash recovery intermittently always with the same error and can't recover anymore. Thanks you so much in advance. |
| Comments |
| Comment by Todd Stoffel (Inactive) [ 2020-07-27 ] | |
|
matias.sanchez@avature.net Can you please post the output of:
And compare that to the documentation here: https://mariadb.com/docs/deploy/enterprise-htap/#configuring-mariadb | |
| Comment by Matias Sanchez [ 2020-07-27 ] | |
|
Hi Todd, thanks you for your fast reply, I was able to set replication strictly with binlog_format=STATEMENT as until now ROW format it's not supported as it's detailed on forwarded documentation, so this issue may be closed. I have opened another issue for this as I could imagine it's a different problem https://jira.mariadb.org/browse/MCOL-4215 any recommendation for tuning replication for this Hybrid Transactional/Analytical Processing (HTAP) solution? |