| Server IP : 185.86.78.101 / Your IP : 216.73.216.213 Web Server : Apache System : Linux 675867-vds-valikoshka1996.gmhost.pp.ua 5.4.0-150-generic #167-Ubuntu SMP Mon May 15 17:35:05 UTC 2023 x86_64 User : www ( 1000) PHP Version : 7.4.33 Disable Function : passthru,exec,system,putenv,chroot,chgrp,chown,shell_exec,popen,proc_open,pcntl_exec,ini_alter,ini_restore,dl,openlog,syslog,readlink,symlink,popepassthru,pcntl_alarm,pcntl_fork,pcntl_waitpid,pcntl_wait,pcntl_wifexited,pcntl_wifstopped,pcntl_wifsignaled,pcntl_wifcontinued,pcntl_wexitstatus,pcntl_wtermsig,pcntl_wstopsig,pcntl_signal,pcntl_signal_dispatch,pcntl_get_last_error,pcntl_strerror,pcntl_sigprocmask,pcntl_sigwaitinfo,pcntl_sigtimedwait,pcntl_exec,pcntl_getpriority,pcntl_setpriority,imap_open,apache_setenv MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : OFF | Sudo : ON | Pkexec : OFF Directory : /www/server/mysql/mysql-test/r/ |
Upload File : |
SET @old_debug= @@SESSION.debug; SET DEBUG='+d, se_error_replace_user_table_read'; CREATE USER 'foo'@'localhost' IDENTIFIED BY 'abcd'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_user_table_read'; SET DEBUG='+d, se_error_replace_user_table_add'; CREATE USER 'foo'@'localhost' IDENTIFIED BY 'abcd'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_user_table_add'; CREATE USER 'foo'@'localhost' IDENTIFIED BY 'abcd'; SET DEBUG='+d, se_error_replace_user_table_update'; ALTER USER 'foo'@'localhost' PASSWORD EXPIRE; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_user_table_update'; SET DEBUG='+d, se_error_replace_db_table_read'; GRANT SELECT ON mysql.* TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_db_table_read'; SET DEBUG='+d, se_error_replace_db_table_add'; GRANT SELECT ON mysql.* TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_db_table_add'; GRANT SELECT ON mysql.* TO 'foo'@'localhost'; SET DEBUG='+d, se_error_replace_db_table_update'; GRANT UPDATE ON mysql.* TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_db_table_update'; SET DEBUG='+d, se_error_replace_db_table_delete'; REVOKE SELECT, UPDATE ON mysql.* FROM 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_db_table_delete'; REVOKE SELECT, UPDATE ON mysql.* FROM 'foo'@'localhost'; CREATE USER 'bar'@'localhost'; SET DEBUG='+d, se_error_replace_proxies_priv_table_read'; GRANT PROXY ON 'foo'@'localhost' TO 'bar'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_proxies_priv_table_read'; SET DEBUG='+d, se_error_replace_proxies_priv_table_add'; GRANT PROXY ON 'foo'@'localhost' TO 'bar'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_proxies_priv_table_add'; GRANT PROXY ON 'foo'@'localhost' TO 'bar'@'localhost'; SET DEBUG='+d, se_error_replace_proxies_priv_table_update'; GRANT PROXY ON 'foo'@'localhost' TO 'bar'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_proxies_priv_table_update'; SET DEBUG='+d, se_error_replace_proxies_priv_table_delete'; REVOKE PROXY ON 'foo'@'localhost' FROM 'bar'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_proxies_priv_table_delete'; CREATE TABLE test.t1(c1 int, c2 int); SET DEBUG='+d, se_error_replace_column_table_read'; GRANT SELECT(c1) ON test.t1 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_read'; SET DEBUG='+d, se_error_replace_column_table_add'; GRANT SELECT(c1) ON test.t1 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_add'; GRANT SELECT(c1) ON test.t1 TO 'foo'@'localhost'; SET DEBUG='+d, se_error_replace_column_table_update'; GRANT UPDATE(c1) ON test.t1 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_update'; REVOKE UPDATE ON test.t1 FROM 'foo'@'localhost'; SET DEBUG='+d, se_error_replace_column_table_delete'; REVOKE SELECT(c1) ON test.t1 FROM 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_delete'; GRANT SELECT(c1), UPDATE(c1) ON test.t1 TO 'foo'@'localhost'; FLUSH PRIVILEGES; SET DEBUG='+d, se_error_replace_column_table_revoke_read'; REVOKE SELECT ON test.t1 FROM 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_revoke_read'; GRANT SELECT(c1) ON test.t1 TO 'foo'@'localhost'; FLUSH PRIVILEGES; SET DEBUG='+d, se_error_replace_column_table_revoke_update'; REVOKE UPDATE ON test.t1 FROM 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_revoke_update'; REVOKE UPDATE ON test.t1 FROM 'foo'@'localhost'; SET DEBUG='+d, se_error_replace_column_table_revoke_delete'; REVOKE SELECT ON test.t1 FROM 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_revoke_delete'; GRANT SELECT(c1) ON test.t1 TO 'foo'@'localhost'; SET DEBUG='+d, se_error_replace_column_table_revoke_read_next'; REVOKE SELECT ON test.t1 FROM 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_column_table_revoke_read_next'; DROP TABLE test.t1; CREATE TABLE test.t2(c1 int, c2 int); SET DEBUG='+d, se_error_replace_table_table_read'; GRANT SELECT ON test.t2 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_table_table_read'; SET DEBUG='+d, se_error_replace_table_table_add'; GRANT SELECT ON test.t2 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_table_table_add'; GRANT SELECT ON test.t2 TO 'foo'@'localhost'; SET DEBUG='+d, se_error_replace_table_table_update'; GRANT UPDATE ON test.t2 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_table_table_update'; DROP TABLE test.t2; CREATE PROCEDURE test.p1() SELECT 1; SET DEBUG='+d, se_error_replace_routine_table_read'; GRANT EXECUTE ON PROCEDURE test.p1 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_routine_table_read'; SET DEBUG='+d, se_error_replace_routine_table_add'; GRANT EXECUTE ON PROCEDURE test.p1 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_routine_table_add'; GRANT EXECUTE ON PROCEDURE test.p1 TO 'foo'@'localhost'; SET DEBUG='+d, se_error_replace_routine_table_update'; GRANT ALTER ROUTINE ON PROCEDURE test.p1 TO 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_routine_table_update'; SET DEBUG='+d, se_error_replace_routine_table_delete'; REVOKE ALL PRIVILEGES ON PROCEDURE test.p1 FROM 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_replace_routine_table_delete'; SET DEBUG='+d, se_error_modify_grant_table_update'; RENAME USER 'foo'@'localhost' TO 'foo_new'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_modify_grant_table_update'; SET DEBUG='+d, se_error_handle_grant_table_read'; RENAME USER 'foo'@'localhost' TO 'foo_new'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_handle_grant_table_read'; SET DEBUG='+d, se_error_handle_grant_table_rnd_read'; RENAME USER 'foo'@'localhost' TO 'foo_new'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_handle_grant_table_rnd_read'; SET DEBUG='+d, se_error_modify_grant_table_delete'; DROP USER 'foo'@'localhost'; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_modify_grant_table_delete'; DROP PROCEDURE test.p1; DROP USER 'foo'@'localhost'; CREATE TABLE t1(a INT); CREATE USER 'foo'@'localhost'; GRANT UPDATE (a) ON t1 TO 'foo'@'localhost'; SET DEBUG='+d, se_error_grant_table_init_read'; FLUSH PRIVILEGES; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_grant_table_init_read'; SET DEBUG='+d, se_error_grant_table_init_read_next'; FLUSH PRIVILEGES; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_grant_table_init_read_next'; CREATE PROCEDURE p() SET @x = 1; GRANT EXECUTE ON PROCEDURE p TO 'foo'@'localhost'; SET DEBUG='+d, se_error_grant_load_read'; FLUSH PRIVILEGES; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_grant_load_read'; SET DEBUG='+d, se_error_grant_load_read_next'; FLUSH PRIVILEGES; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_grant_load_read_next'; SET DEBUG='+d, se_error_grant_load_procs_read'; FLUSH PRIVILEGES; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_grant_load_procs_read'; SET DEBUG='+d, se_error_grant_load_procs_read_next'; FLUSH PRIVILEGES; ERROR HY000: Lock wait timeout exceeded; try restarting transaction SET DEBUG='-d, se_error_grant_load_procs_read_next'; DROP USER 'foo'@'localhost'; DROP TABLE t1; DROP PROCEDURE p; SET DEBUG= @old_global_debug; DROP USER 'bar'@'localhost';