-----Urspr�ngliche Nachricht----- Von: Anhaus, Thomas [mailto:[EMAIL PROTECTED] Gesendet: Donnerstag, 8. Juli 2004 07:40 An: 'Richard Martin'; [EMAIL PROTECTED] Betreff: AW: cannot see/select triggers after migration from 7.4 to 7.5
Richard Martin wrote : > >Hi, > >After migrating the DB to 7.5.0.14, I cannot see/select the existing >triggers (SELECT triggername, definition FROM DOMAIN.TRIGGERS ==> No >Result). I also cannot create new triggers. (Syntax error or access >violation;-5001 POS(1) Missing privilege:NO TRIGGERS FOR >REPLICATION USER). >But the (now "invisible") triggers I migrated with (as >everything else in >the DB) work very well. > >So, i got problem with privileges(?) which I do not >understand, because I >did not change any user/usergroups/owner and before the migration every >trigger was shown. >Who is this REPLICATION USER - did I do things wrong with the >migration-backup/restore? > >Sorry if this question might be too trival but I could not >find any hint. > >Ciao, >Richard > > >-- >MaxDB Discussion Mailing List >For list archives: http://lists.mysql.com/maxdb >To unsubscribe: >http://lists.mysql.com/maxdb?>[EMAIL PROTECTED] > With 7.5 the new user property 'replication user' has been introduced for replication support. This requires a new flag in the catalog which tells whether a user is a replication user. This flag must be set by a migration, which automatically starts at the first restart with 7.5. In seems that this migration didn't happen in your database. For further analysis please tell me the the version of your last 7.4 installation. However, I fear there is no workaround for the problem and you will have to wait until a patch is available. Best Regards, Thomas Hi Thomas, thanks for your fast reply. The old system had/has the version: X32/Linux 7.4.3 Build 030-121-056-274. backup: I am not sure if we used a script or DBMGUI restore: DBMGUI 7.5.0.11 Right now the problem are not the triggers itself, but I cannot alter tables, getting the same error message. For the next days I try to migrate back to 7.4.3.30 and see what happens (if neccessary using the loader). Ciao, Richard -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
