Contributor TMP4 10998 Posted March 10, 2023 Author Contributor Share Posted March 10, 2023 (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) 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 March 10, 2023 by Metin2 Dev International Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Karl 3 Posted March 10, 2023 Share Posted March 10, 2023 I got a strange issue, I can't compile it anymore. I tried downloading from scratch and compiling it, but I get the same issues. Might be related to visual studio. Any idea how to solve this? 1 Link to comment Share on other sites More sharing options...
espinafre18 29 Posted March 15, 2023 Share Posted March 15, 2023 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 Sign In or Sign Up 10 1 3 9 1 8 Link to comment Share on other sites More sharing options...
espinafre18 29 Posted March 16, 2023 Share Posted March 16, 2023 (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 March 16, 2023 by Metin2 Dev International Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Diazepam 1 Posted March 20, 2023 Share Posted March 20, 2023 Hi binary source is with VS 2019? Link to comment Share on other sites More sharing options...
Contributor TMP4 10998 Posted March 20, 2023 Author Contributor Share Posted March 20, 2023 (edited) 7 hours ago, Diazepam said: Hi binary source is with VS 2019? Edited March 20, 2023 by Metin2 Dev International Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Fearlesssss 1 Posted March 20, 2023 Share Posted March 20, 2023 (edited) Hey i've got these errors when trying to compile the source from represence It says that im missing files and need to add some files but idk where to get them from ;c Spoiler Edited March 20, 2023 by Metin2 Dev International Core X - External 2 Internal Link to comment Share on other sites More sharing options...
adrianadyy 1 Posted March 25, 2023 Share Posted March 25, 2023 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 More sharing options...
Contributor TMP4 10998 Posted March 26, 2023 Author Contributor Share Posted March 26, 2023 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. 1 Link to comment Share on other sites More sharing options...
adrianadyy 1 Posted March 26, 2023 Share Posted March 26, 2023 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 More sharing options...
Contributor TMP4 10998 Posted March 27, 2023 Author Contributor Share Posted March 27, 2023 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 More sharing options...
adrianadyy 1 Posted March 27, 2023 Share Posted March 27, 2023 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 More sharing options...
danio475 6 Posted March 29, 2023 Share Posted March 29, 2023 (edited) Perfect release, easy instalation & language settings. Thanks mate! Even setting up compilation enviroment is easy as **** Edited March 29, 2023 by danio475 1 Link to comment Share on other sites More sharing options...
adrianadyy 1 Posted March 30, 2023 Share Posted March 30, 2023 On 3/27/2023 at 7:57 PM, TMP4 said: 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? If everyone use it and work,I think error is somewhere in my freebsd. Maybe I have somethink missing Link to comment Share on other sites More sharing options...
Contributor TMP4 10998 Posted March 30, 2023 Author Contributor Share Posted March 30, 2023 (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 March 30, 2023 by TMP4 1 1 Link to comment Share on other sites More sharing options...
БlyatMAN 13 Posted April 9, 2023 Share Posted April 9, 2023 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? Link to comment Share on other sites More sharing options...
Contributor TMP4 10998 Posted April 9, 2023 Author Contributor Share Posted April 9, 2023 (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 April 9, 2023 by TMP4 Link to comment Share on other sites More sharing options...
БlyatMAN 13 Posted April 9, 2023 Share Posted April 9, 2023 (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 helpis not a big problem with that extra points but makes pe pisst i like perfection Edited April 9, 2023 by БlyatMAN Link to comment Share on other sites More sharing options...
GoldCash 7 Posted April 9, 2023 Share Posted April 9, 2023 No matter what quest I add, it still won't start in the game. What can I do about it? Link to comment Share on other sites More sharing options...
Contributor TMP4 10998 Posted April 9, 2023 Author Contributor Share Posted April 9, 2023 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 More sharing options...
GoldCash 7 Posted April 9, 2023 Share Posted April 9, 2023 Some quest works. but i have skille_5lvl.lua from Paczka And it doesn't work even if I don't get any error Link to comment Share on other sites More sharing options...
Contributor TMP4 10998 Posted April 10, 2023 Author Contributor Share Posted April 10, 2023 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 More sharing options...
Nuzzo 49 Posted April 11, 2023 Share Posted April 11, 2023 (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 April 11, 2023 by Nuzzo Core X - External 2 Internal 1 Link to comment Share on other sites More sharing options...
БlyatMAN 13 Posted April 12, 2023 Share Posted April 12, 2023 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 More sharing options...
avertusss 8 Posted April 14, 2023 Share Posted April 14, 2023 (edited) @ TMP4 i bought vps on contabo as you told but i cannot run freebsd. When i installed by panel Any ideas? Edited April 14, 2023 by Metin2 Dev International Core X - External 2 Internal Link to comment Share on other sites More sharing options...
Recommended Posts