question

greenspun.com : LUSENET : Catholic : One Thread

Why am I getting the following error everytime I try to post to a specific thread:

We're going to try the insert now...

Ouch!! Here was the bad news from the database:

ora8.c:4901:lob_dml_cmd: error in `OCILobWrite ()': ORA-01691: unable to extend lob segment GREENSPUN.SYS_LOB0000024487C00009$$ by 65 in tablespace GREENSPUN ORA-27059: skgfrsz: could not reduce file size Linux Error: 22: Invalid argument Additional information: 1

SQL: insert into bboard (msg_id,refers_to,topic,originating_ip,email,name,one_line,message,notify,sort_key,posting_time) values ('00AObx','009zYm','Catholic','65.41.85.43','seminarian@ziplip.com','','Response to Masterbation wrong if no lust',empty_clob(),'f','009zYm.1f',sysdate) returning message into :1

Don't quit your browser. You might be able to resubmit your posting five or ten minutes from now.

Thanks for any info

God Bless

-- (seminarian@ziplip.com), January 05, 2003

Answers

Dear seminarian,

This has been happening lately (no-one seems to be sure why) when you try to post a message of any substantial length. Short messages go through ok. Longer ones produce the message you indicated. Then you either have to shorten your message, or split it into two or more posts.

Peace! Paul

-- Paul (PaulCyp@cox.net), January 06, 2003.


Moderation questions? read the FAQ