Hallo Com,
vlt kann mir einer von euch helfen, habe immer mal wieder das Problem das der SQL Server crascht.... wäre erstmal nicht schlimm, nur finde ich den Grund dafür leider nicht.
Der Server läuft und läuft und läuft und iwann kann man nicht mehr auf die DB zugreifen und auch nicht mehr mit dem Client einloggen.
Wenn man nun versucht den SQL neu zu starten, bekommt man die Meldung das dieser nicht mehr läuft. (Restart)
Hier mal ein Screen was bei starten der Files gezeigt wird....
Bitte melden Sie sich an, um diesen Anhang zu sehen.
Habe noch den Log des SQL Server angehängt. Ich hoffe das mir einer von euch helfen kann.
Vielen dank schonmal.
Code
- 2018-09-28 23:32:31 722 [Warning] IP address '185.234.219.169' could not be resolved: hostname nor servname provided, or not known
- 2018-09-29 02:50:00 722 [Warning] IP address '211.218.126.142' could not be resolved: hostname nor servname provided, or not known
- 180929 03:03:32 mysqld_safe mysqld restarted
- 2018-09-29 03:03:36 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2018-09-29 03:03:36 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.41) starting as process 2313 ...
- 2018-09-29 03:03:36 2313 [Note] Plugin 'FEDERATED' is disabled.
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2018-09-29 03:03:36 2313 [Note] InnoDB: The InnoDB memory heap is disabled
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Memory barrier is not used
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Compressed tables use zlib 1.2.11
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Not using CPU crc32 instructions
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Completed initialization of buffer pool
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Highest supported file format is Barracuda.
- 2018-09-29 03:03:36 2313 [Note] InnoDB: The log sequence numbers 1626047 and 1626047 in ibdata files do not match the log sequence number 1626057 in the ib_logfiles!
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Database was not shutdown normally!
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Starting crash recovery.
- 2018-09-29 03:03:36 2313 [Note] InnoDB: Reading tablespace information from the .ibd files...
- 2018-09-29 03:03:36 2313 [ERROR] InnoDB: Attempted to open a previously opened tablespace. Previous tablespace mysql/slave_worker_info uses space ID: 5 at filepath: ./mysql/slave_worker_info.ibd. Cannot open tablespace account/server_settings which uses space ID: 5 at filepath: ./account/server_settings.ibd
- 2018-09-29 03:03:36 803806400 InnoDB: Operating system error number 2 in a file operation.
- InnoDB: The error means the system cannot find the path specified.
- InnoDB: If you are installing InnoDB, remember that you must create
- InnoDB: directories yourself, InnoDB does not create them.
- InnoDB: Error: could not open single-table tablespace file ./account/server_settings.ibd
- InnoDB: We do not continue the crash recovery, because the table may become
- InnoDB: corrupt if we cannot apply the log records in the InnoDB log to it.
- InnoDB: To fix the problem and start mysqld:
- InnoDB: 1) If there is a permission problem in the file and mysqld cannot
- InnoDB: open the file, you should modify the permissions.
- InnoDB: 2) If the table is not needed, or you can restore it from a backup,
- InnoDB: then you can remove the .ibd file, and InnoDB will do a normal
- InnoDB: crash recovery and ignore that table.
- InnoDB: 3) If the file system or the disk is broken, and you cannot remove
- InnoDB: the .ibd file, you can set innodb_force_recovery > 0 in my.cnf
- InnoDB: and force InnoDB to continue crash recovery here.
- 180929 03:03:37 mysqld_safe mysqld from pid file /var/db/mysql/cloud604777.fastpipe.io.pid ended<img src="https://www.metin2downloads.to/cms/attachment/1989-pasted-from-clipboard-png/?thumbnail=1" class="woltlabAttachment" data-attachment-id="1989" id="wcfImgAttachment0">