[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