Forum OpenACS Development: Xowiki - Error after umounting instance

Request notifications

Collapse
Posted by Iuri Sampaio on
Hi there,

It seems the error started after umounting a xowiki instance. Furthermore, The whole template crashed and Naviserver is unable torender any page.

Error: error within rp_filter when getting site node: Error: unknown database method 'node_id' for ::xo::db::sql::site_node

How would clean it all up or re-mount the application again?

* the complete log is appended bellow.
Best wihes,
Iuri

[24/Apr/2017:10:35:10][1860.7f112199d700][-conn:1contact:1-] Error: rp_report_error: Error rendering error page (!)
Error: unknown database method 'node_id' for ::xo::db::sql::site_node
while executing
"error "Error: unknown database method '$m' for [self]""
(procedure "unknown" line 2)
::xo::db::sql::site_node ::xo::db::Class->unknown
invoked from within
"next "
invoked from within
"ns_cache_eval xo_site_nodes id-$url { next }"
(procedure ":get_node_id" line 2)
::xo::site_node ::xo::SiteNodeCache->get_node_id
invoked from within
":get_node_id -url $url"
(procedure "get" line 10)
::xo::site_node ::xo::SiteNode->get
invoked from within
"::xo::site_node get -url $url -node_id $node_id"
(procedure "::nsf::procs::site_node::get" line 2)
invoked from within
"site_node::get -url $url"
(procedure "::nsf::procs::site_node::closest_ancestor_package" line 14)
invoked from within
"site_node::closest_ancestor_package -node_id [ad_conn node_id] -package_key [subsite::package_keys] -include_self -element "node_id""
(procedure "ad_conn" line 131)
invoked from within
"ad_conn subsite_node_id"
(procedure "ad_conn" line 135)
invoked from within
"ad_conn subsite_id"
("uplevel" body line 4)
invoked from within
"uplevel {
set __adp_output {}; set __ad_conn_locale [ad_conn locale]

