After some investigations, I am now at this point:

mysql.log:


                  41340 Query       SELECT *,sitegroup FROM article
WHERE id=839 AND (sitegroup in (0, 0
) OR 1<>0)
                  41340 Query       SELECT id FROM file WHERE
(article=839)
                  41340 Query       SELECT id FROM article WHERE
(up=839)
                  41340 Query       SELECT id FROM blobs WHERE
(ptable='article' AND pid=839)
                  41340 Query       SELECT id FROM record_extension
WHERE (tablename='article' AND oid=8
39)

mysql> SELECT id FROM record_extension WHERE (tablename='article' AND
oid=839);
+------+
| id   |
+------+
| 1013 |
+------+
1 row in set (0.00 sec)


repligard-Message:   LINKS FOREACH 7 on 839
repligard-Message:        dependency look: 7 record_extension oid
article 839 tablename id
and after no 'ADDING DEPENDENCY: record_extension'


repligard-Message:       dependency look: 7 record_extension oid topic
575 tablename id
repligard-Message:         ADDING DEPENDENCY: record_extension 2465

srace outputs:

for an article:

write(1, "\t  dependency look: 7 record_extension oid article 839
tablename id", 67) = 67
write(1, "\n", 1)                       = 1
fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
read(3, 0x807a710, 8192)                = -1 EAGAIN (Resource
temporarily unavailable)
fcntl(3, F_SETFL, O_RDWR)               = 0
write(3, "I\0\0\0\3SELECT id FROM record_extension WHERE
(tablename=\'article\' AND oid=839) ", 77) = 77
read(3, "\1\0\0\1", 4)                  = 4
read(3, "\1", 1)                        = 1
read(3, "\36\0\0\2", 4)                 = 4
read(3, "\20record_extension\2id\3\v\0\0\1\3\3\3B\0", 30) = 30
read(3, "\1\0\0\3", 4)                  = 4
read(3, "\376", 1)                      = 1
read(3, "\5\0\0\4", 4)                  = 4
read(3, "\0041013", 5)                  = 5
read(3, "\1\0\0\5", 4)                  = 4
read(3, "\376", 1)                      = 1
>>>> fcntl(3, F_SETFL, O_RDWR|O_NONBLOCK)    = 0
>>>> read(3, 0x807a710, 8192)                = -1 EAGAIN (Resource temporarily 
>>>> unavailable)
fcntl(3, F_SETFL, O_RDWR)               = 0
write(3, "O\0\0\0\3SELECT *,sitegroup FROM article WHERE id=840 AND
(sitegroup in (0, 0) OR 1<>0)", 83)
= 83


for a topic:

write(3, "G\0\0\0\3SELECT id FROM record_extension WHERE
(tablename=\'topic\' AND oid=575) ", 75) = 75
read(3, "\1\0\0\1", 4)                  = 4
read(3, "\1", 1)                        = 1
read(3, "\36\0\0\2", 4)                 = 4
read(3, "\20record_extension\2id\3\v\0\0\1\3\3\3B\0", 30) = 30
read(3, "\1\0\0\3", 4)                  = 4
read(3, "\376", 1)                      = 1
read(3, "\5\0\0\4", 4)                  = 4
read(3, "\0042465", 5)                  = 5
read(3, "\1\0\0\5", 4)                  = 4
read(3, "\376", 1)                      = 1
write(1, "repligard", 9)                = 9
write(1, "-", 1)                        = 1
write(1, "Message: ", 9)                = 9
write(1, "        ADDING DEPENDENCY: record_extension 2465", 48) = 48


so we see that repligard has some troubles reading the response from
mysql when requesting article record_extensions. (2 lines beginning with
>>>>)

I am on the way to look at the repligard sources but perhaps someone has
beter idea?

Nicolas

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]

Reply via email to