| Vroomfondle | I understand that iiprotect holds data regarding grants, and that it's updated whenever a grant is changed. Does this imply that it's read whenever a query is issued, to find out what access rights should be applied? | 01:51 |
|---|---|---|
| grantc | hi Vroomfondle, i believe so | 02:07 |
| grantc | although the information is cached | 02:07 |
| grantc | there's a set statement you can use to see which tables get hit, for IO | 02:08 |
| grantc | if you run the same query twice you'll see the first time it will hit iiprotect | 02:09 |
| grantc | unless it's already in cache | 02:09 |
| grantc | e.g. http://pastebin.com/SmLfxfXb | 02:12 |
| Vroomfondle | cheers grantc | 02:32 |
| grantc | np | 02:32 |
| * Vroomfondle sends off an email saying "let's put driver 2.2.2 on the live web system" ... fingers crossed :) | 02:33 | |
| grantc | :) | 02:34 |
| grantc | i assume you've tested it? :) | 02:34 |
| Vroomfondle | yeah, had it on the main dev system for a little while | 02:36 |
| Vroomfondle | everything seems to work, but these days our live system and dev system are so far apart (software and hardware-wise) it's hard to tell what's going to happen on live :/ | 02:36 |
| grantc | so your fingers will be tightly crossed then :) | 02:53 |
| Vroomfondle | and my toes | 02:55 |
| Vroomfondle | we've got a "status 8" error appearing in our logs on Live lately. AFAIK that's a memory allocation error so I'm wondering if it's related to that memory boundary issue we had with 2.2.1 on dev. We'll see. | 02:57 |
| grantc | what's memory_limit set to in php.ini? | 03:10 |
| grantc | the boundary problem is more fatal, will cause php/apache to crash | 03:10 |
| Vroomfondle | 12 megs, but there's absolutely no way this page could even come close to hitting that. | 03:12 |
| Vroomfondle | It's doing two insert statements, one row each | 03:12 |
| grantc | 12? | 03:12 |
| Vroomfondle | Yes. Dunno why that was chosen. | 03:12 |
| grantc | it's a bit ... low | 03:12 |
| grantc | 5.2/3 recommend 128 | 03:13 |
| Vroomfondle | yeah. Doesn't seem to have been much of an issue thus far though. This page has been around for a while. | 03:13 |
| Vroomfondle | that said we were on PHP4 till last Sept | 03:13 |
| grantc | http://svn.php.net/viewvc/php/php-src/trunk/php.ini-production?view=markup line 391 | 03:14 |
| grantc | the new memory alignment code uses padding which = more memory | 03:15 |
| grantc | but that should not be the case with inserts | 03:15 |
| Vroomfondle | this is still using driver 2.0.2 (errors are on our live system - dev works fine) | 03:16 |
| Vroomfondle | I tell a lie | 03:17 |
| Vroomfondle | well... hang on | 03:18 |
| Vroomfondle | argh, I hate our systems | 03:18 |
| Vroomfondle | yes, I do tell a lie. Our limit is actually 128MB now. Which is odd because I am certain that it was 12MB and I'm pretty sure if I asked my boss he'd swear blind that we've got it set to 12MB. | 03:19 |
| Vroomfondle | so I can only presume that it's gotten overwritten in a PHP upgrade and no-one's noticed. | 03:19 |
| Vroomfondle | yep, dev's still set to 12MB. What fun. | 03:19 |
| Vroomfondle | Anyway, that rules that out. Memory limit is 128 but we're still seeing status 8 errors. | 03:20 |
| *** cytrinox_ has joined #ingres | 04:23 | |
| *** cytrinox has quit IRC | 04:23 | |
| *** cytrinox_ is now known as cytrinox | 04:23 | |
| *** atrofast has joined #ingres | 04:39 | |
| *** atrofast has quit IRC | 04:45 | |
| *** atrofast has joined #ingres | 04:47 | |
| *** cthibert has joined #ingres | 05:00 | |
| grantc | Vroomfondle, if you can generate a test case I'll take a poke | 05:16 |
| *** mull has joined #ingres | 05:19 | |
| *** zxiiro has quit IRC | 05:36 | |
| Vroomfondle | grantc: I'll see what I can do when I get a chance, but it'll be tricky because the problem only occurs with the live server and I have to be *very* careful what I do on that server at this time of year | 05:38 |
| grantc | understood :) | 05:38 |
| *** rossand has joined #ingres | 06:01 | |
| *** ChanServ sets mode: +o rossand | 06:01 | |
| *** zxiiro has joined #ingres | 06:19 | |
| *** ChanServ sets mode: +v zxiiro | 06:19 | |
| *** mull has quit IRC | 06:38 | |
| *** mull has joined #ingres | 07:21 | |
| *** DerMeister has joined #ingres | 09:15 | |
| *** DerMeister has quit IRC | 09:40 | |
| *** grantc has quit IRC | 09:45 | |
| *** DerMeister has joined #ingres | 09:46 | |
| *** toumi01 has left #ingres | 11:56 | |
| *** toumi01 has joined #ingres | 12:48 | |
| *** Mud has quit IRC | 13:42 | |
| *** atrofast has quit IRC | 13:54 | |
| *** zxiiro has quit IRC | 14:05 | |
| *** cthibert has left #ingres | 14:16 | |
| *** DerMeister has quit IRC | 14:20 | |
| *** toumi01 has left #ingres | 14:26 | |
| *** toumi01 has joined #ingres | 14:28 | |
| *** toumi01 has left #ingres | 14:51 | |
| *** zxiiro has joined #ingres | 14:58 | |
| *** ChanServ sets mode: +v zxiiro | 14:58 | |
| *** mull has quit IRC | 15:45 | |
| *** mull has joined #ingres | 16:36 | |
| *** toumi01 has joined #ingres | 17:16 | |
| *** toumi01 has quit IRC | 17:19 | |
| *** toumi01 has joined #ingres | 17:40 | |
| *** cytrinox_ has joined #ingres | 19:21 | |
| *** cytrinox has quit IRC | 19:24 | |
| *** cytrinox_ is now known as cytrinox | 19:24 | |
| *** rossand has quit IRC | 19:44 | |
| *** mull has quit IRC | 20:06 | |
| *** toumi01 has quit IRC | 20:57 | |
| *** toumi01 has joined #ingres | 21:18 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!