*** grantc has joined #ingres | 00:54 | |
*** ChanServ sets mode: +o grantc | 00:54 | |
grantc | @name ii_log | 00:54 |
---|---|---|
ii_log` | grantc: Error: "name" is not a valid command. | 00:54 |
grantc | @nick ii_log | 00:54 |
*** ii_log` is now known as ii_log | 00:54 | |
*** dyki has joined #ingres | 01:13 | |
dyki | morning all | 01:13 |
grantc | morning | 01:15 |
*** Deyan has joined #ingres | 01:30 | |
Deyan | hello guys | 01:30 |
grantc | hi | 01:30 |
Deyan | grantc: in which case ingres_close() will block forever? | 01:31 |
Deyan | any ideas? | 01:31 |
Deyan | i have a case where ingres_close() never returns... | 01:31 |
grantc | it should never block | 01:31 |
grantc | unless you have an ingres_query() statement hanging due to a locking problem | 01:31 |
Deyan | khm... | 01:33 |
Deyan | but in that case the script should not reach the line where i call ingres_close() right? | 01:34 |
Deyan | it should still be there where i called ingres_query() ? | 01:35 |
grantc | yup | 01:35 |
grantc | i would assume so at least | 01:35 |
Deyan | me too | 01:36 |
grantc | is it something you can reproduce on demand? | 01:36 |
Deyan | that is why i added a simple echo before ingres_close and after | 01:36 |
Deyan | it prints the one before | 01:36 |
Deyan | but not after | 01:36 |
Deyan | so it seems to me that ingres_close() blocks | 01:36 |
grantc | CPU usage? | 01:37 |
Deyan | no, it is not something i can reproduce easily :( | 01:38 |
grantc | the next time it happens check to see if you have any lock waits in the server | 01:39 |
grantc | the only thing i can think of that it might be is the clean up code going into an infinite loop | 01:40 |
grantc | but i would expect to see excessive CPU usage | 01:40 |
Deyan | i think you are right | 01:40 |
Deyan | so... if there are some locks, ingres_close() blocks | 01:40 |
Deyan | i restarted server | 01:40 |
Deyan | and ran script again | 01:41 |
Deyan | and now everything works | 01:41 |
grantc | the driver performs a rollback on closure | 01:41 |
grantc | so no locks should stop it | 01:41 |
grantc | before that takes place each statement is closed (under duress if needed) | 01:42 |
grantc | however under ingres_close() the function free_ii_link_result_list() iterates over the open statements and it's possible that goes into the inifinte loop | 01:43 |
grantc | _free_ii_link_result_list() not free_ii_link_result_list() | 01:43 |
Deyan | hold on | 01:43 |
Deyan | i will paste 3 lines | 01:43 |
Deyan | echo "[DEBUG] before\n"; | 01:43 |
Deyan | ingres_close($dbcTarget); | 01:43 |
Deyan | echo "[DEBUG] after\n"; | 01:44 |
Deyan | the first one executes | 01:44 |
Deyan | but second echo does not | 01:44 |
Deyan | so i am quite sure ingres_close() does not return | 01:44 |
Deyan | for some reasons | 01:44 |
grantc | i have an english question or rather how would you interpret the following statement: The number is between 0 and 10 | 03:04 |
grantc | does between imply 0 and 10 are included or not? | 03:05 |
Deyan | good question | 03:09 |
dyki | 10 is included 0 is not | 03:09 |
dyki | ? | 03:10 |
Deyan | according to my colleagues it means that 0 and 10 are included in the range | 03:10 |
pboro | grantc, you can't know without asking :D | 03:11 |
grantc | hmm ... where's my copy of OED when i need it | 03:11 |
grantc | £205+VAT per year for the OED :( | 03:13 |
grantc | i guess between could be inclusive... since a bridge between two cliffs would include the cliffs... | 03:14 |
grantc | but the space between two people would not include the people | 03:15 |
grantc | pboro, sorry to cause any doubts :P | 03:16 |
pboro | ahaha :) | 03:18 |
Deyan | ingres@srv021:~> date | 03:20 |
Deyan | Tue Jul 21 11:24:23 BST 2009 | 03:20 |
Deyan | SRV021 ::[53786 , 4275 , 0000000000000001, scdinit.c:3757 ]: Tue J ul 21 03:22:37 2009 E_SC0129_SERVER_UP Ingres Release II 9.3.0 (a64.lnx/140)NPTL Server -- Normal Sta rtup. | 03:20 |
Deyan | check the system date | 03:20 |
Deyan | and ingres date | 03:20 |
Deyan | why i have that difference?? | 03:21 |
Deyan | any ideas? | 03:21 |
grantc | Deyan, two things - can you post any output you have to http://ingres.pastebin.com and paste the link here... | 03:21 |
grantc | second thing your II_TIMEZONE_NAME is not set or is set to NA-PACIFIC | 03:21 |
Deyan | i suppose that makes sense for output bigger than few lines | 03:21 |
Deyan | thanks for timezone | 03:22 |
grantc | you can set it to UNITED-KINGDOM or EUROPE-WESTERN to get the value you want | 03:22 |
grantc | i kind of wish we used the Olson timezone DB | 03:23 |
grantc | Europe/London or Europe/Madrid is so much easier to decipher | 03:23 |
pboro | indeed | 03:23 |
Deyan | i kind of wish ingres uses system timezone | 03:24 |
grantc | there may be reasons you don't want to do that | 03:24 |
grantc | internally we use GMT | 03:24 |
grantc | but we will adjust the value at the client app | 03:24 |
Deyan | is there some document about all these variables so i do not bother you guys here? | 03:28 |
Deyan | i have set II_TIMEZONE_NAME to UNITED-KINGDOM | 03:29 |
Deyan | in .bashrc of ingres user | 03:29 |
Deyan | still no changes | 03:29 |
Deyan | (restarted server) | 03:29 |
grantc | what does ingprenv II_TIMEZONE_NAME say? | 03:31 |
Deyan | still NA-PACIFIC | 03:32 |
grantc | that's the value ingres will use on startup | 03:32 |
grantc | ingsetenv II_TIMEZONE_NAME UNITED-KINGDOM | 03:32 |
grantc | then restart | 03:33 |
Deyan | will that value be persistently stored? | 03:33 |
Deyan | thanks grantc | 03:35 |
Deyan | very much | 03:35 |
grantc | yup ingsetenv is persistent | 03:35 |
*** atrofast has joined #ingres | 03:45 | |
atrofast | Anyone else having problems checking out from code.ingres.com? | 03:45 |
Deyan | hold on | 03:46 |
Deyan | i will tell you in a sec | 03:46 |
Deyan | looks like there is some problem, indeed | 03:47 |
Deyan | aha, works now | 03:47 |
atrofast | Thanks Deyan | 03:47 |
Deyan | svn up worked here | 03:47 |
Deyan | but is VERY slow | 03:47 |
atrofast | HMm on checkout I got some: OPTION request fialed | 03:48 |
grantc | atrofast, there are problems checking out of code... I don't know what the cause is | 03:49 |
atrofast | Anyone tried a reboot of Apache? | 03:50 |
grantc | no but we keep having these problems and rebooting apache is not the soln | 03:50 |
*** Alex|off is now known as Alex| | 03:51 | |
atrofast | I know... but while we're searching for a solution, let's try to keep it working | 03:54 |
grantc | i've restarted the server | 03:59 |
grantc | perhaps we need to look at uprading subversion? | 04:00 |
grantc | also the server is restarted 2 times a day as it is with the problems we had with trac... | 04:01 |
grantc | perhaps it's time we split bugs and code | 04:01 |
*** AdrianUoW has joined #ingres | 04:03 | |
*** AdrianUoW has quit IRC | 04:09 | |
atrofast | Yeah perhaps... I'm not in the office for a couple of hours but when I get back I will look in to it more closely | 04:09 |
*** AdrianHu has joined #ingres | 04:10 | |
grantc | Hi AdrianHu, are you looking for JoPeel? | 04:10 |
*** atrofast has quit IRC | 04:11 | |
AdrianHu | Hello Grant. Perhaps. I'm looking for somebody with knowledge of DMF. | 04:13 |
grantc | err not me i am afraid | 04:13 |
grantc | there may be someone from the US who might be able to help later on | 04:14 |
AdrianHu | ok. Thanks. | 04:14 |
*** clovisw has joined #ingres | 04:20 | |
clovisw | hi, i'm a user of SapDB now its know as MaxDB, now its time to migrate or know another database, and i'm with a doubt, learn Postgres or Ingres? anyone can explain what Ingres is better than Postgres? | 04:22 |
Deyan | clovisw: no idea, i am just a beginer myself | 04:28 |
Deyan | i never liked PostgreSQL ... | 04:28 |
Deyan | for some reasons | 04:28 |
clovisw | you can explain that reasons? | 04:29 |
Deyan | no idea, just a feeling | 04:29 |
Deyan | :) | 04:29 |
clovisw | and how about your use and learning curve of Ingres? | 04:29 |
Deyan | however, Ingres offers some features (enterprise) that Postgres does not | 04:29 |
Deyan | features like: OpenRoad | 04:29 |
Deyan | ABF | 04:29 |
Deyan | excellent VDBA (i wish i have it on Linux) | 04:30 |
AdrianHu | The learning curve of Ingres is much lower than DB2 :D. DB2 confused the heck out of me, so I uninstalled it fairly soon after. | 04:32 |
AdrianHu | Yeah, the terminal monitor isn't that great on Linux, but it's adequate for my role in developing bits of the backend DBMS for my PhD. | 04:36 |
clovisw | AdrianHu, and what is your impression between Postgres x Ingres? | 04:37 |
Deyan | grantc: ingres examples on wiki do not use ingres_commit() function | 04:40 |
Deyan | is that a mistake, or ingres_commit() is not really necessary? | 04:40 |
grantc | Deyan, they are based on the tests for the PHP driver which in turn don't commit as they need to be repeatable | 04:41 |
Deyan | i am still trying to find out why ingres_close() blocks... | 04:41 |
Deyan | it 100% blocks for some reason | 04:41 |
grantc | 100% meaning CPU? | 04:41 |
Deyan | nope | 04:43 |
Deyan | cpu is fine | 04:43 |
Deyan | load is okay | 04:43 |
Deyan | i will paste the code... | 04:43 |
grantc | if you want the data to persist at the end of the page you will either need to issue an ingres_commit() or enble autocommit | 04:43 |
AdrianHu | I've used both, but neither in a real operational scenario. For me, the first things that spring to mind are that Ingres is particularly strong for distributed DBMS, replication, that sort of thing. PostgreSQL has support for user-defined data types without hacking a bunch of C code. PostgreSQL is really easy to get started with. I like the GUI. Ingres probably is too if you use it on Windows, but I have have to use Linux, though it's | 04:44 |
AdrianHu | still not too bad. Otherwise both are capable DBMSs, good SQL Standard support (unlike MySQL!), strong support for useful things like constraints and triggers, good optimizers. | 04:44 |
Deyan | http://ingres.pastebin.com/d5764767d | 04:45 |
Deyan | grantc: it stops at line 63 | 04:45 |
Deyan | when we call ingres_close() | 04:45 |
grantc | what happens when you comment out lines 32-35= | 04:46 |
grantc | ? | 04:46 |
Deyan | ok, i will check that | 04:47 |
Deyan | it will take few minutes... | 04:48 |
*** MagnusG| has joined #ingres | 04:48 | |
pboro | Hi MagnusG| :) | 04:49 |
MagnusG| | Hi pboro | 04:49 |
grantc | Deyan, no problem, i am going to go in search of lunch | 04:50 |
Deyan | i am using that script for migration to our new server | 04:50 |
Deyan | originally we thought 9.4 is bugged | 04:50 |
Deyan | grantc: yep, still the same | 04:52 |
grantc | which version of the PHP driver are you using? | 04:52 |
Deyan | latest one | 04:53 |
grantc | 2.2.1? | 04:53 |
Deyan | yes | 04:53 |
grantc | i wonder if there is a problem with dual connections... there should not be but you never know... | 04:55 |
grantc | i'll take a shufty after lunch | 04:55 |
Deyan | in fact i will need 3 connections in paralllel | 04:59 |
Deyan | 1) to the "sys" database, 2) to the project database(s) 3) to the target database | 04:59 |
Deyan | because i want to merge all project databases into one, single database | 04:59 |
Deyan | for legacy reasons they have been kept separate | 04:59 |
Deyan | (old VMS ...) | 04:59 |
Deyan | we'll talk after lunch | 05:00 |
Deyan | bbl | 05:00 |
*** MagnusG| has quit IRC | 05:02 | |
* Deyan is back | 05:22 | |
clovisw | ingres supports materialized views? | 05:26 |
*** MagnusG| has joined #ingres | 05:26 | |
pboro | clovisw, afaik no | 05:28 |
clovisw | then to simulate that i must use triggers right? | 05:29 |
pboro | Hmm I'm not sure if it's possible to use triggers to simulate that :/ I don't have much experience with materialized views | 05:30 |
AdrianHu | No. Ingres does not support materialized views. There are no plans from Ingres themselves to add them any time soon. However, my research work does involve materialized views. If it goes well then there maybe a prototype in about a year's time. "Simulating" them with triggers is possible. One paper even stated that some DBMS implement them internally that way. | 05:31 |
pboro | Here's stephenb's answer to materialized views: "Ingres does not support materialized views. This is on the to-do list but as yet has no specific release or date attached to it." | 05:32 |
AdrianHu | You might try http://www.pgcon.org/2008/schedule/events/69.en.html It's written for PostgreSQL but should work in Ingres too. | 05:36 |
clovisw | AdrianHu, thanks that will helps | 05:36 |
*** AdrianHu has quit IRC | 05:37 | |
*** toumi01 has joined #ingres | 05:39 | |
*** rossand has joined #ingres | 05:53 | |
*** ChanServ sets mode: +o rossand | 05:53 | |
*** mull has joined #ingres | 06:30 | |
*** mull has quit IRC | 07:01 | |
Deyan | database creation in ingres is considerably slower than with mysql... | 07:02 |
Deyan | i have sql script which creates around 50 tables, and alters them | 07:03 |
Deyan | it is running for more than a minute... | 07:03 |
*** MagnusG| has quit IRC | 07:33 | |
*** mull has joined #ingres | 07:39 | |
*** Alex| is now known as Alex|off | 07:56 | |
*** zxiiro has joined #ingres | 08:02 | |
*** ChanServ sets mode: +v zxiiro | 08:02 | |
pboro | Deyan, yeah, that's something what I have wondered too | 08:10 |
Deyan | it is at least 10x slower than mySQL | 08:13 |
dyki | i can agree | 08:13 |
dyki | 81 tables with around 180foreign keys works like dog | 08:14 |
*** DerMeister has joined #ingres | 08:27 | |
*** Alex|off is now known as Alex| | 09:38 | |
Alex| | grantc, what's the problem? Didn't had much time to follow irc lately | 09:41 |
grantc | people unable to do checkout updates | 09:41 |
Alex| | hum | 09:41 |
grantc | no real info in the log files | 09:41 |
grantc | are you in the office the rest of this week? | 09:42 |
Alex| | yes, should be there | 09:42 |
grantc | just need to hear back from rossand and atrofast | 09:43 |
rossand | hi grantc, I am free most of the week except tomorrow am my time (afternoon your time). | 09:44 |
grantc | ok - name me a time on thurs you will be free | 09:45 |
*** bonro01 has left #ingres | 10:01 | |
*** bonro01 has joined #ingres | 10:01 | |
*** dyki has quit IRC | 10:03 | |
rossand | grantc: flexible. I can shift my day around our discussion. | 10:18 |
*** Deyan has quit IRC | 10:22 | |
*** clovisw has left #ingres | 10:23 | |
*** zxiiro has quit IRC | 10:41 | |
*** zxiiro has joined #ingres | 10:41 | |
*** ChanServ sets mode: +v zxiiro | 10:41 | |
*** zxiiro has quit IRC | 11:03 | |
*** bonro01 has quit IRC | 11:03 | |
*** DerMeister has quit IRC | 11:03 | |
*** thiagomz has quit IRC | 11:03 | |
*** Vroomfondle has quit IRC | 11:03 | |
*** clach04 has quit IRC | 11:03 | |
*** rossand has quit IRC | 11:03 | |
*** Nornagest has quit IRC | 11:03 | |
*** pboro has quit IRC | 11:03 | |
*** Alex| has quit IRC | 11:03 | |
*** mull has quit IRC | 11:03 | |
*** toumi01 has quit IRC | 11:03 | |
*** grantc has quit IRC | 11:03 | |
*** rossand has joined #ingres | 11:04 | |
*** zxiiro has joined #ingres | 11:04 | |
*** bonro01 has joined #ingres | 11:04 | |
*** DerMeister has joined #ingres | 11:04 | |
*** mull has joined #ingres | 11:04 | |
*** toumi01 has joined #ingres | 11:04 | |
*** grantc has joined #ingres | 11:04 | |
*** thiagomz has joined #ingres | 11:04 | |
*** clach04 has joined #ingres | 11:04 | |
*** Alex| has joined #ingres | 11:04 | |
*** irc.freenode.net sets mode: +ovoo rossand zxiiro grantc Alex| | 11:04 | |
*** Nornagest has joined #ingres | 11:04 | |
*** Vroomfondle has joined #ingres | 11:04 | |
*** pboro has joined #ingres | 11:04 | |
*** atrofast has joined #ingres | 12:59 | |
*** Alex| is now known as Alex|off | 13:18 | |
*** DerMeister has quit IRC | 14:10 | |
*** grantc has quit IRC | 14:24 | |
*** adrianwarwickuni has joined #ingres | 15:25 | |
*** mull has quit IRC | 15:55 | |
*** zxiiro has quit IRC | 16:54 | |
*** zxiiro has joined #ingres | 16:54 | |
*** ChanServ sets mode: +v zxiiro | 16:54 | |
*** adrianwarwickuni has quit IRC | 17:08 | |
*** rossand has quit IRC | 17:30 | |
*** toumi01 has quit IRC | 17:38 | |
*** rossand has joined #ingres | 19:58 | |
*** ChanServ sets mode: +o rossand | 19:58 | |
*** rossand has quit IRC | 22:04 | |
*** Alex|off is now known as Alex| | 22:37 | |
*** Alex| is now known as Alex|off | 23:01 | |
pboro | hmh... after upgrading 9.2 to p13457, I keep getting "ER error 10902" and E_AD7015_ADP_FREE_LOCATOR | 23:08 |
pboro | ah, fix for bug 121788 seems to be incomplete :( | 23:36 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!