Ad Widget

Collapse

Problems with Oracle and Discovery

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • dotneft
    Senior Member
    • Nov 2008
    • 699

    #1

    Problems with Oracle and Discovery

    Code:
    18547:20081229:231821 In DBget_maxid "graphs"."graphid"
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='graphs' and field_name='graphid']
     18547:20081229:231821 Query [update ids set nextid=nextid+1 where nodeid=0 and table_name='graphs' and field_name='graphid']
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='graphs' and field_name='graphid']
     18547:20081229:231821 End of DBget_maxid "graphs"."graphid":627
     18547:20081229:231821 Query [insert into graphs (graphid,name,width,height,yaxistype,yaxismin,yaxismax,show_work_period,show_triggers,$
     18547:20081229:231821 In DBget_maxid "graphs_items"."gitemid"
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='graphs_items' and field_name='gitemid']
     18547:20081229:231821 Query [update ids set nextid=nextid+1 where nodeid=0 and table_name='graphs_items' and field_name='gitemid']
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='graphs_items' and field_name='gitemid']
     18547:20081229:231821 End of DBget_maxid "graphs_items"."gitemid":1260
     18547:20081229:231821 Query [insert into graphs_items (gitemid,graphid,itemid,color,drawtype,sortorder,yaxisside,calc_fnc,type,periods$
     18547:20081229:231821 Graph 'Ping Average' added
     18547:20081229:231821 Query [select distinct ht.hostid  from hosts_templates ht, items i, graphs_items gi  where ht.templateid=i.hosti$
     18547:20081229:231821 Query [commit;]
     18547:20081229:231821 Query::commit;
     18547:20081229:231821 Query failed:ORA-00911: invalid character
    
    /usr/local/sbin/zabbix_server [18547]: Query::commit;.
    /usr/local/sbin/zabbix_server [18547]: Query failed:ORA-00911: invalid character
    .
     18547:20081229:231821 End op_template_add()
    Code:
      4808:20081230:002250 [Z3005] Query failed: [0] ORA-06550: line 1, column 6:
    PLS-00103: Encountered the symbol ";" when expecting one of the following:
    
       begin case declare exit for goto if loop mod null pragma
       raise return select update while with <an identifier>
       <a double-quoted delimited-identifier> <a bind variable> <<
       close current delete fetch lock insert open rollback
       savepoint set sql execute commit forall merge pipe
     [begin;]
      4808:20081230:002251 [Z3005] Query failed: [0] ORA-00911: invalid character
     [commit;]

    Code:
    18520:20081229:231821 /usr/sbin/fping -c3 2>/dev/null </tmp/zabbix_server_18520.pinger
     18547:20081229:231821 Query [select hostid from hosts where ip='10.100.189.251' and hostid between 000000000000000 and 099999999999999]
     18547:20081229:231821 In DBget_maxid "hosts"."hostid"
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
     18547:20081229:231821 Query [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts' and field_name='hostid']
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='hosts' and field_name='hostid']
     18547:20081229:231821 End of DBget_maxid "hosts"."hostid":10156
     18547:20081229:231821 Query [insert into hosts (hostid,proxy_hostid,host,useip,ip,dns) values (10156,0,'10.100.189.251',1,'10.100.189.$
     18547:20081229:231821 End add_discovered_host()
     18547:20081229:231821 Query [select hosttemplateid from hosts_templates where templateid=10050 and hostid=10156]
     18547:20081229:231821 In DBget_maxid "hosts_templates"."hosttemplateid"
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
     18547:20081229:231821 Query [update ids set nextid=nextid+1 where nodeid=0 and table_name='hosts_templates' and field_name='hosttempla$
     18547:20081229:231821 Query [select nextid from ids where nodeid=0 and table_name='hosts_templates' and field_name='hosttemplateid']
     18547:20081229:231821 End of DBget_maxid "hosts_templates"."hosttemplateid":108
     18547:20081229:231821 Query [begin]
     18547:20081229:231821 Query::begin
     18547:20081229:231821 Query failed:ORA-06550: line 1, column 5:
    PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
    
       begin case declare exit for goto if loop mod null pragma
       raise return select update while with <an identifier>
       <a double-quoted delimited-identifier> <a bind variable> <<
       close current delete fetch lock insert open rollback
       savepoint set sql execute commit forall merge pipe
    
    /usr/local/sbin/zabbix_server [18547]: Query::begin.
    /usr/local/sbin/zabbix_server [18547]: Query failed:ORA-06550: line 1, column 5:
    PLS-00103: Encountered the symbol "end-of-file" when expecting one of the following:
    
       begin case declare exit for goto if loop mod null pragma
       raise return select update while with <an identifier>
       <a double-quoted delimited-identifier> <a bind variable> <<
       close current delete fetch lock insert open rollback
       savepoint set sql execute commit forall merge pipe
    .
    It is by practical consideration established that the given errors arise because of discovery.
    A problem in a file src/zabbix_server/operations.c.
    But the last error to me is unknown: (
    Somebody can help?
Working...