I am suddenly facing this error i dont find any solution specific to this all others solutions on different platform such as stackoverflow suggest to change port
renew backup and data etc but nothing worked so i just reverted to original problem>
HELP ME ITS URGENT I CANT COMPLETE MY COLLEGE PROJECT MY DB IS VERY IMPORTAnt FOR MY PROJECT
2023-04-24 12:35:09 0 [Note] Using unique option prefix 'key_buffer' is error-prone and can break in the future. Please use the full name 'key_buffer_size' instead.
2023-04-24 12:35:09 0 [Note] mysqld (mysqld 10.4.22-MariaDB) starting as process 18748 ...
2023-04-24 12:35:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2023-04-24 12:35:09 0 [Note] InnoDB: Uses event mutexes
2023-04-24 12:35:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2023-04-24 12:35:09 0 [Note] InnoDB: Number of pools: 1
2023-04-24 12:35:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2023-04-24 12:35:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2023-04-24 12:35:09 0 [Note] InnoDB: Completed initialization of buffer pool
2023-04-24 12:35:09 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2023-04-24 12:35:09 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2023-04-24 12:35:09 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2023-04-24 12:35:09 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\activity\home_tasks.ibd' OS error: 203
2023-04-24 12:35:09 0 [ERROR] InnoDB: Operating system error number 203 in a file operation.
2023-04-24 12:35:09 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2023-04-24 12:35:09 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``activity`.`home_tasks``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2023-04-24 12:35:09 0 [Warning] InnoDB: Ignoring tablespace for `activity`.`home_tasks` because it could not be opened.
2023-04-24 12:35:09 0 [ERROR] InnoDB: Operating system error number 3 in a file operation.
2023-04-24 12:35:09 0 [ERROR] InnoDB: The error means the system cannot find the path specified.
2023-04-24 12:35:09 0 [ERROR] InnoDB: If you are installing InnoDB, remember that you must create directories yourself, InnoDB does not create them.
2023-04-24 12:35:09 0 [ERROR] InnoDB: Cannot open datafile for read-only: '.\activity\users.ibd' OS error: 203
2023-04-24 12:35:09 0 [ERROR] InnoDB: Operating system error number 203 in a file operation.
2023-04-24 12:35:09 0 [Note] InnoDB: Some operating system error numbers are described at https://mariadb.com/kb/en/library/operating-system-error-codes/
2023-04-24 12:35:09 0 [ERROR] InnoDB: Could not find a valid tablespace file for ``activity`.`users``. Please refer to https://mariadb.com/kb/en/innodb-data-dictionary-troubleshooting/ for how to resolve the issue.
2023-04-24 12:35:09 0 [Warning] InnoDB: Ignoring tablespace for `activity`.`users` because it could not be opened.
2023-04-24 12:35:09 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2023-04-24 12:35:09 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2023-04-24 12:35:09 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2023-04-24 12:35:09 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2023-04-24 12:35:09 0 [Note] InnoDB: Waiting for purge to start
2023-04-24 12:35:09 0 [Note] InnoDB: 10.4.22 started; log sequence number 1329594297; transaction id 1242829
2023-04-24 12:35:09 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2023-04-24 12:35:09 0 [Note] Plugin 'FEEDBACK' is disabled.
2023-04-24 12:35:09 0 [Note] Server socket created on IP: '::'.
2023-04-24 12:35:09 0 [Note] InnoDB: Buffer pool(s) load completed at 230424 12:35:09
2023-04-24 12:35:09 7 [Note] Reading Master_info: 'master-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' Relay_info:'relay-log-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info'
2023-04-24 12:35:09 7 [Warning] Neither --relay-log nor --relay-log-index were used; so replication may break when this MariaDB server acts as a replica and has its hostname changed. Please use '--log-basename=#' or '--relay-log=mysql-relay-bin' to avoid this problem.
2023-04-24 12:35:09 7 [ERROR] log 2023-04-21 12:13:53 7 [Note] Initialized Master_info from 'master-2023@002d04@002d20@002014@003a27@003a23@00200@0020@ listed in the index, but failed to stat@0020master_info@0020entries@0020succeeded@000d.info'
2023-04-24 12:35:09 7 [ERROR] Error counting relay log space
2023-04-24 12:35:09 7 [ERROR] Initialized Master_info from 'master-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020reading@0020of@0020all@0020master_info@0020entries@0020succeeded@000d.info' failed
' to hash table5:09 7 [Note] Added new Master_info '2023-04-20 14:27:23 0 [Note] Reading of all Master_info entries succeeded
2023-04-24 12:35:09 7 [Note] Reading Master_info: 'master-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info' Relay_info:'relay-log-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
2023-04-24 12:35:09 7 [Note] Initialized Master_info from 'master-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.info'
' to hash table5:09 7 [Note] Added new Master_info '2023-04-20 14:27:23 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4hash table
'023-04-24 12:35:09 7 [Note] Started replication for '2023-04-20 14:27:23 0 [Note] Added new Master_info '' to hash table
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020added@0020new@0020master_info@0020@0027@0027@0020to@0020hash@0020table@000d.000001' position: 4
2023-04-24 12:35:09 7 [Note] Reading Master_info: 'master-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info' Relay_info:'relay-log-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
': Slave I/O thread killed while connecting to master:23 0 [Note] Added new Master_info '' to hash table
': Slave I/O thread exiting, read up to log 'FIRST', position 4e] Added new Master_info '' to hash table
': master was :3306 8 [Note] Master '2023-04-20 14:27:23 0 [Note] Added new Master_info '' to hash table
2023-04-24 12:35:09 7 [Note] Initialized Master_info from 'master-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.info'
' to hash table5:09 7 [Note] Added new Master_info '2023-04-20 14:27:23 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4xe: ready for connections.
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
'023-04-24 12:35:09 7 [Note] Started replication for '2023-04-20 14:27:23 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2023@002d04@002d20@002014@003a27@003a23@00200@0020@005bnote@005d@0020c@003a@005cxampp@005cmysql@005cbin@005cmysqld@002eexe@003a@0020ready@0020for@0020connections@002e@000d.000015' position: 4
': Slave I/O thread killed while connecting to master7:23 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2023-04-24 12:35:09 7 [Note] Reading Master_info: 'master-version@003a@0020@002710@002e4@002e22@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info' Relay_info:'relay-log-version@003a@0020@002710@002e4@002e22@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
': Slave I/O thread exiting, read up to log 'FIRST', position 4te] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
': master was :3306 10 [Note] Master '2023-04-20 14:27:23 0 [Note] c:\xampp\mysql\bin\mysqld.exe: ready for connections.
2023-04-24 12:35:09 7 [Note] Initialized Master_info from 'master-version@003a@0020@002710@002e4@002e22@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.info'
' to hash table5:09 7 [Note] Added new Master_info 'Version: '10.4.22-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4adb.org binary distribution
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
'023-04-24 12:35:09 7 [Note] Started replication for 'Version: '10.4.22-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave I/O thread killed while connecting to master22-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-version@003a@0020@002710@002e4@002e22@002dmariadb@0027@0020@0020socket@003a@0020@0027@0027@0020@0020port@003a@00203306@0020@0020mariadb@002eorg@0020binary@0020distribution@000d.000006' position: 4
2023-04-24 12:35:09 0 [Warning] Reading of some Master_info entries failed
': Slave I/O thread exiting, read up to log 'FIRST', position 4' socket: '' port: 3306 mariadb.org binary distribution
2023-04-24 12:35:09 0 [ERROR] Failed to initialize multi master structures
': master was :3306 12 [Note] Master 'Version: '10.4.22-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
2023-04-24 12:35:09 0 [ERROR] Aborting
': Error in Log_event::read_log_event(): 'Event truncated', data_len: 807411764, event_type: 45hash table
': Error reading relay log event: slave SQL thread aborted because of I/O errorster_info '' to hash table
Warning: Memory not freed: 16824