Top-Themen

AppleEntwicklungHardwareInternetLinuxMicrosoftMultimediaNetzwerkeOff TopicSicherheitSonstige SystemeVirtualisierungWeiterbildungZusammenarbeit

Aktuelle Themen

Administrator.de FeedbackApache ServerAppleAssemblerAudioAusbildungAuslandBackupBasicBatch & ShellBenchmarksBibliotheken & ToolkitsBlogsCloud-DiensteClusterCMSCPU, RAM, MainboardsCSSC und C++DatenbankenDatenschutzDebianDigitiales FernsehenDNSDrucker und ScannerDSL, VDSLE-BooksE-BusinessE-MailEntwicklungErkennung und -AbwehrExchange ServerFestplatten, SSD, RaidFirewallFlatratesGoogle AndroidGrafikGrafikkarten & MonitoreGroupwareHardwareHosting & HousingHTMLHumor (lol)Hyper-VIconsIDE & EditorenInformationsdiensteInstallationInstant MessagingInternetInternet DomäneniOSISDN & AnaloganschlüsseiTunesJavaJavaScriptKiXtartKVMLAN, WAN, WirelessLinuxLinux DesktopLinux NetzwerkLinux ToolsLinux UserverwaltungLizenzierungMac OS XMicrosoftMicrosoft OfficeMikroTik RouterOSMonitoringMultimediaMultimedia & ZubehörNetzwerkeNetzwerkgrundlagenNetzwerkmanagementNetzwerkprotokolleNotebook & ZubehörNovell NetwareOff TopicOpenOffice, LibreOfficeOutlook & MailPapierkorbPascal und DelphiPeripheriegerätePerlPHPPythonRechtliche FragenRedHat, CentOS, FedoraRouter & RoutingSambaSAN, NAS, DASSchriftartenSchulung & TrainingSEOServerServer-HardwareSicherheitSicherheits-ToolsSicherheitsgrundlagenSolarisSonstige SystemeSoziale NetzwerkeSpeicherkartenStudentenjobs & PraktikumSuche ProjektpartnerSuseSwitche und HubsTipps & TricksTK-Netze & GeräteUbuntuUMTS, EDGE & GPRSUtilitiesVB for ApplicationsVerschlüsselung & ZertifikateVideo & StreamingViren und TrojanerVirtualisierungVisual StudioVmwareVoice over IPWebbrowserWebentwicklungWeiterbildungWindows 7Windows 8Windows 10Windows InstallationWindows MobileWindows NetzwerkWindows ServerWindows SystemdateienWindows ToolsWindows UpdateWindows UserverwaltungWindows VistaWindows XPXenserverXMLZusammenarbeit

Raspberry PI als Content Filter - MySQL startet nicht

Frage Linux Suse

Mitglied: killtec

killtec (Level 3) - Jetzt verbinden

28.10.2014, aktualisiert 29.10.2014, 3280 Aufrufe, 9 Kommentare

Hallo zusammen,
ich habe auf einem PI B+ ein opensuse installiert. Nun habe ich die Dienste apache, mysql und squid installiert. Squid startet automatisch. Apache2 und Mysql nicht.
1. Frage: Wie bekomme ich die Dienste Apache2 und MySQL automatisch zum starten?

