Comments (4)
Sorry, I don't understand your language.
from mormot.
Translation by Google Translate:
Our company, Sysmo Sistemas, has a cashier application which is closing after a process of verifying the integrity of the SQLite database on some computers with Windows 10 Pro version 18363.900.
Code in Deplhi 6:
uses
mORMot;
[...]
function TRgnSQLiteMaintenance.VerifyDatabaseIntegrity(AServerDatabase: TSQLRestServerDB): Boolean;
var
oSQLTableJSON: TSQLTableJSON;
begin
try
oSQLTableJSON := AServerDatabase.ExecuteList([], 'PRAGMA integrity_check');
try
Result := (oSQLTableJSON <> nil);
if (Result) then
Result := (LowerCase(String(oSQLTableJSON.GetS(1,0))) = 'ok');
finally
if (oSQLTableJSON <> nil) then
FreeAndNil(oSQLTableJSON);
end;
except
on E: Exception do
begin
Result := False;
{$IFDEF VER140}
if (Assigned(LogarErroGeral)) then
LogarErroGeral('', 'TRgnSQLiteMaintenance.VerifyDatabaseIntegrity: Exception [' + E.Message + ']');
{$ENDIF}
end;
end;
end;
As far as it was possible to identify by the logs, the application closed when executing the command oSQLTableJSON.GetS (1,0).
We suspect that an exception occurs in the process, but no error message is generated and simply closes the application.
We have identified in some clients with Windows 10 where if there is any exception in the code and it is not treated with try except the application is closed without presenting an error message.
However, in this case, even with try except, the error persists.
We were unable to simulate internally, only on a client.
We found that on other computers with the same configuration and version of Windows the problem does not happen.
User permissions have already been added for Full Control and placed SSD, but it has not been successful.
The error recorded in Windows events was:
Log Name: Application
Source: Application Error
Date: 11/06/2020 20:01:34
Event ID: 1000
Task Category: (100)
Level: Error
Keywords: classic
User: N / A
Computer: Caixa01lj5
Description:
Faulting application name: pdv10.exe, version: 3.9.20.3, timestamp: 0x2a425e19
Faulty module name: unknown, version: 0.0.0.0, timestamp: 0x00000000
Exception code: 0xc0000005
Fault offset: 0x00000000
Failed process ID: 0xbe0
Failed application start time: 0x01d6402ff3dcb7b8
Faulting application path: c: \ pdv \ pdv10.exe
Faulty module path: unknown
Report ID: 04ede662-fca9-47c6-bcc4-8882091f9ebe
Failed package full name:
Application ID for the failed package:
Event XML:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Application Error" />
<EventID Qualifiers="0">1000</EventID>
<Level>2</Level>
<Task>100</Task>
<Keywords>0x80000000000000</Keywords>
<TimeCreated SystemTime="2020-06-11T23:01:34.725905000Z" />
<EventRecordID>7199</EventRecordID>
<Channel>Application</Channel>
<Computer>caixa01lj5</Computer>
<Security />
</System>
<EventData>
<Data>pdv10.exe</Data>
<Data>3.9.20.3</Data>
<Data>2a425e19</Data>
<Data>unknown</Data>
<Data>0.0.0.0</Data>
<Data>00000000</Data>
<Data>c0000005</Data>
<Data>00000000</Data>
<Data>be0</Data>
<Data>01d6402ff3dcb7b8</Data>
<Data>c:\pdv\pdv10.exe</Data>
<Data>unknown</Data>
<Data>04ede662-fca9-47c6-bcc4-8882091f9ebe</Data>
<Data>
</Data>
<Data>
</Data>
</EventData>
</Event>
from mormot.
It's impossible to identify a source of a problem from information you provide.
For tracking such "unexpected" errors on client side you can add SynLog.pas unit, enable "detailed map file information" in the project option, and enhance exception logging.
You should have the stack trace of all exceptions, in the .log text file.
But without any more context, it is not possible to give you more help.
from mormot.
This process has been removed and the problem continues.
It must be something related to Windows.
Thank you.
from mormot.
Related Issues (20)
- Memory Leak on RemoteDB HOT 2
- Documentation example mistake ? 4.3.1. TList-like properties HOT 10
- Endless recursive calls in SynCommons::FileSize HOT 3
- Typo in SAD 1.18 HOT 3
- why cannot run the same SQLite on Linux at the same time HOT 1
- Bufferoverread for THttpServerRequest.FullUrl HOT 4
- ARM9 without FPU(VFP) does not support HOT 1
- Forward slash instead of backslash? HOT 3
- Fatal Error (Exception External:?) after second exception in Interfaced based Services HOT 1
- Declaration of "ConvertToEmfPlus" is not 64 bit safe HOT 1
- THttpApiWebSocketConnection.PrivateData Property value cannot be set. HOT 2
- THttpServer.OnHttpRequest - Ctxt.RemoteIP is empty HOT 2
- HttpGet: outStatus parameter is invalid
- THttpServer : Executing the HEAD request will read the entire file HOT 4
- TWinHTTP Thread safe issue in filling OSVersionInfo HOT 1
- Postgresql boolean (t/f) JSON parsing HOT 1
- Cannot compile under Delphi 12 due to the compiler errors HOT 2
- SynBloomFilter large volumes HOT 1
- more than one results in AggregateDoc() - MongoDB HOT 1
- X64 AESNI assembler routines corrupt XMM6-XMM15 which the Win64 calling convention expects to be preserved HOT 8
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from mormot.