Here is what I get when I attach to a process that is taking 100% cpu: Reading symbols from /usr/sbin/dbmail-pop3d...done. Reading symbols from /usr/lib/libmysqlclient.so.12...done. Loaded symbols for /usr/lib/libmysqlclient.so.12 Reading symbols from /lib/libc.so.6...done. Loaded symbols for /lib/libc.so.6 Reading symbols from /lib/libcrypt.so.1...done. Loaded symbols for /lib/libcrypt.so.1 Reading symbols from /usr/lib/libz.so.1...done. Loaded symbols for /usr/lib/libz.so.1 Reading symbols from /lib/libnsl.so.1...done. Loaded symbols for /lib/libnsl.so.1 Reading symbols from /lib/libm.so.6...done. Loaded symbols for /lib/libm.so.6 Reading symbols from /usr/lib/i686/cmov/libssl.so.0.9.7...done. Loaded symbols for /usr/lib/i686/cmov/libssl.so.0.9.7 Reading symbols from /usr/lib/i686/cmov/libcrypto.so.0.9.7...done. Loaded symbols for /usr/lib/i686/cmov/libcrypto.so.0.9.7 Reading symbols from /lib/ld-linux.so.2...done. Loaded symbols for /lib/ld-linux.so.2 Reading symbols from /lib/libdl.so.2...done. Loaded symbols for /lib/libdl.so.2 Reading symbols from /lib/libnss_compat.so.2...done. Loaded symbols for /lib/libnss_compat.so.2 Reading symbols from /lib/libnss_nis.so.2...done. Loaded symbols for /lib/libnss_nis.so.2 Reading symbols from /lib/libnss_files.so.2...done. Loaded symbols for /lib/libnss_files.so.2 0x400c4ba9 in _IO_str_overflow () from /lib/libc.so.6
Thanks. When we last encountered each other on (Tuesday 07 October 2003 3:29 am), I spoke with a being called Ilja Booij, transcript follows: > Hi Bret, > > could you maybe use gdb to attach to the process handling your > pop-session, > (you can use the dbmail-log to find the pid of the process handling a > session) > and stop the process when the problem occurs, then do a backtrace. This > way we can find the location of the problem. I have not been able to > reproduce the problem here, by the way. It's probably some subtle bug > in the code. > > cheers, > Ilja > > On Monday, Oct 6, 2003, at 20:45 Europe/Amsterdam, Bret Baptist wrote: > > What would you need from me to test this? > > > > Bret. > > > > On Monday 06 October 2003 1:30 pm, Eelco van Beek - IC&S wrote: > >> Hi Bret, > >> > >> We have a problem locating the exact cause of this. I think it is best > >> if you exchange details with Ilja(@ic-s.nl). > >> > >> Thanks for helping! > >> > >> Eelco > >> > >> On maandag, okt 6, 2003, at 20:27 Europe/Amsterdam, Bret Baptist > >> > >> wrote: > >>> Is there anyone that I could work with to resolve this issue? > >>> > >>> Bret. > >>> > >>> > >>> > >>> ---------- Forwarded Message ---------- > >>> > >>> Subject: Re: [Dbmail] 100% cpu usage with dbmail-pop3d > >>> Date: Monday 06 October 2003 1:11 pm > >>> From: "Jesse Norell" <[EMAIL PROTECTED]> > >>> To: [email protected] > >>> > >>> Hello, > >>> > >>> Yes, that's exactly what it acts like. I looked over the code a > >>> bit once and nothing stood out as definitely wrong, but I really > >>> don't do a lot of C network coding, so it could easily be. > >>> > >>> > >>> ---- Original Message ---- > >>> From: Bret Baptist <[email protected]> > >>> To: [email protected] > >>> Subject: Re: [Dbmail] 100% cpu usage with dbmail-pop3d > >>> Sent: Mon, 6 Oct 2003 12:48:16 -0500 > >>> > >>>> Sarge is testing. > >>>> > >>>> Well I think we can rule out the postgres libs, since I am running > >>>> MySQL. > >>>> I am thinking it must be the SQL code they are using, instead of > >>>> idling > >>>> while waiting for the client to download, it is just taking all the > >>>> cpu. > >>>> > >>>> Just silly. > >>>> > >>>> > >>>> Bret. > >>>> > >>>> On Monday 06 October 2003 12:36 pm, Jesse Norell wrote: > >>>>> Hello, > >>>>> > >>>>> Take comfort in the fact that you're not alone ... but I don't > >>>>> have a solution for you. This is exactly what we're seeing after > >>>>> having upgraded to debian unstable (is unstable now sarge?). I > >>>>> alluded to this briefly in a reply the other day - I think the > >>>>> problem has to either be in the linux kernel or the postgres libs, > >>>>> not dbmail itsself, but maybe would be possible to work around > >>>>> it if it could be nailed down. We've not had much time to look > >>>>> into it, just have enough pop3 front ends that we can put it off > >>>>> for a while. It has persisted through a few kernel updates (and > >>>>> tried smp kernel, same effects), and at least one postgres lib > >>>>> update also... > >>>>> > >>>>> > >>>>> > >>>>> ---- Original Message ---- > >>>>> From: Bret Baptist <[email protected]> > >>>>> To: [email protected] > >>>>> Subject: [Dbmail] 100% cpu usage with dbmail-pop3d > >>>>> Sent: Mon, 6 Oct 2003 12:24:21 -0500 > >>>>> > >>>>>> I recently switched over to a separate dbmail front end server and > >>>>>> database server. When I set the new front end server up I used > >>>>>> debian > >>>>>> sarge. Since that time I have been having huge problems with load > >>>>>> being caused by dbmail-pop3d. It appears to attempt to use all > >>>>>> the > >>>>>> available cpu while transferring messages to the client. I had > >>>>>> never > >>>>>> seen this before when running the front end and database on the > >>>>>> same > >>>>>> server. > >>>>>> > >>>>>> Does anyone have any clues? This is where the logs are at when it > >>>>>> is > >>>>>> taking 100% cpu: > >>>>>> Oct 6 12:02:52 destiny dbmail/pop3d[20773]: pop3():RETR command, > >>>>>> retrieving message > >>>>>> Oct 6 12:02:52 destiny dbmail/pop3d[20773]: pop3(): RETR command, > >>>>>> selecting message > >>>>>> Oct 6 12:02:52 destiny dbmail/pop3d[20773]: > >>>>>> db_send_message_lines(): > >>>>>> request for [-2] lines > >>>>>> Oct 6 12:02:52 destiny dbmail/pop3d[20773]: > >>>>>> db_send_message_lines(): > >>>>>> executing query [SELECT * FROM messageblks WHERE > >>>>>> message_idnr=2458388 > >>>>>> ORDER BY messageblk_idnr ASC] > >>>>>> Oct 6 12:02:52 destiny dbmail/pop3d[20773]: db_query(): executing > >>>>>> [SELECT * FROM messageblks WHERE message_idnr=2458388 ORDER BY > >>>>>> messageblk_idnr ASC] Oct 6 12:02:52 destiny dbmail/pop3d[20773]: > >>>>>> db_send_message_lines(): sending [-2] lines from message [2458388] > >>>>>> Oct 6 12:02:52 destiny dbmail/pop3d[20773]: > >>>>>> db_send_message_lines(): > >>>>>> getting nextblock [1] > >>>>>> > >>>>>> I am running the latest CVS version available, and still seeing > >>>>>> this > >>>>>> issue. > >>>>>> > >>>>>> > >>>>>> -- > >>>>>> Bret Baptist > >>>>>> Systems and Technical Support Specialist > >>>>>> [EMAIL PROTECTED] > >>>>>> Internet Exposure, Inc. > >>>>>> http://www.iexposure.com > >>>>>> > >>>>>> (612)676-1946 x17 > >>>>>> Web Development-Web Marketing-ISP Services > >>>>>> ------------------------------------------ > >>>>>> > >>>>>> > >>>>>> Today is the tomorrow you worried about yesterday. > >>>>>> > >>>>>> _______________________________________________ > >>>>>> Dbmail mailing list > >>>>>> [email protected] > >>>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > >>>>> > >>>>> -- End Original Message -- > >>>>> > >>>>> > >>>>> -- > >>>>> Jesse Norell > >>>>> jesse (at) kci.net > >>>>> > >>>>> > >>>>> _______________________________________________ > >>>>> Dbmail mailing list > >>>>> [email protected] > >>>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > >>>> > >>>> -- > >>>> Bret Baptist > >>>> Systems and Technical Support Specialist > >>>> [EMAIL PROTECTED] > >>>> Internet Exposure, Inc. > >>>> http://www.iexposure.com > >>>> > >>>> (612)676-1946 x17 > >>>> Web Development-Web Marketing-ISP Services > >>>> ------------------------------------------ > >>>> > >>>> > >>>> Today is the tomorrow you worried about yesterday. > >>>> > >>>> _______________________________________________ > >>>> Dbmail mailing list > >>>> [email protected] > >>>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > >>> > >>> -- End Original Message -- > >>> > >>> > >>> -- > >>> Jesse Norell > >>> jesse (at) kci.net > >>> > >>> > >>> _______________________________________________ > >>> Dbmail mailing list > >>> [email protected] > >>> https://mailman.fastxs.nl/mailman/listinfo/dbmail > >>> > >>> ------------------------------------------------------- > >>> > >>> -- > >>> Bret Baptist > >>> Systems and Technical Support Specialist > >>> [EMAIL PROTECTED] > >>> Internet Exposure, Inc. > >>> http://www.iexposure.com > >>> > >>> (612)676-1946 x17 > >>> Web Development-Web Marketing-ISP Services > >>> ------------------------------------------ > >>> > >>> > >>> Today is the tomorrow you worried about yesterday. > >> > >> _________________________ > >> E.J.A. van Beek > >> ICT Manager > >> IC&S > >> T: +31 30 2322878 > >> F: +31 30 2322305 > >> > >> PGP-key: > >> www.ic-s.nl/keys/eelco.txt > > > > -- > > Bret Baptist > > Systems and Technical Support Specialist > > [EMAIL PROTECTED] > > Internet Exposure, Inc. > > http://www.iexposure.com > > > > (612)676-1946 x17 > > Web Development-Web Marketing-ISP Services > > ------------------------------------------ > > > > > > Today is the tomorrow you worried about yesterday. -- Bret Baptist Systems and Technical Support Specialist [EMAIL PROTECTED] Internet Exposure, Inc. http://www.iexposure.com (612)676-1946 x17 Web Development-Web Marketing-ISP Services ------------------------------------------ Today is the tomorrow you worried about yesterday.
