SQL startet nicht

smark

Neuer Benutzer
Beiträge
2
ICH HABE EIN Problem;

sql STARTET NICHT:

kann MIR JEMAND HELFEN?

FOLGENDER Fehler.

InnoDB: using atomic writes.
2019-10-12 17:20:54 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-12 17:20:54 0 [Note] InnoDB: Uses event mutexes
2019-10-12 17:20:54 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-12 17:20:54 0 [Note] InnoDB: Number of pools: 1
2019-10-12 17:20:54 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-12 17:20:54 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-12 17:20:54 0 [Note] InnoDB: Completed initialization of buffer pool
2019-10-12 17:20:54 0 [Note] InnoDB: 128 out of 128 rollback segments are active.
2019-10-12 17:20:55 0 [Note] InnoDB: Creating shared tablespace for temporary tables
2019-10-12 17:20:55 0 [Note] InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
2019-10-12 17:20:55 0 [Note] InnoDB: File 'C:\xampp\mysql\data\ibtmp1' size is now 12 MB.
2019-10-12 17:20:55 0 [Note] InnoDB: Waiting for purge to start
2019-10-12 17:20:55 0 [Note] InnoDB: 10.4.8 started; log sequence number 294606; transaction id 138
2019-10-12 17:20:55 0 [Note] InnoDB: Loading buffer pool(s) from C:\xampp\mysql\data\ib_buffer_pool
2019-10-12 17:20:55 0 [Note] Plugin 'FEEDBACK' is disabled.
2019-10-12 17:20:55 0 [Note] Server socket created on IP: '::'.
InnoDB: using atomic writes.
2019-10-13 17:51:09 0 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2019-10-13 17:51:09 0 [Note] InnoDB: Uses event mutexes
2019-10-13 17:51:09 0 [Note] InnoDB: Compressed tables use zlib 1.2.11
2019-10-13 17:51:09 0 [Note] InnoDB: Number of pools: 1
2019-10-13 17:51:09 0 [Note] InnoDB: Using SSE2 crc32 instructions
2019-10-13 17:51:09 0 [Note] InnoDB: Initializing buffer pool, total size = 16M, instances = 1, chunk size = 16M
2019-10-13 17:51:09 0 [Note] InnoDB: Completed initialization of buffer pool
 
Werbung:
Das ist es leider nicht.


hatte den alten log kopiert.

habe diesen Fehler....

