The mailing list for listmasters using Sympa

["Jahnke-Zumbusch, Dirk" <address@concealed>]

Hi David,

 

>Don't the Sympa logs show something about failed queries?

 

Well, nearly everything seems to be identical in the logs, BUT I have

this line in the Oracle (failing) part:

 

bulk[2287]: err internal error :

current packet (messagekey= 1fead53d865a33513c6fa23b82eef74f)

contain a ref to a null message

 

But no specific SQL-errormessage is seen.

 

When I enable debug level 4, I find something like this:

 

bulk[2506]: debug2 mail::reaper() Reaper unwaited pids : #012Open = 0

bulk[2506]: debug2 List::init_list_cache() List::init_list_cache()

bulk[2506]: debug Bulk::next() Bulk::next

bulk[2506]: debug3 List::db_get_handler() List::db_get_handler

bulk[2506]: debug Bulk::message_from_spool() (messagekey : 3bd31e03d42fae4af9f89cc752c9f9c2)

bulk[2506]: err internal error : current packet (messagekey= 3bd31e03d42fae4af9f89cc752c9f9c2) contain a ref to a null message

bulk[2506]: debug Bulk::remove() Bulk::remove(3bd31e03d42fae4af9f89cc752c9f9c2,1730fbefb5f6efff0f21106f8d276661)

bulk[2506]: debug2 mail::smtpto() mail::smtpto(address@concealed, address@concealed, )

bulk[2506]: debug3 mail::smtpto() Open = 0

bulk[2506]: debug Bulk::remove() Bulk::remove(3bd31e03d42fae4af9f89cc752c9f9c2,1730fbefb5f6efff0f21106f8d276661)

bulk[2506]: debug2 mail::reaper() Reaper unwaited pids : 2550#012Open = 1

 

PS: both log snippets below, which have been "synced" to have a better

overview for comparison

 

ORACLE	MYSQL
sympa[2272]: info Configuration file read, default log level 0	sympa[2003]: info Configuration file read, default log level 0
sympa[2272]: info Server started for all, pid 2277	sympa[2003]: info Server started for all, pid 2008
sympa[2277]: notice Sympa 6.1.7 started	sympa[2008]: notice Sympa 6.1.7 started
task_manager[2282]: info Configuration file read, default log level 0	task_manager[2013]: info Configuration file read, default log level 0
hostname bulk[2284]: info Configuration file read, default log level 0	bulk[2015]: info Configuration file read, default log level 0
bulk[2284]: info Starting bulk master daemon, pid 2287	bulk[2015]: info Starting bulk master daemon, pid 2018
bulk[2287]: notice bulk.pl 6.1.7 Started	bulk[2018]: notice bulk.pl 6.1.7 Started
bounced.pl: info Configuration file read, default log level 0	bounced.pl: info Configuration file read, default log level 0
bounced[2292]: notice bounced Started	bounced[2023]: notice bounced Started
archived.pl: info Configuration file read, default log level 0	archived.pl: info Configuration file read, default log level 0
archived[2297]: notice archived 6.1.7 Started	archived[2028]: notice archived 6.1.7 Started
wwsympa[2332]: info WWSympa started	wwsympa[2058]: info WWSympa started
wwsympa[2332]: info WWSympa started	wwsympa[2058]: info WWSympa started
wwsympa[2332]: info SympaSession::new() SympaSession::new ignoring unknown session cookie '82483601047055'
wwsympa[2332]: info SympaSession::new() SympaSession::new ignoring unknown session cookie '82483601047055'
wwsympa[2332]: info [robot hostname.desy.de] [session 5779836815410] [client A.B.C.D] main::do_renewpasswd() do_renewpasswd()	wwsympa[2058]: info [robot hostname.desy.de] [session 71259558843723] [client A.B.C.D] main::do_firstpasswd() do_firstpasswd()
wwsympa[2332]: info [robot hostname.desy.de] [session 5779836815410] [client A.B.C.D] main::do_renewpasswd() do_renewpasswd()	wwsympa[2058]: info [robot hostname.desy.de] [session 71259558843723] [client A.B.C.D] main::do_firstpasswd() do_firstpasswd()
wwsympa[2332]: info [robot hostname.desy.de] [session 13824026200260] [client A.B.C.D] main::do_requestpasswd() do_requestpasswd(address@concealed)	wwsympa[2058]: info [robot hostname.desy.de] [session 71259558843723] [client A.B.C.D] main::do_renewpasswd() do_renewpasswd()
wwsympa[2332]: info [robot hostname.desy.de] [session 13824026200260] [client A.B.C.D] main::do_requestpasswd() do_requestpasswd(address@concealed)	wwsympa[2058]: info [robot hostname.desy.de] [session 71259558843723] [client A.B.C.D] main::do_renewpasswd() do_renewpasswd()
	wwsympa[2058]: info [robot hostname.desy.de] [session 8172502725355] [client A.B.C.D] main::do_requestpasswd() do_requestpasswd(address@concealed)
	wwsympa[2058]: info [robot hostname.desy.de] [session 8172502725355] [client A.B.C.D] main::do_requestpasswd() do_requestpasswd(address@concealed)
wwsympa[2332]: info Auth::create_one_time_ticket() Auth::create_one_time_ticket(address@concealed,hostname.desy.de,choosepasswd,A.B.C.D) value = 87545674446806	wwsympa[2058]: info Auth::create_one_time_ticket() Auth::create_one_time_ticket(address@concealed,hostname.desy.de,choosepasswd,A.B.C.D) value = 50213592336591
wwsympa[2332]: info Auth::create_one_time_ticket() Auth::create_one_time_ticket(address@concealed,hostname.desy.de,choosepasswd,A.B.C.D) value = 87545674446806	wwsympa[2058]: info Auth::create_one_time_ticket() Auth::create_one_time_ticket(address@concealed,hostname.desy.de,choosepasswd,A.B.C.D) value = 50213592336591
bulk[2287]: err internal error : current packet (messagekey= 1fead53d865a33513c6fa23b82eef74f) contain a ref to a null message
archived[2297]: notice archived exited normally due to signal	archived[2028]: notice archived exited normally due to signal
bounced[2292]: notice bounced exited normally due to signal	bounced[2023]: notice bounced exited normally due to signal
bulk[2287]: notice main::sigterm() signal TERM received, still processing current task	bulk[2018]: notice main::sigterm() signal TERM received, still processing current task
bulk[2287]: notice bulk.pl exited normally due to signal	bulk[2018]: notice bulk.pl exited normally due to signal
task_manager[2282]: notice task_manager exited normally due to signal	task_manager[2013]: notice task_manager exited normally due to signal
sympa[2277]: notice main::sigterm() signal TERM received, still processing current task	sympa[2008]: notice main::sigterm() signal TERM received, still processing current task
sympa[2277]: notice Sympa exited normally due to signal	sympa[2008]: notice Sympa exited normally due to signal

 

 

--

Dirk Jahnke-Zumbusch              Deutsches Elektronen-Synchrotron DESY

IT Information Fabrics              Member of the Helmholtz Association

D-22603 Hamburg                        Notkestrasse 85  / 22607 Hamburg

T: +49-40-899.81760   F: +49-40-899.41760  address@concealed