Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-13610

ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full'

    XMLWordPrintable

Details

    Description

      PM - SPINE: Poller[0] ERROR: SQL Failed! Error:'1114', Message:'The table 'poller_output' is full', SQL Fragment:'INSERT INTO poller_output (local_dat...

      but these table is empty, and per command i can write in, also with duplicate keys, in old mode and insert ignore into...

      all what i could check and change does not play any role at all. as well i testet the engines innodb, and MyISAM, it never worked. But only on an old mysql 5.0.67-log SUSE MySQL RPM it works without any problem.

      my settings therfore are in my.cnf

      old_mode = NO_DUP_KEY_WARNINGS_WITH_IGNORE,ZERO_DATE_TIME_CAST
      ## sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
      # sql_mode=NO_ENGINE_SUBSTITUTION
      # sql_mode=ALLOW_INVALID_DATES,MYSQL40,NO_KEY_OPTIONS,NO_TABLE_OPTIONS,TRADITIONAL,ANSI_QUOTES,HIGH_NOT_PRECEDENCE,IGNORE_BAD_TABLE_OPTIONS,MAXDB
      sql_mode=MAXDB
      

      I tested setting for setting, but ist does not change anything.

      the client site is cacti boost plugin on PHP Version => 5.2.6

      where can i get an usfull error message with gives me a hint what is going wrong and what cat i setup to become it compatibel with the old mysql

      thanks Siegfried

      Attachments

        1. vars.selma.20170823.log
          14 kB
          eichhorn
        2. vars.leap42.2-test.20170823.log
          14 kB
          eichhorn
        3. vars.patty.20170823.log
          15 kB
          eichhorn
        4. test02.log
          3 kB
          eichhorn
        5. test03.log
          1 kB
          eichhorn
        6. test04.log
          0.6 kB
          eichhorn
        7. test08.log
          10 kB
          eichhorn
        8. test09.log
          4 kB
          eichhorn

        Activity

          People

            Unassigned Unassigned
            eichhorn eichhorn
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.