[ZBX-7659] Got signal [signal:7(SIGBUS),reason:128,refaddr:(nil)]. Crashing - in "poller" Created: 2014 Jan 15 Updated: 2017 May 30 Resolved: 2014 Mar 03 |
|
| Status: | Closed |
| Project: | ZABBIX BUGS AND ISSUES |
| Component/s: | Server (S) |
| Affects Version/s: | 2.2.1 |
| Fix Version/s: | 2.0.12rc1, 2.2.3rc1, 2.3.0 |
| Type: | Incident report | Priority: | Major |
| Reporter: | Johannes | Assignee: | Unassigned |
| Resolution: | Fixed | Votes: | 1 |
| Labels: | crash, linux | ||
| Remaining Estimate: | Not Specified | ||
| Time Spent: | Not Specified | ||
| Original Estimate: | Not Specified | ||
| Environment: |
Linux 3.0.58-0.6.6-default #1 SMP Tue Feb 19 11:07:00 UTC 2013 (1576ecd) x86_64 x86_64 x86_64 GNU/Linux |
||
| Attachments: |
objdump_zabbix_server.dump.bz2
|
||||||||
| Issue Links: |
|
||||||||
| Description |
|
after updating from 2.0.6 to 2.2.1 everything was running fine in the beginning. Since yesterday evening suddently the zabbix_server process stops multiple times a day 4346:20140115:145032.347 Got signal [signal:7(SIGBUS),reason:128,refaddr:(nil)]. Crashing ... |
| Comments |
| Comment by Johannes [ 2014 Jan 15 ] | ||
|
I have just updated to Pre-2.2.2rc1 (stable) Rev. 41531 and will report any problems related to https://support.zabbix.com/browse/ZBX-7521 ?? | ||
| Comment by Oleksii Zagorskyi [ 2014 Jan 16 ] | ||
|
it's not related to the | ||
| Comment by Oleksii Zagorskyi [ 2014 Jan 16 ] | ||
|
Did you start to use vmware monitoring exactly yesterday (backtrace above have references to specific functions) ? Could you share with any specific details if you have them ? | ||
| Comment by Johannes [ 2014 Jan 16 ] | ||
|
yes we started to use VMware monitoring but this is working like a charm. what I saw in zabbix_server.log before the crash was this: 28844:20140115:165031.439 [Z3005] query failed: [1364] Field 'hardware_full' doesn't have a default value [insert into host_inventory (hostid,inventory_mode) values (100100000010978,1),(100100000010979,1),(100100000010980,1),(100100000010981,1),(100100000010982,1),(100100000010983,1),(100100000010984,1),(100100000010985,1),(100100000010986,1),(100100000010987,1),(100100000010988,1),(100100000010989,1),(100100000010990,1),(100100000010991,1),(100100000010992,1),(100100000010993,1),(100100000010994,1),(100100000010995,1),(100100000010996,1),(100100000010997,1),(100100000010998,1),(100100000010999,1),(100100000011000,1),(100100000011001,1),(100100000011002,1),(100100000011003,1),(100100000011004,1),(100100000011005,1),(100100000011006,1),(100100000011007,1),(100100000011008,1),(100100000011009,1),(100100000011010,1),(100100000011011,1),(100100000011012,1),(100100000011013,1),(100100000011014,1),(100100000011015,1),(100100000011016,1),(100100000011017,1),(100100000011018,1),(100100000011019,1),(100100000011020,1),(100100000011021,1),(100100000011022,1),(100100000011023,1),(100100000011024,1),(100100000011025,1),(100100000011026,1),(100100000011027,1),(100100000011028,1),(100100000011029,1),(100100000011030,1),(100100000011031,1),(100100000011032,1),(100100000011033,1),(100100000011034,1),(100100000011035,1),(100100000011036,1),(100100000011037,1),(100100000011038,1),(100100000011039,1),(100100000011040,1),(100100000011041,1),(100100000011042,1),(100100000011043,1),(100100000011044,1),(100100000011045,1),(100100000011046,1),(100100000011047,1),(100100000011048,1),(100100000011049,1),(100100000011050,1),(100100000011051,1),(100100000011052,1),(100100000011053,1),(100100000011054,1),(100100000011055,1),(100100000011056,1),(100100000011057,1),(100100000011058,1);] 28844:20140115:165031.457 Got signal [signal:7(SIGBUS),reason:128,refaddr:(nil)]. Crashing ... What I did is setting the sql_mode of our MySQL server to "" which means that strict mode is disabled now. MySQL version: mysql Ver 14.14 Distrib 5.5.29, for Linux (x86_64) mysql> SELECT @@GLOBAL.sql_mode;
------------------- ------------------- | ||
| Comment by Johannes [ 2014 Jan 16 ] | ||
|
maybe related to: https://support.zabbix.com/browse/ZBX-7561 EDIT: When I imported the templates the first time and let it discover I changed nothing and it was working, but I deleted and reimported the templates again and changed the following:
| ||
| Comment by Alexander Vladishev [ 2014 Jan 20 ] | ||
|
Related issue: | ||
| Comment by Andris Zeila [ 2014 Jan 21 ] | ||
|
The crash happens when trying to link template to a host without any interfaces. While normally it can't happen, but apparently in this case host saving failed because of "28844:20140115:165031.439 [Z3005] query failed: [1364] Field 'hardware_full' doesn't have a default value [insert into host_inventory (hostid,inventory_mode) values..." error, leading to following crash when trying to link templates. We have to decide how to handle it. | ||
| Comment by Juris Miščenko (Inactive) [ 2014 Feb 18 ] | ||
|
Fixed in svn://svn.zabbix.com/branches/dev/ZBX-7659 Upon attempting to link a template to a host that has no interfaces a log message will be presented that will inform of the event. The crash has been averted. | ||
| Comment by Alexander Vladishev [ 2014 Feb 26 ] | ||
|
"28844:20140115:165031.439 [Z3005] query failed: [1364] Field 'hardware_full' doesn't have a default value [insert into host_inventory (hostid,inventory_mode) values..." error was fixed under | ||
| Comment by Juris Miščenko (Inactive) [ 2014 Mar 06 ] | ||
|
Fixed in 2.0.12rc1 r43259, 2.2.3rc1 r43240, 2.3.0 (trunk) r43258 | ||
| Comment by Juris Miščenko (Inactive) [ 2014 Mar 06 ] | ||
|
To the reporter: could you please explain to me how you managed to trigger this crash, because during reproducing/testing we had to introduce severe breakage in the code just to get this to happen. Was it a database corruption of some sort? It would be nice to know | ||
| Comment by Johannes [ 2014 Mar 31 ] | ||
|
Hi, imported vmware templates, added the vcenter server and changed the inventory to automatic. 6901:20140331:135135.034 [Z3005] query failed: [1364] Field 'hardware_full' doesn't have a default value [insert into host_inventory (hostid,inventory_mode) values (200200000014422,1),(200200000014423,1),(200200000014424,1),(200200000014425,1),(200200000014426,1),(200200000014427,1),(200200000014428,1),(200200000014429,1),(200200000014430,1),(200200000014431,1),(200200000014432,1),(200200000014433,1),(200200000014434,1),(200200000014435,1),(200200000014436,1),(200200000014437,1),(200200000014438,1),(200200000014439,1),(200200000014440,1),(200200000014441,1),(200200000014442,1),(200200000014443,1),(200200000014444,1),(200200000014445,1),(200200000014446,1),(200200000014447,1),(200200000014448,1);] Mysql version currently 5.5 but we had to set sql_mode to ' ' (which means no_strict mode) and it does not happen anymore with automatic inventory enabled. |
