1. Beatrix Willius
  2. Valentina Database ADK
  3. Dienstag, Dezember 08 2015, 05:11 PM
  4.  Abonnieren via E-Mail
Hi,

in the last week I got several crash reports from my app with the following stack trace:

2015-12-06, 17:44:19 An error happened:
2015-12-06, 17:44:19 Class/Method: DBWindow.DeleteAttachmentIDs
2015-12-06, 17:44:19 Time: Sonntag, 6. Dezember 2015 17:44:19 5978773
2015-12-06, 17:44:19 Type of Error: VException 365830 "embedded file" - EOF reached.
2015-12-06, 17:44:19 --------------------------
2015-12-06, 17:44:19 Stack:
2015-12-06, 17:44:19
Sub VDatabase.Flush()
Sub DBWindow.DeleteAttachmentIDs()
Function DBWindow.getBaseSQL() as string
Sub MainWindow.MainWindow.ResetMessageListCursor(MainWindow.MainWindow)

where the code that is crashing is as follows:

'prepare searching in attachments

if theDatabase = nil then Return
dim theSQL as String = "delete from AttachmentIDs"
dim theResult as Integer = theDatabase.SqlExecute(theSQL)
theDatabase.Flush

theSQL = "SELECT COUNT(*) FROM AttachmentIDs"
dim theCursor as VCursor = theDatabase.SqlSelect(theSQL)
if theCursor <> nil and theCursor.RecordCount > 0 and theCursor.Field(1).Value > 0 then
globals.theErrorLog.LogItem CurrentMethodName + " " + theCursor.Field(1).Value
end if

The code is used before executing a search and deletes data from the helper table AttachmentIDs.

Any idea what could cause this? As usual the databases that are affected by this are huge (>50 GB).

Different MacOSs, Xojo 2014r2, Valentina 5.8 I think.

Regards

Beatrix Willius
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi Beatrix,

You'd better check the db with Diagnose. It seems something wrong with the db.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Finally got a session log from a customer. See attached file. What could cause this problem? How do I fix it?

Mit freundlichen Grüßen/Regards

Trixi Willius

http://www.mothsoftware.com
Mail Archiver X: The email archiving solution for professionals
Anhänge
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi Beatrix,

Volume's SegmentMap errors are most hard ones. Practically, it could not be fixed since this is a map of particular volume segments - most valuable data structure in the volume. I would recommend to restore data from backups.

About the reasons.

Is there rollback-journal off? (If so - in case of any crash this map could be damaged because the only part of the map changes might be flushed on the moment of crash).
Probably user manually dropped journal file after the crash to "speed-up" restoring on the next run?


Is there possibility for some disk space starvation?
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Hi Ivan,

thanks for the reply.

The rollback-journal is always on. I will ask the customer if he deleted it.

Disk space starvation is unlikely. For the small SSDs I had to add a warning at 5 GB left and at 1 GB free space archival stops.
Kommentar
There are no comments made yet.
Beatrix Willius Akzeptierte Antwort
Got some feedback from the customer: he didn't delete the journal file. And there is 55 GB of free space on his harddisk. He is going to re-create the data from scratch.
Kommentar
There are no comments made yet.
Ivan Smahin Akzeptierte Antwort
Hi Beatrix,

Actually it is hard to say how it happened. One more idea is - is it possible to grab all relevant crash logs and send it to me?
Kommentar
There are no comments made yet.
  • Seite :
  • 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. 0 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories
Omegabundle
  1. 0 subcategories