Page 1 of 2

Unable to Open database file Msg after 2.0.1

Posted: Mon Dec 31, 2012 6:24 pm
by RonCline
I loaded 2.0.1 and am now getting this message:
class db::DatabaseException SQLite Error 14: unable to open database file

I click "OK" and everything proceeds normally. However, message reappears every time I launch CN.

Re: Unable to Open database file Msg after 2.0.1

Posted: Tue Jan 01, 2013 6:20 am
by CintaNotes Developer
Hi Ron,
thanks for the report!
Could you please run CintaNotes with the "-d" command line switch and send me the log.txt file that is generated?
Thanks a lot!

Re: Unable to Open database file Msg after 2.0.1

Posted: Fri Jan 04, 2013 5:56 pm
by RonCline
The problem has been "solved", but I'll describe what happened. I ran from the command line and got "Cannot load notebook because the following path is inaccessible: c:\users\rcline\AppData\Roaming\CintaNotes. I got options to open existing, which I tried (but no .db file showed up in the list), or to "create new" which I did (making a test.db). That database opened up (blank of course) with the same error window as posted below. I went to Windows Explorer to look at the AppData directory, and both .db files were there (cintanotes and test). I deleted test.db, tried to reopen cintanotes (Windows launch), and the program did not open fully and hung. I had to force quit. I then re-launched from command line and got the "cannot load notebook" response again. This time, I typed in cintanotes.db, knowing it existed, and the program launched normally, with no error windows. I quit the program, and relaunched. A clean launch, with no error windows. So, for some reason, in the original situation below, it was able to see the cintanotes.db file, but it was complaining about something. (Still a mystery.) For reference, I'm including the .log file below, but I don't see anything interesting. You can consider this bug closed from my POV, since it's working again.

Timestamp Thread Forced Function Details
9:26:17.373694 6288 logging::Log::init Started logging
9:26:17.373694 6288 app::Application::init Turned debug logging on
9:26:17.373694 6288 app::Application::init commandLine=[-d]
9:26:17.436095 6288 app::Application::init Creating application message window
9:26:17.436095 6288 ui::ApplicationBase::onCreate Begin
9:26:17.436095 6288 ui::ApplicationBase::onCreate End
9:26:17.436095 6288 app::Application::tryOpenNoteLink Begin
9:26:17.436095 6288 app::Application::tryOpenNoteLink End
9:26:17.436095 6288 app::Application::tryOpenNotebookFile Begin
9:26:17.451695 6288 app::Application::tryOpenNotebookFile End
9:26:17.451695 6288 ui::ApplicationBase::quit Begin
9:26:17.451695 6288 ui::ApplicationBase::quit End
9:26:17.451695 6288 ui::ApplicationBase::run Begin
9:26:17.451695 6288 ui::ApplicationBase::run End
9:26:17.451695 6288 app::Application::~Application Begin
9:26:17.451695 6288 app::Application::~Application End
9:26:17.451695 6288 settings::ConfigurationLoader::~ConfigurationLoader Begin
9:26:17.451695 6288 settings::ConfigurationLoader::save Begin
9:26:17.451695 6288 settings::ConfigurationLoader::saveAs Begin
9:26:17.451695 6288 settings::ConfigurationLoader::saveAs End
9:26:17.451695 6288 settings::ConfigurationLoader::save End
9:26:17.451695 6288 settings::ConfigurationLoader::~ConfigurationLoader End

Re: Unable to Open database file Msg after 2.0.1

Posted: Fri Jan 04, 2013 6:19 pm
by RonCline
OK - now I'm getting the same, original message again. (Unable to open database file). It opens the cintanotes.db OK, but the error window pops up anyway.

I apparently triggered it when I deleted the test.db file. (I thought I had deleted it before, as mentioned in the previous post, but I was wrong.) This deletion is the only thing that changed. I have tried to create a new test.db file from the File...New drop down, but this doesn't make it happy.

I got the same result from the command line. Here's the log file.

Timestamp Thread Forced Function Details
10:18:27.396564 1036 logging::Log::init Started logging
10:18:27.396564 1036 app::Application::init Turned debug logging on
10:18:27.396564 1036 app::Application::init commandLine=[-d]
10:18:27.458965 1036 app::Application::init Creating application message window
10:18:27.458965 1036 ui::ApplicationBase::onCreate Begin
10:18:27.458965 1036 ui::ApplicationBase::onCreate End
10:18:27.458965 1036 app::Application::tryOpenNoteLink Begin
10:18:27.458965 1036 app::Application::tryOpenNoteLink End
10:18:27.458965 1036 app::Application::tryOpenNotebookFile Begin
10:18:27.474566 1036 app::Application::tryOpenNotebookFile End
10:18:27.474566 1036 ui::ApplicationBase::quit Begin
10:18:27.474566 1036 ui::ApplicationBase::quit End
10:18:27.474566 1036 ui::ApplicationBase::run Begin
10:18:27.474566 1036 ui::ApplicationBase::run End
10:18:27.474566 1036 app::Application::~Application Begin
10:18:27.474566 1036 app::Application::~Application End
10:18:27.474566 1036 settings::ConfigurationLoader::~ConfigurationLoader Begin
10:18:27.474566 1036 settings::ConfigurationLoader::save Begin
10:18:27.474566 1036 settings::ConfigurationLoader::saveAs Begin
10:18:27.474566 1036 settings::ConfigurationLoader::saveAs End
10:18:27.474566 1036 settings::ConfigurationLoader::save End
10:18:27.474566 1036 settings::ConfigurationLoader::~ConfigurationLoader End

Re: Unable to Open database file Msg after 2.0.1

Posted: Wed Jan 09, 2013 6:36 am
by CintaNotes Developer
Ron,
good news: we were able to reproduce the bug. To reproduce it, you have
to run 2 instances of CN, that is, you try to run CN when CN is already running.

We will fix this in 2.0.2!

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Jan 10, 2013 12:47 pm
by CintaNotes Developer
Please try this version: viewtopic.php?f=6&t=1494&p=6439#p6439

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Jan 10, 2013 10:03 pm
by RonCline
OK, Alex. Thanks!

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Jan 10, 2013 10:16 pm
by RonCline
Further info. (I'm keeping the current download for now.) As you probably suspected, I used a shortcut key to launch, not realizing that it was already running in my task bar. So I moved the launch shortcut key in Windows program properties to the hot key in the options for "show main window."

Now I'm fine.

Thanks again.

Re: Unable to Open database file Msg after 2.0.1

Posted: Fri Jan 11, 2013 11:48 am
by CintaNotes Developer
Great that the problem is solved, Ron! Thanks a lot for your help.

Re: Unable to Open database file Msg after 2.0.1

Posted: Wed Feb 27, 2013 11:53 pm
by tomterrific2000
I am running CintaNotes 2.0.4 and am getting the followin error on a random basis.

I was doing search and edits when it happened.

class db:DatabaseException
SQLite Error 5, database locked.

I also get the following when closing the program:

Runtime Error!
Program C:\Program Files\CintaNotes\cintanotes.exe
R6025
- pure virtual function call.

Tom

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Feb 28, 2013 9:33 am
by CintaNotes Developer
Hi Tom,
thanks for reporting!

Could you please tell, was Simplenote sync running when you got this error? Thanks!

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Feb 28, 2013 12:05 pm
by tomterrific2000
No, it was not.

I have multiple computers accessing a common database on a server. However I typically only have one machine active at any one time.

This error is happening while doing the following:

I open the main notes window.
I use the search function from there (cause I can't search within a specific note) to find text that I want to update.
I have noticed that upon entering the search data that the cursor blinks rapidly for a few seconds before displaying the note with the matching data.
Once the note has been located I will open it and edit the text that needs changing. I click 'Ok' to close the note so that the changes will take place since you can't just do a save and leave the note open for further searching or editing.
If I do a lot of editing it seems like that CintaNotes has a problem saving the data and produces the above error and sometimes other errors.
Sometimes it saves the changes, sometimes it dosen't. When it does save the data upon generating the error and I have to shut down the program and restart it.
Upon reopening the note the text may be changed but in addition random text has been converted to links and random highlighting of text has occurred.
It seems to happen particularly if I do a considerable number of edits after the search.
I will see if I can determine how to replicate the error because it has happened several times recently and I have a lot more editing to do.
I do have a question though, will there ever be a search and replace function implemented?
Thanks,

Tom

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Feb 28, 2013 1:18 pm
by CintaNotes Developer
Tom, could you please elaborate a bit about "accessing a common database on a server"?
Does it mean that the .db file is stored on a shared network drive?

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Mar 07, 2013 6:40 pm
by CintaNotes Developer
I do have a question though, will there ever be a search and replace function implemented?

Do you mean S&R within one note, or across many notes?

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Mar 07, 2013 7:07 pm
by tomterrific2000
CintaNotes Developer wrote:
I do have a question though, will there ever be a search and replace function implemented?

Do you mean S&R within one note, or across many notes?


Actually I my original question was around doing the search and replace within a single note however it would be a nice option to do it across several selected or All notes.

I think I have come to the conclusion that by just having CintaNotes open in 2 machines using a common database file caused my crashing problems.

Thanks,

Tom

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Mar 07, 2013 9:25 pm
by Thomas Lohrum
tomterrific2000 wrote:Actually I my original question was around doing the search and replace within a single note however it would be a nice option to do it across several selected or All notes.

You can vote for Search & Replace inside the editor here http://roadmap.cintanotes.com/topic/3169-search-and-replace-inside-of-note-edit-dialog/.

This one should handle the job for Search & Replace for a group of notes http://roadmap.cintanotes.com/topic/5689-batch-text-replace-across-all-notes-in-view/

Thomas

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Mar 07, 2013 10:17 pm
by tomterrific2000
Thomas Lohrum wrote:
tomterrific2000 wrote:Actually I my original question was around doing the search and replace within a single note however it would be a nice option to do it across several selected or All notes.

You can vote for Search & Replace inside the editor here http://roadmap.cintanotes.com/topic/3169-search-and-replace-inside-of-note-edit-dialog/.

This one should handle the job for Search & Replace for a group of notes http://roadmap.cintanotes.com/topic/5689-batch-text-replace-across-all-notes-in-view/

Thomas


I noted that both of these were updated 3 years ago. I guess it's really really really on the bottom of the implementation list.

I didn't see anywhere to 'vote' for either of the above options.

Thanks

Re: Unable to Open database file Msg after 2.0.1

Posted: Thu Mar 07, 2013 10:24 pm
by Thomas Lohrum
tomterrific2000 wrote:I didn't see anywhere to 'vote' for either of the above options.

Simply click on the icon which shows the number of votes.

Re: Unable to Open database file Msg after 2.0.1

Posted: Fri Mar 08, 2013 2:05 am
by CintaNotes Developer
tomterrific2000 wrote:Actually I my original question was around doing the search and replace within a single note however it would be a nice option to do it across several selected or All notes.

Thomas has already been kind enough to give the links to the relevant roadmap tickets.
I understand that it must be frustrating to see "last updated 3 years ago", but nevertheless,
they have currently 40 and 21 votes, which is not bad at all by our standards, so there's a real chance they will
be implemented this year.

I think I have come to the conclusion that by just having CintaNotes open in 2 machines using a common database file caused my crashing problems.

If you used a shared network drive, this can very likely be the case. Please use Simplenote or Dropbox sync for this puprose.
About both sync methods and which to prefer, you can read here: http://cintanotes.com/help.htm#sync

Re: Unable to Open database file Msg after 2.0.1

Posted: Mon Aug 26, 2013 12:41 pm
by axxo1
I wanted to vote too but I can't see any icon in there