Problems Publishing with Pictures and PostgreSQL
Locked
Problems Publishing with Pictures and PostgreSQL
 
|
Today I ran into a problem publishing a form using PostgreSQL. Further inspection revealed that the form fails to publish if there is an image display control on the form with an attached image. The image would save but not publish. Switching to MySQL both saving and publishing failed. But with MySQL the exception in the logs mentioned something about "Packet for query is too large". And I found that both save and publish work fine on MySQL with a smaller image file. PostgreSQL continues to fail publishing even with a smaller image. The top of the stack traces look like this:
and My first guess is that this is symptomatic of another mistake in the PostgreSQL persistence layer, but I'm not sure what it means that saving is successful but publishing fails. Any ideas? Aaron Spike This electronic communication, including any attached documents, may contain confidential and/or legally privileged information that is intended only for use by the recipient(s) named above. If you have received this communication in error, please notify the sender immediately and delete the communication and any attachments. Views expressed by the author do not necessarily represent those of Martin Luther College. -- You received this message because you are subscribed to the Google Groups "Orbeon Forms" group. To unsubscribe from this group and stop receiving emails from it, send an email to [hidden email]. To post to this group, send email to [hidden email]. |
Re: Problems Publishing with Pictures and PostgreSQL
Administrator
|
Hi Aaron,
The MySQL packet size issue is a matter of changing the max_allowed_packet, e.g. in /usr/local/Cellar/mysql/5.6.13/my.cnf, in the [mysqld] section, e.g. adding max_allowed_packet=100M, and restarting the MySQL server. But this is most likely unrelated to the issue you see on PostgreSQL. For the PostgreSQL issue, I would use Charles to see what query fails, exactly, and then debug the relevant code, since the exception by itself doesn't seem to be very useful in this case. Alex
--
Follow Orbeon on Twitter: @orbeon Follow me on Twitter: @avernet |
«
Return to Orbeon Forms community mailing list
|
1 view|%1 views
| Free forum by Nabble | Edit this page |