- discuss - lists.mariadb.org

[Maria-discuss] replication failing to recover due to HA_ERR_KEY_NOT_FOUND
by bbnlaccts acnts 16 Aug '16

16 Aug '16

Hi, I am trying to set up a master slave replication between 2 servers running mariadb 10 on centos 6.7 In the initial setup itself i keep getting HA_ERR_KEY_NOT_FOUND. I have tried all methodology based on my novice knowledge ro rectify but in vain. i am new to this env. Any help will be greatly appreciated. - Server version 10.0.23-MariaDB-log - Protocol version 10 - UNIX socket /var/lib/mysql/mysql.sock. The scenario I have followed is this: 1. Shut the prod (mc1), took a cold backup and restored on slave (mc2). 2. On master ran show master status; prodarchivedlogs-bin.000001 and the pos as 582240 3. Set these info in slave. 4. Started the slave, it started throwing up error: 160812 3:31:50 [ERROR] Slave SQL: Could not execute Update_rows_v1 event on table radius1.radacct; Can't find record in 'radacct', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log prodarchivedlogs-bin.000001, end_log_pos 587695, Gtid 0-1-79, Internal MariaDB error code: 1032 160812 3:17:18 [Warning] Slave: Can't find record in 'radacct' Error_code: 1032 160812 3:17:18 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'prodarchivedlogs-bin.000001' position 587072 I have tried all methods based on my knowledge, but it is just not functioning. I tried using mysqlbinlog tool to extract to a file and then tried inserting, even then it is failing. Any help will be greatly appreciated. The prod my.cnf is as follows symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=1 The slave my.cnf is as follows skip-name-resolve skip-slave-start datadir=/var/lib/mysql/data1 socket=/var/lib/mysql/mysql.sockuser=mysql symbolic-links=0 innodb_buffer_pool_size=10G innodb_data_home_dir= /var/lib/mysql/data2 innodb_data_file_path=ibdata1:10M:autoextend innodb_log_group_home_dir = /var/lib/mysql/redologs innodb_log_file_size = 256M innodb_buffer_pool_size = 10000M innodb_flush_method = O_DIRECT thread_stack = 256K max_connections=100000 expire_logs_days = 5 max_binlog_size = 100M log-bin=/backup/archivedlogs/prodarchivedlogs-bin binlog_format=row server-id=2

1 0

[Maria-discuss] New Question: ST_AsGeoJSON
by AskMonty KB 12 Aug '16

12 Aug '16

Hello, A new question has been asked in "Geographic Functions" by dbauszus. Please answer it at http://mariadb.com/kb/en/st_asgeojson/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Are there plans to implement ST_AsGeoJSON in MariaDB? This is by far the most widely use format to present data in web mapping applications. It will be a large overhead if we need to format records in the client prior to rendering the data on a web map. Best, Dennis -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/st_asgeojson/

1 0

[Maria-discuss] New Question: Percona XtraBackup Trigger Restore
by AskMonty KB 11 Aug '16

11 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore the triggers using percona xtrabackup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-trigger-restore/

1 0

[Maria-discuss] New Question: where can i download connector c which build with glibc2.11
by AskMonty KB 11 Aug '16

11 Aug '16

Hello, A new question has been asked in "MariaDB Connector/C" by shuianle. Please answer it at http://mariadb.com/kb/en/where-can-i-download-connector-c-which-build-with-… as the person asking the question may not be subscribed to the mailing list. -------------------------------- i download mariadb-connector-c-2.3.0-linux-x86_64.tar.gz, it need glibc2.14, but my os is suse11 sp1 with glibc2.11, so it not work. Our customer user mysql now， and we have program use mysql connector c。 In the further，our customer will use mariadb。 The os is suse11 sp1，glib version is 2.11。So the download of mariadb connector can't work. Where can I download ? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/where-can-i-download-connector-c-which-build-with-…

1 0

[Maria-discuss] Known limitation with TokuDB in Read Free Replication & parallel replication ?
by jocelyn fournier 10 Aug '16

10 Aug '16

Hi, After upgrading from TokuDB Enterprise with MariaDB 5.5 to MariaDB 10.1.14, I tried to enable the parallel replication (parallel_mode=optimistic, slave_parallel_threads=4) on a GTID enabled RFR slave, but it leads to random failures. (both master & slave are running 10.1.14) E.g : Could not execute Update_rows_v1 event on table sc_2.sc_param_index; Can't find record in 'sc_param_index', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.008418, end_log_pos 217608066 If I issue a start slave (with sql_slave_skip_counter=0) : Could not execute Update_rows_v1 event on table sc_2.sc_log_cron; Can't find record in 'sc_log_cron', Error_code: 1032; handler error HA_ERR_KEY_NOT_FOUND; the event's master log mysql-bin.008418, end_log_pos 218275984 If I put back slave_parallel_threads to 0, the slave keeps replicating happily without any issue. Is this a known limitation with TokuDB ? Tokudb configuration : tokudb_rpl_lookup_rows=0 tokudb_rpl_unique_checks=0 tokudb_pk_insert_mode=2 tokudb_directio = 1 Thanks and regards, Jocelyn Fournier

