1. F H
  2. as SQLite DB Server
  3. Mittwoch, Oktober 14 2020, 01:05 PM
  4.  Abonnieren via E-Mail
Hello,

I'm devolping a mall tool in python which uses several sqlitedatabases for storing the data. At the moment the tool ist importing regular during the night data into the database, so that I can use the data during the day. The Problem is, that my data is always round about 12 hours behind live which now is getting sometime a problem. Thats why I want to migrate my data to sqlite db server. First of all I installed the vserver on my kali linux desktop pc and stored the databases on a Synology NAS and mounted the folder. That works perfect, that mean I can access the databases from Valentin Studio Pro from the same computer. For thee future I want to migrate the server to a Raspberry PI 4 with 4GB RAM. I allready did that and did the same configuration. When I now try to connect to the sqliteserver from my KALI-Linux PC using Valentin Studio it works and I also can see the sqlite databases, which still are stored on the Synology NAS. The Problem is, that I can't open the databases, because already give me the message ERROR 0x68500: Sqlite db "block_000000_200000.db": Error : "unable to open database file".

That are the same files I can open when I run the server on the KaliLinux and connect withe Valentin Studio Pro to localhost. Attached you can find a screenshot of the error message and the two server logfiles. I added in the logfilename a hint to the system (Kali or RPI4). I already search for a solutions since 3 days now but I do not have any other idea.

Can somebody help me with this problem?

Thank you very much in advance.

Fabian
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Fabian,

So the SQLite database file is on the NFS share, right?
Could you please try to copy it to the Raspberry Pi? To be sure that Valentina SQLite Server for ARM is able to open it directly.
Kommentar
There are no comments made yet.
F H Akzeptierte Antwort
Hello Sergey,

I copied one database to the Raspberry and also switched the database folder in der vserver.ini, but I still have the same problem. When I try to open the database with sqlite3 on command line from the raspberry pi it works perfect. Also my python script can open the database and select and insert data in it.

Also it is possible to create database with Valentina Studio on the Raspberry Pi. There I can insert data and create tables and so on. But I can not access the database I already have.

I checked the two databases (old and the new with Valentina studio created one) and could see difference in the privileges.

-rwxr-xr-x 1 pi pi 12150452224 Okt 15 09:42 block_000000_200000.db
-rw-r--r-- 1 root root 16384 Okt 15 09:56 test.db

Could this be the problem? I think not, because when I start the server from the Kali-Linux-PC it works also.

Fabian
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
And this new test database can be closed and opened again without an issue, right?

I noticed Kali Linux uses version 10.0.1 of the Valentina Server while on the Raspberry Pi the version 10.5.3 is installed.

What if you install the latest version of the Valentina Server on Kali Linux? Or copy your database to Kali Linux and open it locally using the latest version of Valentina Studio?
Kommentar
There are no comments made yet.
F H Akzeptierte Antwort
Yes the database can openend and closed without any problems.

I upgraded the VServer on Kali to 10.5.3 and did my test opening when the database was stored local and when the database was stored on the synology nas, both worked perfect (see the logfiles below).

Also I can open the database locally with Valentina Studio Pro Version 10.5.3 for Linux.
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Yes, I reproduced the problem with 12 GB database on Valentina Server ARM.
Kommentar
There are no comments made yet.
F H Akzeptierte Antwort
Does it mean, that my databases are to big?

Fabian
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
No, it should not be a problem. I think something is wrong with compilation for ARM, we’ll try to find it out ASAP.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Fabian,

The fix will be available in version 10.5.5 (it was a compilation issue)
Kommentar
There are no comments made yet.
F H Akzeptierte Antwort
Very Good. Thank you. Do you already have a timing for 10.5.5?
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Yes, we expect it to be ready tomorrow.
Kommentar
There are no comments made yet.
Ruslan Zasukhin Akzeptierte Antwort
10.5.5 released
Kommentar
There are no comments made yet.
F H Akzeptierte Antwort
Thank you. Sorry for my late response, but I had not the time to test it in detail. But today I can say that it works perfectly also with sqlite database which are bigger then 400GB.

Thank you.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Thank you for testing it, you have really big data sets.
If not secret, what kind of data is it (e.g. scientific, financial)?
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.