Hi,
When I executed the following sql commands, one of the backend got disabled on
the first server, whereas it successfully completed on the second backend on
the second server. This is setup as a RAIDb-1 configuration. It seems to be
compaining about NullPointerException. Any ideas why?
The sql command are as follows:
insert into site_groups (site_group_id,site_group_name) values (61,'Company');
insert into user_site_group (user_id, site_group_id) values (999,61);
insert into sites(site_type, name, site_group_id) values ('company','Company
Showcase',61);
insert into sites(site_type, name, site_group_id) values
('company.oneclip','Company OneClip',61);
The log file has the following errors:
2006-12-26 16:41:42,038 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271662 0 insert into site_groups (site_group_id,site_gr
oup_name) values (61,'Company')
2006-12-26 16:41:42,039 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271662 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,039 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271662 0 insert into site_groups (site_group_id,site_gro
up_name) values (61,'Company')
2006-12-26 16:41:42,039 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271662 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,040 DEBUG sequoia.controller.recoverylog Logging request 164
2006-12-26 16:41:42,041 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[32] - INSERT INTO reporting_securityREC
OVERY VALUES(164,'user','insert into site_groups
(site_group_id,site_group_name) values
(61,\'Company\')',null,'A',0,1688849860271662,'E',1
,0)
2006-12-26 16:41:42,042 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Scheduling request insert
into site_groups (site_group_
id,site_group_name) values (61,'Company') in non conflicting queue
2006-12-26 16:41:42,042 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Adding task Autocommit
StatementExecuteUpdateTask 16888
49860263937 (insert into site_groups (site_group_id,site_group_name) values
(61,'Company')) to pending request queue
2006-12-26 16:41:42,042 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Executing task Autocommit
StatementExecuteUpdateTask 16
88849860263937 (insert into site_groups (site_group_id,site_group_name) values
(61,'Company'))
2006-12-26 16:41:42,047 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Task Autocommit
StatementExecuteUpdateTask 168884986026
3937 (insert into site_groups (site_group_id,site_group_name) values
(61,'Company')) completed
2006-12-26 16:41:42,047 DEBUG sequoia.controller.recoverylog Logging request 164
2006-12-26 16:41:42,047 WARN controller.RequestManager.REPORTINGSECURITYDBPROD
Failed to execute request insert into site_groups (site_gro
up_id,s... because of (null)
java.lang.NullPointerException
at java.lang.String.compareTo(Unknown Source)
at
org.continuent.sequoia.controller.cache.result.schema.CacheDatabaseSchema.getTable(CacheDatabaseSchema.java:144)
at
org.continuent.sequoia.controller.cache.result.ResultCacheTable.processWriteNotify(ResultCacheTable.java:87)
at
org.continuent.sequoia.controller.cache.result.ResultCache.writeNotify(ResultCache.java:829)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.updateAndNotifyExecWriteRequest(RequestManager.java:1048)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(Distributed
StatementExecuteUpdate.java:89)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java
:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDataba
se.java:335)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99)
2006-12-26 16:41:42,048 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[33] - UPDATE reporting_securityRECOVERY
SET exec_status='S',update_count=1,exec_time=7 WHERE log_id=164
2006-12-26 16:41:42,049 WARN controller.RequestManager.REPORTINGSECURITYDBPROD
SQLException while executing distributed write request Fail
ed to execute request insert into site_groups (site_group_id,s... because of
(null)
java.sql.SQLException: Failed to execute request insert into site_groups
(site_group_id,s... because of (null)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.updateAndNotifyExecWriteRequest(RequestManager.java:1168)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate.executeScheduledRequest(Distributed
StatementExecuteUpdate.java:89)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java
:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDataba
se.java:335)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99)
2006-12-26 16:41:42,152 WARN controller.RequestManager.REPORTINGSECURITYDBPROD
Request 1688849860271662 failed on controller Member(addres
s=/192.168.5.150:33057:33057, uid=REPORTINGSECURITYDBPROD)
(java.sql.SQLException: Failed to execute request insert into site_groups (site_
group_id,s... because of (null))
2006-12-26 16:41:42,189 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into site_groups (site_group_id,site_group_name) v
alues (61,'Company')
2006-12-26 16:41:42,189 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271662 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,189 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into site_groups (site_group_id,site_group_name) va
lues (61,'Company')
2006-12-26 16:41:42,189 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271662 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,190 DEBUG sequoia.controller.recoverylog Logging request 164
2006-12-26 16:41:42,190 WARN controller.RequestManager.REPORTINGSECURITYDBPROD
Failed to notify scheduler for request insert into site_gro
ups (site_group_id,site_group_name) values (61,'Company')
java.sql.SQLException: Query 1688849860271662 is not in the list of currently
scheduled queries
at
org.continuent.sequoia.controller.scheduler.AbstractScheduler.writeCompleted(AbstractScheduler.java:536)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.logRequestCompletionAndNotifyScheduler(Di
stributedRequestManager.java:554)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.completeFailedOnAllBackends(DistributedRe
questManager.java:683)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.NotifyCompletion.executeScheduledRequest(NotifyCompletion.java:101)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java
:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDataba
se.java:335)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99)
2006-12-26 16:41:42,190 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[33] - UPDATE reporting_securityRECOVERY
SET exec_status='S',update_count=1,exec_time=1 WHERE log_id=164
2006-12-26 16:41:42,190 ERROR controller.RequestManager.REPORTINGSECURITYDBPROD
Request insert into site_groups (site_group_id,s... failed
on all local backends but succeeded on other controllers. Disabling all local
backends.
2006-12-26 16:41:42,197 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Database backend
db-alpha.globixny1-reporting-security
is now in state sequoia.virtualdatabase.backend.disabled
2006-12-26 16:41:42,199 INFO controller.RequestManager.REPORTINGSECURITYDBPROD
Setting new virtual database schema.
2006-12-26 16:41:42,200 INFO sequoia.controller.cache Removing table user
2006-12-26 16:41:42,200 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Stopping 5 worker threads
of backend db-alpha.globixny1
-reporting-security
2006-12-26 16:41:42,200 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Adding task
KillThreadTask to pending request queue
2006-12-26 16:41:42,200 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Adding task
KillThreadTask to pending request queue
2006-12-26 16:41:42,200 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Executing task
KillThreadTask
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Adding task
KillThreadTask to pending request queue
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security REPORTINGSECURITYDBPROD -
BackendWorkerThread for backe
nd 'db-alpha.globixny1-reporting-security' with RAIDb level:1 is shutting down
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Adding task
KillThreadTask to pending request queue
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Executing task
KillThreadTask
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Task KillThreadTask
completed
2006-12-26 16:41:42,202 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Adding task
KillThreadTask to pending request queue
2006-12-26 16:41:42,202 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Executing task
KillThreadTask
2006-12-26 16:41:42,202 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security REPORTINGSECURITYDBPROD -
BackendWorkerThread for backe
nd 'db-alpha.globixny1-reporting-security' with RAIDb level:1 is shutting down
2006-12-26 16:41:42,202 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Task KillThreadTask
completed
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Executing task
KillThreadTask
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security REPORTINGSECURITYDBPROD -
BackendWorkerThread for backe
nd 'db-alpha.globixny1-reporting-security' with RAIDb level:1 is shutting down
2006-12-26 16:41:42,202 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security REPORTINGSECURITYDBPROD -
BackendWorkerThread for backe
nd 'db-alpha.globixny1-reporting-security' with RAIDb level:1 is shutting down
2006-12-26 16:41:42,202 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Task KillThreadTask
completed
2006-12-26 16:41:42,203 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Task KillThreadTask
completed
2006-12-26 16:41:42,201 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Executing task
KillThreadTask
2006-12-26 16:41:42,203 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security REPORTINGSECURITYDBPROD -
BackendWorkerThread for backe
nd 'db-alpha.globixny1-reporting-security' with RAIDb level:1 is shutting down
2006-12-26 16:41:42,203 DEBUG
DatabaseBackend.db-alpha.globixny1-reporting-security Task KillThreadTask
completed
2006-12-26 16:41:42,204 INFO sequoia.controller.connection 1 connections freed
on "jdbc:mysql://db-alpha.globixny1:3306/reporting_security
?autoReconnect=true"
2006-12-26 16:41:42,315 INFO controller.RequestManager.REPORTINGSECURITYDBPROD
Backend db-alpha.globixny1-reporting-security is now disabl
ed
2006-12-26 16:41:42,393 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271663 0 insert into user_site_group (user_id, site_gro
up_id) values (999,61)
2006-12-26 16:41:42,394 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271663 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,394 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271663 0 insert into user_site_group (user_id, site_grou
p_id) values (999,61)
2006-12-26 16:41:42,394 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271663 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,395 DEBUG sequoia.controller.recoverylog Logging request 165
2006-12-26 16:41:42,395 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[32] - INSERT INTO reporting_securityREC
OVERY VALUES(165,'user','insert into user_site_group (user_id, site_group_id)
values (999,61)',null,'A',0,1688849860271663,'E',0,0)
2006-12-26 16:41:42,499 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into user_site_group (user_id, site_group_id) valu
es (999,61)
2006-12-26 16:41:42,500 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271663 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,500 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into user_site_group (user_id, site_group_id) value
s (999,61)
2006-12-26 16:41:42,500 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271663 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,500 DEBUG sequoia.controller.recoverylog Logging request 165
2006-12-26 16:41:42,501 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[33] - UPDATE reporting_securityRECOVERY
SET exec_status='S',update_count=1,exec_time=0 WHERE log_id=165
2006-12-26 16:41:42,576 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271664 0 insert into sites(site_type, name, site_group_
id) values ('company','Company Showcase',61)
2006-12-26 16:41:42,576 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271664 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,576 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271664 0 insert into sites(site_type, name, site_group_i
d) values ('company','Company Showcase',61)
2006-12-26 16:41:42,576 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271664 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,577 DEBUG sequoia.controller.recoverylog Logging request 166
2006-12-26 16:41:42,577 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[32] - INSERT INTO reporting_securityREC
OVERY VALUES(166,'user','insert into sites(site_type, name, site_group_id)
values (\'company\',\'Company Showcase\',61)',null,'A',0,1688849
860271664,'E',1,0)
2006-12-26 16:41:42,680 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into sites(site_type, name, site_group_id) values
('company','Company Showcase',61)
2006-12-26 16:41:42,681 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271664 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,681 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into sites(site_type, name, site_group_id) values (
'company','Company Showcase',61)
2006-12-26 16:41:42,681 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271664 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,681 DEBUG sequoia.controller.recoverylog Logging request 166
2006-12-26 16:41:42,682 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[33] - UPDATE reporting_securityRECOVERY
SET exec_status='S',update_count=1,exec_time=0 WHERE log_id=166
2006-12-26 16:41:42,756 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271665 0 insert into sites(site_type, name, site_group_
id) values ('company.oneclip','Company OneClip',61)
2006-12-26 16:41:42,756 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271665 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,756 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.DistributedStatementExecuteUpdate): W
1688849860271665 0 insert into sites(site_type, name, site_group_i
d) values ('company.oneclip','Company OneClip',61)
2006-12-26 16:41:42,756 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271665 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,757 DEBUG sequoia.controller.recoverylog Logging request 167
2006-12-26 16:41:42,757 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[32] - INSERT INTO reporting_securityREC
OVERY VALUES(167,'user','insert into sites(site_type, name, site_group_id)
values (\'company.oneclip\',\'Company OneClip\',61)',null,'A',0,
1688849860271665,'E',0,0)
2006-12-26 16:41:42,862 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageSingleThreaded
(class org.continuent.sequoia.
controller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into sites(site_type, name, site_group_id) values
('company.oneclip','Company OneClip',61)
2006-12-26 16:41:42,862 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Scheduling distributedRequest 1688849
860271665 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,862 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD handleMessageMultiThreaded
(class org.continuent.sequoia.c
ontroller.virtualdatabase.protocol.NotifyCompletion): Notify success of
request: insert into sites(site_type, name, site_group_id) values (
'company.oneclip','Company OneClip',61)
2006-12-26 16:41:42,862 DEBUG
controller.virtualdatabase.REPORTINGSECURITYDBPROD 192.168.5.150:25322:
Executing distributedRequest 16888498
60271665 from Member(address=/192.168.5.150:33057:33057,
uid=REPORTINGSECURITYDBPROD)
2006-12-26 16:41:42,862 DEBUG sequoia.controller.recoverylog Logging request 167
2006-12-26 16:41:42,863 DEBUG sequoia.controller.recoverylog
com.mysql.jdbc.ServerPreparedStatement[33] - UPDATE reporting_securityRECOVERY
SET exec_status='S',update_count=1,exec_time=0 WHERE log_id=167
2006-12-26 16:41:43,144 WARN sequoia.controller.cache Unable to remove pending
query user,SELECT user_id, first_name, last_name, title, em
ail, organization FROM user where email='[EMAIL PROTECTED]' and
password='MjoWPT49OjA6KSk='
2006-12-26 16:41:43,288 WARN sequoia.controller.cache Unable to remove pending
query user,select sg.site_group_name, s.name, s.site_type f
rom site_groups sg, sites s, user_site_group usg where usg.user_id = 1001 and
usg.site_group_id = sg.site_group_id and s.site_group_id = sg
.site_group_id order by sg.site_group_name, s.name
2006-12-26 16:41:54,504 WARN sequoia.controller.cache Unable to remove pending
query user,SELECT user_id, first_name, last_name, title, em
ail, organization FROM user where email='[EMAIL PROTECTED]' and
password='MjoWPT49OjA6KSk='
2006-12-26 16:41:54,612 WARN controller.RequestManager.REPORTINGSECURITYDBPROD
An error occured while executing remote select request 1688
849860271668
java.sql.SQLException: Query 1688849860271668 is not in the list of currently
scheduled queries
at
org.continuent.sequoia.controller.scheduler.AbstractScheduler.readCompleted(AbstractScheduler.java:457)
at
org.continuent.sequoia.controller.requestmanager.RequestManager.statementExecuteQuery(RequestManager.java:637)
at
org.continuent.sequoia.controller.requestmanager.distributed.DistributedRequestManager.execLocalStatementExecuteQuery(Distribute
dRequestManager.java:1347)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.ExecRemoteStatementExecuteQuery.executeScheduledRequest(ExecRemoteSta
tementExecuteQuery.java:95)
at
org.continuent.sequoia.controller.virtualdatabase.protocol.DistributedRequest.handleMessageMultiThreaded(DistributedRequest.java
:157)
at
org.continuent.sequoia.controller.virtualdatabase.DistributedVirtualDatabase.handleMessageMultiThreaded(DistributedVirtualDataba
se.java:335)
at
org.continuent.hedera.adapters.MulticastRequestAdapterThread.run(MulticastRequestAdapterThread.java:99)
2006-12-26 16:41:54,612 WARN
controller.virtualdatabase.REPORTINGSECURITYDBPROD Request '1688849860271668'
failed (Query 1688849860271668
is not in the list of currently scheduled queries)
2006-12-26 16:41:54,613 WARN
virtualdatabase.VirtualDatabaseWorkerThread.REPORTINGSECURITYDBPROD Error
during command execution (Query 168
8849860271668 is not in the list of currently scheduled queries)
2006-12-26 16:42:54,709 WARN sequoia.controller.cache Unable to remove pending
query user,SELECT user_id, first_name, last_name, title, em
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
