{5} Assigned, Active Tickets by Owner (Full Description) (10 matches)

The sql terminal monitor / shell needs some usage information for new comers to become familiar with it, without the need of reading 100 pages of Ingres manuals.

So here is a patch to svn that will add this functionality.

This enhancement was requested by Andrew Ross.

Looks like we may have a 32 bit file size limit on Mac OS/X. The relevant error is:

VOYAGER_LOCAL     ::[62111             , 12435     ,  0a5f3100]: Tue Apr 29 10:05:56 2008 E_CL0608_DI_BADEXTEND	Error allocating disk space
write() failed with operating system error 27 (File too large)
voyager.::[62111           , 00000001]: Tue Apr 29 10:05:56 2008 File size limit exceeded (SIGXFSZ), see setrlimit(2)

Also, once this has occurred, it appears that the system crashes attempting to recover from the error. An important question concerning this part of the problem is if this indicates a problem in error handling that is not Mac port specific.

VOYAGER_LOCAL     ::[62111             , 12435     ,  00000001]: Tue Apr 29 10:05:56 2008 E_CL2514_CS_ESCAPED_EXCEPTIONAn exception has escaped from user session.  This session will be terminated.
VOYAGER_LOCAL     ::[62111             , 12435     ,  0a5f3100]: Tue Apr 29 10:05:56 2008 E_DM9006_BAD_FILE_WRITE	Disk file write error on database:i126648 table:signatures pathname:/Users/monda07/Downloads/ingres/data/default/i126648 filename:raaad71l.m00 page:262144
write() failed with operating system error 27 (File too large)
VOYAGER_LOCAL     ::[62111             , 12435     ,  0a5f3100]: Tue Apr 29 10:05:56 2008 E_DM933F_DM2F_WRITE_ERROR	Error writing pages for database table.
VOYAGER_LOCAL     ::[62111             , 12435     ,  0a5f3100]: Tue Apr 29 10:05:56 2008 E_DM92F0_DM1X_WRITE_GROUP	Error writing a group of pages while building a table or index.
VOYAGER_LOCAL     ::[62111             , 12435     ,  0a5f3100]: Tue Apr 29 10:05:56 2008 E_DM92E5_DM1X_ALLOCATE	Error allocating a page during build.
VOYAGER_LOCAL     ::[62111             , 12435     ,  0a5f3100]: Tue Apr 29 10:05:56 2008 E_DM92E3_DM1X_NEWPAGE	Error allocating new page for build.
VOYAGER_LOCAL     ::[62109             , 12412     ,  00a064c0]: Tue Apr 29 10:05:57 2008 E_DMA460_LGREAD_EOF_REACHED	The end of the log file has been reached. Log record address <1205960368,13983,0> is past the end (or beginning) of the log file. The log file currently contains log record addresses <1205960368,17533,120> through <1205960368,17546,556>.
voyager.local     ::[62107        IIGCN, 12343     , 00000001]: Tue Apr 29 10:06:01 2008 E_GC0155_GCN_SRV_FAILURE	Registered server failure: class INGRES, address 62111

Following the qs_linux.pdf doc, page 12, indicates how to copy a table into a file, and then copy the file back into the table. However, the commands as given fail when copying the data back into the table. The error received:

1> copy table airport (

ap_id=integer, ap_iatacode=nchar(3) , ap_place=nvarchar(30), ap_name=nvarchar(50), ap_ccode=nchar(2))

FROM 'airport.in'

E_CO0024 COPY: Unexpected END OF FILE while processing row 2.

E_CO002A COPY: Copy has been aborted.

End of Request - Terminated by Errors

I believe this is because the first copy (into the file) is a binary copy, but the second copy (from the file back into the table) is a formatted copy. The correct syntax was found in the DBA guide (dba.pdf) starting age 82 and onwards.

I did a checkout of main from SVN on 20 June 2008 on Red Hat Enterprise Linux Client 5 (Tikanga) and the build process failed using runbuild.sh. The first point of failure shown in the log is copied below.

Link /dcs/pg07/adrianh/workspace/ingres_main/build/bin/iyacc /dcs/pg07/adrianh/workspace/ingres_main/build/lib/libcompat.a(louniq.o): In function `LOuniq': louniq.c:(.text+0x17f): warning: the use of mktemp' is dangerous, better use mkstemp' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `PC' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `tgetflag' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `tgetent' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `UP' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `tputs' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `tgoto' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `tgetnum' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `BC' /usr/lib/gcc/i386-redhat-linux/4.1.1/../../../libreadline.so: undefined reference to `tgetstr' collect2: ld returned 1 exit status

cc -rdynamic -o /dcs/pg07/adrianh/workspace/ingres_main/build/bin/iyacc /dcs/pg07/adrianh/workspace/ingres_main/src/front/tools/yacc/y1.o /dcs/pg07/adrianh/workspace/ingres_main/tools/lib/libyacc.a /dcs/pg07/adrianh/workspace/ingres_main/build/lib/libcompat.a -L/dcs/pg07/adrianh/workspace/ingres_main/build/lib -lpthread -lrt -lm -lc -lcrypt -ldl -lgcc_s -lreadline

...failed

The full log file is attached.

** The Daitch-Mokotoff Soundex algorithm, is an improved soundex algorithm ** more suitable for larger databases where the distinction between names ** such as 'NICHOLS' and 'NICHOLSON' is important. The regular (Russell) ** soundex would have an identical return value (N242) for those words. ** However, the D-M soundex retuns a six character string and its return ** values for those words are indicated in the following table. ** ** The rules of D-M soundex are independent or geographic or ethnic ** considerations - but it has been particularly usefull for Jewish and ** Eastern European Names. ** ** The D-M soundex system is reportedly the standard soundex used by: ** - Jewish genealogical organizations. ** - Hebrew Immigrant Aid Society (HIAS), a social welfare organization, ** - U.S. Holocaust Memorial Museum in Washington, DC. ** - Ellis Island database of 24 million immigrants at the Stephen P. ** Morse Searching the Ellis Island Database in One Step site. ** ** A major difference between the D-M soundex and the Russell soundex is ** the D-M soundex can make distinctions between 'hard' and 'soft' sounds. ** For example, is the 'CH' pronounced soft as in 'Cheese' or hard as in ** 'Christmas'. ** The implementation of the function achieves this by using an optional ** second parameter to indicate the hardness. It defaults to SOFT. The ** second parameter may be 'SOFT, 'S', 'soft' or 's' to indicate soft ** sounds. Any other value will cause it to use the 'Hard' sounds. ** ** Examples: ** Word soundex(Word) soundex_dm(Word) soundex_dm(Word, 'H') ** Nichelle N240 648000 658000 ** Nichols N242 648400 658400 ** Nicholson N242 648460 658460 ** ** Rules on words: ** - The words are converted to uppercase for the soundex generation. ** - Leading and embedded whitespace is ignored. ** - With the exception of the hyphen '-' character, the word(s) are ** terminated by the first non alpha character encountered. ** To allow for hyphenated names, the first hyphen is ignored, but ** subsequent hyphens will be considered terminating characters. ** Hence the following are equivalent (and all return 483784): ** soundex_dm('Claudia Black') ** soundex_dm('Claudia-Black') ** soundex_dm('CLAUDIA-BLACK') ** soundex_dm('CLAUDIA-BLACK.')