Categories
Knowledge Support Support exacqVision Enterprise Categories Products

ESM: Known database errors.

ESM displays an error in its log files indicating one of the following database related errors:

ProgrammingError…
DatabaseError…
OperationalError…
InterfaceError…

This is expected behavior if the log message shows it was caught by !RunDatabaseQuery and also logs that the query recovered without exception.  This is an example of an error communicating with the database but has recovered.

[16/Jun/2016 10:34:27] ERROR [importer:70] Exception in Thread : RunDatabaseQuery: Traceback (most recent call last):

File “/home/exacqu/DVR/build_cswsrcbuild_branch_24.118/evHealth/build/importer/out00-PYZ.pyz/utils.RunDatabaseQuery”, line 65, in RunDatabaseQuery

File “”, line 234, in
File “/home/exacqu/DVR/build_cswsrcbuild_branch_24.118/evHealth/build/importer/out00-PYZ.pyz/django.db.models.query”, line 493, in update
File “/home/exacqu/DVR/build_cswsrcbuild_branch_24.118/evHealth/build/importer/out00-PYZ.pyz/django.db.models.sql.compiler”, line 980, in execute_sql
File “/home/exacqu/DVR/build_cswsrcbuild_branch_24.118/evHealth/build/importer/out00-PYZ.pyz/django.db.models.sql.compiler”, line 786, in execute_sql
File “/home/exacqu/DVR/build_cswsrcbuild_branch_24.118/evHealth/build/importer/out00-PYZ.pyz/django.db.backends.util”, line 53, in execute
File “/home/exacqu/DVR/build_cswsrcbuild_branch_24.118/evHealth/build/importer/out00-PYZ.pyz/django.db.utils”, line 99, in __exit__
File “/home/exacqu/DVR/build_cswsrcbuild_branch_24.118/evHealth/build/importer/out00-PYZ.pyz/django.db.backends.util”, line 53, in execute
DatabaseError: server closed the connection unexpectedly


This probably means the server terminated abnormally
before or while processing the request.

[16/Jun/2016 10:34:28] INFO [importer:73] Thread : Query recovered and returned without exception.

Notice that error is in !RunDatabaseQuery, indicated on the first line of the of the error message.
Also notice that it recovered indicated by the last in the example.
This is expected behavior.