*** grantc has joined #ingres | 00:17 | |
*** ChanServ sets mode: +o grantc | 00:17 | |
*** Gerhard has joined #ingres | 00:40 | |
Gerhard | Hi all | 00:42 |
---|---|---|
Gerhard | Any way to create system catalog iiviews in case it is missing in a db? | 00:46 |
grantc | missing? how? | 00:47 |
grantc | i guess you can access the db in question using "sql +U dbname" and then add the missing view | 00:49 |
Gerhard | A customers server had a hardware problem. Unfortunately, database was not checkpointed / journaled. Customer did a verifydb ... -o force_consistent... | 00:50 |
Gerhard | Now we want to copy out / copy in whole db but copydb / unloaddb says "iiviews missing..." | 00:50 |
grantc | the quel in http://ingres.pastebin.com/m5b997d27 will create the view for you | 00:51 |
Gerhard | What would be the correct "create view..." statement to recreate the iiviews view, I could not find it in old copy.in files... | 00:53 |
Gerhard | Oh sorry, will look in the pastebin... | 00:53 |
Gerhard | I saved the code in the pastebin to a file repair.sql and then did... | 00:57 |
Gerhard | ...sql -u$ingres dbname < repair.sql | 00:57 |
grantc | you need to use the "+U" flag | 00:57 |
Gerhard | screen output: You are in a transaction. Do you wish to abort your transaction and quit? | 00:58 |
Gerhard | will try +U | 00:58 |
grantc | also add "end transaction" to your sql file | 00:59 |
grantc | or "\sql;commit\g" | 00:59 |
*** Alex| has quit IRC | 01:03 | |
*** Nornagest has quit IRC | 01:03 | |
*** Alex|off has joined #ingres | 01:03 | |
*** Nornagest has joined #ingres | 01:04 | |
*** Alex|off is now known as Alex| | 01:05 | |
*** ChanServ sets mode: +o Alex| | 01:05 | |
*** Alex| is now known as Alex|off | 01:05 | |
*** Alex|off is now known as Alex| | 01:06 | |
Gerhard | Now a copydb will result in errlog.log messages "error getting a record ... from iirelation", so obviously physical problem with iirelation | 01:07 |
Gerhard | Any chance to repair ii* catalogs with verifydb? | 01:07 |
grantc | you can try - it could be your disk is fscked? | 01:08 |
grantc | take a back first before running verifydb | 01:08 |
grantc | also check errlog.log | 01:08 |
grantc | also raise an issue with support as they may have come across something like this before... | 01:08 |
Gerhard | server is a Windows machine, not Linux | 01:08 |
grantc | fscked = trouble :) | 01:10 |
grantc | or screwed... | 01:10 |
*** Dejan has joined #ingres | 02:38 | |
Dejan | good morning | 02:39 |
grantc | morning | 02:42 |
Dejan | when is 9.3 stable going to be released? | 04:19 |
grantc | i don't know - your best bet is to email info@ingres.com | 04:21 |
*** Gerhard has quit IRC | 05:33 | |
* Dejan loves Ingres | 05:42 | |
Dejan | Ingres makes me happy | 05:42 |
Dejan | :D | 05:42 |
atrofast | We should start selling Ingres as a happy pill then :D | 05:56 |
*** thiagomz has joined #ingres | 06:02 | |
thiagomz | guys, anyone has a view of the ingres architecture, i am trying understand dmf memory, group, etc... | 06:04 |
atrofast | thiagomz: Did you read this: http://community.ingres.com/wiki/A_Short_Excursion_Through_The_Ingres_Back-End#Utility_Facility_.28ULF.29 | 06:05 |
thiagomz | atrofast: tkz | 06:05 |
atrofast | minus the #Utility_Facility_.28ULF.29 | 06:05 |
thiagomz | atrofast: i am looking for something like that -> http://farm4.static.flickr.com/3142/2862960124_eaa0443ec0.jpg | 06:11 |
atrofast | Ahhh thiagomz a diagram, hmm I think I've seen something like that but I can't remember where | 06:13 |
thiagomz | atrofast: my english.. sorry | 06:14 |
thiagomz | :D | 06:14 |
atrofast | No worries :) | 06:14 |
atrofast | My first language isn't English either | 06:15 |
Dejan | i would like to know what "K Join" and "T join" are, in the QEP | 06:17 |
Dejan | from a newbie perspective, it would be IMHO more useful to have EXPLAIN like in PGSQL | 06:18 |
Dejan | (maybe ingres has it but i am not aware of it) | 06:18 |
*** mull has joined #ingres | 06:19 | |
*** Gerhard has joined #ingres | 06:24 | |
Dejan | we are many | 06:25 |
Dejan | :D | 06:25 |
Gerhard | Hi all | 06:26 |
atrofast | I believe K Join is a key join and T Join is a table join | 06:26 |
Dejan | hi Gerhard | 06:30 |
Dejan | what i like in EXPLAIN in PGSQL is that it gives times | 06:30 |
Dejan | for each operation | 06:30 |
Dejan | it is IMHO very useful | 06:30 |
Dejan | as it shows bottlenecks | 06:31 |
Gerhard | Anybody having experiences with making Ingres portable / USB-stick-enabled? Stumbled upon this ...http://www.rationalcommerce.com/mojopac.htm | 06:32 |
atrofast | Dejan: if you do set tracepoint qe90 you will get some more cost information | 06:33 |
Dejan | atrofast: where can i get information about available tracepoints? | 06:37 |
atrofast | Dejan: http://www.kbcomputer.com/trace_pts.html | 06:40 |
Dejan | atrofast: i get the same QEP | 06:40 |
Dejan | with and without set tracepoint qe90 | 06:40 |
Dejan | :( | 06:41 |
Dejan | Gerhard: mojopac simply just hosts OS | 06:41 |
Dejan | i have Fedora on my USB stick | 06:41 |
Dejan | ingres can work pretty well on it | 06:41 |
Gerhard | Yes, I know it's possible to have bootable OS on a stick, but that's not what I thought of. | 06:43 |
Gerhard | I mainly use Windows as a platform and for testing purposes have to switch between different Ingres Rels. / patch levels which means having to built zillions of VMs | 06:46 |
Dejan | a box with linux and virtualbox would do | 06:49 |
Dejan | i suppose | 06:49 |
Dejan | my test servers are all on a Dell Equalogic 4500 | 06:49 |
Dejan | it is a sexy rack with Xen installed | 06:50 |
Dejan | comes with Xen centre | 06:50 |
Dejan | awesome stuff | 06:50 |
atrofast | grantc: is libq supposed to be linked with librt and somebody accidentally removed it or what was happening therE? Because I get the same issues with libgeos in the geospatial branch | 06:50 |
Gerhard | So I want something like that ... http://portable-apps.net/portable-apps-tag/mysql ... but without the apache / PHP thingie and with Ingres instead of MySQL. | 06:51 |
Dejan | it is not linked against librt here on my machine | 06:51 |
atrofast | Ingres 9.2 has libq.1.so linked against librt | 06:52 |
atrofast | But anything newer seems to remove that link | 06:52 |
Dejan | ah... | 06:54 |
Dejan | something that would work straight... | 06:54 |
Dejan | basically it is the same like MySQL ZIP binary distribution | 06:54 |
Dejan | you unzip it, and it runs straight | 06:55 |
Dejan | Gerhard: did you try to ZIP the Ingres folder, and make a script which will just simply reconfigure a new copy? | 06:55 |
*** Alex| is now known as Alex|off | 06:55 | |
toumi01 | atrofast: re librt see this copy of a recent piccolo integration http://ingres.pastebin.com/m3b6f5e5f | 06:56 |
Gerhard | Dejan: could be a good starting point, will try. | 06:56 |
Gerhard | Maybe will also try with app virtualization like Thinstall or XEN Virtual Application Studio, unfortunately both not free. | 06:59 |
grantc | atrofast, libcompat is suppoed to be linked against librt | 06:59 |
atrofast | grantc, toumi01 okay, but libcompat does not link against it in the SVN version :) | 07:02 |
atrofast | Also since we're using two new libs, should those be linked with libcompat in our branch? | 07:03 |
Dejan | it is not linked in 10.x-105 | 07:03 |
atrofast | Is that the right way to go about it | 07:03 |
toumi01 | the librt option seems to be there in the head revision main svn repository | 07:05 |
Dejan | i was looking at UK IUA Development Sprint 2009 | 07:47 |
Dejan | there are some very nice things done there | 07:47 |
Dejan | like: ckpdb --compression=bzip2 <dbname> | 07:47 |
Dejan | i want that | 07:47 |
Dejan | ASAP | 07:47 |
pboro | you can have it by modifying ckp template :) | 07:47 |
Dejan | really? | 07:48 |
pboro | though it would not be a parameter then but would use bzip2 anyways | 07:48 |
Dejan | omg imust make it | 07:48 |
Dejan | or: | 07:48 |
pboro | check cktmpl.def under files dir | 07:48 |
Dejan | sql iidbdb | 07:48 |
Dejan | create database <dbname>; | 07:48 |
Dejan | that is also nice | 07:48 |
Dejan | i wonder would Ingres benefit of using CUDA... | 08:20 |
Dejan | and do some parallel query processing using separate cores | 08:21 |
*** Gerhard has quit IRC | 08:47 | |
*** Nornagest has quit IRC | 08:50 | |
*** Alex|off has quit IRC | 08:50 | |
*** Alex| has joined #ingres | 08:51 | |
*** ChanServ sets mode: +o Alex| | 08:51 | |
*** Nornagest has joined #ingres | 08:52 | |
*** rossand has quit IRC | 09:54 | |
*** Dejan has quit IRC | 09:56 | |
*** clach04 has joined #ingres | 10:17 | |
thiagomz | guys, are there a way to get the time of execution of a sql that triggers a lot of rules... i want to known what is my poor query in a processes... | 11:49 |
*** grantc has quit IRC | 12:01 | |
*** thiagomz has quit IRC | 13:03 | |
*** DerMeister has joined #ingres | 13:20 | |
*** Alex| is now known as Alex|off | 13:28 | |
*** DerMeister has quit IRC | 14:23 | |
*** rossand has joined #ingres | 15:05 | |
*** ChanServ sets mode: +o rossand | 15:05 | |
*** mull has quit IRC | 16:17 | |
*** mull has joined #ingres | 17:48 | |
*** rossand has quit IRC | 18:08 | |
*** rossand has joined #ingres | 18:10 | |
*** ChanServ sets mode: +o rossand | 18:10 | |
*** rossand has quit IRC | 18:15 | |
*** mull has quit IRC | 20:33 | |
*** bonro01 has quit IRC | 21:39 | |
*** Alex|off has quit IRC | 21:39 | |
*** clach04 has quit IRC | 21:39 | |
*** Vroomfondle has quit IRC | 21:39 | |
*** atrofast has quit IRC | 21:39 | |
*** toumi01 has quit IRC | 21:39 | |
*** FrankW has quit IRC | 21:39 | |
*** atrofast has joined #ingres | 21:40 | |
*** toumi01 has joined #ingres | 21:40 | |
*** clach04 has joined #ingres | 21:42 | |
*** Vroomfondle has joined #ingres | 21:42 | |
*** bonro01 has joined #ingres | 21:43 | |
*** Alex| has joined #ingres | 21:43 | |
*** irc.freenode.net sets mode: +o Alex| | 21:43 | |
*** Alex| is now known as Alex|off | 22:11 | |
*** bonro01 has quit IRC | 22:48 | |
*** Alex|off has quit IRC | 22:50 | |
*** Alex|off has joined #ingres | 22:52 | |
*** irc.freenode.net sets mode: +o Alex|off | 22:52 | |
*** bonro01 has joined #ingres | 22:53 | |
*** Alex|off has quit IRC | 23:13 | |
*** bonro01 has quit IRC | 23:13 | |
*** Alex|off has joined #ingres | 23:25 | |
*** irc.freenode.net sets mode: +o Alex|off | 23:25 | |
*** bonro01 has joined #ingres | 23:26 | |
*** bonro01 has quit IRC | 23:32 | |
*** Alex|off has quit IRC | 23:32 | |
*** Alex|off has joined #ingres | 23:39 | |
*** irc.freenode.net sets mode: +o Alex|off | 23:39 | |
*** bonro01 has joined #ingres | 23:39 |
Generated by irclog2html.py 2.7 by Marius Gedminas - find it at mg.pov.lt!