*** stliu has joined #ingres | 03:19 | |
*** stliu has quit IRC | 03:57 | |
*** cytrinox_ has joined #ingres | 05:22 | |
*** cytrinox has quit IRC | 05:23 | |
*** cytrinox_ is now known as cytrinox | 05:23 | |
*** pboro has quit IRC | 05:35 | |
*** pboro has joined #ingres | 05:44 | |
*** stliu has joined #ingres | 05:54 | |
*** Alex| has joined #ingres | 06:19 | |
*** ChanServ sets mode: +o Alex| | 06:19 | |
*** Alex| has quit IRC | 06:52 | |
*** Alex| has joined #ingres | 07:15 | |
*** ChanServ sets mode: +o Alex| | 07:15 | |
*** Dejan has joined #ingres | 09:13 | |
*** Dejan has quit IRC | 10:10 | |
*** stliu has quit IRC | 10:23 | |
*** Dejan has joined #ingres | 10:31 | |
*** Mud has joined #ingres | 11:30 | |
*** Mud has quit IRC | 12:44 | |
*** Mud has joined #ingres | 12:50 | |
*** Mud is now known as Guest28016 | 12:51 | |
*** stliu has joined #ingres | 12:52 | |
Alex| | anyone around who could help me with isolation levels in Ingres? | 13:58 |
---|---|---|
Dejan | shoot, maybe we can help | 14:09 |
Alex| | the customer has readlock=nolock and level=read committed at system level | 14:22 |
Alex| | sql terminal 1 does an insert on a table but no commit, terminal 2 does a select on that table and sees the row of terminal 1... why? | 14:23 |
Dejan | Alex|, could be that TM sets its own isolation level | 14:42 |
Dejan | ? | 14:42 |
Alex| | I also tried it after setting it with set session isolation level read committed - and they have an application via odbc that shows the same effect | 14:43 |
Alex| | so to me it looks like this is just what Ingres does... but the fact that the level says read COMMITTED doesn't appeal here | 14:44 |
Dejan | i think TM changes the isolation for its session | 14:45 |
Dejan | that is the only explanation i can think of | 14:45 |
Dejan | :/ | 14:45 |
Alex| | as I said, the same happens when using their application that is connected via odbc | 14:45 |
Dejan | i am out of ideas | 15:02 |
Dejan | :/ | 15:02 |
*** stliu has quit IRC | 15:21 | |
*** Alex| has quit IRC | 15:47 | |
*** Alex| has joined #ingres | 16:04 | |
*** ChanServ sets mode: +o Alex| | 16:04 | |
*** Alex| has quit IRC | 16:21 | |
*** Guest28016 has quit IRC | 16:46 | |
*** Mud has joined #ingres | 16:50 | |
*** Mud is now known as Guest34255 | 16:51 | |
*** clach04 has quit IRC | 17:38 | |
*** clach04 has joined #ingres | 17:47 | |
*** Dejan has quit IRC | 18:10 | |
*** Alex| has joined #ingres | 20:14 | |
*** ChanServ sets mode: +o Alex| | 20:14 | |
*** Guest34255 has quit IRC | 20:44 | |
*** Mud has joined #ingres | 20:50 | |
*** Mud is now known as Guest87590 | 20:51 | |
*** Guest87590 has quit IRC | 21:13 | |
*** Alex| has quit IRC | 21:41 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!