Vertica 7 linux odbc driver always displays debug message

Jack_Pan

After upgraded from 6.1 to 7, the odbc query now dumps a lot of debug messages onto console:

Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_BIGINT
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_WVARCHAR
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_TYPE_TIME
Feb 05 11:42:11 INFO  693212928 VPQResultSet::SetupColumns: column type is SQL_WVARCHAR

I'm using pydbc with vertica v7 odbc driver on ubuntu. This doesn't seem to happen with v6.1 driver. Is there a flag I can set to turn this off?

Thanks,

Jack

Jack_Pan

It turns out to be the loglevel setting in vertica.ini was changed. It's fixed now.