Search found 1178 matches: InnoDB

Searched query: +InnoDB

Return to advanced search

Re: Doppelte Einträge

P.S.: Jetzt, wo ich das nochmal erläutert habe, kommt mir eine Idee. Das ist im SMF Forum ja ein ganz schrecklicher Primärschlüssel und da werden Strings mit Integers gemischt. Vielleicht ist das ja ein Reihenfolgeproblem, je nachdem, welcher Satz zuerst angelegt wird, ist das ein Duplicate Key oder nicht, denn möglicherweise wird in Abhängigkeit des vorhandenen Datensatzes ein anderes Casting betrieben. Möglicherweise schon im SMF Script auf PHP Ebene, möglicherweise auch in der Engine (ich weiß nicht auswendig, ob das mit InnoDB oder MyISAM läuft). Vielleicht läuft es Online auch mit MyISAM und bei mir lokal mit InnoDB, auch das könnte das Verhalten erklären.

Aber es liegt definitiv an dem schrecklichen Primärschlüssel, ich kann nicht begreifen, wie man so einen Müll programmieren kann.
by Nobbie
21. January 2016 11:59
 
Forum: MySQL
Topic: Doppelte Einträge
Replies: 6
Views: 229

Re: Doppelte Einträge

Das ist ja interessant...
Ich bin mir wohl bewusst, dass es Einstellungen gibt constraints (i.d.R. temporär) zu deaktivieren (beschrieben zum Beispiel hier: https://dev.mysql.com/doc/refman/5.7/en/optimizing-innodb-bulk-data-loading.html), doch das sollte bei Primärschlüsseln eigentlich nicht funktionieren... zumindest nicht mit der InnoDB Engine. Es kann durchaus sein, dass sich MyISAM hier weniger streng verhält...
Wieder was gelernt.

@msp:
Der gezeigte Code enthält keine Rückschlüsse auf das erwähnte Verhalten, daher liegt die Vermutung nahe, dass die Daten in der Datenbank das Problem sind.
by Altrea
21. January 2016 01:12
 
Forum: MySQL
Topic: Doppelte Einträge
Replies: 6
Views: 229

Re: Doppelte Einträge

Aus der export Datei habe ich folgendes kopiert
Code: Select all
CREATE TABLE `question` (
  `id` int(10) UNSIGNED NOT NULL,
  `content` varchar(255) CHARACTER SET utf8 NOT NULL,
  `quality` tinyint(4) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

ALTER TABLE `question`
  ADD PRIMARY KEY (`id`),
  ADD UNIQUE KEY `content` (`content`);

ALTER TABLE `question`
  MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=853

Der Quellcode ist auch denkbar einfach gehalten.

Code: Select all
$_db = new mysqli('localhost','root','','m_quest');
$_db->set_charset('utf8');
header('Content-Type: text/html; charset=utf-8');

$res = $_db->query("SELECT * FROM question");
while($row = $res->fetch_object()){
   echo "<a href='showQuestion.php?id={$row->id}'>{$row->content}</a><br>";
}

Der Eintrag stimmt sowohl in id als auch in content exakt überein. in PHPmyAdmin konnte ich (bisher) keine doppelten vorfinden.
Gerade deswegen kann ich mir das nicht erklären.
Ich habe lange Zeit gar nichts mehr mit PHP/MySQL gemacht aber ich war es auch vorher gewohnt dass die Ergebnisse wenn keine Sortierung angegeben war meist in der Reihenfolge ausgegeben werden wie sie in der Datenbank vorliegen. Das ist jetzt auch nicht mehr der Fall. Aber das lässt sich ja vermeiden.
by msp
20. January 2016 22:58
 
Forum: MySQL
Topic: Doppelte Einträge
Replies: 6
Views: 229

Re: Performanceprobleme - PHP?

Altrea wrote:Jein. Das einfachste und sicherste wäre die Datenbank als sql Datei zu exportieren (Struktur und Daten), mit einem Editor zu öffnen, alle "ENGINE=InnoDB" ersetzen durch "ENGINE=MyISAM" und anschließend die alte Datenbank zu löschen und über die editierte sql Datei wieder neu zu erstellen.


Oder einfach jede Tabelle durch ein simples

Code: Select all
ALTER TABLE table_name ENGINE=MyISAM;


in MyISAM umwandeln.
by Nobbie
20. January 2016 14:06
 
Forum: XAMPP für Windows
Topic: Gelöst - Performanceprobleme - PHP?
Replies: 5
Views: 320

Re: Performanceprobleme - PHP?

Jein. Das einfachste und sicherste wäre die Datenbank als sql Datei zu exportieren (Struktur und Daten), mit einem Editor zu öffnen, alle "ENGINE=InnoDB" ersetzen durch "ENGINE=MyISAM" und anschließend die alte Datenbank zu löschen und über die editierte sql Datei wieder neu zu erstellen.
by Altrea
19. January 2016 20:13
 
Forum: XAMPP für Windows
Topic: Gelöst - Performanceprobleme - PHP?
Replies: 5
Views: 320

Re: Performanceprobleme - PHP?

Benutze bei MariaDB die Engine MyISAM statt InnoDB.
by Altrea
19. January 2016 14:20
 
Forum: XAMPP für Windows
Topic: Gelöst - Performanceprobleme - PHP?
Replies: 5
Views: 320

Re: HELLO ALTREA!!!

Seyi723 wrote:i have tried all known options to me.

I don't know what you have tried, but you are having a serious problem now.

At first MariaDB was starting successful:
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


Then something happens, that the control panel was thinking MariaDB is not started, it tries to start the service but there is already a process occupying port 3306
2016-01-15 11:11:50 5532 [Note] Server socket created on IP: '::'.
2016-01-15 11:11:50 5532 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.
2016-01-15 11:11:50 5532 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:11:50 5532 [ERROR] Aborting

That would have been the chance to solve the issue if done correctly.

But then you have done something terrible, so that now MariaDB cannot access and create required files:
2016-01-16 15:00:19 5456 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:00:19 5456 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2016-01-16 15:00:20 5456 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile1
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:00:20 5456 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:00:20 5456 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:00:20 5456 [ERROR] Aborting


I have no idea what you have done. So the best solution i can give you is to start over. Uninstall everything to do with XAMPP (inclusively stopping all services and processes, unregistering all services and deleting the whole xampp folder).
by Altrea
19. January 2016 10:52
 
Forum: XAMPP for Windows
Topic: HELP PLEASE: ERROR ON MYSQL!!!
Replies: 14
Views: 763

HELLO ALTREA!!!

Hello Altrea,
Please kindly help me.I'm begging you on this please as i have tried all known options to me.
I have fixed my apache and filezilla and they are now running fine. But mysql won't. Please help me.

This is the error i'm having please.Thank you.

09:16:35 [main] Initializing Control Panel
09:16:35 [main] Windows Version: Windows 8 64-bit
09:16:35 [main] XAMPP Version: 5.6.15
09:16:35 [main] Control Panel Version: 3.2.2 [ Compiled: Nov 12th 2015 ]
09:16:35 [main] Running with Administrator rights - good!
09:16:35 [main] XAMPP Installation Directory: "c:\xampp\"
09:16:35 [main] Checking for prerequisites
09:16:38 [main] All prerequisites found
09:16:38 [main] Initializing Modules
09:16:38 [Apache] XAMPP Apache Service is already running on port 443
09:16:38 [filezilla] XAMPP FileZilla Service is already running on port 21
09:16:38 [filezilla] XAMPP FileZilla Service is already running on port 14147

[/i][/i]
09:16:38 [main] Starting Check-Timer
09:16:38 [main] Control Panel Ready
09:16:44 [mysql] Attempting to start MySQL service...
09:16:47 [mysql] Status change detected: running
09:16:53 [mysql] Status change detected: stopped
09:16:53 [mysql] Error: MySQL shutdown unexpectedly.
09:16:53 [mysql] This may be due to a blocked port, missing dependencies,
09:16:53 [mysql] improper privileges, a crash, or a shutdown by another method.
09:16:53 [mysql] Press the Logs button to view error logs and check
09:16:53 [mysql] the Windows Event Viewer for more clues
09:16:53 [mysql] If you need more help, copy and post this
09:16:53 [mysql] entire log window on the forums


This is the log as well please (mysql).

[i][b]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 (http://www.percona.com) 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

2016-01-15 11:11:47 159c 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.
2016-01-15 11:11:47 5532 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 11:11:47 5532 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 11:11:47 5532 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 11:11:47 5532 [Note] InnoDB: Memory barrier is not used
2016-01-15 11:11:47 5532 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 11:11:47 5532 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 11:11:47 5532 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 11:11:47 5532 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 11:11:48 5532 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 11:11:49 5532 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 11:11:49 5532 [Note] InnoDB: Waiting for purge to start
2016-01-15 11:11:49 5532 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835037
2016-01-15 11:11:49 6140 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 11:11:49 5532 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 11:11:50 5532 [Note] Server socket created on IP: '::'.
2016-01-15 11:11:50 5532 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 11:11:50 5532 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:11:50 5532 [ERROR] Aborting

2016-01-15 11:51:40 1a34 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.
2016-01-15 11:51:40 6708 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 11:51:40 6708 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 11:51:40 6708 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 11:51:40 6708 [Note] InnoDB: Memory barrier is not used
2016-01-15 11:51:40 6708 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 11:51:40 6708 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 11:51:40 6708 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 11:51:40 6708 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 11:51:41 6708 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 11:52:17 6708 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 11:52:17 6708 [Note] InnoDB: Waiting for purge to start
2016-01-15 11:52:17 6708 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835047
2016-01-15 11:52:18 7048 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 11:52:19 6708 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 11:52:21 6708 [Note] Server socket created on IP: '::'.
2016-01-15 11:52:21 6708 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 11:52:21 6708 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:52:21 6708 [ERROR] Aborting

2016-01-15 11:59:17 134c 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.
2016-01-15 11:59:17 4940 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 11:59:17 4940 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 11:59:17 4940 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 11:59:17 4940 [Note] InnoDB: Memory barrier is not used
2016-01-15 11:59:17 4940 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 11:59:17 4940 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 11:59:17 4940 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 11:59:17 4940 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 11:59:19 4940 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 11:59:55 4940 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 11:59:55 4940 [Note] InnoDB: Waiting for purge to start
2016-01-15 11:59:55 4940 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835057
2016-01-15 11:59:57 7080 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 11:59:57 4940 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 11:59:57 4940 [Note] Server socket created on IP: '::'.
2016-01-15 11:59:57 4940 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 11:59:57 4940 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 11:59:57 4940 [ERROR] Aborting

2016-01-15 15:23:06 984 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.
2016-01-15 15:23:06 2436 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:23:06 2436 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:23:06 2436 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:23:06 2436 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:23:06 2436 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:23:06 2436 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:23:06 2436 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:23:06 2436 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:23:06 2436 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:23:07 2436 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:23:07 2436 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:23:07 2436 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835067
2016-01-15 15:23:07 3976 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:23:07 2436 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:23:07 2436 [Note] Server socket created on IP: '::'.
2016-01-15 15:23:07 2436 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:23:07 2436 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:23:07 2436 [ERROR] Aborting

2016-01-15 15:31:29 18a4 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.
2016-01-15 15:31:29 6308 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:31:29 6308 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:31:29 6308 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:31:29 6308 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:31:29 6308 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:31:29 6308 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:31:29 6308 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:31:29 6308 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:31:30 6308 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:31:30 6308 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:31:30 6308 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:31:30 6308 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835077
2016-01-15 15:31:30 1172 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:31:30 6308 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:31:30 6308 [Note] Server socket created on IP: '::'.
2016-01-15 15:31:30 6308 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:31:30 6308 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:31:30 6308 [ERROR] Aborting

2016-01-15 15:31:35 fd0 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.
2016-01-15 15:31:35 4048 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:31:35 4048 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:31:35 4048 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:31:35 4048 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:31:35 4048 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:31:35 4048 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:31:35 4048 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:31:35 4048 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:31:35 4048 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:31:36 4048 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:31:36 4048 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:31:36 4048 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835087
2016-01-15 15:31:36 6124 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:31:36 4048 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:31:36 4048 [Note] Server socket created on IP: '::'.
2016-01-15 15:31:36 4048 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:31:36 4048 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:31:36 4048 [ERROR] Aborting

2016-01-15 15:33:29 1b50 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.
2016-01-15 15:33:29 6992 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:33:29 6992 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:33:29 6992 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:33:29 6992 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:33:29 6992 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:33:29 6992 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:33:29 6992 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:33:29 6992 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:33:29 6992 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:33:30 6992 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:33:30 6992 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:33:30 6992 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835097
2016-01-15 15:33:30 1952 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:33:30 6992 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:33:30 6992 [Note] Server socket created on IP: '::'.
2016-01-15 15:33:30 6992 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:33:30 6992 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:33:30 6992 [ERROR] Aborting

2016-01-15 15:33:34 1344 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.
2016-01-15 15:33:34 4932 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:33:34 4932 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:33:34 4932 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:33:34 4932 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:33:34 4932 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:33:34 4932 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:33:34 4932 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:33:34 4932 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:33:35 4932 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:33:35 4932 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:33:35 4932 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:33:35 4932 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835107
2016-01-15 15:33:36 6392 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:33:36 4932 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:33:36 4932 [Note] Server socket created on IP: '::'.
2016-01-15 15:33:36 4932 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:33:36 4932 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:33:36 4932 [ERROR] Aborting

2016-01-15 15:54:17 c1c 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.
2016-01-15 15:54:17 3100 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:54:17 3100 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:54:17 3100 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:54:17 3100 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:54:17 3100 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:54:17 3100 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:54:17 3100 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:54:17 3100 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:54:17 3100 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:54:18 3100 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:54:18 3100 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:54:18 3100 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835117
2016-01-15 15:54:18 5972 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:54:18 3100 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:54:18 3100 [Note] Server socket created on IP: '::'.
2016-01-15 15:54:18 3100 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:54:18 3100 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:54:18 3100 [ERROR] Aborting

2016-01-15 15:56:28 bfc 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.
2016-01-15 15:56:29 3068 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:56:29 3068 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:56:29 3068 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:56:29 3068 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:56:29 3068 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:56:29 3068 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:56:29 3068 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:56:29 3068 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:56:29 3068 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:56:32 3068 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:56:32 3068 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:56:32 3068 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835127
2016-01-15 15:56:32 5800 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:56:32 3068 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:56:32 3068 [Note] Server socket created on IP: '::'.
2016-01-15 15:56:32 3068 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:56:32 3068 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:56:32 3068 [ERROR] Aborting

2016-01-15 15:57:38 f70 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.
2016-01-15 15:57:38 3952 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:57:38 3952 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:57:38 3952 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:57:38 3952 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:57:38 3952 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:57:38 3952 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:57:38 3952 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:57:38 3952 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:57:38 3952 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:57:39 3952 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:57:39 3952 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:57:39 3952 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835137
2016-01-15 15:57:39 3952 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:57:39 3640 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:57:39 3952 [Note] Server socket created on IP: '::'.
2016-01-15 15:57:39 3952 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:57:39 3952 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:57:39 3952 [ERROR] Aborting

2016-01-15 15:58:20 20c 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.
2016-01-15 15:58:20 524 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 15:58:20 524 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 15:58:20 524 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 15:58:20 524 [Note] InnoDB: Memory barrier is not used
2016-01-15 15:58:20 524 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 15:58:20 524 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 15:58:20 524 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 15:58:20 524 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 15:58:20 524 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 15:58:21 524 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 15:58:21 524 [Note] InnoDB: Waiting for purge to start
2016-01-15 15:58:21 524 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835147
2016-01-15 15:58:21 2896 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 15:58:21 524 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 15:58:21 524 [Note] Server socket created on IP: '::'.
2016-01-15 15:58:21 524 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 15:58:21 524 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 15:58:21 524 [ERROR] Aborting

2016-01-15 18:27:38 da8 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.
2016-01-15 18:27:39 3496 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 18:27:39 3496 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 18:27:39 3496 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 18:27:39 3496 [Note] InnoDB: Memory barrier is not used
2016-01-15 18:27:39 3496 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 18:27:39 3496 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 18:27:39 3496 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 18:27:39 3496 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 18:27:39 3496 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 18:27:39 3496 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 18:27:39 3496 [Note] InnoDB: Waiting for purge to start
2016-01-15 18:27:39 3496 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835157
2016-01-15 18:27:40 1680 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 18:27:40 3496 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 18:27:40 3496 [Note] Server socket created on IP: '::'.
2016-01-15 18:27:40 3496 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 18:27:40 3496 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 18:27:40 3496 [ERROR] Aborting

2016-01-15 18:39:06 1668 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.
2016-01-15 18:39:06 5736 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 18:39:06 5736 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 18:39:06 5736 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 18:39:06 5736 [Note] InnoDB: Memory barrier is not used
2016-01-15 18:39:06 5736 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 18:39:06 5736 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 18:39:06 5736 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 18:39:06 5736 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 18:39:07 5736 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 18:39:07 5736 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 18:39:07 5736 [Note] InnoDB: Waiting for purge to start
2016-01-15 18:39:08 5736 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835167
2016-01-15 18:39:08 944 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 18:39:08 5736 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 18:39:08 5736 [Note] Server socket created on IP: '::'.
2016-01-15 18:39:08 5736 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 18:39:08 5736 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 18:39:08 5736 [ERROR] Aborting

2016-01-15 22:23:52 f58 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.
2016-01-15 22:23:52 3928 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 22:23:52 3928 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 22:23:52 3928 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 22:23:52 3928 [Note] InnoDB: Memory barrier is not used
2016-01-15 22:23:52 3928 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 22:23:52 3928 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 22:23:52 3928 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 22:23:52 3928 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 22:23:53 3928 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 22:23:54 3928 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 22:23:54 3928 [Note] InnoDB: Waiting for purge to start
2016-01-15 22:23:54 3928 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835177
2016-01-15 22:23:54 7096 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 22:23:54 3928 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 22:23:55 3928 [Note] Server socket created on IP: '::'.
2016-01-15 22:23:55 3928 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 22:23:55 3928 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 22:23:55 3928 [ERROR] Aborting

2016-01-15 22:33:13 3d0 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.
2016-01-15 22:33:13 976 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-15 22:33:13 976 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-15 22:33:13 976 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-15 22:33:13 976 [Note] InnoDB: Memory barrier is not used
2016-01-15 22:33:13 976 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-15 22:33:13 976 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-15 22:33:13 976 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-15 22:33:13 976 [Note] InnoDB: Completed initialization of buffer pool
2016-01-15 22:33:13 976 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-15 22:33:14 976 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-15 22:33:14 976 [Note] InnoDB: Waiting for purge to start
2016-01-15 22:33:14 976 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835187
2016-01-15 22:33:14 976 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-15 22:33:14 976 [Note] Server socket created on IP: '::'.
2016-01-15 22:33:14 5184 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-15 22:33:14 976 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-15 22:33:14 976 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-15 22:33:14 976 [ERROR] Aborting

2016-01-16 12:59:31 1c6c 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.
2016-01-16 12:59:31 7276 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 12:59:31 7276 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 12:59:31 7276 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 12:59:31 7276 [Note] InnoDB: Memory barrier is not used
2016-01-16 12:59:31 7276 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 12:59:31 7276 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 12:59:31 7276 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 12:59:31 7276 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 12:59:31 7276 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-16 12:59:32 7276 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-16 12:59:32 7276 [Note] InnoDB: Waiting for purge to start
2016-01-16 12:59:32 7276 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835197
2016-01-16 12:59:32 6248 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-16 12:59:32 7276 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 12:59:32 7276 [Note] Server socket created on IP: '::'.
2016-01-16 12:59:32 7276 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-16 12:59:32 7276 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-16 12:59:32 7276 [ERROR] Aborting

2016-01-16 13:14:47 1d20 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.
2016-01-16 13:14:47 7456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 13:14:47 7456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 13:14:47 7456 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 13:14:47 7456 [Note] InnoDB: Memory barrier is not used
2016-01-16 13:14:47 7456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 13:14:47 7456 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 13:14:47 7456 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 13:14:47 7456 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 13:14:48 7456 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-16 13:14:48 7456 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-16 13:14:48 7456 [Note] InnoDB: Waiting for purge to start
2016-01-16 13:14:49 7456 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835207
2016-01-16 13:14:49 7224 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-16 13:14:49 7456 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 13:14:49 7456 [Note] Server socket created on IP: '::'.
2016-01-16 13:14:49 7456 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-16 13:14:49 7456 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-16 13:14:49 7456 [ERROR] Aborting

2016-01-16 14:52:27 14ec 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.
2016-01-16 14:52:27 5356 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 14:52:27 5356 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 14:52:27 5356 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 14:52:27 5356 [Note] InnoDB: Memory barrier is not used
2016-01-16 14:52:27 5356 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 14:52:27 5356 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 14:52:27 5356 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 14:52:27 5356 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 14:52:27 5356 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-16 14:52:27 5356 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-16 14:52:27 5356 [Note] InnoDB: Waiting for purge to start
2016-01-16 14:52:27 5356 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.26-74.0 started; log sequence number 1835217
2016-01-16 14:52:27 5476 [Note] InnoDB: Dumping buffer pool(s) not yet started
2016-01-16 14:52:27 5356 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 14:52:27 5356 [Note] Server socket created on IP: '::'.
2016-01-16 14:52:27 5356 [ERROR] Can't start server: Bind on TCP/IP port. Got error: 10048: Only one usage of each socket address (protocol/network address/port) is normally permitted.


2016-01-16 14:52:27 5356 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-16 14:52:27 5356 [ERROR] Aborting

2016-01-16 15:00:19 1550 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.
2016-01-16 15:00:19 5456 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:00:19 5456 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:00:19 5456 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:00:19 5456 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:00:19 5456 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:00:19 5456 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:00:19 5456 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:00:19 5456 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:00:19 5456 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:00:19 5456 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:00:19 5456 [Note] InnoDB: Setting log file C:\xampp\mysql\data\ib_logfile101 size to 5 MB
2016-01-16 15:00:20 5456 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile1
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:00:20 5456 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:00:20 5456 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:00:20 5456 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:00:20 5456 [ERROR] Aborting

2016-01-16 15:03:39 1d30 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.
2016-01-16 15:03:39 7472 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:03:39 7472 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:03:39 7472 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:03:39 7472 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:03:39 7472 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:03:39 7472 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:03:39 7472 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:03:39 7472 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:03:39 7472 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:03:39 7472 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:03:39 7472 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:03:40 7472 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-16 15:03:40 7472 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:03:40 7472 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:03:40 7472 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:03:40 7472 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:03:40 7472 [ERROR] Aborting

2016-01-16 15:04:55 1ffc 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.
2016-01-16 15:04:55 8188 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:04:55 8188 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:04:55 8188 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:04:55 8188 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:04:55 8188 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:04:55 8188 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:04:55 8188 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:04:55 8188 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:04:55 8188 [Note] InnoDB: Restoring page 0 of tablespace 0
2016-01-16 15:04:55 8188 [Warning] InnoDB: Doublewrite does not have page_no=0 of space: 0
2016-01-16 15:04:55 8188 [ERROR] InnoDB: space header page consists of zero bytes in data file C:\xampp\mysql\data\ibdata1
2016-01-16 15:04:55 8188 [ERROR] InnoDB: Could not open or create the system tablespace. If you tried to add new data files to the system tablespace, and it failed here, you should now edit innodb_data_file_path in my.cnf back to what it was, and remove the new ibdata files InnoDB created in this failed attempt. InnoDB only wrote those files full of zeros, but did not yet use them in any way. But be careful: do not remove old data files which contain your precious data!
2016-01-16 15:04:55 8188 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:04:55 8188 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:04:55 8188 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:04:55 8188 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:04:56 8188 [ERROR] Aborting

2016-01-16 15:07:53 1b2c 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.
2016-01-16 15:07:54 6956 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:07:54 6956 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:07:54 6956 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:07:54 6956 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:07:54 6956 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:07:54 6956 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:07:54 6956 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:07:54 6956 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:07:54 6956 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:07:54 6956 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:07:54 6956 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:07:54 6956 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-16 15:07:54 6956 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:07:54 6956 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:07:54 6956 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:07:54 6956 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:07:54 6956 [ERROR] Aborting

2016-01-16 15:14:19 15a8 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.
2016-01-16 15:14:19 5544 [Note] InnoDB: Using mutexes to ref count buffer pool pages
2016-01-16 15:14:19 5544 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-16 15:14:19 5544 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-16 15:14:19 5544 [Note] InnoDB: Memory barrier is not used
2016-01-16 15:14:19 5544 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-16 15:14:19 5544 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-16 15:14:19 5544 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-16 15:14:19 5544 [Note] InnoDB: Completed initialization of buffer pool
2016-01-16 15:14:19 5544 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-16 15:14:19 5544 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-16 15:14:19 5544 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-16 15:14:20 5544 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-16 15:14:20 5544 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-16 15:14:20 5544 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-16 15:14:20 5544 [Note] Plugin 'FEEDBACK' is disabled.
2016-01-16 15:14:20 5544 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-16 15:14:20 5544 [ERROR] Aborting
by Seyi723
18. January 2016 09:19
 
Forum: XAMPP for Windows
Topic: HELP PLEASE: ERROR ON MYSQL!!!
Replies: 14
Views: 763

PHPMyAdmin click options fail to be executed.

Hi everyone. Maybe you can confirm that I'm not the only one suffering this issue.

Table rows insertted in database I created are unresponsive to clicks to change their values or delete rows:

Image
Image

SELECT * FROM Database.Table WHERE ; DELETE FROM TABLE WHERE LIMIT 1;

Of course I have an error in My SQL syntax; There's no need to check the manual that corresponds to my MariaDB server version for the right syntax to use near '' at line 1, since I know reference (id=someNumber) is needed, But I thougt it should be added automatically. Should I configure something else in adittion to what I've already configured? All my Tables have their primary and unique keys.

Issue only happens with my tables in my database. System databases bring their rows for editing or even deleting them when I click their edit and delete links. Writing commands in consoles is no problem (textbox is marking invalid syntax for valid syntax, but commands still run).

I'm currently using XAMPP with PHP 7.0.2, PHPMyAdmin 4.5.3 and 10.1.9-MariaDB.
Tried new database with a single table of the ones I have: Here is the export:

CREATE TABLE Categoria( id bigint(20) NOT NULL,
orden bigint(20) NOT NULL,
activa tinyint(4) DEFAULT 1,
nombre varchar(256) NOT NULL,
detalle varchar(512) NOT NULL,
PRIMARY KEY (id),
UNIQUE KEY nombre (nombre),
UNIQUE KEY orden (orden) )ENGINE=InnoDB DEFAULT CHARSET=latin1;

INSERT INTO Categoria (id,orden,activa,nombre,detalle) VALUES (1, 1, 1, 'COBRE', 'Rradiadores, estañados y otros.'),
(2, 2, 1, 'BRONCE', 'rebaba, radiadores etc.. Se incluye al antimonio'),
(3, 3, 1, 'ALUMINIO', 'Rebaba, rines, perfiles, cables, botes, radiadores, litografías, aleaciones, etc.');

Problem persists. Maybe adding two unique keys confuses phpmyadmin.

I'm using Adminer in the meanwhile...Which is also giving me problems while using it with PHP7

Fresh Reinstall, using previous versions and similar does not help.

If you can confirm that I'm not crazy, maybe you can help reporting problem. I already did, but since PHPMyAdmin staff only tried online demo, It is clear that I'm dealing with this alone.

So, if you know I missed something, please let me know...

Thanks in advance.
by laeirbag
16. January 2016 19:45
 
Forum: XAMPP for Windows
Topic: PHPMyAdmin click options fail to be executed.
Replies: 0
Views: 175

Re: XAMPP, Mysql Error Shutdown Unexpectedly

Edit: The Windows event viewer says:

Fatal error: Can't open and lock privilege tables: Table '.\mysql\db' is marked as crashed and last (automatic?) repair failed

I have both myisam and innodb tables in the database. According to the MySQL site, REPAIR only works on Myisam tables. What works on Innodb tables?

Could anyone please provide the commands so I can manually repair?

***********************************************************

I too am having this problem. Yesterday things were operating swimmingly and I left everything running overnight. A Windows10 update then reboot occurred and now I'm getting this error message. Apache runs fine.

10:14:46 AM [mysql] Checking default ports...
10:14:46 AM [mysql] Attempting to start MySQL app...
10:14:46 AM [mysql] Executing ""d:\xampp\mysql\bin\mysqld.exe" --defaults-file="d:\xampp\mysql\bin\my.ini" --standalone"
10:14:46 AM [mysql] Return code: 0
10:14:46 AM [mysql] Status change detected: running
10:14:47 AM [mysql] Status change detected: stopped
10:14:47 AM [mysql] Error: MySQL shutdown unexpectedly.
10:14:47 AM [mysql] This may be due to a blocked port, missing dependencies,
10:14:47 AM [mysql] improper privileges, a crash, or a shutdown by another method.
10:14:47 AM [mysql] Press the Logs button to view error logs and check
10:14:47 AM [mysql] the Windows Event Viewer for more clues
10:14:47 AM [mysql] If you need more help, copy and post this
10:14:47 AM [mysql] entire log window on the forums
by eric99
16. January 2016 16:22
 
Forum: XAMPP for Windows
Topic: XAMPP, Mysql Error Shutdown Unexpectedly
Replies: 3
Views: 498

Re: MySQL unerträglich langsam

Martin66 wrote:Ich habe nicht die Spur einer Ahnung, was "InnoDB" und "MyISAM" bedeuten soll. Hat jemand einen Tipp, wo ich zu diesem Thema Hintergrundinfos finde?


Wie wäre es mit Google, mit Wikipedia usw.?
by Nobbie
15. January 2016 16:36
 
Forum: MySQL
Topic: MySQL unerträglich langsam
Replies: 5
Views: 243

Re: MySQL unerträglich langsam

Hi,

Danke für den Link - auch, wenn er mir nix gebracht hat ;-)

Inzwischen bin ich etwas schlauer geworden: Nachdem ich versehentlich eine Tabelle nicht geleert, sondern gelöscht hatte, musste ich sie mittels Import neu anlegen. Auf einmal ging alles viel schneller. Wahrscheinlicher Ursache meines Problems: Es wird langsam, wenn die Tabellen vom Typ "InnoDB" sind. Mit "MyISAM" flutscht es.

Ich habe nicht die Spur einer Ahnung, was "InnoDB" und "MyISAM" bedeuten soll. Hat jemand einen Tipp, wo ich zu diesem Thema Hintergrundinfos finde?
by Martin66
15. January 2016 16:04
 
Forum: MySQL
Topic: MySQL unerträglich langsam
Replies: 5
Views: 243

Re: My Sql Wont start

Okay. Sorry I'm in the learning phase but I don't see the problem using the MySql log file, mysql_error.log. But I've attached it below.
This option may be removed in future releases, together with the option innodb_use_sys_malloc and with the InnoDB's internal memory allocator.
160112 10:44:48 [Note] InnoDB: Using mutexes to ref count buffer pool pages
160112 10:44:48 [Note] InnoDB: The InnoDB memory heap is disabled
160112 10:44:48 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
160112 10:44:48 [Note] InnoDB: Memory barrier is not used
160112 10:44:48 [Note] InnoDB: Compressed tables use zlib 1.2.3
160112 10:44:48 [Note] InnoDB: Not using CPU crc32 instructions
160112 10:44:48 [Note] InnoDB: Initializing buffer pool, size = 16.0M
160112 10:44:48 [Note] InnoDB: Completed initialization of buffer pool
160112 10:44:48 [Note] InnoDB: Highest supported file format is Barracuda.
160112 10:44:48 [Note] InnoDB: Log scan progressed past the checkpoint lsn 1672852
160112 10:44:48 [Note] InnoDB: Database was not shutdown normally!
160112 10:44:48 [Note] InnoDB: Starting crash recovery.
160112 10:44:48 [Note] InnoDB: Reading tablespace information from the .ibd files...
160112 10:44:49 [Note] InnoDB: Restoring possible half-written data pages
160112 10:44:49 [Note] InnoDB: from the doublewrite buffer...
InnoDB: Doing recovery: scanned up to log sequence number 1672892
160112 10:44:49 [Note] InnoDB: 128 rollback segment(s) are active.
160112 10:44:49 [Note] InnoDB: Waiting for purge to start
160112 10:44:49 [Note] InnoDB: Percona XtraDB (http://www.percona.com) 5.6.22-72.0 started; log sequence number 1672892
160112 10:44:49 [Note] Plugin 'FEEDBACK' is disabled.
160112 10:44:49 [Note] Server socket created on IP: '::'.

Greatly appreciate your help.

Bruce
by bruceaj
12. January 2016 17:08
 
Forum: XAMPP for Windows
Topic: My Sql Wont start
Replies: 5
Views: 792

XAMPP, Mysql Error Shutdown Unexpectedly

Hi, my xampp keeps on giving error by saying this message in red font text whenever i tried to start mysql

Error: MySQL shutdown unexpectedly.
11:14:04 AM [mysql] This may be due to a blocked port, missing dependencies,
11:14:04 AM [mysql] improper privileges, a crash, or a shutdown by another method.
11:14:04 AM [mysql] Press the Logs button to view error logs and check
11:14:04 AM [mysql] the Windows Event Viewer for more clues
11:14:04 AM [mysql] If you need more help, copy and post this
11:14:04 AM [mysql] entire log window on the forums



I have tried many solution such as deleting the ibdata1 file and done lots of other solution found on the internet but the problem still occur


This is my log file during the problem occur

2016-01-11 10:46:49 324 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:46:49 1810 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.
2016-01-11 10:46:49 324 [Note] InnoDB: Started in read only mode
2016-01-11 10:46:49 324 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:46:49 324 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:46:49 324 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:46:49 324 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:46:49 324 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:46:49 324 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:46:49 324 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:46:49 324 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:46:49 324 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:46:49 324 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:46:49 324 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:46:49 324 [ERROR] InnoDB: Can't initiate database recovery, running in read-only-mode.
2016-01-11 10:46:49 324 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-11 10:46:49 324 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-11 10:46:49 324 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-11 10:46:49 324 [ERROR] Aborting

2016-01-11 10:46:49 324 [Note] Binlog end
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'partition'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'ARCHIVE'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'MyISAM'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'MEMORY'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'CSV'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'sha256_password'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'mysql_old_password'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'mysql_native_password'
2016-01-11 10:46:49 324 [Note] Shutting down plugin 'binlog'
2016-01-11 10:46:49 324 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-11 10:46:51 2440 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:46:51 12a0 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.
2016-01-11 10:46:51 2440 [Note] InnoDB: Started in read only mode
2016-01-11 10:46:51 2440 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:46:51 2440 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:46:51 2440 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:46:51 2440 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:46:51 2440 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:46:51 2440 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:46:51 2440 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:46:51 2440 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:46:51 2440 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:46:51 2440 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:46:51 2440 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:46:51 2440 [ERROR] InnoDB: Can't initiate database recovery, running in read-only-mode.
2016-01-11 10:46:51 2440 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-11 10:46:51 2440 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-11 10:46:51 2440 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-11 10:46:51 2440 [ERROR] Aborting

2016-01-11 10:46:51 2440 [Note] Binlog end
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'partition'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'ARCHIVE'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'MyISAM'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'MEMORY'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'CSV'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'sha256_password'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'mysql_old_password'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'mysql_native_password'
2016-01-11 10:46:51 2440 [Note] Shutting down plugin 'binlog'
2016-01-11 10:46:51 2440 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-11 10:48:39 3472 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:48:39 12a8 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.
2016-01-11 10:48:39 3472 [Note] InnoDB: Started in read only mode
2016-01-11 10:48:39 3472 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:48:39 3472 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:48:39 3472 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:48:39 3472 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:48:39 3472 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:48:39 3472 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:48:39 3472 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:48:39 3472 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:48:39 3472 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:48:39 12a8 InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:48:39 3472 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:50:15 6188 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:50:15 628 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.
2016-01-11 10:50:15 6188 [Note] InnoDB: Started in read only mode
2016-01-11 10:50:15 6188 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:50:15 6188 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:50:15 6188 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:50:15 6188 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:50:15 6188 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:50:15 6188 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:50:15 6188 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:50:15 6188 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:50:15 6188 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:50:15 628 InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:50:15 6188 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:50:30 2640 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:50:30 39c 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.
2016-01-11 10:50:30 2640 [Note] InnoDB: Started in read only mode
2016-01-11 10:50:30 2640 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:50:30 2640 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:50:30 2640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:50:30 2640 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:50:30 2640 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:50:30 2640 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:50:30 2640 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:50:30 2640 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:50:30 2640 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:50:30 39c InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:50:30 2640 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:50:31 6540 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:50:31 364 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.
2016-01-11 10:50:31 6540 [Note] InnoDB: Started in read only mode
2016-01-11 10:50:31 6540 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:50:31 6540 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:50:31 6540 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:50:31 6540 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:50:31 6540 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:50:31 6540 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:50:31 6540 [Note] InnoDB: Disabling background IO write threads.
2016-01-11 10:50:31 6540 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:50:31 6540 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:50:31 364 InnoDB: Operating system error number 2 in a file operation.
InnoDB: Some operating system error numbers are described at
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/operating-system-error-codes.html
2016-01-11 10:50:31 6540 [ERROR] InnoDB: File C:\xampp\mysql\data\ibdata1: 'open' returned OS error 71. Cannot continue operation
2016-01-11 10:51:35 5972 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:35 16b4 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.
2016-01-11 10:51:35 5972 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:35 5972 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:35 5972 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:35 5972 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:35 5972 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:35 5972 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:35 5972 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:35 5972 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:35 5972 [Note] InnoDB: The first specified data file C:\xampp\mysql\data\ibdata1 did not exist: a new database to be created!
2016-01-11 10:51:35 5972 [Note] InnoDB: Setting file C:\xampp\mysql\data\ibdata1 size to 10 MB
2016-01-11 10:51:35 5972 [Note] InnoDB: Database physically writes the file full: wait...
2016-01-11 10:51:35 5972 [ERROR] InnoDB: Cannot create C:\xampp\mysql\data\ib_logfile101
2016-01-11 10:51:35 5972 [ERROR] Plugin 'InnoDB' init function returned error.
2016-01-11 10:51:35 5972 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed.
2016-01-11 10:51:35 5972 [ERROR] Unknown/unsupported storage engine: InnoDB
2016-01-11 10:51:35 5972 [ERROR] Aborting

2016-01-11 10:51:35 5972 [Note] Binlog end
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'partition'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'ARCHIVE'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'MyISAM'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'MEMORY'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'CSV'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'sha256_password'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'mysql_old_password'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'mysql_native_password'
2016-01-11 10:51:35 5972 [Note] Shutting down plugin 'binlog'
2016-01-11 10:51:35 5972 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

2016-01-11 10:51:38 6188 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:38 b4c 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.
2016-01-11 10:51:38 6188 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:38 6188 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:38 6188 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:38 6188 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:38 6188 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:38 6188 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:38 6188 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:38 6188 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:38 6188 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:51:38 6188 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:51:38 6188 [Note] InnoDB: Database was not shutdown normally!
2016-01-11 10:51:38 6188 [Note] InnoDB: Starting crash recovery.
2016-01-11 10:51:38 6188 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-11 10:51:41 2640 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:41 d58 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.
2016-01-11 10:51:41 2640 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:41 2640 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:41 2640 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:41 2640 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:41 2640 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:41 2640 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:41 2640 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:41 2640 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:41 2640 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:51:41 2640 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:51:41 2640 [Note] InnoDB: Database was not shutdown normally!
2016-01-11 10:51:41 2640 [Note] InnoDB: Starting crash recovery.
2016-01-11 10:51:41 2640 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-11 10:51:43 2640 [Note] InnoDB: Restoring possible half-written data pages
2016-01-11 10:51:43 2640 [Note] InnoDB: from the doublewrite buffer...
2016-01-11 10:51:43 d58 InnoDB: Assertion failure in thread 3416 in file fsp0fsp.cc line 1887
InnoDB: Failing assertion: inode
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
02:51:43 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
127a500 mysqld.exe!my_thread_name()
14b392d mysqld.exe!my_mb_ctype_mb()
135c937 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
132c0f9 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13db796 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12f5356 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12ae22a mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
102a200 mysqld.exe!?ha_initialize_handlerton@@YAHPAUst_plugin_int@@@Z()
106434e mysqld.exe!?plugin_lock_by_name@@YAPAUst_plugin_int@@PAVTHD@@PBUst_mysql_lex_string@@H@Z()
1068a81 mysqld.exe!?plugin_init@@YAHPAHPAPADH@Z()
10217bb mysqld.exe!?init_common_variables@@YAHXZ()
10224c8 mysqld.exe!?win_main@@YAHHPAPAD@Z()
1022a37 mysqld.exe!?mysql_service@@YAHPAX@Z()
14ae48a mysqld.exe!my_mb_ctype_mb()
74d2338a kernel32.dll!BaseThreadInitThunk()
77079f72 ntdll.dll!RtlInitializeExceptionChain()
77079f45 ntdll.dll!RtlInitializeExceptionChain()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2016-01-11 10:51:59 6804 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:51:59 5c4 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.
2016-01-11 10:51:59 6804 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:51:59 6804 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:51:59 6804 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:51:59 6804 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:51:59 6804 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:51:59 6804 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:51:59 6804 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:51:59 6804 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:51:59 6804 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:51:59 6804 [Note] InnoDB: The log sequence numbers 0 and 0 in ibdata files do not match the log sequence number 3460453250 in the ib_logfiles!
2016-01-11 10:51:59 6804 [Note] InnoDB: Database was not shutdown normally!
2016-01-11 10:51:59 6804 [Note] InnoDB: Starting crash recovery.
2016-01-11 10:51:59 6804 [Note] InnoDB: Reading tablespace information from the .ibd files...
2016-01-11 10:51:59 6804 [Note] InnoDB: Restoring possible half-written data pages
2016-01-11 10:51:59 6804 [Note] InnoDB: from the doublewrite buffer...
2016-01-11 10:51:59 5c4 InnoDB: Assertion failure in thread 1476 in file fsp0fsp.cc line 1887
InnoDB: Failing assertion: inode
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.6/en/forcing-innodb-recovery.html
InnoDB: about forcing recovery.
02:51:59 UTC - mysqld got exception 0x80000003 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help
diagnose the problem, but since we have already crashed,
something is definitely wrong and this may fail.

key_buffer_size=16777216
read_buffer_size=262144
max_used_connections=0
max_threads=151
thread_count=0
connection_count=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133778 K bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

Thread pointer: 0x0
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
terribly wrong...
127a500 mysqld.exe!my_thread_name()
14b392d mysqld.exe!my_mb_ctype_mb()
135c937 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
132c0f9 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
13db796 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12f5356 mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
12ae22a mysqld.exe!?my_aes_create_key@@YAXPBEIPAEW4my_aes_opmode@@@Z()
102a200 mysqld.exe!?ha_initialize_handlerton@@YAHPAUst_plugin_int@@@Z()
106434e mysqld.exe!?plugin_lock_by_name@@YAPAUst_plugin_int@@PAVTHD@@PBUst_mysql_lex_string@@H@Z()
1068a81 mysqld.exe!?plugin_init@@YAHPAHPAPADH@Z()
10217bb mysqld.exe!?init_common_variables@@YAHXZ()
10224c8 mysqld.exe!?win_main@@YAHHPAPAD@Z()
1022a37 mysqld.exe!?mysql_service@@YAHPAX@Z()
14ae48a mysqld.exe!my_mb_ctype_mb()
74d2338a kernel32.dll!BaseThreadInitThunk()
77079f72 ntdll.dll!RtlInitializeExceptionChain()
77079f45 ntdll.dll!RtlInitializeExceptionChain()
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
2016-01-11 10:55:59 5924 [Note] Plugin 'FEDERATED' is disabled.
2016-01-11 10:55:59 1a08 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.
2016-01-11 10:55:59 5924 [Note] InnoDB: Using atomics to ref count buffer pool pages
2016-01-11 10:55:59 5924 [Note] InnoDB: The InnoDB memory heap is disabled
2016-01-11 10:55:59 5924 [Note] InnoDB: Mutexes and rw_locks use Windows interlocked functions
2016-01-11 10:55:59 5924 [Note] InnoDB: Memory barrier is not used
2016-01-11 10:55:59 5924 [Note] InnoDB: Compressed tables use zlib 1.2.3
2016-01-11 10:55:59 5924 [Note] InnoDB: Not using CPU crc32 instructions
2016-01-11 10:55:59 5924 [Note] InnoDB: Initializing buffer pool, size = 16.0M
2016-01-11 10:55:59 5924 [Note] InnoDB: Completed initialization of buffer pool
2016-01-11 10:55:59 5924 [Note] InnoDB: Highest supported file format is Barracuda.
2016-01-11 10:56:00 5924 [Note] InnoDB: 128 rollback segment(s) are active.
2016-01-11 10:56:00 5924 [Note] InnoDB: Waiting for purge to start
2016-01-11 10:56:00 5924 [Note] InnoDB: 5.6.20 started; log sequence number 3460453250
2016-01-11 10:56:00 5924 [Note] InnoDB: !!! innodb_force_recovery is set to 1 !!!
2016-01-11 10:56:00 5924 [Note] Server hostname (bind-address): '*'; port: 3306
2016-01-11 10:56:00 5924 [Note] IPv6 is available.
2016-01-11 10:56:00 5924 [Note] - '::' resolves to '::';
2016-01-11 10:56:00 5924 [Note] Server socket created on IP: '::'.
2016-01-11 10:56:00 5924 [ERROR] Can't start server: Bind on TCP/IP port: No such file or directory
2016-01-11 10:56:00 5924 [ERROR] Do you already have another mysqld server running on port: 3306 ?
2016-01-11 10:56:00 5924 [ERROR] Aborting

2016-01-11 10:56:00 5924 [Note] Binlog end
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'partition'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_FIELDS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_INDEXES'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_SYS_TABLES'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_FT_CONFIG'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_FT_DELETED'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_METRICS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_CMPMEM'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_CMP_RESET'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_CMP'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_LOCK_WAITS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_LOCKS'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'INNODB_TRX'
2016-01-11 10:56:00 5924 [Note] Shutting down plugin 'InnoDB'
2016-01-11 10:56:00 5924 [Note] InnoDB: FTS optimize thread exiting.
2016-01-11 10:56:00 5924 [Note] InnoDB: Starting shutdown...
2016-01-11 10:56:02 5924 [Note] InnoDB: Shutdown completed; log sequence number 3460453260
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'BLACKHOLE'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'ARCHIVE'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'MRG_MYISAM'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'MyISAM'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'MEMORY'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'CSV'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'sha256_password'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'mysql_old_password'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'mysql_native_password'
2016-01-11 10:56:02 5924 [Note] Shutting down plugin 'binlog'
2016-01-11 10:56:02 5924 [Note] c:\xampp\mysql\bin\mysqld.exe: Shutdown complete

Hope someone can help me , I am new to this :(
by farhanz95
11. January 2016 04:35
 
Forum: XAMPP for Windows
Topic: XAMPP, Mysql Error Shutdown Unexpectedly
Replies: 3
Views: 498

Re: Database Corrupted after Upgrade XAMPP 7.0

Did you backup your MySQL data?

Or did you simply install Xampp over the existing data? If you did so, you destroyed the MySQL data.

You may be lucky, as older Xampp versions did not use INNODB, but MyISAM instead. Try to switch to MyISAM in that case (google for "default_engine" and MyISAM), but do a backup first!
by Nobbie
10. January 2016 13:17
 
Forum: XAMPP for Mac OS X
Topic: Database Corrupted after Upgrade XAMPP 7.0
Replies: 1
Views: 186
PreviousNext

Return to advanced search