*** Alex| has joined #ingres | 00:01 | |
*** ChanServ sets mode: +o Alex| | 00:01 | |
*** Dejan has joined #ingres | 00:52 | |
*** Alex___ has joined #ingres | 01:09 | |
*** Alex| has quit IRC | 01:10 | |
*** KermitTheFragger has joined #ingres | 01:22 | |
*** Mud has joined #ingres | 01:36 | |
*** grantc has quit IRC | 02:31 | |
*** grantc has joined #ingres | 02:47 | |
Dejan | hello everybody | 02:49 |
---|---|---|
grantc | morning Dejan | 02:49 |
*** javahorn has joined #ingres | 03:44 | |
*** javahorn has left #ingres | 04:04 | |
*** rossand has joined #ingres | 04:37 | |
*** ChanServ sets mode: +o rossand | 04:37 | |
*** Alex___ has quit IRC | 04:39 | |
*** Alex| has joined #ingres | 04:39 | |
*** ChanServ sets mode: +o Alex| | 04:39 | |
*** mull has joined #ingres | 05:16 | |
*** rossand has quit IRC | 05:51 | |
*** rossand has joined #ingres | 05:52 | |
*** ChanServ sets mode: +o rossand | 05:52 | |
*** zxiiro has joined #ingres | 06:08 | |
*** ChanServ sets mode: +v zxiiro | 06:08 | |
*** rossand has quit IRC | 06:09 | |
*** rossand has joined #ingres | 06:11 | |
*** ChanServ sets mode: +o rossand | 06:11 | |
*** grantc has quit IRC | 06:15 | |
*** Mud has quit IRC | 07:00 | |
*** grantc has joined #ingres | 07:42 | |
*** Alex| has quit IRC | 07:46 | |
*** Mud has joined #ingres | 08:13 | |
*** cytrinox_ has joined #ingres | 08:45 | |
*** cytrinox has quit IRC | 08:48 | |
*** cytrinox_ is now known as cytrinox | 08:48 | |
*** bonro011 has joined #ingres | 09:00 | |
*** bonro01 has quit IRC | 09:01 | |
*** bonro01 has joined #ingres | 09:02 | |
*** bonro011 has quit IRC | 09:05 | |
*** Dejan has quit IRC | 09:41 | |
*** grantc has quit IRC | 09:56 | |
*** Mud has quit IRC | 10:32 | |
*** Mud has joined #ingres | 10:38 | |
*** clach04 has quit IRC | 10:41 | |
*** KermitTheFragger has quit IRC | 10:47 | |
*** clach04 has joined #ingres | 10:47 | |
*** bonro011 has joined #ingres | 10:53 | |
*** bonro01 has quit IRC | 10:54 | |
*** Alex| has joined #ingres | 10:58 | |
*** ChanServ sets mode: +o Alex| | 10:58 | |
*** atrofast has quit IRC | 12:26 | |
*** atrofast has joined #ingres | 12:28 | |
*** zxiiro has quit IRC | 13:00 | |
*** Mud has quit IRC | 13:08 | |
*** Alex| has quit IRC | 13:28 | |
*** mull has quit IRC | 14:46 | |
*** rossand has quit IRC | 15:22 | |
*** rossand has joined #ingres | 15:24 | |
*** ChanServ sets mode: +o rossand | 15:24 | |
*** toumi01 has joined #ingres | 16:20 | |
*** clach04 has quit IRC | 16:51 | |
*** toumi01 has left #ingres | 17:07 | |
*** toumi01 has joined #ingres | 17:15 | |
*** atrofast has quit IRC | 17:17 | |
*** rossand has quit IRC | 18:06 | |
*** rossand has joined #ingres | 18:08 | |
*** ChanServ sets mode: +o rossand | 18:08 | |
*** zxiiro has joined #ingres | 18:36 | |
*** ChanServ sets mode: +v zxiiro | 18:36 | |
*** zxiiro has quit IRC | 18:53 | |
*** zxiiro has joined #ingres | 19:00 | |
*** ChanServ sets mode: +v zxiiro | 19:00 | |
*** cytrinox has quit IRC | 19:24 | |
*** cytrinox has joined #ingres | 19:26 | |
*** zxiiro has quit IRC | 20:14 | |
*** rossand has quit IRC | 21:27 | |
*** Alex| has joined #ingres | 22:40 | |
*** ChanServ sets mode: +o Alex| | 22:40 | |
*** Alex| has quit IRC | 23:09 | |
*** grassi has joined #ingres | 23:13 | |
grassi | good morning, can i handle a detected deadlock with the usermod command? | 23:14 |
pboro | handle? | 23:14 |
grassi | meaning: cope with it. | 23:14 |
grassi | unlock it. | 23:14 |
grassi | fix it | 23:14 |
grassi | ressurect it. | 23:15 |
grassi | :-) | 23:15 |
pboro | when ingres detects a deadlock, it "handles" it immediately by "killing" the session | 23:15 |
grassi | E_DM9042_PAGE_DEADLOCK Deadlock encountered locking page 17020 for table iprotocol9 in database isystem with mode 6. Resource held by session [4198 2aaacb7dc200] Mode 6. | 23:15 |
grassi | ah | 23:15 |
grassi | ok. so no action is necessarily neccessary then? | 23:15 |
pboro | no, as long as your program is able to cope with the deadlocks, since they cause the transaction to roll back | 23:16 |
pboro | i.e. the action has to be repeated if applicable | 23:16 |
pboro | do you get a lot of deadlocks? | 23:16 |
pboro | if you do, then there might be a need to make some changes to the db and the applications using it | 23:16 |
grassi | not a lot fortunately. | 23:17 |
grassi | this morning only two users where in the system (bookkeeping), and bam->deadlock. | 23:17 |
grassi | the session wasn't killed though. | 23:17 |
pboro | yeah it just stops with an error I guess | 23:17 |
grassi | deadlock encountered at 07:52:20 | 23:17 |
grassi | the next client connection abort was 7 minutes later. | 23:18 |
grassi | ah, ok. | 23:18 |
grassi | an admin told me once, i have to run usermod dbname tablename to fix the deadlock...?` | 23:18 |
pboro | that doesn't really fix anything... it simply rebuilds the table structures, which is a good thing to do from time to time as a maintenance | 23:19 |
pboro | just like running sysmod and optimizedb from time to time | 23:19 |
grassi | ok. i don't have that scheduled yet... | 23:20 |
grassi | ok. thanks for the enlightenment, pboro. :-) | 23:22 |
pboro | no prob | 23:22 |
pboro | so you're a dba? | 23:22 |
grassi | haha... no | 23:22 |
grassi | i never had a proper training. | 23:22 |
pboro | ok :) | 23:22 |
grassi | i'm the only admin in a small company, running some citrix, linux, etc. | 23:22 |
grassi | and have to keep a look on things, running commands from time to time. | 23:23 |
grassi | and doing backup. | 23:23 |
grassi | but i know that i don't know what i'm doing ;-) | 23:23 |
pboro | ok :) | 23:23 |
grassi | i should really read that ingres bookshelf, next weekend... | 23:23 |
grassi | *g* | 23:24 |
pboro | hehe | 23:24 |
pboro | at least figure out what usermod, sysmod and optimizedb are for and how to automate them to keep your db working well | 23:24 |
grassi | automatization is my middle name... ok. i'll do that | 23:25 |
*** Alex| has joined #ingres | 23:26 | |
*** ChanServ sets mode: +o Alex| | 23:26 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!