Skip to content

Instantly share code, notes, and snippets.

@samuell

samuell/gist:1481827

Created December 15, 2011 16:50
Show Gist options
  • Save samuell/1481827 to your computer and use it in GitHub Desktop.
Save samuell/1481827 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Test Errors on iRODS 3.0 install on Ubutnu 11.10 (32bit)
Raw
gistfile1.txt
Finishing the iRODS setup
------------------------------------------------------------------------
Thu Dec 15 17:41:58 2011
Script:
Script: ./scripts/perl/finishSetup.pl
CWD: /home/samuel/opt/irods
Perl:
Perl path: /usr/bin/perl
Perl version: 5.012004
System:
OS: Linux
User: samuel
User ID: 1000
Host name: samuel-hp
Host addresses: 127.0.0.1 130.238.138.20
Environment:
XAUTHORITY = /home/samuel/.Xauthority
XDG_CURRENT_DESKTOP = Unity
UBUNTU_MENUPROXY = libappmenu.so
PGUSER = irods
XDG_SEAT_PATH = /org/freedesktop/DisplayManager/Seat0
MANDATORY_PATH = /usr/share/gconf/ubuntu.mandatory.path
GNOME_KEYRING_CONTROL = /tmp/keyring-yrBU7c
SSH_AUTH_SOCK = /tmp/keyring-yrBU7c/ssh
LESSOPEN = | /usr/bin/lesspipe %s
PWD = /home/samuel/opt/irods
LANG = en_US.UTF-8
USER = samuel
XDG_CONFIG_DIRS = /etc/xdg/xdg-ubuntu:/etc/xdg
GNOME_DESKTOP_SESSION_ID = this-is-deprecated
LOGNAME = samuel
LESSCLOSE = /usr/bin/lesspipe %s %s
SHLVL = 2
XDG_SESSION_COOKIE = 5ba1e59cabe3ed6917e40d3800000004-1323938443.66794-172781963
XDG_SESSION_PATH = /org/freedesktop/DisplayManager/Session0
PGDATA = /home/samuel/opt/postgres/pgsql/data
PATH = .:/home/samuel/opt/irods/clients/icommands/bin:/home/samuel/opt/postgres/pgsql/bin:.:/home/samuel/opt/irods/clients/icommands/bin:/usr/lib/lightdm/lightdm:/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/usr/games:/home/samuel/opt/irods/clients/icommands/bin/:/home/samuel/opt/irods/clients/fuse/bin/:/home/samuel/opt/irods/:/home/samuel/scripts:/home/samuel/program/eclipse-rcp-helios/:/home/samuel/opt/irods/clients/icommands/bin/:/home/samuel/opt/irods/clients/fuse/bin/:/home/samuel/opt/irods/:/home/samuel/scripts:/home/samuel/program/eclipse-rcp-helios/
WINDOWID = 79691782
GTK_MODULES = canberra-gtk-module:canberra-gtk-module
COLORTERM = gnome-terminal
IBUS_ENABLE_SYNC_MODE = 1
TERM = screen
HOME = /home/samuel
DBUS_SESSION_BUS_ADDRESS = unix:abstract=/tmp/dbus-znX9PhrM75,guid=8a5d4de87cf22d0f0017cd6c000001e0
GNOME_KEYRING_PID = 1835
SSH_AGENT_PID = 1886
LD_LIBRARY_PATH = /home/samuel/opt/postgres/pgsql/lib:/usr/lib/globus/lib:/usr/local/lib:/usr/local/lib
DISPLAY = :0.0
COMPIZ_CONFIG_PROFILE = ubuntu
GDMSESSION = ubuntu
EDITOR = /usr/bin/nano
DEFAULTS_PATH = /usr/share/gconf/ubuntu.default.path
WINDOW = 1
USERNAME = samuel
STY = 3984.pts-0.samuel-hp
OLDPWD = /home/samuel/opt/irods
XDG_DATA_DIRS = /usr/share/ubuntu:/usr/share/gnome:/usr/local/share/:/usr/share/
PGPASSWORD = ******
DESKTOP_SESSION = ubuntu
_ = ./irodssetup
LS_COLORS = rs=0:di=01;34:ln=01;36:mh=00:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31;01:su=37;41:sg=30;43:ca=30;41:tw=30;42:ow=34;42:st=37;44:ex=01;32:*.tar=01;31:*.tgz=01;31:*.arj=01;31:*.taz=01;31:*.lzh=01;31:*.lzma=01;31:*.tlz=01;31:*.txz=01;31:*.zip=01;31:*.z=01;31:*.Z=01;31:*.dz=01;31:*.gz=01;31:*.lz=01;31:*.xz=01;31:*.bz2=01;31:*.bz=01;31:*.tbz=01;31:*.tbz2=01;31:*.tz=01;31:*.deb=01;31:*.rpm=01;31:*.jar=01;31:*.rar=01;31:*.ace=01;31:*.zoo=01;31:*.cpio=01;31:*.7z=01;31:*.rz=01;31:*.jpg=01;35:*.jpeg=01;35:*.gif=01;35:*.bmp=01;35:*.pbm=01;35:*.pgm=01;35:*.ppm=01;35:*.tga=01;35:*.xbm=01;35:*.xpm=01;35:*.tif=01;35:*.tiff=01;35:*.png=01;35:*.svg=01;35:*.svgz=01;35:*.mng=01;35:*.pcx=01;35:*.mov=01;35:*.mpg=01;35:*.mpeg=01;35:*.m2v=01;35:*.mkv=01;35:*.ogm=01;35:*.mp4=01;35:*.m4v=01;35:*.mp4v=01;35:*.vob=01;35:*.qt=01;35:*.nuv=01;35:*.wmv=01;35:*.asf=01;35:*.rm=01;35:*.rmvb=01;35:*.flc=01;35:*.avi=01;35:*.fli=01;35:*.flv=01;35:*.gl=01;35:*.dl=01;35:*.xcf=01;35:*.xwd=01;35:*.yuv=01;35:*.cgm=01;35:*.emf=01;35:*.axv=01;35:*.anx=01;35:*.ogv=01;35:*.ogx=01;35:*.aac=00;36:*.au=00;36:*.flac=00;36:*.mid=00;36:*.midi=00;36:*.mka=00;36:*.mp3=00;36:*.mpc=00;36:*.ogg=00;36:*.ra=00;36:*.wav=00;36:*.axa=00;36:*.oga=00;36:*.spx=00;36:*.xspf=00;36:
SHELL = /bin/bash
PGPORT = 5434
GPG_AGENT_INFO = /tmp/keyring-yrBU7c/gpg:0:1
SESSION_MANAGER = local/samuel-hp:@/tmp/.ICE-unix/1844,unix/samuel-hp:/tmp/.ICE-unix/1844
TERMCAP = SC|screen|VT 100/ANSI X3.64 virtual terminal:\
:DO=\E[%dB:LE=\E[%dD:RI=\E[%dC:UP=\E[%dA:bs:bt=\E[Z:\
:cd=\E[J:ce=\E[K:cl=\E[H\E[J:cm=\E[%i%d;%dH:ct=\E[3g:\
:do=^J:nd=\E[C:pt:rc=\E8:rs=\Ec:sc=\E7:st=\EH:up=\EM:\
:le=^H:bl=^G:cr=^M:it#8:ho=\E[H:nw=\EE:ta=^I:is=\E)0:\
:li#40:co#180:am:xn:xv:LP:sr=\EM:al=\E[L:AL=\E[%dL:\
:cs=\E[%i%d;%dr:dl=\E[M:DL=\E[%dM:dc=\E[P:DC=\E[%dP:\
:im=\E[4h:ei=\E[4l:mi:IC=\E[%d@:ks=\E[?1h\E=:\
:ke=\E[?1l\E>:vi=\E[?25l:ve=\E[34h\E[?25h:vs=\E[34l:\
:ti=\E[?1049h:te=\E[?1049l:us=\E[4m:ue=\E[24m:so=\E[3m:\
:se=\E[23m:mb=\E[5m:md=\E[1m:mr=\E[7m:me=\E[m:ms:\
:Co#8:pa#64:AF=\E[3%dm:AB=\E[4%dm:op=\E[39;49m:AX:\
:vb=\Eg:G0:as=\E(0:ae=\E(B:\
:ac=\140\140aaffggjjkkllmmnnooppqqrrssttuuvvwwxxyyzz{{||}}~~..--++,,hhII00:\
:po=\E[5i:pf=\E[4i:k0=\E[10~:k1=\EOP:k2=\EOQ:k3=\EOR:\
:k4=\EOS:k5=\E[15~:k6=\E[17~:k7=\E[18~:k8=\E[19~:\
:k9=\E[20~:k;=\E[21~:F1=\E[23~:F2=\E[24~:F3=\E[1;2P:\
:F4=\E[1;2Q:F5=\E[1;2R:F6=\E[1;2S:F7=\E[15;2~:\
:F8=\E[17;2~:F9=\E[18;2~:FA=\E[19;2~:kb=:K2=\EOE:\
:kB=\E[Z:kF=\E[1;2B:kR=\E[1;2A:*4=\E[3;2~:*7=\E[1;2F:\
:#2=\E[1;2H:#3=\E[2;2~:#4=\E[1;2D:%c=\E[6;2~:%e=\E[5;2~:\
:%i=\E[1;2C:kh=\E[1~:@1=\E[1~:kH=\E[4~:@7=\E[4~:\
:kN=\E[6~:kP=\E[5~:kI=\E[2~:kD=\E[3~:ku=\EOA:kd=\EOB:\
:kr=\EOC:kl=\EOD:km:
Script versions:
utils_platform.pl = September 2011
utils_print.pl = March 2010
utils_paths.pl = September 2011
finishSetup.pl = Oct 2010
utils_config.pl = September 2011
utils_file.pl = September 2011
Preparing to initialize...
------------------------------------------------------------------------
Thu Dec 15 17:41:58 2011
Stopping iRODS server...
Skipped. Server already stopped.
Starting database server...
Configuring database user...
------------------------------------------------------------------------
Thu Dec 15 17:42:06 2011
Updating user's .pgpass...
Skipped. File already uptodate.
Creating Postgres database user...
Creating database and tables...
------------------------------------------------------------------------
Thu Dec 15 17:42:06 2011
Checking whether iCAT database exist...
Creating iCAT database...
Updating Postgres UNIX ODBC odbc.ini configuration
Updating user's .odbc.ini...
Setting database user password...
alter user "irods" with password '******';
alter user irods set client_encoding to LATIN1;
Creating iCAT tables...
List of existing tables (if any):
No relations found.
Converting zone name in icatSysInserts.sql
Converting SQL to postgres form.
Inserting ICAT tables...
icatCoreTables.sql...
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
icatSysTables.sql...
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE SEQUENCE
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
icatCoreInserts.sql...
INSERT 0 1
icatSysInserts.sql...
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
Configuring database security...
------------------------------------------------------------------------
Thu Dec 15 17:42:07 2011
Updating Postgres pg_hba.conf...
Removing old pg_hba.conf...
Replacing with new pg_hba.conf...
Testing database communications with test_cll...
LOG_SQL: pid: 28357 sql: begin
LOG_SQL: pid: 28357 result: SUCCESS
LOG_SQL: pid: 28357 sql: SET SESSION autocommit=0
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: SET SESSION sql_mode='ANSI,STRICT_TRANS_TABLES'
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: create table test (i integer, j integer, a varchar(32))
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: insert into test values (2, 3, 'a')
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: commit
LOG_SQL: pid: 28357 result: SUCCESS
LOG_SQL: pid: 28357 sql: begin
LOG_SQL: pid: 28357 result: SUCCESS
LOG_SQL: pid: 28357 sql: bad sql
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: rollback
LOG_SQL: pid: 28357 result: SUCCESS
LOG_SQL: pid: 28357 sql: begin
LOG_SQL: pid: 28357 result: SUCCESS
LOG_SQL: pid: 28357 sql: delete from test where i = 1
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: commit
LOG_SQL: pid: 28357 result: SUCCESS
LOG_SQL: pid: 28357 sql: SQLPrepare
LOG_SQL: pid: 28357 sql: bindVar1=a
LOG_SQL: pid: 28357 sql: select * from test where a = ?
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: SQLPrepare
LOG_SQL: pid: 28357 sql: bindVar1=2
LOG_SQL: pid: 28357 sql: select * from test where i = ?
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: begin
LOG_SQL: pid: 28357 result: SUCCESS
LOG_SQL: pid: 28357 sql: drop table test;
LOG_SQL: pid: 28357 result: SQL_ERROR
LOG_SQL: pid: 28357 sql: commit
LOG_SQL: pid: 28357 result: SUCCESS
userName=irods
password=******
One or more tests DID NOT complete normally
Tests failed.
Abort.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment