| Time |
S |
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[…]s-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 |
