hi,
In my app, i need first drop table(table1) if exit, then create(table1), last
insert some data .so in my code,
i set jdbc con.setAutoCommit(false).
First i exe sql "drop table table1"
next i exe sql "create table1(col1 ,col2)"
last ....
my app construct on tomcat+hibernate+sequoia2.10.6+postgres2.8.1
but, this failed,in client console,i see err:
---------------------------------------------
1000 Message of cause: Transaction is aborted, cannot execute query CREATE
TABLE TTM (LSH NUMERIC(15) NOT NULL, MBBH NUMERIC(3) NOT NULL,CONSTRAINT PK_TTM
PRIMARY KEY (LSH,MBBH))
---------------------------------------------
any in sequoia's log , i see err:
---------------------------------------------
2007-03-21 03:38:20,012 DEBUG controller.RequestManager.empp Begin transaction
4597
2007-03-21 03:38:20,014 DEBUG controller.RequestManager.empp Broadcasting
request DROP TABLE TTM transaction 4597 to all controllers
(Member(address=/10.0.65.74:33271,
uid=10.0.65.74:33271)->[Member(address=/10.0.65.74:33271,
uid=10.0.65.74:33271)])
2007-03-21 03:38:20,080 DEBUG controller.virtualdatabase.empp
handleMessageSingleThreaded (class org.continuent.sequoia.controller.v
irtualdatabase.protocol.DistributedStatementExecuteUpdate): W 35560 4597 DROP
TABLE TTM
2007-03-21 03:38:20,080 DEBUG controller.virtualdatabase.empp 10.0.65.74:25322:
Scheduling distributedRequest 35560 from Member(addr
ess=/10.0.65.74:33271, uid=10.0.65.74:33271)
2007-03-21 03:38:20,081 DEBUG controller.virtualdatabase.empp
handleMessageMultiThreaded (class org.continuent.sequoia.controller.vi
rtualdatabase.protocol.DistributedStatementExecuteUpdate): W 35560 4597 DROP
TABLE TTM
2007-03-21 03:38:20,081 DEBUG controller.virtualdatabase.empp 10.0.65.74:25322:
Executing distributedRequest 35560 from Member(addre
ss=/10.0.65.74:33271, uid=10.0.65.74:33271)
2007-03-21 03:38:20,092 WARN controller.RequestManager.empp SQLException while
executing distributed write request Unknown table 't
tm' in this DROP statement 'DROP TABLE TTM'
java.sql.SQLException: Unknown table 'ttm' in this DROP statement 'DROP TABLE
TTM'
at
org.continuent.sequoia.controller.requests.DropRequest.parse(DropRequest.java:267)
at
org.continuent.sequoia.controller.cache.parsing.ParsingCache.getParsingFromCacheAndParseIfMissing(ParsingCache.java:307)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.getParsingFromCacheOrParse(RequestManager.java:369)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.scheduleExecWriteRequest(RequestManager.java:809)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.scheduleExecWriteRequest(Distribut
edRequestManager.java:1462)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(Dist
ributedStatementExecuteUpdate.java:84)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedReque
st.java:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtua
lDatabase.java:357)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:102)
2007-03-21 03:38:20,093 WARN controller.virtualdatabase.empp Distributed
request DROP TABLE TTM did not remove itself from the tota
l order queue
2007-03-21 03:38:20,116 DEBUG controller.RequestManager.empp Request DROP TABLE
TTM completed.
2007-03-21 03:38:20,116 WARN controller.RequestManager.empp Request 35560
failed on controller Member(address=/10.0.65.74:33271, ui
d=10.0.65.74:33271) (java.sql.SQLException: Unknown table 'ttm' in this DROP
statement 'DROP TABLE TTM')
2007-03-21 03:38:20,126 DEBUG controller.virtualdatabase.empp
handleMessageSingleThreaded (class org.continuent.sequoia.controller.v
irtualdatabase.protocol.NotifyCompletion): Notify failure of request: DROP
TABLE TTM
2007-03-21 03:38:20,126 DEBUG controller.virtualdatabase.empp 10.0.65.74:25322:
Scheduling distributedRequest 35560 from Member(addr
ess=/10.0.65.74:33271, uid=10.0.65.74:33271)
2007-03-21 03:38:20,126 DEBUG controller.virtualdatabase.empp
handleMessageMultiThreaded (class org.continuent.sequoia.controller.vi
rtualdatabase.protocol.NotifyCompletion): Notify failure of request: DROP TABLE
TTM
2007-03-21 03:38:20,127 DEBUG controller.virtualdatabase.empp 10.0.65.74:25322:
Executing distributedRequest 35560 from Member(addre
ss=/10.0.65.74:33271, uid=10.0.65.74:33271)
2007-03-21 03:38:20,131 WARN controller.RequestManager.empp Request DROP TABLE
TTM failed (Unknown table 'ttm' in this DROP stateme
nt 'DROP TABLE TTM')
2007-03-21 03:38:20,132 DEBUG controller.RequestManager.empp Broadcasting
request abort transaction 4597 to all controllers (Member(
address=/10.0.65.74:33271,
uid=10.0.65.74:33271)->[Member(address=/10.0.65.74:33271,
uid=10.0.65.74:33271)])
2007-03-21 03:38:20,144 DEBUG controller.virtualdatabase.empp
handleMessageSingleThreaded (class org.continuent.sequoia.controller.v
irtualdatabase.protocol.DistributedAbort): Abort transaction 4597
2007-03-21 03:38:20,145 DEBUG controller.virtualdatabase.empp
handleMessageMultiThreaded (class org.continuent.sequoia.controller.vi
rtualdatabase.protocol.DistributedAbort): Abort transaction 4597
2007-03-21 03:38:20,145 DEBUG controller.RequestManager.empp Aborting
transaction 4,597
2007-03-21 03:38:20,147 DEBUG controller.RequestManager.empp Transaction 4,597
aborted
2007-03-21 03:38:20,156 DEBUG controller.RequestManager.empp Request abort
completed.
2007-03-21 03:38:20,157 DEBUG controller.RequestManager.empp Abort of
transaction 4597 completed.
2007-03-21 03:38:20,157 WARN controller.virtualdatabase.empp Request DROP
TABLE TTM failed, transaction has been aborted (Unknown t
able 'ttm' in this DROP statement 'DROP TABLE TTM')
2007-03-21 03:38:20,157 WARN virtualdatabase.VirtualDatabaseWorkerThread.empp
Error during command execution (Unknown table 'ttm' i
n this DROP statement 'DROP TABLE TTM')
2007-03-21 03:38:20,185 WARN virtualdatabase.VirtualDatabaseWorkerThread.empp
Error during command execution (Transaction is aborte
d, cannot execute query CREATE TABLE TTM (LSH NUMERIC(15) NOT NULL, MBBH
NUMERIC(3) NOT NULL,CONSTRAINT PK_TTM PRIMARY KEY (LSH,MBBH
)))
2007-03-21 03:38:20,198 WARN virtualdatabase.VirtualDatabaseWorkerThread.empp
Transaction 4597 was aborted by database
--------------------------------------------------
is this sequoia's issue, or i can take over it by other way?
thanks,
wangtw
[EMAIL PROTECTED]
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
