on 04-14-2015 9:14 AM
We try to do an export/Import (from 7.6 to 7.8 in RECORDS format) with the loadercli Version 7.8.02.39 (same for 7.6er) and face one interesting difficulty:
When exporting the more complex parts of the catalog in the catalog0001 file (views, triggers, functions), the loader seems not to honour any required order of statements; that is if we for example have a view that needs a user-defined function for it's creation, the view is tried to be created before the function (much earlier in the file). Of course this does not work. The same seems to apply to functions and triggers depending on each other.
Of course we can manually reorder those things (and will ), but since this seems a little weird to me (loader completely ignoring such constraints) and I could not find anything in the documentation I would like to ask for any hints.
Thanks a lot,
urs
Thank you for reporting this bug. We will fix this via bug tracking id PTS1253606. If you want, I can send you a preliminary bug fix for testing (new loadercli executable) once it is available.
Kind regards,
Thorsten
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Thorsten,
Great. We already did our migration to 7.8 on Saturday (had to - sorry), but will be happy to test that and yes we are on Linux x86_64 (sorry for not mentioning).
I don't like to sound too greedy, but we seem to have discovered some other little loader problems that we needed to circumvent:
By the way one more novice question: I could not find a system table holding those execute rights on functions like 'FUNCTIONPRIVILEGES'. Where are these kept?
Best Regards,
Urs
Hi Urs,
here is the download link for the new Loader version (will be part of 7.8.02.42):
In response to your questions:
1. Sequences should not be missing from the Export. Can you double check with the new Loader version?
2. Grants on functions are indeed missing - we will to bug fix this, but it might take some time...
3. And indeed the system table holding the execute rights on FUNCTIONPRIVILEGES is also missing - it seems this feature was not fully implemented - we will also address this problem and fix it.
Regards,
Thorsten
Hi Thorsten,
Sorry for the delay ... I still cannot provide a full test report right now, but at least it seems to run much smoother than 7.8.02.39. I could export/import a smaller test database with only one error in the catalog script (despite many of them before).
Most funny the single error was a duplicate statement like:
CREATE VIEW bla AS ...
CREATE VIEW bla AS ...
I can of course provide more information on our DB, but not here in the open forum.
I will continue to run a bigger test as well.
Regards,
Urs
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.