*VERY* Weird problem with MySQL

Discuss usability issues, general maintenance, and general support issues for a grsecurity-enabled system.

*VERY* Weird problem with MySQL

Postby superbock » Wed Jun 30, 2004 12:59 am

Hi!

This one has been bugging me for some days now.. and it took a while to narrow it down to my grsec kernel.. uhf. Well, here's the scenario:

Platform: P4, FedoraCore1, Apache 2.0.49, PHP 4.3.6, MySQL 3.23.58, Linux 2.4.26, latest grsec (not CVS), relaxed default ACL's.

Software: Photopost (PHP/MySQL).

Situation: showgallery.php?cat=all should return long listing of all galleries, but script fails intermittently (only succeeds around 33% of the time) with "Lost connection to server during query". Obviously this is not specific to this software, but it was with it that the problem showed up and was easily and sistematically reproduced. It seems to affect queries that return large amounts of data.

Workaround: boot non-grsec kernel (in this case latest FC's).

Logs: none that seem related

Ideas / thoughts: wanted :)

After many troubleshooting effort with mysql and php, a simple reboot to a "clean" kernel made the problem completely go away. Unfortunately, only after that i realized that the problem appeared at the same time i installed grsec's kernel. Grsec is interfering here in some obscure way. I was thinking of resource overstepping in some way, but to my knowledge that kind of situation is logged.

Anyway, anyone experienced(ing) similar behaviour?

Tks in advance
superbock
 
Posts: 37
Joined: Sun Mar 31, 2002 6:34 pm

Re: *VERY* Weird problem with MySQL

Postby PaX Team » Fri Jul 02, 2004 11:57 am

superbock wrote:Situation: showgallery.php?cat=all should return long listing of all galleries, but script fails intermittently (only succeeds around 33% of the time) with "Lost connection to server during query". Obviously this is not specific to this software, but it was with it that the problem showed up and was easily and sistematically reproduced. It seems to affect queries that return large amounts of data.
if the problem is so well reproducible, you could try to strace both apache/mysql and see what happens when the failure occurs.
PaX Team
 
Posts: 2310
Joined: Mon Mar 18, 2002 4:35 pm


Return to grsecurity support