[PostgreSQL] wsod in postgres with event track log module

Created on 15 November 2019, over 4 years ago

Updated 21 January 2024, 5 months ago

Hi,

I encounters some troubles with the module event track logs with my db pgsql.
I can't edit, create, logout etc without a wsod

I have this error log in database logging :

Drupal\Core\Database\IntegrityConstraintViolationException : SQLSTATE[23502]: Not null violation: 7 ERROR: null value in column "lid" violates not-null constraint DETAIL: Failing row contains (null, authentication, logout, user/logout, 1, webmaster, webmaster (uid handleQueryException()

I have posted an issue on the module page

but perhaps someone has encounters the same problem with this module and varbase ?

for me it's the use of merge syntax the culprit, I don't found any other contrib modules that use this syntax, In the drupal doc, I read this :
"...Merge queries are a special type of hybrid query. Although a syntax is defined for them in the SQL 2003 specification, virtually no database supports the standard syntax. Most, however, provide some alternate implementation using a database-specific syntax..."

you can see more information about this issue :

https://www.drupal.org/project/events_log_track/issues/3094617 →

🐛 Bug report

Status

Fixed

Version

7.2

Component

Code

Created by

🇧🇪Belgium pixelpreview

Live updates comments and jobs are added and updated live.