Menu
▾
▴
perfparse-users
|
From: Ricardo D. M. <ric...@gm...> - 2004-10-25 13:19:09
|
Hi, i am currently testing perfparse version 0.14 on a mysql crossed replication solution. I know it's not the last version. Anyways i found a problem dealing with mysql innodb queries. When i consult the nagios native CGIs i found no problem. When consulting PerfParse CGI (the only that uses innodb) I found this persistent error on each resulting query to the data base. 041025 14:02:29 Aborted connection 1882 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) 041025 14:02:34 Aborted connection 1884 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) 041025 14:02:55 Aborted connection 1889 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) 041025 14:02:59 Aborted connection 1891 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) 041025 14:03:04 Aborted connection 1893 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) 041025 14:04:04 Aborted connection 1896 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) 041025 14:10:21 Aborted connection 1904 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) 041025 14:10:22 Aborted connection 1903 to db: 'nagios' user: 'nagios' host: `localhost.localdomain' (Got an error reading communication packets) I actually didn't detect (yet) any practical manifestation of this error but i felt i should report it. My regards --=20 Ricardo David Martins ___________________________________________________________________________= __________________________ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. ___________________________________________________________________________= __________________________ |
|
From: Yves M. <yme...@li...> - 2004-10-25 13:42:40
|
> Hi, > > i am currently testing perfparse version 0.14 on a mysql crossed > replication solution. I know it's not the last version. Anyways i We (the developpers) try to support only the latest versions. If this is = a bug, it can have been fixed in a more recent version. We are not a company that sell = support on older version of the software but few hackers who are trying to do our be= st on some free software. For bug reports, please upgrade to some more recent version. If you are asking for support, maybe somebody here can answer you. This i= s probably the best place to ask for support. But don't copy the log without understanding it. We don't need 8 times th= e same line. And ask yourself if you would answer to somebody who says he has problems= to connect to localhost.localdomain with user nagios on db nagios with no other precisi= ons. What would you answer then ? Regards, Yves --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://perfparse.sf.net/ - |
|
From: Ricardo D. M. <ric...@gm...> - 2004-10-25 14:33:03
|
> We (the developpers) try to support only the latest versions. If this is = a bug, it can > have been fixed in a more recent version. We are not a company that sell = support on > older version of the software but few hackers who are trying to do our be= st on some free > software. > For bug reports, please upgrade to some more recent version. I fetched PP 2 months ago... time flies but really!!! I copied the version from perfparse_state table but the tar.gz is 0.100.3. > If you are asking for support, maybe somebody here can answer you. This i= s probably the > best place to ask for support. Support for what? Fixing bugs? This doesn't seem like support. Seems like development. > But don't copy the log without understanding it. We don't need 8 times th= e same line. "... don't copy the log without understanding..." Is this the wrong mailing list? > And ask yourself if you would answer to somebody who says he has problems= to connect to > localhost.localdomain with user nagios on db nagios with no other precisi= ons. What would > you answer then ? I mentioned mysql, PP version 0.14, nagios queries being OK and 8 times the mysql error log (this seemed a little over the top) and that the error happens on PP CGI consulting GUI. It seems null information, so i tell more... Archlinux wombat kernel 2.6.8.1, mysql 4.0.21, nagios 1.2 (all on both replicas, which means the problem occurs on two hosts) I just want to know if any body else found this error before or even an idea for this to happen (Yves doesn't seem to). Regards --=20 Ricardo David Martins ___________________________________________________________________________= __________________________ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. ___________________________________________________________________________= __________________________ |
|
From: Yves M. <yme...@li...> - 2004-10-25 14:48:45
|
>> We (the developpers) try to support only the latest versions. If this = is a bug, it can >> have been fixed in a more recent version. We are not a company that se= ll support on >> older version of the software but few hackers who are trying to do our= best on some >> free >> software. >> For bug reports, please upgrade to some more recent version. > > I fetched PP 2 months ago... time flies but really!!! I copied the > version from perfparse_state table but the tar.gz is 0.100.3. Perfparse was rewritten. So any bug reported on 0.100.X or older version = will not help. >> If you are asking for support, maybe somebody here can answer you. Thi= s is probably >> the >> best place to ask for support. > > Support for what? Fixing bugs? This doesn't seem like support. Seems > like development. Use per...@li... for development :) [...] >> And ask yourself if you would answer to somebody who says he has probl= ems to connect >> to >> localhost.localdomain with user nagios on db nagios with no other prec= isions. What >> would >> you answer then ? > > I mentioned mysql, PP version 0.14, nagios queries being OK and 8 > times the mysql error log (this seemed a little over the top) and that > the error happens on PP CGI consulting GUI. It seems null > information, so i tell more... pp is version 0.100.3 as you wrote it at the beginning. Not 0.14. Some interesting remark to Ben : we don't have a table with what version = of perfparse use what version of the database schema. However, 0.100.3 <-> 0.14 is cor= rect. No problem here :) > Archlinux wombat kernel 2.6.8.1, mysql 4.0.21, nagios 1.2 (all on both > replicas, which means the problem occurs on two hosts) > > I just want to know if any body else found this error before or even > an idea for this to happen (Yves doesn't seem to). Yes, I've already had such a problem : mistyping in the password :) Could you run perfparse-log2db <your options here> --show-config and tell us the results (notice that you will print the db password. Hide= it if you want) I don't say I will be able to help, but I ask questions and maybe somebod= y will have the idea :) Yves --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://perfparse.sf.net/ - |
|
From: Ricardo D. M. <ric...@gm...> - 2004-10-25 18:12:31
|
I have no problem seing the results, but the error appears just the same. I only found the error because i am making tests for a real production environment. > Could you run > perfparse-log2db <your options here> --show-config I only have the perfparse-db-tool. # ./perfparse-db-tool --show_config DB_User =3D "nagios" DB_Name =3D "nagios" DB_Pass =3D "******" DB_Host =3D "127.0.0.1" Drop_File =3D "/tmp/perfparse.drop" Service_Log =3D "/usr/local/nagios/var/serviceperf.log" Host_Log =3D "/usr/local/nagios/var/hostperf.log" Dummy_Hostname =3D "dummy" Delete_Service_Log =3D "No" Delete_Host_Log =3D "No" Nagios_Lock =3D "/usr/local/nagios/var/nagios.lock" Lock_File =3D "/var/lock/perfparse.lock" Be_Silent =3D "no" Do_Report =3D "no" Accept_Odd_Chars_in_Label =3D "no" Default_user_permissions_Policy =3D "rw" Default_user_permissions_Host_groups =3D "rw" Regards --=20 Ricardo David Martins ___________________________________________________________________________= __________________________ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. ___________________________________________________________________________= __________________________ |
|
From: Yves M. <yme...@li...> - 2004-10-26 08:05:44
|
> I have no problem seing the results, but the error appears just the > same. I only found the error because i am making tests for a real > production environment. > >> Could you run >> perfparse-log2db <your options here> --show-config > > I only have the perfparse-db-tool. Ooops, perfparse-log2db is the new version of perparse. With 0.100.x, I w= as meaning perfparse --show_config. But perfparse-db-tool answers the same thing so it's OK. OK, I see nothing unusual here. I have another idea. Check your mysql config file. Do you have 3306 as th= e tcp port for mysqld ? Same question for the client even if I don't know if this is imp= ortant. Is skip-networking defined ? If yes, comment it. Well, if this is not enough, the last thing I would do is : telnet localhost 3306 If the connection is refused, stop searching on perfparse side and read t= he documentation about mysql. If the connection is accepted, for me, it's ga= me over, and just hope that somebody else can help you :) For information for Ricardo and those who would try to help, nagios conne= cts to mysql thanks to a local socket (some file in /tmp/...). Perfparse connects to m= ysql thanks to the network (socket IPv4). I don't know for the client mysql, but it prov= ides a -P option for the port, and -h for the host name. Maybe this can help ? Yves > # ./perfparse-db-tool --show_config > DB_User =3D "nagios" > DB_Name =3D "nagios" > DB_Pass =3D "******" > DB_Host =3D "127.0.0.1" > Drop_File =3D "/tmp/perfparse.drop" > Service_Log =3D "/usr/local/nagios/var/serviceperf.log" > Host_Log =3D "/usr/local/nagios/var/hostperf.log" > Dummy_Hostname =3D "dummy" > Delete_Service_Log =3D "No" > Delete_Host_Log =3D "No" > Nagios_Lock =3D "/usr/local/nagios/var/nagios.lock" > Lock_File =3D "/var/lock/perfparse.lock" > Be_Silent =3D "no" > Do_Report =3D "no" > Accept_Odd_Chars_in_Label =3D "no" > Default_user_permissions_Policy =3D "rw" > Default_user_permissions_Host_groups =3D "rw" > > Regards > > -- > Ricardo David Martins > _______________________________________________________________________= ______________________________ > > AVISO > > Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o > confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o > destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar es= te > e-mail. Se recebeu esta mensagem por engano, por favor informe o > emissor e elimine-a imediatamente. Obrigado. > > DISCLAIMER > > This e-mail (including any attachments) may contain confidential > information for exclusive use of its recipient. If you are not the > intended recipient you must not use, distribute or copy this e-mail. > If you have received this e-mail in error please notify the sender and > delete it immediately. Thank You. > > _______________________________________________________________________= ______________________________ > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJourna= l > Use IT products in your business? Tell us what you think of them. Give = us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out = more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > Perfparse-users mailing list > Per...@li... > https://lists.sourceforge.net/lists/listinfo/perfparse-users > > --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://perfparse.sf.net/ - |
|
From: Ben C. <Be...@cl...> - 2004-10-26 10:02:06
|
Dear Users,
When the current versions are stable, we will be looking to convert the
binary table in the PP database. This will probably take our product up
to version 1.0. I need some advise from users about the best method.
The advantages of the change are:
- A range for the Warn and Crit values, rather than just a single value.
- Smaller storage space needed for same data.
- Faster access to data, bigger graphs possible.
- A scalable solution where new information can be added easily.
In order to complete this conversion, the main table
'perfdata_service_bin' will be copied to two new tables, and then
dropped. But this causes problems. In order to complete this
conversion there are three methods. I would like you to suggest which
one you consider the best. Then we will program and use the method you
choose. Please let us know.
Option 1.
---------
Copy the old table to new tables and delete old table.
Pro:
Fast.
Easy to program & test => low in bugs.
Con:
Will double size of MySQL database during conversion.
This space is very hard to recover.
Option 2.
---------
Copy all data to an external text files. Delete old table. Copy back
to new tables. Delete text files.
Pro:
Fast.
No increase in MySQL table space.
Con:
Harder to program & test => bugs possible.
Text file size is far larger than table, which is binary.
Need database size again in temporary storage for text dump of table.
Option 3.
---------
Copy over a line at a time and delete line from old table.
Pro:
No extra space needed. No increase in MySQL table space.
Easy to program & test => low in bugs.
Con:
Deleting line by line is slow. Conversion may take several weeks.
Finally, a plee to anybody who knows some MySQL and a little 'c'. Can
you spare some time to help develop and/or test a conversion program.
You time will be welcome, and you will be credited as a developer.
Kind regards,
Ben Clewett.
|
|
From: Ricardo D. M. <ric...@gm...> - 2004-10-26 13:14:20
|
> I have another idea. Check your mysql config file. Do you have 3306 as th= e tcp port for > mysqld ? Same question for the client even if I don't know if this is imp= ortant. > Is skip-networking defined ? If yes, comment it. I'm sure I have all that well configured, or else i couldn't make crossed replication in mysql. Besides, i can make queries to perfparse databases using the IPv4 socket. I can see the results on the CGI, although the error is persistent. > For information for Ricardo and those who would try to help, nagios conne= cts to mysql > thanks to a local socket (some file in /tmp/...). Perfparse connects to m= ysql thanks to > the network (socket IPv4). I don't know for the client mysql, but it prov= ides a -P > option for the port, and -h for the host name. Maybe this can help ? Basically i have all functionality going but the error just keeps appearing. Maybe when i update it Will disappear. Regards -- Ricardo David Martins ___________________________________________________________________________= __________________________ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. ___________________________________________________________________________= __________________________ |
|
From: Yves M. <yme...@li...> - 2004-10-26 13:42:51
|
> Basically i have all functionality going but the error just keeps > appearing. Maybe when i update it Will disappear. Does that mean that you have no problem to store the perf data into the d= atabase ? I thought you had the problem *before* the connection to the database. My understanding is now : you run perfparse (perfparse-log2db for 0.101.1) perfparse connects to the database successfully perfparse successfully makes all its query including those to insert data something happen before or after perfparse exit mysql writes the message in the log my understanding was : you run perfparse connection to the database fails and perfparse does nothing. Well, in that case, we should move to perfparse-devel mailing-list. You first mail was definitely not clear. Thanks for insisting :) Ben, can you reproduce that bug ? I have such messages, but I don't know yet if they come from an old versi= on or from >=3D 0.101.1. I have to test. Yves --=20 - Homepage - http://ymettier.free.fr - http://www.logicacmg.com - - GPG key - http://ymettier.free.fr/gpg.txt - - Maitretarot - http://www.nongnu.org/maitretarot/ - - Perfparse - http://perfparse.sf.net/ - |
|
From: Ricardo D. M. <ric...@gm...> - 2004-10-26 15:49:03
|
> Does that mean that you have no problem to store the perf data into the d= atabase ? Yes. > My understanding is now : > you run perfparse (perfparse-log2db for 0.101.1) > perfparse connects to the database successfully > perfparse successfully makes all its query including those to insert data > something happen before or after perfparse exit > mysql writes the message in the log This seems right. Regards --=20 Ricardo David Martins ___________________________________________________________________________= __________________________ AVISO Esta mensagem (incluindo quaisquer anexos) pode conter informa=E7=E3o confidencial para uso exclusivo do destinat=E1rio. Se n=E3o for o destinat=E1rio pretendido, n=E3o dever=E1 usar, distribuir ou copiar este e-mail. Se recebeu esta mensagem por engano, por favor informe o emissor e elimine-a imediatamente. Obrigado. DISCLAIMER This e-mail (including any attachments) may contain confidential information for exclusive use of its recipient. If you are not the intended recipient you must not use, distribute or copy this e-mail. If you have received this e-mail in error please notify the sender and delete it immediately. Thank You. ___________________________________________________________________________= __________________________ |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X