Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Incomplete
-
10.0.31, 10.0.32
-
Debian 8 und OpenSuSE Leap 42.2
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