Page 1 of 1
ERROR 2826 when querying configuration_parameters
Posted: Thu Apr 24, 2014 2:55 pm
by Josh
Anyone know why I might be getting this weird error?
Code: Select all
dbadmin=> select * from configuration_parameters where default_value = 1;
ERROR 2826: Could not convert "/opt/vertica/log/annotatedExplainSQL.sql" from column cp.default_value to a float8
I am using Vertica 7.0.1 on a DEV box...
Re: ERROR 2826 when querying configuration_parameters
Posted: Thu Apr 24, 2014 2:59 pm
by NorbertKrupa
Probably because the default_value column is a varchar:
Code: Select all
dbadmin=> SELECT column_name, data_type FROM system_columns WHERE table_name = 'configuration_parameters' ORDER BY ordinal_position;
column_name | data_type
-------------------------------+---------------
node_name | varchar(128)
parameter_name | varchar(128)
current_value | varchar(8192)
default_value | varchar(8192)
change_under_support_guidance | boolean
change_requires_restart | boolean
description | varchar(8192)
This works:
Code: Select all
select * from configuration_parameters where default_value = '1';
Re: ERROR 2826 when querying configuration_parameters
Posted: Thu Apr 24, 2014 3:38 pm
by Josh
Thanks, norbertk, that is what I figured... But I wonder if showing that SQL file as part of the error is a bug? Shouldn't the error be similar to the one shown on a normal user table?
Code: Select all
dbadmin=> create table test (t varchar(1));
CREATE TABLE
dbadmin=> insert into test values ('A');
OUTPUT
--------
1
(1 row)
dbadmin=> select * from test where t = 1;
ERROR 2826: Could not convert "A" from column test.t to a float8
Or maybe not
No biggie
Re: ERROR 2826 when querying configuration_parameters
Posted: Thu Apr 24, 2014 4:47 pm
by NorbertKrupa
May be a bug
Code: Select all
-- Vertica Analytic Database v7.0.1-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826: Could not convert "/opt/vertica/log/annotatedExplainSQL.sql" from column cp.default_value to a float8
-- Vertica Analytic Database v6.1.2-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826: Could not convert "" from column cp.default_value to a float8
-- Vertica Analytic Database v6.0.1-0
dbadmin=> SELECT * FROM configuration_parameters WHERE default_value = 1;
ERROR 2826: Could not convert "" from column cp.default_value to a float8
I reported it on the
Vertica Community.
Re: ERROR 2826 when querying configuration_parameters
Posted: Fri Apr 25, 2014 3:35 pm
by id10t
Hi!
[DELETED]
Re: ERROR 2826 when querying configuration_parameters
Posted: Fri Apr 25, 2014 3:39 pm
by NorbertKrupa
sKwa wrote:Will see if will be any movement.
I will be pleasantly surprised.