Skip to main content

Vertica 7 linux odbc driver always displays debug message

  • February 6, 2014
  • 1 reply
  • 7 views

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

1 reply

Jack_Pan
  • Author
  • New Participant
  • February 6, 2014
It turns out to be the loglevel setting in vertica.ini was changed. It's fixed now.