Jump to content

Source discussions, questions, answers


Recommended Posts

And can i ask you  sure if only i don't bother you if i have to portforward the p2p_ports or not,because i know i don't have to portforward them , only the channel/cores ports need to be forwarded, from my knowledge p2p_ports are accesed only internaly and acces from outsite the internal network should be block on them ,am I right?

Link to comment
Share on other sites

Hi guys,i promised i will be back with the confirmation if masodikbela's suggestion with game will work,today i finally have time to test the method  and guess what it really works ,it solved my problem,thank you very much masodikblea,but at first i get some connection refused i looked at my syserror  on channels and it seems like only problem was that i have to port forward some p2p_ports on external ip ,more precise channel99 port and core2_channel1 port ,i don't really know why i have to port forward these but that solved the problem with connection refused,so i have one question ,i follow your tutorial and replace both in strlcpy,and memcpy with my external ip and now i have to portforward those p2p_ports, what do i have to do to have more security on those p2p_ports?use pf ?or ipfw? and what rule i have to set to pass all outcoming or incoming packets,because i think i have to pass only out packet?

Link to comment
Share on other sites

  • Premium
On 2016. 01. 12. at 5:09 PM, alexandru1992 said:

Hi guys,i promised i will be back with the confirmation if masodikbela's suggestion with game will work,today i finally have time to test the method  and guess what it really works ,it solved my problem,thank you very much masodikblea,but at first i get some connection refused i looked at my syserror  on channels and it seems like only problem was that i have to port forward some p2p_ports on external ip ,more precise channel99 port and core2_channel1 port ,i don't really know why i have to port forward these but that solved the problem with connection refused,so i have one question ,i follow your tutorial and replace both in strlcpy,and memcpy with my external ip and now i have to portforward those p2p_ports, what do i have to do to have more security on those p2p_ports?use pf ?or ipfw? and what rule i have to set to pass all outcoming or incoming packets,because i think i have to pass only out packet?

Well on BSD you have to wait some minutes after starting the core to establish the local connection (IDK why...) In this time, you probably will see some connection refused "operation timed out" message (about 5-10 pcs), but don't panic! Just wait ~2 minutes, then try to connect. You don't have to portforward the p2p ports.

Edit:

Hmm... its quite interesting, for me I didn't have to portforward the p2p_ports, they was closed, and I got only operation timed out, as I mentioned it before.

The one and only UI programming guideline

Link to comment
Share on other sites

  • 1 month later...
  • Premium
6 hours ago, shishishi said:

does anyone know how to fix this? 

the server is working but this warning is so boring

24c6b145c1.PNG

d51fb7734d.PNG

 

Its not the best way, but if you build it in release mode (not debug) probably will solve the problem. Also if you use vs13 probably you won't get this problem. (Btw the best way would be debug the core properly to see what's causes this problem...)

Edited by Metin2 Dev
Core X - External 2 Internal
  • Dislove 1
  • Love 1

The one and only UI programming guideline

Link to comment
Share on other sites

40 minutes ago, masodikbela said:

Its not the best way, but if you build it in release mode (not debug) probably will solve the problem. Also if you use vs13 probably you won't get this problem. (Btw the best way would be debug the core properly to see what's causes this problem...)

if I build the source in release mode it gives me a lot of errors...

and if I convert the project in vs13 it gives me more and more errors

Link to comment
Share on other sites

  • 2 weeks later...

guys i followed sanchez's guide




*Trying to block OTHER GROUP MEMBER CAN PICKUP my items , if i am the owner, and if i have full inventory.

also i would like to add a syschat (unable to pickup other player items, this item belong to ---read the name of the owner of item i m trying to pick up -.. )
_______

 

Just replace this in char_item.cpp:

LPCHARACTER owner = funcFindOwnership.owner;

With this:

LPCHARACTER owner = funcFindOwnership.owner;

// Owner does not exist, so don't allow to run remaining codes.
if (!owner)
	return false;

The next line of the code will set me as owner of the item if the owner is currently nobody. And sure, it's nobody because no one is the owner of the item from my group.

 

 

 


but unfortunatly it didnt blocked the process

Link to comment
Share on other sites

  • 4 weeks later...
  • 2 months later...
  • 1 month later...
  • 7 months later...

Hello, how can I set a Weapon Costume to work only on a specific weapon.
For example : Let's say that I have a coloured level 1 sword (costume), how can I set this costume unequipable unless I equiped level 1 sword too. Anyone knows? 

Ps : If you didn't understand, but you want to help me, tell me and I'll explain it clearly.

Ps2: Sorry for my english mistakes. 

Link to comment
Share on other sites

  • 4 years later...
  • Silver

look at bool CHARACTER::EquipItem(LPITEM item, int iCandidateCell)

bool CHARACTER::EquipItem(LPITEM item, int iCandidateCell)

Then maybe something like that;

	if (item->GetVnum() == 1234 && GetWear(PART_WEAPON) != NULL) {
		if (GetWear(PART_WEAPON)->GetVnum() != 4321) {
			ChatPacket(CHAT_TYPE_INFO, "NOT_VNUM_4321_EQUIPPED"));
			return false;
		}
	}

I there are more, you can filter for type/subtype or do a array of vnum

Link to comment
Share on other sites

  • 1 year later...

Hello guys, after install the server its all works good and when i start the game i have too many connection refused. I dont know why. 

Can you help me guys? please

 

This is my mysql .err :

Spoiler

2022-09-21T12:02:25.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'.
2022-09-21T12:02:25.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2022-09-21T12:02:26.160290Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:02:26.162143Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 1726 ...
2022-09-21T12:02:26.165146Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:02:26.165165Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:02:26.165173Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:02:26.165180Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:02:26.165453Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:02:26.165536Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-21T12:02:26.166796Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:02:26.181937Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21T12:02:26.196146Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-21T12:02:26.205148Z 0 [Note] InnoDB: Creating tablespace and datafile system tables.
2022-09-21T12:02:26.209492Z 0 [Note] InnoDB: Tablespace and datafile system tables created.
2022-09-21T12:02:26.210718Z 0 [Warning] InnoDB: Upgrading redo log: 2*3072 pages, LSN=1600088
2022-09-21T12:02:26.314729Z 0 [Warning] InnoDB: Starting to delete and rewrite log files.
2022-09-21T12:02:26.315801Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2022-09-21T12:02:26.379245Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2022-09-21T12:02:26.441469Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-09-21T12:02:26.441537Z 0 [Warning] InnoDB: New log files created, LSN=1600088
2022-09-21T12:02:26.441732Z 0 [Note] InnoDB: Successfully reset 32 pre-5.7.2 rseg slots.
2022-09-21T12:02:26.441750Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-21T12:02:26.441787Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-21T12:02:26.458459Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-21T12:02:26.459221Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-21T12:02:26.459231Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-21T12:02:26.459505Z 0 [Note] InnoDB: Creating sys_virtual system tables.
2022-09-21T12:02:26.459917Z 0 [Note] InnoDB: sys_virtual table created
2022-09-21T12:02:26.460024Z 0 [Note] InnoDB: Waiting for purge to start
2022-09-21T12:02:26.513220Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 0
2022-09-21T12:02:26.513597Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-21T12:02:26.516282Z 0 [Warning] System table 'plugin' is expected to be transactional.
mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
2022-09-21T12:02:26.516659Z 0 [Warning] World-writable config file './auto.cnf' has been removed.

2022-09-21T12:02:26.516693Z 0 [Note] Salting uuid generator variables, current_pid: 1726, server_start_time: 1663761746, bytes_sent: 0, 
2022-09-21T12:02:26.516722Z 0 [Note] Generated uuid: '426ccd5e-39a5-11ed-827b-62520285d11e', server_start_time: 1663763472, bytes_sent: 921683968
2022-09-21T12:02:26.516733Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: 426ccd5e-39a5-11ed-827b-62520285d11e.
2022-09-21T12:02:26.517037Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2022-09-21T12:02:26.517189Z 0 [ERROR] InnoDB: Cannot open '/var/db/mysql/ib_buffer_pool' for reading: No such file or directory
2022-09-21T12:02:26.517368Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-09-21T12:02:27.505561Z 0 [Note] Auto generated SSL certificates are placed in data directory.
2022-09-21T12:02:27.505883Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:02:27.505892Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:02:27.506444Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-21T12:02:27.936190Z 0 [Note] Auto generated RSA key files are placed in data directory.
2022-09-21T12:02:27.937236Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-21T12:02:27.937273Z 0 [Note] IPv6 is available.
2022-09-21T12:02:27.937285Z 0 [Note]   - '::' resolves to '::';
2022-09-21T12:02:27.937307Z 0 [Note] Server socket created on IP: '::'.
2022-09-21T12:02:27.937329Z 0 [ERROR] Can't start server: Bind on TCP/IP port: Address already in use
2022-09-21T12:02:27.937335Z 0 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2022-09-21T12:02:27.937345Z 0 [ERROR] Aborting

2022-09-21T12:02:27.937360Z 0 [Note] Binlog end
2022-09-21T12:02:27.937396Z 0 [Note] Shutting down plugin 'ngram'
2022-09-21T12:02:27.937403Z 0 [Note] Shutting down plugin 'partition'
2022-09-21T12:02:27.937409Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-09-21T12:02:27.937416Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-09-21T12:02:27.937421Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-09-21T12:02:27.937465Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-09-21T12:02:27.937472Z 0 [Note] Shutting down plugin 'MyISAM'
2022-09-21T12:02:27.937484Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-09-21T12:02:27.937491Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-09-21T12:02:27.937497Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-09-21T12:02:27.937503Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-09-21T12:02:27.937509Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-09-21T12:02:27.937514Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-09-21T12:02:27.937520Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-09-21T12:02:27.937526Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-09-21T12:02:27.937532Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-09-21T12:02:27.937538Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-09-21T12:02:27.937543Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-09-21T12:02:27.937549Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-09-21T12:02:27.937555Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-09-21T12:02:27.937561Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-09-21T12:02:27.937567Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-09-21T12:02:27.937573Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-09-21T12:02:27.937578Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-09-21T12:02:27.937584Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-09-21T12:02:27.937590Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-09-21T12:02:27.937596Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-09-21T12:02:27.937602Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-09-21T12:02:27.937608Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-09-21T12:02:27.937615Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-09-21T12:02:27.937622Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-09-21T12:02:27.937628Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-09-21T12:02:27.937634Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-09-21T12:02:27.937639Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-09-21T12:02:27.937645Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-09-21T12:02:27.937651Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-09-21T12:02:27.937656Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-09-21T12:02:27.937662Z 0 [Note] Shutting down plugin 'InnoDB'
2022-09-21T12:02:27.937867Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-09-21T12:02:27.938048Z 0 [Note] InnoDB: Starting shutdown...
2022-09-21T12:02:28.044531Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2022-09-21T12:02:28.045018Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220921 14:02:28
2022-09-21T12:02:28.883439Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1603681
2022-09-21T12:02:28.884335Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-21T12:02:28.884350Z 0 [Note] Shutting down plugin 'MEMORY'
2022-09-21T12:02:28.884358Z 0 [Note] Shutting down plugin 'CSV'
2022-09-21T12:02:28.884365Z 0 [Note] Shutting down plugin 'sha256_password'
2022-09-21T12:02:28.884371Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-09-21T12:02:28.884489Z 0 [Note] Shutting down plugin 'binlog'
2022-09-21T12:02:28.884606Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

2022-09-21T12:02:28.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended
2022-09-21T12:04:50.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended
2022-09-21T12:05:29.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'.
2022-09-21T12:05:29.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2022-09-21T12:05:29.823654Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:05:29.826960Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 863 ...
2022-09-21T12:05:29.836557Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:05:29.836577Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:05:29.836584Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:05:29.836591Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:05:29.837305Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:05:29.838197Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-21T12:05:29.840019Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:05:29.856404Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21T12:05:29.877622Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-21T12:05:29.887885Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-21T12:05:29.887936Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-21T12:05:29.905221Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-21T12:05:29.906069Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-21T12:05:29.906084Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-21T12:05:29.906289Z 0 [Note] InnoDB: Waiting for purge to start
2022-09-21T12:05:29.959487Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 1603681
2022-09-21T12:05:29.959930Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2022-09-21T12:05:29.960184Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-21T12:05:29.960607Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:05:29
2022-09-21T12:05:29.964643Z 0 [Warning] System table 'plugin' is expected to be transactional.
2022-09-21T12:05:29.966271Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-09-21T12:05:29.970026Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-09-21T12:05:29.970037Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-09-21T12:05:29.970045Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:05:29.970052Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:05:29.971632Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-21T12:05:29.972105Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-09-21T12:05:29.973097Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-21T12:05:29.973134Z 0 [Note] IPv6 is available.
2022-09-21T12:05:29.973145Z 0 [Note]   - '::' resolves to '::';
2022-09-21T12:05:29.973164Z 0 [Note] Server socket created on IP: '::'.
2022-09-21T12:05:29.973791Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
2022-09-21T12:05:29.973876Z 0 [Warning] Failed to open optimizer cost constant tables

2022-09-21T12:05:29.977471Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2022-09-21T12:05:29.977480Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2022-09-21T12:05:29.977486Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2022-09-21T12:05:29.977492Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2022-09-21T12:05:29.977497Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2022-09-21T12:05:29.978865Z 0 [Warning] System table 'servers' is expected to be transactional.
2022-09-21T12:05:29.980479Z 0 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:05:29.980673Z 0 [ERROR] Column count of performance_schema.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:05:29.980872Z 0 [ERROR] Column count of performance_schema.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:05:29.980918Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:05:29.981298Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2022-09-21T12:05:29.981335Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:05:29.981362Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:05:29.981963Z 0 [ERROR] Column count of performance_schema.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:05:29.982180Z 0 [ERROR] Column count of performance_schema.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:05:29.982213Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2022-09-21T12:05:29.982409Z 0 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2022-09-21T12:05:29.982438Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2022-09-21T12:05:29.982860Z 0 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2022-09-21T12:05:29.982889Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2022-09-21T12:05:29.983293Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2022-09-21T12:05:29.983510Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2022-09-21T12:05:29.983535Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2022-09-21T12:05:29.983564Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2022-09-21T12:05:29.983741Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 3. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:05:29.983781Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2022-09-21T12:05:29.983804Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2022-09-21T12:05:29.983832Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2022-09-21T12:05:29.983856Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:05:29.983882Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:05:29.983905Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:05:29.983934Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:05:29.983960Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2022-09-21T12:05:29.983996Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2022-09-21T12:05:29.984019Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2022-09-21T12:05:29.984055Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2022-09-21T12:05:29.984082Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:05:29.984110Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:05:29.984138Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:05:29.984164Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:05:29.984194Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2022-09-21T12:05:29.984222Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2022-09-21T12:05:29.984245Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
2022-09-21T12:05:29.984273Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
2022-09-21T12:05:29.984298Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
2022-09-21T12:05:29.984323Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
2022-09-21T12:05:29.984346Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:05:29.984372Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:05:29.984395Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:05:29.984418Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:05:29.984445Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
2022-09-21T12:05:29.984470Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2022-09-21T12:05:29.984493Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2022-09-21T12:05:29.984520Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2022-09-21T12:05:29.984551Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2022-09-21T12:05:29.984576Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2022-09-21T12:05:29.984598Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2022-09-21T12:05:29.984622Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2022-09-21T12:05:29.984647Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2022-09-21T12:05:29.984673Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
2022-09-21T12:05:29.984695Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:05:29.984720Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:05:29.984743Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:05:29.984773Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:05:29.984801Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
2022-09-21T12:05:29.984823Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
2022-09-21T12:05:29.984848Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
2022-09-21T12:05:29.984870Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
2022-09-21T12:05:29.984895Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
2022-09-21T12:05:29.984932Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
2022-09-21T12:05:29.984957Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
2022-09-21T12:05:29.984983Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
2022-09-21T12:05:29.985005Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
2022-09-21T12:05:29.985032Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
2022-09-21T12:05:29.985058Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
2022-09-21T12:05:29.985084Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
2022-09-21T12:05:29.985114Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
2022-09-21T12:05:29.985136Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
2022-09-21T12:05:29.985158Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
2022-09-21T12:05:29.985188Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
2022-09-21T12:05:29.985212Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
2022-09-21T12:05:29.985234Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
2022-09-21T12:05:29.985260Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
2022-09-21T12:05:29.985283Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
2022-09-21T12:05:29.985311Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
2022-09-21T12:05:29.985386Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16).
2022-09-21T12:05:29.985426Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28
2022-09-21T12:05:29.985868Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2022-09-21T12:05:29.985968Z 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.7.38'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2022-09-21T12:06:44.147004Z 2 [Note] Access denied for user 'root'@'localhost' (using password: YES)
2022-09-21T12:07:53.267501Z 4 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2022-09-21T12:08:19.187639Z 5 [ERROR] /usr/local/libexec/mysqld: Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:08:38.562141Z 5 [ERROR] /usr/local/libexec/mysqld: Column count of mysql.user is wrong. Expected 45, found 42. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:09:05.460488Z 5 [Note] Aborted connection 5 to db: 'unconnected' user: 'root' host: 'localhost' (Got an error reading communication packets)
2022-09-21T12:09:06.892739Z 6 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2022-09-21T12:09:17.747755Z 0 [Note] Giving 0 client threads a chance to die gracefully
2022-09-21T12:09:17.747770Z 0 [Note] Shutting down slave threads
2022-09-21T12:09:17.748018Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-09-21T12:09:17.748178Z 0 [Note] Binlog end
2022-09-21T12:09:17.748378Z 0 [Note] Shutting down plugin 'ngram'
2022-09-21T12:09:17.748385Z 0 [Note] Shutting down plugin 'partition'
2022-09-21T12:09:17.748392Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-09-21T12:09:17.748398Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-09-21T12:09:17.748404Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-09-21T12:09:17.748433Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-09-21T12:09:17.748440Z 0 [Note] Shutting down plugin 'MyISAM'
2022-09-21T12:09:17.748451Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-09-21T12:09:17.748470Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-09-21T12:09:17.748476Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-09-21T12:09:17.748482Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-09-21T12:09:17.748488Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-09-21T12:09:17.748493Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-09-21T12:09:17.748499Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-09-21T12:09:17.748505Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-09-21T12:09:17.748511Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-09-21T12:09:17.748517Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-09-21T12:09:17.748523Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-09-21T12:09:17.748529Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-09-21T12:09:17.748534Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-09-21T12:09:17.748540Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-09-21T12:09:17.748546Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-09-21T12:09:17.748552Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-09-21T12:09:17.748558Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-09-21T12:09:17.748564Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-09-21T12:09:17.748570Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-09-21T12:09:17.748576Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-09-21T12:09:17.748581Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-09-21T12:09:17.748587Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-09-21T12:09:17.748593Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-09-21T12:09:17.748599Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-09-21T12:09:17.748605Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-09-21T12:09:17.748687Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-09-21T12:09:17.748694Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-09-21T12:09:17.748700Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-09-21T12:09:17.748705Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-09-21T12:09:17.748711Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-09-21T12:09:17.748717Z 0 [Note] Shutting down plugin 'InnoDB'
2022-09-21T12:09:17.748795Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-09-21T12:09:17.748949Z 0 [Note] InnoDB: Starting shutdown...
2022-09-21T12:09:17.855517Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2022-09-21T12:09:17.855790Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220921 14:09:17
2022-09-21T12:09:18.913650Z 0 [Note] InnoDB: Shutdown completed; log sequence number 1603709
2022-09-21T12:09:18.914447Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-21T12:09:18.914464Z 0 [Note] Shutting down plugin 'MEMORY'
2022-09-21T12:09:18.914472Z 0 [Note] Shutting down plugin 'CSV'
2022-09-21T12:09:18.914479Z 0 [Note] Shutting down plugin 'sha256_password'
2022-09-21T12:09:18.914485Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-09-21T12:09:18.914603Z 0 [Note] Shutting down plugin 'binlog'
2022-09-21T12:09:18.914808Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

2022-09-21T12:09:18.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended
2022-09-21T12:10:16.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'.
2022-09-21T12:10:16.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2022-09-21T12:10:16.904875Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:10:16.907645Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 1290 ...
2022-09-21T12:10:16.911148Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:10:16.911166Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:10:16.911173Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:10:16.911180Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:10:16.911448Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:10:16.911530Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-21T12:10:16.913706Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:10:16.930551Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21T12:10:16.945744Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-21T12:10:16.953877Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-21T12:10:16.953921Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-21T12:10:16.970432Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-21T12:10:16.971201Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-21T12:10:16.971219Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-21T12:10:16.971469Z 0 [Note] InnoDB: Waiting for purge to start
2022-09-21T12:10:17.024768Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 1603709
2022-09-21T12:10:17.025116Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-21T12:10:17.028447Z 0 [Warning] System table 'plugin' is expected to be transactional.
2022-09-21T12:10:17.028917Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2022-09-21T12:10:17.030368Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-09-21T12:10:17.030379Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-09-21T12:10:17.030386Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:10:17.030404Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:10:17.031091Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-21T12:10:17.031142Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-09-21T12:10:17.032142Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-21T12:10:17.032190Z 0 [Note] IPv6 is available.
2022-09-21T12:10:17.032205Z 0 [Note]   - '::' resolves to '::';
2022-09-21T12:10:17.032229Z 0 [Note] Server socket created on IP: '::'.
2022-09-21T12:10:17.032553Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2022-09-21T12:10:17.032915Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:10:17
2022-09-21T12:10:17.033628Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
2022-09-21T12:10:17.033737Z 0 [Warning] Failed to open optimizer cost constant tables

2022-09-21T12:10:17.034764Z 0 [Warning] System table 'time_zone_leap_second' is expected to be transactional.
2022-09-21T12:10:17.034775Z 0 [Warning] System table 'time_zone_name' is expected to be transactional.
2022-09-21T12:10:17.034780Z 0 [Warning] System table 'time_zone' is expected to be transactional.
2022-09-21T12:10:17.034786Z 0 [Warning] System table 'time_zone_transition_type' is expected to be transactional.
2022-09-21T12:10:17.034791Z 0 [Warning] System table 'time_zone_transition' is expected to be transactional.
2022-09-21T12:10:17.035317Z 0 [Warning] System table 'servers' is expected to be transactional.
2022-09-21T12:10:17.035632Z 0 [ERROR] Column count of performance_schema.events_waits_current is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:10:17.035703Z 0 [ERROR] Column count of performance_schema.events_waits_history is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:10:17.035775Z 0 [ERROR] Column count of performance_schema.events_waits_history_long is wrong. Expected 19, found 16. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:10:17.035807Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:10:17.035948Z 0 [ERROR] Incorrect definition of table performance_schema.events_waits_summary_by_thread_by_event_name: expected column 'THREAD_ID' at position 0 to have type bigint(20), found type int(11).
2022-09-21T12:10:17.035989Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:10:17.036034Z 0 [ERROR] Native table 'performance_schema'.'events_waits_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:10:17.036289Z 0 [ERROR] Column count of performance_schema.file_summary_by_event_name is wrong. Expected 23, found 5. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:10:17.036386Z 0 [ERROR] Column count of performance_schema.file_summary_by_instance is wrong. Expected 25, found 6. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:10:17.036419Z 0 [ERROR] Native table 'performance_schema'.'host_cache' has the wrong structure
2022-09-21T12:10:17.036487Z 0 [ERROR] Incorrect definition of table performance_schema.mutex_instances: expected column 'LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2022-09-21T12:10:17.036527Z 0 [ERROR] Native table 'performance_schema'.'objects_summary_global_by_type' has the wrong structure
2022-09-21T12:10:17.036649Z 0 [ERROR] Incorrect definition of table performance_schema.rwlock_instances: expected column 'WRITE_LOCKED_BY_THREAD_ID' at position 2 to have type bigint(20), found type int(11).
2022-09-21T12:10:17.036683Z 0 [ERROR] Native table 'performance_schema'.'setup_actors' has the wrong structure
2022-09-21T12:10:17.036823Z 0 [ERROR] Native table 'performance_schema'.'setup_objects' has the wrong structure
2022-09-21T12:10:17.036913Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_index_usage' has the wrong structure
2022-09-21T12:10:17.036935Z 0 [ERROR] Native table 'performance_schema'.'table_io_waits_summary_by_table' has the wrong structure
2022-09-21T12:10:17.036956Z 0 [ERROR] Native table 'performance_schema'.'table_lock_waits_summary_by_table' has the wrong structure
2022-09-21T12:10:17.037025Z 0 [ERROR] Column count of performance_schema.threads is wrong. Expected 17, found 3. Created with MySQL 50562, now running 50738. Please use mysql_upgrade to fix this error.
2022-09-21T12:10:17.037060Z 0 [ERROR] Native table 'performance_schema'.'events_stages_current' has the wrong structure
2022-09-21T12:10:17.037081Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history' has the wrong structure
2022-09-21T12:10:17.037108Z 0 [ERROR] Native table 'performance_schema'.'events_stages_history_long' has the wrong structure
2022-09-21T12:10:17.037129Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:10:17.037154Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:10:17.037175Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:10:17.037203Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:10:17.037227Z 0 [ERROR] Native table 'performance_schema'.'events_stages_summary_global_by_event_name' has the wrong structure
2022-09-21T12:10:17.037258Z 0 [ERROR] Native table 'performance_schema'.'events_statements_current' has the wrong structure
2022-09-21T12:10:17.037279Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history' has the wrong structure
2022-09-21T12:10:17.037302Z 0 [ERROR] Native table 'performance_schema'.'events_statements_history_long' has the wrong structure
2022-09-21T12:10:17.037327Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:10:17.037353Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:10:17.037379Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:10:17.037403Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:10:17.037425Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_global_by_event_name' has the wrong structure
2022-09-21T12:10:17.037450Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_digest' has the wrong structure
2022-09-21T12:10:17.037471Z 0 [ERROR] Native table 'performance_schema'.'events_statements_summary_by_program' has the wrong structure
2022-09-21T12:10:17.037498Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_current' has the wrong structure
2022-09-21T12:10:17.037521Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history' has the wrong structure
2022-09-21T12:10:17.037544Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_history_long' has the wrong structure
2022-09-21T12:10:17.037566Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:10:17.037591Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:10:17.037612Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:10:17.037640Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:10:17.037667Z 0 [ERROR] Native table 'performance_schema'.'events_transactions_summary_global_by_event_name' has the wrong structure
2022-09-21T12:10:17.037690Z 0 [ERROR] Native table 'performance_schema'.'users' has the wrong structure
2022-09-21T12:10:17.037712Z 0 [ERROR] Native table 'performance_schema'.'accounts' has the wrong structure
2022-09-21T12:10:17.037732Z 0 [ERROR] Native table 'performance_schema'.'hosts' has the wrong structure
2022-09-21T12:10:17.037759Z 0 [ERROR] Native table 'performance_schema'.'socket_instances' has the wrong structure
2022-09-21T12:10:17.037782Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_instance' has the wrong structure
2022-09-21T12:10:17.037803Z 0 [ERROR] Native table 'performance_schema'.'socket_summary_by_event_name' has the wrong structure
2022-09-21T12:10:17.037827Z 0 [ERROR] Native table 'performance_schema'.'session_connect_attrs' has the wrong structure
2022-09-21T12:10:17.037850Z 0 [ERROR] Native table 'performance_schema'.'session_account_connect_attrs' has the wrong structure
2022-09-21T12:10:17.037874Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_global_by_event_name' has the wrong structure
2022-09-21T12:10:17.037895Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_account_by_event_name' has the wrong structure
2022-09-21T12:10:17.037919Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_host_by_event_name' has the wrong structure
2022-09-21T12:10:17.037942Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_thread_by_event_name' has the wrong structure
2022-09-21T12:10:17.037994Z 0 [ERROR] Native table 'performance_schema'.'memory_summary_by_user_by_event_name' has the wrong structure
2022-09-21T12:10:17.038032Z 0 [ERROR] Native table 'performance_schema'.'table_handles' has the wrong structure
2022-09-21T12:10:17.038060Z 0 [ERROR] Native table 'performance_schema'.'metadata_locks' has the wrong structure
2022-09-21T12:10:17.038088Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_configuration' has the wrong structure
2022-09-21T12:10:17.038108Z 0 [ERROR] Native table 'performance_schema'.'replication_group_members' has the wrong structure
2022-09-21T12:10:17.038131Z 0 [ERROR] Native table 'performance_schema'.'replication_connection_status' has the wrong structure
2022-09-21T12:10:17.038157Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_configuration' has the wrong structure
2022-09-21T12:10:17.038179Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status' has the wrong structure
2022-09-21T12:10:17.038203Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_coordinator' has the wrong structure
2022-09-21T12:10:17.038224Z 0 [ERROR] Native table 'performance_schema'.'replication_applier_status_by_worker' has the wrong structure
2022-09-21T12:10:17.038246Z 0 [ERROR] Native table 'performance_schema'.'replication_group_member_stats' has the wrong structure
2022-09-21T12:10:17.038269Z 0 [ERROR] Native table 'performance_schema'.'prepared_statements_instances' has the wrong structure
2022-09-21T12:10:17.038290Z 0 [ERROR] Native table 'performance_schema'.'user_variables_by_thread' has the wrong structure
2022-09-21T12:10:17.038317Z 0 [ERROR] Native table 'performance_schema'.'status_by_account' has the wrong structure
2022-09-21T12:10:17.038337Z 0 [ERROR] Native table 'performance_schema'.'status_by_host' has the wrong structure
2022-09-21T12:10:17.038357Z 0 [ERROR] Native table 'performance_schema'.'status_by_thread' has the wrong structure
2022-09-21T12:10:17.038388Z 0 [ERROR] Native table 'performance_schema'.'status_by_user' has the wrong structure
2022-09-21T12:10:17.038411Z 0 [ERROR] Native table 'performance_schema'.'global_status' has the wrong structure
2022-09-21T12:10:17.038430Z 0 [ERROR] Native table 'performance_schema'.'session_status' has the wrong structure
2022-09-21T12:10:17.038460Z 0 [ERROR] Native table 'performance_schema'.'variables_by_thread' has the wrong structure
2022-09-21T12:10:17.038481Z 0 [ERROR] Native table 'performance_schema'.'global_variables' has the wrong structure
2022-09-21T12:10:17.038500Z 0 [ERROR] Native table 'performance_schema'.'session_variables' has the wrong structure
2022-09-21T12:10:17.038572Z 0 [ERROR] Incorrect definition of table mysql.db: expected column 'User' at position 2 to have type char(32), found type char(16).
2022-09-21T12:10:17.038591Z 0 [ERROR] mysql.user has no `Event_priv` column at position 28
2022-09-21T12:10:17.038750Z 0 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler.
2022-09-21T12:10:17.038848Z 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.7.38'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2022-09-21T12:10:23.225699Z 2 [Warning] System table 'servers' is expected to be transactional.
2022-09-21T12:10:36.311345Z 3 [Note] Access denied for user 'root'@'localhost' (using password: NO)
2022-09-21T12:20:19.942294Z 0 [Note] Giving 0 client threads a chance to die gracefully
2022-09-21T12:20:19.942309Z 0 [Note] Shutting down slave threads
2022-09-21T12:20:19.942317Z 0 [Note] Forcefully disconnecting 0 remaining clients
2022-09-21T12:20:19.942443Z 0 [Note] Binlog end
2022-09-21T12:20:19.943960Z 0 [Note] Shutting down plugin 'ngram'
2022-09-21T12:20:19.943973Z 0 [Note] Shutting down plugin 'partition'
2022-09-21T12:20:19.943981Z 0 [Note] Shutting down plugin 'BLACKHOLE'
2022-09-21T12:20:19.943990Z 0 [Note] Shutting down plugin 'ARCHIVE'
2022-09-21T12:20:19.943996Z 0 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2022-09-21T12:20:19.944025Z 0 [Note] Shutting down plugin 'MRG_MYISAM'
2022-09-21T12:20:19.944032Z 0 [Note] Shutting down plugin 'MyISAM'
2022-09-21T12:20:19.944045Z 0 [Note] Shutting down plugin 'INNODB_SYS_VIRTUAL'
2022-09-21T12:20:19.944052Z 0 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2022-09-21T12:20:19.944058Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2022-09-21T12:20:19.944064Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2022-09-21T12:20:19.944069Z 0 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2022-09-21T12:20:19.944075Z 0 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2022-09-21T12:20:19.944081Z 0 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2022-09-21T12:20:19.944086Z 0 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2022-09-21T12:20:19.944092Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2022-09-21T12:20:19.944098Z 0 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2022-09-21T12:20:19.944104Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2022-09-21T12:20:19.944109Z 0 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2022-09-21T12:20:19.944115Z 0 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2022-09-21T12:20:19.944121Z 0 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2022-09-21T12:20:19.944127Z 0 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2022-09-21T12:20:19.944132Z 0 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2022-09-21T12:20:19.944138Z 0 [Note] Shutting down plugin 'INNODB_METRICS'
2022-09-21T12:20:19.944144Z 0 [Note] Shutting down plugin 'INNODB_TEMP_TABLE_INFO'
2022-09-21T12:20:19.944150Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2022-09-21T12:20:19.944155Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2022-09-21T12:20:19.944161Z 0 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2022-09-21T12:20:19.944167Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2022-09-21T12:20:19.944173Z 0 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2022-09-21T12:20:19.944178Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2022-09-21T12:20:19.944184Z 0 [Note] Shutting down plugin 'INNODB_CMPMEM'
2022-09-21T12:20:19.944190Z 0 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2022-09-21T12:20:19.944195Z 0 [Note] Shutting down plugin 'INNODB_CMP'
2022-09-21T12:20:19.944201Z 0 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2022-09-21T12:20:19.944219Z 0 [Note] Shutting down plugin 'INNODB_LOCKS'
2022-09-21T12:20:19.944225Z 0 [Note] Shutting down plugin 'INNODB_TRX'
2022-09-21T12:20:19.944231Z 0 [Note] Shutting down plugin 'InnoDB'
2022-09-21T12:20:19.944274Z 0 [Note] InnoDB: FTS optimize thread exiting.
2022-09-21T12:20:19.944335Z 0 [Note] InnoDB: Starting shutdown...
2022-09-21T12:20:20.046133Z 0 [Note] InnoDB: Dumping buffer pool(s) to /var/db/mysql/ib_buffer_pool
2022-09-21T12:20:20.046342Z 0 [Note] InnoDB: Buffer pool(s) dump completed at 220921 14:20:20
2022-09-21T12:20:20.900318Z 0 [Note] InnoDB: Shutdown completed; log sequence number 2674426
2022-09-21T12:20:20.901318Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-21T12:20:20.901338Z 0 [Note] Shutting down plugin 'MEMORY'
2022-09-21T12:20:20.901348Z 0 [Note] Shutting down plugin 'CSV'
2022-09-21T12:20:20.901357Z 0 [Note] Shutting down plugin 'sha256_password'
2022-09-21T12:20:20.901365Z 0 [Note] Shutting down plugin 'mysql_native_password'
2022-09-21T12:20:20.901535Z 0 [Note] Shutting down plugin 'binlog'
2022-09-21T12:20:20.901945Z 0 [Note] /usr/local/libexec/mysqld: Shutdown complete

2022-09-21T12:20:20.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended
2022-09-21T12:21:04.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'.
2022-09-21T12:21:04.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2022-09-21T12:21:04.865887Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:21:04.868721Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 861 ...
2022-09-21T12:21:04.877586Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:21:04.877606Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:21:04.877614Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:21:04.877621Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:21:04.878258Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:21:04.879160Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-21T12:21:04.881238Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:21:04.898024Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21T12:21:04.916696Z 0 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2022-09-21T12:21:04.981429Z 0 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2022-09-21T12:21:05.074148Z 0 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2022-09-21T12:21:05.074220Z 0 [Warning] InnoDB: New log files created, LSN=2674426
2022-09-21T12:21:05.075276Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-21T12:21:05.075894Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2674700
2022-09-21T12:21:05.075905Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2674709
2022-09-21T12:21:05.075913Z 0 [Note] InnoDB: Database was not shutdown normally!
2022-09-21T12:21:05.075919Z 0 [Note] InnoDB: Starting crash recovery.
2022-09-21T12:21:05.206010Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-21T12:21:05.206089Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-21T12:21:05.223188Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-21T12:21:05.224050Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-21T12:21:05.224061Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-21T12:21:05.224272Z 0 [Note] InnoDB: Waiting for purge to start
2022-09-21T12:21:05.277503Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 2674709
2022-09-21T12:21:05.278058Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2022-09-21T12:21:05.278291Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-21T12:21:05.280386Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:21:05
2022-09-21T12:21:05.289935Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-09-21T12:21:05.289948Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-09-21T12:21:05.289954Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:21:05.289961Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:21:05.291543Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-21T12:21:05.291918Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-09-21T12:21:05.292829Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-21T12:21:05.292862Z 0 [Note] IPv6 is available.
2022-09-21T12:21:05.292872Z 0 [Note]   - '::' resolves to '::';
2022-09-21T12:21:05.292890Z 0 [Note] Server socket created on IP: '::'.
2022-09-21T12:21:05.293665Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
2022-09-21T12:21:05.320465Z 0 [Note] Event Scheduler: Loaded 0 events
2022-09-21T12:21:05.320587Z 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.7.38'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2022-09-21T12:22:39.6NZ mysqld_safe mysqld restarted
2022-09-21T12:22:40.071178Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:22:40.073676Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 987 ...
2022-09-21T12:22:40.081911Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:22:40.081929Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:22:40.081937Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:22:40.081944Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:22:40.082367Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:22:40.083062Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-21T12:22:40.084950Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:22:40.100624Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21T12:22:40.122103Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-21T12:22:40.122975Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2674728
2022-09-21T12:22:40.122987Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2674737
2022-09-21T12:22:40.122995Z 0 [Note] InnoDB: Database was not shutdown normally!
2022-09-21T12:22:40.123002Z 0 [Note] InnoDB: Starting crash recovery.
2022-09-21T12:22:40.252749Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-21T12:22:40.252767Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-21T12:22:40.252811Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-21T12:22:40.269793Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-21T12:22:40.270644Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-21T12:22:40.270656Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-21T12:22:40.270879Z 0 [Note] InnoDB: Waiting for purge to start
2022-09-21T12:22:40.324091Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 2674737
2022-09-21T12:22:40.324509Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2022-09-21T12:22:40.324990Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-21T12:22:40.326986Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:22:40
2022-09-21T12:22:40.339405Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-09-21T12:22:40.339432Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-09-21T12:22:40.339459Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:22:40.339465Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:22:40.342070Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-21T12:22:40.342487Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-09-21T12:22:40.343900Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-21T12:22:40.344185Z 0 [Note] IPv6 is available.
2022-09-21T12:22:40.344198Z 0 [Note]   - '::' resolves to '::';
2022-09-21T12:22:40.344216Z 0 [Note] Server socket created on IP: '::'.
2022-09-21T12:22:40.345187Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
2022-09-21T12:22:40.372021Z 0 [Note] Event Scheduler: Loaded 0 events
2022-09-21T12:22:40.372135Z 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.7.38'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2022-09-21T12:28:34.540166Z 2 [Warning] IP address '755.647.155.34' could not be resolved: Name does not resolve
2022-09-21T12:29:16.748869Z 0 [Note] Giving 16 client threads a chance to die gracefully
2022-09-21T12:29:16.749028Z 0 [Note] Shutting down slave threads
2022-09-21T12:30:18.6NZ mysqld_safe Logging to '/var/db/mysql/omikron.err'.
2022-09-21T12:30:18.6NZ mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2022-09-21T12:30:18.566588Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:30:18.569642Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 884 ...
2022-09-21T12:30:18.578895Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:30:18.578916Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:30:18.578924Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:30:18.578931Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:30:18.579607Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:30:18.580626Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-21T12:30:18.582527Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:30:18.598197Z 0 [Note] InnoDB: Completed initialization of buffer pool
2022-09-21T12:30:18.621596Z 0 [Note] InnoDB: Highest supported file format is Barracuda.
2022-09-21T12:30:18.626060Z 0 [Note] InnoDB: Log scan progressed past the checkpoint lsn 2674756
2022-09-21T12:30:18.626070Z 0 [Note] InnoDB: Doing recovery: scanned up to log sequence number 2674765
2022-09-21T12:30:18.626079Z 0 [Note] InnoDB: Database was not shutdown normally!
2022-09-21T12:30:18.626085Z 0 [Note] InnoDB: Starting crash recovery.
2022-09-21T12:30:19.142612Z 0 [Note] InnoDB: Removed temporary tablespace data file: "ibtmp1"
2022-09-21T12:30:19.142628Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2022-09-21T12:30:19.142667Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2022-09-21T12:30:19.164534Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB.
2022-09-21T12:30:19.171851Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active.
2022-09-21T12:30:19.171866Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active.
2022-09-21T12:30:19.172097Z 0 [Note] InnoDB: Waiting for purge to start
2022-09-21T12:30:19.225342Z 0 [Note] InnoDB: 5.7.38 started; log sequence number 2674765
2022-09-21T12:30:19.225814Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/db/mysql/ib_buffer_pool
2022-09-21T12:30:19.226103Z 0 [Note] Plugin 'FEDERATED' is disabled.
2022-09-21T12:30:19.228148Z 0 [Note] InnoDB: Buffer pool(s) load completed at 220921 14:30:19
2022-09-21T12:30:19.235372Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them.
2022-09-21T12:30:19.235384Z 0 [Note] Skipping generation of SSL certificates as certificate files are present in data directory.
2022-09-21T12:30:19.235391Z 0 [Warning] A deprecated TLS version TLSv1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:30:19.235397Z 0 [Warning] A deprecated TLS version TLSv1.1 is enabled. Please use TLSv1.2 or higher.
2022-09-21T12:30:19.236436Z 0 [Warning] CA certificate ca.pem is self signed.
2022-09-21T12:30:19.236859Z 0 [Note] Skipping generation of RSA key pair as key files are present in data directory.
2022-09-21T12:30:19.237786Z 0 [Note] Server hostname (bind-address): '*'; port: 3306
2022-09-21T12:30:19.237820Z 0 [Note] IPv6 is available.
2022-09-21T12:30:19.237830Z 0 [Note]   - '::' resolves to '::';
2022-09-21T12:30:19.237847Z 0 [Note] Server socket created on IP: '::'.
2022-09-21T12:30:19.238538Z 0 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
2022-09-21T12:30:19.264903Z 0 [Note] Event Scheduler: Loaded 0 events
2022-09-21T12:30:19.265017Z 0 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.7.38'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2022-09-21T12:30:52.6NZ mysqld_safe mysqld restarted
2022-09-21T12:30:53.154957Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2022-09-21T12:30:53.157851Z 0 [Note] /usr/local/libexec/mysqld (mysqld 5.7.38) starting as process 980 ...
2022-09-21T12:30:53.166608Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2022-09-21T12:30:53.166624Z 0 [Note] InnoDB: Uses event mutexes
2022-09-21T12:30:53.166632Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier
2022-09-21T12:30:53.166640Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.12
2022-09-21T12:30:53.167038Z 0 [Note] InnoDB: Number of pools: 1
2022-09-21T12:30:53.167800Z 0 [Note] InnoDB: Not using CPU crc32 instructions
2022-09-21T12:30:53.169893Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M
2022-09-21T12:31:04.6NZ mysqld_safe mysqld from pid file /var/db/mysql/omikron.pid ended

 

Link to comment
Share on other sites

  • 9 months later...
  • 2 weeks later...
  • 7 months later...

Pessoal, eu preciso de ajuda. Comprei uma Vps Freebsd, mas não sei como acessar, já tenho o Ip, login e senha, mas não sei como ter acesso para upar meu servidor. vocês podem me ensinar como entrar? a Vps é comprada, no YouTube só mostra como criar uma freebsd, mas eu preciso saber como conectar a uma comprada. desde já agradeço profundamente se alguém puder me dar essa ajuda. abraço. 

 

Guys, I need help. I bought a Freebsd Vps, but I don't know how to access it, I already have the IP, login and password, but I don't know how to access it to upload my server. Can you teach me how to enter? the Vps is purchased, YouTube only shows how to create a freebsd, but I need to know how to connect to a purchased one. I would be very grateful in advance if anyone could give me this help. hug.

Link to comment
Share on other sites

Please sign in to comment

You will be able to leave a comment after signing in



Sign In Now

Announcements



×
×
  • Create New...

Important Information

Terms of Use / Privacy Policy / Guidelines / We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.