| Server IP : 172.67.216.182 / Your IP : 162.158.106.125 Web Server : Apache System : Linux krdc-ubuntu-s-2vcpu-4gb-amd-blr1-01.localdomain 5.15.0-142-generic #152-Ubuntu SMP Mon May 19 10:54:31 UTC 2025 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 : ON Directory : /www/server/mysql/src/mysql-test/suite/perfschema/r/ |
Upload File : |
drop view if exists test.user_view; "Testing mysql_upgrade with VIEW performance_schema.user_view" create view test.user_view as select "Not supposed to be here"; use performance_schema; show tables like "user_view"; Tables_in_performance_schema (user_view) user_view mysql_upgrade: [ERROR] 1050: Table 'cond_instances' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_current' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_history' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_history_long' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_summary_by_instance' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_summary_by_host_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_summary_by_user_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_summary_by_account_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_summary_by_thread_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_waits_summary_global_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'file_instances' already exists mysql_upgrade: [ERROR] 1050: Table 'file_summary_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'file_summary_by_instance' already exists mysql_upgrade: [ERROR] 1050: Table 'socket_instances' already exists mysql_upgrade: [ERROR] 1050: Table 'socket_summary_by_instance' already exists mysql_upgrade: [ERROR] 1050: Table 'socket_summary_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'host_cache' already exists mysql_upgrade: [ERROR] 1050: Table 'mutex_instances' already exists mysql_upgrade: [ERROR] 1050: Table 'objects_summary_global_by_type' already exists mysql_upgrade: [ERROR] 1050: Table 'performance_timers' already exists mysql_upgrade: [ERROR] 1050: Table 'rwlock_instances' already exists mysql_upgrade: [ERROR] 1050: Table 'setup_actors' already exists mysql_upgrade: [ERROR] 1050: Table 'setup_consumers' already exists mysql_upgrade: [ERROR] 1050: Table 'setup_instruments' already exists mysql_upgrade: [ERROR] 1050: Table 'setup_objects' already exists mysql_upgrade: [ERROR] 1050: Table 'setup_timers' already exists mysql_upgrade: [ERROR] 1050: Table 'table_io_waits_summary_by_index_usage' already exists mysql_upgrade: [ERROR] 1050: Table 'table_io_waits_summary_by_table' already exists mysql_upgrade: [ERROR] 1050: Table 'table_lock_waits_summary_by_table' already exists mysql_upgrade: [ERROR] 1050: Table 'threads' already exists mysql_upgrade: [ERROR] 1050: Table 'processlist' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_current' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_history' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_history_long' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_summary_by_thread_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_summary_by_host_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_summary_by_user_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_summary_by_account_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_stages_summary_global_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_current' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_history' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_history_long' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_summary_by_thread_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_summary_by_host_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_summary_by_user_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_summary_by_account_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_summary_global_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_current' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_history' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_history_long' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_summary_by_thread_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_summary_by_host_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_summary_by_user_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_summary_by_account_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_transactions_summary_global_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'hosts' already exists mysql_upgrade: [ERROR] 1050: Table 'users' already exists mysql_upgrade: [ERROR] 1050: Table 'accounts' already exists mysql_upgrade: [ERROR] 1050: Table 'memory_summary_global_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'memory_summary_by_thread_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'memory_summary_by_account_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'memory_summary_by_host_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'memory_summary_by_user_by_event_name' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_summary_by_digest' already exists mysql_upgrade: [ERROR] 1050: Table 'events_statements_summary_by_program' already exists mysql_upgrade: [ERROR] 1050: Table 'prepared_statements_instances' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_connection_configuration' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_group_member_stats' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_group_members' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_connection_status' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_applier_configuration' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_applier_status' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_applier_status_by_coordinator' already exists mysql_upgrade: [ERROR] 1050: Table 'replication_applier_status_by_worker' already exists mysql_upgrade: [ERROR] 1050: Table 'session_connect_attrs' already exists mysql_upgrade: [ERROR] 1050: Table 'session_account_connect_attrs' already exists mysql_upgrade: [ERROR] 1050: Table 'table_handles' already exists mysql_upgrade: [ERROR] 1050: Table 'metadata_locks' already exists mysql_upgrade: [ERROR] 1050: Table 'user_variables_by_thread' already exists mysql_upgrade: [ERROR] 1050: Table 'variables_by_thread' already exists mysql_upgrade: [ERROR] 1050: Table 'global_variables' already exists mysql_upgrade: [ERROR] 1050: Table 'session_variables' already exists mysql_upgrade: [ERROR] 1050: Table 'status_by_thread' already exists mysql_upgrade: [ERROR] 1050: Table 'status_by_user' already exists mysql_upgrade: [ERROR] 1050: Table 'status_by_host' already exists mysql_upgrade: [ERROR] 1050: Table 'status_by_account' already exists mysql_upgrade: [ERROR] 1050: Table 'global_status' already exists mysql_upgrade: [ERROR] 1050: Table 'session_status' already exists mysql_upgrade: [ERROR] 1644: Unexpected content found in the performance_schema database. show tables like "user_view"; Tables_in_performance_schema (user_view) user_view use test; drop view test.user_view;