*** dyki has joined #ingres | 01:39 | |
*** FrankW has quit IRC | 02:11 | |
*** FrankW has joined #ingres | 02:12 | |
*** Alex| is now known as Alex|off | 02:40 | |
Vroomfondle | is there a list of ingres error codes anywhere? | 04:08 |
---|---|---|
Vroomfondle | a SELECT via the PHP driver is generating errno 3502, but there's no accompanying message as far as we can tell | 04:09 |
Vroomfondle | i.e. ingres_error returns null and there's nothing in the PHP error log | 04:09 |
pboro | just a sec | 04:09 |
pboro | it's somewhere in the manuals but cant recall, still searching :) | 04:10 |
pboro | http://docs.ingres.com/Ingres/9.2/Message%20Guide/messages.htm | 04:11 |
pboro | that's the one I've seen | 04:11 |
pboro | no 3502 in it :( | 04:11 |
Vroomfondle | hrm | 04:11 |
Vroomfondle | grantc: is this a PHP-specific error code perhaps? | 04:11 |
Vroomfondle | ah, hang on - I'll try sqlstate codes instead | 04:12 |
pboro | damn I hate docs.ingres.com, it's so slow | 04:12 |
pboro | E_US0DAE_3502 | 04:12 |
pboro | SQLCODE: | 04:12 |
pboro | SS42503_INSUF_PRIV | 04:12 |
pboro | Error text: | 04:12 |
pboro | %2c on table %0c: no GRANT or GRANT compatible permit exists. | 04:12 |
pboro | that's best I could find | 04:12 |
pboro | the url I pasted only contained error messages for ADF, the one I pasted was found from http://docs.ingres.com/Ingres/9.2/Message%20Guide/errorsUSF.htm | 04:13 |
*** cthibert has joined #ingres | 04:14 | |
Vroomfondle | yeah, that fits with the sqlstate too | 04:17 |
Vroomfondle | for some reason GRANt errors aren't appearing in our main PHP error log. Any idea why that might be, grantc? They used to appear, along with SQL syntax errors etc. (which are still appearing fine) | 04:18 |
Vroomfondle | could we have somehow accidentally set some sort of error-level threshold or something... | 04:19 |
Vroomfondle | (we did recently upgrade to PHP5 - I vaguely remember that there are differences in the default error level between 4 and 5 - perhaps that's it?) | 04:19 |
*** grantc has joined #ingres | 04:21 | |
*** ChanServ sets mode: +o grantc | 04:21 | |
Vroomfondle | oh poo, he wasn't here ;) | 04:22 |
Vroomfondle | actually we have error_reporting set to E_ALL so can't be that | 04:22 |
Vroomfondle | grantc: GRANT errors aren't appearing in our main PHP error log any more, possible due to upgrading to PHP5 (judging by the timing). Other errors e.g. SQL syntax errors are still appearing. Any idea why? | 04:23 |
grantc | hi Vroomfondle - were you using the updated driver with your php 4 installation? | 04:31 |
*** Gerhard has joined #ingres | 05:19 | |
*** Dejan has joined #ingres | 05:41 | |
Dejan | hi everybody | 05:47 |
Dejan | erm... 10.0.0-108 install script fails on Fedora 11 | 05:48 |
Dejan | (tar based installer) | 05:48 |
bonsaikitten | how does it fail? :) | 05:49 |
Vroomfondle | grantc: it wasn't entirely up-to-date, no | 05:51 |
Vroomfondle | so is this something which occurs with later drivers? | 05:51 |
Vroomfondle | and if so is there any way we can configure it to show those GRANT errors? They're quite handy | 05:52 |
*** rossand has joined #ingres | 05:59 | |
*** ChanServ sets mode: +o rossand | 05:59 | |
Dejan | GRANTC errors | 06:04 |
Dejan | roflz | 06:04 |
*** atrofast has joined #ingres | 06:08 | |
grantc | you can use the ingres_error() and ingres_errno() functions | 06:19 |
grantc | i am not aware of any issues with any SQL statements (other than the one's the driver does not support) | 06:20 |
Vroomfondle | ingres_error() isn't working. It returns null when there's a GRANT error. | 06:23 |
Vroomfondle | well.. or blank, I haven't checked. Either way there's no string. | 06:24 |
grantc | i'll need a test case to verify the problem as "it works for me (TM)".... | 06:31 |
grantc | either that or an api log | 06:31 |
Dejan | i see someone is working on pdo-ingres | 06:36 |
Dejan | do you guys know how far is that project from usable? | 06:36 |
grantc | the last i heard it was 80% | 06:38 |
grantc | i've asked to see the code but have yet to receive a copy | 06:38 |
Dejan | omg, that is brilliant | 06:38 |
grantc | hmm i find it's normally that the last 20% is the real challenge ... | 06:39 |
Dejan | I am currently working on DAM-NL protocol layer in D | 06:43 |
Dejan | it goes slowly | 06:43 |
Dejan | actually, i am doing DAM-TL too, in parallel | 06:43 |
Dejan | luckilly, i have lots of code that can help me in JDBC and .NET connectors | 06:44 |
Dejan | but it goes slow | 06:45 |
Dejan | because i have no spare time | 06:46 |
*** cthibert has left #ingres | 07:16 | |
DarylM | Ingres.pastebin.com down because of http://www.pcmag.com/article2/0,2817,2353820,00.asp ? | 07:24 |
*** Hop has joined #ingres | 07:24 | |
*** zxiiro has quit IRC | 07:30 | |
grantc | yup | 07:30 |
*** zxiiro has joined #ingres | 07:31 | |
*** irc.freenode.net sets mode: +v zxiiro | 07:31 | |
grantc | i guess the url is regarding the posting of phished info? | 07:31 |
*** toumi01 has joined #ingres | 07:34 | |
*** cthibert has joined #ingres | 07:49 | |
*** Gerhard has quit IRC | 08:14 | |
*** DarylM has quit IRC | 08:14 | |
*** NoeJeko has quit IRC | 08:14 | |
*** Vroomfondle has quit IRC | 08:14 | |
*** Vroomfon1le has joined #ingres | 08:14 | |
*** NoeJeko has joined #ingres | 08:14 | |
*** Gerhard has joined #ingres | 08:15 | |
*** zxiiro has quit IRC | 08:17 | |
*** zxiiro has joined #ingres | 08:17 | |
*** irc.freenode.net sets mode: +v zxiiro | 08:17 | |
*** zxiiro has quit IRC | 08:23 | |
*** zxiiro has joined #ingres | 08:23 | |
*** irc.freenode.net sets mode: +v zxiiro | 08:23 | |
*** Gerhard has quit IRC | 08:25 | |
Dejan | how much a license for ingres 9.3 costs? | 08:43 |
Dejan | :D | 08:43 |
Dejan | does anyone know? | 08:44 |
grantc | either $7k or $8k per socket ... | 08:44 |
grantc | or something there abouts | 08:44 |
grantc | $7,995 - http://ingres.com/tco | 08:45 |
pboro | it's per occupied socket, empty sockets don't count afaik | 08:46 |
grantc | good point | 08:46 |
pboro | so just buy a server with a lot of core ;) | 08:46 |
grantc | yup | 08:46 |
pboro | that's what I did! | 08:46 |
Dejan | what about virtualised environment? | 08:46 |
pboro | with one server we went from 4 cpus (single cores) to 1 cpu (4 cores) | 08:47 |
Dejan | i am effectively using 1 CPU with lots of cores | 08:47 |
pboro | I asked about that and I was answerred that it has to be fair game so that you may only assign the virtual machine one cpu at most from the host | 08:48 |
Dejan | hold on, it is not actually a license, it is the "annual support" ... | 08:48 |
grantc | so if you have a dual cuad core box you can assign up to "4 cpus" in ESX (for example) and still only pay for a single CPU? | 08:49 |
grantc | Dejan: yup there is no license cost just support | 08:49 |
pboro | grantc, no no, you may only assign up to the cores of a single cpu | 08:50 |
Dejan | i will try to influence buying the support | 08:50 |
Dejan | so we can support the project | 08:50 |
pboro | Dejan, the support service is great, there's some amazing ppl on the team :) | 08:50 |
Dejan | ah noes, people like grantc? | 08:50 |
* grantc blushes ;) | 08:50 | |
Dejan | we are dooomeddddd | 08:50 |
Dejan | :))))))))) | 08:51 |
pboro | at least in the specialist team ;) | 08:51 |
grantc | i used to work in that team :) | 08:51 |
grantc | many moons ago... | 08:51 |
* Dejan likes Ingres | 08:51 | |
pboro | grantc, and now you work as a PHP slave! ;) | 08:51 |
Dejan | hell guys, you did not see my Ingres T-Shirt yet | 08:51 |
Dejan | :( | 08:51 |
pboro | well, at least somewhat | 08:51 |
Dejan | i must transfer picture from my phone, and put somewhere :D | 08:52 |
grantc | 50% php slave, 25% ruby slave and 25% rails... | 08:52 |
Dejan | ruby, eek | 08:52 |
grantc | it's different :) | 08:52 |
* Dejan plans to finish DAM-TL layer in his D-Ingres project by the end of October | 08:53 | |
Dejan | and hopefully in November DAM-ML | 08:53 |
pboro | DAMN layer! | 08:53 |
Dejan | :))))))) | 08:53 |
grantc | If you want some hosting space for the code or wiki space let me know | 08:54 |
pboro | okay, 10 hours at work, time to go home | 08:54 |
grantc | gnite | 08:54 |
Dejan | grantc: no need, i have my own svn and git | 08:54 |
Dejan | but thanks a lot | 08:54 |
grantc | ok - but I guess you will do a write up in the community wiki? | 08:54 |
grantc | even if it's just links to your own stuff | 08:55 |
Dejan | i will do that once i can actually do "SELECT * FROM some_table" and get result in D, using my DAM classes | 08:55 |
Dejan | :) | 08:56 |
grantc | ah :) | 08:56 |
Dejan | I actually think I will have that in 2 months | 08:56 |
Dejan | judging how slow i develop this | 08:56 |
Dejan | :D | 08:57 |
*** Dejan has quit IRC | 10:03 | |
Vroomfon1le | is there a way, in isql, to view the total number of locks which are currently open on a given table within the current transaction/session? | 10:05 |
*** grantc has quit IRC | 10:09 | |
*** atrofast has quit IRC | 10:13 | |
*** atrofast has joined #ingres | 10:16 | |
*** zxiiro has quit IRC | 11:40 | |
*** zxiiro has joined #ingres | 11:40 | |
*** irc.freenode.net sets mode: +v zxiiro | 11:40 | |
*** zxiiro has quit IRC | 11:42 | |
*** zxiiro has joined #ingres | 11:44 | |
*** ChanServ sets mode: +v zxiiro | 11:44 | |
*** bonsaikitten is now known as AmazingPudding | 12:03 | |
*** cthibert has left #ingres | 13:23 | |
*** Hop has quit IRC | 16:33 | |
*** rossand has quit IRC | 16:44 | |
*** rossand has joined #ingres | 18:58 | |
*** ChanServ sets mode: +o rossand | 18:58 | |
*** rossand has quit IRC | 20:17 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!