← Previous day | Today | Next day → | Search | Index
All times shown according to UTC.
| Time | Nick | Message |
|---|---|---|
| 12:43 | kados | paul still around? |
| 12:43 | paul | yes (4PM in France) |
| 12:43 | kados | our load is pretty high compared to 2.0 |
| 12:44 | circ functions are back up to about 10 sec per transaction | |
| 12:45 | 9977 mysql 16 0 796m 16m 2160 S 49.5 0.8 0:08.95 mysqld | |
| 12:45 | that's from 'top' | |
| 12:57 | hey owen | |
| 12:57 | owen | Hi |
| 12:57 | Weird problem with the reserves. | |
| 12:57 | kados | yea ... any ideas? |
| 13:00 | owen | I had forgotten an instance of 'waiting' that should have been changed to 'consigned' |
| 13:00 | kados | the server load? yay! ;-) |
| 13:05 | owen | Is the server load problem different from before? |
| 13:07 | kados | maybe ... I'm not quite sure yet |
| 13:13 | paul: so we've got Handler_read_rnd_next | 42195455 | |
| 13:13 | in mysqladmin var | |
| 13:14 | and according to the mysql folks (http://dev.mysql.com/doc/mysql[…]s-variables.html) | |
| 13:14 | # | |
| 13:14 | Handler_read_rnd_next | |
| 13:14 | The number of requests to read the next row in the data file. This is high if you are doing a lot of table scans. Generally this suggests that your tables are not properly indexed or that your queries are not written to take advantage of the indexes you have. | |
| 13:15 | also this applies: | |
| 13:15 | # | |
| 13:15 | Handler_read_rnd | |
| 13:15 | The number of requests to read a row based on a fixed position. This is high if you are doing a lot of queries that require sorting of the result. You probably have a lot of queries that require MySQL to scan whole tables or you have joins that don't use keys properly. | |
| 13:20 | owen | Hmmm... an error from memberentry.pl... |
| 13:23 | hdl | paul: coming back soon |
| 13:23 | paul | ok (webcam hs de mon coté) |
| 13:26 | kados | I may have found another perf prob |
| 13:27 | with our other server we were running mysql 4.0 | |
| 13:27 | which has query_cache | |
| 13:27 | but now we have mysql 3.23 ... which doesn't | |
| 13:27 | I'm wondering if that's the problem | |
| 13:27 | (difference, I still think there are problems either with the index or the queries using indeces) | |
| 13:28 | (or both) | |
| 13:29 | I'll have to look into upgrading mysql on FC3 ... | |
| 13:35 | owen have you tried adding a new patron? | |
| 13:35 | owen | No...problem? |
| 13:35 | kados | looks like there might be |
| 13:37 | owen | I just tried it and it worked for me |
| 13:39 | kados | I guess the problem is happening when you're searching for a patron |
| 13:40 | it doesn't give you the option to add a new patron if your search results in nothing ... it just seems to reload the page | |
| 13:41 | I guess this is only happening with an 'issues' search | |
| 13:41 | Gloria noticed it ... | |
| 13:42 | (did our other system allow that from an issues search?) | |
| 13:42 | owen | Looks like there's a broken link |
| 13:43 | kados | also Roxanne in Coolville is having problems with certain fields ... I'm going to call her |
| 13:46 | OK ... I've re-routed Roxanne to you ;-) | |
| 13:47 | sounds like maybe the javascript isn't working for add member screen but I'm not sure | |
| 13:50 | I was able to solve it by removving the 00 from the beginning of the card number | |
| 13:50 | when adding a patron ... but I'm not sure this is the right way to do it | |
| 13:51 | owen | You made a change to the record in the database? |
| 13:51 | kados | no |
| 13:51 | this is weird | |
| 13:51 | sargent, lori | |
| 13:51 | search for that patron | |
| 13:52 | so Gloria added her and got the same error Roxanne is having | |
| 13:52 | invalid barcode number and invalid address field | |
| 13:52 | owen | I've added two member records now with no problem. |
| 13:52 | kados | then I tried manually typing the card number in (without the leading 0s) |
| 13:52 | owen | I wonder if it's a barcode scanner problem? |
| 13:52 | kados | and it added them |
| 13:53 | BUT ... it's happening in two branches | |
| 13:53 | and it added both records ... | |
| 13:53 | sargent, lori | |
| 13:53 | that's the patron | |
| 13:56 | paul | kados : mysql 3.23 is really old. Completly outdated in fact... I use 4.0.x, that is not the last version, but a better one anyway ! |
| 13:56 | kados | right |
| 13:56 | I'm upgrading tonight | |
| 13:56 | we'll see if that imporves the perfs | |
| 13:56 | paul | be careful with the update |
| 13:56 | the BINARY sql files will probably be invalid | |
| 13:56 | kados | yea ... I'm going to mysqldump the database ... then import it |
| 13:56 | paul | so you need a mysqldump |
| 13:56 | ok | |
| 13:56 | kados | yep ;-) |
| 14:02 | owen: so any ideas on the addmember probs folks are having? | |
| 14:02 | owen | No, I'm stumped. |
| 14:02 | I can't reproduce the problem. | |
| 14:02 | kados | hmmm, you're scanning the barcodes in? |
| 14:04 | owen | Yes |
| 14:16 | hdl | paul : back |
| 14:16 | paul | re, sauf que tjs pas de webcam, et je veux pas rebooter. |
| 14:25 | hdl | ok ;) |
| 14:47 | paul : still there ? | |
| 14:47 | paul | plus pour longtemps... |
| 14:47 | hdl | zone 001 : quid ? |
| 14:48 | C'est pour le $0. | |
| 14:48 | paul | c'et quoi la question ? |
| 14:48 | hdl | Je le trouve par le bibid ou bien par autre chose. |
| 14:49 | paul | il doit y avoir un champ 001 |
| 14:49 | hdl | ok. |
| 14:49 | paul | enfin, pas à l'EMN, mais c'est possible qu'il y en ait un ;-) |
| 14:50 | hdl | et sinon, le bibid ne fait pas office ? |
| 14:50 | paul_dine | mmm... non, tu mets le bibid dans le $9 |
| 14:50 | (chjamp local) | |
| 14:50 | comme pour les autorités | |
| 14:51 | hdl | merci |
| 16:57 | rach | bonjour |
| 17:06 | hmm win-32 list is getting spam | |
| 17:14 | hdl | hi rach |
| 22:24 | rach | sorry about that |
| 22:24 | si triped over the power cable | |
| 22:33 | kados | :-) |
| 05:22 | sylvain | hi all |
| 05:43 | hdl | hi |
| 05:53 | sylvain | salut hdl |
| 06:24 | paul_dine | coucou sylvain &hdl |
| 06:24 | paul | (je ne suis plus en train de diner ;-) ) |
| 06:25 | sylvain | :) |
| 06:26 | j'sais pas si tu as vu sur la ML paul mais pascale nalon a aussi un pb avec les dates d'inscription ... | |
| 06:26 | paul | oui, j'ai vu |
| 06:26 | va falloir que je réponde, mais je ne sais pas trop quoi répondre... | |
| 06:27 | sylvain | j'ai le mm pb |
| 06:27 | j'essaierai de voir tout à l'heure un peu | |
| 06:48 | hdl | Paul ? |
| 06:50 | paul | yep |
| 06:50 | hdl | a priori problème dns résolu. |
| 06:51 | Pour se voir, quand ? | |
| 06:51 | paul | ok pour le dns. J'appelle le comptable dans quelques minutes. |
| 06:53 | hdl | Pour demo.koha-fr.org, j'ai fait des modifs sur le serveur hier... Installation des bases et de la version CVS ainsi que de 2.2.1 |
| 06:53 | Mais j'ai des problèmes : Apache n'aime pas SetEnv sur cette machine. | |
| 06:53 | :( | |
| 06:54 | Je vais essayer de faire sans. | |
| 06:54 | Mais je préfère le faire le soir la veillée. Lorsque la france dort. | |
| 07:12 | JYL57 | Hello paul, hdl !? J'ai une p'tite question |
| 07:13 | paul | hello |
| 07:13 | JYL57 | Si j'exporte des exemplaires, je peux sans autre forme les réimporter ensuite ?! |
| 07:13 | J'ai créé un p'tit script à moi qui sélectionne, puis exporte | |
| 07:14 | il fait un print OUTFILE $record->as_usmarc() | |
| 07:15 | Je me rappelle avoir lu quelque chose au sujet des tags 9 |
← Previous day | Today | Next day → | Search | Index