2. Bekomme ich folgende Meldung beim start von MySQL:
01.
linux:/etc/rc.d # rcmysql start 
02.
/usr/sbin/rcmysql: line 19: Default-Start:: command not found 
03.
redirecting to systemctl start mysql 
04.
Job for mysql.service failed. See 'systemctl status mysql.service' and 'journalctl -xn' for details. 
05.
linux:/etc/rc.d # journalctl -xn 
06.
-- Logs begin at Thu 1970-01-01 01:00:05 CET, end at Tue 2014-10-28 18:30:20 CET. -- 
07.
Oct 28 18:30:01 linux /usr/sbin/cron[2777]: pam_unix(crond:session): session opened for user root by (uid=0) 
08.
Oct 28 18:30:02 linux systemd[1]: Starting Session c2 of user root. 
09.
-- Subject: Unit session-c2.scope has begun with start-up 
10.
-- Defined-By: systemd 
11.
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel 
12.
-- 
13.
-- Unit session-c2.scope has begun starting up. 
14.
Oct 28 18:30:02 linux systemd[1]: Started Session c2 of user root. 
15.
-- Subject: Unit session-c2.scope has finished start-up 
16.
-- Defined-By: systemd 
17.
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel 
18.
-- 
19.
-- Unit session-c2.scope has finished starting up. 
20.
-- 
21.
-- The start-up result is done. 
22.
Oct 28 18:30:02 linux /USR/SBIN/CRON[2777]: pam_unix(crond:session): session closed for user root 
23.
Oct 28 18:30:20 linux mysql[2413]: Starting service MySQL warning: /var/run/mysql/mysql.sock didn't appear within 30 seconds 
24.
Oct 28 18:30:20 linux mysql[2413]: chmod: cannot access '/var/run/mysql/mysqld.pid': No such file or directory 
25.
Oct 28 18:30:20 linux mysql[2413]: ..failed 
26.
Oct 28 18:30:20 linux systemd[1]: mysql.service: control process exited, code=exited status=1 
27.
Oct 28 18:30:20 linux systemd[1]: Failed to start LSB: Start the MySQL database server. 
28.
-- Subject: Unit mysql.service has failed 
29.
-- Defined-By: systemd 
30.
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel 
31.
-- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/be02cf6855d2428ba40df7e9d022f03d 
32.
-- 
33.
-- Unit mysql.service has failed. 
34.
-- 
35.
-- The result is failed. 
36.
Oct 28 18:30:20 linux systemd[1]: Unit mysql.service entered failed state.
habe schon im Netz gegoogelt, jedoch nichts passendes gefunden.

Danke.

Gruß
Mitglied: alaim89
28.10.2014 um 19:29 Uhr
Der automatische Start beim apache2 und mysql müsste folgender Befehl sein: chkconfig -a apache2 && chkconfig -a mysql

Gruß

alaim89
Bitte warten ..
Mitglied: killtec
28.10.2014 um 20:18 Uhr
Hi,
das hat schon mal geklappt Nur startet der mysql dienst noch nicht. (Fehler wie oben).

Aber dafür schon mal Danke

Gruß
Bitte warten ..
Mitglied: Gersen
29.10.2014 um 11:09 Uhr
Hallo,

um dem MySQL-Problem auf die Spur zu kommen, empfehle ich Dir, das Fehler-Logging einzuschalten. In /etc/my.cnf (im Bereich "[mysqld]" bzw. "[mysqld_safe]") die Zeile ergänzen:
log_error=/var/log/mysql/mysql_error.log
(schauen, ob das Verzeichnis /var/log/mysql existiert und "mysql" gehört)
, den Dienst neu starten und das Log sichten. Evtl. hier posten.

Gruß,
Gersen
Bitte warten ..
Mitglied: killtec
29.10.2014, aktualisiert um 11:15 Uhr
Hi gersen,
den Bereich [mysql_safe] gibt es bei mir nicht. Ich habe den Eintrag in der config ergänzt (ohne den mysql_safe bereich).
Der Ordner gehört mysql (drwxrwx---).
Die errorlog ist folgende:
01.
 
02.
141029 11:12:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
03.
2014-10-29 11:12:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 
04.
2014-10-29 11:12:14 3183 [Warning] Buffered warning: Performance schema disabled (reason: init failed). 
05.
 
06.
2014-10-29 11:12:14 3183 [Note] Plugin 'FEDERATED' is disabled. 
07.
2014-10-29 11:12:14 3183 [ERROR] Function 'archive' already exists 
08.
2014-10-29 11:12:14 3183 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'. 
09.
2014-10-29 11:12:17 3183 [Note] InnoDB: The InnoDB memory heap is disabled 
10.
2014-10-29 11:12:17 3183 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
11.
2014-10-29 11:12:17 3183 [Note] InnoDB: Compressed tables use zlib 1.2.8 
12.
2014-10-29 11:12:17 3183 [Note] InnoDB: Using Linux native AIO 
13.
2014-10-29 11:12:17 3183 [Note] InnoDB: Not using CPU crc32 instructions 
14.
2014-10-29 11:12:18 3183 [Note] InnoDB: Initializing buffer pool, size = 128.0M 
15.
141029 11:12:20 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 
16.
 
