View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001455 | SymmetricDS | Bug | public | 2013-10-28 14:13 | 2014-02-15 19:20 |
Reporter | mandreatta | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.5.10 | ||||
Target Version | 3.5.17 | Fixed in Version | 3.5.17 | ||
Summary | 0001455: Audit tables don't get created | ||||
Description | Audit table don't get created for InnoDB tables with autoincrement id: a fatal error is thrown. | ||||
Steps To Reproduce | import the following configuration: -------------------- insert into sym_node_group (node_group_id, description) values ('central', 'test central'); insert into sym_node_group (node_group_id, description) values ('local', 'dummy group'); insert into sym_node_group_link (source_node_group_id, target_node_group_id, data_event_action) values ('central', 'local', 'R'); insert into sym_node (node_id, node_group_id, external_id, sync_enabled) values ('000', 'central', '000', 1); insert into sym_node_identity values ('000'); insert into sym_channel (channel_id, processing_order, max_batch_size, enabled, description) values('general', 1, 100000, 1, 'my channel'); insert into sym_trigger (trigger_id,source_table_name,channel_id,last_update_time,create_time) values('test_trigger','test_table','general',current_timestamp,current_timestamp); insert into sym_router (router_id,source_node_group_id,target_node_group_id,router_type,create_time,last_update_time) values('auditcentral', 'central', 'local', 'audit',current_timestamp, current_timestamp); insert into sym_trigger_router (trigger_id,router_id,last_update_time,create_time) values('test_trigger','auditcentral',current_timestamp, current_timestamp); CREATE TABLE test_table ( id smallint(6) NOT NULL AUTO_INCREMENT, desc varchar(50) NOT NULL, PRIMARY KEY (id) ) ENGINE=InnoDB; ------- Then make some change to test_table like: INSERT INTO test_table (desc) VALUES ('test'); A running symmetricdb instance should report something like: [logiko-000] - RouterService - Failed to route and batch data on 'general' channel org.jumpmind.db.platform.DdlException: org.jumpmind.db.model.ModelException: Column id in table test_table_audit is auto-incrementing but not a primary key column, which is not supported by the platform ... | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2013-10-28 14:13 | mandreatta | New Issue | |
2014-02-07 00:48 | chenson | Assigned To | => chenson |
2014-02-07 00:48 | chenson | Status | new => assigned |
2014-02-07 00:49 | chenson | Target Version | => 3.5.17 |
2014-02-07 01:53 | chenson | Status | assigned => resolved |
2014-02-07 01:53 | chenson | Fixed in Version | => 3.5.17 |
2014-02-07 01:53 | chenson | Resolution | open => fixed |
2014-02-07 01:53 | chenson | Note Added: 0000467 | |
2014-02-07 02:00 | Changeset attached | => SymmetricDS trunk r7924 | |
2014-02-15 19:20 | chenson | Status | resolved => closed |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master 547036e2 |