This is very weird...
Michael was working with the PG installation I set up for him and
everything was fine until he started getting a "connection
refused" every time he went to any /dotlrn URL.
Looking at the log, it seems that everything was fine until
21:17:58. At that time, the server restarted itself after processing
(or attempting to process) this query:
[28/Jul/2002:21:17:58][9859.1160199][-conn5-] Debug:
QD_LOGGER = POST-QD: the SQL is
select
file_storage__get_package_id(fs_objects.object_id) as
package_id,
(CASE
WHEN fs_objects.type = 'url'
THEN (select site_node__url(site_nodes.node_id)
from site_nodes
where site_nodes.object_id =
file_storage__get_package_id(fs_objects.parent_id))
ELSE (select site_node__url(site_nodes.node_id)
from site_nodes
where site_nodes.object_id =
file_storage__get_package_id(fs_objects.object_id))
END) as url,
fs_objects.object_id,
fs_objects.name,
fs_objects.live_revision,
fs_objects.type,
fs_objects.content_size
from fs_objects
where fs_objects.parent_id in (5390)
and 't' =
acs_permission__permission_p(fs_objects.object_id, :user_id,
'read')
order by fs_objects.parent_id,
fs_objects.sort_key,
fs_objects.name
After that, any attempt to go to any /dotlrn URL causes this query
to be processed, which then causes the server to restart:
[28/Jul/2002:21:19:25][22833.10249][-conn0-] Debug:
QD_LOGGER = POST-QD: the SQL is
select forums_forums.package_id,
acs_object__name(apm_package__parent_id(forums_forums.
package_id)) as parent_name,
(select site_node__url(site_nodes.node_id)
from site_nodes
where site_nodes.object_id =
forums_forums.package_id) as url,
forums_forums.forum_id,
forums_forums.name,
case when last_modified > (now() - 1) then 't' else 'f' end
as new_p
from forums_forums_enabled forums_forums,
acs_objects
where acs_objects.object_id = forums_forums.forum_id
and
forums_forums.package_id in (5407)
order by parent_name,
forums_forums.name
I have no idea what might be causing this. It's nsd 3.3+ad13,
and we don't seem to have any such problems with the Oracle
version.
Michael, do you happen to remember what you were doing in file
storage? Maybe that will give us a clue...
