Re: [Cppcms-users] CPPDB - connection time out

[Artyom B. <art...@ya...>]

Try to run the program with strace:

   strace ./program_name

And see what exactly happens - why sqlite fails to open the DB.
Maybe something happens there that you are not aware of?

See why open() fails.
 
Artyom Beilis
--------------
CppCMS - C++ Web Framework:   http://cppcms.com/
CppDB - C++ SQL Connectivity: http://cppcms.com/sql/cppdb/



>________________________________
> From: "la...@sa..." <la...@sa...>
>To: Artyom Beilis <art...@ya...>; cpp...@li... 
>Sent: Friday, July 6, 2012 6:16 PM
>Subject: Re: [Cppcms-users] CPPDB - connection time out
> 
>
> 
>
>The error I am having is: "Error: Unable to open database file".
>
>I have a connection -> cppdb::session sql("sqlite3:db=/home/common/source/DB/Mdata.db");
>
>I have a process that does a lot of selects, and updates, but always after aproximatly 600 seconds i get this error, .... I also found that this error occurs when i try to do an update (when i do stat.exec()).
>
>my updates are like this (It works fine, on the first 600 seconds, and then it gives an error):
>//////////////////////////////////////////////
>stat = sql << "update reading_h set read_id = ?, date = ?, time = ? where read_id = ? and mrg_id = ?" << readId << date << time << headerReadId  << mrgId;
>stat.exec();
>stat.reset();
>stat.clear();
>/////////////////////////////////////////////
>
> 
>Quoting Artyom Beilis <art...@ya...>:
>There is no such thing as "lost a connection" with sqlite3 DB...
>>The sqlite3 database is a file and database engine operates on the file
>> 
>>Artyom Beilis
>>--------------
>>CppCMS - C++ Web Framework:   http://cppcms.com/
>>CppDB - C++ SQL Connectivity: http://cppcms.com/sql/cppdb/
>>
>>
>>
>>>________________________________
>>> From: "la...@sa..." <la...@sa...>
>>>To: cpp...@li...
>>>Sent: Friday, July 6, 2012 1:58 PM
>>>Subject: [Cppcms-users] CPPDB - connection time out
>>>
>>>Hi,
>>>I am working with cppdb, with sqlite.
>>>
>>>I am doing a connection with cppdb::session 
>>>sql("sqlite3:db=/home/common/source/DB/Mdata.db");
>>>
>>>But i think i lost connection after 600 seconds (10min). I already try 
>>>to change to, 'opt_reconnect = 1',
>>>
>>>but still does not work, .... i have always error after 10min. Error: 
>>>Unable to open database connection.
>>>
>>>
>>>
>>>
>>>
>>>Thanks,
>>>Leandro
>>>
>>>
>>>
>>>------------------------------------------------------------------------------
>>>Live Security Virtual Conference
>>>Exclusive live event will cover all the ways today's security and
>>>threat landscape has changed and how IT managers can respond. Discussions
>>>will include endpoint security, mobile security and the latest in malware
>>>threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>>>_______________________________________________
>>>Cppcms-users mailing list
>>>Cpp...@li...
>>>https://lists.sourceforge.net/lists/listinfo/cppcms-users
>>>
>>> 
>
>
>
>------------------------------------------------------------------------------
>Live Security Virtual Conference
>Exclusive live event will cover all the ways today's security and 
>threat landscape has changed and how IT managers can respond. Discussions 
>will include endpoint security, mobile security and the latest in malware 
>threats. http://www.accelacomm.com/jaw/sfrnl04242012/114/50122263/
>_______________________________________________
>Cppcms-users mailing list
>Cpp...@li...
>https://lists.sourceforge.net/lists/listinfo/cppcms-users
>
>
>