попробовали позавчера запустить в бой с управлением 3-я микротиками.
начали отпадать коннекты с микротиками и проблемы коннектов радиуса к БД.
лог mysqld
140108 14:35:33 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.28' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140210 6:59:09 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 6:59:09 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 6:59:09 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 6:59:09 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 6:59:09 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 6:59:09 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:03:35 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:03:35 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:07:25 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:07:25 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:07:25 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:07:25 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:07:25 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:07:25 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:19:16 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:19:16 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:28:01 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:28:01 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:30:14 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:30:14 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:31:26 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:31:26 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:32:47 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:32:47 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:32:47 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:32:47 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:33:33 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:33:33 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:36:47 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:36:47 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:37:07 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:37:07 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:39:56 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:39:56 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:39:56 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:39:56 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:40:42 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:40:42 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:40:42 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:40:42 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:07 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:07 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:07 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:07 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:07 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:07 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:37 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:37 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:37 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:48:37 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:56:19 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:56:19 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:56:19 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:56:19 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 7:59:15 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 7:59:15 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:00:52 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:00:52 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:00:52 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:00:52 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:00:52 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:00:52 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:03:06 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:03:06 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:03:06 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:03:06 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:04:02 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:04:02 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:04:02 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:04:02 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:04:02 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:04:02 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:04:35 [Note] /usr/local/libexec/mysqld: Normal shutdown
140210 8:04:35 [Note] Event Scheduler: Purging the queue. 0 events
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 33833 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 33832 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 33831 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 33830 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 33829 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 7 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 5 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 3 user: 'nodeny'
140210 8:04:37 [Warning] /usr/local/libexec/mysqld: Forcing close of thread 1 user: 'nodeny'
140210 8:04:38 InnoDB: Starting shutdown...
140210 8:04:41 InnoDB: Shutdown completed; log sequence number 186218651
140210 8:04:41 [Note] /usr/local/libexec/mysqld: Shutdown complete
140210 08:04:42 mysqld_safe mysqld from pid file /var/db/mysql/bill.xxx.com.ua.pid ended
140210 08:07:05 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
140210 8:07:06 InnoDB: The InnoDB memory heap is disabled
140210 8:07:06 InnoDB: Mutexes and rw_locks use GCC atomic builtins
140210 8:07:06 InnoDB: Compressed tables use zlib 1.2.7
140210 8:07:06 InnoDB: Initializing buffer pool, size = 128.0M
140210 8:07:06 InnoDB: Completed initialization of buffer pool
140210 8:07:06 InnoDB: highest supported file format is Barracuda.
140210 8:07:06 InnoDB: Waiting for the background threads to start
140210 8:07:07 InnoDB: 1.1.8 started; log sequence number 186218651
140210 8:07:07 [Note] Server hostname (bind-address): '0.0.0.0'; port: 3306
140210 8:07:07 [Note] - '0.0.0.0' resolves to '0.0.0.0';
140210 8:07:07 [Note] Server socket created on IP: '0.0.0.0'.
140210 8:07:08 [Warning] 'user' entry 'root@bill.xxx.com.ua' ignored in --skip-name-resolve mode.
140210 8:07:08 [Warning] 'user' entry '@bill.xxx.com.ua' ignored in --skip-name-resolve mode.
140210 8:07:08 [Warning] 'proxies_priv' entry '@ root@bill.xxx.com.ua' ignored in --skip-name-resolve mode.
140210 8:07:08 [Note] Event Scheduler: Loaded 0 events
140210 8:07:08 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.5.28' socket: '/tmp/mysql.sock' port: 3306 Source distribution
140210 8:07:23 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:23 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:23 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:23 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:23 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:23 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:28 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:28 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:28 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:28 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:48 [ERROR] /usr/local/libexec/mysqld: Deadlock found when trying to get lock; try restarting transaction
140210 8:07:48 [ERROR] /usr/local/libexec/mysqld: Sort aborted: Deadlock found when trying to get lock; try restarting transaction
лог radiusd
Mon Feb 10 06:55:09 2014 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #4
Mon Feb 10 06:55:09 2014 : Info: rlm_sql_mysql: Starting connect to MySQL server for #4
Mon Feb 10 06:55:09 2014 : Info: rlm_sql (sql): Connected new DB handle, #4
Mon Feb 10 06:55:17 2014 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #2
Mon Feb 10 06:55:17 2014 : Info: rlm_sql_mysql: Starting connect to MySQL server for #2
Mon Feb 10 06:55:17 2014 : Info: rlm_sql (sql): Connected new DB handle, #2
Mon Feb 10 06:55:21 2014 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #0
Mon Feb 10 06:55:21 2014 : Info: rlm_sql_mysql: Starting connect to MySQL server for #0
Mon Feb 10 06:55:21 2014 : Info: rlm_sql (sql): Connected new DB handle, #0
Mon Feb 10 06:55:22 2014 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #3
Mon Feb 10 06:55:22 2014 : Info: rlm_sql_mysql: Starting connect to MySQL server for #3
Mon Feb 10 06:55:22 2014 : Info: rlm_sql (sql): Connected new DB handle, #3
Mon Feb 10 06:55:32 2014 : Info: rlm_sql (sql): Attempting to connect rlm_sql_mysql #1
Mon Feb 10 06:55:32 2014 : Info: rlm_sql_mysql: Starting connect to MySQL server for #1
Mon Feb 10 06:55:32 2014 : Info: rlm_sql (sql): Connected new DB handle, #1
Mon Feb 10 06:56:50 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:56:59 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:57:00 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:57:19 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:57:20 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:57:32 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:57:54 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:57:59 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:58:19 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:58:39 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:58:44 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:58:57 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:59:05 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:59:09 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:59:09 2014 : Error: rlm_sql_getvpdata: database query error
Mon Feb 10 06:59:09 2014 : Error: [sql] SQL query error; rejecting user
Mon Feb 10 06:59:09 2014 : Error: rlm_sql_getvpdata: database query error
Mon Feb 10 06:59:09 2014 : Error: [sql] SQL query error; rejecting user
Mon Feb 10 06:59:09 2014 : Error: rlm_sql_getvpdata: database query error
Mon Feb 10 06:59:09 2014 : Error: [sql] SQL query error; rejecting user
Mon Feb 10 06:59:21 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:59:30 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:59:43 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:59:49 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 06:59:50 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 07:00:01 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 07:00:11 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 07:00:14 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 07:00:26 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 07:00:36 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
Mon Feb 10 07:00:43 2014 : Error: rlm_sql (sql): There are no DB handles to use! skipped 0, tried to connect 0
запущенные процессы
# ps ax | grep pl
1545 ?? Ss 183:23.70 /usr/local/bin/flow-capture -R /var/db/flows/netflow_8888.pl -p /var/run/flow-capture/flow-capture.pid -w /
1592 ?? Ss 0:29.40 /usr/local/bin/perl /usr/local/lib/webmin/miniserv.pl /usr/local/etc/webmin/miniserv.conf
1546 v0- S 10:06.02 /usr/bin/perl /usr/local/nodeny/nokernel.pl -d (perl5.14.4)
1547 v0- S 74:27.55 /usr/bin/perl /usr/local/nodeny/noserver.pl -d (perl5.14.4)
1548 v0- S 125:23.75 /usr/bin/perl /usr/local/nodeny/nokernel.pl -m=collectors -d (perl5.14.4)
1549 v0- S 61:02.55 /usr/bin/perl /usr/local/nodeny/nokernel.pl -m=cap -d (perl5.14.4)
1550 v0- S 98:11.36 /usr/bin/perl /usr/local/nodeny/noserver.pl -g=mikrotik_82.cfg.pm -d (perl5.14.4)
1551 v0- S 98:21.77 /usr/bin/perl /usr/local/nodeny/noserver.pl -g=mikrotik_84.cfg.pm -d (perl5.14.4)
1552 v0- S 253:03.35 /usr/bin/perl /usr/local/nodeny/noserver.pl -g=mikrotik_250.cfg.pm -d (perl5.14.4)
2115 0 RL+ 0:00.01 grep pl
Как я понял проблема с недоступностью таблиц на чтение из-за локов в связи с большим количеством запросов?
в конфиге my.cnf значение max_connections по умолчанию = 100
может ли это быть связано с увеличением параметра start_servers в конфиге radiusd.conf?
