Re: [sqlite] Core dumps on AIX with optimization
If you are using the verson of Sqlite in one big file you are expecting a lot from the optimizer. I would never compile Sqlite that way, instead do it the normal way and link the optimized. code. Also make sure you remove the -g option which interferes with some AIX linking. My experience with IBM's Xlc is that it has a very aggressive optimizer and will produce optimized code of high quality, running on one of my tests 40% better than gcc code. I would not compile large files with it. Ribeiro, Glauber wrote: > Unfortunately gcc is not an option right now. > I wouldn't be very surprised if it turned out to be that the very large > source file is overwhelming IBM's optimizer. So far the non-optimized > compiles of sqlite3 are working fine. > > -Original Message- > From: John Stanton [mailto:[EMAIL PROTECTED] > Sent: Monday, September 22, 2008 11:34 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Core dumps on AIX with optimization > > We use gcc. > > Ribeiro, Glauber wrote: >> This issue continues with version 3.6.2 >> >> g >> >> -Original Message- >> From: Ribeiro, Glauber >> Sent: Friday, September 19, 2008 11:55 AM >> To: General Discussion of SQLite Database >> Subject: [sqlite] Core dumps on AIX with optimization >> >> Just wondering, are there other AIX Sqlite users out there, and what >> have you done in order to get a successful compile? >> >> I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the >> command line utility sqlite2 dumps core when running SQL that contains >> an aggregation function, if it was compiled with any level of >> optimization. It seems to work fine if C optimization is turned off. >> >> I reported this at http://www.sqlite.org/cvstrac/tktview?tn=3344,2 >> (ticket 3344), and at least one more person reported seeing the same >> problem. >> >> I'm not worried about the lack of optimization, just thinking that > this >> may be caused by an underlying problem in the C code. >> >> Thanks, >> >> glauber >> >> ___ >> sqlite-users mailing list >> sqlite-users@sqlite.org >> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Core dumps on AIX with optimization
We use gcc. Ribeiro, Glauber wrote: > This issue continues with version 3.6.2 > > g > > -Original Message- > From: Ribeiro, Glauber > Sent: Friday, September 19, 2008 11:55 AM > To: General Discussion of SQLite Database > Subject: [sqlite] Core dumps on AIX with optimization > > Just wondering, are there other AIX Sqlite users out there, and what > have you done in order to get a successful compile? > > I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the > command line utility sqlite2 dumps core when running SQL that contains > an aggregation function, if it was compiled with any level of > optimization. It seems to work fine if C optimization is turned off. > > I reported this at http://www.sqlite.org/cvstrac/tktview?tn=3344,2 > (ticket 3344), and at least one more person reported seeing the same > problem. > > I'm not worried about the lack of optimization, just thinking that this > may be caused by an underlying problem in the C code. > > Thanks, > > glauber > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Core dumps on AIX with optimization
This issue continues with version 3.6.2 g -Original Message- From: Ribeiro, Glauber Sent: Friday, September 19, 2008 11:55 AM To: General Discussion of SQLite Database Subject: [sqlite] Core dumps on AIX with optimization Just wondering, are there other AIX Sqlite users out there, and what have you done in order to get a successful compile? I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the command line utility sqlite2 dumps core when running SQL that contains an aggregation function, if it was compiled with any level of optimization. It seems to work fine if C optimization is turned off. I reported this at http://www.sqlite.org/cvstrac/tktview?tn=3344,2 (ticket 3344), and at least one more person reported seeing the same problem. I'm not worried about the lack of optimization, just thinking that this may be caused by an underlying problem in the C code. Thanks, glauber ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Core dumps on AIX with optimization
I use sqlite on AIX, but compile using gcc. Can you try the gcc compiler instead? --- On Fri, 9/19/08, Ribeiro, Glauber <[EMAIL PROTECTED]> wrote: From: Ribeiro, Glauber <[EMAIL PROTECTED]> Subject: [sqlite] Core dumps on AIX with optimization To: "General Discussion of SQLite Database" <sqlite-users@sqlite.org> Date: Friday, September 19, 2008, 11:55 AM Just wondering, are there other AIX Sqlite users out there, and what have you done in order to get a successful compile? I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the command line utility sqlite2 dumps core when running SQL that contains an aggregation function, if it was compiled with any level of optimization. It seems to work fine if C optimization is turned off. I reported this at http://www.sqlite.org/cvstrac/tktview?tn=3344,2 (ticket 3344), and at least one more person reported seeing the same problem. I'm not worried about the lack of optimization, just thinking that this may be caused by an underlying problem in the C code. Thanks, glauber ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Core dumps on AIX with optimization
We use Sqlite on AIX and discovered that when compiling with gcc we have to remove the debug -g from the makefiles No optimization issues. We always link statically. Ribeiro, Glauber wrote: > Just wondering, are there other AIX Sqlite users out there, and what > have you done in order to get a successful compile? > > I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the > command line utility sqlite2 dumps core when running SQL that contains > an aggregation function, if it was compiled with any level of > optimization. It seems to work fine if C optimization is turned off. > > I reported this at http://www.sqlite.org/cvstrac/tktview?tn=3344,2 > (ticket 3344), and at least one more person reported seeing the same > problem. > > I'm not worried about the lack of optimization, just thinking that this > may be caused by an underlying problem in the C code. > > Thanks, > > glauber > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Core dumps on AIX with optimization
Just wondering, are there other AIX Sqlite users out there, and what have you done in order to get a successful compile? I found out that on our AIX 5.2, with IBM's Visual Age C v9.0, the command line utility sqlite2 dumps core when running SQL that contains an aggregation function, if it was compiled with any level of optimization. It seems to work fine if C optimization is turned off. I reported this at http://www.sqlite.org/cvstrac/tktview?tn=3344,2 (ticket 3344), and at least one more person reported seeing the same problem. I'm not worried about the lack of optimization, just thinking that this may be caused by an underlying problem in the C code. Thanks, glauber ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users