Forum

Kognitio Console issues, advice, etc.
Contributor
Offline
Posts: 184
Joined: Wed May 29, 2013 2:10 pm
Location: Bracknell

Console Version 80199s170522

by MikeAtkinson » Tue May 16, 2017 2:56 pm

This is a bugfix release of Console. Several bugs to do with aborting queries and scripts have been fixed.

Features
    1. Run metadata queries unqueued in Kognitio 8.2.
    2. Colour views chocolate in the metadata tree if all dependencies are in RAM.
    3. Colour depend on and dependencies in View Object View Dependencies tab.
    4. Improve Check Query to look at expected rows, cost and in-ram status of tables/views in query.
    5. Colour views chocolate if view does not touch disk or external table.
    6. Allow parallel load when copying table between systems.
Bug Fixes
    1. Avoid potential for crashes when connecting/connected to restarted Kognitio systems
    2. Crash in QueueUserListWidget::contextMenuEvent().
    3. Ensure that the statementMap cannot contain invalid statements for line numbers.
    4. Attempt to fix occasional crash when getting ODBC errors - seems to be invalid handle.
    5. If the query is a picture, explain or diagnose, don't do the picture before execution, etc.
    6. Crash in ImplWxScript::doDebugHook() during Console shutdown.
    7. Crash: Drop user's default schema while viewing User Object View, make change and then save changes.
    8. Crash: Drop user's security class while viewing User Object View, make change and then save changes.
    9. Crash: viewing a User Object View from another user which does not have privileges to view queues.
    10. WORKSPACE_SIZE and INSERTBUF_SIZE removed from ipe_allram_access.
    11. Dropping table images does not reset some internal state.
    12. Add in a short delay before schema update after detecting script "create table ...", etc.
    13. ; within comment within sql statement causes kog script parsing to go wrong.
    14. Various problems with characters within comments with sql statements within kog scripts.
    15. Don't show the System Monitor Tool in the Panes menu if its UI has been disabled.
    16. Remove Web from View -> Panes menu.
    17. If the script has changed always get the new first statement.
    18. Crash after discard results of most recent “execute statement” command.
    19. Don’t show the System Monitor Tool in the Panes menu if its UI has been disabled.
    20. Don’t restore from .sav files if they are empty.
    21. Send Console bugs to console-bugs AT kognitio.com
    22. Don’t change to kog script after we have decided to start running as an SQL script.
    23. External scripts not inserted in correct schema in metadata tree.
    24. External scripts no removed from metadata tree when removed from database in all cases.
    25. View dependency on external scripts not queried correctly.
    26. Avoid adding domains twice into the metadata tree.
    27. Improve: External scripts no removed from metadata tree when removed from database in all cases.
    28. Update Console configuration backup whenever console is run.
    29. Disable invalid script options.
    30. Minor bug in dependency processing.
    31. Crash when "Check Tables ..." with no connected database.
    32. Allow parallel load when copying table between systems.
    33. Fix some potential null pointer exceptions.
    34. ActivityLog sometimes crashes.
    35. Prevent lock-ups of the UI due to SQLProcessor being locked (e.g. waiting for a server restart).
    36. Crash if invalid database in Systems pane.
The main enhancement is colouring in views that have all their dependencies in RAM in a chocolate colour, this includes views that depend on tables that have horizontally or vertically fragmented images as for those we parse the output of explain select * from <view>;

Image

A similar parsing of the output of explain <statement> is used to extract the estimated rows, cost and whether the source is in ram for the “statement” -> “check query” pop-up menu item.

Image

Also metadata queries are now run unqueued for all users in Kognitio 8.2 (used to be only for sys). This should avoid long delays while console is waiting for the results of a metadata query which is held up waiting on a queue. Metadata queries should be much faster on most Kognitio 8.2 systems.

This release may be obtained through the Version Check tool within Kognitio Console. This may be turned on by selecting "Enable check for updates" in the configuration "Miscellaneous" pane.

It is also available from our updates website http://updates.kognitiocloud.com.s3.ama ... 170522.exe
Reply with quote Top

Who is online

Users browsing this forum: No registered users and 1 guest

cron