[Postgres-xl-developers] Postgres-XL on SmartOS

Patrick Sodré psodre at gmail.com
Sun Apr 3 21:40:46 PDT 2016


Hi Developers,

In the interest of running Postgres-XL on Joyent’s SmartOS I created a repo here  to track my progress. I created it because after some research the closest I got were 2 posts from Ernest Lee to this mailing list back in February 2015.

By following Ernest Lee’s scripts (https://sourceforge.net/p/postgres-xl/mailman/message/33395098/ <https://sourceforge.net/p/postgres-xl/mailman/message/33395098/>) the code compiles but the regression test fails while trying to create the “regression” database. 

With the patches I made in the branch  ``smartos`` I only have 3/183 tests failing consistently. The first two are in  tsearch.sql and constraints.sql where **despite having an “order by” clause** the results’ order does not match what is expected. The other is in aggregates.sql where there is a difference in the  16th digit of a floating point computation, i.e. not a big deal. You can find the related files are here  https://gist.github.com/sodre/09b9ef4f37da84d185b9ba4694e50127 <https://gist.github.com/sodre/09b9ef4f37da84d185b9ba4694e50127>.

In the inconsistent side during regression tests, I encountered a couple of GTM crashes which once took down a Coordinator with it. You can find the “stack traces” here https://gist.github.com/sodre/4513e56c5c172bab446cc6a752f9087f <https://gist.github.com/sodre/4513e56c5c172bab446cc6a752f9087f> and here https://gist.github.com/sodre/1ac233ff6c70f2217c574aee072ed6d4 <https://gist.github.com/sodre/1ac233ff6c70f2217c574aee072ed6d4>.

Things are much worse with —enable-cassert, 132/181 tests fail. In this case one of the coordinator segfaults during “int2” test and I get a lot of warnings from memory allocated through TupleSort. The related files are here https://gist.github.com/sodre/471742b1ad297f072f0c31d38c80c833 <https://gist.github.com/sodre/471742b1ad297f072f0c31d38c80c833>.

I will continue doing what I can, but could really use help on the stack traces.

Best,
Patrick Sodré

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-developers-postgres-xl.org/attachments/20160404/868f59f9/attachment.htm>


More information about the Postgres-xl-developers mailing list