IRC log for #koha, 2005-03-16

← 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

koha1