NPE "null task" under heavy load / RAIDb1 / 1 controller + 2 postgresql nodes
-----------------------------------------------------------------------------
Key: SEQUOIA-966
URL: https://forge.continuent.org/jira/browse/SEQUOIA-966
Project: Sequoia
Type: Bug
Components: Core
Versions: Sequoia 2.9
Environment: Linux dba053.tenroses.com.ar 2.6.18-1.2849.fc6 #1 SMP Fri Nov 10
12:36:14 EST 2006 i686 i686 i386 GNU/Linux
java version "1.5.0_11"
Java(TM) 2 Runtime Environment, Standard Edition (build 1.5.0_11-b03)
Java HotSpot(TM) Client VM (build 1.5.0_11-b03, mixed mode, sharing)
Intel(R) Pentium(R) 4 CPU 3.00GHz Dual Core / 1GB Ram memory
Reporter: Saulo Gil
Running the embedded sql script many times against the controller, in 15 or 20
minutes the controller logs
22:23:32,882 INFO virtualdatabase.VirtualDatabaseWorkerThread.sequoia
Statement.execute() did detect a stored procedure ({call
media_view_insert(55076, null, 244, 1, -110414488
3, null)}) remapping the call to CallableStatement.execute()
22:23:32,883 DEBUG controller.RequestManager.sequoia Write Stored Procedure
(19958) : {call media_view_insert(55076, null, 244...
22:23:32,883 DEBUG sequoia.controller.loadbalancer Request 19958 execute on 2
backends
22:23:32,883 FATAL backend.DatabaseBackend.node2 Unexpected error while
executing task: null task
java.lang.NullPointerException
at
org.continuent.sequoia.controller.requests.StoredProcedure.parse(StoredProcedure.java:488)
at
org.continuent.sequoia.controller.loadbalancer.BackendTaskQueues.fetchNextQueryFromBackendTotalOrderQueue(BackendTaskQueues.java:837)
at
org.continuent.sequoia.controller.loadbalancer.BackendTaskQueues.getNextEntryToExecute(BackendTaskQueues.java:1693)
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:185)
Exception in thread "sequoia - BackendWorkerThread for backend 'node2' with
RAIDb level:1" java.lang.NullPointerException
at
org.continuent.sequoia.controller.loadbalancer.BackendWorkerThread.run(BackendWorkerThread.java:216)
Unfortunately I was not able to reproduce this bug in a deterministic way. This
NPE could happen on any of the other stored procedures calls. Doing a load test
without calling stored procedures seems to work well on my environment.
I've used Jakarta JMeter to run the tests.
Embedded sql script and virtualdatabase conf (sorry but can't attach files on
this interface ...)
{call media_view_insert(1935, null, 42, 1, 1264121101, null)}
{call media_view_insert(69216, null, 41, 1, 1305543287, null)}
UPDATE song SET duration= '00:02:40.000' WHERE id = 1952
{call media_view_insert(61539, null, 102, 1, 1473952043, null)}
{call media_view_insert(204, null, 24, 1, 1429644707, null)}
{call media_view_insert(28564, null, 38, 1, 1429342796, null)}
{call media_view_insert(384, null, 218, 1, -1114625472, null)}
{call usr_add_visit(null, 22301, {ts '2007-07-31 09:06:05.0'}, 1)}
UPDATE song SET duration= '00:03:29.000' WHERE id = 73433
UPDATE song SET duration= '00:03:33.000' WHERE id = 59546
{call media_view_insert(54891, null, 242, 1, -1104049303, null)}
{call usr_add_visit(null, 8709, {ts '2007-07-31 09:06:08.0'}, 1)}
{call media_view_insert(1511, 22788, 6, 1, 1476933659, null)}
{call usr_add_visit(null, 24675, {ts '2007-07-31 09:06:09.0'}, 1)}
{call usr_check_login('[EMAIL PROTECTED]', '', 1)}
{call usr_add_visit(null, 22301, {ts '2007-07-31 09:06:10.0'}, 1)}
UPDATE song SET duration= '00:00:21.000' WHERE id = 30098
{call media_view_insert(56348, null, 281, 1, -936529243, null)}
{call usr_add_visit(null, 18556, {ts '2007-07-31 09:06:23.0'}, 1)}
{call friend_of_request_insert(22788,2273,'2007-07-31 13:10:32.077')}
{call usr_add_visit(null, 19547, {ts '2007-07-31 09:06:24.0'}, 1)}
{call media_view_insert(56547, null, 218, 1, 1135598934, null)}
{call media_view_insert(30098, null, 21, 1, 1429342796, null)}
{call usr_add_visit(null, 23631, {ts '2007-08-01 01:50:22.0'}, 1)}
{call media_view_insert(55802, null, 280, 1, -934418876, null)}
UPDATE song SET duration= '00:04:28.000' WHERE id = 56548
{call usr_add_visit(null, 1768, {ts '2007-07-31 09:06:34.0'}, 1)}
{call usr_add_visit(null, 6717, {ts '2007-07-31 13:10:34.0'}, 1)}
{call media_view_insert(55446, null, 5, 1, -934418876, null)}
{call usr_check_login('[EMAIL PROTECTED]', '270475', 1)}
{call media_view_insert(55076, null, 244, 1, -1104144883, null)}
{call media_view_insert(1931, null, 239, 1, -908729687, null)}
{call media_view_insert(67658, null, 246, 1, 1394826397, null)}
{call media_view_insert(51515, null, 402, 1, -640080518, null)}
UPDATE song SET duration= '00:00:39.000' WHERE id = 28564
UPDATE song SET duration= '00:00:04.000' WHERE id = 74109
{call media_view_insert(708, null, 79, 1, 1396376333, null)}
{call media_view_insert(55906, null, 315, 1, -1104074824, null)}
UPDATE song SET duration= '00:04:00.000' WHERE id = 56301
{call usr_add_visit(null, 23631, {ts '2007-08-01 01:50:30.0'}, 1)}
{call media_view_insert(56253, null, 301, 1, -906310517, null)}
UPDATE song SET duration= '00:03:40.000' WHERE id = 55818
UPDATE song SET duration= '00:04:00.000' WHERE id = 56301
{call media_view_insert(74109, 22309, 1, 1, -934986318, null)}
{call usr_add_visit(null, 9421, {ts '2007-07-31 09:06:59.0'}, 1)}
{call usr_check_login('[EMAIL PROTECTED]', 'xxxxxxxx', 1)}
UPDATE song SET duration= '00:01:07.000' WHERE id = 1412
{call usr_add_visit(null, 9421, {ts '2007-07-31 09:07:03.0'}, 1)}
UPDATE song SET duration= '00:03:17.000' WHERE id = 56037
{call media_view_insert(28564, null, 38, 1, 1429342796, null)}
{call media_view_insert(56231, null, 21, 1, -906308422, null)}
{call media_view_insert(1466, null, 171, 1, 1395328847, null)}
{call usr_add_visit(null, 1714, {ts '2007-07-31 10:47:39.0'}, 1)}
{call media_view_insert(1466, null, 171, 1, 1395328847, null)}
{call usr_add_visit(13181, 9758, {ts '2007-08-01 01:50:47.0'}, 1)}
UPDATE song SET duration= '00:04:33.000' WHERE id = 56341
{call media_view_insert(38, 590, 2, 1, 1256461077, null)}
{call usr_add_visit(null, 9766, {ts '2007-07-31 09:07:14.0'}, 1)}
UPDATE song SET duration= '00:00:02.000' WHERE id = 71833
UPDATE song SET duration= '00:00:21.000' WHERE id = 30098
{call media_view_insert(732, null, 7, 1, 1286285573, null)}
--
{call media_view_insert(3476, 24289, 292, 1, -655287415, null)}
UPDATE collection_item SET item_order = 27 WHERE collection = 48864 AND media
= 56441
{call usr_add_visit(null, 9420, {ts '2007-08-01 02:19:07.0'}, 1)}
UPDATE collection_item SET item_order = 28 WHERE collection = 48864 AND media
= 56525
{call usr_add_visit(null, 5356, {ts '2007-07-31 11:01:20.0'}, 1)}
UPDATE collection_item SET item_order = 29 WHERE collection = 48864 AND media
= 56536
{call media_view_insert(28615, null, 64, 1, -1113975715, null)}
UPDATE collection_item SET item_order = 30 WHERE collection = 48864 AND media
= 56443
{call usr_add_visit(null, 9039, {ts '2007-07-31 11:01:32.0'}, 1)}
UPDATE collection_item SET item_order = 31 WHERE collection = 48864 AND media
= 56568
{call media_view_insert(55452, null, 307, 1, -907574839, null)}
UPDATE collection_item SET item_order = 32 WHERE collection = 48864 AND media
= 56422
UPDATE song SET duration= '00:03:31.000' WHERE id = 56013
UPDATE collection_item SET item_order = 33 WHERE collection = 48864 AND media
= 56526
{call media_view_insert(56525, null, 10, 1, -1115206014, null)}
UPDATE collection_item SET item_order = 34 WHERE collection = 48864 AND media
= 56559
{call media_view_insert(56346, null, 68, 1, -1114283805, null)}
UPDATE collection_item SET item_order = 35 WHERE collection = 48864 AND media
= 56429
{call usr_add_visit(null, 21095, {ts '2007-08-01 02:19:09.0'}, 1)}
UPDATE collection_item SET item_order = 36 WHERE collection = 48864 AND media
= 56435
{call usr_add_visit(17535, 1285, {ts '2007-07-31 11:01:44.0'}, 1)}
UPDATE collection_item SET item_order = 37 WHERE collection = 48864 AND media
= 56531
UPDATE song SET duration= '00:04:33.000' WHERE id = 56525
UPDATE collection_item SET item_order = 38 WHERE collection = 48864 AND media
= 56586
UPDATE song SET duration= '00:03:42.000' WHERE id = 1548
UPDATE collection_item SET item_order = 39 WHERE collection = 48864 AND media
= 56530
UPDATE collection_item SET item_order = 40 WHERE collection = 48864 AND media
= 56561
{call usr_add_visit(null, 9417, {ts '2007-07-31 11:01:52.0'}, 1)}
UPDATE collection_item SET item_order = 41 WHERE collection = 48864 AND media
= 56686
{call media_view_insert(68105, null, 68, 1, -1104099811, null)}
{call media_view_insert(55076, null, 244, 1, -1104144883, null)}
UPDATE collection_item SET item_order = 42 WHERE collection = 48864 AND media
= 56451
{call media_view_insert(56036, null, 637, 1, 1195109177, null)}
UPDATE collection_item SET item_order = 43 WHERE collection = 48864 AND media
= 56564
{call media_view_insert(76312, 17535, 1, 1, 1218081613, null)}
UPDATE collection_item SET item_order = 44 WHERE collection = 48864 AND media
= 56412
{call media_view_insert(60258, null, 202, 1, -1114544502, null)}
UPDATE collection_item SET item_order = 45 WHERE collection = 48864 AND media
= 56475
{call usr_add_visit(null, 1568, {ts '2007-07-31 11:02:04.0'}, 1)}
UPDATE collection_item SET item_order = 46 WHERE collection = 48864 AND media
= 56566
UPDATE song SET duration= '00:03:47.000' WHERE id = 56242
UPDATE collection_item SET item_order = 47 WHERE collection = 48864 AND media
= 56408
{call usr_add_visit(null, 14398, {ts '2007-07-31 11:02:05.0'}, 1)}
UPDATE collection_item SET item_order = 48 WHERE collection = 48864 AND media
= 56456
{call usr_add_visit(null, 9421, {ts '2007-07-31 13:16:43.0'}, 1)}
UPDATE collection_item SET item_order = 49 WHERE collection = 48864 AND media
= 56445
{call media_view_insert(28615, null, 3, 1, 1128211548, null)}
UPDATE collection_item SET item_order = 50 WHERE collection = 48864 AND media
= 56436
{call media_view_insert(68145, null, 119, 1, -1019046348, null)}
UPDATE collection_item SET item_order = 51 WHERE collection = 48864 AND media
= 56533
{call friend_of_request_insert(17535,1285,'2007-07-31 11:02:07.455')}
UPDATE collection_item SET item_order = 52 WHERE collection = 48864 AND media
= 56535
{call usr_add_visit(null, 11264, {ts '2007-07-31 13:16:43.0'}, 1)}
UPDATE collection_item SET item_order = 53 WHERE collection = 48864 AND media
= 56419
UPDATE song SET duration= '00:03:13.000' WHERE id = 56344
UPDATE collection_item SET item_order = 54 WHERE collection = 48864 AND media
= 56522
UPDATE collection_item SET item_order = 55 WHERE collection = 48864 AND media
= 56407
{call usr_save(null,'doble k ','xxxxxxxxxx','[EMAIL
PROTECTED]',null,null,'xxx',983,'xxxxxxxxxxxxxxxxxx','28821',null,null,null,0,1,2,true,true,1)}
UPDATE collection_item SET item_order = 56 WHERE collection = 48864 AND media
= 56415
UPDATE song SET duration= '00:04:00.000' WHERE id = 56301
UPDATE collection_item SET item_order = 57 WHERE collection = 48864 AND media
= 56509
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE SEQUOIA PUBLIC "-//Continuent//DTD SEQUOIA 2.10.6//EN"
"http://sequoia.continuent.org/dtds/sequoia-2.10.6.dtd";>
<SEQUOIA>
<VirtualDatabase name="sequoia">
<Backup>
<Backuper backuperName="Octopus"
className="org.continuent.sequoia.controller.backup.backupers.OctopusBackuper"
options="zip=true" />
<Backuper backuperName="postgres"
className="org.continuent.sequoia.controller.backup.backupers.PostgreSQLPlainTextBackuper"
options="dumpServer=localhost,splitSize=500m" />
</Backup>
<AuthenticationManager>
<Admin>
<User username="admin" password="" />
</Admin>
<VirtualUsers>
<VirtualLogin vLogin="user" vPassword="" />
</VirtualUsers>
</AuthenticationManager>
<DatabaseBackend name="node1" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost/sequoia1" connectionTestStatement="select
1">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="true">
<DefaultStoredProcedureSemantic hasSelect="true" hasInsert="true"
hasUpdate="true"
hasDelete="true" hasDDL="false" hasTransaction="false"
isCausallyDependent="true"
isCommutative="false" />
<StoredProcedureSemantic procedureName="sequoia_rowcounts"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
hasTransaction="false" isCausallyDependent="true" isCommutative="false"
/>
<StoredProcedureSemantic procedureName="sequoia_reload_schema"
parameterCount="0"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="true"
hasTransaction="false" isCausallyDependent="true" isCommutative="false"
/>
<StoredProcedureSemantic procedureName="band_disc_save"
parameterCount="9" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="band_save" parameterCount="15"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_close"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_song_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_song_nominate"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_song_set_permanent"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_vote_save"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_winners_calc"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_winners_recalc"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_add_to_favorites"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_delete" parameterCount="1"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_post_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_post_save"
parameterCount="5" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_post_save"
parameterCount="6" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_remove_from_favorites"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_save" parameterCount="5"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="collection_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="event_save" parameterCount="14"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="fan_of_delete"
parameterCount="2" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="fan_of_insert"
parameterCount="2" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_delete"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_insert"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_request_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_request_insert"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="geo_rule_add_exclusion"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="geo_rule_add_inclusion"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="geo_rule_remove_inclusion"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="insert_contest_song_vote"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="insert_media_comment"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_delete"
parameterCount="1" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_rate_save"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_insert"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_insert"
parameterCount="6"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_save"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="partner_label_save"
parameterCount="8"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="photo_save" parameterCount="13"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="photo_set_as_main"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="photo_update"
parameterCount="4" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_add_item"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_remove_item"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_save"
parameterCount="5"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="sequoia_execute"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="song_add_to_collection"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="song_save" parameterCount="14"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="tr_friend_of_request_insert"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_add_visit"
parameterCount="4" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_answer_save"
parameterCount="5"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_check_login"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_comment_save"
parameterCount="7"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_delete" parameterCount="1"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_detail_save"
parameterCount="5"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_detail_save"
parameterCount="13"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_map_to_partner"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_queue_home_creation"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_queue_mail"
parameterCount="2" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_queue_mail"
parameterCount="1" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_save" parameterCount="19"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_school_save"
parameterCount="9"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_set_cell_index"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_style_save"
parameterCount="32"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="testing.usr_blank_media"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
</DatabaseSchema>
<ConnectionManager vLogin="user" rLogin="pgsql" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<DatabaseBackend name="node2" driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost/sequoia2" connectionTestStatement="select
1">
<DatabaseSchema dynamicPrecision="all" gatherSystemTables="true">
<DefaultStoredProcedureSemantic hasSelect="true" hasInsert="true"
hasUpdate="true"
hasDelete="true" hasDDL="false" hasTransaction="false"
isCausallyDependent="true"
isCommutative="false" />
<StoredProcedureSemantic procedureName="sequoia_rowcounts"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
hasTransaction="false" isCausallyDependent="true" isCommutative="false"
/>
<StoredProcedureSemantic procedureName="sequoia_reload_schema"
parameterCount="0"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="true"
hasTransaction="false" isCausallyDependent="true" isCommutative="false"
/>
<StoredProcedureSemantic procedureName="band_disc_save"
parameterCount="9" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="band_save" parameterCount="15"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_close"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_song_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_song_nominate"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_song_set_permanent"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_vote_save"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_winners_calc"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="battle_zone_winners_recalc"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_add_to_favorites"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_delete" parameterCount="1"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_post_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_post_save"
parameterCount="5" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_post_save"
parameterCount="6" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_remove_from_favorites"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="blog_save" parameterCount="5"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="collection_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="event_save" parameterCount="14"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="fan_of_delete"
parameterCount="2" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="fan_of_insert"
parameterCount="2" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_delete"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_insert"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_request_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="friend_of_request_insert"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="geo_rule_add_exclusion"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="geo_rule_add_inclusion"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="geo_rule_remove_inclusion"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="insert_contest_song_vote"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="insert_media_comment"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_delete"
parameterCount="1" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_rate_save"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_insert"
parameterCount="4"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_insert"
parameterCount="6"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="media_view_save"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="partner_label_save"
parameterCount="8"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="photo_save" parameterCount="13"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="photo_set_as_main"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="photo_update"
parameterCount="4" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_add_item"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_delete"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_remove_item"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="published_set_save"
parameterCount="5"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="sequoia_execute"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="song_add_to_collection"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="song_save" parameterCount="14"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="tr_friend_of_request_insert"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_add_visit"
parameterCount="4" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_answer_save"
parameterCount="5"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_check_login"
parameterCount="3"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_comment_save"
parameterCount="7"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_delete" parameterCount="1"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_detail_save"
parameterCount="5"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_detail_save"
parameterCount="13"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_map_to_partner"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_queue_home_creation"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_queue_mail"
parameterCount="2" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_queue_mail"
parameterCount="1" hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_save" parameterCount="19"
hasSelect="true"
hasInsert="true" hasUpdate="false" hasDelete="false" hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_school_save"
parameterCount="9"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_set_cell_index"
parameterCount="2"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="usr_style_save"
parameterCount="32"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
<StoredProcedureSemantic procedureName="testing.usr_blank_media"
parameterCount="1"
hasSelect="true" hasInsert="true" hasUpdate="false" hasDelete="false"
hasDDL="false"
isCausallyDependent="true" isCommutative="false" />
</DatabaseSchema>
<ConnectionManager vLogin="user" rLogin="pgsql" rPassword="">
<VariablePoolConnectionManager initPoolSize="10" />
</ConnectionManager>
</DatabaseBackend>
<RequestManager>
<RequestScheduler>
<RAIDb-1Scheduler level="passThrough" />
</RequestScheduler>
<RequestCache>
<MetadataCache />
<ParsingCache />
<ResultCache granularity="column" pendingTimeout="2">
<DefaultResultCacheRule>
<!-- <EagerCaching /> -->
<NoCaching />
</DefaultResultCacheRule>
</ResultCache>
</RequestCache>
<LoadBalancer>
<RAIDb-1>
<WaitForCompletion policy="all" />
<RAIDb-1-LeastPendingRequestsFirst />
</RAIDb-1>
</LoadBalancer>
<RecoveryLog driver="org.postgresql.Driver"
url="jdbc:postgresql://localhost/log"
login="pgsql" password="">
<RecoveryLogTable tableName="recovery" logIdColumnType="BIGINT NOT NULL"
vloginColumnType="VARCHAR NOT NULL" sqlColumnType="VARCHAR NOT NULL"
extraStatementDefinition=",PRIMARY KEY (log_id)" />
<CheckpointTable tableName="checkpoint"
checkpointNameColumnType="VARCHAR NOT NULL" />
<BackendTable tableName="backend" databaseNameColumnType="VARCHAR NOT
NULL"
backendNameColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL" />
<DumpTable tableName="dump" dumpNameColumnType="VARCHAR NOT NULL"
dumpDateColumnType="TIMESTAMP" dumpPathColumnType="VARCHAR NOT NULL"
dumpFormatColumnType="VARCHAR NOT NULL"
checkpointNameColumnType="VARCHAR NOT NULL"
backendNameColumnType="VARCHAR NOT NULL" tablesColumnType="VARCHAR NOT
NULL" />
</RecoveryLog>
</RequestManager>
</VirtualDatabase>
</SEQUOIA>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://forge.continuent.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
http://www.atlassian.com/software/jira
_______________________________________________
Sequoia mailing list
[email protected]
https://forge.continuent.org/mailman/listinfo/sequoia
