Schau mal nach ob du genug Speicher hast mit df -h das hatte jemand mal den ich geholfen hatte bei ihn war kein Speicher zur Verfügung mehr.
Bitte melden Sie sich an, um diesen Anhang zu sehen.
Diese Fehlermeldung zieht sich durch den Logfile:
Code
- 2023-07-01 02:02:10 80177f000 InnoDB: Error: table 'common/priv_settings'
- InnoDB: in InnoDB data dictionary has tablespace id 7,
- InnoDB: but a tablespace with that id does not exist. There is
- InnoDB: a tablespace of name common/priv_settings and id 16, though. Have
- InnoDB: you deleted or moved .ibd files?
- InnoDB: Please refer to
- InnoDB: http://dev.mysql.com/doc/refman/5.6/en/innodb-troubleshooting-datadict.html
- InnoDB: for how to resolve the issue.
Hab die table jetzt gefixt. Neuer Log:
Code
- 230701 17:50:02 mysqld_safe Logging to '/var/db/mysql/cloud619522.fastpipe.io.err'.
- 230701 17:50:02 mysqld_safe Starting mysqld daemon with databases from /var/db/mysql
- 2023-07-01 17:50:02 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
- 2023-07-01 17:50:02 0 [Note] /usr/local/libexec/mysqld (mysqld 5.6.51) starting as process 2140 ...
- 2023-07-01 17:50:02 2140 [Note] Plugin 'FEDERATED' is disabled.
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Using atomics to ref count buffer pool pages
- 2023-07-01 17:50:02 2140 [Note] InnoDB: The InnoDB memory heap is disabled
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Memory barrier is not used
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Compressed tables use zlib 1.2.12
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Not using CPU crc32 instructions
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Initializing buffer pool, size = 128.0M
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Completed initialization of buffer pool
- 2023-07-01 17:50:02 2140 [Note] InnoDB: The first specified data file ./ibdata1 did not exist: a new database to be created!
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Setting file ./ibdata1 size to 12 MB
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Database physically writes the file full: wait...
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Setting log file ./ib_logfile101 size to 48 MB
- 2023-07-01 17:50:02 2140 [Note] InnoDB: Setting log file ./ib_logfile1 size to 48 MB
- 2023-07-01 17:50:03 2140 [Note] InnoDB: Renaming log file ./ib_logfile101 to ./ib_logfile0
- 2023-07-01 17:50:03 2140 [Warning] InnoDB: New log files created, LSN=45781
- 2023-07-01 17:50:03 2140 [Note] InnoDB: Doublewrite buffer not found: creating new
- 2023-07-01 17:50:03 2140 [Note] InnoDB: Doublewrite buffer created
- 2023-07-01 17:50:03 2140 [Note] InnoDB: 128 rollback segment(s) are active.
- 2023-07-01 17:50:03 2140 [Warning] InnoDB: Creating foreign key constraint system tables.
- 2023-07-01 17:50:03 2140 [Note] InnoDB: Foreign key constraint system tables created
- 2023-07-01 17:50:03 2140 [Note] InnoDB: Creating tablespace and datafile system tables.
- 2023-07-01 17:50:03 2140 [Note] InnoDB: Tablespace and datafile system tables created.
- 2023-07-01 17:50:03 2140 [Note] InnoDB: Waiting for purge to start
- 2023-07-01 17:50:03 2140 [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-07-01 17:50:03 2140 [Warning] World-writable config file './auto.cnf' has been removed.
- 2023-07-01 17:50:03 2140 [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: f14ce3e1-1826-11ee-9b03-00091f6dd229.
- 2023-07-01 17:50:03 2140 [Note] RSA private key file not found: /var/db/mysql//private_key.pem. Some authentication plugins will not work.
- 2023-07-01 17:50:03 2140 [Note] RSA public key file not found: /var/db/mysql//public_key.pem. Some authentication plugins will not work.
- 2023-07-01 17:50:03 2140 [Note] Server hostname (bind-address): '*'; port: 3306
- 2023-07-01 17:50:03 2140 [Note] IPv6 is available.
- 2023-07-01 17:50:03 2140 [Note] - '::' resolves to '::';
- 2023-07-01 17:50:03 2140 [Note] Server socket created on IP: '::'.
- 2023-07-01 17:50:03 2140 [Warning] Insecure configuration for --pid-file: Location '/var/db/mysql' in the path is accessible to all OS users. Consider choosing a different directory.
- 2023-07-01 17:50:03 2140 [Note] Event Scheduler: Loaded 0 events
- 2023-07-01 17:50:03 2140 [Note] /usr/local/libexec/mysqld: ready for connections.
- Version: '5.6.51' socket: '/tmp/mysql.sock' port: 3306 Source distribution
- 230701 17:50:33 mysqld_safe mysqld restarted
- 230701 17:50:44 mysqld_safe mysqld from pid file /var/db/mysql/cloud619522.fastpipe.io.pid ended
DB Syserr ist derselbe Fehler wie vorher. Leider keine .core Datei