Hi, I recently set up a central database server to store bayes data for a handful of mail relays to query for bayes info. I've done this in the past and don't recall there being a problem with read locks, but hoped someone could explain why I'm now seeing errors/warnings like this when using sa-learn from one of the clients.
This is from the mariadb-error.log file on the database server. 2020-11-30 10:11:46 2772099 [Note] InnoDB: *** (2) WAITING FOR THIS LOCK TO BE GRANTED: RECORD LOCKS space id 13828 page no 935 n bits 480 index PRIMARY of table `bayes`.`bayes_token` trx id 477451935 lock_mode X locks rec but not gap waiting Record lock, heap no 9 PHYSICAL RECORD: n_fields 7; compact format; info bits 0 0: len 4; hex 80000004; asc ;; 1: len 5; hex 07839a4235; asc B5;; 2: len 6; hex 00001c755710; asc uW ;; 3: len 7; hex 17000002101943; asc C;; 4: len 4; hex 80000231; asc 1;; 5: len 4; hex 800052d2; asc R ;; 6: len 4; hex dfc519be; asc ;; 2020-11-30 10:11:46 2772099 [Note] InnoDB: *** WE ROLL BACK TRANSACTION (1) This is across a network connected with a 1Gb/s link. SA isn't installed on the database server so it would be difficult to do this on the local database server. Is there something more I should be doing to make this work properly? What more info can I provide to troubleshoot this? The database server is on modern hardware with 128GB of RAM. # cat /etc/my.cnf.d/my.cnf |grep ^inno innodb_data_home_dir = /var/lib/mysql innodb_defragment=1 innodb_file_per_table innodb_data_file_path = ibdata1:10M:autoextend:max:500M innodb_buffer_pool_size=60G innodb_log_file_size = 1G innodb_flush_log_at_trx_commit = 2 innodb_flush_method=O_DIRECT innodb_lock_wait_timeout = 50 innodb_buffer_pool_instances = 40 innodb_open_files=10000 innodb_log_buffer_size=64M innodb_page_cleaners=15 innodb_purge_threads=15 innodb_write_io_threads=64 innodb_read_io_threads=64 innodb_io_capacity=2100 innodb_lru_scan_depth=100 innodb_fast_shutdown=0 innodb_adaptive_max_sleep_delay=20000 innodb_flushing_avg_loops=5 innodb_print_all_deadlocks=ON innodb_flush_neighbors=0 innodb_buffer_pool_dump_pct=90 innodb_fill_factor=93 innodb_read_ahead_threshold=8 innodb_stats_sample_pages=32