View Issue Details

IDProjectCategoryView StatusLast Update
0008797VALENTINA SERVERDatabasepublic2020-06-02 12:30
ReporterAleksandar SpasojevicAssigned To 
PriorityhighSeveritymajorReproducibilitysometimes
Status newResolutionopen 
PlatformWindowsOSWindows ServerOS Version2019
Product Version 
Target VersionFixed in Version 
Summary0008797: Partly damaged Database usage under Windows Server 2019
DescriptionI cannot open DB backups on Windows Server 2019. VStudio returns 'Cannot open database'. Copy DB on Windows 10 works .
Also, under Windows Server 2019, I cannot do diagnose of DB under VServer through VStudio, it returns 'Sql error', Same goes for Reindex, Defragment, Compact,..
On Windows 10, same DB is working normally, except diagnose returns few segment problems.
TagsNo tags attached.

Activities

Ivan Smahin

Ivan Smahin

2020-05-27 05:23

manager   ~0011295

Well, what about some fresh/new db under Windows Server 2019? Is it working there?
Aleksandar Spasojevic

Aleksandar Spasojevic

2020-05-27 08:15

reporter   ~0011296

New DB is working there.
Currently, I am checking one of the backups which cannot be opened under Windows Server 2019.
On Win 10, same DB is opened without problems and diagnose shows no error.
I am using VStudio 10.4.1 on both machines.

I can send you that database if you give me mail address.
Ivan Smahin

Ivan Smahin

2020-05-27 11:03

manager   ~0011299

ivan_smahin at paradigmasoft.com
Aleksandar Spasojevic

Aleksandar Spasojevic

2020-05-27 11:16

reporter   ~0011301

DB sent.
Just checked one more time on Win Server. If I delete index file and then try to open DB, it creates .ind with only 68KB every time and then shows error.
Ivan Smahin

Ivan Smahin

2020-05-30 07:16

manager   ~0011309

1. Well, db is diagnosed ok first time, but second time - there are few index problems found. We will check what's wrong there.

2. Do you mean "local db mode" for both 2016 and 2019 Windows Server or the db is under vServer? If it was "remote db" - please specify - is there the same vServer instance for both cases or not. BTW, if we are talking of vServer - it does not matter (almost ) which vStudio version is, in this case vServer versions are much more important.

3. I'm not sure that your issues are result of 2019/2016 Windows Server differences (BTW, following some sources - late 2016 is the same as 2019). So, please check your hardware. You are the first who reported such things like zeroed INI file, unable to open db on the particular OS, etc...
Aleksandar Spasojevic

Aleksandar Spasojevic

2020-05-30 09:32

reporter   ~0011310

I understand that about Windows Server 2019 being almost same as 2016, but we are not using both Windows Server 2016 and Windows Server 2019 here. What I am comparing is different behavior on Windows 10 and Windows Server 2019.

I am currently using these versions on both Windows 10 and Windows Server 2019:
vServer: 10.1.2
vStudio: 10.4.1

Problems are happening in both modes ( local and remote ).
In local mode, on Windows Server 2019, database cannot be opened, and same database is opened using same vStudio version on Win 10.
In remote mode, db cannot be diagnosed on Windows Server 2019, but same database on Windows 10 in remote mode can be diagnosed.
For testing this, I used 3 separate Windows Server 2019 machines.

Zeroed INI file happened on multiple machines, with Win 10, Win Server 2012 and Win Server 2019,
Ivan Smahin

Ivan Smahin

2020-05-30 09:55

manager   ~0011311

>> For testing this, I used 3 separate Windows Server 2019 machines.

Does it mean there is the same issues on all that machines?
All that machines have own disk storages, etc.. - no shared components like same disk drive?
Aleksandar Spasojevic

Aleksandar Spasojevic

2020-05-30 10:20

reporter   ~0011312

Let's call these 3 machines PAM1, PAM2 and PAM3
PAM1 and PAM2 have shared storage. On them we have Windows Failover Cluster, and using disk from other storage which is connected as iSCSI target. DB is on that disk, connected through 20Gbps network.

On PAM3, DB is on system SSD, in original location (C:\Program Files\Paradigma Software\VServer x64\databases).
PAM1 and PAM2 have multiple networks, They have 20Gbps and 10Gbps networks where is 20Gbps teaming between 2 cards.
PAM3 have 20Gbps which is teaming between 2 10Gbps cards.

These machines does not have internet connection.
Ivan Smahin

Ivan Smahin

2020-05-30 15:20

manager   ~0011313

Could you send me vServer's log (verboosemode == 3) after all that operations like db.Open, Diagnose, Reindex..?
Ivan Smahin

Ivan Smahin

2020-05-30 15:24

manager   ~0011314

And one more thing - could you describe me how do you insert/update asset.path_unique field? SQL only? how that statements looks like? Send me please all that statements "as is".
Aleksandar Spasojevic

Aleksandar Spasojevic

2020-05-30 16:37

reporter   ~0011315

Files are sent via WeTransfer on your mail. Actually, Reindex is done successfully, but diagnose failed twice.

path_unique is updated as every other field, and it is used to prevent duplicates. Insert/update of this field is done only using Api in XOJO, like
tabelaAsset.StringField("path_unique").value = path
Ivan Smahin

Ivan Smahin

2020-06-01 05:09

manager   ~0011316

Sorry, could you send it once more - it was no email - probably goes to the Junk folder.
Aleksandar Spasojevic

Aleksandar Spasojevic

2020-06-01 09:45

reporter   ~0011317

No problem, I sent it again.

Issue History

Date Modified Username Field Change
2020-05-26 17:14 Aleksandar Spasojevic New Issue
2020-05-27 05:23 Ivan Smahin Note Added: 0011295
2020-05-27 08:15 Aleksandar Spasojevic Note Added: 0011296
2020-05-27 11:03 Ivan Smahin Note Added: 0011299
2020-05-27 11:16 Aleksandar Spasojevic Note Added: 0011301
2020-05-30 07:16 Ivan Smahin Note Added: 0011309
2020-05-30 09:32 Aleksandar Spasojevic Note Added: 0011310
2020-05-30 09:55 Ivan Smahin Note Added: 0011311
2020-05-30 10:20 Aleksandar Spasojevic Note Added: 0011312
2020-05-30 15:20 Ivan Smahin Note Added: 0011313
2020-05-30 15:24 Ivan Smahin Note Added: 0011314
2020-05-30 16:37 Aleksandar Spasojevic Note Added: 0011315
2020-06-01 05:09 Ivan Smahin Note Added: 0011316
2020-06-01 09:45 Aleksandar Spasojevic Note Added: 0011317