Hello everyone,
I seem to have a problem adding images to my PostgreSQL database with
mmbase. I use PostgreSQL version 7.3.2 and the driver for jdk1.4 which is
also the installed mmbase version (MMBase 1.6.5-Final.20030829). To store
the image I use a bytea field, not an oid.
in the log, the following is listed before my mmbase crashes:
2003-11-11 18:08:39,087 [Thread-6] INFO context.ContextAuthorization
-create on node #2131 by user: admin (administrator)
2003-11-11 18:08:39,596 [Thread-3] SERVICE mmbase.PAGE -Parsing JSP page:
/ceportalred/mmeditors/jsp/change_node.jsp?node_number=2131
2003-11-11 18:08:39,668 [Thread-3] SERVICE builders.AbstractServletBuilder
-images are served on: /ceportalred/img.db
2003-11-11 18:08:39,673 [Thread-3] INFO builders.ImageCaches -cached node
not found, returning null
2003-11-11 18:08:39,674 [Thread-3] SERVICE builders.Images -getting image
bytes of [2131, s(100x60)]
2003-11-11 18:08:40,232 [ImageConvert] SERVICE builders.ConvertImageMagick
-converted image(#9894 bytes) to 'jpeg'-image(#1624 bytes)('[convert, -,
-geometry, 100x60, jpeg:-]')
2003-11-11 18:08:40,260 [ImageConvert] ERROR support.PostgreSQL71 -error,
could not insert record for builder icaches current field:(8)DEF
GUIName=Size GUIType=integer Input=5 Search=5 List=5 DBname=filesize
DBType=INTEGER DBSTATE=PERSISTENT DBNOTNULL=false DBPos=7 DBSIZE=-1
isKey=false DBDocType=null
2003-11-11 18:08:40,260 [ImageConvert] ERROR support.PostgreSQL71 - SQL
: INSERT INTO install_icaches (number, otype, owner, ckey, id, handle,
filesize) VALUES (?, ?, ?, ?, ?, ?, ?)
2003-11-11 18:08:40,261 [ImageConvert] ERROR support.PostgreSQL71 -
SQLState : null
2003-11-11 18:08:40,261 [ImageConvert] ERROR support.PostgreSQL71 -
ErrorCode: 0
2003-11-11 18:08:40,261 [ImageConvert] ERROR support.PostgreSQL71 -
Message : ERROR: ExecAppend: rejected due to CHECK constraint
install_icaches_id_references
2003-11-11 18:08:40,264 [ImageConvert] ERROR core.MMObjectBuilder
-Failure(java.lang.RuntimeException: java.sql.SQLException: ERROR:
ExecAppend: rejected due to CHECK constraint install_icaches_id_references
) inserting node:
prefix='',otype=2:'29',owner=1:'imagesmodule',filesize=2:'1624',ckey=1:'2131
s(100x60)',number=9:'2132',handle=4:'[EMAIL PROTECTED]',id=9:'2131'
java.lang.RuntimeException: java.sql.SQLException: ERROR: ExecAppend:
rejected due to CHECK constraint install_icaches_id_references
at
org.mmbase.module.database.support.PostgreSQL71.insertRecord(PostgreSQL71.ja
va:679)
at
org.mmbase.module.database.support.PostgreSQL71.insert(PostgreSQL71.java:575
)
at
org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder.java:414)
at org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:176)
at
org.mmbase.module.builders.ImageRequestProcessor.processRequest(ImageRequest
Processor.java:112)
at
org.mmbase.module.builders.ImageRequestProcessor.run(ImageRequestProcessor.j
ava:78)
at java.lang.Thread.run(Thread.java:536)
2003-11-11 18:08:40,265 [ImageConvert] ERROR builders.ImageRequestProcessor
-java.lang.RuntimeException: java.sql.SQLException: ERROR: ExecAppend:
rejected due to CHECK constraint install_icaches_id_references
at
org.mmbase.module.database.support.PostgreSQL71.insertRecord(PostgreSQL71.ja
va:679)
at
org.mmbase.module.database.support.PostgreSQL71.insert(PostgreSQL71.java:575
)
at
org.mmbase.module.core.MMObjectBuilder.insert(MMObjectBuilder.java:414)
at org.mmbase.module.core.MMObjectNode.insert(MMObjectNode.java:176)
at
org.mmbase.module.builders.ImageRequestProcessor.processRequest(ImageRequest
Processor.java:112)
at
org.mmbase.module.builders.ImageRequestProcessor.run(ImageRequestProcessor.j
ava:78)
at java.lang.Thread.run(Thread.java:536)
Can someone please tell me what is wrong or what I should change?
Thank in advance,
Peter van der Meer
Software Developer
[VARA!] Nieuwe Media
Postbus 175
1200 AD Hilversum
http:://www.vara.nl
T +31 (0)35.67.11.383
Disclaimer:
De informatie verzonden met en of in dit e-mail bericht is uitsluitend
bestemd voor de geadresseerde(n). Gebruik van deze informatie door anderen
dan geadresseerde(n) is verboden. Openbaarmaking, vermenigvuldiging,
verspreiding, en/of verstrekking van deze informatie aan derden is NIET
toegestaan. Omroepvereniging VARA staat niet in voor de juiste en volledige
overbrenging van de inhoud van een verzonden e-mail, noch voor tijdige
ontvangst daarvan.