2020-02-10 15:07:39 7 [Note] Reading Master_info: 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005csb@005c00kalkmat@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005csb@005c00kalkmat@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
2020-02-10 15:07:39 29 [Note] Master '2020-02-07 13:28:29 17 [Warning] Checking table: '.\sb\00beleg'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d02@002d07@002013@003a28@003a29@002017@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00beleg@0027@000d.000037' position: 4
2020-02-10 15:07:39 28 [ERROR] Master '2020-02-07 13:28:29 17 [Warning] Checking table: '.\sb\00beleg'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-02-10 15:07:39 7 [ERROR] Error reading master configuration
2020-02-10 15:07:39 28 [Note] Master '2020-02-07 13:28:29 17 [Warning] Checking table: '.\sb\00beleg'
': Slave I/O thread killed while connecting to master
2020-02-10 15:07:39 7 [ERROR] Initialized Master_info from 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005csb@005c00kalkmat@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2020-02-10 15:07:39 28 [Note] Master '2020-02-07 13:28:29 17 [Warning] Checking table: '.\sb\00beleg'
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-02-10 15:07:39 7 [Note] Added new Master_info '2020-02-07 13:28:36 23 [ERROR] mysqld.exe: Table '.\sb\00kalkmat' is marked as crashed and should be repaired
' to hash table
2020-02-10 15:07:40 7 [Note] Reading Master_info: 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkmat@0027@000d.info' Relay_info:'relay-log-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkmat@0027@000d.info'
2020-02-10 15:07:40 7 [Note] Initialized Master_info from 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkmat@0027@000d.info'
2020-02-10 15:07:40 7 [Note] Added new Master_info '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkmat'
' to hash table
2020-02-10 15:07:40 30 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkmat'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-02-10 15:07:40 30 [ERROR] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkmat'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-02-10 15:07:40 30 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkmat'
': Slave I/O thread killed while connecting to master
2020-02-10 15:07:40 30 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkmat'
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-02-10 15:07:40 7 [Note] Started replication for '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkmat'
'
2020-02-10 15:07:40 7 [Note] Reading Master_info: 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005csb@005c00kalkdaten@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' Relay_info:'relay-log-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005csb@005c00kalkdaten@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info'
2020-02-10 15:07:40 7 [ERROR] Error reading master configuration
2020-02-10 15:07:40 7 [ERROR] Initialized Master_info from 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005berror@005d@0020mysqld@002eexe@003a@0020table@0020@0027@002e@005csb@005c00kalkdaten@0027@0020is@0020marked@0020as@0020crashed@0020and@0020should@0020be@0020repaired@000d.info' failed
2020-02-10 15:07:40 7 [Note] Added new Master_info '2020-02-07 13:28:36 23 [ERROR] mysqld.exe: Table '.\sb\00kalkdaten' is marked as crashed and should be repaired
' to hash table
2020-02-10 15:07:40 7 [Note] Reading Master_info: 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkdaten@0027@000d.info' Relay_info:'relay-log-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkdaten@0027@000d.info'
2020-02-10 15:07:40 31 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkmat'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkmat@0027@000d.000037' position: 4
2020-02-10 15:07:40 7 [Note] Initialized Master_info from 'master-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkdaten@0027@000d.info'
2020-02-10 15:07:40 7 [Note] Added new Master_info '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkdaten'
' to hash table
2020-02-10 15:07:40 32 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkdaten'
': Slave I/O thread: Start asynchronous replication to master '@:3306' in log '' at position 4
2020-02-10 15:07:40 7 [Note] Started replication for '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkdaten'
'
2020-02-10 15:07:40 33 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkdaten'
': Slave SQL thread initialized, starting replication in log 'FIRST' at position 0, relay log '.\mysql-relay-bin-2020@002d02@002d07@002013@003a28@003a36@002023@0020@005bwarning@005d@0020checking@0020table@003a@0020@0020@0020@0027@002e@005csb@005c00kalkdaten@0027@000d.000037' position: 4
2020-02-10 15:07:40 32 [ERROR] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkdaten'
': Slave I/O: Fatal error: Invalid (empty) username when attempting to connect to the master server. Connection attempt terminated. Internal MariaDB error code: 1593
2020-02-10 15:07:40 0 [Warning] Reading of some Master_info entries failed
2020-02-10 15:07:40 32 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkdaten'
': Slave I/O thread killed while connecting to master
2020-02-10 15:07:40 0 [ERROR] Failed to initialize multi master structures
2020-02-10 15:07:40 32 [Note] Master '2020-02-07 13:28:36 23 [Warning] Checking table: '.\sb\00kalkdaten'
': Slave I/O thread exiting, read up to log 'FIRST', position 4
2020-02-10 15:07:40 0 [ERROR] Aborting
 
  • Du bist noch immer im falschen Forum
  • Deine Multi-Master-Replikation ist kapott
  • Invalid (empty) username when attempting to connect to the master server.
  • Table '.\sb\00kalkdaten' is marked as crashed and should be repaired
 
Du bist hier im Microsoft SQL-Server Forum und nicht im ORACLE Incooperated MySQL-Server Forum. Das sind zwei völlig unterschiedliche Datenbanksysteme von verschiedenen Herrstellern.

SQL ist ein Obergriff wie z.B Auto auch.
MSSQL ist Mazda und MySQL ist Opel, klar soweit?

Gehe daher in den MySQL Forunsbereich, da wird Dir geholfen.
 
Werbung:
Zurück
Oben