|
| Database files locked after a crash |
| Iniciado por PaulGruet, 04,feb. 2020 09:19 - 3 respuestas |
| |
| | | |
|
| |
| Publicado el 04,febrero 2020 - 09:19 |
Please accept my apologies for reposting this but we still have no solution and it is becoming very urgent that we resolve this.
We have an application which collects data from a Data Translation A to D module. Occasionally this module loses USB comms for no obvious reason. When it does, if our Windev application is closed and restarted we find we get an Error saying that our database files are locked by another user. I have also seen the error box (usually in French) saying that we cannot run a second instance of the application.
In task manager it can be seen that the process is still running even though the application has been closed. This process cannot be killed by Task Manager, Process Explorer or any of a number of programs that claim to be able to kill a zombie process.
This process takes around 10-15 minutes to disappear. If the computer is rebooted this often recovers the situation but sometimes we have seen the zombie process restart after a reboot. |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
102 mensajes |
|
| Publicado el 04,febrero 2020 - 17:44 |
Paul,
is this a HFSQL database? Is it client/server or classic? What is the name of the process you are not able to kill? How is your application connected to the analog-digital-converter?
--
WD23 with Oracle, WDM23 Apps for Android, iOS and Windows CE.
Python 3 with Oracle and MySQL. PHP with MySQL and JSON. |
| |
| |
| | | |
|
| | |
| |
| Publicado el 05,febrero 2020 - 16:32 |
Hi Sebastian
Its an HFSQL classic database. The a/d converter is a DataTranslation DT9805 connect by USB and using a .net framework interface to it supplied by the manufacturer.
The zombie process is the remains of the original application and has its name our program is called FTTSOft.exe so that's what we see in task manager unless the program is being run under the WinDev IDE in which case it is wdtst.exe
Paul |
| |
| |
| | | |
|
| | |
| |
Miembro registrado
102 mensajes |
|
| Publicado el 05,febrero 2020 - 20:33 |
Hi Paul,
two tipps:
1. If you can, try to switch to HFSQL Client/Server. The server itself can run on the same PC as your program runs, if necessary
2. Try to turn off your virus scanner temporarily, just to find out if it makes any difference
HTH
Sebastian
--
WD23 with Oracle, WDM23 Apps for Android, iOS and Windows CE.
Python 3 with Oracle and MySQL. PHP with MySQL and JSON. |
| |
| |
| | | |
|
| | | | |
| | |
|