Strange DB error on alpha12

[dminstrel]

Hi,

after an upgrade to mysqld Ver 4.0.24 on a Debian box, zabbix_server (alpha12) dies. It worked before. This is what I have in the logfile:

001380:20050814:085932 In DBnum_rows
001380:20050814:085932 Result of DBnum_rows [1]
001380:20050814:085932 Expression1:[{11679}=0]
001380:20050814:085932 Expression2:[%lf679}=0]
001380:20050814:085932 Expression3:[%lf =0]
001380:20050814:085932 Before deleting spaces:0.000300 =0
001380:20050814:085932 After deleting spaces:0.000300=0
001380:20050814:085932 Expression4:[0.000300=0]
001380:20050814:085932 Before find_char:0.000300=0[{]
001380:20050814:085932 Expression:[0.000300=0]
001380:20050814:085932 END substitute_functions
001380:20050814:085932 In evaluate([0.000300=0])
001380:20050814:085932 Before find_char:0.000300=0[)]
001380:20050814:085932 Evaluating simple expression [0.000300=0]
001380:20050814:085932 Starting is_double:[0.000300=0]
001380:20050814:085932 It is NOT double [0.000300=0]
001380:20050814:085932 Before find_char:0.000300=0[|]
001380:20050814:085932 Before find_char:0.000300=0[&]
001380:20050814:085932 Before find_char:0.000300=0[>]
001380:20050814:085932 Before find_char:0.000300=0[<]
001380:20050814:085932 Before find_char:0.000300=0[*]
001380:20050814:085932 Before find_char:0.000300=0[/]
001380:20050814:085932 Before find_char:0.000300=0[+]
001380:20050814:085932 Before find_char:0.000300=0[-]

MySQL works fine and I have other applications on that server that access it with no problems. My hunch is that it's a compilation issue but I recompiled and still have the problem. Any ideas?

Thanks!

Jonathan

[dminstrel]

I've upgraded MySQL to version 4.1.13 but still no dice.

Anybody else see this error?

[Alexei]

What error? Please provide us with more information. Give us at least 50-100 trailing lines of the LogFile...

[dminstrel]

Found it!

I did a tail -f of zabbix_server.log. This is all I get when I start zabbix_server:

001380:20050814:085932 Starting is_double:[0.000300=0]
001380:20050814:085932 It is NOT double [0.000300=0]
001380:20050814:085932 Before find_char:0.000300=0[|]
001380:20050814:085932 Before find_char:0.000300=0[&]
001380:20050814:085932 Before find_char:0.000300=0[>]
001380:20050814:085932 Before find_char:0.000300=0[<]
001380:20050814:085932 Before find_char:0.000300=0[*]
001380:20050814:085932 Before find_char:0.000300=0[/]
001380:20050814:085932 Before find_char:0.000300=0[+]
001380:20050814:085932 Before find_char:0.000300=0[-]

I'm at DebugLevel4.

The problem is quite simple : the zabbix_server.log file had reached 2.0GB! I've emptied it and everything is fine.

I've configured logrotate to manage this. Still, a simple check of the logfile size when zabbix_server starts with a helpful error message could be useful (but it's far from peing a priority).

(hangs head in shame)

[Alexei]

The problem is quite simple : the zabbix_server.log file had reached 2.0GB! I've emptied it and everything is fine.

ZABBIX (1.0, 1.1 alphas) does perform automatic log rotation! By default, it rotates log files after 1MB. Something is very strange here. Perhaps some permission problems or a broken filesystem, I have no idea.