search

Cacti / cacti

Cacti ™
http://www.cacti.net
GNU General Public License v2.0
1.65k stars 406 forks source link

Hungings at upgrade_database.php #154

Closed interduo closed 7 years ago

interduo commented 7 years ago

php -e -q upgrade_database.php --forcever=0.8.8h Upgrading to 1.0.0

... it hungs here ...

when debuging strace -p PROPERPID write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLEplugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE `plugin_aggrega"..., 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default val"..., 16384) = 54

cigamit commented 7 years ago

You need to increase the width of your strace using -s 2500, and then run again. Also, what database MariaDB or MySQL and version?

interduo commented 7 years ago

poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "P\0\0\0\3SELECT 1 FROM snmpagent_cache WHERE oid = '.1.3.6.1.4.1.23925.1.14.1.1.653'", 84) = 84 read(5, "\1\0\0\1\1\27\0\0\2\3def\0\0\0\0011\0\f?\0\1\0\0\0\10\201\0\0\0\0\5\0\0\3\376\0\0\2\0\5\0\0\4\376\0\0\2\0", 16384) = 50 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\1\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.1.653', 'cactiApplDeviceIndex', 'CACTI-MIB', 'Unsigned32', 'DATA', 'Column Data', 'read-only', '653')", 261) = 261 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "$\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.2.653', 'cactiApplDeviceDescription', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', 'P2P-Niedzwiada-OstrowLubelski')", 296) = 296 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\r\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.3.653', 'cactiApplDeviceHostname', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '10.0.7.90')", 273) = 273 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\375\0\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.4.653', 'cactiApplDeviceStatus', 'CACTI-MIB', 'INTEGER', 'DATA', 'Column Data', 'read-only', '3')", 257) = 257 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\4\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.5.653', 'cactiApplDeviceEventCount', 'CACTI-MIB', 'Unsigned32', 'DATA', 'Column Data', 'read-only', '0')", 264) = 264 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\27\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.6.653', 'cactiApplDeviceFailDate', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '2017-01-02 17:20:37')", 283) = 283 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\33\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.7.653', 'cactiApplDeviceRecoveryDate', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '0000-00-00 00:00:00')", 287) = 287 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "O\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.1.14.1.8.653', 'cactiApplDeviceLastError', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', 'SNMP not performed due to setting or ping result., UDP ping error: timeout')", 339) = 339 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "O\0\0\0\3SELECT 1 FROM snmpagent_cache WHERE oid = '.1.3.6.1.4.1.23925.2.9.1.1.653'", 83) = 83 read(5, "\1\0\0\1\1\27\0\0\2\3def\0\0\0\0011\0\f?\0\1\0\0\0\10\201\0\0\0\0\5\0\0\3\376\0\0\2\0\5\0\0\4\376\0\0\2\0", 16384) = 50 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\1\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.1.653', 'cactiStatsDeviceIndex', 'CACTI-MIB', 'Unsigned32', 'DATA', 'Column Data', 'read-only', '653')", 261) = 261 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\r\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.2.653', 'cactiStatsDeviceHostname', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '10.0.7.90')", 273) = 273 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\n\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.3.653', 'cactiStatsDeviceMinTime', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '0.07892')", 270) = 270 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\f\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.4.653', 'cactiStatsDeviceMaxTime', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '507.96500')", 272) = 272 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\n\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.5.653', 'cactiStatsDeviceCurTime', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '0.52500')", 270) = 270 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\n\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.6.653', 'cactiStatsDeviceAvgTime', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '1.58972')", 270) = 270 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\10\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.7.653', 'cactiStatsDeviceTotalPolls', 'CACTI-MIB', 'Unsigned32', 'DATA', 'Column Data', 'read-only', '79363')", 268) = 268 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\6\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.8.653', 'cactiStatsDeviceFailedPolls', 'CACTI-MIB', 'Unsigned32', 'DATA', 'Column Data', 'read-only', '60')", 266) = 266 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\20\1\0\0\3INSERT IGNORE INTO snmpagent_cache (oid, name, mib, type, otype, kind, max-access, value) VALUES ('.1.3.6.1.4.1.23925.2.9.1.9.653', 'cactiStatsDeviceAvailability', 'CACTI-MIB', 'DisplayString', 'DATA', 'Column Data', 'read-only', '99.92440')", 276) = 276 read(5, "\7\0\0\1\0\1\0\2\0\0\0", 16384) = 11 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "$\0\0\0\3SELECT * FROM host WHERE id = '654'", 40) = 40 read(5, "\1\0\0\0014'\0\0\2\3def\5cacti\4host\4host\2id\2id\f?\0\10\0\0\0\t#B\0\0\0005\0\0\3\3def\5cacti\4host\4host\tpoller_id\tpoller_id\f?\0\n\0\0\0\3(@\0\0\0001\0\0\4\3def\5cacti\4host\4host\7site_id\7site_id\f?\0\n\0\0\0\3(@\0\0\0C\0\0\5\3def\5cacti\4host\4host\20host_template_id\20host_template_id\f?\0\10\0\0\0\t!\0\0\0\0009\0\0\6\3def\5cacti\4host\4host\vdescription\vdescription\f!\0\302\1\0\0\375\1\0\0\0\0003\0\0\7\3def\5cacti\4host\4host\10hostname\10hostname\f!\0\356\2\0\0\375\0\0\0\0\0-\0\0\10\3def\5cacti\4host\4host\5notes\5notes\f!\0\375\377\2\0\374\20\0\0\0\0?\0\0\t\3def\5cacti\4host\4host\16snmp_community\16snmp_community\f!\0,\1\0\0\375\0\0\0\0\0;\0\0\n\3def\5cacti\4host\4host\fsnmp_version\fsnmp_version\f?\0\1\0\0\0\1!\0\0\0\0=\0\0\v\3def\5cacti\4host\4host\rsnmp_username\rsnmp_username\f!\0\226\0\0\0\375\0\0\0\0\0=\0\0\f\3def\5cacti\4host\4host\rsnmp_password\rsnmp_password\f!\0\226\0\0\0\375\0\0\0\0\0G\0\0\r\3def\5cacti\4host\4host\22snmp_auth_protocol\22snmp_auth_protocol\f!\0\17\0\0\0\376\0\0\0\0\0K\0\0\16\3def\5cacti\4host\4host\24snmp_priv_passphrase\24snmp_priv_passphrase\f!\0X\2\0\0\375\0\0\0\0\0G\0\0\17\3def\5cacti\4host\4host\22snmp_priv_protocol\22snmp_priv_protocol\f!\0\22\0\0\0\376\0\0\0\0\0;\0\0\20\3def\5cacti\4host\4host\fsnmp_context\fsnmp_context\f!\0\300\0\0\0\375\0\0\0\0\0?\0\0\21\3def\5cacti\4host\4host\16snmp_engine_id\16snmp_engine_id\f!\0Z\0\0\0\375\0\0\0\0\0005\0\0\22\3def\5cacti\4host\4host\tsnmp_port\tsnmp_port\f?\0\5\0\0\0\t!\0\0\0\0;\0\0\23\3def\5cacti\4host\4host\fsnmp_timeout\fsnmp_timeout\f?\0\10\0\0\0\t!\0\0\0\0=\0\0\24\3def\5cacti\4host\4host\rsnmp_sysDescr\rsnmp_sysDescr\f!\0\204\3\0\0\375\1\0\0\0\0C\0\0\25\3def\5cacti\4host\4host\20snmp_sysObjectID\20snmp_sysObjectID\f!\0\300\0\0\0\375\1\0\0\0\0O\0\0\26\3def\5cacti\4host\4host\26snmp_sysUpTimeInstance\26snmp_sysUpTimeInstance\f?\0\n\0\0\0\3!\0\0\0\0A\0\0\27\3def\5cacti\4host\4host\17snmp_sysContact\17snmp_sysContact\f!\0\204\3\0\0\375\1\0\0\0\0;\0\0\30\3def\5cacti\4host\4host\fsnmp_sysName\fsnmp_sysName\f!\0\204\3\0\0\375\1\0\0\0\0C\0\0\31\3def\5cacti\4host\4host\20snmp_sysLocation\20snmp_sysLocation\f!\0\204\3\0\0\375\1\0\0\0\0I\0\0\32\3def\5cacti\4host\4host\23availability_method\23availability_method\f?\0\5\0\0\0\2!\0\0\0\0009\0\0\33\3def\5cacti\4host\4host\vping_method\vping_method\f?\0\5\0\0\0\2 \0\0\0\0005\0\0\34\3def\5cacti\4host\4host\tping_port\tping_port\f?\0\f\0\0\0\3 \0\0\0\0;\0\0\35\3def\5cacti\4host\4host\fping_timeout\fping_timeout\f?\0\f\0\0\0\3 \0\0\0\0;\0\0\36\3def\5cacti\4host\4host\fping_retries\fping_retries\f?\0\f\0\0\0\3 \0\0\0\0003\0\0\37\3def\5cacti\4host\4host\10max_oids\10max_oids\f?\0\f\0\0\0\3 \0\0\0\0?\0\0 \3def\5cacti\4host\4host\16device_threads\16device_threads\f?\0\2\0\0\0\1!\0\0\0\0003\0\0!\3def\5cacti\4host\4host\10disabled\10disabled\f!\0\6\0\0\0\376\10@\0\0\0C\0\0\"\3def\5cacti\4host\4host\20thold_send_email\20thold_send_email\f?\0\n\0\0\0\3\1\0\0\0\0C\0\0#\3def\5cacti\4host\4host\20thold_host_email\20thold_host_email\f?\0\n\0\0\0\3\1\20\0\0\0001\0\0$\3def\5cacti\4host\4host\7monitor\7monitor\f!\0\t\0\0\0\376\1\0\0\0\0;\0\0%\3def\5cacti\4host\4host\fmonitor_text\fmonitor_text\f!\0\375\377\2\0\374\21\20\0\0\0I\0\0&\3def\5cacti\4host\4host\23monitor_criticality\23monitor_criticality\f?\0\3\0\0\0\1!\0\0\0\0;\0\0'\3def\5cacti\4host\4host\fmonitor_warn\fmonitor_warn\f?\0\26\0\0\0\5\1\0\37\0\0=\0\0(\3def\5cacti\4host\4host\rmonitor_alert\rmonitor_al"..., 16384) = 3778 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "P\0\0\0\3SELECT 1 FROM snmpagent_cache WHERE oid = '.1.3.6.1.4.1.23925.1.14.1.1.654'", 84) = 84 read(5, "\1\0\0\1\1\27\0\0\2\3def\0\0\0\0011\0\f?\0\1\0\0\0\10\201\0\0\0\0\5\0\0\3\376\0\0\2\0\5\0\0\4\376\0\0\2\0", 16384) = 50 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, ":\0\0\0\3SELECT value FROM settings WHERE name = 'selective_debug'", 62) = 62 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\1\0\0\4\0\5\0\0\5\376\0\0\2\0", 16384) = 85 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "8\0\0\0\3SELECT value FROM settings WHERE name = 'log_verbosity'", 60) = 60 read(5, "\1\0\0\1\0015\0\0\2\3def\5cacti\10settings\10settings\5value\5value\f!\0\0000\0\0\375\1\0\0\0\0\5\0\0\3\376\0\0\2\0\2\0\0\4\0013\5\0\0\5\376\0\0\2\0", 16384) = 86

MySQL: 5.5.53-0+deb8u1

cigamit commented 7 years ago

Please start from a fresh installation and see if you can reproduce this. Thanks.

cigamit commented 7 years ago

Please start over with a fresh install from the latest development branch. There was an error in cacti.sql that caused some column ordering issues. After that, this problem will go away. We have addressed this issue by removing all graph templates from the default install. When you install, you have to pick the Device Templates that you are interested in.

interduo commented 7 years ago

I did a $ git pull -a

And then did a: $ php -e -q upgrade_database.php --forcever=0.8.8h

Now It hungs at: $ strace -p PID -s 2048 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout) write(5, "\211\0\0\0\3ALTER TABLE plugin_aggregate_graphs_graph_item ADD graph_type_id tinyint(3) NOT NULL default CURRENT_TIMESTAMP AFTER t_graph_type_id", 141) = 141 read(5, "2\0\0\1\377+\4#42000Invalid default value for 'graph_type_id'", 16384) = 54 poll([{fd=5, events=POLLIN|POLLPRI}], 1, 0) = 0 (Timeout)