[TYPO3-dev] Typo3 4.1 - Server crashes

[Gregor Gold]

Hi everyone,

first of all I would like to say hello to everyone. My name is Greg and I
did never post here before, but maybe you can help me or find a potential
bug in Typo3 release 4.1. If this subject is totally wrong in this mailing
list, i'm sorry.

My problem:

I do experience some strange problems with the new release 4.1. I did
migrate to the latest release about 2 weeks ago. Afterwards, my server
started to crash from time to time.

Maybe some info first:

I run a website (www.pimp-my-sims.com), which is visited by up to 18k
visitors per day. Server and Typo3 seem to be capable to handle this amount
of users, but since the migration to 4.1, it crashes from time to time. I
did choose the latest release due to the improvements in caching, which is
quite important for my site. The weird thing is, that the server crashed
always took place in low-load periods (e.g. 0.5). During high load periods
(15-20, as I did empty the FE cache on saturday night :( ), the server and
typo3 just worked fine.

The support of my provider did already check the server and did find no
indications for a server-side problem (e.g. hardware etc.)

As the server crashed, I requested a mysql query logging with a special
focus on slow queries, which i thought might point to the problem. These are
the slow queries right before the server stopped working. I noticed that
only cache_hash queries show up in the log file, but I do not know enough
about Typo3 and its core scripts to determine, where I might look for more
info and what is processed exactly.


> # Time: 070323 13:29:32
> # User at Host: MY_DATABASE@ localhost []
> # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> use db199750123;
> INSERT INTO cache_hash
>     (
>      hash,
>      content,
>      ident,
>      tstamp
>     ) VALUES (
>      'd7e896db81739df597cfe718c8501e3d',
>      'N;',
>      'MENUDATA',
>      '1174652968'
>     );
> # User at Host: MY_DATABASE@ localhost []
> # Query_time: 5  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> INSERT INTO cache_hash
>     (
>      hash,
>      content,
>      ident,
>      tstamp
>     ) VALUES (
>      'eff58c0e62c2e18dc6f5756587616db9',
>      'N;',
>      'MENUDATA',
>      '1174652967'
>     );
> # User at Host: MY_DATABASE@ localhost []
> # Query_time: 4  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> INSERT INTO cache_hash
>     (
>      hash,
>      content,
>      ident,
>      tstamp
>     ) VALUES (
>      '76e7f280bde8724e8121eae43c625aa2',
>      'a:6:{i:0;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:1;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:2;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:3;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:4;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:5;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">| </p>\";}}',
>      'MENUDATA',
>      '1174652968'
>     );
> # Time: 070323 13:31:30
> # User at Host: MY_DATABASE @ localhost []
> # Query_time: 7  Lock_time: 0  Rows_sent: 1  Rows_examined: 0
> SELECT content
>    FROM cache_hash
>    WHERE
>     hash='eccb8c04efcdf79cedbdd98315e31f56' AND tstamp > 1174566683;
> # User at Host: MY_DATABASE @ localhost []
> # Query_time: 7  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> SELECT content
>    FROM cache_hash
>    WHERE
>     hash='d9e5cdffd1504ead8ed0311da0ca9292' AND tstamp > 1174566683;
> # User at Host: MY_DATABASE @ localhost []
> # Query_time: 7  Lock_time: 0  Rows_sent: 0  Rows_examined: 0
> INSERT INTO cache_hash
>     (
>      hash,
>      content,
>      ident,
>      tstamp
>     ) VALUES (
>      'a49c4243e8d3807bf272f7dcad571e81',
>      'a:11:{i:0;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:1;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:2;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:3;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:4;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:5;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:6;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:7;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:8;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:9;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">|
> </p>\";}i:10;a:1:{s:8:\"linkWrap\";s:23:\"<p class=\"links\">| </p>\";}}',
>      'MENUDATA',
>      '1174653083'
>     );



Here comes some information about my system configuration. Should you need
more, please tell me and I will try to deliver, what is needed. I can't
modify that much on request, as i run a managed server with full-service,
but i can try to deliver as much information as possible.

Typo3 4.1

Extensions:

Standard stuff like realurl, tt_news etc. In the downloads section, I run
some selfmade extensions to display the files.

Server: Opteron 1218, 2 x 2,6GHz, 4GB RAM, 2x400GB harddrive with hardware
Raid1

Any help is relly appreciated, even if it is a "Typo3 can not be the cause
for the server crashes" and if I have to bother the support of my provider
again :)

Greetings and thanks in advance
Greg