• Registered: 2011-03-10
  • Posts: 2

Topic: PHP segfaults with mysqli on CentOS5

Hi

We're using the latest 5.3.5-1.el5.remi.1 packages on a CentOS5 installation.

All works fine but some mysql action let php segfault. The only tool we could reproduce this with is piwik usind both the mysqli and the pdo_mysql adapter.

a strace shows it dying right after closing the handle to the open connection (either unix socket or network).

We tried a lot of things including reinstalling all php and mysql packages.


Did you hear about some similar problem? Any ideas what could be done to fix it?

Peter

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: PHP segfaults with mysqli on CentOS5

It seems the new garbage collector (new in 5.3) comes with memory issues.

Each new PHP version solves more issues.

So you should try
- to run without the garbage collector (zend.enable-gc)
- try the 5.3.6RC2 in remi-test (RC3, and then final version should be available really soon)
- switch from mysqli to mysql (if possible) which seems less affected

Else : try to provide a minimal test case which reproduce the issue and report the bug upstream.

+

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website

  • Registered: 2011-03-10
  • Posts: 2

Re: PHP segfaults with mysqli on CentOS5

Hey man, thank you very much for your quick answer.

zend.enable_gc = Off

did the trick and solved the problem on cli and web.

Thynk you very much
  - that saved my day (and the next nights' sleep ^^)

Peter

  • Remi
  • Remi
  • Administrateur
  • Offline
  • From: Champagne...
  • Registered: 2009-04-28
  • Posts: 3,836

Re: PHP segfaults with mysqli on CentOS5

Great !

Please, when 5.3.6 will be out : test it with gc enabled to see if your issue is fixed (else I will try to reproduce, because such a bug need to be reprted upstream).

Remi.

Laptop:  Fedora 38 + rpmfusion + remi (SCL only)
x86_64 builder: Fedora 39 + rpmfusion + remi-test
aarch64 builder: RHEL 9 with EPEL
Hosting Server: CentOS 8 Stream with EPEL, rpmfusion, remi

Remi's Website