Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute S_1: BEGIN
- 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from logging.clear_log_id() as result
- 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.unsubscribe_server($1, $2) as result
- 2015-02-25 16:44:51 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '117'
- 2015-02-25 16:44:51 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
- 2015-02-25 16:44:51 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '117', $3 = NULL
- 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
- 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute S_1: BEGIN
- 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: select * from logging.clear_log_id() as result
- 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: select * from rhn_channel.unsubscribe_server($1, $2) as result
- 2015-02-25 16:44:52 CET susemanager susemanager 31445 DETAIL: parameters: $1 = '1000010000', $2 = '117'
- 2015-02-25 16:44:52 CET susemanager susemanager 31445 LOG: execute <unnamed>: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
- 2015-02-25 16:44:52 CET susemanager susemanager 31445 DETAIL: parameters: $1 = '1000010000', $2 = '117', $3 = NULL
- 2015-02-25 16:44:53 CET susemanager susemanager 31446 LOG: execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
- 2015-02-25 16:44:53 CET susemanager susemanager 31446 LOG: execute S_1: BEGIN
- 2015-02-25 16:44:53 CET susemanager susemanager 31446 LOG: execute <unnamed>: select * from rhn_server.update_needed_cache($1) as result
- 2015-02-25 16:44:53 CET susemanager susemanager 31446 DETAIL: parameters: $1 = '1000010000'
- 2015-02-25 16:45:05 CET susemanager susemanager 31423 LOG: statement: rollback;
- 2015-02-25 16:45:06 CET susemanager susemanager 31397 LOG: unexpected EOF on client connection
- 2015-02-25 16:45:06 CET susemanager susemanager 31420 LOG: statement: SELECT format_type(oid,-1) as typname FROM pg_type WHERE oid = 2278
- 2015-02-25 16:45:06 CET susemanager susemanager 31420 LOG: statement: SELECT CASE WHEN typbasetype=0 THEN oid else typbasetype END AS basetype
- FROM pg_type WHERE oid=2278
- 2015-02-25 16:45:10 CET susemanager susemanager 31420 LOG: statement: rollback;
- 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute S_2: COMMIT
- 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute <unnamed>: SELECT NULL AS TABLE_CAT, n.nspname AS TABLE_SCHEM, c.relname AS TABLE_NAME, CASE n.nspname ~ '^pg_' OR n.nspname = 'information_schema' WHEN true THEN CASE WHEN n.nspname = 'pg_catalog' OR n.nspname = 'information_schema' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TABLE' WHEN 'v' THEN 'SYSTEM VIEW' WHEN 'i' THEN 'SYSTEM INDEX' ELSE NULL END WHEN n.nspname = 'pg_toast' THEN CASE c.relkind WHEN 'r' THEN 'SYSTEM TOAST TABLE' WHEN 'i' THEN 'SYSTEM TOAST INDEX' ELSE NULL END ELSE CASE c.relkind WHEN 'r' THEN 'TEMPORARY TABLE' WHEN 'i' THEN 'TEMPORARY INDEX' ELSE NULL END END WHEN false THEN CASE c.relkind WHEN 'r' THEN 'TABLE' WHEN 'i' THEN 'INDEX' WHEN 'S' THEN 'SEQUENCE' WHEN 'v' THEN 'VIEW' ELSE NULL END ELSE NULL END AS TABLE_TYPE, d.description AS REMARKS FROM pg_catalog.pg_namespace n, pg_catalog.pg_class c LEFT JOIN pg_catalog.pg_description d ON (c.oid = d.objoid AND d.objsubid = 0) LEFT JOIN pg_catalog.pg_class dc ON (d.classoid=dc.oid AND dc.relname='pg_class') LEFT JOIN pg_catalog.pg_namespace dn ON (dn.oid=dc.relnamespace AND dn.nspname='pg_catalog') WHERE c.relnamespace = n.oid AND c.relname LIKE 'PROBABLYNOT' AND (false OR ( c.relkind = 'r' AND n.nspname !~ '^pg_' AND n.nspname <> 'information_schema' ) ) ORDER BY TABLE_TYPE,TABLE_SCHEM,TABLE_NAME
- 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute S_1: BEGIN
- 2015-02-25 16:45:11 CET susemanager susemanager 31446 LOG: execute <unnamed>: select * from rhn_server.update_needed_cache($1) as result
- 2015-02-25 16:45:11 CET susemanager susemanager 31446 DETAIL: parameters: $1 = '1000010000'
- 2015-02-25 16:45:11 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.unsubscribe_server($1, $2) as result
- 2015-02-25 16:45:11 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '118'
- 2015-02-25 16:45:11 CET susemanager susemanager 31444 LOG: execute <unnamed>: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
- 2015-02-25 16:45:11 CET susemanager susemanager 31444 DETAIL: parameters: $1 = '1000010000', $2 = '118', $3 = NULL
- 2015-02-25 16:45:12 CET susemanager susemanager 31446 ERROR: deadlock detected
- 2015-02-25 16:45:12 CET susemanager susemanager 31446 DETAIL: Process 31446 waits for ShareLock on transaction 2960664; blocked by process 31444.
- Process 31444 waits for ShareLock on transaction 2960666; blocked by process 31446.
- Process 31446: select * from rhn_server.update_needed_cache($1) as result
- Process 31444: select * from rhn_channel.subscribe_server($1, $2, 1, $3) as result
- 2015-02-25 16:45:12 CET susemanager susemanager 31446 HINT: See server log for query details.
- 2015-02-25 16:45:12 CET susemanager susemanager 31446 CONTEXT: SQL statement "SELECT 1 FROM ONLY "public"."rhnserver" x WHERE "id" OPERATOR(pg_catalog.=) $1 FOR SHARE OF x"
- SQL statement "insert into rhnServerNeededCache
- (server_id, errata_id, package_id, channel_id)
- (select distinct sp.server_id, x.errata_id, p.id, x.channel_id
- FROM (SELECT sp_sp.server_id, sp_sp.name_id,
- sp_sp.package_arch_id, max(sp_pe.evr) AS max_evr
- FROM rhnServerPackage sp_sp
- join rhnPackageEvr sp_pe ON sp_pe.id = sp_sp.evr_id
- GROUP BY sp_sp.server_id, sp_sp.name_id, sp_sp.package_arch_id) sp
- join rhnPackage p ON p.name_id = sp.name_id
- join rhnPackageEvr pe ON pe.id = p.evr_id AND sp.max_evr < pe.evr
- join rhnPackageUpgradeArchCompat puac
- ON puac.package_arch_id = sp.package_arch_id
- AND puac.package_upgrade_arch_id = p.package_arch_id
- join rhnServerChannel sc ON sc.server_id = sp.server_id
- join rhnChannelPackage cp ON cp.package_id = p.id
- AND cp.channel_id = sc.channel_id
- left join (SELECT ep.errata_id, ce.channel_id, ep.package_id
- FROM rhnChannelErrata ce
- join rhnErrataPackage ep
- ON ep.errata_id = ce.errata_id
- join rhnServerChannel sc_sc
- ON sc_sc.channel_id = ce.channel_id
- WHERE sc_sc.server_id = server_id_in) x
- ON x.channel_id = sc.channel_id AND x.package_id = cp.package_id
- where sp.server_id = server_id_in)"
- PL/pgSQL function "update_needed_cache" line 5 at SQL statement
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement