Jump to content

[40250] Reference Serverfile + Client + Src [15 Available Languages]

TMP4

By TMP4,
in Binaries

 Share

Recommended Posts

  • Contributor
TMP4 Perfect

TMP4 10534

Posted
  • Author
  • Contributor
Posted (edited)
17 hours ago, TonisBoss said:

I got a strange bug with guild. 
When I own guild after reboot I can't invite a player, also when I try to change leader with the item(71099),the new leader can't invite anyone else.
guild_member and guild in Navicat are updated correctly. The only thing that make me think about the problem is guild_grade because it's empty.
There are no syserr for the error. 
Thank you in advance.

I just created a guild and it does insert it's data to guild_grade right away. (guild id 2)

K-perny-k-p-2023-03-10-162559.png

If you missing these lines then ofc you can't invite anyone after restart since the leader have ADD_MEMBER and the other permissions set there, and after a full server restart it'll load from there.

You have to find the error on your side.
I know you said syserr is empty but check db's syserr too, since if an sql query fails, it'll log there and not to the game core.

Edited by Metin2 Dev International
Core X - External 2 Internal
Link to comment
Share on other sites
  • Replies 1.4k
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Popular Posts

TMP4
TMP4

This is the hidden content, please Sign In or

TMP4
TMP4

Yes they were 32bit packages since the vm is 32bit. Luckily I have an x64 vm too where I had the packages so here you are:  This is the hidden content, please &

KingGallardo
KingGallardo

try using these commands:  fetch ftp://ftp.freebsd.org/pub/FreeBSD/releases/amd64/amd64/12.2-RELEASE/lib32.txz tar Jxpvf lib32.txz -C / rm lib32.txz I was able to mount it in a vps with freebsd

espinafre18 Explorer

espinafre18 29

Posted
Posted

Hello
I have been implementing the sash system.
Everything is ok in both client and Server as well as Sources.

The only problem I think is in the quest, when I press to open the window to combine the sash's I get nothing, when I try to open it again, it says that it is already open.

I used this system.

 

This is the hidden content, please

 

  • Metin2 Dev 10
  • kekw 1
  • Eyes 3
  • Good 9
  • Love 1
  • Love 8
Link to comment
Share on other sites
espinafre18 Explorer

espinafre18 29

Posted
Posted (edited)

Hi ppl.

Just to inform you that everything is ok now.
The problem was in the location of the TGA's and not in the quest itself... Thanks, if anyone needs help on this subject I can try to help.

I leave print of sash system

https://metin2.download/picture/46E8hP7Pq5By2jqN9q9GQ1a6tH3DCkOA/.png

 

Edited by Metin2 Dev International
Core X - External 2 Internal
Link to comment
Share on other sites
adrianadyy Contributor

adrianadyy 1

Posted
Posted
On 11/25/2021 at 5:29 PM, TMP4 said:

Hi

I can t start it. every time I receive connection refused. freebsd is 13.1 x64,I installed all libs,sv,mysql instaled,but I receive connection refused....

syser db

Spoiler

SYSERR: Mar 25 23:40:55 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Mar 25 23:41:15 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:15 :: ChildLoop: AsyncSQL: retrying
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Mar 25 23:41:25 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:25 :: ChildLoop: AsyncSQL: retrying
 

can help me please?

Link to comment
Share on other sites
  • Contributor
TMP4 Perfect

TMP4 10534

Posted
  • Author
  • Contributor
Posted
10 hours ago, adrianadyy said:

I can t start it. every time I receive connection refused. freebsd is 13.1 x64,I installed all libs,sv,mysql instaled,but I receive connection refused....

syser db

  Hide contents

SYSERR: Mar 25 23:40:55 :: Start: TABLE_POSTFIX not configured use default
SYSERR: Mar 25 23:41:15 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:15 :: ChildLoop: AsyncSQL: retrying
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:20 :: ChildLoop: AsyncSQL: retrying
SYSERR: Mar 25 23:41:25 :: ChildLoop: AsyncSQL: query failed: Can't connect to MySQL server on '127.0.0.1' (61) (query: SELECT id,login,vnum,count,socket0,socket1,socket2,mall,why FROM item_award WHERE taken_time IS NULL and id > 0 errno: 2003)
SYSERR: Mar 25 23:41:25 :: ChildLoop: AsyncSQL: retrying
 

can help me please?

Your syserr says that it can't connect to your mysql server.

Did you install the mysql server? Not the mysql data (metin2mysql.tar.gz) but the server.

Install it with pkg install mysql56-server.

If it's installed then check error logs of mysql server why it couldn't start.

  • Good 1
Link to comment
Share on other sites
adrianadyy Contributor

adrianadyy 1

Posted
Posted
11 hours ago, TMP4 said:

If it's installed then check error logs of mysql server why it couldn't start.

i have installed mysql56 server on freebsd 13.1 from blazingfast

In db error from var/db/mysql I have only this on .err file

Spoiler

230326 22:19:07 mysqld_safe Logging to '/var/db/mysql/bsd.err'.
230326 22:19:07 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-03-26 22:19:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:19:08 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 874 ...
2023-03-26 22:19:08 874 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:19:08 874 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:19:08 874 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:19:08 874 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:19:08 874 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:19:08 874 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:19:08 874 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:19:08 874 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:19:08 874 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:19:08 874 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2023-03-26 22:19:08 874 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2023-03-26 22:19:08 874 [Note] InnoDB: Database physically writes the file full: wait...
2023-03-26 22:19:08 874 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2023-03-26 22:19:08 874 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2023-03-26 22:19:08 874 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2023-03-26 22:19:08 874 [Warning] InnoDB: New log files created, LSN=45781
2023-03-26 22:19:08 874 [Note] InnoDB: Doublewrite buffer not found: creating new
2023-03-26 22:19:08 874 [Note] InnoDB: Doublewrite buffer created
2023-03-26 22:19:08 874 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:19:08 874 [Warning] InnoDB: Creating foreign key constraint system tables.
2023-03-26 22:19:08 874 [Note] InnoDB: Foreign key constraint system tables created
2023-03-26 22:19:08 874 [Note] InnoDB: Creating tablespace and datafile system tables.
2023-03-26 22:19:08 874 [Note] InnoDB: Tablespace and datafile system tables created.
2023-03-26 22:19:08 874 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:19:08 874 [Note] InnoDB: 5.6.51 started; log sequence number 0
 /usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
2023-03-26 22:19:08 874 [Warning] World-writable config file './auto.cnf' has been removed.

2023-03-26 22:19:08 874 [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: 76bc0da5-cc13-11ed-aaef-fa59b31350c8.
2023-03-26 22:19:08 874 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:08 874 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:08 874 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:19:08 874 [Note] IPv6 is available.
2023-03-26 22:19:08 874 [Note]   - '::' resolves to '::';
2023-03-26 22:19:08 874 [Note] Server socket created on IP: '::'.
2023-03-26 22:19:08 874 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:19:08 874 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2023-03-26 22:19:35 874 [Note] /usr/local/libexec/mysqld: Normal shutdown

2023-03-26 22:19:35 874 [Note] Giving 0 client threads a chance to die gracefully
2023-03-26 22:19:35 874 [Note] Event Scheduler: Purging the queue. 0 events
2023-03-26 22:19:35 874 [Note] Shutting down slave threads
2023-03-26 22:19:35 874 [Note] Forcefully disconnecting 0 remaining clients
2023-03-26 22:19:35 874 [Note] Binlog end
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'partition'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_METRICS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_TRX'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'InnoDB'
2023-03-26 22:19:35 874 [Note] InnoDB: FTS optimize thread exiting.
2023-03-26 22:19:35 874 [Note] InnoDB: Starting shutdown...
2023-03-26 22:19:36 874 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'BLACKHOLE'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'ARCHIVE'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'MRG_MYISAM'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'MyISAM'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'MEMORY'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'CSV'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'sha256_password'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'mysql_old_password'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'mysql_native_password'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'binlog'
2023-03-26 22:19:36 874 [Note] /usr/local/libexec/mysqld: Shutdown complete

230326 22:19:36 mysqld_safe mysqld from pid file /var/db/mysql/bsd.pid ended
2023-03-26 22:19:42 1024 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:19:42 1024 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:19:42 1024 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:19:42 1024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:19:42 1024 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:19:42 1024 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:19:42 1024 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:19:42 1024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:19:42 1024 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:19:42 1024 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:19:42 1024 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:19:42 1024 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:19:42 1024 [Note] InnoDB: 5.6.51 started; log sequence number 1600607
2023-03-26 22:19:42 1024 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:42 1024 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:42 1024 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:19:42 1024 [Note] IPv6 is available.
2023-03-26 22:19:42 1024 [Note]   - '::' resolves to '::';
2023-03-26 22:19:42 1024 [Note] Server socket created on IP: '::'.
2023-03-26 22:19:42 1024 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/innodb_index_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:20:16 1024 [Note] /usr/local/libexec/mysqld: Normal shutdown

2023-03-26 22:20:16 1024 [Note] Giving 0 client threads a chance to die gracefully
2023-03-26 22:20:16 1024 [Note] Shutting down slave threads
2023-03-26 22:20:16 1024 [Note] Forcefully disconnecting 0 remaining clients
2023-03-26 22:20:16 1024 [Note] Binlog end
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'partition'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_METRICS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_TRX'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'InnoDB'
2023-03-26 22:20:16 1024 [Note] InnoDB: FTS optimize thread exiting.
2023-03-26 22:20:16 1024 [Note] InnoDB: Starting shutdown...
2023-03-26 22:20:17 1024 [Note] InnoDB: Shutdown completed; log sequence number 1600617
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'BLACKHOLE'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'ARCHIVE'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'MRG_MYISAM'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'MyISAM'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'MEMORY'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'CSV'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'sha256_password'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'mysql_old_password'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'mysql_native_password'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'binlog'
2023-03-26 22:20:17 1024 [Note] /usr/local/libexec/mysqld: Shutdown complete

2023-03-26 22:20:22 1174 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:20:22 1174 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:20:22 1174 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:20:22 1174 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:20:22 1174 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:20:22 1174 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:20:22 1174 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:20:22 1174 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:20:22 1174 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:20:22 1174 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:20:22 1174 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:20:22 1174 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:20:22 1174 [Note] InnoDB: 5.6.51 started; log sequence number 1600617
2023-03-26 22:20:22 1174 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:20:22 1174 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:20:22 1174 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:20:22 1174 [Note] IPv6 is available.
2023-03-26 22:20:22 1174 [Note]   - '::' resolves to '::';
2023-03-26 22:20:22 1174 [Note] Server socket created on IP: '::'.
2023-03-26 22:20:22 1174 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:20:22 1174 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2023-03-26 22:20:43 1174 [Warning] IP address '89.39.81.250' could not be resolved: Name does not resolve
230326 22:24:22 mysqld_safe Logging to '/var/db/mysql/bsd.err'.
230326 22:24:22 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-03-26 22:24:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:24:23 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 875 ...
2023-03-26 22:24:23 875 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:24:23 875 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:24:23 875 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:24:23 875 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:24:23 875 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:24:23 875 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:24:23 875 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:24:23 875 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:24:23 875 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:24:23 875 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:24:23 875 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600627 in the ib_logfiles!
2023-03-26 22:24:23 875 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:24:23 875 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:24:23 875 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:24:23 875 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:24:23 875 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:24:23 875 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:24:23 875 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:24:23 875 [Note] InnoDB: 5.6.51 started; log sequence number 1600627
2023-03-26 22:24:23 875 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:24:23 875 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:24:23 875 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:24:23 875 [Note] IPv6 is available.
2023-03-26 22:24:23 875 [Note]   - '::' resolves to '::';
2023-03-26 22:24:23 875 [Note] Server socket created on IP: '::'.
2023-03-26 22:24:23 875 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:24:23 875 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:38 mysqld_safe mysqld restarted
2023-03-26 22:33:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:39 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1248 ...
2023-03-26 22:33:39 1248 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:39 1248 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:39 1248 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:39 1248 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:39 1248 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:39 1248 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:39 1248 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:39 1248 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:39 1248 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:39 1248 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:39 1248 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600637 in the ib_logfiles!
2023-03-26 22:33:39 1248 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:39 1248 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:39 1248 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:39 1248 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:39 1248 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:41 1248 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:41 1248 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:42 1248 [Note] InnoDB: 5.6.51 started; log sequence number 1600637
2023-03-26 22:33:42 1248 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:42 1248 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:42 1248 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:42 1248 [Note] IPv6 is available.
2023-03-26 22:33:42 1248 [Note]   - '::' resolves to '::';
2023-03-26 22:33:42 1248 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:42 1248 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:42 1248 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:44 mysqld_safe mysqld restarted
2023-03-26 22:33:44 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:44 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1262 ...
2023-03-26 22:33:44 1262 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:44 1262 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:44 1262 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:44 1262 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:44 1262 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:44 1262 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:44 1262 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:44 1262 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:44 1262 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:44 1262 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:44 1262 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600647 in the ib_logfiles!
2023-03-26 22:33:44 1262 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:44 1262 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:44 1262 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:44 1262 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:44 1262 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:44 1262 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:44 1262 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:45 1262 [Note] InnoDB: 5.6.51 started; log sequence number 1600647
2023-03-26 22:33:45 1262 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:45 1262 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:45 1262 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:45 1262 [Note] IPv6 is available.
2023-03-26 22:33:45 1262 [Note]   - '::' resolves to '::';
2023-03-26 22:33:45 1262 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:45 1262 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:45 1262 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:47 mysqld_safe mysqld restarted
2023-03-26 22:33:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:47 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1272 ...
2023-03-26 22:33:47 1272 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:47 1272 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:47 1272 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:47 1272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:47 1272 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:47 1272 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:47 1272 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:47 1272 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:47 1272 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:47 1272 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:47 1272 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600657 in the ib_logfiles!
2023-03-26 22:33:47 1272 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:47 1272 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:47 1272 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:47 1272 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:47 1272 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:47 1272 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:47 1272 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:47 1272 [Note] InnoDB: 5.6.51 started; log sequence number 1600657
2023-03-26 22:33:47 1272 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:47 1272 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:47 1272 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:47 1272 [Note] IPv6 is available.
2023-03-26 22:33:47 1272 [Note]   - '::' resolves to '::';
2023-03-26 22:33:47 1272 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:47 1272 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:47 1272 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:49 mysqld_safe mysqld restarted
2023-03-26 22:33:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:49 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1282 ...
2023-03-26 22:33:49 1282 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:49 1282 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:49 1282 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:49 1282 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:49 1282 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:49 1282 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:49 1282 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:49 1282 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:49 1282 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:49 1282 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:49 1282 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600657
2023-03-26 22:33:49 1282 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:49 1282 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:49 1282 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:49 1282 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:49 1282 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600667
2023-03-26 22:33:50 1282 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:50 1282 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:50 1282 [Note] InnoDB: 5.6.51 started; log sequence number 1600667
2023-03-26 22:33:50 1282 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:50 1282 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:50 1282 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:50 1282 [Note] IPv6 is available.
2023-03-26 22:33:50 1282 [Note]   - '::' resolves to '::';
2023-03-26 22:33:50 1282 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:50 1282 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:50 1282 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:51 mysqld_safe mysqld restarted
2023-03-26 22:33:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:52 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1292 ...
2023-03-26 22:33:52 1292 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:52 1292 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:52 1292 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:52 1292 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:52 1292 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:52 1292 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:52 1292 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:52 1292 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:52 1292 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:52 1292 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:52 1292 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600667
2023-03-26 22:33:52 1292 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:52 1292 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:52 1292 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:52 1292 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:52 1292 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600677
2023-03-26 22:33:52 1292 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:52 1292 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:52 1292 [Note] InnoDB: 5.6.51 started; log sequence number 1600677
2023-03-26 22:33:52 1292 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:52 1292 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:52 1292 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:52 1292 [Note] IPv6 is available.
2023-03-26 22:33:52 1292 [Note]   - '::' resolves to '::';
2023-03-26 22:33:52 1292 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:52 1292 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:52 1292 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:53 mysqld_safe mysqld restarted
2023-03-26 22:33:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:54 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1304 ...
2023-03-26 22:33:54 1304 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:54 1304 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:54 1304 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:54 1304 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:54 1304 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:54 1304 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:54 1304 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:54 1304 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:54 1304 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:54 1304 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:54 1304 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600677
2023-03-26 22:33:54 1304 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:54 1304 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:54 1304 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:54 1304 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:54 1304 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600687
2023-03-26 22:33:54 1304 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:54 1304 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:54 1304 [Note] InnoDB: 5.6.51 started; log sequence number 1600687
2023-03-26 22:33:54 1304 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:54 1304 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:54 1304 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:54 1304 [Note] IPv6 is available.
2023-03-26 22:33:54 1304 [Note]   - '::' resolves to '::';
2023-03-26 22:33:54 1304 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:54 1304 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:54 1304 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:56 mysqld_safe mysqld restarted
2023-03-26 22:33:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:56 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1316 ...
2023-03-26 22:33:56 1316 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:56 1316 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:56 1316 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:56 1316 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:56 1316 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:56 1316 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:56 1316 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:56 1316 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:56 1316 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:56 1316 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:56 1316 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600697 in the ib_logfiles!
2023-03-26 22:33:56 1316 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:56 1316 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:56 1316 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:56 1316 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:56 1316 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:56 1316 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:56 1316 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:56 1316 [Note] InnoDB: 5.6.51 started; log sequence number 1600697
2023-03-26 22:33:56 1316 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:56 1316 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:56 1316 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:56 1316 [Note] IPv6 is available.
2023-03-26 22:33:56 1316 [Note]   - '::' resolves to '::';
2023-03-26 22:33:56 1316 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:56 1316 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:56 1316 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:58 mysqld_safe mysqld restarted
2023-03-26 22:33:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:59 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1326 ...
2023-03-26 22:33:59 1326 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:59 1326 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:59 1326 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:59 1326 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:59 1326 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:59 1326 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:59 1326 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:59 1326 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:59 1326 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:59 1326 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:59 1326 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600697
2023-03-26 22:33:59 1326 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:59 1326 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:59 1326 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:59 1326 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:59 1326 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600707
2023-03-26 22:33:59 1326 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:59 1326 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:59 1326 [Note] InnoDB: 5.6.51 started; log sequence number 1600707
2023-03-26 22:33:59 1326 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:59 1326 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:59 1326 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:59 1326 [Note] IPv6 is available.
2023-03-26 22:33:59 1326 [Note]   - '::' resolves to '::';
2023-03-26 22:33:59 1326 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:59 1326 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:59 1326 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:34:05 mysqld_safe mysqld restarted
2023-03-26 22:34:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:34:06 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1337 ...
2023-03-26 22:34:06 1337 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:34:06 1337 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:34:06 1337 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:34:06 1337 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:34:06 1337 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:34:06 1337 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:34:06 1337 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:34:06 1337 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:34:06 1337 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:34:06 1337 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:34:06 1337 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600717 in the ib_logfiles!
2023-03-26 22:34:06 1337 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:34:06 1337 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:34:06 1337 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:34:06 1337 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:34:06 1337 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:34:06 1337 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:34:06 1337 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:34:06 1337 [Note] InnoDB: 5.6.51 started; log sequence number 1600717
2023-03-26 22:34:06 1337 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:06 1337 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:06 1337 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:34:06 1337 [Note] IPv6 is available.
2023-03-26 22:34:06 1337 [Note]   - '::' resolves to '::';
2023-03-26 22:34:06 1337 [Note] Server socket created on IP: '::'.
230326 22:34:15 mysqld_safe mysqld restarted
2023-03-26 22:34:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:34:15 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1350 ...
2023-03-26 22:34:15 1350 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:34:15 1350 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:34:15 1350 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:34:15 1350 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:34:15 1350 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:34:15 1350 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:34:15 1350 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:34:15 1350 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:34:15 1350 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:34:15 1350 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:34:15 1350 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600727 in the ib_logfiles!
2023-03-26 22:34:15 1350 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:34:15 1350 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:34:15 1350 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:34:15 1350 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:34:15 1350 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:34:15 1350 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:34:15 1350 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:34:15 1350 [Note] InnoDB: 5.6.51 started; log sequence number 1600727
2023-03-26 22:34:15 1350 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:15 1350 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:15 1350 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:34:15 1350 [Note] IPv6 is available.
2023-03-26 22:34:15 1350 [Note]   - '::' resolves to '::';
2023-03-26 22:34:15 1350 [Note] Server socket created on IP: '::'.
2023-03-26 22:34:15 1350 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:34:15 1350 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
 

 What I can do?

Link to comment
Share on other sites
  • Contributor
TMP4 Perfect

TMP4 10534

Posted
  • Author
  • Contributor
Posted
20 hours ago, adrianadyy said:

i have installed mysql56 server on freebsd 13.1 from blazingfast

In db error from var/db/mysql I have only this on .err file

  Hide contents

230326 22:19:07 mysqld_safe Logging to '/var/db/mysql/bsd.err'.
230326 22:19:07 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-03-26 22:19:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:19:08 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 874 ...
2023-03-26 22:19:08 874 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:19:08 874 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:19:08 874 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:19:08 874 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:19:08 874 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:19:08 874 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:19:08 874 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:19:08 874 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:19:08 874 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:19:08 874 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
2023-03-26 22:19:08 874 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
2023-03-26 22:19:08 874 [Note] InnoDB: Database physically writes the file full: wait...
2023-03-26 22:19:08 874 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
2023-03-26 22:19:08 874 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
2023-03-26 22:19:08 874 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
2023-03-26 22:19:08 874 [Warning] InnoDB: New log files created, LSN=45781
2023-03-26 22:19:08 874 [Note] InnoDB: Doublewrite buffer not found: creating new
2023-03-26 22:19:08 874 [Note] InnoDB: Doublewrite buffer created
2023-03-26 22:19:08 874 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:19:08 874 [Warning] InnoDB: Creating foreign key constraint system tables.
2023-03-26 22:19:08 874 [Note] InnoDB: Foreign key constraint system tables created
2023-03-26 22:19:08 874 [Note] InnoDB: Creating tablespace and datafile system tables.
2023-03-26 22:19:08 874 [Note] InnoDB: Tablespace and datafile system tables created.
2023-03-26 22:19:08 874 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:19:08 874 [Note] InnoDB: 5.6.51 started; log sequence number 0
 /usr/local/libexec/mysqld: Error on delete of './auto.cnf' (Errcode: 2 - No such file or directory)
2023-03-26 22:19:08 874 [Warning] World-writable config file './auto.cnf' has been removed.

2023-03-26 22:19:08 874 [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: 76bc0da5-cc13-11ed-aaef-fa59b31350c8.
2023-03-26 22:19:08 874 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:08 874 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:08 874 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:19:08 874 [Note] IPv6 is available.
2023-03-26 22:19:08 874 [Note]   - '::' resolves to '::';
2023-03-26 22:19:08 874 [Note] Server socket created on IP: '::'.
2023-03-26 22:19:08 874 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:19:08 874 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2023-03-26 22:19:35 874 [Note] /usr/local/libexec/mysqld: Normal shutdown

2023-03-26 22:19:35 874 [Note] Giving 0 client threads a chance to die gracefully
2023-03-26 22:19:35 874 [Note] Event Scheduler: Purging the queue. 0 events
2023-03-26 22:19:35 874 [Note] Shutting down slave threads
2023-03-26 22:19:35 874 [Note] Forcefully disconnecting 0 remaining clients
2023-03-26 22:19:35 874 [Note] Binlog end
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'partition'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_METRICS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_CMP'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'INNODB_TRX'
2023-03-26 22:19:35 874 [Note] Shutting down plugin 'InnoDB'
2023-03-26 22:19:35 874 [Note] InnoDB: FTS optimize thread exiting.
2023-03-26 22:19:35 874 [Note] InnoDB: Starting shutdown...
2023-03-26 22:19:36 874 [Note] InnoDB: Shutdown completed; log sequence number 1600607
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'BLACKHOLE'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'ARCHIVE'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'MRG_MYISAM'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'MyISAM'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'MEMORY'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'CSV'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'sha256_password'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'mysql_old_password'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'mysql_native_password'
2023-03-26 22:19:36 874 [Note] Shutting down plugin 'binlog'
2023-03-26 22:19:36 874 [Note] /usr/local/libexec/mysqld: Shutdown complete

230326 22:19:36 mysqld_safe mysqld from pid file /var/db/mysql/bsd.pid ended
2023-03-26 22:19:42 1024 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:19:42 1024 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:19:42 1024 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:19:42 1024 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:19:42 1024 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:19:42 1024 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:19:42 1024 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:19:42 1024 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:19:42 1024 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:19:42 1024 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:19:42 1024 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:19:42 1024 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:19:42 1024 [Note] InnoDB: 5.6.51 started; log sequence number 1600607
2023-03-26 22:19:42 1024 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:42 1024 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:19:42 1024 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:19:42 1024 [Note] IPv6 is available.
2023-03-26 22:19:42 1024 [Note]   - '::' resolves to '::';
2023-03-26 22:19:42 1024 [Note] Server socket created on IP: '::'.
2023-03-26 22:19:42 1024 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/innodb_index_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/innodb_table_stats from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/slave_master_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/slave_relay_log_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:19:52 1024 [Warning] InnoDB: Cannot open table mysql/slave_worker_info from the internal data dictionary of InnoDB though the .frm file for the table exists. See http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting.html for how you can resolve the problem.
2023-03-26 22:20:16 1024 [Note] /usr/local/libexec/mysqld: Normal shutdown

2023-03-26 22:20:16 1024 [Note] Giving 0 client threads a chance to die gracefully
2023-03-26 22:20:16 1024 [Note] Shutting down slave threads
2023-03-26 22:20:16 1024 [Note] Forcefully disconnecting 0 remaining clients
2023-03-26 22:20:16 1024 [Note] Binlog end
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'partition'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_METRICS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMPMEM'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_CMP'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_LOCKS'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'INNODB_TRX'
2023-03-26 22:20:16 1024 [Note] Shutting down plugin 'InnoDB'
2023-03-26 22:20:16 1024 [Note] InnoDB: FTS optimize thread exiting.
2023-03-26 22:20:16 1024 [Note] InnoDB: Starting shutdown...
2023-03-26 22:20:17 1024 [Note] InnoDB: Shutdown completed; log sequence number 1600617
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'BLACKHOLE'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'ARCHIVE'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'MRG_MYISAM'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'MyISAM'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'MEMORY'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'CSV'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'sha256_password'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'mysql_old_password'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'mysql_native_password'
2023-03-26 22:20:17 1024 [Note] Shutting down plugin 'binlog'
2023-03-26 22:20:17 1024 [Note] /usr/local/libexec/mysqld: Shutdown complete

2023-03-26 22:20:22 1174 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:20:22 1174 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:20:22 1174 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:20:22 1174 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:20:22 1174 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:20:22 1174 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:20:22 1174 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:20:22 1174 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:20:22 1174 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:20:22 1174 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:20:22 1174 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:20:22 1174 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:20:22 1174 [Note] InnoDB: 5.6.51 started; log sequence number 1600617
2023-03-26 22:20:22 1174 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:20:22 1174 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:20:22 1174 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:20:22 1174 [Note] IPv6 is available.
2023-03-26 22:20:22 1174 [Note]   - '::' resolves to '::';
2023-03-26 22:20:22 1174 [Note] Server socket created on IP: '::'.
2023-03-26 22:20:22 1174 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:20:22 1174 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
2023-03-26 22:20:43 1174 [Warning] IP address '89.39.81.250' could not be resolved: Name does not resolve
230326 22:24:22 mysqld_safe Logging to '/var/db/mysql/bsd.err'.
230326 22:24:22 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
2023-03-26 22:24:23 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:24:23 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 875 ...
2023-03-26 22:24:23 875 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:24:23 875 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:24:23 875 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:24:23 875 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:24:23 875 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:24:23 875 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:24:23 875 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:24:23 875 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:24:23 875 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:24:23 875 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:24:23 875 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600627 in the ib_logfiles!
2023-03-26 22:24:23 875 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:24:23 875 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:24:23 875 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:24:23 875 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:24:23 875 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:24:23 875 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:24:23 875 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:24:23 875 [Note] InnoDB: 5.6.51 started; log sequence number 1600627
2023-03-26 22:24:23 875 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:24:23 875 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:24:23 875 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:24:23 875 [Note] IPv6 is available.
2023-03-26 22:24:23 875 [Note]   - '::' resolves to '::';
2023-03-26 22:24:23 875 [Note] Server socket created on IP: '::'.
2023-03-26 22:24:23 875 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:24:23 875 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:38 mysqld_safe mysqld restarted
2023-03-26 22:33:39 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:39 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1248 ...
2023-03-26 22:33:39 1248 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:39 1248 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:39 1248 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:39 1248 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:39 1248 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:39 1248 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:39 1248 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:39 1248 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:39 1248 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:39 1248 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:39 1248 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600637 in the ib_logfiles!
2023-03-26 22:33:39 1248 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:39 1248 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:39 1248 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:39 1248 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:39 1248 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:41 1248 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:41 1248 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:42 1248 [Note] InnoDB: 5.6.51 started; log sequence number 1600637
2023-03-26 22:33:42 1248 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:42 1248 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:42 1248 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:42 1248 [Note] IPv6 is available.
2023-03-26 22:33:42 1248 [Note]   - '::' resolves to '::';
2023-03-26 22:33:42 1248 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:42 1248 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:42 1248 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:44 mysqld_safe mysqld restarted
2023-03-26 22:33:44 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:44 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1262 ...
2023-03-26 22:33:44 1262 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:44 1262 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:44 1262 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:44 1262 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:44 1262 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:44 1262 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:44 1262 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:44 1262 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:44 1262 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:44 1262 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:44 1262 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600647 in the ib_logfiles!
2023-03-26 22:33:44 1262 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:44 1262 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:44 1262 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:44 1262 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:44 1262 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:44 1262 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:44 1262 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:45 1262 [Note] InnoDB: 5.6.51 started; log sequence number 1600647
2023-03-26 22:33:45 1262 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:45 1262 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:45 1262 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:45 1262 [Note] IPv6 is available.
2023-03-26 22:33:45 1262 [Note]   - '::' resolves to '::';
2023-03-26 22:33:45 1262 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:45 1262 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:45 1262 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:47 mysqld_safe mysqld restarted
2023-03-26 22:33:47 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:47 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1272 ...
2023-03-26 22:33:47 1272 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:47 1272 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:47 1272 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:47 1272 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:47 1272 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:47 1272 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:47 1272 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:47 1272 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:47 1272 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:47 1272 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:47 1272 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600657 in the ib_logfiles!
2023-03-26 22:33:47 1272 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:47 1272 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:47 1272 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:47 1272 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:47 1272 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:47 1272 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:47 1272 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:47 1272 [Note] InnoDB: 5.6.51 started; log sequence number 1600657
2023-03-26 22:33:47 1272 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:47 1272 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:47 1272 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:47 1272 [Note] IPv6 is available.
2023-03-26 22:33:47 1272 [Note]   - '::' resolves to '::';
2023-03-26 22:33:47 1272 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:47 1272 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:47 1272 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:49 mysqld_safe mysqld restarted
2023-03-26 22:33:49 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:49 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1282 ...
2023-03-26 22:33:49 1282 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:49 1282 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:49 1282 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:49 1282 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:49 1282 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:49 1282 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:49 1282 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:49 1282 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:49 1282 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:49 1282 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:49 1282 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600657
2023-03-26 22:33:49 1282 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:49 1282 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:49 1282 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:49 1282 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:49 1282 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600667
2023-03-26 22:33:50 1282 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:50 1282 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:50 1282 [Note] InnoDB: 5.6.51 started; log sequence number 1600667
2023-03-26 22:33:50 1282 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:50 1282 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:50 1282 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:50 1282 [Note] IPv6 is available.
2023-03-26 22:33:50 1282 [Note]   - '::' resolves to '::';
2023-03-26 22:33:50 1282 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:50 1282 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:50 1282 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:51 mysqld_safe mysqld restarted
2023-03-26 22:33:52 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:52 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1292 ...
2023-03-26 22:33:52 1292 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:52 1292 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:52 1292 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:52 1292 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:52 1292 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:52 1292 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:52 1292 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:52 1292 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:52 1292 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:52 1292 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:52 1292 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600667
2023-03-26 22:33:52 1292 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:52 1292 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:52 1292 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:52 1292 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:52 1292 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600677
2023-03-26 22:33:52 1292 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:52 1292 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:52 1292 [Note] InnoDB: 5.6.51 started; log sequence number 1600677
2023-03-26 22:33:52 1292 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:52 1292 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:52 1292 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:52 1292 [Note] IPv6 is available.
2023-03-26 22:33:52 1292 [Note]   - '::' resolves to '::';
2023-03-26 22:33:52 1292 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:52 1292 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:52 1292 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:53 mysqld_safe mysqld restarted
2023-03-26 22:33:54 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:54 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1304 ...
2023-03-26 22:33:54 1304 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:54 1304 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:54 1304 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:54 1304 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:54 1304 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:54 1304 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:54 1304 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:54 1304 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:54 1304 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:54 1304 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:54 1304 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600677
2023-03-26 22:33:54 1304 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:54 1304 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:54 1304 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:54 1304 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:54 1304 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600687
2023-03-26 22:33:54 1304 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:54 1304 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:54 1304 [Note] InnoDB: 5.6.51 started; log sequence number 1600687
2023-03-26 22:33:54 1304 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:54 1304 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:54 1304 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:54 1304 [Note] IPv6 is available.
2023-03-26 22:33:54 1304 [Note]   - '::' resolves to '::';
2023-03-26 22:33:54 1304 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:54 1304 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:54 1304 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:56 mysqld_safe mysqld restarted
2023-03-26 22:33:56 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:56 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1316 ...
2023-03-26 22:33:56 1316 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:56 1316 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:56 1316 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:56 1316 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:56 1316 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:56 1316 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:56 1316 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:56 1316 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:56 1316 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:56 1316 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:56 1316 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600697 in the ib_logfiles!
2023-03-26 22:33:56 1316 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:56 1316 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:56 1316 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:56 1316 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:56 1316 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:33:56 1316 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:56 1316 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:56 1316 [Note] InnoDB: 5.6.51 started; log sequence number 1600697
2023-03-26 22:33:56 1316 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:56 1316 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:56 1316 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:56 1316 [Note] IPv6 is available.
2023-03-26 22:33:56 1316 [Note]   - '::' resolves to '::';
2023-03-26 22:33:56 1316 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:56 1316 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:56 1316 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:33:58 mysqld_safe mysqld restarted
2023-03-26 22:33:59 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:33:59 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1326 ...
2023-03-26 22:33:59 1326 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:33:59 1326 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:33:59 1326 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:33:59 1326 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:33:59 1326 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:33:59 1326 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:33:59 1326 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:33:59 1326 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:33:59 1326 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:33:59 1326 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:33:59 1326 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1600697
2023-03-26 22:33:59 1326 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:33:59 1326 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:33:59 1326 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:33:59 1326 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:33:59 1326 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1600707
2023-03-26 22:33:59 1326 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:33:59 1326 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:33:59 1326 [Note] InnoDB: 5.6.51 started; log sequence number 1600707
2023-03-26 22:33:59 1326 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:59 1326 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:33:59 1326 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:33:59 1326 [Note] IPv6 is available.
2023-03-26 22:33:59 1326 [Note]   - '::' resolves to '::';
2023-03-26 22:33:59 1326 [Note] Server socket created on IP: '::'.
2023-03-26 22:33:59 1326 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:33:59 1326 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
230326 22:34:05 mysqld_safe mysqld restarted
2023-03-26 22:34:06 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:34:06 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1337 ...
2023-03-26 22:34:06 1337 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:34:06 1337 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:34:06 1337 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:34:06 1337 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:34:06 1337 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:34:06 1337 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:34:06 1337 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:34:06 1337 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:34:06 1337 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:34:06 1337 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:34:06 1337 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600717 in the ib_logfiles!
2023-03-26 22:34:06 1337 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:34:06 1337 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:34:06 1337 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:34:06 1337 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:34:06 1337 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:34:06 1337 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:34:06 1337 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:34:06 1337 [Note] InnoDB: 5.6.51 started; log sequence number 1600717
2023-03-26 22:34:06 1337 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:06 1337 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:06 1337 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:34:06 1337 [Note] IPv6 is available.
2023-03-26 22:34:06 1337 [Note]   - '::' resolves to '::';
2023-03-26 22:34:06 1337 [Note] Server socket created on IP: '::'.
230326 22:34:15 mysqld_safe mysqld restarted
2023-03-26 22:34:15 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2023-03-26 22:34:15 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 1350 ...
2023-03-26 22:34:15 1350 [Note] Plugin 'FEDERATED' is disabled.
2023-03-26 22:34:15 1350 [Note] InnoDB: Using atomics to ref count buffer pool pages
2023-03-26 22:34:15 1350 [Note] InnoDB: The InnoDB memory heap is disabled
2023-03-26 22:34:15 1350 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
2023-03-26 22:34:15 1350 [Note] InnoDB: Memory barrier is not used
2023-03-26 22:34:15 1350 [Note] InnoDB: Compressed tables use zlib 1.2.12
2023-03-26 22:34:15 1350 [Note] InnoDB: Using CPU crc32 instructions
2023-03-26 22:34:15 1350 [Note] InnoDB: Initializing buffer pool, size = 128.0M
2023-03-26 22:34:15 1350 [Note] InnoDB: Completed initialization of buffer pool
2023-03-26 22:34:15 1350 [Note] InnoDB: Highest supported file format is Barracuda.
2023-03-26 22:34:15 1350 [Note] InnoDB: The log sequence numbers 1600617 and 1600617 in ibdata files do not match the log sequence number 1600727 in the ib_logfiles!
2023-03-26 22:34:15 1350 [Note] InnoDB: Database was not shutdown normally!
2023-03-26 22:34:15 1350 [Note] InnoDB: Starting crash recovery.
2023-03-26 22:34:15 1350 [Note] InnoDB: Reading tablespace information from the .ibd files...
2023-03-26 22:34:15 1350 [Note] InnoDB: Restoring possible half-written data pages 
2023-03-26 22:34:15 1350 [Note] InnoDB: from the doublewrite buffer...
2023-03-26 22:34:15 1350 [Note] InnoDB: 128 rollback segment(s) are active.
2023-03-26 22:34:15 1350 [Note] InnoDB: Waiting for purge to start
2023-03-26 22:34:15 1350 [Note] InnoDB: 5.6.51 started; log sequence number 1600727
2023-03-26 22:34:15 1350 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:15 1350 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
2023-03-26 22:34:15 1350 [Note] Server hostname (bind-address): '*'; port: 3306
2023-03-26 22:34:15 1350 [Note] IPv6 is available.
2023-03-26 22:34:15 1350 [Note]   - '::' resolves to '::';
2023-03-26 22:34:15 1350 [Note] Server socket created on IP: '::'.
2023-03-26 22:34:15 1350 [Note] Event Scheduler: Loaded 0 events
2023-03-26 22:34:15 1350 [Note] /usr/local/libexec/mysqld: ready for connections.
Version: '5.6.51'  socket: '/tmp/mysql.sock'  port: 3306  Source distribution
 

 What I can do?

I'm not seeing any error there but can you log in to mysql? (Via navicat/heidisql) Or just the Metin2 server can't connect to it?

Link to comment
Share on other sites
adrianadyy Contributor

adrianadyy 1

Posted
Posted
2 hours ago, TMP4 said:

Or just the Metin2 server can't connect to it?

I can connect to mysql via navicat,but when I start server I receive error connection refused. If I use command service mysql status this will say mysql not running.

I tryed to delete all svf+mysql again,reboot, reinstal it via tar -xf and name,rebbot,changed mysql pw,reboot and in end connection refused. After I aded my server ip in every config via bind_ip without # and also connection refused.

Syser ch1,ch99,auth,db are clean...

Link to comment
Share on other sites
  • Contributor
TMP4 Perfect

TMP4 10534

Posted
  • Author
  • Contributor
Posted (edited)
34 minutes ago, adrianadyy said:

If everyone use it and work,I think error is somewhere in my freebsd. Maybe I have somethink missing

Your db syserr says it can't connect to mysql server on 127.0.0.1, while you say you're able to reach it from outside (from the internet).

If you change 127.0.0.1 to your vps's public ip and metin2 & password to root and rootpassword in every config file and db/conf.txt then it would probably work. 
Should you do it? Just for testing, there's a reason metin2 uses a local user for the db (security). Also a local connection is probably faster I think.

I'm not able to debug your FreeBSD's mysql server remotely.
If It would be my vps, I would check first if "localhost" works instead of the 127.0.0.1, then check the metin2@localhost db user what is probably fine, then ask the hosting about are there any preinstalled firewall or port filter.

Edited by TMP4
  • Metin2 Dev 1
  • Good 1
Link to comment
Share on other sites
  • 2 weeks later...
  • Contributor
TMP4 Perfect

TMP4 10534

Posted
  • Author
  • Contributor
Posted (edited)
4 hours ago, БlyatMAN said:

one dumb question i modified level max to 175 and i have 174 skill points it is a whay to make that skill points less?

1. cmd_general.cpp: #define MAX_STAT 90 // Modifiy 90 to max stat

2. char.cpp: (GetLevel() < 91) PointChange(POINT_STAT, 1); // Modifiy 91 to max stat + 1

3. char.cpp: PointChange(POINT_STAT, ((MINMAX(1, iLv, 90) - 1) * 3) + GetPoint(POINT_LEVEL_STEP) - GetPoint(POINT_STAT)); // Modifiy 90 to max stat

--------------

Edit: One thing I just noticed now. In the 3., the original code from kraizy.tgz is like this: 

	if(iLv <= 90)
		PointChange(POINT_STAT, ((MINMAX(1, iLv, 90) - 1) * 3) + GetPoint(POINT_LEVEL_STEP) - GetPoint(POINT_STAT));
	else
		PointChange(POINT_STAT, 270 - GetPoint(POINT_STAT));

I think now if you do /level 91 you get 267 point instead of 270.
I don't know why Mali modified this but I'm gonna modify it back to it's original state.

("one dumb question" Even if it was dumb, you helped me discover this modification so thank you 😄 )

Edit: Mega archive updated. 

2023.04.09: - Char.cpp CHARACTER::ResetPoint's POINT_STAT was modified, changed back to original code. (Line: 5934-5939)
Edited by TMP4
Link to comment
Share on other sites
БlyatMAN Enthusiast

БlyatMAN 13

Posted
Posted (edited)
1 hour ago, TMP4 said:

1. cmd_general.cpp: #define MAX_STAT 90 // Modifiy 90 to max stat

2. char.cpp: (GetLevel() < 91) PointChange(POINT_STAT, 1); // Modifiy 90 to max stat + 1

3. char.cpp: PointChange(POINT_STAT, ((MINMAX(1, iLv, 90) - 1) * 3) + GetPoint(POINT_LEVEL_STEP) - GetPoint(POINT_STAT)); // Modifiy 90 to max stat

--------------

Edit: One thing I just noticed now. In the 3., the original code from kraizy.tgz is like this: 

	if(iLv <= 90)
		PointChange(POINT_STAT, ((MINMAX(1, iLv, 90) - 1) * 3) + GetPoint(POINT_LEVEL_STEP) - GetPoint(POINT_STAT));
	else
		PointChange(POINT_STAT, 270 - GetPoint(POINT_STAT));

I think now if you do /level 91 you get 267 point instead of 270.
I don't know why Mali modified this but I'm gonna modify it back to it's original state.

("one dumb question" Even if it was dumb, you helped me disover this modification so thank you 😄 )

Nice to help🫡is not a big problem with that extra points but makes pe pisst i like perfection❤️

Edited by БlyatMAN
Link to comment
Share on other sites
  • Contributor
TMP4 Perfect

TMP4 10534

Posted
  • Author
  • Contributor
Posted
11 minutes ago, GoldCash said:

No matter what quest I add, it still won't start in the game. What can I do about it?

1. Go to your quest folder and create a new file named goldcash.quest 
2. Open the new file and put this to it: 

quest goldcash begin
	state start begin
 		when login begin
			say("It works!")
		end
	end
end

3. Open locale_list and write the new quest name goldcash.quest to the bottom of the file
4. Do this command: cd /usr/metin2/server/share/locale/english/quest && python2.7 make.py
     and make sure you're seeing your new quest at the end of the output. If it writes any error then copy the output here.
5. If your server running then close and start your server via start.sh (or do ingame a /reload q)
6. Login and it should write you "It works!" after every login.

If you don't success with it then record your work and upload it to somewhere, because I'm not a mind reader to know what you're doing wrong, I have to see it.

Link to comment
Share on other sites
  • Contributor
TMP4 Perfect

TMP4 10534

Posted
  • Author
  • Contributor
Posted
8 hours ago, GoldCash said:

Some quest works. but i have skille_5lvl.lua from Paczka  And it doesn't work even if I don't get any error

Well, on your first post you said none of the quest works you trying to add.
But I'm still not a mind reader to check that quest. If it's public then copy & paste here, if it's not then talk with Paczka.

If a quest does not work on a basic 40k files then it requires some additional function/requirement what Paczka did not provide you.

Link to comment
Share on other sites
Nuzzo Collaborator

Nuzzo 45

Posted
Posted (edited)

If I try to enter the devil's catacombs, I get this error on the .mse file, and when I go through the portals on the third floor:
CRaceManager::GetRaceDataPointer: cannot load data by dwRaceIndex 10801

 

https://metin2.download/picture/KbEvq5nXD6Ffer26ZIDkOuGhEv0mPv14/.png
 

 


If I go into the "flamed" map I get this instead:

0411 20:27:12832 :: CRaceManager::RegisterRacePath : RACE[20385] LOAD MSMFILE[d:/ymir work/npc/flame_dungeon_npc/flame_npc.msm] ERROR. Will Find Another Path.
0411 20:27:12833 :: CEffectManager::RegisterEffect - LoadScript(D:\Ymir Work\effect\monster2\yellowred1_big.mse) Error

flame_npc.msm  is located in npc2

Edited by Nuzzo
Core X - External 2 Internal
  • Good 1
Link to comment
Share on other sites
БlyatMAN Enthusiast

БlyatMAN 13

Posted
Posted
12 hours ago, Nuzzo said:

If I try to enter the devil's catacombs, I get this error on the .mse file, and when I go through the portals on the third floor:
CRaceManager::GetRaceDataPointer: cannot load data by dwRaceIndex 10801

 

https://metin2.download/picture/KbEvq5nXD6Ffer26ZIDkOuGhEv0mPv14/.png
 

 


If I go into the "flamed" map I get this instead:

0411 20:27:12832 :: CRaceManager::RegisterRacePath : RACE[20385] LOAD MSMFILE[d:/ymir work/npc/flame_dungeon_npc/flame_npc.msm] ERROR. Will Find Another Path.
0411 20:27:12833 :: CEffectManager::RegisterEffect - LoadScript(D:\Ymir Work\effect\monster2\yellowred1_big.mse) Error

flame_npc.msm  is located in npc2

Also in v4 if i remember is the same error sadly i dont know the fix maybe @ TMP4can help us🤗

Link to comment
Share on other sites
 Share
Go to topic listing

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.