negative partition_key in partitions table?
Posted: Wed Dec 23, 2015 3:01 am
Does it make sense for the partition_key to be negative? I am seeing the following error in my application and then the following error on vertica.
011org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [SELECT DROP_PARTITION('<table name>', -17875912)]; [Vertica][VJDBC](5060) ERROR: Too many data partitions; nested exception is java.sql.SQLNonTransientException: [Vertica][VJDBC](5060) ERROR: Too many data partitions
vertica: Event Posted: Event Code:14 Event Id:261 Event Severity: Warning [4] PostedTimestamp: 2015-12-22 16:49:11.907154 ExpirationTimestamp: 2015-12-22 16:49:26.907154 EventCodeDescription: Timer Service Task Error ProblemDescription: threadShim: Too many data partitions DatabaseName: <db name> Hostname: <node hostname>
The above occurred with following settings in place:
ALTER DATABASE <db name> SET MergeOutInterval = 60;
ALTER RESOURCE POOL tm MEMORYSIZE '2G' MAXCONCURRENCY 6;
ALTER DATABASE <db name> SET MergeoutCache = 1;
What should I be investigating to figure out the "too many data partitions" errors?
011org.springframework.dao.DataAccessResourceFailureException: StatementCallback; SQL [SELECT DROP_PARTITION('<table name>', -17875912)]; [Vertica][VJDBC](5060) ERROR: Too many data partitions; nested exception is java.sql.SQLNonTransientException: [Vertica][VJDBC](5060) ERROR: Too many data partitions
vertica: Event Posted: Event Code:14 Event Id:261 Event Severity: Warning [4] PostedTimestamp: 2015-12-22 16:49:11.907154 ExpirationTimestamp: 2015-12-22 16:49:26.907154 EventCodeDescription: Timer Service Task Error ProblemDescription: threadShim: Too many data partitions DatabaseName: <db name> Hostname: <node hostname>
The above occurred with following settings in place:
ALTER DATABASE <db name> SET MergeOutInterval = 60;
ALTER RESOURCE POOL tm MEMORYSIZE '2G' MAXCONCURRENCY 6;
ALTER DATABASE <db name> SET MergeoutCache = 1;
What should I be investigating to figure out the "too many data partitions" errors?