17.
 
Gruß
Bitte warten ..
Mitglied: Gersen
29.10.2014, aktualisiert um 13:16 Uhr
Ich habe den Verdacht, dass für MySQL zu wenig Speicher zur Verfügung steht.

Schau mal zum Beispiel hier, wie man MySQL für Low-RAM-Rechner konfigurieren kann/muss.

Gruß,
Gersen

PS: Das Verzeichnis /var/run/mysql gibt es aber, oder? - Und es gehört mysql?
Bitte warten ..
Mitglied: killtec
31.10.2014 um 12:45 Uhr
Hi,
funktioniert leider nicht

Config:
01.
[mysqld] 
02.
port            = 3306 
03.
socket          = /var/lib/mysql/mysql.sock 
04.
skip-locking 
05.
key_buffer = 16K 
06.
max_allowed_packet = 1M 
07.
table_cache = 4 
08.
sort_buffer_size = 64K 
09.
read_buffer_size = 256K 
10.
read_rnd_buffer_size = 256K 
11.
net_buffer_length = 2K 
12.
thread_stack = 64K 
13.
 
14.
# For low memory, Berkeley DB should not be used so keep skip-bdb uncommented unless required 
15.
skip-bdb 
16.
 
17.
# For low memory, InnoDB should not be used so keep skip-innodb uncommented unless required 
18.
skip-innodb 
19.
 
20.
# Uncomment the following if you are using InnoDB tables 
21.
#innodb_data_home_dir = /var/lib/mysql/ 
22.
#innodb_data_file_path = ibdata1:10M:autoextend 
23.
#innodb_log_group_home_dir = /var/lib/mysql/ 
24.
#innodb_log_arch_dir = /var/lib/mysql/ 
25.
# You can set .._buffer_pool_size up to 50 - 80 % 
26.
# of RAM but beware of setting memory usage too high 
27.
#innodb_buffer_pool_size = 16M 
28.
#innodb_additional_mem_pool_size = 2M 
29.
# Set .._log_file_size to 25 % of buffer pool size 
30.
#innodb_log_file_size = 5M 
31.
#innodb_log_buffer_size = 8M 
32.
#innodb_flush_log_at_trx_commit = 1 
33.
#innodb_lock_wait_timeout = 50 
34.
 
35.
 
36.
[mysqldump] 
37.
quick 
38.
max_allowed_packet = 16M 
39.
 
40.
[mysql] 
41.
no-auto-rehash 
42.
# Remove the next comment character if you are not familiar with SQL 
43.
#safe-updates 
44.
 
45.
[isamchk] 
46.
key_buffer = 8M 
47.
sort_buffer_size = 8M 
48.
 
49.
[myisamchk] 
50.
key_buffer = 8M 
51.
sort_buffer_size = 8M 
52.
 
