View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
0001082 | SymmetricDS | Bug | public | 2013-02-28 14:42 | 2014-02-03 01:53 |
Reporter | rbro | Assigned To | chenson | ||
Priority | normal | ||||
Status | closed | Resolution | fixed | ||
Product Version | 3.3.1 | ||||
Target Version | 3.3.3 | Fixed in Version | 3.3.3 | ||
Summary | 0001082: MySQL - error calling unknown function sym_transaction_idnull() | ||||
Description | From http://sourceforge.net/p/symmetricds/discussion/739236/thread/aed21be1: I'm running into an issue on MySQL where some of my generated triggers are referencing a function called sym_transaction_idnull(), so my queries to the affected tables are failing since that function doesn't exist. I tried to resync triggers, but the call to that missing function remains. How can I resolve this issue? I was running on version 3.2.3, but after getting the error, I upgraded to 3.3.1 with the same results. The only way I was able to get around it was to delete the sym_trigger and sym_trigger_hist rows for the affected tables, then re-add the sym_trigger rows, and then regenerate triggers. | ||||
Tags | No tags attached. | ||||
Date Modified | Username | Field | Change |
---|---|---|---|
2013-02-28 14:42 | rbro | New Issue | |
2013-03-01 01:47 | chenson | Status | new => resolved |
2013-03-01 01:47 | chenson | Fixed in Version | => 3.3.3 |
2013-03-01 01:47 | chenson | Resolution | open => fixed |
2013-03-01 01:47 | chenson | Assigned To | => chenson |
2013-03-01 01:47 | chenson | Note Added: 0000220 | |
2013-03-01 11:15 | chenson | Status | resolved => closed |
2013-03-01 12:51 | chenson | Summary | error calling unknown function sym_transaction_idnull() => MySQL - error calling unknown function sym_transaction_idnull() |
2014-02-03 01:53 | Changeset attached | => SymmetricDS trunk r6906 | |
2015-07-31 01:49 | chenson | Changeset attached | => SymmetricDS master ac90aad4 |