Hi everyone,
I have a view which produces an "Uncommited transactions" error message whenever I open it from within dbForgeStudio for MySQL on a remote machine. The message also has "Document: dorisdb_vwsearchresultsbasb.sql" ("dorisdb" being the database and "vwsearchresultsbasb" the view name )and "Transaction count: 1". The structure of the view appears to be fine, but when I did a backup and attempted to restore to another database on the same MySQL Server it complained about an unknown field. The unknown field is the field in the view as it was before I made a change to the view.
If I stop the MySQL Server and then restart it, I get the same error message when I open the view in dbForgeStudio. Note that if I run Workbench on the machine hosting the MySQL Server and open the view I get no error message.
I need to make some important further changes to the database and really, really do need to ensure I can back it up and restore it if anything goes wrong. How do I find out what is causing the problem and how do I stop it happening, please?
Please note that I only an occasional user of MySQL and am generally using this for data accessed by Microsoft Access.
"Uncommited transactions" appears when opening a view
-
- Posts: 8
- Joined: Wed 27 May 2015 12:34
Re: "Uncommited transactions" appears when opening a view
We will investigate this issue and will answer you as soon as possible.
Re: "Uncommited transactions" appears when opening a view
We are aware of this issue.I have a view which produces an "Uncommited transactions" error message whenever I open it from within dbForgeStudio for MySQL on a remote machine.
Currently, you can resolve this by turning on Paginal mode:
1. Select 'Tools -> Options...' from the main menu. The 'Options' window opens.
2. Navigate to the 'Data Editor -> General' branch.
3. Select the 'Use paginal mode by default' option.
Could you please let us know if the issue is reproducible and, if so, describe the steps to reproduce it providing the CREATE definitions of the view? Please also specify what columns were added/deleted so we can reproduce the issue on our side.when I did a backup and attempted to restore to another database on the same MySQL Server it complained about an unknown field. The unknown field is the field in the view as it was before I made a change to the view.
-
- Posts: 8
- Joined: Wed 27 May 2015 12:34
Re: "Uncommited transactions" appears when opening a view
Hi,
Thanks for this reply. However, I had had to get round this urgently and did something else (rebuilt the view???). If it happens again, I'll certainly try out your suggestion and let you know how I get on.
Thanks for this reply. However, I had had to get round this urgently and did something else (rebuilt the view???). If it happens again, I'll certainly try out your suggestion and let you know how I get on.
Re: "Uncommited transactions" appears when opening a view
Hi,
We would be much obliged if you could come back then to us.Alan Cossey wrote: ↑Thu 16 Aug 2018 06:40 Hi,
Thanks for this reply. However, I had had to get round this urgently and did something else (rebuilt the view???). If it happens again, I'll certainly try out your suggestion and let you know how I get on.
-
- Posts: 8
- Joined: Wed 27 May 2015 12:34