53.
[mysqlhotcopy] 
54.
interactive-timeout
Fehler:
01.
linux:/etc # journalctl -xn 
02.
-- Logs begin at Thu 1970-01-01 01:00:05 CET, end at Fri 2014-10-31 12:45:01 CET. -- 
03.
Oct 31 12:39:50 linux mysql[2547]: Starting service MySQL warning: /var/lib/mysql/mysql.sock didn't appear within 30 seconds 
04.
Oct 31 12:39:50 linux mysql[2547]: chmod: cannot access '/var/run/mysql/mysqld.pid': No such file or directory 
05.
Oct 31 12:39:50 linux mysql[2547]: ..failed 
06.
Oct 31 12:39:50 linux systemd[1]: mysql.service: control process exited, code=exited status=1 
07.
Oct 31 12:39:50 linux systemd[1]: Failed to start LSB: Start the MySQL database server. 
08.
-- Subject: Unit mysql.service has failed 
09.
-- Defined-By: systemd 
10.
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel 
11.
-- Documentation: http://www.freedesktop.org/wiki/Software/systemd/catalog/be02cf6855d2428ba40df7e9d022f03d 
12.
-- 
13.
-- Unit mysql.service has failed. 
14.
-- 
15.
-- The result is failed. 
16.
Oct 31 12:39:50 linux systemd[1]: Unit mysql.service entered failed state. 
17.
Oct 31 12:45:01 linux /usr/sbin/cron[3113]: pam_unix(crond:session): session opened for user root by (uid=0) 
18.
Oct 31 12:45:01 linux systemd[1]: Starting Session c4 of user root. 
19.
-- Subject: Unit session-c4.scope has begun with start-up 
20.
-- Defined-By: systemd 
21.
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel 
22.
-- 
23.
-- Unit session-c4.scope has begun starting up. 
24.
Oct 31 12:45:01 linux systemd[1]: Started Session c4 of user root. 
25.
-- Subject: Unit session-c4.scope has finished start-up 
26.
-- Defined-By: systemd 
27.
-- Support: http://lists.freedesktop.org/mailman/listinfo/systemd-devel 
28.
-- 
29.
-- Unit session-c4.scope has finished starting up. 
30.
-- 
31.
-- The start-up result is done. 
32.
Oct 31 12:45:01 linux /USR/SBIN/CRON[3113]: pam_unix(crond:session): session closed for user root 
33.
linux:/etc #
Die Verzeichnisse haben die Berechtigungen dafür.

Gruß
Bitte warten ..
Mitglied: Gersen
01.11.2014, aktualisiert um 19:41 Uhr
Die Logs des Init-Systems helfen nicht weiter. Gibt es eine Datei /var/log/mysql/mysqld.log? - Wenn ja, was steht dort?

Und (auch wenn es unwahrscheinlich ist) prüfe bitte, ob MySQL vielleicht schon läuft:
ps -ef|grep mysql
Bitte warten ..
Mitglied: killtec
01.11.2014 um 21:11 Uhr
Hi,
also das ps ergab folgendes:
01.
linux:~ # ps -ef | grep mysql 
02.
root      3604  3542  0 21:05 pts/1    00:00:00 grep --color=auto mysql 
03.
linux:~ # ps -ef | grep mysqld 
04.
root      3606  3542  0 21:05 pts/1    00:00:00 grep --color=auto mysqld 
05.
linux:~ #
mysql_error.log:
01.
141029 11:12:10 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
02.
2014-10-29 11:12:12 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 
03.
2014-10-29 11:12:14 3183 [Warning] Buffered warning: Performance schema disabled (reason: init failed). 
04.
 
05.
2014-10-29 11:12:14 3183 [Note] Plugin 'FEDERATED' is disabled. 
06.
2014-10-29 11:12:14 3183 [ERROR] Function 'archive' already exists 
07.
2014-10-29 11:12:14 3183 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'. 
08.
2014-10-29 11:12:17 3183 [Note] InnoDB: The InnoDB memory heap is disabled 
09.
2014-10-29 11:12:17 3183 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
10.
2014-10-29 11:12:17 3183 [Note] InnoDB: Compressed tables use zlib 1.2.8 
11.
2014-10-29 11:12:17 3183 [Note] InnoDB: Using Linux native AIO 
12.
2014-10-29 11:12:17 3183 [Note] InnoDB: Not using CPU crc32 instructions 
13.
2014-10-29 11:12:18 3183 [Note] InnoDB: Initializing buffer pool, size = 128.0M 
14.
141029 11:12:20 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 
15.
141029 15:28:01 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
16.
141029 15:28:03 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 
17.
141029 16:19:53 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
18.
141029 16:19:57 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 
19.
141030 06:24:35 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
20.
2014-10-30 06:24:38 0 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 
21.
2014-10-30 06:24:38 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 
22.
2014-10-30 06:24:41 2228 [Warning] Buffered warning: Performance schema disabled (reason: init failed). 
23.
 
