[Ape] Idle in transaction with psycopg (2)

Marco Bizzarri m.bizzarri at icube.it
Thu Nov 4 03:57:12 EST 2004


Hi all.

Sorry for posting a long file. This is the trace of the operations with ape.

The sequence is as follows:

I've the browser open on the /sql folderl

I add a new Accelerated HTTP Cache Manager, named 'a'.

As you can see, I've a transaction starting and finishing (the one which 
adds the cache manager), and one which opens, but never closes!

Regards
Marco
-------------- next part --------------
Nov  4 09:53:53 legoland postgres[19745]: [170] LOG:  pq_recvbuf: unexpected EOF on client connection
Nov  4 09:54:05 legoland postgres[19760]: [1] LOG:  connection received: host=127.0.0.1 port=49413
Nov  4 09:54:05 legoland postgres[19760]: [2] FATAL:  unsupported frontend protocol
Nov  4 09:54:05 legoland postgres[19761]: [1] LOG:  connection received: host=127.0.0.1 port=49414
Nov  4 09:54:05 legoland postgres[19761]: [2] LOG:  connection authorized: user=postgres database=ape-test
Nov  4 09:54:05 legoland postgres[19761]: [3] LOG:  query: begin; select version(); end
Nov  4 09:54:05 legoland postgres[19761]: [4] LOG:  query: begin; select pg_catalog.pg_client_encoding(); end
Nov  4 09:54:05 legoland postgres[19761]: [5] LOG:  query: SET DATESTYLE TO 'ISO'
Nov  4 09:54:05 legoland postgres[19761]: [6] LOG:  query: BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
Nov  4 09:54:05 legoland postgres[19761]: [7] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [8] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [9] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [10] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [11] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [12] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [13] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [14] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [15] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [16] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [17] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [18] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [19] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [20] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [21] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [22] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [23] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [24] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [25] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [26] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [27] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [28] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [29] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [30] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [31] LOG:  query: SELECT relname FROM pg_class WHERE relkind = 'S' AND relname = 'oid_seq'
Nov  4 09:54:05 legoland postgres[19761]: [32] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [33] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [34] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [35] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [36] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [37] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [38] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [39] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [40] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [41] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [42] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [43] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [44] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [45] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [46] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [47] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [48] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [49] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [50] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'folder_items'
Nov  4 09:54:05 legoland postgres[19761]: [51] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [52] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [53] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [54] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [55] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [56] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [57] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [58] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [59] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [60] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [61] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [62] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [63] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [64] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [65] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [66] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [67] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'folder_items'
Nov  4 09:54:05 legoland postgres[19761]: [68] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [69] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [70] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'folder_items'
Nov  4 09:54:05 legoland postgres[19761]: [71] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [72] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [73] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'folder_items'
Nov  4 09:54:05 legoland postgres[19761]: [74] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [75] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [76] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'classification'
Nov  4 09:54:05 legoland postgres[19761]: [77] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [78] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [79] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [80] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [81] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [82] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [83] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [84] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [85] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [86] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [87] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'folder_items'
Nov  4 09:54:05 legoland postgres[19761]: [88] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'user_domains'
Nov  4 09:54:05 legoland postgres[19761]: [89] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'users'
Nov  4 09:54:05 legoland postgres[19761]: [90] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'user_roles'
Nov  4 09:54:05 legoland postgres[19761]: [91] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [92] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'mtime'
Nov  4 09:54:05 legoland postgres[19761]: [93] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'property_tables'
Nov  4 09:54:05 legoland postgres[19761]: [94] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'properties'
Nov  4 09:54:05 legoland postgres[19761]: [95] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [96] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [97] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [98] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [99] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'remainder'
Nov  4 09:54:05 legoland postgres[19761]: [100] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'object_data'
Nov  4 09:54:05 legoland postgres[19761]: [101] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'security'
Nov  4 09:54:05 legoland postgres[19761]: [102] LOG:  query: SELECT name, child_oid FROM folder_items WHERE objoid = 0
Nov  4 09:54:05 legoland postgres[19761]: [103] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 1
Nov  4 09:54:05 legoland postgres[19761]: [104] LOG:  query: SELECT data FROM object_data WHERE objoid = 0
Nov  4 09:54:05 legoland postgres[19761]: [105] LOG:  query: SELECT name, child_oid FROM folder_items WHERE objoid = 0
Nov  4 09:54:05 legoland postgres[19761]: [106] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 1
Nov  4 09:54:05 legoland postgres[19761]: [107] LOG:  query: SELECT data FROM object_data WHERE objoid = 0
Nov  4 09:54:06 legoland postgres[19761]: [108] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 1
Nov  4 09:54:06 legoland postgres[19761]: [109] LOG:  query: SELECT mtime FROM mtime WHERE objoid = 1
Nov  4 09:54:06 legoland postgres[19761]: [110] LOG:  query: SELECT name, child_oid FROM folder_items WHERE objoid = 1
Nov  4 09:54:06 legoland postgres[19761]: [111] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 3
Nov  4 09:54:06 legoland postgres[19761]: [112] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 2
Nov  4 09:54:06 legoland postgres[19761]: [113] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [114] LOG:  query: SELECT declaration_type, role, permission, username FROM security WHERE objoid = 1
Nov  4 09:54:06 legoland postgres[19761]: [115] LOG:  query: SELECT pickle FROM remainder WHERE objoid = 1
Nov  4 09:54:06 legoland postgres[19761]: [116] LOG:  query: SELECT id, type, data FROM properties WHERE objoid = 1
Nov  4 09:54:06 legoland postgres[19761]: [117] LOG:  query: SELECT table_name FROM property_tables WHERE class_name = 'OFS.Application.Application'
Nov  4 09:54:06 legoland postgres[19761]: [118] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'application_properties'
Nov  4 09:54:06 legoland postgres[19761]: [119] LOG:  query: SELECT title FROM Application_properties WHERE objoid = 1
Nov  4 09:54:06 legoland postgres[19761]: [120] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [121] LOG:  query: SELECT mtime FROM mtime WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [122] LOG:  query: SELECT name, child_oid FROM folder_items WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [123] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 16
Nov  4 09:54:06 legoland postgres[19761]: [124] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 17
Nov  4 09:54:06 legoland postgres[19761]: [125] LOG:  query: SELECT id, type, data FROM properties WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [126] LOG:  query: SELECT table_name FROM property_tables WHERE class_name = 'OFS.Folder.Folder'
Nov  4 09:54:06 legoland postgres[19761]: [127] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'folder_properties'
Nov  4 09:54:06 legoland postgres[19761]: [128] LOG:  query: SELECT title FROM Folder_properties WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [129] LOG:  query: SELECT declaration_type, role, permission, username FROM security WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [130] LOG:  query: SELECT pickle FROM remainder WHERE objoid = 4
Nov  4 09:54:06 legoland postgres[19761]: [131] LOG:  query: SELECT name FROM folder_items WHERE child_oid = '4'
Nov  4 09:54:07 legoland postgres[19761]: [132] LOG:  query: SELECT nextval('oid_seq')
Nov  4 09:54:07 legoland postgres[19761]: [133] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [134] LOG:  query: SELECT mtime FROM mtime WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [135] LOG:  query: SELECT name, child_oid FROM folder_items WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [136] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [137] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 17
Nov  4 09:54:07 legoland postgres[19761]: [138] LOG:  query: SELECT id, type, data FROM properties WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [139] LOG:  query: SELECT title FROM Folder_properties WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [140] LOG:  query: SELECT declaration_type, role, permission, username FROM security WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [141] LOG:  query: SELECT pickle FROM remainder WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [142] LOG:  query: SELECT name FROM folder_items WHERE child_oid = '4'
Nov  4 09:54:07 legoland postgres[19761]: [143] LOG:  query: UPDATE classification SET class_name = 'OFS.Folder.Folder', mapper_name = 'folder' WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [144] LOG:  query: UPDATE mtime SET mtime = 1099558447 WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [145] LOG:  query: SELECT name, child_oid FROM folder_items WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [146] LOG:  query: INSERT INTO folder_items (objoid, name, child_oid) VALUES (4, 'a', 18)
Nov  4 09:54:07 legoland postgres[19761]: [147] LOG:  query: UPDATE Folder_properties SET title = '' WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [148] LOG:  query: DELETE FROM security WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [149-1] LOG:  query: INSERT INTO security (objoid, declaration_type, role, permission, username) VALUES (4, 'executable-owner', '', '',
Nov  4 09:54:07 legoland postgres[19761]: [149-2]  'acl_users/icube')
Nov  4 09:54:07 legoland postgres[19761]: [150-1] LOG:  query: INSERT INTO security (objoid, declaration_type, role, permission, username) VALUES (4, 'local-role', 'Owner', '',
Nov  4 09:54:07 legoland postgres[19761]: [150-2]  'icube')
Nov  4 09:54:07 legoland postgres[19761]: [151-1] LOG:  query: UPDATE remainder SET pickle = '# pickle-base-64 contents:\\012# \'__ZCacheManager_ids__\'\\012#
Nov  4 09:54:07 legoland postgres[19761]: [151-2]  \'__before_publishing_traverse__\'\\012# \'__before_traverse__\'\\012#
Nov  4 09:54:07 legoland postgres[19761]: [151-3]  \'__error_log__\'\\012XXEBKChVFV9fWkNhY2hlTWFuYWdlcl9pZHNfX3ECKFUBYXRxA3RxBChVHl9fYmVmb3JlX3B1Ymxp\\012c2hpbmdfdHJhdmVyc2VfX3EF
Nov  4 09:54:07 legoland postgres[19761]: [151-4] KGNaUHVibGlzaGVyLkJlZm9yZVRyYXZlcnNlCk11bHRpSG9vawpx\\012Bm9xB31xCChVEV9kZWZpbmVkX2luX2NsYXNzcQlJMDAKVQlfaG9va25hbWVxClUeX19iZWZ
Nov  4 09:54:07 legoland postgres[19761]: [151-5] vcmVf\\012cHVibGlzaGluZ190cmF2ZXJzZV9fcQtVBl9wcmlvcnEMTlUFX2xpc3RxDV1xDnVidHEPKFUTX19i\\012ZWZvcmVfdHJhdmVyc2VfX3EQfXERdHESKFUNX
Nov  4 09:54:07 legoland postgres[19761]: [151-6] 19lcnJvcl9sb2dfX3ETVQ9pdGVtczplcnJvcl9s\\012b2dxFFF0cRVlLl1xFi4=\\012' WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [152-1] LOG:  query: INSERT INTO classification (objoid, class_name, mapper_name) VALUES (18,
Nov  4 09:54:07 legoland postgres[19761]: [152-2]  'Products.StandardCacheManagers.AcceleratedHTTPCacheManager.AcceleratedHTTPCacheManager', 'anyfile')
Nov  4 09:54:07 legoland postgres[19761]: [153] LOG:  query: INSERT INTO mtime (objoid, mtime) VALUES (18, 1099558447)
Nov  4 09:54:07 legoland postgres[19761]: [154] LOG:  query: DELETE FROM security WHERE objoid = 18
Nov  4 09:54:07 legoland postgres[19761]: [155-1] LOG:  query: INSERT INTO security (objoid, declaration_type, role, permission, username) VALUES (18, 'local-role', 'Owner', '',
Nov  4 09:54:07 legoland postgres[19761]: [155-2]  'icube')
Nov  4 09:54:07 legoland postgres[19761]: [156-1] LOG:  query: INSERT INTO object_data (objoid, data) VALUES (18, '# pickle-base-64 contents:\\012#
Nov  4 09:54:07 legoland postgres[19761]: [156-2]  \'_AcceleratedHTTPCacheManager__cacheid\'\\012# \'_settings\'\\012#
Nov  4 09:54:07 legoland postgres[19761]: [156-3]  \'title\'\\012XXEBKChVJV9BY2NlbGVyYXRlZEhUVFBDYWNoZU1hbmFnZXJfX2NhY2hlaWRxAlUcMTA5ODY3NTI2\\012NF8xMDk5NTU4NDQ3LjY5NDA4NXEDdHEE
Nov  4 09:54:07 legoland postgres[19761]: [156-4] KFUJX3NldHRpbmdzcQV9cQYoVQhpbnRlcnZhbHEHTRAO\\012VQtub3RpZnlfdXJsc3EIKVUOYW5vbnltb3VzX29ubHlxCUsBdXRxCihVBXRpdGxlcQtVAHRxDGUu\\0
Nov  4 09:54:07 legoland postgres[19761]: [156-5] 12XXENLg==\\012')
Nov  4 09:54:07 legoland postgres[19761]: [157] LOG:  query: SELECT id, type, data FROM properties WHERE objoid = 18
Nov  4 09:54:07 legoland postgres[19761]: [158] LOG:  query: END
Nov  4 09:54:07 legoland postgres[19761]: [159] LOG:  query: BEGIN; SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
Nov  4 09:54:07 legoland postgres[19761]: [160] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 18
Nov  4 09:54:07 legoland postgres[19761]: [161] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 4
Nov  4 09:54:07 legoland postgres[19761]: [162] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [163] LOG:  query: SELECT mtime FROM mtime WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [164] LOG:  query: SELECT name, child_oid FROM folder_items WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [165] LOG:  query: SELECT id, type, data FROM properties WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [166] LOG:  query: SELECT table_name FROM property_tables WHERE class_name = 'Products.BTreeFolder2.BTreeFolder2.BTreeFolder2'
Nov  4 09:54:07 legoland postgres[19761]: [167] LOG:  query: SELECT tablename FROM pg_tables WHERE tablename = 'btreefolder2_properties'
Nov  4 09:54:07 legoland postgres[19761]: [168] LOG:  query: SELECT title FROM BTreeFolder2_properties WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [169] LOG:  query: SELECT declaration_type, role, permission, username FROM security WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [170] LOG:  query: SELECT pickle FROM remainder WHERE objoid = 16
Nov  4 09:54:07 legoland postgres[19761]: [171] LOG:  query: SELECT name FROM folder_items WHERE child_oid = '16'
Nov  4 09:54:07 legoland postgres[19761]: [172] LOG:  query: SELECT class_name, mapper_name FROM classification WHERE objoid = 17
Nov  4 09:54:07 legoland postgres[19761]: [173] LOG:  query: SELECT mtime FROM mtime WHERE objoid = 17
Nov  4 09:54:07 legoland postgres[19761]: [174] LOG:  query: SELECT declaration_type, role, permission, username FROM security WHERE objoid = 17
Nov  4 09:54:07 legoland postgres[19761]: [175] LOG:  query: SELECT data FROM object_data WHERE objoid = 17
Nov  4 09:54:07 legoland postgres[19761]: [176] LOG:  query: SELECT id, type, data FROM properties WHERE objoid = 17
Nov  4 09:54:07 legoland postgres[19761]: [177] LOG:  query: SELECT name FROM folder_items WHERE child_oid = '17'


More information about the Ape mailing list