Seeing this error in multiple collector logs: Unable to create partition for <timestamp>

Document ID : KB000030494
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

Seeing this error in multiple collector logs:

[ERROR] [SessionPartition.Thread1] [Manager.com.timestock.tess.util.DbUtils] Unable to create partition for <timestamp>
[ERROR] [SessionPartition.Thread1] [Manager.com.timestock.tess.util.DbUtils] Execute failed for SQL DDL 'ALTER TABLE ts_us_sessions_map ADD PARTITION ts_us_sessions_map_<timestamp> VALUES LESS THAN (TIMESTAMP 'xyz')'

 

Solution:

Note this issue is not related to Daylight Saving Time (DST).

An important clue is that the same error is seen in multiple collector logs. This is due to the collectors trying to create the same partitions simultaneously (and failing). This may be caused by a duplicate entity.guid which occurs when the user copies the EM installation instead of running the installer for a new collector. Each GUID needs to be unique for each collector EM, otherwise the collectors are not treated as separate entities.


Steps to resolve the issue with duplicate GUID causing Tim Collection Service to run on multiple Collectors:

1) Assign to one collector the TIM Collection Service (TCS) and leave this collector running
2) Stop all other collectors and delete tess.internal.properties on these collectors (this file is located in the directory "<APM_INSTALL>/config/internal/server")
3) Restart all of the collectors you stopped in step 2. The file "tess.internal.properties" will be automatically re-created with a unique GUID.
4) Let the collectors run, and verify in the collector EM logs the error no longer occur, and the partitions are being created.