Why is insert_update doing nothing in Kamailio db insert_update ?
As explained in the following article the design of "UPSERT" in
PostgreSQL requires to be explicit about the constraint on which
we accept to do update modification to Kamailio database framework/API
would be required to expose which specific key constraint should be
handled as an update
http://pgeoghegan.blogspot.com/2015/10/avoid-naming-constraint-directly-whe…
In this first step, DO NOTHING is providing the simple feature to ignore
error on insert when facing a constraint violation
You can view, comment on, or merge this pull request online at:
https://github.com/kamailio/kamailio/pull/1039
-- Commit Summary --
* db_postgress: insert_update() with DO NOTHING
-- File Changes --
M src/modules/db_postgres/db_postgres.c (1)
M src/modules/db_postgres/db_postgres.h (2)
M src/modules/db_postgres/km_dbase.c (83)
M src/modules/db_postgres/km_dbase.h (5)
M src/modules/db_postgres/km_pg_con.c (4)
M src/modules/db_postgres/pg_mod.c (4)
-- Patch Links --
https://github.com/kamailio/kamailio/pull/1039.patchhttps://github.com/kamailio/kamailio/pull/1039.diff
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/pull/1039
When attempting to start Kamailio 5.0.0 with the app_perl module, it fails to start and logs:
Mar 1 10:20:04 albatross kamailio: DEBUG: <core> [core/sr_module.c:575]: load_module(): trying to load </lib64/kamailio/m
odules/app_perl.so>
Mar 1 10:20:04 albatross kamailio: ERROR: <core> [core/sr_module.c:582]: load_module(): could not open module </lib64/kam
ailio/modules/app_perl.so>: /lib64/kamailio/modules/app_perl.so: undefined symbol: sv2int_str
Mar 1 10:20:04 albatross kamailio: CRITICAL: <core> [core/cfg.y:3400]: yyerror_at(): parse error in config file /opt/ensw
itch/current/etc/kamailio/kamailio_50.cfg, line 28, column 12-21: failed to load module
The machine is Ubuntu 16.10, line 28 of kamailio_50.cfg is:
loadmodule "app_perl"
and the other options passed to app_perl are:
modparam( "app_perl", "filename", "/opt/enswitch/current/perllib/Integrics/Enswitch/Kamailio.pm" )
modparam( "app_perl", "modpath", "/opt/enswitch/current/perllib" )
modparam( "app_perl", "reset_cycles", 100000 )
modparam( "app_perl", "perl_destroy_func", "Integrics::Enswitch::Kamailio::restart" )
This problem does not happen on the same machine with Kamailio 4.2.1 and an identical configuration file.
--
You are receiving this because you are subscribed to this thread.
Reply to this email directly or view it on GitHub:
https://github.com/kamailio/kamailio/issues/1012