Re: MySQL statement assistance with upgrade to 0.8.8
"Mark S. Turczan" <[email protected]>
| Newsgroups | gmane.network.cacti.user |
|---|---|
| Message-ID | <7908_1333550297_0M1Y00LGGLZR35A0_736C8E45-A76F-43CD-A02F-7E44E77AAB52@nyp.org> |
Tony, Thanks for the quick reply. It appears that we are using the MyISAM engine. mysql> show create table poller_output; -----------------------------------------------------------------------------------------------------------------------------------------------------+ | Table | Create Table | -----------------------------------------------------------------------------------------------------------------------------------------------------+ | poller_output | CREATE TABLE `poller_output` ( `local_data_id` mediumint(8) unsigned NOT NULL default '0', `rrd_name` varchar(19) NOT NULL default '', `time` datetime NOT NULL default '0000-00-00 00:00:00', `output` text NOT NULL, PRIMARY KEY (`local_data_id`,`rrd_name`,`time`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 | -----------------------------------------------------------------------------------------------------------------------------------------------------+ 1 row in set (0.00 sec) Regards, Mark On Apr 4, 2012, at 10:30 AM, Tony Roman wrote: > This failure, while bad looking, should be fine. > > That is unless the original index does not exist, in which case for the > version of mySQL you have, you want to remove "USING BTREE" from the end > of the alter. > > mySQL 5.0 does have support for BTREE index. I'm curious what engine > you are using for your Cacti database tables. Please send me a 'show > create table poller_output;' query. > > Thanks, > > Tony Roman > Cacti Developer > > > > On 4/4/12 10:08 AM, Mark S. Turczan wrote: >> Folks, >> >> I'm in the process of upgrading from 0.8.7g to 0.8.8. The installation script kicked back one error in the 0.8.7i -> 0.8.8 section of SQL statements: >> >> [Fail] ALTER TABLE `poller_output` ADD PRIMARY KEY (`local_data_id`, `rrd_name`, `time`) USING BTREE >> >> I logged into mysql as the root user and attempted to enter the command: >> >> mysql> ALTER TABLE `poller_output` ADD PRIMARY KEY (`local_data_id`, `rrd_name`, `time`) USING BTREE; >> >> but received the following error message: >> >> ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USING BTREE' at line 1 >> >> I'm looking at the manual for the ATLER TABLE syntax, and the statement looks correct. I'm using the following version of MySQL: Server version: 5.0.51a-24+lenny5 (Debian). >> >> All the other SQL statements succeeded. Can anyone shed some light as to why that one did not? >> >> Regards, >> >> Mark >> >> >> This electronic message is intended to be for the use only of the named recipient, and may contain information that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately by contacting the sender at the electronic mail address noted above, and delete and destroy all copies of this message. Thank you. >> >> >> -------------------- >> >> This electronic message is intended to be for the use only of the named recipient, and may contain information that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately by contacting the sender at the electronic mail address noted above, and delete and destroy all copies of this message. Thank you. >> >> >> >> >> -------------------- >> >> This electronic message is intended to be for the use only of the named recipient, and may contain information that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately by contacting the sender at the electronic mail address noted above, and delete and destroy all copies of this message. Thank you. >> >> >> >> >> ------------------------------------------------------------------------------ >> Better than sec? Nothing is better than sec when it comes to >> monitoring Big Data applications. Try Boundary one-second >> resolution app monitoring today. Free. >> http://p.sf.net/sfu/Boundary-dev2dev >> _______________________________________________ >> cacti-user mailing list >> [email protected] >> https://lists.sourceforge.net/lists/listinfo/cacti-user > > ------------------------------------------------------------------------------ > Better than sec? Nothing is better than sec when it comes to > monitoring Big Data applications. Try Boundary one-second > resolution app monitoring today. Free. > http://p.sf.net/sfu/Boundary-dev2dev > _______________________________________________ > cacti-user mailing list > [email protected] > https://lists.sourceforge.net/lists/listinfo/cacti-user -------------------- This electronic message is intended to be for the use only of the named recipient, and may contain information that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately by contacting the sender at the electronic mail address noted above, and delete and destroy all copies of this message. Thank you. -------------------- This electronic message is intended to be for the use only of the named recipient, and may contain information that is confidential or privileged. If you are not the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of the contents of this message is strictly prohibited. If you have received this message in error or are not the named recipient, please notify us immediately by contacting the sender at the electronic mail address noted above, and delete and destroy all copies of this message. Thank you. ------------------------------------------------------------------------------ Better than sec? Nothing is better than sec when it comes to monitoring Big Data applications. Try Boundary one-second resolution app monitoring today. Free. http://p.sf.net/sfu/Boundary-dev2dev