• datenbank probleme

      Hallo,
      bringen tut das Auslagern der DB i.d.R. nur was, wenn du die (wenige) [lexicon]Performance[/lexicon] sparen willst.
      Hoste die DB lieber auf deinem Server.

      Poste doch hier bitte deine Logs ([lexicon]extDB[/lexicon], Server- und Client-RPT). Ohne die läuft hier nichts.

      Wenn ich etwas missverstanden habe, hoppala

      Hallo,

      Die Datenbank auszulagern ist nicht empfehlenswert und ist meist ein Sicherheitsrisiko. Bitte poste deine logs. (extDB2- und Serverlog)

      Mit freundliche Grüßen

      Lukas B.

      _______________________________________________
      Scripting | Mapping | Designing

      Ich verlinke dir hier einmal eine hilfreiche Informationsseite, die dich über sowas aufklärt. Außerdem solltest du - wie zehntausend mal bereits erwähnt - Logs anhängen und das Problem genauer beschreiben.

      Spoiler anzeigen


      2015-11-10 15:26:56 10fc InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
      2015-11-10 15:26:56 4348 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2015-11-10 15:26:56 4348 [Note] InnoDB: The InnoDB memory heap is disabled
      2015-11-10 15:26:56 4348 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2015-11-10 15:26:56 4348 [Note] InnoDB: Memory barrier is not used
      2015-11-10 15:26:56 4348 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2015-11-10 15:26:56 4348 [Note] InnoDB: Not using CPU crc32 instructions
      2015-11-10 15:26:56 4348 [Note] InnoDB: Initializing buffer pool, size = 16.0M
      2015-11-10 15:26:56 4348 [Note] InnoDB: Completed initialization of buffer pool
      2015-11-10 15:26:56 4348 [Note] InnoDB: Highest supported file format is Barracuda.
      2015-11-10 15:26:57 4348 [Note] InnoDB: 128 rollback segment(s) are active.
      2015-11-10 15:26:57 4348 [Note] InnoDB: Waiting for purge to start
      2015-11-10 15:26:57 4348 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.26-74.0 started; log sequence number 1835027
      2015-11-10 15:26:57 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2015-11-10 15:26:57 4348 [Note] Plugin 'FEEDBACK' is disabled.
      2015-11-10 15:26:57 4348 [Note] Server socket created on IP: '::'.
      2015-11-10 15:26:57 4348 [Note] Event Scheduler: Loaded 0 events
      2015-11-10 15:26:57 4348 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
      Version: '10.1.8-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
      2015-11-10 15:27:11 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown


      2015-11-10 15:27:11 5152 [Note] Event Scheduler: Purging the queue. 0 events
      2015-11-10 15:27:11 5732 [Note] InnoDB: FTS optimize thread exiting.
      2015-11-10 15:27:11 5152 [Note] InnoDB: Starting shutdown...
      2015-11-10 15:27:13 5152 [Note] InnoDB: Shutdown completed; log sequence number 1835037
      2015-11-10 15:27:13 5152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


      2017-01-03 16:23:36 10c InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
      2017-01-03 16:23:36 268 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.


      2017-01-03 16:23:36 268 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2017-01-03 16:23:36 268 [Note] InnoDB: The InnoDB memory heap is disabled
      2017-01-03 16:23:36 268 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2017-01-03 16:23:36 268 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
      2017-01-03 16:23:36 268 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2017-01-03 16:23:36 268 [Note] InnoDB: Using generic crc32 instructions
      2017-01-03 16:23:36 268 [Note] InnoDB: Initializing buffer pool, size = 16.0M
      2017-01-03 16:23:36 268 [Note] InnoDB: Completed initialization of buffer pool
      2017-01-03 16:23:36 268 [Note] InnoDB: Highest supported file format is Barracuda.
      2017-01-03 16:23:36 268 [Note] InnoDB: 128 rollback segment(s) are active.
      2017-01-03 16:23:36 268 [Note] InnoDB: Creating zip_dict and zip_dict_cols system tables.
      2017-01-03 16:23:37 268 [Note] InnoDB: zip_dict and zip_dict_cols system tables created.
      2017-01-03 16:23:37 268 [Note] InnoDB: Waiting for purge to start
      2017-01-03 16:23:38 268 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.32-79.0 started; log sequence number 1835037
      2017-01-03 16:23:38 5824 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2017-01-03 16:23:38 268 [Note] Plugin 'FEEDBACK' is disabled.
      2017-01-03 16:23:38 268 [Note] Server socket created on IP: '::'.
      2017-01-03 16:23:38 268 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
      Version: '10.1.19-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
      2017-01-03 18:40:47 5188 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown


      2017-01-03 18:40:47 5188 [Note] Event Scheduler: Purging the queue. 0 events
      2017-01-03 18:40:47 4404 [Note] InnoDB: FTS optimize thread exiting.
      2017-01-03 18:40:47 5188 [Note] InnoDB: Starting shutdown...
      2017-01-03 18:40:48 5188 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2017-01-03 18:40:49 5188 [Note] InnoDB: Shutdown completed; log sequence number 2142604
      2017-01-03 18:40:49 5188 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


      2017-01-04 15:38:10 9b4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
      2017-01-04 15:38:10 2484 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.


      2017-01-04 15:38:10 2484 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2017-01-04 15:38:10 2484 [Note] InnoDB: The InnoDB memory heap is disabled
      2017-01-04 15:38:10 2484 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2017-01-04 15:38:10 2484 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
      2017-01-04 15:38:10 2484 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2017-01-04 15:38:10 2484 [Note] InnoDB: Using generic crc32 instructions
      2017-01-04 15:38:10 2484 [Note] InnoDB: Initializing buffer pool, size = 16.0M
      2017-01-04 15:38:10 2484 [Note] InnoDB: Completed initialization of buffer pool
      2017-01-04 15:38:11 2484 [Note] InnoDB: Highest supported file format is Barracuda.
      2017-01-04 15:38:24 2484 [Note] InnoDB: 128 rollback segment(s) are active.
      2017-01-04 15:38:24 2484 [Note] InnoDB: Waiting for purge to start
      2017-01-04 15:38:24 2484 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.32-79.0 started; log sequence number 2142604
      2017-01-04 15:38:24 2440 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2017-01-04 15:38:25 2484 [Note] Plugin 'FEEDBACK' is disabled.
      2017-01-04 15:38:25 2484 [Note] Server socket created on IP: '::'.
      2017-01-04 15:38:26 2484 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
      Version: '10.1.19-MariaDB' socket: '' port: 3306 mariadb.org binary distribution
      2017-01-06 16:31:49 3152 [Note] C:\xampp\mysql\bin\mysqld.exe: Normal shutdown


      2017-01-06 16:31:49 3152 [Note] Event Scheduler: Purging the queue. 0 events
      2017-01-06 16:31:49 1880 [Note] InnoDB: FTS optimize thread exiting.
      2017-01-06 16:31:49 3152 [Note] InnoDB: Starting shutdown...
      2017-01-06 16:31:49 3152 [Note] InnoDB: Waiting for page_cleaner to finish flushing of buffer pool
      2017-01-06 16:31:51 3152 [Note] InnoDB: Shutdown completed; log sequence number 2142614
      2017-01-06 16:31:51 3152 [Note] C:\xampp\mysql\bin\mysqld.exe: Shutdown complete


      2017-01-06 16:31:56 de4 InnoDB: Warning: Using innodb_additional_mem_pool_size is DEPRECATED. This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
      2017-01-06 16:31:56 3556 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.


      2017-01-06 16:31:56 3556 [Note] InnoDB: Using mutexes to ref count buffer pool pages
      2017-01-06 16:31:56 3556 [Note] InnoDB: The InnoDB memory heap is disabled
      2017-01-06 16:31:56 3556 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
      2017-01-06 16:31:56 3556 [Note] InnoDB: _mm_lfence() and _mm_sfence() are used for memory barrier
      2017-01-06 16:31:56 3556 [Note] InnoDB: Compressed tables use zlib 1.2.3
      2017-01-06 16:31:56 3556 [Note] InnoDB: Using generic crc32 instructions
      2017-01-06 16:31:56 3556 [Note] InnoDB: Initializing buffer pool, size = 16.0M
      2017-01-06 16:31:56 3556 [Note] InnoDB: Completed initialization of buffer pool
      2017-01-06 16:31:57 3556 [Note] InnoDB: Highest supported file format is Barracuda.
      2017-01-06 16:31:58 3556 [Note] InnoDB: 128 rollback segment(s) are active.
      2017-01-06 16:31:58 3556 [Note] InnoDB: Waiting for purge to start
      2017-01-06 16:31:58 3556 [Note] InnoDB: Percona XtraDB (Percona – The Database Performance Experts) 5.6.32-79.0 started; log sequence number 2142614
      2017-01-06 16:31:59 3656 [Note] InnoDB: Dumping buffer pool(s) not yet started
      2017-01-06 16:31:59 3556 [Note] Plugin 'FEEDBACK' is disabled.
      2017-01-06 16:31:59 3556 [Note] Server socket created on IP: '::'.
      2017-01-06 16:31:59 3556 [Note] C:\xampp\mysql\bin\mysqld.exe: ready for connections.
      Version: '10.1.19-MariaDB' socket: '' port: 3306 mariadb.org binary distribution

      Das sieht so aus als erstellt er den MySQL Server nicht richtig

      Zitat von SmokeTV

      2017-01-06 16:31:56 3556 [Note] InnoDB: innodb_empty_free_list_algorithm has been changed to legacy because of small buffer pool size. In order to use backoff, increase buffer pool at least up to 20MB.

      Also Du solltest auf jeden Fall mal die Konfig der DB anpassen und den Speicher von 16MB auf 20 erhöhen. Dann sieht es für mich erstmal auch so aus als ob da noch ein Fehler in der DB Konfig ist. Du startest die DB ohne IP und Port. Hast Du schon mal versucht mit einen DB-Tool an die DB ranzukommen? Normalerweise ist bei der Installation ein PHPMyAdmin dabei zum anlegen von DBs.

      Hallo,

      @moeck hat recht. Wenn alles nicht geht und du noch keine daten auf der DB hast, würde ich den DB Server mal komplet runterwerfen und neu installieren den für mich sieht es so aus, als wenn etwas bei der installation schief gelaufen ist.

      Mit freundliche Grüßen

      Lukas B.

      _______________________________________________
      Scripting | Mapping | Designing