Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

db handles not used correctly in core #2384

Open
wmasilva opened this issue Feb 8, 2024 · 5 comments · May be fixed by #2385
Open

db handles not used correctly in core #2384

wmasilva opened this issue Feb 8, 2024 · 5 comments · May be fixed by #2385
Assignees
@andywolk
Labels
bug Something isn't working

Comments

@wmasilva
Copy link
Contributor

wmasilva commented Feb 8, 2024

i've configured different core-db-dsn for switch.conf.xml and dbname for sofia.conf.xml, that work ok but i'm seeing sql queries executed on the wrong database. Sentences like "delete channels " executed in sofia database witch is wrong because the channels table does not exist, and that is leading to issues in BLFs, zombie channels...

Log in postgres database for sofia only:

Feb 07 10:46:36 CVPRINCIPAL postgres[3318030]: 2024-02-07 10:46:36.359 CET [3318030] STATEMENT:  BEGIN TRANSACTION;
Feb 07 10:46:36 CVPRINCIPAL postgres[3318030]:         delete from "channels"  where "uuid" = '7272b982-5cd0-4ab6-b887-349e3d81fc3e';
Feb 07 10:46:36 CVPRINCIPAL postgres[3318030]:         delete from "channels"  where "call_uuid" = '7272b982-5cd0-4ab6-b887-349e3d81fc3e';
Feb 07 10:46:36 CVPRINCIPAL postgres[3318030]:         delete from "calls"  where "call_uuid" = '7272b982-5cd0-4ab6-b887-349e3d81fc3e';
Feb 07 10:46:36 CVPRINCIPAL postgres[3318030]:         COMMIT;

In the configuration i have:

vars.xml:        <X-PRE-PROCESS cmd="set" data="pgdbmem_core=pgsql://$${pgdbmem_libpq} dbname=freeswitch"/>
vars.xml:        <X-PRE-PROCESS cmd="set" data="pgdb_core=pgsql://$${pgdb_libpq} dbname=freeswitch"/>

sofia.conf.xml:		<param name="dbname" value="$${pgdbmem_core}"/>
sofia.conf.xml:<param name="dbname" value="$${pgdbmem_core}"/>

switch.conf.xml:		<param name="core-db-dsn" value="$${pgdb_core}" />

db cache status result:

db="host=/var/run/postgresql user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 0
	Total used: 246
	Flags: Unlocked, Detached(0)
	Creator: mod_db.c:99
	Last User: src/switch_console.c:253
db="host=/var/run/postgresql/ user=postgres dbname=cmcore",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 0
	Total used: 2304
	Flags: Unlocked, Detached(0)
	Creator: freeswitch_lua.cpp:371
	Last User: freeswitch_lua.cpp:371
db="host=/var/run/postgresql/ user=postgres dbname=cmcore",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1
	Total used: 4302
	Flags: Unlocked, Detached(0)
	Creator: mod_voicemail.c:221
	Last User: mod_voicemail.c:221
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 0
	Total used: 256021
	Flags: Unlocked, Detached(0)
	Creator: sofia_glue.c:2880
	Last User: mod_callcenter.c:609
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 0
	Total used: 642817
	Flags: Unlocked, Detached(0)
	Creator: src/switch_core_sqldb.c:1945
	Last User: sofia_glue.c:2916
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1
	Total used: 211792
	Flags: Unlocked, Detached(0)
	Creator: sofia_glue.c:2880
	Last User: sofia_glue.c:2916
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1
	Total used: 165284
	Flags: Unlocked, Detached(0)
	Creator: sofia_glue.c:2880
	Last User: sofia_glue.c:2916
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 448936
	Total used: 204318
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2880
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/postgresql user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068154
	Total used: 1
	Flags: Locked, Attached(1)
	Creator: src/switch_core_sqldb.c:2213
	Last User: 
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/pgsql-fs user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 2
	Flags: Locked, Attached(1)
	Creator: sofia_glue.c:2649
	Last User: src/switch_core_sqldb.c:2213
db="host=/var/run/postgresql user=freeswitch password=",type="database_interface"
	Type: DATABASE_INTERFACE
	Last used: 1068156
	Total used: 1
	Flags: Locked, Attached(1)
	Creator: src/switch_core_sqldb.c:2213
	Last User:

For what reason that i don't know the function switch_cache_db_get_db_handle_dsn is getting the wrong db handle.
@wmasilva wmasilva added the bug Something isn't working label Feb 8, 2024
@andywolk andywolk self-assigned this Feb 8, 2024
@andywolk
Copy link
Contributor

andywolk commented Feb 8, 2024 •
edited

@wmasilva See if that makes it better:

@wmasilva
Copy link
Contributor Author

wmasilva commented Feb 8, 2024

Hi @andywolk , testing it. Thanks

@andywolk andywolk linked a pull request Feb 8, 2024 that will close this issue
[Core] Database handles: Fix possible hash collision in get_handle(). #2385
Open
@wmasilva
Copy link
Contributor Author

wmasilva commented Feb 8, 2024

@andywolk didn't solve the issue.

@andywolk
Copy link
Contributor

andywolk commented Feb 8, 2024

Can you please send your full conf to andrey@signalwire.com without changes to passwords or anything else.

@wmasilva
Copy link
Contributor Author

Hi Andy, to be more easy to track i'm trying to reproduce it using a basic configuration, i have some lua scripts that i think could be triggering the issue. i keep you informed of the results. Thanks.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@andywolk andywolk

Labels
bug Something isn't working
Projects
None yet
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

[Core] Database handles: Fix possible hash collision in get_handle(). signalwire/freeswitch
2 participants
@andywolk @wmasilva