When I use db.odbc.select monitor mysql server, I find a bug.
This is zabbix_server.log:
4792:20111009:172923.067 In get_values()
4792:20111009:172923.068 In DCconfig_get_poller_items() poller_type:0
4792:20111009:172923.068 End of DCconfig_get_poller_items():1
4792:20111009:172923.068 In substitute_simple_macros() data:'db.odbc.select[mysqld]'
4792:20111009:172923.068 In substitute_simple_macros() data:'DSN=mysql
user=nagios
password=123456
sql=show status like 'Uptime';'
4792:20111009:172923.068 In get_value() key:'db.odbc.select[mysqld]'
4792:20111009:172923.069 In database monitor: db.odbc.select[mysqld]
4792:20111009:172923.069 ODBC connect [mysql] [nagios]
4792:20111009:172923.094 ODBC select [show status like 'Uptime';]
4792:20111009:172923.096 selected 0 cols
4792:20111009:172923.096 ODBC fetch
4792:20111009:172923.096 Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x8c]. Crashing ...
4792:20111009:172923.097 ====== Fatal information: ======
4792:20111009:172923.097 Program counter: 0xaa3c20
4792:20111009:172923.097 === Registers: ===
4792:20111009:172923.097 gs = 33 = 51 = 51
4792:20111009:172923.097 fs = 0 = 0 = 0
4792:20111009:172923.097 es = c040007b = 3225419899 = -1069547397
4792:20111009:172923.097 ds = 7b = 123 = 123
4792:20111009:172923.098 edi = 9a8fd20 = 162069792 = 162069792
4792:20111009:172923.098 esi = 0 = 0 = 0
4792:20111009:172923.098 ebp = bfd25f58 = 3218235224 = -1076732072
4792:20111009:172923.098 esp = bfd25f30 = 3218235184 = -1076732112
4792:20111009:172923.098 ebx = c63ea4 = 12992164 = 12992164
4792:20111009:172923.098 edx = 6 = 6 = 6
4792:20111009:172923.099 ecx = 9a7cd24 = 161991972 = 161991972
4792:20111009:172923.099 eax = 0 = 0 = 0
4792:20111009:172923.099 trapno = e = 14 = 14
4792:20111009:172923.099 err = 6 = 6 = 6
4792:20111009:172923.099 eip = aa3c20 = 11156512 = 11156512
4792:20111009:172923.099 cs = 73 = 115 = 115
4792:20111009:172923.099 efl = 210246 = 2163270 = 2163270
4792:20111009:172923.100 uesp = bfd25f30 = 3218235184 = -1076732112
4792:20111009:172923.100 ss = 7b = 123 = 123
4792:20111009:172923.100 === Stack frame: ===
4792:20111009:172923.100 +0x40(%ebp) = ebp + 64 = 09a83250 = 162017872 = 162017872
4792:20111009:172923.100 +0x3c(%ebp) = ebp + 60 = 0066ded0 = 6741712 = 6741712
4792:20111009:172923.100 +0x38(%ebp) = ebp + 56 = 00d25fd8 = 13787096 = 13787096
4792:20111009:172923.101 +0x34(%ebp) = ebp + 52 = 00000001 = 1 = 1
4792:20111009:172923.101 +0x30(%ebp) = ebp + 48 = 00000000 = 0 = 0
4792:20111009:172923.101 +0x2c(%ebp) = ebp + 44 = 00000001 = 1 = 1
4792:20111009:172923.101 +0x28(%ebp) = ebp + 40 = 00000000 = 0 = 0
4792:20111009:172923.101 +0x24(%ebp) = ebp + 36 = 000013ac = 5036 = 5036
4792:20111009:172923.101 +0x20(%ebp) = ebp + 32 = 09a8fd10 = 162069776 = 162069776
4792:20111009:172923.101 +0x1c(%ebp) = ebp + 28 = 00a6754e = 10909006 = 10909006
4792:20111009:172923.102 +0x18(%ebp) = ebp + 24 = 00000000 = 0 = 0
4792:20111009:172923.102 +0x14(%ebp) = ebp + 20 = 00aa3ddb = 11156955 = 11156955
4792:20111009:172923.102 +0x10(%ebp) = ebp + 16 = 09a8fd20 = 162069792 = 162069792
4792:20111009:172923.102 +0x0c(%ebp) = ebp + 12 = 09a7cd24 = 161991972 = 161991972
4792:20111009:172923.102 +0x08(%ebp) = ebp + 8 = 09a7bff8 = 161988600 = 161988600 <--- call arguments
4792:20111009:172923.102 +0x04(%ebp) = ebp + 4 = 00aa4198 <--- return address
4792:20111009:172923.103 (%ebp) = ebp = bfd25fa8 <--- saved ebp value
4792:20111009:172923.103 -0x04(%ebp) = ebp - 4 = 09a8fd20 = 162069792 = 162069792 <--- local variables
4792:20111009:172923.103 -0x08(%ebp) = ebp - 8 = 09a83250 = 162017872 = 162017872
4792:20111009:172923.103 -0x0c(%ebp) = ebp - 12 = 00c63ea4 = 12992164 = 12992164
4792:20111009:172923.103 -0x10(%ebp) = ebp - 16 = 00000002 = 2 = 2
4792:20111009:172923.103 -0x14(%ebp) = ebp - 20 = 09a8fd20 = 162069792 = 162069792
4792:20111009:172923.103 -0x18(%ebp) = ebp - 24 = 09a7cd24 = 161991972 = 161991972
4792:20111009:172923.104 -0x1c(%ebp) = ebp - 28 = 00aa3bf3 = 11156467 = 11156467
4792:20111009:172923.104 -0x20(%ebp) = ebp - 32 = 00000000 = 0 = 0
4792:20111009:172923.104 -0x24(%ebp) = ebp - 36 = 00000000 = 0 = 0
4792:20111009:172923.104 -0x28(%ebp) = ebp - 40 = 09a7bff8 = 161988600 = 161988600
4792:20111009:172923.104 -0x2c(%ebp) = ebp - 44 = 00aa3c1a = 11156506 = 11156506
4792:20111009:172923.104 -0x30(%ebp) = ebp - 48 = bfd25f58 = 3218235224 = -1076732072
4792:20111009:172923.104 -0x34(%ebp) = ebp - 52 = 0980cd00 = 159436032 = 159436032
4792:20111009:172923.105 -0x38(%ebp) = ebp - 56 = 0000adb8 = 44472 = 44472
4792:20111009:172923.105 -0x3c(%ebp) = ebp - 60 = 00000000 = 0 = 0
4792:20111009:172923.105 -0x40(%ebp) = ebp - 64 = 00000000 = 0 = 0
4792:20111009:172923.105 === Backtrace: ===
4792:20111009:172923.107 14: /usr/local/zabbix/sbin/zabbix_server(print_fatal_info+0x311) [0x808b9a1]
4792:20111009:172923.107 13: /usr/local/zabbix/sbin/zabbix_server [0x808af04]
4792:20111009:172923.107 12: [0x2d9440]
4792:20111009:172923.107 11: /usr/local/myodbc/lib/libmyodbc5.so [0xaa3c20]
4792:20111009:172923.107 10: /usr/local/myodbc/lib/libmyodbc5.so(my_SQLExtendedFetch+0x3cb) [0xaa4198]
4792:20111009:172923.108 9: /usr/local/myodbc/lib/libmyodbc5.so(SQLFetch+0x38) [0xaa43a1]
4792:20111009:172923.108 8: /usr/lib/libodbc.so.1(SQLFetch+0xb8) [0x1adf78]
4792:20111009:172923.108 7: /usr/local/zabbix/sbin/zabbix_server(odbc_DBfetch+0x48) [0x80ab228]
4792:20111009:172923.108 6: /usr/local/zabbix/sbin/zabbix_server(get_value_db+0xe7) [0x8062307]
4792:20111009:172923.108 5: /usr/local/zabbix/sbin/zabbix_server(main_poller_loop+0x177b) [0x80603bb]
4792:20111009:172923.108 4: /usr/local/zabbix/sbin/zabbix_server(MAIN_ZABBIX_ENTRY+0x6f0) [0x8056d20]
4792:20111009:172923.109 3: /usr/local/zabbix/sbin/zabbix_server(daemon_start+0x2b6) [0x808ab56]
4792:20111009:172923.109 2: /usr/local/zabbix/sbin/zabbix_server(main+0x228) [0x8056478]
4792:20111009:172923.109 1: /lib/libc.so.6(__libc_start_main+0xdc) [0x68df2c]
4792:20111009:172923.109 0: /usr/local/zabbix/sbin/zabbix_server [0x80524b1]
4792:20111009:172923.109 === Memory map: ===
4792:20111009:172923.109 memory map not available for this platform
4792:20111009:172923.109 ================================
4792:20111009:172923.110 Please consider attaching a disassembly listing to your bug report.
4792:20111009:172923.110 This listing can be produced with, e.g., objdump -DSswx zabbix_server.
4792:20111009:172923.110 ================================
This is zabbix_server.log:
4792:20111009:172923.067 In get_values()
4792:20111009:172923.068 In DCconfig_get_poller_items() poller_type:0
4792:20111009:172923.068 End of DCconfig_get_poller_items():1
4792:20111009:172923.068 In substitute_simple_macros() data:'db.odbc.select[mysqld]'
4792:20111009:172923.068 In substitute_simple_macros() data:'DSN=mysql
user=nagios
password=123456
sql=show status like 'Uptime';'
4792:20111009:172923.068 In get_value() key:'db.odbc.select[mysqld]'
4792:20111009:172923.069 In database monitor: db.odbc.select[mysqld]
4792:20111009:172923.069 ODBC connect [mysql] [nagios]
4792:20111009:172923.094 ODBC select [show status like 'Uptime';]
4792:20111009:172923.096 selected 0 cols

4792:20111009:172923.096 ODBC fetch
4792:20111009:172923.096 Got signal [signal:11(SIGSEGV),reason:1,refaddr:0x8c]. Crashing ...
4792:20111009:172923.097 ====== Fatal information: ======
4792:20111009:172923.097 Program counter: 0xaa3c20
4792:20111009:172923.097 === Registers: ===
4792:20111009:172923.097 gs = 33 = 51 = 51
4792:20111009:172923.097 fs = 0 = 0 = 0
4792:20111009:172923.097 es = c040007b = 3225419899 = -1069547397
4792:20111009:172923.097 ds = 7b = 123 = 123
4792:20111009:172923.098 edi = 9a8fd20 = 162069792 = 162069792
4792:20111009:172923.098 esi = 0 = 0 = 0
4792:20111009:172923.098 ebp = bfd25f58 = 3218235224 = -1076732072
4792:20111009:172923.098 esp = bfd25f30 = 3218235184 = -1076732112
4792:20111009:172923.098 ebx = c63ea4 = 12992164 = 12992164
4792:20111009:172923.098 edx = 6 = 6 = 6
4792:20111009:172923.099 ecx = 9a7cd24 = 161991972 = 161991972
4792:20111009:172923.099 eax = 0 = 0 = 0
4792:20111009:172923.099 trapno = e = 14 = 14
4792:20111009:172923.099 err = 6 = 6 = 6
4792:20111009:172923.099 eip = aa3c20 = 11156512 = 11156512
4792:20111009:172923.099 cs = 73 = 115 = 115
4792:20111009:172923.099 efl = 210246 = 2163270 = 2163270
4792:20111009:172923.100 uesp = bfd25f30 = 3218235184 = -1076732112
4792:20111009:172923.100 ss = 7b = 123 = 123
4792:20111009:172923.100 === Stack frame: ===
4792:20111009:172923.100 +0x40(%ebp) = ebp + 64 = 09a83250 = 162017872 = 162017872
4792:20111009:172923.100 +0x3c(%ebp) = ebp + 60 = 0066ded0 = 6741712 = 6741712
4792:20111009:172923.100 +0x38(%ebp) = ebp + 56 = 00d25fd8 = 13787096 = 13787096
4792:20111009:172923.101 +0x34(%ebp) = ebp + 52 = 00000001 = 1 = 1
4792:20111009:172923.101 +0x30(%ebp) = ebp + 48 = 00000000 = 0 = 0
4792:20111009:172923.101 +0x2c(%ebp) = ebp + 44 = 00000001 = 1 = 1
4792:20111009:172923.101 +0x28(%ebp) = ebp + 40 = 00000000 = 0 = 0
4792:20111009:172923.101 +0x24(%ebp) = ebp + 36 = 000013ac = 5036 = 5036
4792:20111009:172923.101 +0x20(%ebp) = ebp + 32 = 09a8fd10 = 162069776 = 162069776
4792:20111009:172923.101 +0x1c(%ebp) = ebp + 28 = 00a6754e = 10909006 = 10909006
4792:20111009:172923.102 +0x18(%ebp) = ebp + 24 = 00000000 = 0 = 0
4792:20111009:172923.102 +0x14(%ebp) = ebp + 20 = 00aa3ddb = 11156955 = 11156955
4792:20111009:172923.102 +0x10(%ebp) = ebp + 16 = 09a8fd20 = 162069792 = 162069792
4792:20111009:172923.102 +0x0c(%ebp) = ebp + 12 = 09a7cd24 = 161991972 = 161991972
4792:20111009:172923.102 +0x08(%ebp) = ebp + 8 = 09a7bff8 = 161988600 = 161988600 <--- call arguments
4792:20111009:172923.102 +0x04(%ebp) = ebp + 4 = 00aa4198 <--- return address
4792:20111009:172923.103 (%ebp) = ebp = bfd25fa8 <--- saved ebp value
4792:20111009:172923.103 -0x04(%ebp) = ebp - 4 = 09a8fd20 = 162069792 = 162069792 <--- local variables
4792:20111009:172923.103 -0x08(%ebp) = ebp - 8 = 09a83250 = 162017872 = 162017872
4792:20111009:172923.103 -0x0c(%ebp) = ebp - 12 = 00c63ea4 = 12992164 = 12992164
4792:20111009:172923.103 -0x10(%ebp) = ebp - 16 = 00000002 = 2 = 2
4792:20111009:172923.103 -0x14(%ebp) = ebp - 20 = 09a8fd20 = 162069792 = 162069792
4792:20111009:172923.103 -0x18(%ebp) = ebp - 24 = 09a7cd24 = 161991972 = 161991972
4792:20111009:172923.104 -0x1c(%ebp) = ebp - 28 = 00aa3bf3 = 11156467 = 11156467
4792:20111009:172923.104 -0x20(%ebp) = ebp - 32 = 00000000 = 0 = 0
4792:20111009:172923.104 -0x24(%ebp) = ebp - 36 = 00000000 = 0 = 0
4792:20111009:172923.104 -0x28(%ebp) = ebp - 40 = 09a7bff8 = 161988600 = 161988600
4792:20111009:172923.104 -0x2c(%ebp) = ebp - 44 = 00aa3c1a = 11156506 = 11156506
4792:20111009:172923.104 -0x30(%ebp) = ebp - 48 = bfd25f58 = 3218235224 = -1076732072
4792:20111009:172923.104 -0x34(%ebp) = ebp - 52 = 0980cd00 = 159436032 = 159436032
4792:20111009:172923.105 -0x38(%ebp) = ebp - 56 = 0000adb8 = 44472 = 44472
4792:20111009:172923.105 -0x3c(%ebp) = ebp - 60 = 00000000 = 0 = 0
4792:20111009:172923.105 -0x40(%ebp) = ebp - 64 = 00000000 = 0 = 0
4792:20111009:172923.105 === Backtrace: ===
4792:20111009:172923.107 14: /usr/local/zabbix/sbin/zabbix_server(print_fatal_info+0x311) [0x808b9a1]
4792:20111009:172923.107 13: /usr/local/zabbix/sbin/zabbix_server [0x808af04]
4792:20111009:172923.107 12: [0x2d9440]
4792:20111009:172923.107 11: /usr/local/myodbc/lib/libmyodbc5.so [0xaa3c20]
4792:20111009:172923.107 10: /usr/local/myodbc/lib/libmyodbc5.so(my_SQLExtendedFetch+0x3cb) [0xaa4198]
4792:20111009:172923.108 9: /usr/local/myodbc/lib/libmyodbc5.so(SQLFetch+0x38) [0xaa43a1]
4792:20111009:172923.108 8: /usr/lib/libodbc.so.1(SQLFetch+0xb8) [0x1adf78]
4792:20111009:172923.108 7: /usr/local/zabbix/sbin/zabbix_server(odbc_DBfetch+0x48) [0x80ab228]
4792:20111009:172923.108 6: /usr/local/zabbix/sbin/zabbix_server(get_value_db+0xe7) [0x8062307]
4792:20111009:172923.108 5: /usr/local/zabbix/sbin/zabbix_server(main_poller_loop+0x177b) [0x80603bb]
4792:20111009:172923.108 4: /usr/local/zabbix/sbin/zabbix_server(MAIN_ZABBIX_ENTRY+0x6f0) [0x8056d20]
4792:20111009:172923.109 3: /usr/local/zabbix/sbin/zabbix_server(daemon_start+0x2b6) [0x808ab56]
4792:20111009:172923.109 2: /usr/local/zabbix/sbin/zabbix_server(main+0x228) [0x8056478]
4792:20111009:172923.109 1: /lib/libc.so.6(__libc_start_main+0xdc) [0x68df2c]
4792:20111009:172923.109 0: /usr/local/zabbix/sbin/zabbix_server [0x80524b1]
4792:20111009:172923.109 === Memory map: ===
4792:20111009:172923.109 memory map not available for this platform
4792:20111009:172923.109 ================================
4792:20111009:172923.110 Please consider attaching a disassembly listing to your bug report.
4792:20111009:172923.110 This listing can be produced with, e.g., objdump -DSswx zabbix_server.
4792:20111009:172923.110 ================================
Comment