On Thu, 2004-03-04 at 20:02, Pierangelo Masarati wrote: hi, > It could be a problem in back-sql, I need to check > how it behaves when when searches are abandoned or > when a connection is lost. Can you detail what you > exactly do to cause the problem with back-sql > in the glue sequence? Does the problem persist > if you use back-sql by itself, without glueing it > to another database? ok.. to reproduce the problem: 1) setup a (postgres) db with the example files in rdbms_depend/pgsql/ 2) the attached file ldbm-testdata.txt contains the testdata which i used for the ldbm backend. i just used 'c=RU' as root, so that i don't have to modify the sql example. 3) when i do a 'ldapsearch -b "c=RU"' and cancel it somewhere in the middle, the next time i start it no objects are returned (and i have to restart slapd). if i cancel it near the end of the output, sometimes the next run succeeds. if i just use back-sql (without another database) and cancel the operation i can't reproduce the problem. cu /gst
dn: c=RU
objectClass: country
c: RU
dn: uid=1,c=RU
objectClass: posixAccount
objectClass: account
cn: 1
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 1
dn: uid=2,c=RU
objectClass: posixAccount
objectClass: account
cn: 2
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 2
dn: uid=3,c=RU
objectClass: posixAccount
objectClass: account
cn: 3
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 3
dn: uid=4,c=RU
objectClass: posixAccount
objectClass: account
cn: 4
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 4
dn: uid=5,c=RU
objectClass: posixAccount
objectClass: account
cn: 5
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 5
dn: uid=6,c=RU
objectClass: posixAccount
objectClass: account
cn: 6
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 6
dn: uid=7,c=RU
objectClass: posixAccount
objectClass: account
cn: 7
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 7
dn: uid=8,c=RU
objectClass: posixAccount
objectClass: account
cn: 8
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 8
dn: uid=9,c=RU
objectClass: posixAccount
objectClass: account
cn: 9
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 9
dn: uid=10,c=RU
objectClass: posixAccount
objectClass: account
cn: 10
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 10
dn: uid=11,c=RU
objectClass: posixAccount
objectClass: account
cn: 11
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 11
dn: uid=12,c=RU
objectClass: posixAccount
objectClass: account
cn: 12
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 12
dn: uid=13,c=RU
objectClass: posixAccount
objectClass: account
cn: 13
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 13
dn: uid=14,c=RU
objectClass: posixAccount
objectClass: account
cn: 14
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 14
dn: uid=15,c=RU
objectClass: posixAccount
objectClass: account
cn: 15
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 15
dn: uid=16,c=RU
objectClass: posixAccount
objectClass: account
cn: 16
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 16
dn: uid=17,c=RU
objectClass: posixAccount
objectClass: account
cn: 17
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 17
dn: uid=18,c=RU
objectClass: posixAccount
objectClass: account
cn: 18
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 18
dn: uid=19,c=RU
objectClass: posixAccount
objectClass: account
cn: 19
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 19
dn: uid=20,c=RU
objectClass: posixAccount
objectClass: account
cn: 20
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 20
dn: uid=21,c=RU
objectClass: posixAccount
objectClass: account
cn: 21
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 21
dn: uid=22,c=RU
objectClass: posixAccount
objectClass: account
cn: 22
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 22
dn: uid=23,c=RU
objectClass: posixAccount
objectClass: account
cn: 23
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 23
dn: uid=24,c=RU
objectClass: posixAccount
objectClass: account
cn: 24
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 24
dn: uid=25,c=RU
objectClass: posixAccount
objectClass: account
cn: 25
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 25
dn: uid=26,c=RU
objectClass: posixAccount
objectClass: account
cn: 26
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 26
dn: uid=27,c=RU
objectClass: posixAccount
objectClass: account
cn: 27
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 27
dn: uid=28,c=RU
objectClass: posixAccount
objectClass: account
cn: 28
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 28
dn: uid=29,c=RU
objectClass: posixAccount
objectClass: account
cn: 29
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 29
dn: uid=30,c=RU
objectClass: posixAccount
objectClass: account
cn: 30
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 30
dn: uid=31,c=RU
objectClass: posixAccount
objectClass: account
cn: 31
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 31
dn: uid=32,c=RU
objectClass: posixAccount
objectClass: account
cn: 32
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 32
dn: uid=33,c=RU
objectClass: posixAccount
objectClass: account
cn: 33
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 33
dn: uid=34,c=RU
objectClass: posixAccount
objectClass: account
cn: 34
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 34
dn: uid=35,c=RU
objectClass: posixAccount
objectClass: account
cn: 35
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 35
dn: uid=36,c=RU
objectClass: posixAccount
objectClass: account
cn: 36
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 36
dn: uid=37,c=RU
objectClass: posixAccount
objectClass: account
cn: 37
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 37
dn: uid=38,c=RU
objectClass: posixAccount
objectClass: account
cn: 38
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 38
dn: uid=39,c=RU
objectClass: posixAccount
objectClass: account
cn: 39
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 39
dn: uid=40,c=RU
objectClass: posixAccount
objectClass: account
cn: 40
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 40
dn: uid=41,c=RU
objectClass: posixAccount
objectClass: account
cn: 41
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 41
dn: uid=42,c=RU
objectClass: posixAccount
objectClass: account
cn: 42
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 42
dn: uid=43,c=RU
objectClass: posixAccount
objectClass: account
cn: 43
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 43
dn: uid=44,c=RU
objectClass: posixAccount
objectClass: account
cn: 44
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 44
dn: uid=45,c=RU
objectClass: posixAccount
objectClass: account
cn: 45
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 45
dn: uid=46,c=RU
objectClass: posixAccount
objectClass: account
cn: 46
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 46
dn: uid=47,c=RU
objectClass: posixAccount
objectClass: account
cn: 47
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 47
dn: uid=48,c=RU
objectClass: posixAccount
objectClass: account
cn: 48
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 48
dn: uid=49,c=RU
objectClass: posixAccount
objectClass: account
cn: 49
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 49
dn: uid=50,c=RU
objectClass: posixAccount
objectClass: account
cn: 50
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 50
dn: uid=51,c=RU
objectClass: posixAccount
objectClass: account
cn: 51
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 51
dn: uid=52,c=RU
objectClass: posixAccount
objectClass: account
cn: 52
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 52
dn: uid=53,c=RU
objectClass: posixAccount
objectClass: account
cn: 53
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 53
dn: uid=54,c=RU
objectClass: posixAccount
objectClass: account
cn: 54
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 54
dn: uid=55,c=RU
objectClass: posixAccount
objectClass: account
cn: 55
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 55
dn: uid=56,c=RU
objectClass: posixAccount
objectClass: account
cn: 56
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 56
dn: uid=57,c=RU
objectClass: posixAccount
objectClass: account
cn: 57
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 57
dn: uid=58,c=RU
objectClass: posixAccount
objectClass: account
cn: 58
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 58
dn: uid=59,c=RU
objectClass: posixAccount
objectClass: account
cn: 59
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 59
dn: uid=60,c=RU
objectClass: posixAccount
objectClass: account
cn: 60
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 60
dn: uid=61,c=RU
objectClass: posixAccount
objectClass: account
cn: 61
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 61
dn: uid=62,c=RU
objectClass: posixAccount
objectClass: account
cn: 62
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 62
dn: uid=63,c=RU
objectClass: posixAccount
objectClass: account
cn: 63
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 63
dn: uid=64,c=RU
objectClass: posixAccount
objectClass: account
cn: 64
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 64
dn: uid=65,c=RU
objectClass: posixAccount
objectClass: account
cn: 65
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 65
dn: uid=66,c=RU
objectClass: posixAccount
objectClass: account
cn: 66
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 66
dn: uid=67,c=RU
objectClass: posixAccount
objectClass: account
cn: 67
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 67
dn: uid=68,c=RU
objectClass: posixAccount
objectClass: account
cn: 68
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 68
dn: uid=69,c=RU
objectClass: posixAccount
objectClass: account
cn: 69
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 69
dn: uid=70,c=RU
objectClass: posixAccount
objectClass: account
cn: 70
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 70
dn: uid=71,c=RU
objectClass: posixAccount
objectClass: account
cn: 71
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 71
dn: uid=72,c=RU
objectClass: posixAccount
objectClass: account
cn: 72
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 72
dn: uid=73,c=RU
objectClass: posixAccount
objectClass: account
cn: 73
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 73
dn: uid=74,c=RU
objectClass: posixAccount
objectClass: account
cn: 74
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 74
dn: uid=75,c=RU
objectClass: posixAccount
objectClass: account
cn: 75
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 75
dn: uid=76,c=RU
objectClass: posixAccount
objectClass: account
cn: 76
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 76
dn: uid=77,c=RU
objectClass: posixAccount
objectClass: account
cn: 77
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 77
dn: uid=78,c=RU
objectClass: posixAccount
objectClass: account
cn: 78
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 78
dn: uid=79,c=RU
objectClass: posixAccount
objectClass: account
cn: 79
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 79
dn: uid=80,c=RU
objectClass: posixAccount
objectClass: account
cn: 80
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 80
dn: uid=81,c=RU
objectClass: posixAccount
objectClass: account
cn: 81
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 81
dn: uid=82,c=RU
objectClass: posixAccount
objectClass: account
cn: 82
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 82
dn: uid=83,c=RU
objectClass: posixAccount
objectClass: account
cn: 83
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 83
dn: uid=84,c=RU
objectClass: posixAccount
objectClass: account
cn: 84
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 84
dn: uid=85,c=RU
objectClass: posixAccount
objectClass: account
cn: 85
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 85
dn: uid=86,c=RU
objectClass: posixAccount
objectClass: account
cn: 86
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 86
dn: uid=87,c=RU
objectClass: posixAccount
objectClass: account
cn: 87
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 87
dn: uid=88,c=RU
objectClass: posixAccount
objectClass: account
cn: 88
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 88
dn: uid=89,c=RU
objectClass: posixAccount
objectClass: account
cn: 89
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 89
dn: uid=90,c=RU
objectClass: posixAccount
objectClass: account
cn: 90
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 90
dn: uid=91,c=RU
objectClass: posixAccount
objectClass: account
cn: 91
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 91
dn: uid=92,c=RU
objectClass: posixAccount
objectClass: account
cn: 92
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 92
dn: uid=93,c=RU
objectClass: posixAccount
objectClass: account
cn: 93
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 93
dn: uid=94,c=RU
objectClass: posixAccount
objectClass: account
cn: 94
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 94
dn: uid=95,c=RU
objectClass: posixAccount
objectClass: account
cn: 95
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 95
dn: uid=96,c=RU
objectClass: posixAccount
objectClass: account
cn: 96
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 96
dn: uid=97,c=RU
objectClass: posixAccount
objectClass: account
cn: 97
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 97
dn: uid=98,c=RU
objectClass: posixAccount
objectClass: account
cn: 98
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 98
dn: uid=99,c=RU
objectClass: posixAccount
objectClass: account
cn: 99
userPassword: {CLEARTEXT}foobar
uidNumber: 4000
gidNumber: 4000
homeDirectory: /home/foo/
uid: 99
# Schema and objectClass definitions include /etc/ldap/schema/core.schema include /etc/ldap/schema/cosine.schema include /etc/ldap/schema/nis.schema include /etc/ldap/schema/inetorgperson.schema # Where the pid file is put. The init.d script # will not stop the server if you change this. pidfile /var/run/slapd.pid # List of arguments that were passed to the server argsfile /var/run/slapd.args # Read slapd.conf(5) for possible values loglevel 4095 schemacheck on ####################################################################### database sql suffix "o=sql,c=RU" subordinate dbname "PgSQL" dbuser "zope" strcast_func "text" upper_func "upper" concat_pattern "?||?" has_ldapinfo_dn_ru no database ldbm suffix "c=RU" rootdn "cn=admin,c=RU" rootpw "foobar"
Attachment:
signature.asc
Description: This is a digitally signed message part