Mailing List Archive

bayes and InnoDB read locks
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
Re: bayes and InnoDB read locks [ In reply to ]
Alex skrev den 2020-11-30 17:33:

> 2020-11-30 10:11:46 2772099 [Note] InnoDB: *** (2) WAITING FOR THIS
> LOCK TO BE GRANTED:

have you tryed do the bayes with AriaDB ?

note i am not expert at all