1. Smart City doo
  2. Valentina Server
  3. Sunday, May 03 2020, 11:42 PM
  4.  Subscribe via email
field type: TEXT
segment size is: 128

after some time diagnose result is:


==========> Field: completeInfo , type Text
.....> SegmentFile:
Segment 6479 has wrong mIndex must be 5 in fact 2
Segment 6479 has wrong mFirstSegment must be 6475 in fact 232341
Segment 6479 has wrong mPrevSegment must be 6478 in fact 232341

Problems found! ( SegmentFile: )


Problems found! ( Field: completeInfo , type Text )


Reindex can not help.

Any solution?
Comment
There are no comments made yet.
Ruslan Zasukhin Accepted Answer
Hi,

db.Clone usually is able to fix.

Can you add please using which engine version and which OS you have got this?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 1
Smart City doo Accepted Answer
I am using windows OS, VServer version 10.1.2.

Is there any "hot" solution for fixing?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 2
Ruslan Zasukhin Accepted Answer
Yes, you can call db.Clone() from your app if Diagnose() returns issue.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 3
Smart City doo Accepted Answer
Does segmentSize of text field (blob) affect on this problem?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 4
Ruslan Zasukhin Accepted Answer
There is no such information, that it affects.

Please keep eye on your db, maybe you will notice when and how this comes.
We did a lots of efforts to reproduce it, and no way so far.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Server
  3. # 5
  • Page :
  • 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