Unable to Open database file Msg after 2.0.1

RonCline
Posts: 5
Joined: Mon Dec 31, 2012 6:18 pm
Contact:

Unable to Open database file Msg after 2.0.1

Postby RonCline » Mon Dec 31, 2012 6:24 pm

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.
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Tue Jan 01, 2013 6:20 am

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!
Alex
RonCline
Posts: 5
Joined: Mon Dec 31, 2012 6:18 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby RonCline » Fri Jan 04, 2013 5:56 pm

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
RonCline
Posts: 5
Joined: Mon Dec 31, 2012 6:18 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby RonCline » Fri Jan 04, 2013 6:19 pm

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
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Wed Jan 09, 2013 6:36 am

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!
Alex
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Thu Jan 10, 2013 12:47 pm

Please try this version: viewtopic.php?f=6&t=1494&p=6439#p6439
Alex
RonCline
Posts: 5
Joined: Mon Dec 31, 2012 6:18 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby RonCline » Thu Jan 10, 2013 10:03 pm

OK, Alex. Thanks!
RonCline
Posts: 5
Joined: Mon Dec 31, 2012 6:18 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby RonCline » Thu Jan 10, 2013 10:16 pm

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.
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Fri Jan 11, 2013 11:48 am

Great that the problem is solved, Ron! Thanks a lot for your help.
Alex
tomterrific2000
Posts: 4
Joined: Wed Feb 27, 2013 11:37 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby tomterrific2000 » Wed Feb 27, 2013 11:53 pm

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
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Thu Feb 28, 2013 9:33 am

Hi Tom,
thanks for reporting!

Could you please tell, was Simplenote sync running when you got this error? Thanks!
Alex
tomterrific2000
Posts: 4
Joined: Wed Feb 27, 2013 11:37 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby tomterrific2000 » Thu Feb 28, 2013 12:05 pm

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
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Thu Feb 28, 2013 1:18 pm

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?
Alex
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Thu Mar 07, 2013 6:40 pm

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?
Alex
tomterrific2000
Posts: 4
Joined: Wed Feb 27, 2013 11:37 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby tomterrific2000 » Thu Mar 07, 2013 7:07 pm

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
Thomas Lohrum
Posts: 1324
Joined: Tue Mar 08, 2011 11:15 am

Re: Unable to Open database file Msg after 2.0.1

Postby Thomas Lohrum » Thu Mar 07, 2013 9:25 pm

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
tomterrific2000
Posts: 4
Joined: Wed Feb 27, 2013 11:37 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby tomterrific2000 » Thu Mar 07, 2013 10:17 pm

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
Thomas Lohrum
Posts: 1324
Joined: Tue Mar 08, 2011 11:15 am

Re: Unable to Open database file Msg after 2.0.1

Postby Thomas Lohrum » Thu Mar 07, 2013 10:24 pm

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.
User avatar
CintaNotes Developer
Site Admin
Posts: 5001
Joined: Fri Dec 12, 2008 4:45 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby CintaNotes Developer » Fri Mar 08, 2013 2:05 am

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
Alex
axxo1
Posts: 1
Joined: Mon Aug 26, 2013 12:38 pm
Contact:

Re: Unable to Open database file Msg after 2.0.1

Postby axxo1 » Mon Aug 26, 2013 12:41 pm

I wanted to vote too but I can't see any icon in there

Return to “Bug Reports”