*** NoeJeko has quit IRC | 00:37 | |
*** NoeJeko has joined #ingres | 00:38 | |
*** NoeJeko has quit IRC | 00:49 | |
*** toumi01 has quit IRC | 03:51 | |
*** Alex|off is now known as Alex| | 05:35 | |
*** Alex| is now known as Alex|off | 06:24 | |
*** grantc_offline is now known as grantc | 08:07 | |
*** Gerhard has joined #ingres | 10:52 | |
troal01 | Hm doing a copy tab() into 'file' freezes even when directing to a proper harddrive (this is the table that's about 150gbs) | 11:57 |
---|---|---|
troal01 | The binary file grows to 77GB then Ingres freezes | 11:58 |
troal01 | Is there any way I can copy out a bit of the table at a time? | 12:10 |
grantc | you could create a pipe to gzip and split... | 12:11 |
grantc | do you not see any errors in the errlog.log? | 12:12 |
troal01 | ALEX-FEDORA ::[55316 , 29324 , 0000000001c622c0, scscompress.c:300 ]: Tue Mar 3 03:46:58 2009 E_SC039B_VAR_LEN_INCORRECTData in column has a length of 80 (0x00000050) exceeding its maximum of 6 - excess length retracted. | 12:12 |
troal01 | That's all there is in the errlog | 12:13 |
grantc | and the time matches the time of the hang? | 12:14 |
troal01 | That I'm not sure, I was sleeping :P | 12:14 |
grantc | http://ingres.pastebin.com/m1341785f - corrupt data? | 12:15 |
troal01 | Okay so if I have a corrupt column how do I fix it? | 12:16 |
grantc | no idea | 12:16 |
troal01 | Crap | 12:17 |
troal01 | Well I kinda need to be able to take a backup of this database :P | 12:17 |
grantc | ckpdb? | 12:17 |
troal01 | How much space will that use anyway? | 12:17 |
grantc | less I guess than copydb | 12:18 |
troal01 | Also what's the proper way to shutdown a terminal that's frozen? | 12:18 |
grantc | remove the session from the server i guess | 12:18 |
troal01 | How do I do that? :) | 12:21 |
grantc | rtfm | 12:21 |
grantc | or raise an issue with support | 12:21 |
troal01 | Thank you | 12:22 |
grantc | sorry but I don't have time to talk you through the process and these sorts of things are what our support guys are fore | 12:22 |
grantc | for even.. | 12:22 |
troal01 | I understand | 12:25 |
grantc | perhaps its worth you attending a dba course? | 12:26 |
troal01 | I'd jump on that chance | 12:28 |
troal01 | I haven't been offered it though | 12:28 |
grantc | ask for it? | 12:28 |
troal01 | Yeah I guess I should | 12:29 |
troal01 | Hey has anyone here tried Arch linux? | 12:32 |
grantc | not me | 12:33 |
troal01 | It's quite neat if you like to get your hands dirty | 12:34 |
grantc | my hands get dirty enough ... | 12:34 |
troal01 | I find that it's also faster than your regular distro | 12:44 |
pboro | faster? have you tried gentoo? or lfs? :D | 12:45 |
*** Gerhard has quit IRC | 12:55 | |
troal01 | zxiiro_ swears by Gentoo :) | 12:57 |
troal01 | I like how Arch has rolling releases though | 12:57 |
troal01 | I dunno about LFS, I kinda like having a package manager that can pull binaries for me | 13:11 |
*** rossand has joined #ingres | 14:05 | |
*** ChanServ sets mode: +o rossand | 14:05 | |
*** notdefault is now known as withdefault | 14:09 | |
*** toumi01 has joined #ingres | 14:25 | |
troal01 | Is there any way to change an existing database's dmp,journal and ckp location? | 14:55 |
troal01 | Or would using ingsetenv to change II_DUMP etc be bad? | 14:57 |
*** mull has joined #ingres | 14:57 | |
elPiola | troal01, take a look at relocatedb, extenddb and accessdb | 15:00 |
troal01 | extenddb, accessdb did not help me | 15:01 |
troal01 | I'll look at relocatedb | 15:01 |
troal01 | relocatedb worked, thanks al ot elPiola | 15:03 |
*** DarylM has joined #ingres | 15:06 | |
*** DarylM has quit IRC | 15:08 | |
*** DarylM has joined #ingres | 15:08 | |
troal01 | relocatedb doesn't autmatically create the dirs for the db :P | 15:12 |
troal01 | I had to manually do mkdir | 15:12 |
troal01 | can you take a ckp, dump and journal file and move it to another system and recreate the database? | 15:39 |
*** mib_amrzc78i has joined #ingres | 16:10 | |
*** mib_amrzc78i has quit IRC | 16:15 | |
*** satanmalin has joined #ingres | 16:16 | |
satanmalin | Hi everyone | 16:16 |
satanmalin | Hi grant | 16:16 |
grantc | hi satanmalin | 16:16 |
satanmalin | im cedric | 16:16 |
satanmalin | really thanks for your help | 16:17 |
grantc | still mad i see ;) | 16:17 |
satanmalin | LOL | 16:17 |
satanmalin | yes i am | 16:17 |
satanmalin | im becoming crazy | 16:17 |
satanmalin | now i have a prob with the iidbdbd | 16:17 |
satanmalin | iidbdbd | 16:17 |
satanmalin | iidbdb | 16:17 |
satanmalin | LOL | 16:17 |
grantc | ? | 16:18 |
satanmalin | it drive me crazy | 16:18 |
satanmalin | were you on the web ex when we shows easyingres ? | 16:18 |
satanmalin | with emma | 16:19 |
grantc | I was on the call but did not see the webex session | 16:20 |
satanmalin | oki | 16:20 |
satanmalin | i launch again the ingres console and tell you the problem | 16:20 |
satanmalin | the problem is when I do a createdb -i demodb it returns me E_US002B Could not open the iidbdb database | 16:22 |
grantc | there should be some messages in %II_SYSTEM%\ingres\files\errlog.log | 16:23 |
satanmalin | do you want my errlog by mail ? | 16:26 |
grantc | no thanks, paste the messages into http://ingres.pastebin.com | 16:26 |
satanmalin | http://ingres.pastebin.com/m77134293 | 16:29 |
satanmalin | i think its due to a path but i dont know how to fix it | 16:30 |
satanmalin | beacause in easy ingres now we do a "flash" install | 16:30 |
grantc | did the iidbdb database get created? | 16:30 |
DarylM | Doesn't look like it | 16:31 |
grantc | what does "flash" mean? | 16:31 |
satanmalin | indeed | 16:31 |
satanmalin | ill install ingres on a machine | 16:31 |
satanmalin | i copy the file | 16:32 |
satanmalin | and my install copy the file at the right place during install | 16:32 |
satanmalin | thats why i think | 16:33 |
satanmalin | the iidbdb is created but the path isnt right | 16:33 |
satanmalin | I see for the path C:\Program Files\Ingres\IngresWi ... | 16:34 |
satanmalin | and normally the path is | 16:34 |
satanmalin | C:\Program Files\EasyIngres\Ingres\IngresWi ... | 16:34 |
satanmalin | i dont know if im clear | 16:34 |
grantc | kind of | 16:35 |
satanmalin | indeed my install is quiet like a self exctracting zip package | 16:35 |
grantc | if you install ingres the way you do using a pre-installed ingres you must keep the same path | 16:36 |
grantc | for everything | 16:37 |
grantc | in the database we have a file that remembers where its files should be | 16:37 |
satanmalin | yes but is ther a way to sepecified the pass | 16:37 |
satanmalin | making an install like mine ? | 16:37 |
grantc | i am not sure i understand | 16:38 |
grantc | at the moment there is no way you can change the location of the database at least there is no supported way | 16:39 |
satanmalin | ill try to explain in a better way | 16:39 |
grantc | the file, aaaaaaaa.cnf contains the locations but you cannot edit it using notepad you need a hex editor | 16:39 |
grantc | or write a program to change the file | 16:39 |
satanmalin | LOL | 16:40 |
satanmalin | in fact the problem is that Ingres was installed on a machine | 16:40 |
grantc | so for your problem, you have to re-install on the source machine to the location you want... | 16:40 |
satanmalin | and i copy all the files located in C:\progam files\ingres on a usb stick | 16:41 |
DarylM | You cannot relocate Ingres once installed. It should not be that way, but it is ancient history and a massive undertaking to change. | 16:42 |
satanmalin | thats a prob for me LOL | 16:43 |
DarylM | On Unix systems people will sometimes resort to "softlinks" or file systems mounted at a specific place. For example, I did what you did on a USB stick on Mac OS/X but I did the install on the USB and I mount the USB at the same place on every machine: /Volumes/IngresStick | 16:48 |
DarylM | You should be able to do the same thing on Windows. | 16:48 |
grantc | windows has junctions | 16:48 |
DarylM | I've tried aliases on Windows before. Ingres didn't play well with them | 16:49 |
DarylM | But that is very old information | 16:49 |
grantc | junctions work the same as far as I can tell | 16:50 |
grantc | i use them for building the PHP / Ruby drivers on Windows | 16:50 |
grantc | i don't use them to run Ingres though | 16:50 |
satanmalin | and how to do that ? | 16:50 |
DarylM | That is a bit involved for an IM session | 16:51 |
grantc | google for ntfs junction | 16:51 |
DarylM | http://en.wikipedia.org/wiki/NTFS_junction_point | 16:53 |
DarylM | I had no idea that existed!. Thanks :-) | 16:53 |
DarylM | It was "shortcuts" that don't work with Ingres. | 16:53 |
* DarylM Windows memories come flooding back. Where is my barf bag? | 16:54 | |
DarylM | Hummm, there are some interesting and VERY dangerous differences between junctions and unix (hard/soft) links. | 16:55 |
*** DerMeister has joined #ingres | 16:57 | |
satanmalin | it seems to be quiet Hard for me (i dont know very well Ingres like you) | 16:59 |
satanmalin | sorry im really a noob | 17:00 |
DarylM | It is less of a question on knowing Ingres and more of a question of how to use the Operating System (Windows in this case) to create a folder tree that looks like your original. You don't need to know much about Ingres. | 17:00 |
DarylM | You can look at the folders and files and see how they are organized. | 17:01 |
satanmalin | im looking at the $crosoft explainaition about NTFS junctions it seems to be something dark | 17:02 |
satanmalin | LOL | 17:02 |
*** bonro01 has left #ingres | 17:02 | |
DarylM | Perhaps the above Wiki reference would be easier? | 17:02 |
DarylM | I have no experience at all with Windows "junctions" and Ingres. | 17:04 |
DarylM | In fact, I didn't even know about junctions until grantc gave the reference :-) | 17:05 |
grantc | my experience is just with simplifying a build process so i can iterate over a directory | 17:05 |
* DarylM has learned one new thing for today. Am I done now? | 17:05 | |
grantc | such that ingres_releases contains junctions pointing to the ingres installations i wish to build against | 17:05 |
grantc | ditto with php_releases | 17:06 |
satanmalin | satanmalin is completly lost LOL | 17:06 |
grantc | satanmalin, junctions are similar to soft links in linux | 17:06 |
DarylM | Easy solution. Plug in the USB drive and just install directly onto it with a new, fresh installation. | 17:07 |
grantc | what happens if the drive letter for the usb disk is different | 17:07 |
DarylM | If you have existing databases to move, use "unloaddb" | 17:07 |
* DarylM sighs at another Windows feature from 1960's computing technology | 17:08 | |
satanmalin | the only bases i have is iidbdb and demodb | 17:08 |
DarylM | Those are from the install. | 17:08 |
DarylM | grantc: How do most people deal with mounted file systems to guarentee a fixed, predictable file system path on Windows? | 17:09 |
grantc | good question | 17:09 |
DarylM | lol | 17:10 |
grantc | i don't know the answer to that. | 17:10 |
grantc | i typically only ever plug in one usb device at a time | 17:10 |
* DarylM wonders if there is anyone else out there with that answer | 17:10 | |
grantc | mass storage device that is | 17:10 |
satanmalin | Satanmalin try to commit suicide with an RJ45 cable cause he is completely mad LOOOOOOOOOOOOOOOL it drives me mad LOOL it seem very simple in a first time | 17:12 |
DarylM | Someone has to try stuff for the first time | 17:12 |
satanmalin | but now its becoming harder than I thougt | 17:12 |
satanmalin | yep but i aint a engineer | 17:13 |
satanmalin | LOL | 17:13 |
satanmalin | DarylM | 17:20 |
DarylM | yo | 17:20 |
satanmalin | are you the one who contact bruno for easy ingres ? | 17:21 |
satanmalin | im little satan | 17:21 |
DarylM | I asked about techniques for packing EasyIngres, yes | 17:21 |
satanmalin | the one who try to do this packages | 17:22 |
satanmalin | oki | 17:22 |
satanmalin | LOL | 17:22 |
DarylM | That explains a lot :D | 17:22 |
satanmalin | LOL | 17:22 |
satanmalin | of course | 17:22 |
satanmalin | LOL | 17:22 |
satanmalin | bruno has just send me you request | 17:22 |
satanmalin | and when i saw Daryl and your name | 17:23 |
DarylM | As the resident Mac guy, I am interested in a similar packaging. Plus, it sounds like a fun hacking project | 17:23 |
satanmalin | LOOOOOOL | 17:23 |
satanmalin | bacause of the devil ? | 17:23 |
satanmalin | LOL | 17:23 |
satanmalin | the bleu devil ? | 17:24 |
satanmalin | blue | 17:24 |
DarylM | Well, if my spelling is correct, when talking cheese it is bleu. | 17:24 |
satanmalin | yep LOL | 17:24 |
satanmalin | so what are your question about this project because the only sentence i have is No, I don't have the details, but I can ask the community guy who did that. I know Delphi was involved. Little Satan, ready for an interview with Daryl ? ;0) | 17:25 |
DarylM | But as I have mentioned to others in the past, my Deutsch is very bad and my French is non-existent. | 17:25 |
satanmalin | My english is bad my french of course a quiet better LOL and my italian is getting worse and worse | 17:26 |
satanmalin | thats why i have to beg you pardon if my english is sometime ununderstandable LOL | 17:29 |
DarylM | Not a problem if you can forgive me for not knowing any French at all. ;-) | 17:30 |
DarylM | (except for Bleu-chees of course) LoL | 17:30 |
satanmalin | LOL no problem | 17:30 |
satanmalin | LOOOOL | 17:30 |
satanmalin | so what are your questions about the project ?? maybe i can answer it | 17:31 |
satanmalin | LOL | 17:31 |
satanmalin | ill try to be clear LOL | 17:32 |
satanmalin | i have solved the problem to install in english or in french | 17:36 |
satanmalin | so now the 0.2 is also in english or in french (depending on your choice in the install) | 17:37 |
satanmalin | grant helped me for the dll so now in the pacjage we have ingres 9.2 build 143 (when it will work LOL) apache 2.2.8 php 5.2.9 scite editor 1.77 and fox it reader | 17:40 |
*** NoeJeko has joined #ingres | 17:43 | |
*** DerMeister has quit IRC | 17:47 | |
*** bonro01 has joined #ingres | 18:11 | |
*** grantc is now known as grantc_offline | 18:21 | |
troal01 | This would be fun to run on our logs: http://pisg.sourceforge.net/ :D | 18:28 |
pboro | Pisg is a classic :) | 18:28 |
*** Alex|off is now known as Alex| | 19:44 | |
*** Alex| is now known as Alex|off | 20:37 | |
*** DerMeister has joined #ingres | 21:32 | |
*** NoeJeko has quit IRC | 22:01 | |
*** DerMeister has quit IRC | 22:10 | |
*** DarylM has quit IRC | 23:40 | |
*** mull has quit IRC | 23:45 | |
*** withdefault has left #ingres | 23:59 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!