24.
2014-10-30 06:24:42 2228 [Note] Plugin 'FEDERATED' is disabled. 
25.
2014-10-30 06:24:43 2228 [ERROR] Function 'archive' already exists 
26.
2014-10-30 06:24:43 2228 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'. 
27.
2014-10-30 06:24:48 2228 [Note] InnoDB: The InnoDB memory heap is disabled 
28.
2014-10-30 06:24:48 2228 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
29.
2014-10-30 06:24:48 2228 [Note] InnoDB: Compressed tables use zlib 1.2.8 
30.
2014-10-30 06:24:48 2228 [Note] InnoDB: Using Linux native AIO 
31.
2014-10-30 06:24:48 2228 [Note] InnoDB: Not using CPU crc32 instructions 
32.
2014-10-30 06:24:51 2228 [Note] InnoDB: Initializing buffer pool, size = 128.0M 
33.
141030 06:24:54 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 
34.
141031 06:53:30 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
35.
2014-10-31 06:53:33 0 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 
36.
2014-10-31 06:53:34 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 
37.
2014-10-31 06:53:39 2477 [Warning] Buffered warning: Performance schema disabled (reason: init failed). 
38.
 
39.
2014-10-31 06:53:39 2477 [Note] Plugin 'FEDERATED' is disabled. 
40.
2014-10-31 06:53:40 2477 [ERROR] Function 'archive' already exists 
41.
2014-10-31 06:53:40 2477 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'. 
42.
2014-10-31 06:53:45 2477 [Note] InnoDB: The InnoDB memory heap is disabled 
43.
2014-10-31 06:53:45 2477 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
44.
2014-10-31 06:53:45 2477 [Note] InnoDB: Compressed tables use zlib 1.2.8 
45.
2014-10-31 06:53:45 2477 [Note] InnoDB: Using Linux native AIO 
46.
2014-10-31 06:53:45 2477 [Note] InnoDB: Not using CPU crc32 instructions 
47.
2014-10-31 06:53:46 2477 [Note] InnoDB: Initializing buffer pool, size = 128.0M 
48.
141031 06:53:48 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 
49.
141031 12:05:33 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
50.
2014-10-31 12:05:35 0 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 
51.
2014-10-31 12:05:37 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 
52.
2014-10-31 12:05:37 2247 [Warning] Buffered warning: Performance schema disabled (reason: init failed). 
53.
 
54.
2014-10-31 12:05:37 2247 [Note] Plugin 'FEDERATED' is disabled. 
55.
2014-10-31 12:05:37 2247 [ERROR] Function 'archive' already exists 
56.
2014-10-31 12:05:37 2247 [ERROR] Couldn't load plugin named 'archive' with soname 'ha_archive.so'. 
57.
2014-10-31 12:05:38 2247 [Note] InnoDB: The InnoDB memory heap is disabled 
58.
2014-10-31 12:05:38 2247 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins 
59.
2014-10-31 12:05:38 2247 [Note] InnoDB: Compressed tables use zlib 1.2.8 
60.
2014-10-31 12:05:38 2247 [Note] InnoDB: Using Linux native AIO 
61.
2014-10-31 12:05:38 2247 [Note] InnoDB: Not using CPU crc32 instructions 
62.
2014-10-31 12:05:38 2247 [Note] InnoDB: Initializing buffer pool, size = 128.0M 
63.
InnoDB: mmap(135987200 bytes) failed; errno 12 
64.
2014-10-31 12:05:38 2247 [ERROR] InnoDB: Cannot allocate memory for the buffer pool 
65.
2014-10-31 12:05:38 2247 [ERROR] Plugin 'InnoDB' init function returned error. 
66.
2014-10-31 12:05:38 2247 [ERROR] Plugin 'InnoDB' registration as a STORAGE ENGINE failed. 
67.
2014-10-31 12:05:38 2247 [ERROR] /usr/sbin/mysqld: unknown variable 'table_cache=4' 
68.
2014-10-31 12:05:38 2247 [ERROR] Aborting 
69.
 
70.
2014-10-31 12:05:38 2247 [Note] Binlog end 
71.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'partition' 
72.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_DATAFILES' 
73.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_TABLESPACES' 
74.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN_COLS' 
75.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_FOREIGN' 
76.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_FIELDS' 
77.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_COLUMNS' 
78.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_INDEXES' 
79.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_TABLESTATS' 
80.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_SYS_TABLES' 
81.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_FT_INDEX_TABLE' 
82.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_FT_INDEX_CACHE' 
83.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_FT_CONFIG' 
84.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_FT_BEING_DELETED' 
85.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_FT_DELETED' 
86.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_FT_DEFAULT_STOPWORD' 
87.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_METRICS' 
88.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_BUFFER_POOL_STATS' 
89.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE_LRU' 
90.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_BUFFER_PAGE' 
91.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX_RESET' 
92.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_CMP_PER_INDEX' 
93.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_CMPMEM_RESET' 
94.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_CMPMEM' 
95.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_CMP_RESET' 
96.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_CMP' 
97.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_LOCK_WAITS' 
98.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_LOCKS' 
99.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'INNODB_TRX' 
100.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'BLACKHOLE' 
101.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'ARCHIVE' 
102.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'PERFORMANCE_SCHEMA' 
103.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'MyISAM' 
104.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'CSV' 
105.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'MEMORY' 
106.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'MRG_MYISAM' 
107.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'sha256_password' 
108.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'mysql_old_password' 
109.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'mysql_native_password' 
110.
2014-10-31 12:05:38 2247 [Note] Shutting down plugin 'binlog' 
111.
2014-10-31 12:05:38 2247 [Note] /usr/sbin/mysqld: Shutdown complete 
112.
 
113.
141031 12:05:39 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended 
114.
141031 12:14:03 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 
115.
2014-10-31 12:14:07 0 [Warning] option 'thread_stack': unsigned value 65536 adjusted to 131072 
116.
2014-10-31 12:14:08 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). 
117.
141031 12:14:12 mysqld_safe mysqld from pid file /var/run/mysql/mysqld.pid ended
Ich habe den Conten Filter getestet, er funktioniert auch ohne den mysql, so lasse ich ihn einfach aus.
Wenn du noch eine Idee hast, lass es mich wissen, ich versuche dann das weiter zu debuggen

Schönes Wochenende

Gruß
Bitte warten ..
Mitglied: Gersen
01.11.2014, aktualisiert um 23:45 Uhr
Na, da
InnoDB: Cannot allocate memory for the buffer pool
haben wir doch den Übeltäter.
Der DB-Engine fehlt Arbeitsspeicher. Es gibt zwei Lösungsansätze bzw. -versuche:

1. Versuch mal, in der Konfigurationsdatei (my.cnf) die Option
innodb_use_sys_malloc = 0
unterzubringen.

2. In der Konfig den Wert für "innodb_buffer_pool_size" (niedriger) zu setzen.

3. Andernfalls wäre SWAP noch eine Möglichkeit....

Auch 'n schönes WE!
Bitte warten ..
Neuester Wissensbeitrag
Ähnliche Inhalte
Ubuntu
Open VPN auf Raspberry PI 2 (4)

Frage von Hector-User zum Thema Ubuntu ...

Apache Server
gelöst Raspberry Pi 3 Owncloud installieren (4)

Frage von bestelitt zum Thema Apache Server ...

Erkennung und -Abwehr
gelöst IT-Sicherheit für eigenen Raspberry Pi Webserver im Heimnetzwerk erhöhen (19)

Frage von mastermaiksen zum Thema Erkennung und -Abwehr ...

Heiß diskutierte Inhalte
Windows Userverwaltung
Ausgeschiedene Mitarbeiter im Unternehmen - was tun mit den AD Konten? (32)

Frage von patz223 zum Thema Windows Userverwaltung ...

LAN, WAN, Wireless
FritzBox, zwei Server, verschiedene Netze (21)

Frage von DavidGl zum Thema LAN, WAN, Wireless ...

Viren und Trojaner
Aufgepasst: Neue Ransomware Goldeneye verbreitet sich rasant (20)

Link von Penny.Cilin zum Thema Viren und Trojaner ...

Windows Netzwerk
Windows 10 RDP geht nicht (18)

Frage von Fiasko zum Thema Windows Netzwerk ...