Forum OpenACS Development: Re: import database

Collapse
2: Re: import database (response to 1)
Posted by Iuri Sampaio on 02/08/08 09:32 PM
so far,
i noticed some apis of notifications pkg, (such as
notification::sweep::sweep_notifications), generate errors more oftenly than before.

[08/Feb/2008:05:24:11][17018.3034266544][-sched:12-] Error: Ns_PgExec: result status: 7 message: ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^

[08/Feb/2008:05:24:11][17018.3034266544][-sched:12-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^
")

while executing
"ns_pg_bind select nsdb0 {
select
message_id as id,
creation_date,
locking_server,..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]

set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_queued_messages {} {
# check if record is already there and free to use
set return_id [db_string get_qu..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"with_finally -code {
db_foreach get_queued_messages {} {
# check if record is already there and free to use
..."
(procedure "acs_mail_lite::sweeper" line 8)
invoked from within
"acs_mail_lite::sweeper"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 acs_mail_lite::sweeper {} 1202476990 0 f}"
[08/Feb/2008:05:24:12][17018.3034266544][-sched:16-] Error: Ns_PgExec: result status: 7 message: ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^

[08/Feb/2008:05:24:12][17018.3034266544][-sched:16-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^
")

while executing
"ns_pg_bind select nsdb0 {
select notification_id,
notif_subject,
notif_text,
noti..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set result [list]
set selection [db_exec select $db $full_statement_name $sql]

while {[db_getro..."
(procedure "db_list_of_ns_sets" line 7)
invoked from within
"db_list_of_ns_sets select_notifications {}"
(procedure "notification::sweep::sweep_notifications" line 7)
invoked from within
"notification::sweep::sweep_notifications -interval_id 587 -batched_p 0"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 notification::sweep::sweep_notifications {-interval_id 587 -batched_p 0} 1202476992 0 f}"
[08/Feb/2008:05:25:11][17018.3034266544][-sched:12-] Error: Ns_PgExec: result status: 7 message: ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^

[08/Feb/2008:05:25:11][17018.3034266544][-sched:12-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^
")

while executing
"ns_pg_bind select nsdb0 {
select
message_id as id,
creation_date,
locking_server,..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]

set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_queued_messages {} {
# check if record is already there and free to use
set return_id [db_string get_qu..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"with_finally -code {
db_foreach get_queued_messages {} {
# check if record is already there and free to use
..."
(procedure "acs_mail_lite::sweeper" line 8)
invoked from within
"acs_mail_lite::sweeper"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 acs_mail_lite::sweeper {} 1202476990 0 f}"
[08/Feb/2008:05:25:12][17018.3034266544][-sched:16-] Error: Ns_PgExec: result status: 7 message: ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^

[08/Feb/2008:05:25:12][17018.3034266544][-sched:16-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^
")

while executing
"ns_pg_bind select nsdb0 {
select notification_id,
notif_subject,
notif_text,
noti..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set result [list]
set selection [db_exec select $db $full_statement_name $sql]

while {[db_getro..."
(procedure "db_list_of_ns_sets" line 7)
invoked from within
"db_list_of_ns_sets select_notifications {}"
(procedure "notification::sweep::sweep_notifications" line 7)
invoked from within
"notification::sweep::sweep_notifications -interval_id 587 -batched_p 0"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 notification::sweep::sweep_notifications {-interval_id 587 -batched_p 0} 1202476992 0 f}"
[08/Feb/2008:05:26:11][17018.3034266544][-sched:12-] Error: Ns_PgExec: result status: 7 message: ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^

[08/Feb/2008:05:26:11][17018.3034266544][-sched:12-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "creation_date" does not exist
LINE 4: creation_date,
^
")

while executing
"ns_pg_bind select nsdb0 {
select
message_id as id,
creation_date,
locking_server,..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 2)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set selection [db_exec select $db $full_statement_name $sql]

set counter 0
while { [db_getrow $..."
(procedure "db_foreach" line 36)
invoked from within
"db_foreach get_queued_messages {} {
# check if record is already there and free to use
set return_id [db_string get_qu..."
("uplevel" body line 2)
invoked from within
"uplevel $code"
invoked from within
"with_finally -code {
db_foreach get_queued_messages {} {
# check if record is already there and free to use
..."
(procedure "acs_mail_lite::sweeper" line 8)
invoked from within
"acs_mail_lite::sweeper"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 acs_mail_lite::sweeper {} 1202476990 0 f}"
[08/Feb/2008:05:26:12][17018.3034266544][-sched:16-] Error: Ns_PgExec: result status: 7 message: ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^

[08/Feb/2008:05:26:12][17018.3034266544][-sched:16-] Error: Tcl exception:
Database operation "select" failed
(exception ERROR, "ERROR: column "file_ids" does not exist
LINE 6: file_ids,
^
")

while executing
"ns_pg_bind select nsdb0 {
select notification_id,
notif_subject,
notif_text,
noti..."
("uplevel" body line 1)
invoked from within
"uplevel $ulevel [list ns_pg_bind $type $db $sql]"
("postgresql" arm line 2)
invoked from within
"switch $driverkey {
oracle {
return [uplevel $ulevel [list ns_ora $type $db $sql] $args]
}
..."
invoked from within
"db_exec select $db $full_statement_name $sql"
invoked from within
"set selection [db_exec select $db $full_statement_name $sql]"
("uplevel" body line 3)
invoked from within
"uplevel 1 $code_block "
invoked from within
"db_with_handle -dbn $dbn db {
set result [list]
set selection [db_exec select $db $full_statement_name $sql]

while {[db_getro..."
(procedure "db_list_of_ns_sets" line 7)
invoked from within
"db_list_of_ns_sets select_notifications {}"
(procedure "notification::sweep::sweep_notifications" line 7)
invoked from within
"notification::sweep::sweep_notifications -interval_id 587 -batched_p 0"
("eval" body line 1)
invoked from within
"eval [concat [list $proc] $args]"
(procedure "ad_run_scheduled_proc" line 46)
invoked from within
"ad_run_scheduled_proc {t f 60 notification::sweep::sweep_notifications {-interval_id 587 -batched_p 0} 1202476992 0 f}"
^X