View Issue Details

IDProjectCategoryView StatusLast Update
0000416SymmetricDSBugpublic2011-01-15 15:09
ReporterAssigned To 
Prioritynormal 
Status closedResolutionfixed 
Product Version2.2.2 
Target Version2.2.2Fixed in Version2.2.2 
Summary0000416: DB2 dialect is resetting auto-increments on sym_trigger_hist, _outgoing_batch, and _data every startup
DescriptionConfigurationService - Initializing SymmetricDS database. Db2v9DbDialect - Starting auto update of SymmetricDS tables. JdbcSupport - Borrowed connection org.apache.commons.dbcp.PoolableConnection@22712271 from data source JdbcSupport - Returning connection org.apache.commons.dbcp.PoolableConnection@22712271 to data source. Remaining connections: None ModelComparator - Index IDX_NODE_EL_STATS needs to be removed from table SYM_NODE_HOST_CHANNEL_STATS ModelComparator - Index idx_node_host_channel_stats needs to be created for table SYM_NODE_HOST_CHANNEL_STATS ModelComparator - Index IDX_NODE_ST_STATS needs to be removed from table SYM_NODE_HOST_STATS ModelComparator - Index idx_node_host_stats needs to be created for table SYM_NODE_HOST_STATS Db2v9DbDialect - Alter SQL Generated: DROP INDEX IDX_NODE_EL_STATS; DROP INDEX IDX_NODE_ST_STATS; CREATE INDEX idx_node_el_stats ON sym_node_host_channel_stats (node_id, start_time, end_time); CREATE INDEX idx_node_st_stats ON sym_node_host_stats (node_id, start_time, end_time); Db2v9DbDialect - Resetting auto increment columns for sym_trigger_hist Db2v9DbDialect - Resetting auto increment columns for sym_outgoing_batch Db2v9DbDialect - Resetting auto increment columns for sym_data ConfigurationService - No need to create channel config. It already exists. ConfigurationService - No need to create channel reload. It already exists. ConfigurationService - Done initializing SymmetricDS database. ClusterService - Failed to insert to the NODE_LOCK table for ROUTE. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for PULL. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for PUSH. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for HEARTBEAT. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for PURGE_INCOMING. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for PURGE_OUTGOING. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for PURGE_STATISTICS. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for SYNCTRIGGERS. Must be initialized already. ClusterService - Failed to insert to the NODE_LOCK table for PURGE_DATA_GAPS. Must be initialized already. SpringWireableSymmetricEngine - Starting registered node [group=corp, id=00000, externalId=00000]
TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change