set __adp_master [template::util::master_to_file "[parameter::get -packa..."
(procedure "template::code::adp::/var/www/1contact/packages/acs-tcl/lib/..." line 2)
invoked from within
"template::code::${template_extension}::$__adp_stub"
invoked from within
"template::adp_parse /var/www/1contact/packages/acs-tcl/lib/page-error {stacktrace {} user_id 0 error_file /var/www/1contact/www/index.adp prev_url {} ..."
("uplevel" body line 1)
invoked from within
"uplevel [list template::adp_parse [template::util::url_to_file $template [ad_conn file]] $template_params]"
(procedure "::nsf::procs::ad_parse_template" line 10)
invoked from within
"ad_parse_template -params $params "/packages/acs-tcl/lib/page-error""
("uplevel" body line 2)
invoked from within
"uplevel $body "
[24/Apr/2017:10:35:10][1860.7f112199d700][-conn:1contact:1-] Error: Error: unknown database method 'node_id' for ::xo::db::sql::site_node
while executing
"error "Error: unknown database method '$m' for [self]""
(procedure "unknown" line 2)
::xo::db::sql::site_node ::xo::db::Class->unknown
invoked from within
"next "
invoked from within
"ns_cache_eval xo_site_nodes id-$url { next }"
(procedure ":get_node_id" line 2)
::xo::site_node ::xo::SiteNodeCache->get_node_id
invoked from within
":get_node_id -url $url"
(procedure "get" line 10)
::xo::site_node ::xo::SiteNode->get
invoked from within
"::xo::site_node get -url $url -node_id $node_id"
(procedure "::nsf::procs::site_node::get" line 2)
invoked from within
"site_node::get -url $url"
(procedure "::nsf::procs::site_node::closest_ancestor_package" line 14)
invoked from within
"site_node::closest_ancestor_package -node_id [ad_conn node_id] -package_key [subsite::package_keys] -include_self -element "node_id""
(procedure "ad_conn" line 131)
invoked from within
"ad_conn subsite_node_id"
(procedure "ad_conn" line 135)

Collapse
Posted by Antonio Pisano on
Dear Iuri,

can you plese tell what version of OpenACS are you running? On my dev instance from latest cvs I have tried unmounting xowiki package and there was no problem.

Can you access any page on your system?

Collapse
Posted by Iuri Sampaio on
Hi Pisano,

I have no access at all. I'm unable to run even a simple .tcl script/page I've created within /www/ .

ad_page_contract {}
::xo::db::sql::apm_package proc delete -package_id ####

ACS-KERNEL 5.9.1d17 and Xowiki 5.9.1d10. I wonder how I would whether roll it back or fix the issue specifically. Restarting from scratch is not a possibility

Best wishes,

Collapse
Posted by Gustaf Neumann on
Hi Iuri,

i am not sure, what you have done, but according to the error message, it looks to me, as if there is more wrong than an unmounted xowiki instance. The error message "unknown database method" indicates, that xotcl-core/tcl/05-db-procs.tcl was not sourced properly,

What is the first "Error:" in your error.log file when you start the server?

Collapse
Posted by Iuri Sampaio on
Hi Gustaf,

Please see startup errors bellow

#########
## 1o LOG
#########

[24/Apr/2017:18:53:02][22834.7f4f19a6c700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/05-db-procs.tcl:
argument with no name
(creating proc "new")
invoked from within
"::nsf::method::create [self] -per-object $name $arguments $body {*}$conditions"
(procedure "proc" line 6)
::xo::db::sql::mandat ::xotcl::Object->proc
invoked from within
"::xo::db::sql::mandat proc new {{-dbn {}} {-
mandat_id:required} {-
code:required} {-
customer_id:required} {-
type_of_tr..."
("uplevel" body line 1)
invoked from within
"uplevel [list [self] proc {*}$flags $proc_name $arguments {*}$returnSpec $body]"
(procedure "ad_proc" line 4)
::xo::db::sql::mandat ::xotcl::Object->ad_proc
invoked from within
"my ad_proc $object_name $nonposarg_list {Automatically generated method} [dict get $sql_info body]"
(procedure "dbproc_nonposargs" line 52)
::xo::db::sql::mandat ::xo::db::Class->dbproc_nonposargs
invoked from within
"$class_name dbproc_nonposargs [string tolower $object_name]"
(procedure "create_all_functions" line 22)
::xo::db::Class->create_all_functions
invoked from within
"::xo::db::Class create_all_functions"
(in namespace eval "::xo::db" script line 660)
invoked from within
"namespace eval ::xo::db {
#
# ::xo::db::Class is a meta class for interfacing with acs_object_types.
# acs_object_types are instances of this me..."
(file "/var/www/1contact/packages/xotcl-core/tcl/05-db-procs.tcl" line 995)
invoked from within
"source $__file "

#########
## 2o LOG
#########

[24/Apr/2017:18:53:02][22834.7f4f19a6c700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/06-package-procs.tcl:
superclass: expected a list of classes but got "::xo::db::Object"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xo::Package superclass ::xo::db::Object} {superclass: expected ..."
::xo::Package ::xotcl::Class->superclass
::xo::PackageMgr ::xotcl::Class->create
invoked from within
"PackageMgr create ::xo::Package -superclass ::xo::db::Object -table_name apm_packages -id_column package_id -object_type apm_package -package_key a..."
(in namespace eval "::xo" script line 200)
invoked from within
"namespace eval ::xo {
#
# Meta-Class for Application Package Classes
#

Class create ::xo::PackageMgr \
-superclass ::xo::db::Class \
..."
(file "/var/www/1contact/packages/xotcl-core/tcl/06-package-procs.tcl" line 9)
invoked from within
"source $__file "

##########
## 3o LOG
##########

[24/Apr/2017:18:53:02][22834.7f4f19a6c700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/06-param-procs.tcl:
superclass: expected a list of classes but got "::xo::db::Object"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xo::db::apm_parameter superclass ::xo::db::Object} {superclass:..."
::xo::db::apm_parameter ::xotcl::Class->superclass
::xo::db::Class ::xotcl::Class->create
invoked from within
"::xo::db::Class create $classname -superclass [my object_type_to_class $supertype] -object_type $object_type -supertype $supertype -pretty_name $p..."
(procedure "get_class_from_db" line 13)
::xo::db::Class->get_class_from_db
invoked from within
"::xo::db::Class get_class_from_db -object_type apm_parameter"
(in namespace eval "::xo" script line 8)
invoked from within
"namespace eval ::xo {

Class create ::xo::parameter

# Every OpenACS parameter should work with the methods defined here.
# So, fetch first th..."
(file "/var/www/1contact/packages/xotcl-core/tcl/06-param-procs.tcl" line 108)
invoked from within
"source $__file "

##########
## 4o LOG
##########

[24/Apr/2017:18:53:02][22834.7f4f19a6c700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/cr-procs.tcl:
superclass: expected a list of classes but got "::xo::db::Object"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xo::db::CrItem superclass ::xo::db::Object} {superclass: expect..."
::xo::db::CrItem ::xotcl::Class->superclass
::xo::db::CrClass ::xotcl::Class->create
invoked from within
"::xo::db::CrClass create ::xo::db::CrItem -superclass ::xo::db::Object -table_name cr_revisions -id_column revision_id -object_type content_revisio..."
(in namespace eval "::xo::db" script line 632)
invoked from within
"namespace eval ::xo::db {

::xotcl::Class create ::xo::db::CrClass \
-superclass ::xo::db::Class \
-parameter {
{supertype conte..."
(file "/var/www/1contact/packages/xotcl-core/tcl/cr-procs.tcl" line 9)
invoked from within
"source $__file "

Collapse
Posted by Gustaf Neumann on
It seems, as if you have defined an SQL function "mandat__new", which does not follow the usual conventions. can you post the SQL-definition of this function?
Collapse
Posted by Iuri Sampaio on
You're right. I did changed standard deifinitions. I've read this old standard

http://openacs.org/doc/acs-content-repository/tutorial

create function pm_task__new_task_item (
p_task_id integer,
p_project_id integer,
p_title varchar,
p_description varchar,
p_end_date timestamptz,
p_percent_complete numeric,
p_estimated_hours_work numeric,
p_estimated_hours_work_min numeric,
p_estimated_hours_work_max numeric,
p_creation_date timestamptz,
p_creation_user integer,
...

But I dropped them all (all plsql functions) , restarted and the error remains.

Best wishes,

Collapse
Posted by Iuri Sampaio on
By the way, the old standard seems more logic to avoid wrong datatype assignments while coding new plsql.

Why have we changed to

CREATE OR REPLACE FUNCTION mandat__new(
integer,
varchar,
varchar,

...

DECLARE
p_mandat_id ALIAS FOR $1;
p_type_of_transaction ALIAS FOR $2;
p_type_of_property ALIAS FOR $3;
...

Collapse
Posted by Iuri Sampaio on
Gustaff,

Ok. Fixed. I have left one version of mandat__new left. Now, I will rewrite all plsql and run the scripts again.

Best wishes,
Iuri

Collapse
Posted by Gustaf Neumann on
The problem was in mandat__new(), and not not in pm_task__new_task_item(). If you change the definition to:
CREATE OR REPLACE FUNCTION mandat__new(
   p_mandat_id  integer,
   p_type_of_transaction varchar,
   p_type_of_property varchar,
...
at least this error should go away. I was not able to reproduce the problem with the provided definition, but i made the code more robust (updated in CVS).
Collapse
Posted by Iuri Sampaio on
I rolled back to the preivous standard within ... ALIAS FOR $1 ... instead. Later on I'll download it from CVS and try coding that way.

Thanks again.

Collapse
Posted by Iuri Sampaio on
Gustaf,

Here it's the plsql definition:

CREATE OR REPLACE FUNCTION mandat__new(
p_mandat_id integer,
p_code varchar,
p_type_of_transaction smallint,
p_type_of_property smallint,
p_subtype_of_property smallint,
p_rooms_min smallint,
p_surface_min numeric,
p_budget_max numeric,
p_selected_regions text,
p_selected_routes text,
p_unwanted_areas text,
p_charac_required text,
p_requests text,
p_status smallint,
p_payment_mode smallint,
p_tva_p boolean,
p_card_provider varchar,
p_search_reason text,
p_photo_instead_visit_p boolean,
p_current_residence_date date,
p_assurer_company varchar,
p_assurer_contract varchar,
p_doc_not_porsuing boolean,
p_doc_holerite boolean,
p_doc_identity boolean,
p_doc_job_contract boolean,
p_doc_job_rec_letter boolean,
p_customer_id integer,
p_guarantor_id integer,
p_cotenant_id integer,
p_creation_user integer,
p_creation_ip varchar,
p_context_id integer
) RETURNS integer AS $$
DECLARE

BEGIN
...

Collapse
Posted by Iuri Sampaio on
Gustaff,

The problem is not resolved. At first I thought the error was gone, but after inserting the first register (i.e. acs_object) it starts ti fail again.
The complete plsql is defined bellow. As well as the full statup logs

CREATE OR REPLACE FUNCTION mandat__new(
integer,
varchar,
smallint,
smallint,
smallint,
smallint,
numeric,
numeric,
text,
text,
text,
text,
text,
smallint,
smallint,
boolean,
varchar,
text,
boolean,
timestamp,
varchar,
varchar,
boolean,
boolean,
boolean,
boolean,
boolean,
integer,
integer,
integer,
integer,
varchar,
integer
) RETURNS integer AS '
DECLARE
p_mandat_id ALIAS FOR $1;
p_code ALIAS FOR $2;
p_type_of_transaction ALIAS FOR $3;
p_type_of_property ALIAS FOR $4;
p_subtype_of_property ALIAS FOR $5;
...
p_creation_user ALIAS FOR $31;
p_creation_ip ALIAS FOR $32;
p_context_id ALIAS FOR $33;

BEGIN


PERFORM acs_object__new (
p_mandat_id, -- object_id
''mandat_object'', -- object_type
now(), -- creation_date
p_creation_user, -- creation_user
p_creation_ip, -- cretion_ip
p_context_id, -- context_id
true --
);

INSERT INTO mandats (
mandat_id,
code,
type_of_transaction,
type_of_property,

...



) VALUES (
p_mandat_id,
p_code,
p_type_of_transaction,
p_type_of_property,
...
p_cotenant_id
);

RETURN 0;

END;' LANGUAGE 'plpgsql';

25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: obtain fnargs for WORKFLOW_CASE_PKG__DELETE from PostgreSQL via parsing function definition
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/05-db-procs.tcl:
argument with no name
(creating proc "new")
invoked from within
"::nsf::method::create [self] -per-object $name $arguments $body {*}$conditions"
(procedure "proc" line 6)
::xo::db::sql::mandat ::xotcl::Object->proc
invoked from within
"::xo::db::sql::mandat proc new {{-dbn {}} {-
mandat_id:required} {-
code:required} {-
customer_id:required} {-
type_of_tr..."
("uplevel" body line 1)
invoked from within
"uplevel [list [self] proc {*}$flags $proc_name $arguments $body]"
(procedure "ad_proc" line 3)
::xo::db::sql::mandat ::xotcl::Object->ad_proc
invoked from within
"my ad_proc $object_name $nonposarg_list {Automatically generated method} [dict get $sql_info body]"
(procedure "dbproc_nonposargs" line 52)
::xo::db::sql::mandat ::xo::db::Class->dbproc_nonposargs
invoked from within
"$class_name dbproc_nonposargs [string tolower $object_name]"
(procedure "create_all_functions" line 22)
::xo::db::Class->create_all_functions
invoked from within
"::xo::db::Class create_all_functions"
(in namespace eval "::xo::db" script line 659)
invoked from within
"namespace eval ::xo::db {
#
# ::xo::db::Class is a meta class for interfacing with acs_object_types.
# acs_object_types are instances of this me..."
(file "/var/www/1contact/packages/xotcl-core/tcl/05-db-procs.tcl" line 862)
invoked from within
"source $__file "
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/05-db-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/06-package-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/06-package-procs.tcl:
superclass: expected a list of classes but got "::xo::db::Object"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xo::Package superclass ::xo::db::Object} {superclass: expected ..."
::xo::Package ::xotcl::Class->superclass
::xo::PackageMgr ::xotcl::Class->create
invoked from within
"PackageMgr create ::xo::Package -superclass ::xo::db::Object -table_name apm_packages -id_column package_id -object_type apm_package -package_key a..."
(in namespace eval "::xo" script line 200)
invoked from within
"namespace eval ::xo {
#
# Meta-Class for Application Package Classes
#

Class create ::xo::PackageMgr \
-superclass ::xo::db::Class \
..."
(file "/var/www/1contact/packages/xotcl-core/tcl/06-package-procs.tcl" line 9)
invoked from within
"source $__file "
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/06-package-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/06-param-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/06-param-procs.tcl:
superclass: expected a list of classes but got "::xo::db::Object"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xo::db::apm_parameter superclass ::xo::db::Object} {superclass:..."
::xo::db::apm_parameter ::xotcl::Class->superclass
::xo::db::Class ::xotcl::Class->create
invoked from within
"::xo::db::Class create $classname -superclass [my object_type_to_class $supertype] -object_type $object_type -supertype $supertype -pretty_name $p..."
(procedure "get_class_from_db" line 13)
::xo::db::Class->get_class_from_db
invoked from within
"::xo::db::Class get_class_from_db -object_type apm_parameter"
(in namespace eval "::xo" script line 8)
invoked from within
"namespace eval ::xo {

Class create ::xo::parameter

# Every OpenACS parameter should work with the methods defined here.
# So, fetch first th..."
(file "/var/www/1contact/packages/xotcl-core/tcl/06-param-procs.tcl" line 108)
invoked from within
"source $__file "
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/06-param-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/10-recreation-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::xotcl::RecreationClass ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: -- softrecreate
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/10-recreation-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/20-Ordered-Composite-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/20-Ordered-Composite-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/30-widget-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/30-widget-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/40-thread-mod-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/40-thread-mod-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/50-protocol-handler-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/50-protocol-handler-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/bgdelivery-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: mutex mid0 created
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/bgdelivery-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/chat-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/chat-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/cluster-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/cluster-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/context-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::xo::Context ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/context-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/cr-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::xo::db::CrClass ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: --Postgres Version 9.5
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xotcl-core/tcl/cr-procs.tcl:
superclass: expected a list of classes but got "::xo::db::Object"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xo::db::CrItem superclass ::xo::db::Object} {superclass: expect..."
::xo::db::CrItem ::xotcl::Class->superclass
::xo::db::CrClass ::xotcl::Class->create
invoked from within
"::xo::db::CrClass create ::xo::db::CrItem -superclass ::xo::db::Object -table_name cr_revisions -id_column revision_id -object_type content_revisio..."
(in namespace eval "::xo::db" script line 631)
invoked from within
"namespace eval ::xo::db {

::xotcl::Class create ::xo::db::CrClass \
-superclass ::xo::db::Class \
-parameter {
{supertype conte..."
(file "/var/www/1contact/packages/xotcl-core/tcl/cr-procs.tcl" line 9)
invoked from within
"source $__file "
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/cr-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/doc-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/doc-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/generic-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::Generic::Form ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::Generic::List ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/generic-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/html-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/html-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/http-client-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/http-client-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/ical-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::xo::ical ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/ical-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/install-check-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/install-check-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xotcl-core/tcl/policy-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xotcl-core/tcl/policy-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/adp-generator-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/view-plain.adp, ::xowiki::view-plain ::xowiki::ADP_Generator->init (0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/view-links.adp, ::xowiki::view-links ::xowiki::ADP_Generator->init (0ms, 0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/view-default.adp, ::xowiki::view-default ::xowiki::ADP_Generator->init (0ms, 0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/oacs-view.adp, ::xowiki::oacs-view ::xowiki::ADP_Generator->init (0ms, 0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/oacs-view2.adp, ::xowiki::oacs-view2 ::xowiki::ADP_Generator->init (0ms, 0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/oacs-view3.adp, ::xowiki::oacs-view3 ::xowiki::ADP_Generator->init (0ms, 0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/view-book.adp, ::xowiki::view-book ::xowiki::ADP_Generator->init (0ms, 0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Notice: create ADP /var/www/1contact/packages/xowiki/tcl/../www/view-book-no-ajax.adp, ::xowiki::view-book-no-ajax ::xowiki::ADP_Generator->init (0ms, 0ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/adp-generator-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/bootstrap-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: --sourcing /var/www/1contact/packages/xowiki/tcl/menu-procs.tcl, ::xo::library ->require (0ms, 1ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::xo::Table::BootstrapTableRenderer::AnchorField ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: update_object_doc ::xo::Table::BootstrapTableRenderer::AnchorField ...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/bootstrap-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/category-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/category-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/chat-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/chat-procs.tcl.
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/folder-procs.tcl...
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: --sourcing /var/www/1contact/packages/xowiki/tcl/xowiki-procs.tcl, ::xo::library ->require (0ms, 11ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xowiki/tcl/xowiki-procs.tcl:
superclass: expected a list of classes but got "::xo::db::CrItem"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xowiki::Page superclass ::xo::db::CrItem} {superclass: expected..."
::xowiki::Page ::xotcl::Class->superclass
::xo::db::CrClass ::xotcl::Class->create
invoked from within
"::xo::db::CrClass create Page -superclass ::xo::db::CrItem -pretty_name "#xowiki.Page_pretty_name#" -pretty_plural "#xowiki.Page_pretty_plural#" -ta..."
(in namespace eval "::xowiki" script line 5)
invoked from within
"namespace eval ::xowiki {
#
# Create classes for different kind of pages
#
::xo::db::CrClass create Page -superclass ::xo::db::CrItem \
..."
(file "/var/www/1contact/packages/xowiki/tcl/xowiki-procs.tcl" line 9)
invoked from within
"source $__file "
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: --sourcing /var/www/1contact/packages/xowiki/tcl/includelet-procs.tcl, ::xo::library ->require (0ms, 3ms)
[25/Apr/2017:10:52:48][3619.7f136a8cf700][-main-] Notice: --sourcing /var/www/1contact/packages/xowiki/tcl/form-field-procs.tcl, ::xo::library ->require (0ms, 24ms)
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/folder-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/import-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/import-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/lcs-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/lcs-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/link-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/link-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/notification-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/notification-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/package-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xowiki/tcl/package-procs.tcl:
superclass: expected a list of classes but got "::xo::Package"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xowiki::Package superclass ::xo::Package} {superclass: expected..."
::xowiki::Package ::xotcl::Class->superclass
::xo::PackageMgr ::xotcl::Class->create
invoked from within
"::xo::PackageMgr create ::xowiki::Package -superclass ::xo::Package -pretty_name "XoWiki" -package_key xowiki -parameter {
{folder_id 0}
..."
(in namespace eval "::xowiki" script line 3)
invoked from within
"namespace eval ::xowiki {

::xo::PackageMgr create ::xowiki::Package \
-superclass ::xo::Package \
-pretty_name "XoWiki" \
-packag..."
(file "/var/www/1contact/packages/xowiki/tcl/package-procs.tcl" line 9)
invoked from within
"source $__file "
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/x

25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xowiki/tcl/xowiki-procs.tcl:
superclass: expected a list of classes but got "::xo::db::CrItem"
::xotcl::Class::slot::superclass ::nx::ObjectParameterSlot->onError
invoked from within
"::xotcl::Class::slot::superclass onError {::xotcl::Class::slot::superclass value=set ::xowiki::Page superclass ::xo::db::CrItem} {superclass: expected..."
::xowiki::Page ::xotcl::Class->superclass
::xo::db::CrClass ::xotcl::Class->create
invoked from within
"::xo::db::CrClass create Page -superclass ::xo::db::CrItem -pretty_name "#xowiki.Page_pretty_name#" -pretty_plural "#xowiki.Page_pretty_plural#" -ta..."
(in namespace eval "::xowiki" script line 5)
invoked from within
"namespace eval ::xowiki {
#
# Create classes for different kind of pages
#
::xo::db::CrClass create Page -superclass ::xo::db::CrItem \
..."
(file "/var/www/1contact/packages/xowiki/tcl/xowiki-procs.tcl" line 9)
invoked from within
"source $__file "
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/xowiki-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/xowiki-sc-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/xowiki-sc-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/xowiki-utility-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: create/recreate ::xowiki::utility without cleanup
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/xowiki-utility-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/xowiki-www-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Error: Error sourcing /var/www/1contact/packages/xowiki/tcl/xowiki-www-procs.tcl:
invalid command name "Page"
while executing
"Page instproc clipboard-add {} {
my instvar package_id

if {![my exists_form_parameter "objects"]} {
my msg "nothing to copy"
}
..."
(in namespace eval "::xowiki" script line 10)
invoked from within
"namespace eval ::xowiki {
#
# This block contains the externally callable methods. We use as
# naming convention dashes as separators.
#

#
..."
(file "/var/www/1contact/packages/xowiki/tcl/xowiki-www-procs.tcl" line 12)
invoked from within
"source $__file "
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loaded packages/xowiki/tcl/xowiki-www-procs.tcl.
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: Loading packages/xowiki/tcl/yui-procs.tcl...
[25/Apr/2017:10:52:49][3619.7f136a8cf700][-main-] Notice: update_object_doc ::YUI::loader ...

Collapse
Posted by Iuri Sampaio on
So far I removed xo-tcl and the error is finally gone. I believe I donwnload a temporarily broken release from HEAD and that stays sleeping until now.

I'll move forward debugging the problem. I'll download the latest version of xotcl , then, I'll confirm here if I notice anything new.

In advance, thanks again for the help/support.

Best wishes,

Collapse
Posted by Gustaf Neumann on
´You do not need to delete xotcl, applying the changes of [1] to xotcl-core/tcl/05-db-procs.tcl is sufficient (when you have a recent version of xotcl-core). With the new code, the somewhat simplified version of your function
CREATE OR REPLACE FUNCTION mandat__new(
 integer,
 varchar,
 varchar
)
RETURNS integer AS $$
DECLARE
p_mandat_id ALIAS FOR $1;
p_code ALIAS FOR $2;
p_type_of_transaction ALIAS FOR $3;
BEGIN
    return 1;
END;
$$ LANGUAGE plpgsql;
is loaded as expected, and no error is triggered (but a few warnings about missing argument names). Btw, you should define the function with named parameters as used all over in newer OpenACS versions in the style of
CREATE OR REPLACE FUNCTION mandat__new(
   p_mandat_id  integer,
   p_type_of_transaction varchar,
   p_type_of_property varchar
)
RETURNS integer AS $$
DECLARE
BEGIN
    return 1;
END;
$$ LANGUAGE plpgsql;
Be aware, that if you are trying multiple variants of a SQL function (like mandat__new), you might have multiple versions of this function defined in you DB, and the the loading process checks, what's in the DB. So, clean up first to avoid confusions.

[1] http://cvs.openacs.org/browse/OpenACS/openacs-4/packages/xotcl-core/tcl/05-db-procs.tcl?r1=1.103.2.36&r2=1.103.2.37