*** 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!