Bug 49646

Summary: Very long debug message "LockingDB: Return SQL result"
Product: UCS Reporter: Arvid Requate <requate>
Component: S4 ConnectorAssignee: Samba maintainers <samba-maintainers>
Status: RESOLVED DUPLICATE QA Contact: Samba maintainers <samba-maintainers>
Severity: normal    
Priority: P5 CC: best
Version: UCS 4.4   
Target Milestone: ---   
Hardware: Other   
OS: Linux   
What kind of report is it?: Bug Report What type of bug is this?: 1: Cosmetic issue or missing function but workaround exists
Who will be affected by this bug?: 1: Will affect a very few installed domains How will those affected feel about the bug?: 1: Nuisance – not a big deal but noticeable
User Pain: 0.006 Enterprise Customer affected?:
School Customer affected?: ISV affected?:
Waiting Support: Flags outvoted (downgraded) after PO Review:
Ticket number: 2019060521000496 Bug group (optional):
Max CVSS v3 score:
Attachments: just_lock_once.patch

Description Arvid Requate univentionstaff 2019-06-13 15:45:09 CEST
In a support case I saw this very long debug message, we should check if that is a problem in the S4-Connector:

============================================================================
07.06.2019 13:54:13.132 LDAP        (PROCESS): sync to ucs:   [windowscomputer] [    modify] cn=foo,ou=computers,dc=bar,dc=net
07.06.2019 13:54:13.132 LDAP        (INFO   ): sync_to_ucs: set position to ou=computers,dc=bar,dc=net
07.06.2019 13:54:13.133 LDAP        (INFO   ): LockingDB: Execute SQL command: 'SELECT id FROM UCS_LOCK WHERE uuid=?;', '('c4ba44c8-a650-1036-94a5-ed2dda9899b6',)'
07.06.2019 13:54:13.586 LDAP        (INFO   ): LockingDB: Return SQL result: '[(436990,), (436993,), (436996,), (436999,), (437002,), (437005,), (437008,), (437011,), (437014,
), (437017,), (437020,), (437023,), (437026,), (437029,), (437032,), (437035,), (437038,), (437041,), (437044,), (437047,), (437050,), (437053,), (437056,), (437059,), (437062
,), (437065,), (437068,), (437071,), (437074,), (437077,), (437080,), (437083,), (437086,), (437089,), (437092,), (437095,), (437098,), (437101,), (437104,), (437107,), (43711
0,), (437113,), (437116,), (437119,), (437122,), (437125,), (437128,), (437131,), (437134,), (437137,), (437140,), (437143,), (437146,), (437149,), (437152,), (437155,), (4371
58,), (437161,), (437164,), (437167,), (437170,), (437173,), (437176,), (437179,), (437182,), (437185,), (437188,), (437191,), (437194,), (437197,), (437200,), (437203,), (437
206,), (437209,), (437212,), (437215,), (437218,), (437221,), (437224,), (437227,), (437230,), (437233,), (437236,), (437239,), (437242,), (437245,), (437248,), (437251,), (43
7254,), (437257,), (437260,), (437263,), (437266,), (437269,), (437272,), (437275,), (437278,), (437281,), (437284,), (437287,), (437290,), (437293,), (437296,), (437299,), (4
37302,), (437305,), (437308,), (437311,), (437314,), (437317,), (437320,), (437323,), (437326,), (437329,), (437332,), (437335,), (437338,), (437341,), (437344,), (437347,), (
437350,), (437353,), (437356,), (437359,), (437362,), (437365,), (437368,), (437371,), (437374,), (437377,), (437380,), (437383,), (437386,), (437389,), (437392,), (437395,), 
(437398,), (437401,), (437404,), (437407,), (437410,), (437413,), (437416,), (437419,), (437422,), (437425,), (437428,), (437431,), (437434,), (437437,), (437440,), (437443,),
 (437446,), (437449,), (437452,), (437455,), (437458,), (437461,), (437464,), (437467,), (437470,), (437473,), (437476,), (437479,), (437482,), (437485,), (437488,), (437491,)
, (437494,), (437497,), (437500,), (437503,), (437506,), (437509,), (437512,), (437515,), (437518,), (437521,), (437524,), (437527,), (437530,), (437533,), (437536,), (437539,
), (437542,), (437545,), (437548,), (437551,), (437554,), (437557,), (437560,), (437563,), (437566,), (437569,), (437572,), (437575,), (437578,), (437581,), (437584,), (437587
,), (437590,), (437593,), (437596,), (437599,), (437602,), (437605,), (437608,), (437611,), (437614,), (437617,), (
============================================================================

and so on.
Comment 1 Arvid Requate univentionstaff 2019-06-13 18:36:56 CEST
Created attachment 10062 [details]
just_lock_once.patch

This very long log message is a symptom of the S4-Connector adding an entry to the lockingdb each time it retries to resolve a reject. See attached patch.
Comment 2 Arvid Requate univentionstaff 2019-06-27 23:13:08 CEST

*** This bug has been marked as a duplicate of bug 49459 ***