On Tue, Oct 07, 2008 at 07:52:49PM +0200, Niels Nes wrote:
>
> Sjoerd, Stefan,
>
> Ik heb al een tijdje geen buildtools in een lege omgeving (ie geen
> monetdb enviroment settings) geprobeert. Kan het zijn dat er dan
> iets misgaat. Make distclean moeten we misschien ook nog aan de testing
> toevoegen ?
>
> Niels
> ----- Forwarded message from Carl Nobile <[EMAIL PROTECTED]> -----
>
> From: Carl Nobile <[EMAIL PROTECTED]>
> Subject: Re: [Monetdb-developers] Data integrity bug
> To: Niels Nes <[EMAIL PROTECTED]>
>
> Neils,
> I got buildtools to compile. It seems that 'make distclean'
> does not clean out any of the yacc crud. So, I just blew away
> the tree and checked it out again.
> Now when I run ./bootstrap in the clients code it complains the
> following:
> $ ./bootstrap
> automake 1.9.6 is 1.7 or newer. Good.
> autoconf 2.61 is 2.57 or newer. Good.
> libtool 1.5.24Debian1.5.24-1ubuntu1 is 1.4 or newer. Good.
> Python 2.5.1 is 2.0.0 or newer. Good.
> Traceback (most recent call last):
> File "/usr/local/MonetDB/bin/autogen.py", line 29, in
> <module>
> from autogen import am
> ImportError: No module named autogen
> I've looked for a python-autogen package, but have found
> nothing in Ubuntu's repositories.
from buildtools/README
========
[...]
In particular, see autogen/README for how to set your PYTHONPATH in case
./bootstrap of MonetDB, sql, pathfinder, etc. fails to find the autogen
module with the default settings.
========
from buildtools/autogen/README
========
To build, run
python setup.py build
then to install, run
python setup.py install [--prefix=<install-dir-prefix>]
Use
python setup.py --help
to get more information about the possible options.
If you use the --prefix option or otherwise install autogen in a
different place, you may have to set your PYTHONPATH environment
variable accordingly. The directory which needs to be added is
<install-dir-prefix>/lib(64)/python<python-version>/site-packages, where
<python-version> is the version of Python used (e.g. 2.4).
You can automatically get the respective directory via
"<install-dir-prefix>/`python -c 'import distutils.sysconfig; print
distutils.sysconfig.get_python_lib(0,0,"")'`".
(
In case you are using Apple-built Python 2.5.1 on Mac OS X 10.5.* (Darwin 9.*),
it can be that the above command yields
"<install-dir-prefix>/Library/Python/2.5/site-packages",
while Python's distutils.core.setup() actually installs the python modules into
"<install-dir-prefix>/lib/python2.5/site-packages".
In that case, replacing the above command by
"<install-dir-prefix>/`python -c 'import distutils.sysconfig; print
distutils.sysconfig.get_python_lib(0,1,"")'`/site-packages"
might help to overcome this inconsistency.
)
[...]
========
Stefan
> -Carl
> On Tue, Oct 7, 2008 at 12:35 PM, Niels Nes
> <[EMAIL PROTECTED]> wrote:
>
> On Tue, Oct 07, 2008 at 12:24:38PM -0400, Carl Nobile wrote:
> > Neils,
> > I'm getting errors when I try to build buildtools.
> > mel.cc:(.text+0x7f9): undefined reference to `yyin'
> > My installed packages are:
> > autoconf (GNU Autoconf) 2.61
> > automake (GNU automake) 1.9.6
> > autogen (GNU AutoGen) - The Automated Program Generator -
> Ver.
> > 5.9.1
> > ltmain.sh (GNU libtool) 1.5.24 Debian 1.5.24-1ubuntu1
> > (1.1220.2.456 2007/06/24 02:25:32)
> > bison (GNU Bison) 2.3
> > flex 2.5.33
> > g++ (GCC) 4.1.3 20070929 (prerelease) (Ubuntu
> 4.1.2-16ubuntu2)
> > Carl
>
> yyin should be defined in mel/[2]mel.yy.cc, ie a flex
> generated source
> file. Maybe something went wrong with this file. We have for
> almost
> all tools the same version on our fedore 8 systems.
> Niels (ie not Neils)
> > On Tue, Oct 7, 2008 at 6:27 AM, Niels Nes
> <[EMAIL PROTECTED]>
>
> > wrote:
> >
> > On Mon, Oct 06, 2008 at 03:07:02PM -0400, Carl Nobile
> wrote:
> > > Ross,
> > > I forgot to answer one of your questions. Although my
> web
> > > service can delete data, running a delete doesn't
> seen to
> > be
> > > involved with this issue. To make a long story short
> it
> > seems
> > > everything is okay until I add a column during an
> update.
> >
> > I just fixed the problem for Ross. Allthough the problem
> was
> > related to
> > deletes which you do not have, it still may solve your
> > problem as the
> > fix was at a lower level than the sql delete statement.
> > So could you test with a checkout from cvs head?
> > Niels
> >
> > > -Carl
> > > On Mon, Oct 6, 2008 at 2:50 PM, Carl Nobile
> >
>
> > > <[EMAIL PROTECTED]> wrote:
> > >
> > > Yes, the same is true with my situation. It can work
> fine
> > 3 or
> > > 4 times in a row then select from where equals just
> stops
> > > returning any data.
> > > -Carl
> > > On Mon, Oct 6, 2008 at 2:45 PM, Ross Bates
> >
>
> > > <[EMAIL PROTECTED]> wrote:
> > >
> > > Something definitely going on with the table stats, I
> am
> > seeing
> > > the same strange behavior in that it doesn't occur on
> a
> > > consistent basis.
> > > I have finally been able to recreate it using the
> > following
> > > steps. (also see my notes that follow)
> > > --------------------------------------
> > > CREATE TABLE "sobi"."table1"
> > > (
> > > cid integer,
> > > p varchar(100),
> > > c varchar(100),
> > > lf integer,
> > > rt integer,
> > > lvl integer
> > > )
> > > insert into sobi.table1 values (1,'foo','bar',9,12,1)
> > > insert into sobi.table1 values
> (1,'boo','blah',13,22,1)
> > > CREATE TABLE "sobi"."table2"
> > > (
> > > p varchar(100),
> > > c varchar(100),
> > > lf integer,
> > > rt integer,
> > > lvl integer
> > > )
> > > insert into sobi.table2(p,c) (select p,c from
> sobi.table1)
> > > select * from sobi.table2
> > > select * from sobi.table2 where p = 'foo'
> > > delete from sobi.table2
> > > --------------------------------------
> > > It might happen right away - or it might take 5-10
> times,
> > but
> > > if you iterate over the insert > select > delete
> > statements
> > > eventually the [p = 'foo'] select will stop returning
> > rows.
> > > On Mon, Oct 6, 2008 at 1:24 PM, Carl Nobile
> >
>
> > > <[EMAIL PROTECTED]> wrote:
> > >
> > > Ross,
> > > I have written a web service in Python that sets on
> top of
> > > MonetDB it is somewhat complicated, but I'll try to
> > explain it
> > > below. There are only three tables in the schema and
> one
> > view
> > > over sys.tables and sys.columns.
> > > BUSINESS_UNIT
> > > BUSINESS_USER_COLUMN_STATS
> > > BUSINESS_USER_PROFILE
> > > BUSINESS_USER_PROFILE_COLUMNS
> > > 1) START TRANSACTION
> > > 2) Check if record exists to determine if an UPDATE
> or an
> > > INSERT needs to be done.
> > > (SELECT count(*) FROM "BUSINESS_USER_PROFILE" WHERE
> > > "USER_ID"=%(USER_ID)s AND
> "BUSINESS_ID"=%(BUSINESS_ID)s)
> > > 3) If an INSERT then check if the BUSINESS_UNIT is
> > present.
> > > SELECT count(*) FROM "BUSINESS_UNIT" WHERE
> > > "BUSINESS_ID"=%(BUSINESS_ID)s
> > > 4) If UPDATE see item 13
> > > 5) If INSERT then: INSERT INTO "BUSINESS_UNIT"
> > ("BUSINESS_ID",
> > > "CREATE_DT", "CREATE_CID") VALUES (%(BUSINESS_ID)s,
> > > %(CREATE_DT)s, %(CREATE_CID)s
> > > 6) Look to see if any new columns need to be added to
> > > BUSINESS_USER_PROFILE by checking the view, if yes
> then:
> > ALTER
> > > TABLE "BUSINESS_USER_PROFILE" ADD COLUMN "%s"
> VARCHAR(240)
> > NULL
> > > 7) Commit then START TRANSACTION
> > > 8) INSERT the record into the BUSINESS_USER_PROFILE
> table
> > (the
> > > two %s constructs could be any number of columns and
> > values):
> > > INSERT INTO "BUSINESS_USER_PROFILE" (%s) VALUES (%s)
> > > 9) Check to see if the column needs to be inserted or
> > updated
> > > to the stats table: SELECT "COLUMN_NAME" FROM
> > > "BUSINESS_USER_COLUMN_STATS"
> > > 10) Check the view again to see if the column already
> > exists.
> > > 11) If INSERT: INSERT INTO
> "BUSINESS_USER_COLUMN_STATS"
> > > ("COLUMN_NAME", "BUSINESS_ID", "LAST_UPDT_DT",
> > "LAST_UPDT_CID")
> > > VALUES (%(COLUMN_NAME)s, %(BUSINESS_ID)s,
> > %(LAST_UPDT_DT)s,
> > > %(LAST_UPDT_CID)s)
> > > 12) If UPDATE: UPDATE "BUSINESS_USER_COLUMN_STATS"
> SET
> > > "BUSINESS_ID"=%(BUSINESS_ID)s,
> > "LAST_UPDT_DT"=%(LAST_UPDT_DT)s,
> > > "LAST_UPDT_CID"=%(LAST_UPDT_CID)s WHERE
> > > "COLUMN_NAME"=%(COLUMN_NAME)s
> > > 13) Do 6 and 7 above.
> > > 14) UPDATE the record in the BUSINESS_USER_PROFILE
> table
> > (the
> > > two %s constructs could be any number of columns or
> > > conditions): 'UPDATE "BUSINESS_USER_PROFILE" SET %s
> WHERE
> > %s
> > > 15) Do 9, 10, 11, and 12
> > > OK this may be over kill, but I had to think through
> the
> > > process myself before I could answer your question.
> Any
> > select
> > > after doing a sequence of six inserts and six updates
> > would
> > > usually cause the issue. The operative word is
> 'usually',
> > > because sometimes it would work flawlessly.
> > > -Carl
> > > On Mon, Oct 6, 2008 at 1:23 PM, Ross Bates
> >
>
> > > <[EMAIL PROTECTED]> wrote:
> > >
> > > Carl - this bug continues to bother me as well as I
> can't
> > > reproduce the exact steps.
> > > Does your application populate the table in question
> using
> > sql
> > > like this?
> > > insert into foo(col1,col2) (select col1,col2 from
> bar)
> > > Also, do you run any delete statements before
> populating
> > the
> > > data?
> > > I was thinking that the bug was related to the
> > > addition/deletion of columns, but it appears to show
> up
> > more
> > > often after a series of insert/delete statements
> which
> > follow
> > > my alter/create table statements.
> > > On Sun, Oct 5, 2008 at 4:19 PM, Stefan de Konink
> >
>
> > > <[EMAIL PROTECTED]> wrote:
> > >
> > > -----BEGIN PGP SIGNED MESSAGE-----
> > > Hash: SHA512
> > >
> > > Ross Bates schreef:
> > >
> > > > Stefan - what is occurring in the alignment bug you
> are
> > > referring to?
> > >
> > > I had an issue before that occured after I had
> added an
> > > index (that in
> > > MonetDB terms shouldn't do anything), where I was
> able
> > to
> > > make mserver5
> > > crash on a string comparison.
> > > But I know that this was fixed even before I had
> > reported
> > > it.
> > >
> > > Stefan
> > > -----BEGIN PGP SIGNATURE-----
> > > Version: GnuPG v2.0.9 (GNU/Linux)
> > > Comment: Using GnuPG with Mozilla -
> >
>
> > > [6][7][9]http://enigmail.mozdev.org
>
> >
> > >
> > >
> >
> iEYEAREKAAYFAkjpL2AACgkQYH1+F2Rqwn3k9gCeKg+p+n+nQE+dPTLDLnZe
> > > 9OZ9
> > > SIAAnimb0zS4XvWtiKncWEwh3RU7DMJe
> > > =zHeG
> > > -----END PGP SIGNATURE-----
> > >
>
> > >
> > > References
> > >
> > > 1. mailto:[EMAIL PROTECTED]
> > > 2. mailto:[EMAIL PROTECTED]
> >
> > > 3. mailto:[EMAIL PROTECTED]
> > > 4. mailto:[EMAIL PROTECTED]
> > > 5. mailto:[EMAIL PROTECTED]
> > > 6. [16][15]http://enigmail.mozdev.org/
> >
> > > 7. mailto:[EMAIL PROTECTED]
> > > 8. mailto:[EMAIL PROTECTED]
> > > 9. mailto:[EMAIL PROTECTED]
>
> >
> > >
> >
> ---------------------------------------------------------------
> > ----------
> > > This SF.Net email is sponsored by the Moblin Your Move
> > Developer's challenge
> > > Build the coolest Linux based applications with Moblin
> SDK &
> > win great prizes
> > > Grand prize is a trip for two to an Open Source event
> > anywhere in the world
> > >
>
> >
> [20][19]http://moblin-contest.org/redirect.php?banner_id=100
> &url=/
> > > _______________________________________________
> > > Monetdb-developers mailing list
> > > [EMAIL PROTECTED]
> > >
> >
> [22][21]https://lists.sourceforge.net/lists/listinfo/monetdb
> -develo
>
> > pers
> >
> > --
> > Niels Nes, Centre for Mathematics and Computer Science
> (CWI)
> > Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
> > room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312
>
> > url: [23][22]http://www.cwi.nl/~niels e-mail:
> > [EMAIL PROTECTED]
>
> >
>
> >
> > References
> >
> > 1. mailto:[EMAIL PROTECTED]
>
> > 2. mailto:[EMAIL PROTECTED]
>
> > 3. mailto:[EMAIL PROTECTED]
>
> > 4. mailto:[EMAIL PROTECTED]
>
> > 5. mailto:[EMAIL PROTECTED]
> > 6. mailto:[EMAIL PROTECTED]
> > 7. [30]http://enigmail.mozdev.org/
>
> > 8. mailto:[EMAIL PROTECTED]
> > 9. mailto:[EMAIL PROTECTED]
>
> > 10. mailto:[EMAIL PROTECTED]
> > 11. mailto:[EMAIL PROTECTED]
> > 12. mailto:[EMAIL PROTECTED]
> > 13. mailto:[EMAIL PROTECTED]
> > 14. mailto:[EMAIL PROTECTED]
> > 15. mailto:[EMAIL PROTECTED]
> > 16. [39]http://enigmail.mozdev.org/
> > 17. mailto:[EMAIL PROTECTED]
> > 18. mailto:[EMAIL PROTECTED]
> > 19. mailto:[EMAIL PROTECTED]
> > 20.
> [43]http://moblin-contest.org/redirect.php?banner_id=100&url
> =/
> > 21. mailto:[EMAIL PROTECTED]
> > 22.
> [45]https://lists.sourceforge.net/lists/listinfo/monetdb-dev
> elopers
> > 23. [46]http://www.cwi.nl/%7Eniels
> > 24. mailto:[EMAIL PROTECTED]
> > 25. mailto:[EMAIL PROTECTED]
> --
>
> Niels Nes, Centre for Mathematics and Computer Science (CWI)
> Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
> room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312
> url: [49]http://www.cwi.nl/~niels e-mail:
> [EMAIL PROTECTED]
>
> References
>
> 1. mailto:[EMAIL PROTECTED]
> 2. http://mel.yy.cc/
> 3. mailto:[EMAIL PROTECTED]
> 4. mailto:[EMAIL PROTECTED]
> 5. mailto:[EMAIL PROTECTED]
> 6. mailto:[EMAIL PROTECTED]
> 7. mailto:[EMAIL PROTECTED]
> 8. mailto:[EMAIL PROTECTED]
> 9. http://enigmail.mozdev.org/
> 10. mailto:[EMAIL PROTECTED]
> 11. mailto:[EMAIL PROTECTED]
> 12. mailto:[EMAIL PROTECTED]
> 13. mailto:[EMAIL PROTECTED]
> 14. mailto:[EMAIL PROTECTED]
> 15. http://enigmail.mozdev.org/
> 16. mailto:[EMAIL PROTECTED]
> 17. mailto:[EMAIL PROTECTED]
> 18. mailto:[EMAIL PROTECTED]
> 19. http://moblin-contest.org/redirect.php?banner_id=100&url=/
> 20. mailto:[email protected]
> 21. https://lists.sourceforge.net/lists/listinfo/monetdb-develo
> 22. http://www.cwi.nl/%7Eniels
> 23. mailto:[EMAIL PROTECTED]
> 24. mailto:[EMAIL PROTECTED]
> 25. mailto:[EMAIL PROTECTED]
> 26. mailto:[EMAIL PROTECTED]
> 27. mailto:[EMAIL PROTECTED]
> 28. mailto:[EMAIL PROTECTED]
> 29. mailto:[EMAIL PROTECTED]
> 30. http://enigmail.mozdev.org/
> 31. mailto:[EMAIL PROTECTED]
> 32. mailto:[EMAIL PROTECTED]
> 33. mailto:[EMAIL PROTECTED]
> 34. mailto:[EMAIL PROTECTED]
> 35. mailto:[EMAIL PROTECTED]
> 36. mailto:[EMAIL PROTECTED]
> 37. mailto:[EMAIL PROTECTED]
> 38. mailto:[EMAIL PROTECTED]
> 39. http://enigmail.mozdev.org/
> 40. mailto:[EMAIL PROTECTED]
> 41. mailto:[EMAIL PROTECTED]
> 42. mailto:[EMAIL PROTECTED]
> 43. http://moblin-contest.org/redirect.php?banner_id=100&url=/
> 44. mailto:[email protected]
> 45. https://lists.sourceforge.net/lists/listinfo/monetdb-developers
> 46. http://www.cwi.nl/%7Eniels
> 47. mailto:[EMAIL PROTECTED]
> 48. mailto:[EMAIL PROTECTED]
> 49. http://www.cwi.nl/%7Eniels
> 50. mailto:[EMAIL PROTECTED]
>
> ----- End forwarded message -----
>
> --
>
> Niels Nes, Centre for Mathematics and Computer Science (CWI)
> Kruislaan 413, 1098 SJ Amsterdam, The Netherlands
> room C0.02, phone ++31 20 592-4098, fax ++31 20 592-4312
> url: http://www.cwi.nl/~niels e-mail: [EMAIL PROTECTED]
>
--
| Dr. Stefan Manegold | mailto:[EMAIL PROTECTED] |
| CWI, P.O.Box 94079 | http://www.cwi.nl/~manegold/ |
| 1090 GB Amsterdam | Tel.: +31 (20) 592-4212 |
| The Netherlands | Fax : +31 (20) 592-4312 |
-------------------------------------------------------------------------
This SF.Net email is sponsored by the Moblin Your Move Developer's challenge
Build the coolest Linux based applications with Moblin SDK & win great prizes
Grand prize is a trip for two to an Open Source event anywhere in the world
http://moblin-contest.org/redirect.php?banner_id=100&url=/
_______________________________________________
Monetdb-developers mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-developers
