kCGErrorFailure with BigSQL

So you are trying to start BigSQL on your mac and get the following error:

java[5413] <Error>: kCGErrorFailure: Set a breakpoint 
@ CGErrorBreakpoint() to catch errors as they are logged.

after trying to run the following command:

hadoop namenode -format

The issue may have to do with the combination of your OS and Java version (we saw the error with OS 10.7.4 and Java version 1.6.0_51). We fixed this issue by updating the version of Java to the latest release and changed the definition of JAVA_HOME in setENV.sh in the main BigSQL directory.

Browser Wars 2013

Browser Wars 2013

For the most recent month, see below for the breakouts by Browser, Platform & OS of OpenSCG’s corporate website. From this data it doesn’t take a rocket scientist to conclude that:


  • Microsoft defintely lost the browser & mobile wars
  • Microsoft has NOT lost the OS war (yet)
  • The folks interested in OpenSCG’s content are dweebs
  • Our content is not compelling enough for folks to want to see it from the Smartphones


Summarized by Browser

Google Chrome 40%
Firefox 31%
Internet Explorer 10%
Safari 10%
Android 7%
iOS 5%
BlackBerry .6%
Windows Phone .04%


Summarized by Platform

PC 91%
Mobile 9%


Summarized by OS

Windows 52%
Linux 18%
OSX 17%
Other 3%

Debugging PostgreSQL w Eclipse on OSX

Tonight I worked on getting PostgreSQL running in the Juno Eclipse debugger on Max OSX. It was relatively easy to do by following this Working with Eclipse post on the PostgreSQL wiki site.

The cool thing is that the above Wiki post works nicely even though:

  • It is a Linux example rather than OSX
  • It is for PG version 8.4 rather than PG 9.2
  • It is for an old version of Eclipse Helios rather than Juno

I think this gets to the very heart of what makes PostgreSQL so powerful, efficient and stable.

  1. A superior ANSI C code base that works consistently across all major computing platforms of today (and still runs on many from yesteryear as well).
  2. A large & active community the produces so much great documentation that figuring out how to do advanced stuff is always just a goggle search away for those so inclined.
BigSQL Architecture



From data to information, from information to insight.

A state-of-the-art Big Data Warehouse solution that is fast, secure and continuously available. BigSQL will scale from your desktop to the cloud. Run real time OLAP directly from the worlds most secure RDBMS.

Get started with BigSQL right now.

You can immediately put BigSQL to work on your Relational Data and Big Data. BigSQL is an integrated bundle of:

  • PostgresHA – Highly Available PostgreSQL, the worlds most advanced open source database,
  • Hadoop, the archetypical Big Data solution and
  • Hive, an implementation of relational table abstrations.

BigSQL Architecture.

BigSQL Architecture

This is the core BigSQL engine and together they give you a Highly Available Big Data Warehouse solution.

When you add in components like Enterprise Search (Solr), Streams Processors (Pig), ETL (Sqoop) you have all the components required to analyze real time data directly from PostgreSQL including your NoSQL data in Hadoop.

Linear Scalability.

BigSQL leverages the linear scalability of Hadoop and HDFS across low cost commodity hardware and/or the cloud. It can easily scale to petabytes of information.

Platform Ubiquity.

BigSQL will lay down cleanly in 64 bit Linux (Production) and 64 bit OS X (Development) distros.

 24 x 7.

Every part of your Big Data stack should be hardened. The Hive Relational Metastore in BigSQL is PostgresHA, a Highly Available PostgreSQL implementation that can be set up and distributed exactly the same way that you would any Big Data implementation. You can have Active Standby clusters in the same datacenter but in different racks, you can stream to a remote Disaster Recover node.

Open Source.

Every component of BigSQL is Open Source. Some components serve double duty.

ZooKeeper is used as the distributed coordinator for HDFS and is used as the distributed lock manager in Hive. PostgresSQL, through PostgresHA is the relational metastore in Hive and a Relational Data Warehouse in it’s own right.

Each software component is free and it runs on cheap freely available hardware. If you cobble together enough Raspberry Pi’s, your entire hardware software stack could be open source.


BigSQL is built on PostgreSQL, the worlds most secure RDBMS.

Data Equivalence.

BigSQL gives you equivalent access to your Big Data and Relational Data through psql (the PostgresHA Command Line Interface) and the Hadoop Foreign Data Wrapper.


OpenSCG The people that built BigSQL are here to help, from package customization through on-site consulting to 24 x 7 database administration.


“From data to information, from information to insight.”

Bash Script for setting JAVA_HOME

Bash Script for setting JAVA_HOME on Linux & OSX

jvmVer=`java -version 2>&1 | grep "java version" | awk '{print $3}' | tr -d \"`
if [ ! "$rc" == "0" ]; then
  echo " "
  echo "ERROR: JDK does not appear to be installed."
  exit 3

if [ "x$JAVA_HOME" == "x" ]; then
  if [ "$osName" == "Darwin" ]; then