[MDEV-19469] Connection timeout before Authentication does not show up as an error Created: 2019-05-14  Updated: 2019-05-28

Status: Open
Project: MariaDB Server
Component/s: OTHER
Affects Version/s: 10.4.4
Fix Version/s: 10.4

Type: Bug Priority: Major
Reporter: Oleksandr Byelkin Assignee: Oleksandr Byelkin
Resolution: Unresolved Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-19277 Add status variable that gets increme... Closed
relates to MDEV-19282 Log more specific warning with log_wa... Closed

 Description   

Timed out connection shows that it was normal connection closed (error is lost)

flush status;
SHOW GLOBAL STATUS LIKE 'Aborted%';
 
SET @save_connect_timeout= @@connect_timeout;
SET GLOBAL connect_timeout=2;
SET GLOBAL log_warnings=2;
--let SEARCH_FILE=$MYSQLTEST_VARDIR/log/mysqld.1.err
--let SEARCH_PATTERN= unauthenticated
--source include/search_pattern_in_file.inc
--let SEARCH_PATTERN= This connection closed normally without authentication
--source include/search_pattern_in_file.inc
 
--perl
use Socket;
use autodie;
socket(SOCK, PF_INET, SOCK_STREAM, getprotobyname("tcp"));
connect(SOCK, pack_sockaddr_in($ENV{MASTER_MYPORT}, inet_aton("localhost")));
sleep 3;
exit(0);
EOF
 
SHOW GLOBAL STATUS LIKE 'Aborted%';
 
--let SEARCH_FILE=$MYSQLTEST_VARDIR/log/mysqld.1.err
--let SEARCH_PATTERN= unauthenticated
--source include/search_pattern_in_file.inc
--let SEARCH_PATTERN= This connection closed normally without authentication
--source include/search_pattern_in_file.inc
 
SET GLOBAL log_warnings=default;
SET GLOBAL connect_timeout= @save_connect_timeout;



 Comments   
Comment by Oleksandr Byelkin [ 2019-05-14 ]

wlad [14:13 Uhr]
MYSQL_SERVER_my_error(net->last_errno, MYF(0));
это не пишет в error log потому что во последнем параметере должен быть ME_ERROR_LOG flag
это про my_real_read()

wlad [14:21 Uhr]
там просто много чего произошло между vio_read() и vio_was_timeout(), который делает WSAGetLastError() == GetLastError().
этот GetLastError() надо бы сразу читать, иначе он пропадет
или же надо хранить этот last error в самой структуре vio

Generated at Thu Feb 08 08:51:56 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.