3 18

[Maria-discuss] MariaDB 5.5.51, Connector/J 1.5.0, & Connector/C 2.3.1 now available
by Daniel Bartholomew 10 Aug '16

10 Aug '16

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.51 Stable (GA), MariaDB Connector/J 1.5.0 Release Candidate (RC), and MariaDB Connector/C 2.3.1 Stable (GA). See the Release Notes and Changelogs for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.51 Stable (GA) - Release Notes: https://mariadb.com/kb/en/mdb-5551-rn/ - Changelog: https://mariadb.com/kb/en/mdb-5551-cl/ - Downloads: https://downloads.mariadb.org/mariadb/5.5.51 About MariaDB 5.5: - https://mariadb.com/kb/en/what-is-mariadb-55/ APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ MariaDB Connector/J 1.5.0 RC - Release Notes: https://mariadb.com/kb/en/mcj-150-rn/ - Changelog: https://mariadb.com/kb/en/mcj-150-cl/ - Downloads: https://downloads.mariadb.org/connector-java/1.5.0/ About MariaDB Connector/J: - https://mariadb.com/kb/en/about-mariadb-connector-j/ MariaDB Connector/C 2.3.1 - Release Notes: https://mariadb.com/kb/en/mcc-231-rn/ - Changelog: https://mariadb.com/kb/en/mcc-231-cl/ - Downloads: https://downloads.mariadb.org/connector-c/2.3.1/ About MariaDB Connector/C: - https://mariadb.com/kb/en/about-mariadb-connector-c/ - - MariaDB Webinars - - - - - - - - - - - - - - - - - - - - - - - - - There are several upcoming MariaDB-focused webinars and many previously held ones available to watch on an on-demand basis at: - https://mariadb.com/news-events/webinars - - MariaDB Books - - - - - - - - - - - - - - - - - - - - - - - - - - There is an ever-growing library of MariaDB books available to help you get the most out of MariaDB. See the MariaDB Books page for details and links: - https://mariadb.com/kb/en/mariadb/books/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf or my.ini file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to the MariaDB Foundation, please see the "contributing" and "donations" pages. We also have merchandise available in a cafepress store. All proceeds go to support the MariaDB Foundation. - https://mariadb.com/kb/en/contributing - https://mariadb.org/donate/ We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Percona XtraBackup restore
by AskMonty KB 09 Aug '16

09 Aug '16

Hello, A new question has been asked in "MariaDB FAQ" by palash.harchandani93_43595. Please answer it at http://mariadb.com/kb/en/percona-xtrabackup-restore/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- How do i restore a single database from a full backup or from a single database backup?? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/percona-xtrabackup-restore/

1 0

[Maria-discuss] Help on ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
by Karthick Subramanian 07 Aug '16

07 Aug '16

Dear Experts, I almost tried all sort of combinations that I think of very difficult to crack, but repeatedly failed to satisfy MariaDB not throw this error. Can anyone guide me on what is the specific needs for successful password. Warning message: +---------+------+----------------------------------------------------------------+ | Level | Code | Message | +---------+------+----------------------------------------------------------------+ | Warning | 1819 | cracklib: error loading dictionary | | Error | 1819 | Your password does not satisfy the current policy requirements | +---------+------+----------------------------------------------------------------+ Regards, Karth

2 2

[Maria-discuss] Discrepancy with innodb table statistics
by Mark Wadham 05 Aug '16

05 Aug '16

Can anyone explain this? http://pastebin.com/Zctaj8BE TL;DR index sizes seem to differ drastically in size depending on how you request them. Thanks, Mark

1 1

[Maria-discuss] New Question: 2 node replication failover/recovery
by AskMonty KB 03 Aug '16

03 Aug '16

Hello, A new question has been asked in "MariaDB Community" by greg_brownell_g. Please answer it at http://mariadb.com/kb/en/2-node-replication-failoverrecovery/ as the person asking the question may not be subscribed to the mailing list. -------------------------------- Is there a way to automate the following: 1. 2 node system set up as master-master replication 2. node 1, master 1 fails. 3. node 2 master 2 is now the active instance. Up to here, all works well. Replication is fast enough. We detect failure and code now uses master 2 on node 2. The problem is sync'ing master 1 when the node 1 restarts, perhaps 5 minutes later. Requirement is: 1. node 2 master 2 continues to run without interruption 2. node 1 master 1 must sync as quickly as possible with node 2 master 2 3. this must be done without human intervention (using scripts, programs, whatever) Thanks. -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/2-node-replication-failoverrecovery/

1 0