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 kados circ functions are back up to about 10 sec per transaction 12:45 kados 9977 mysql 16 0 796m 16m 2160 S 49.5 0.8 0:08.95 mysqld 12:45 kados that's from 'top' 12:57 kados hey owen 12:57 owen Hi 12:57 owen 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 kados paul: so we've got Handler_read_rnd_next | 42195455 13:13 kados in mysqladmin var 13:14 kados and according to the mysql folks (http://dev.mysql.com/doc/mysql/en/server-status-variables.html) 13:14 kados # 13:14 kados Handler_read_rnd_next 13:14 kados 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 kados also this applies: 13:15 kados # 13:15 kados Handler_read_rnd 13:15 kados 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 kados with our other server we were running mysql 4.0 13:27 kados which has query_cache 13:27 kados but now we have mysql 3.23 ... which doesn't 13:27 kados I'm wondering if that's the problem 13:27 kados (difference, I still think there are problems either with the index or the queries using indeces) 13:28 kados (or both) 13:29 kados I'll have to look into upgrading mysql on FC3 ... 13:35 kados 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 kados 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 kados I guess this is only happening with an 'issues' search 13:41 kados Gloria noticed it ... 13:42 kados (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 kados OK ... I've re-routed Roxanne to you ;-) 13:47 kados sounds like maybe the javascript isn't working for add member screen but I'm not sure 13:50 kados I was able to solve it by removving the 00 from the beginning of the card number 13:50 kados 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 kados this is weird 13:51 kados sargent, lori 13:51 kados search for that patron 13:52 kados so Gloria added her and got the same error Roxanne is having 13:52 kados 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 kados BUT ... it's happening in two branches 13:53 kados and it added both records ... 13:53 kados sargent, lori 13:53 kados 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 kados I'm upgrading tonight 13:56 kados we'll see if that imporves the perfs 13:56 paul be careful with the update 13:56 paul 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 paul ok 13:56 kados yep ;-) 14:02 kados owen: so any ideas on the addmember probs folks are having? 14:02 owen No, I'm stumped. 14:02 owen 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 hdl paul : still there ? 14:47 paul plus pour longtemps... 14:47 hdl zone 001 : quid ? 14:48 hdl 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 paul_dine (chjamp local) 14:50 paul_dine comme pour les autorités 14:51 hdl merci 16:57 rach bonjour 17:06 rach hmm win-32 list is getting spam 17:14 hdl hi rach 22:24 rach sorry about that 22:24 rach 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 sylvain 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 paul 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 sylvain 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 hdl 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 hdl Mais j'ai des problèmes : Apache n'aime pas SetEnv sur cette machine. 06:53 hdl :( 06:54 hdl Je vais essayer de faire sans. 06:54 hdl 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 JYL57 J'ai créé un p'tit script à moi qui sélectionne, puis exporte 07:14 JYL57 il fait un print OUTFILE $record->as_usmarc() 07:15 JYL57 Je me rappelle avoir lu quelque chose au sujet des tags 9