Parameter "work_mem" requires an integer value

[f4i2u1]

Got this error when trying the csv.load example:

An unhandled error condition has been signalled:
   Database error 22023: parameter "work_mem" requires an integer value
QUERY: SET work_mem TO '12MB'

Date/time: 2014-01-21-01:49An unhandled error condition has been signalled:
                              Database error 22023: parameter "work_mem" requires an integer value
QUERY: SET work_mem TO '12MB'


Backtrace for: #<SB-THREAD:THREAD "main thread" RUNNING {D9F7C51}>
0: ((LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX))
1: (SB-IMPL::CALL-WITH-SANE-IO-SYNTAX #<CLOSURE (LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX) {DFFCBBD}>)
2: (SB-IMPL::%WITH-STANDARD-IO-SYNTAX #<CLOSURE (LAMBDA NIL :IN SB-DEBUG::FUNCALL-WITH-DEBUG-IO-SYNTAX) {DFFCBA5}>)
3: (PRINT-BACKTRACE :STREAM #<SYNONYM-STREAM :SYMBOL SB-SYS:*STDOUT* {91E2F09}> :START 0 :FROM :DEBUGGER-FRAME :COUNT 536870911 :PRINT-THREAD T :PRINT-FRAME-SOURCE NIL :METHOD-FRAME-STYLE NIL)
4: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE-TO-STREAM #<SYNONYM-STREAM :SYMBOL SB-SYS:*STDOUT* {91E2F09}>)
5: (TRIVIAL-BACKTRACE:PRINT-BACKTRACE #<CL-POSTGRES-ERROR:DATA-EXCEPTION {DFF7A31}> :OUTPUT #<SYNONYM-STREAM :SYMBOL SB-SYS:*STDOUT* {91E2F09}> :IF-EXISTS :APPEND :VERBOSE T)
6: (SIGNAL #<CL-POSTGRES-ERROR:DATA-EXCEPTION {DFF7A31}>)
7: (ERROR CL-POSTGRES-ERROR:DATA-EXCEPTION :CODE "22023" :MESSAGE "parameter \"work_mem\" requires an integer value" :DETAIL NIL :HINT NIL :CONTEXT NIL :POSITION NIL)
8: (CL-POSTGRES::GET-ERROR #<SB-SYS:FD-STREAM for "socket 127.0.0.1:33609, peer: 127.0.0.1:5432" {DFF24A1}>)
9: (CL-POSTGRES::LOOK-FOR-ROW #<unavailable argument>)
10: (CL-POSTGRES::SEND-QUERY #<unavailable argument> #<unavailable argument> #<unavailable argument>)
11: ((LABELS #:G508 :IN CL-POSTGRES:EXEC-QUERY))
12: (PGLOADER.PGSQL::SET-SESSION-GUCS (("client_encoding" . "latin1") ("work_mem" . "12MB") ("standard_conforming_strings" . "on")) :TRANSACTION NIL :DATABASE NIL)
13: ((LAMBDA ()))
14: (PGLOADER.PARSER:RUN-COMMANDS #P"csv.load" :START-LOGGER NIL :LOG-FILENAME NIL :LOG-MIN-MESSAGES NIL :CLIENT-MIN-MESSAGES NIL)
15: ((FLET #:CLEANUP-FUN-124 :IN PGLOADER::MAIN)) [cleanup]
16: (PGLOADER::MAIN ("../build/pgloader.exe" "-d" "csv.load"))
17: ((LAMBDA NIL :IN "/root/pgloader-master/dumper-2SKVI5f7.lisp"))
18: ((FLET #:WITHOUT-INTERRUPTS-BODY-44 :IN SAVE-LISP-AND-DIE))
19: ((LABELS SB-IMPL::RESTART-LISP :IN SAVE-LISP-AND-DIE))

2014-01-21T01:49:03.408000-06:00 DEBUG CONNECT
2014-01-21T01:49:03.408000-06:00 DEBUG SET client_encoding TO 'latin1'
2014-01-21T01:49:03.408000-06:00 DEBUG SET work_mem TO '12MB'
2014-01-21T01:49:03.408000-06:00 FATAL We have a situation here.
2014-01-21T01:49:03.408000-06:00 INFO Stopping monitor

debugger invoked on a CL-POSTGRES-ERROR:DATA-EXCEPTION in thread
#<THREAD "main thread" RUNNING {D9F7C51}>:
  Database error 22023: parameter "work_mem" requires an integer value
QUERY: SET work_mem TO '12MB'

[dimitri]

Which version of PostgreSQL are you using? You can get details about that with the following query:

SELECT version();

[f4i2u1]

My bad, it was old version - 8.1
Install PostgreSQL 9.3 and then rebuild SBCL and pgloader and now I'm getting this error when trying to run pgloader:

root@rev [~/pgloader-master/test]# ../build/pgloader.exe -d errors.load
sb-impl::default-external-format :UTF-8
tmpdir: #P"/tmp/pgloader/"

debugger invoked on a UNDEFINED-FUNCTION in thread
#<THREAD "main thread" RUNNING {D9EEC59}>:
The function LPARALLEL.KERNEL::MAKE-SCHEDULER-INSTANCE is undefined.

Type HELP for debugger help, or (SB-EXT:EXIT) to exit from SBCL.

restarts (invokable by number or by possibly-abbreviated name):
0: [ABORT] Exit application

[dimitri]

I think you need to rm -rf ˜/.cache/common-lisp then build again.

[f4i2u1]

Ok, managed to sort it out.
I removed the quicklisp folder and quicklisp.lisp and then run "make pgloader" again.
Finally it worked like a charm! Thanks Dimitri!