Forum OpenACS Q&A: Re: Lazy site node caching

We are testing it and I get the first problem. The function
dotlrn::is_package_mounted is not detecting the attach mounted below dotlrn package in the OpenACS start process.
Next is the error log:

[13/Mar/2007:12:56:41][14966.16384][-main-] Notice: Loading packages/dotlrn/tcl/dotlrn-init.tcl...
[13/Mar/2007:12:56:41][14966.16384][-main-] Notice: dotlrn-init: starting...
[13/Mar/2007:12:56:41][14966.16384][-main-] Notice: dotlrn-init: attachments being automounted at /dotlrn/attach
[13/Mar/2007:12:56:41][14966.16384][-main-] Notice: dotlrn::mount_package: object_type apm_package url /dotlrn/ object_id 2121 instance_name dotLRN
package_type apm_application package_id 2121 name dotlrn node_id 2120 has_children_p 1 directory_p t package_key dotlrn pattern_p t parent_id 498
NOTICE: adding missing FROM-clause entry for table "acs_object_id_seq"
CONTEXT: PL/pgSQL function "acs_object__new" line 17 at SQL statement
PL/pgSQL function "site_node__new" line 23 at assignment
[13/Mar/2007:12:56:41][14966.16384][-main-] Error: Ns_PgExec: result status: 7 message: ERROR: duplicate key violates unique constraint "site_nodes_un"
CONTEXT: SQL statement "INSERT INTO site_nodes (node_id, parent_id, name, object_id, directory_p, pattern_p) values ( $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "site_node__new" line 35 at SQL statement

[13/Mar/2007:12:56:41][14966.16384][-main-] Error: dbinit: error(pizarradb.uv.es:5433:openacsdb_5_2_desa,ERROR: duplicate key violates unique constraint
"site_nodes_un"
CONTEXT: SQL statement "INSERT INTO site_nodes (node_id, parent_id, name, object_id, directory_p, pattern_p) values ( $1 , $2 , $3 , $4 , $5 , $6 )"
PL/pgSQL function "site_node__new" line 35 at SQL statement
): '

select site_node__new(NULL,'2120','attach',NULL,'t','t',NULL,NULL)
...

Regards,
Agustín

if {[catch {nsv_get site_nodes "${new_url}/"} result] == 0} {
set node_id ""
} else {
if {$new_node(has_children_p) && [lsearch $acs_subsite_dir_list $name] == -1} {
set node_id [db_string node_id "select node_id from site_nodes where parent_id = :parent_id and name=:name" -default ""]
ns_log Debug "Loading from the database $test_url $name $parent_id"
} else {
set node_id ""
}
}

Your code works. At this moment all works except:

-Some portles displaying the msg (example):
Error in include template "/var/lib/aolserver/oacs_5_2/packages/lorsm/lib/user-lorsm": can't read "url_by_node_id(17673735)": no such element in array

-xotcl:
site_node::get "must pass in either url or node_id"
while executing
"error "site_node::get \"must pass in either url or node_id\"""
(procedure "site_node::get" line 4)
invoked from within
"site_node::get -url $mount_url"
(procedure "::Generic::package_id_from_package_key" line 4)
invoked from within
"::Generic::package_id_from_package_key xotcl-request-monitor"

I will like resolve these problems before test the performance in our true cluster.

Any pointer?
Agustín

We are working in our production cluster with your code
with some small mods. The speed are very increased.
Thanks!

We have since 400 concurrent connections.
If anybody want to know how is our system:

http://aulavirtual.uv.es/ficheros/view/imagenes%5C/CLUSTER_AulaVirtual_pub.gif

NOTES:

Another patch (line 360, site-nodes-procs.tcl):
db_foreach $query_name {} {
if {$parent_id eq ""} {
# url of root node
set url "/"
} else {
# append directory to url of parent node
if { [info exists url_by_node_id($parent_id)] } {
set url $url_by_node_id($parent_id)
} else {
set url [db_string snid {select site_node__url(:parent_id)} -default ""]
}
append url $name
if { $directory_p eq "t" } { append url "/" }
}

Regards,
Agustin