Ad Widget

Collapse

Ошибка записи в Postgres

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Dev_LC
    Member
    • Feb 2011
    • 64

    #1

    Ошибка записи в Postgres

    База PostgreSQL 8.4 и сервер Zabbix 1.8.4 разнесены.
    Через некоторое время работы в логах такие ошибки:

    Code:
      2678:20110303:171913.402 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [insert into ids (nodeid,table_name,field_name,nextid) values (0,'events','eventid',0)]
      2679:20110303:171913.403 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
      2678:20110303:171913.403 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
      2679:20110303:171913.404 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [select max(eventid) from events where eventid between 0 and 99999999999999]
      2679:20110303:171913.406 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [insert into ids (nodeid,table_name,field_name,nextid) values (0,'events','eventid',0)]
      2678:20110303:171913.406 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [select nextid from ids where nodeid=0 and table_name='events' and field_name='eventid']
      2679:20110303:171913.409 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [update ids set nextid=nextid+1 where nodeid=0 and table_name='events' and field_name='eventid']
      2678:20110303:171913.409 [Z3005] Query failed: [0] PGRES_FATAL_ERROR:ERROR:  current transaction is aborted, commands ignored until end of transaction block
     [select max(eventid) from events where eventid between 0 and 99999999999999]
    Last edited by Dev_LC; 03-03-2011, 22:04.
  • Dev_LC
    Member
    • Feb 2011
    • 64

    #2
    Похоже этих ошибок нет, если отключен Хаускипинг.

    Comment

    • sevensides
      Junior Member
      • Jan 2011
      • 1

      #3
      Emm, where do you turn off this Highskipping? Google gives no answers o_O ;o

      Comment

      • zalex_ua
        Senior Member
        Zabbix Certified Trainer
        Zabbix Certified SpecialistZabbix Certified Professional
        • Oct 2009
        • 1286

        #4
        Originally posted by Dev_LC
        Похоже этих ошибок нет, если отключен Хаускипинг.
        Сходите на трекер и поищите запросы связанные с Постгресом. Они там точно есть, может быть и ваш случай уже там присутствует.

        Comment

        • zalex_ua
          Senior Member
          Zabbix Certified Trainer
          Zabbix Certified SpecialistZabbix Certified Professional
          • Oct 2009
          • 1286

          #5
          Originally posted by sevensides
          emm, where do you turn off this highskipping? Google gives no answers o_o ;o
          Эй, ты, умный бот, мы обольщены твоим знанием терминологии на английском :d
          Но еще один не аккуратный шаг с твоей стороны, а не дай бог еще и со ссылкой и ты будешь уничтожен.
          Модераторы уже присматривают за тобой

          Comment

          Working...