1. Beatrix Willius
  2. as SQLite DB Server
  3. Вторник, Апрель 16 2024, 02:00 PM
  4.  Подписаться через email
For my server solution I'm using an SQLite database with an FTS table to search in emails. Now and then SQLite loses connection before Valentina Server. Then there is no error message. The code is really simple:


try

dim thePreparedStatement as VSqlitePreparedStatement = remote_db.PrepareEx("INSERT INTO bodyindex(docid, messagebody) VALUES(" + str(theRecID) + ", ?)")
thePreparedStatement.BindType(0, SQLitePreparedStatement.SQLITE_TEXT)

if MessageBody = "" then
thePreparedStatement.SqlExecute(App.MailFields.MessageBody)
else
thePreparedStatement.SQLExecute(MessageBody)
end if
thePreparedStatement = Nil

catch err as DatabaseException
Globals.theErrorLog.DialogErrorProceed kErrorWrite + " " + err.Message
globals.StopArchiving = True
catch err2 as NilObjectException
Return False
end try


Screenshot from the error message is attached.

Bug or feature?
Вложения
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
Well, you got some error during the "insert" - right? It seems it comes from Sqlite - it's not a Valentina error.
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
Yes, it comes from SQLite. But I'm using Valentina Server as SQLite server here. So why is there no error message?
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
What exactly returned in err.Message and err.Code?

Also, it would be helpful to see vServer log (verbooseLevel 3)
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
An empty string is returned. See screenshot.
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
So, it's your app message on the screenshot? How do you know that problem with updating the index?

err.Code is also zero? Is it reproducible? What about vServer log?
Комментарий
There are no comments made yet.
Ivan Smahin Ответ принят
What do you mean by "SQLite loses connection before Valentina Server."?
Комментарий
There are no comments made yet.
Beatrix Willius Ответ принят
err.message returned is an empty string. I'll make the user a new version to check err.number. The user had the same problem 2 times.

The error message showed up when the app lost connection to Valentina Server. Unfortunately, the error was just "unknown".
Комментарий
There are no comments made yet.
  • Страница :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories