| *** rossand has joined #ingres | 03:33 | |
| *** ChanServ sets mode: +o rossand | 03:33 | |
| *** rossand has quit IRC | 04:16 | |
| *** Alex|off is now known as Alex| | 05:36 | |
| *** Alex| is now known as Alex|off | 06:13 | |
| *** withdefault has joined #ingres | 07:16 | |
| *** ChanServ sets mode: +o withdefault | 07:16 | |
| *** ChanServ sets mode: +o grantc | 08:00 | |
| *** grantc is now known as grantc_offline | 09:29 | |
| *** grantc_offline is now known as grantc | 09:32 | |
| *** Gerhard has joined #ingres | 11:42 | |
| *** rossand has joined #ingres | 13:03 | |
| *** ChanServ sets mode: +o rossand | 13:03 | |
| atrofast | grantc: Did you get my messages on here last night? | 13:04 |
|---|---|---|
| grantc | atrofast, err | 13:07 |
| * grantc goes to check the irc logs | 13:08 | |
| atrofast | Probably around 9 pm your time | 13:08 |
| grantc | i am guessing the problem is coming from dmt_create_temp | 13:09 |
| grantc | the other two are for normal create table and alter table | 13:09 |
| grantc | that function calls adc_lenchk() which for some reason is failing | 13:12 |
| atrofast | That's all I could really track down, E_QE002E is never actually used in code as far as I can tell but the comment on qeu_dbu says it's a possible one but is never actually used as far as I can tell | 13:12 |
| grantc | i would guess that QEF calls through to DMF which in turn executes dmt_create_temp | 13:13 |
| atrofast | Ah I see so E_QE002E is never actually used, it's E_DM0009 | 13:14 |
| grantc | from what i can see the error is coming from the server, perhaps something i am doing is causing this problem to occur? scrollable cursors? | 13:15 |
| grantc | normally the error number i.e is the same | 13:15 |
| grantc | ie 00009 | 13:15 |
| atrofast | you got the error number 0x00001204 in your logs, which is E_US1204 right? And it's never used, but it is mapped to E_DM0009 in Qef_err_map | 13:16 |
| grantc | it's scrollable cursors causing the problem - set ingres.scrollable to 0 and it will work .. | 13:16 |
| atrofast | But I have | 13:16 |
| atrofast | My code has ini_set('ingres.scrollable', 0); | 13:17 |
| atrofast | ini_set('ingres.scrollable', false); | 13:17 |
| atrofast | I had to do that because it didn't work with LOBs :) | 13:17 |
| grantc | can you dump "ini_get('ingres.scrollable')" before the fetch? | 13:18 |
| atrofast | Alright will do | 13:18 |
| grantc | http://ingres.pastebin.com/f55e431a2 - my test case | 13:19 |
| atrofast | ini_get('ingres.scrollable') returns nothing | 13:34 |
| atrofast | Not even 1 or 0 :) | 13:35 |
| atrofast | What if I set that in php.ini? | 13:37 |
| atrofast | Okay changed it to ini_set('ingres.scrollable', 0); instead and now it shows zero but I still get a blah isn't a valid resource error | 13:43 |
| *** DarylM has joined #ingres | 14:20 | |
| grantc | it's possible that you are hitting another problem but without knowing what error message/code i cannot say | 14:31 |
| atrofast | Alright want an OpenAPI trace log? :) | 14:43 |
| *** Alex|off is now known as Alex| | 14:47 | |
| *** zxiiro has quit IRC | 14:55 | |
| *** mull has joined #ingres | 14:57 | |
| *** Gerhard has left #ingres | 15:02 | |
| grantc | atrofast, sure | 15:10 |
| atrofast | Okay sent | 15:15 |
| grantc | atrofast, I am going to log an issue in SD for the E_DM0009 problem | 15:24 |
| grantc | will put you as the client | 15:24 |
| atrofast | Alright, so it seems like it's an Ingres DBMS bug? | 15:25 |
| grantc | it works without scrollable cursors and the error comes from Ingres not from OpenAPI | 15:25 |
| *** atrofast has quit IRC | 15:26 | |
| *** rossand has quit IRC | 15:28 | |
| *** atrofast has joined #ingres | 15:29 | |
| *** bonro011 has left #ingres | 15:35 | |
| *** bonro01 has joined #ingres | 15:35 | |
| *** rossand has joined #ingres | 15:37 | |
| *** ChanServ sets mode: +o rossand | 15:37 | |
| *** rossand has quit IRC | 15:44 | |
| *** zxiiro has joined #ingres | 16:24 | |
| *** ChanServ sets mode: +v zxiiro | 16:24 | |
| *** rossand has joined #ingres | 16:27 | |
| *** ChanServ sets mode: +o rossand | 16:27 | |
| *** DerMeister has joined #ingres | 16:34 | |
| *** Alex| is now known as Alex|off | 17:55 | |
| *** Alex|off is now known as Alex| | 18:09 | |
| *** atrofast has quit IRC | 18:54 | |
| *** atrofast has joined #ingres | 18:57 | |
| *** withdefault has quit IRC | 18:58 | |
| *** Alex| is now known as Alex|off | 19:32 | |
| *** Alex|off is now known as Alex| | 19:32 | |
| *** Alex| is now known as Alex|off | 19:37 | |
| *** Alex|off is now known as Alex| | 19:39 | |
| *** Alex| is now known as Alex|off | 19:42 | |
| *** Alex|off is now known as Alex| | 19:44 | |
| *** Alex| is now known as Alex|off | 19:47 | |
| *** Alex|off is now known as Alex| | 21:15 | |
| *** hunter has joined #ingres | 21:24 | |
| *** Alex| is now known as Alex|off | 21:25 | |
| *** SlimeyPete has quit IRC | 21:51 | |
| *** SlimeyPete has joined #ingres | 21:52 | |
| atrofast | grantc: Found another bug in newer builds of Ingres regarding tables spanning more than one page | 21:54 |
| *** DerMeister has quit IRC | 22:03 | |
| *** grantc is now known as grantc_offline | 22:08 | |
| *** mull has quit IRC | 23:18 | |
| *** DarylM has quit IRC | 23:44 | |
| *** perftuning has joined #ingres | 23:47 | |
| *** hunter has left #ingres | 23:55 | |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!