You are viewing a plain text version of this content. The canonical link for it is here.
Posted to slide-user@jakarta.apache.org by Muhammad Al Sebaeyie <sh...@gmail.com> on 2005/07/25 16:38:53 UTC
Oracle Store Serialization problem
Hi All
We Setup an oracle store on Slide 2.1 Release and then Later 2.2 (latest
from head) working off an oracle JDBC store, after much problems (discussed
somewhere here too ) we contacted oracle and they suggested an upgrade from
9.2.0.1 <http://9.2.0.1> to 9.2.0.5 <http://9.2.0.5>
which made the problem go away, but now I'm hit with multiple 'cant
serialize access to transaction errors'. I've tried to overcome that by
making the application retry multiple times. But this happens a LOT, on PUT,
CHECKOUT, CHECKIN, VERSIONCONTROL, and doesnt have a pattern... and a weird
side effect is that docs get renamed by slide from doc.txt to doc[5].txt or
doc[3].txt or the like.
There is a firewall between the db server and the slide webserver...
Does this have to do with caching or delay from the firewall?
here is part of my stack trace:
http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
"Multi-Status", 10 ms, /files/5/doc.APPL.tif
http-8087-Processor22, 25-Jul-2005 06:54:42, root, GET, 200 "OK", 73 ms,
/files/5/doc.APPL.tif
http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
"Multi-Status", 11 ms, /files/5/doc.APPL.tif
http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
"Multi-Status", 9 ms, /files/5/doc.APPL.tif
http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
"Multi-Status", 10 ms, /files/5/doc.APPL.tif
http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
"Multi-Status", 10 ms, /files/5/doc.APPL.tif
http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
"Multi-Status", 10 ms, /files/5/doc.APPL.tif
http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
"Multi-Status", 10 ms, /files/5/doc.APPL.tif
http-8087-Processor18, 25-Jul-2005 06:55:34, root, PROPFIND, 207
"Multi-Status", 10 ms, /files/5
http-8087-Processor22, 25-Jul-2005 06:55:34, root, PROPFIND, 207
"Multi-Status", 10 ms, /files/5
http-8087-Processor15, 25-Jul-2005 06:55:34, root, PROPFIND, 207
"Multi-Status", 11 ms, /files/5
http-8087-Processor15, 25-Jul-2005 06:55:35, root, CHECKOUT, 200 "OK", 461
ms, /files/5/doc.APPL.tif
25 Jul 2005 06:55:35 -
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR -
java.io.IOException: ORA-08177: can't serialize access for this transaction
java.io.IOException: ORA-08177: can't serialize access for this transaction
at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:716)
at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(
OracleBlobOutputStream.java:279)
at oracle.jdbc.driver.OracleBlobOutputStream.flush(
OracleBlobOutputStream.java:215)
at org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter.storeContent(
OracleRDBMSAdapter.java:157)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(
StandardRDBMSAdapter.java:1113)
at
org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent(
StandardRDBMSAdapter.java:1077)
at org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionContent
(AbstractRDBMSStore.java:852)
at org.apache.slide.store.AbstractStore.storeRevisionContent(
AbstractStore.java:1560)
at org.apache.slide.store.ExtendedStore.storeRevisionContent(
ExtendedStore.java:551)
at org.apache.slide.content.ContentImpl.store(ContentImpl.java:1017)
--
Best Regards,
Muhammad Alsebaey
Re: Oracle Store Serialization problem
Posted by Muhammad Al Sebaeyie <sh...@gmail.com>.
Sorry Correction,
the document names don't change, they stay the same, this was IE/Win XP
Share playing tricks...
On 7/25/05, Muhammad Al Sebaeyie <sh...@gmail.com> wrote:
>
> Hi All
> We Setup an oracle store on Slide 2.1 Release and then Later 2.2 (latest
> from head) working off an oracle JDBC store, after much problems (discussed
> somewhere here too ) we contacted oracle and they suggested an upgrade from
> 9.2.0.1 <http://9.2.0.1> to 9.2.0.5 <http://9.2.0.5>
> which made the problem go away, but now I'm hit with multiple 'cant
> serialize access to transaction errors'. I've tried to overcome that by
> making the application retry multiple times. But this happens a LOT, on PUT,
> CHECKOUT, CHECKIN, VERSIONCONTROL, and doesnt have a pattern... and a weird
> side effect is that docs get renamed by slide from doc.txt to doc[5].txt
> or doc[3].txt or the like.
> There is a firewall between the db server and the slide webserver...
> Does this have to do with caching or delay from the firewall?
>
> here is part of my stack trace:
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
> "Multi-Status", 10 ms, /files/5/doc.APPL.tif
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, GET, 200 "OK", 73 ms,
> /files/5/doc.APPL.tif
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
> "Multi-Status", 11 ms, /files/5/doc.APPL.tif
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
> "Multi-Status", 9 ms, /files/5/doc.APPL.tif
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
> "Multi-Status", 10 ms, /files/5/doc.APPL.tif
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
> "Multi-Status", 10 ms, /files/5/doc.APPL.tif
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
> "Multi-Status", 10 ms, /files/5/doc.APPL.tif
> http-8087-Processor22, 25-Jul-2005 06:54:42, root, PROPFIND, 207
> "Multi-Status", 10 ms, /files/5/doc.APPL.tif
> http-8087-Processor18, 25-Jul-2005 06:55:34, root, PROPFIND, 207
> "Multi-Status", 10 ms, /files/5
> http-8087-Processor22, 25-Jul-2005 06:55:34, root, PROPFIND, 207
> "Multi-Status", 10 ms, /files/5
> http-8087-Processor15, 25-Jul-2005 06:55:34, root, PROPFIND, 207
> "Multi-Status", 11 ms, /files/5
> http-8087-Processor15, 25-Jul-2005 06:55:35, root, CHECKOUT, 200 "OK", 461
> ms, /files/5/doc.APPL.tif
> 25 Jul 2005 06:55:35 -
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter - ERROR -
> java.io.IOException: ORA-08177: can't serialize access for this
> transaction
>
> java.io.IOException: ORA-08177: can't serialize access for this
> transaction
> at oracle.jdbc.dbaccess.DBError.SQLToIOException(DBError.java:716)
> at oracle.jdbc.driver.OracleBlobOutputStream.flushBuffer(
> OracleBlobOutputStream.java:279)
> at oracle.jdbc.driver.OracleBlobOutputStream.flush(
> OracleBlobOutputStream.java:215)
> at org.apache.slide.store.impl.rdbms.OracleRDBMSAdapter.storeContent(
> OracleRDBMSAdapter.java:157)
> at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent
> (StandardRDBMSAdapter.java:1113)
> at
> org.apache.slide.store.impl.rdbms.StandardRDBMSAdapter.storeRevisionContent
> (StandardRDBMSAdapter.java:1077)
> at
> org.apache.slide.store.impl.rdbms.AbstractRDBMSStore.storeRevisionContent(
> AbstractRDBMSStore.java:852)
> at org.apache.slide.store.AbstractStore.storeRevisionContent(
> AbstractStore.java:1560)
> at org.apache.slide.store.ExtendedStore.storeRevisionContent(
> ExtendedStore.java:551)
> at org.apache.slide.content.ContentImpl.store(ContentImpl.java:1017)
>
>
>
>
> --
> Best Regards,
> Muhammad Alsebaey
--
Best Regards,
Muhammad Alsebaey