4

I have upgraded to mysql 5.7 using this MySQL 5.5 Update to MySQL 5.7

Since then we have been receiving 500 on all hosted websites and apache2 error log contains 

[Thu Jul 07 03:52:24.807409 2016] [core:notice] [pid 1624] AH00051: child     pid 11486 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:52:32.819761 2016] [core:notice] [pid 1624] AH00051: child pid 11482 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:52:32.819853 2016] [core:notice] [pid 1624] AH00051: child pid 11489 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:52:35.824422 2016] [core:notice] [pid 1624] AH00051: child pid 11490 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:52:42.833487 2016] [core:notice] [pid 1624] AH00051: child pid 11493 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:52:46.839680 2016] [core:notice] [pid 1624] AH00051: child pid 11494 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:52:52.847820 2016] [core:notice] [pid 1624] AH00051: child pid 11495 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:52:56.852889 2016] [core:notice] [pid 1624] AH00051: child pid 11498 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:53:06.864664 2016] [core:notice] [pid 1624] AH00051: child pid 11500 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:53:07.867806 2016] [core:notice] [pid 1624] AH00051: child pid 11504 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:53:35.899735 2016] [core:notice] [pid 1624] AH00051: child pid 11506 exit signal Segmentation fault (11), possible coredump in /etc/apache2
[Thu Jul 07 03:53:39.906559 2016] [core:notice] [pid 1624] AH00051: child pid 11509 exit signal Segmentation fault (11), possible coredump in /etc/apache2

Server configuration : Ubuntu 14.04 , Mysql :5.7 , PHP 5.5.9, Apache 2.4.7

Improve this question
3
  • "possible coredump in /etc/apache2". Is there 1? Does it show anything? Also see sysadmin.carlusgg.com/?p=197 for hints. and bugs.launchpad.net/ubuntu/+source/apache2/+bug/1405173 and omh.cc/blog/2008/mar/6/… Just the error notice is not enough. Most likely it is PHP, not apache though.
    – Rinzwind
    Jul 7, 2016 at 8:27
  • I have got something using gdb ref:sysadmin.carlusgg.com/?p=197 [Thread debugging using libthread_db enabled] Using host libthread_db library "/lib/x86_64-linux-gnu/libthread_db.so.1" warning: the debug information found in "/usr/lib/debug/usr/lib/php5/20121212/pdo_mysql.so" does not match "/usr/lib/php5/20121212/pdo_mysql.so" (CRC mismatch). Core was generated by /usr/sbin/apache2 -k start'. Program terminated with signal SIGSEGV, Segmentation fault. #0 0x00007f72d6da8117 in mysql_close_free_options () from /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18 `
    – Rahul K Jha
    Jul 7, 2016 at 8:32
  • I guess the main problem is Program terminated with signal SIGSEGV, Segmentation fault. #0 0x00007f72d6da8117 in mysql_close_free_options () from /usr/lib/x86_64-linux-gnu/libmysqlclient.so.18
    – Rahul K Jha
    Jul 7, 2016 at 8:45

1 Answer 1

Reset to default
1

Check the value assigned for memory_limit in php.ini
Check also memory allocation suffix:

correct:

memory_limit = 128M

not correct: 

memory_limit = 128

https://unix.stackexchange.com/a/199562

Improve this answer
1
  • in my case i had to increase memory from 128M to 384M
    – Wolfgang Fahl
    Jul 13, 2018 at 9:20

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .