I find it interesting that this happened right after a restart of the database. you may want to do a spacewalk-data-fsck
On Thu, Jul 17, 2014 at 7:03 PM, sirin <ar...@e-inet.ru> wrote: > hmm… > > data from /var/lib/pgsql/data/pg_log/postgresql-Fri.log > > 2014-07-18 00:40:18.750 MSK LOG: received fast shutdown request > 2014-07-18 00:40:18.750 MSK LOG: aborting any active transactions > 2014-07-18 00:40:18.750 MSK LOG: autovacuum launcher shutting down > 2014-07-18 00:40:18.754 MSK LOG: shutting down > 2014-07-18 00:40:32.141 MSK LOG: database system is shut down > 2014-07-18 00:40:37.899 MSK LOG: database system was shut down at 2014-07-18 > 00:40:32 MSK > 2014-07-18 00:40:38.078 MSK LOG: database system is ready to accept > connections > 2014-07-18 00:40:38.079 MSK LOG: autovacuum launcher started > 2014-07-18 01:37:53.832 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 01:37:53.832 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (2879, (select id from rhnChecksumType > where label = 'sha256'), > '81bff035d495ee67f779edb98bebab8a4b112721e46bd3124450b11c79c90477') > 2014-07-18 01:37:53.839 MSK ERROR: query returned no rows > 2014-07-18 01:37:53.839 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 01:37:53.839 MSK STATEMENT: select lookup_checksum(E'sha256', > E'81bff035d495ee67f779edb98bebab8a4b112721e46bd3124450b11c79c90477') id from > dual > 2014-07-18 01:37:57.767 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 01:37:57.767 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (2935, (select id from rhnChecksumType > where label = 'sha256'), > '711ba25b47743a4d1630ff823a4c096fa63d25bb84921f2d1cdedfe7eb329e54') > 2014-07-18 01:37:57.768 MSK ERROR: query returned no rows > 2014-07-18 01:37:57.768 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 01:37:57.768 MSK STATEMENT: select lookup_checksum(E'sha256', > E'711ba25b47743a4d1630ff823a4c096fa63d25bb84921f2d1cdedfe7eb329e54') id from > dual > 2014-07-18 01:42:23.951 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 01:42:23.951 MSK STATEMENT: select 1 > 2014-07-18 01:42:28.665 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 01:42:28.665 MSK STATEMENT: select 1 > 2014-07-18 01:59:27.544 MSK ERROR: duplicate key value violates unique > constraint "rhn_pkg_cap_name_version_uq" > 2014-07-18 01:59:27.544 MSK STATEMENT: insert into rhnPackageCapability(id, > name, version) values (19338, 'boost-devel(x86-64)', '1.41.0-18.el6') > 2014-07-18 01:59:27.558 MSK ERROR: query returned no rows > 2014-07-18 01:59:27.558 MSK CONTEXT: PL/pgSQL function > "lookup_package_capability" line 34 at SQL statement > 2014-07-18 01:59:27.558 MSK STATEMENT: select > lookup_package_capability(E'boost-devel(x86-64)', E'1.41.0-18.el6') as id > from dual > 2014-07-18 02:00:15.387 MSK ERROR: duplicate key value violates unique > constraint "rhn_pkg_cap_name_version_uq" > 2014-07-18 02:00:15.387 MSK STATEMENT: insert into rhnPackageCapability(id, > name, version) values (20353, 'boost-python-devel', '1.41.0-18.el6') > 2014-07-18 02:00:15.389 MSK ERROR: query returned no rows > 2014-07-18 02:00:15.389 MSK CONTEXT: PL/pgSQL function > "lookup_package_capability" line 34 at SQL statement > 2014-07-18 02:00:15.389 MSK STATEMENT: select > lookup_package_capability(E'boost-python-devel', E'1.41.0-18.el6') as id from > dual > 2014-07-18 02:05:42.545 MSK ERROR: duplicate key value violates unique > constraint "rhn_pn_name_uq" > 2014-07-18 02:05:42.545 MSK STATEMENT: insert into rhnPackageName(id, name) > values (214, 'boost-devel') > 2014-07-18 02:05:42.546 MSK ERROR: query returned no rows > 2014-07-18 02:05:42.546 MSK CONTEXT: PL/pgSQL function "lookup_package_name" > line 20 at SQL statement > 2014-07-18 02:05:42.546 MSK STATEMENT: select > LOOKUP_PACKAGE_NAME(E'boost-devel') id from dual > 2014-07-18 02:06:18.339 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:06:18.339 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (10914, (select id from rhnChecksumType > where label = 'sha256'), > '3dbc381a76778d34cd4e9f3ac0ba4eaf0fc39f30300c3cf705aaf2904e40a313') > 2014-07-18 02:06:18.341 MSK ERROR: query returned no rows > 2014-07-18 02:06:18.341 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:06:18.341 MSK STATEMENT: select lookup_checksum(E'sha256', > E'3dbc381a76778d34cd4e9f3ac0ba4eaf0fc39f30300c3cf705aaf2904e40a313') id from > dual > 2014-07-18 02:06:31.426 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:06:31.426 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (11108, (select id from rhnChecksumType > where label = 'sha256'), > '380065ad87ddd9c7fa0cfe267c6333c0443493f4eef8dcf1df955387f0003c5e') > 2014-07-18 02:06:31.428 MSK ERROR: query returned no rows > 2014-07-18 02:06:31.428 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:06:31.428 MSK STATEMENT: select lookup_checksum(E'sha256', > E'380065ad87ddd9c7fa0cfe267c6333c0443493f4eef8dcf1df955387f0003c5e') id from > dual > 2014-07-18 02:10:31.975 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:10:31.975 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (14811, (select id from rhnChecksumType > where label = 'sha256'), > '21fe61cde5d055a691e1d69cb97bd2359b25a5137611fd449b67afb5899c561b') > 2014-07-18 02:10:31.976 MSK ERROR: query returned no rows > 2014-07-18 02:10:31.976 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:10:31.976 MSK STATEMENT: select lookup_checksum(E'sha256', > E'21fe61cde5d055a691e1d69cb97bd2359b25a5137611fd449b67afb5899c561b') id from > dual > 2014-07-18 02:10:42.714 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:10:42.714 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (14956, (select id from rhnChecksumType > where label = 'sha256'), > '637d64a90096ac466a84a6830fc6b12e7f999e5ce702d147855cb367b7e95f6f') > 2014-07-18 02:10:42.715 MSK ERROR: query returned no rows > 2014-07-18 02:10:42.715 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:10:42.715 MSK STATEMENT: select lookup_checksum(E'sha256', > E'637d64a90096ac466a84a6830fc6b12e7f999e5ce702d147855cb367b7e95f6f') id from > dual > 2014-07-18 02:10:55.984 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:10:55.984 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (15118, (select id from rhnChecksumType > where label = 'sha256'), > '135bd367f7615dd4610fbef5f04e40e69b8490fe3d56d6e0a9282884f8ade945') > 2014-07-18 02:10:55.986 MSK ERROR: query returned no rows > 2014-07-18 02:10:55.986 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:10:55.986 MSK STATEMENT: select lookup_checksum(E'sha256', > E'135bd367f7615dd4610fbef5f04e40e69b8490fe3d56d6e0a9282884f8ade945') id from > dual > 2014-07-18 02:11:14.090 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.091 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.159 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.161 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.163 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.164 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.192 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.196 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.203 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.205 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.208 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.211 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.211 MSK LOG: could not receive data from client: > Connection reset by peer > 2014-07-18 02:11:14.211 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.218 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.223 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.228 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:11:14.237 MSK LOG: unexpected EOF on client connection > 2014-07-18 02:18:54.515 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:18:54.515 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (18161, (select id from rhnChecksumType > where label = 'sha256'), > 'be4bb5576a46303f7e64b80ab297827e4f32654500768a8a4bdd4a0081afa581') > 2014-07-18 02:18:54.516 MSK ERROR: query returned no rows > 2014-07-18 02:18:54.516 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:18:54.516 MSK STATEMENT: select lookup_checksum(E'sha256', > E'be4bb5576a46303f7e64b80ab297827e4f32654500768a8a4bdd4a0081afa581') id from > dual > 2014-07-18 02:19:02.494 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:19:02.494 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (18287, (select id from rhnChecksumType > where label = 'sha256'), > 'a87de4d3db1eab8195465010c57e9625e1f320fdf75a413e4afd24f2309217cb') > 2014-07-18 02:19:02.495 MSK ERROR: query returned no rows > 2014-07-18 02:19:02.495 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:19:02.495 MSK STATEMENT: select lookup_checksum(E'sha256', > E'a87de4d3db1eab8195465010c57e9625e1f320fdf75a413e4afd24f2309217cb') id from > dual > 2014-07-18 02:22:40.970 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 02:22:40.970 MSK STATEMENT: select 1 > 2014-07-18 02:22:59.758 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 02:22:59.758 MSK STATEMENT: select 1 > 2014-07-18 02:26:03.426 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:26:03.426 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (20827, (select id from rhnChecksumType > where label = 'sha256'), > '260df5aeb9c0a564e93d21d8b301372706b48e0dc76ae62de0835c597189149b') > 2014-07-18 02:26:03.427 MSK ERROR: query returned no rows > 2014-07-18 02:26:03.427 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:26:03.427 MSK STATEMENT: select lookup_checksum(E'sha256', > E'260df5aeb9c0a564e93d21d8b301372706b48e0dc76ae62de0835c597189149b') id from > dual > 2014-07-18 02:26:09.723 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:26:09.723 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (20912, (select id from rhnChecksumType > where label = 'sha256'), > '3691ca156779f016677743f32a2073aed7bb037ad8c09f23ac66e9050f56ee73') > 2014-07-18 02:26:09.724 MSK ERROR: query returned no rows > 2014-07-18 02:26:09.724 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:26:09.724 MSK STATEMENT: select lookup_checksum(E'sha256', > E'3691ca156779f016677743f32a2073aed7bb037ad8c09f23ac66e9050f56ee73') id from > dual > 2014-07-18 02:34:43.440 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 02:34:43.440 MSK STATEMENT: select 1 > 2014-07-18 02:34:58.949 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 02:34:58.949 MSK STATEMENT: select 1 > 2014-07-18 02:49:40.285 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:49:40.285 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (27411, (select id from rhnChecksumType > where label = 'sha256'), > '868ad1309c2fe18b4c68157b25b62bd95a9e4c41a39f502a17febdf1b3eb984f') > 2014-07-18 02:49:40.286 MSK ERROR: query returned no rows > 2014-07-18 02:49:40.286 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:49:40.286 MSK STATEMENT: select lookup_checksum(E'sha256', > E'868ad1309c2fe18b4c68157b25b62bd95a9e4c41a39f502a17febdf1b3eb984f') id from > dual > 2014-07-18 02:49:46.299 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:49:46.299 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (27507, (select id from rhnChecksumType > where label = 'sha256'), > '5b43cc518811dbed9ad8a5bddfdf28a647cab18a67285c713cbdd5b4a06b8c4f') > 2014-07-18 02:49:46.300 MSK ERROR: query returned no rows > 2014-07-18 02:49:46.300 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:49:46.300 MSK STATEMENT: select lookup_checksum(E'sha256', > E'5b43cc518811dbed9ad8a5bddfdf28a647cab18a67285c713cbdd5b4a06b8c4f') id from > dual > 2014-07-18 02:52:27.358 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 02:52:27.358 MSK STATEMENT: select 1 > 2014-07-18 02:52:31.639 MSK ERROR: current transaction is aborted, commands > ignored until end of transaction block > 2014-07-18 02:52:31.639 MSK STATEMENT: select 1 > 2014-07-18 02:58:32.316 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:58:32.316 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (31223, (select id from rhnChecksumType > where label = 'sha256'), > 'fc15a81113ffb95666fbfc471c512b7256e6bf1e863737334fd1583e2ce2e8a9') > 2014-07-18 02:58:32.319 MSK ERROR: query returned no rows > 2014-07-18 02:58:32.319 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:58:32.319 MSK STATEMENT: select lookup_checksum(E'sha256', > E'fc15a81113ffb95666fbfc471c512b7256e6bf1e863737334fd1583e2ce2e8a9') id from > dual > 2014-07-18 02:58:39.265 MSK ERROR: duplicate key value violates unique > constraint "rhnchecksum_chsum_uq" > 2014-07-18 02:58:39.265 MSK STATEMENT: insert into rhnChecksum (id, > checksum_type_id, checksum) values (31323, (select id from rhnChecksumType > where label = 'sha256'), > '2781936d94b405f487dbbf8cdf3e551875621ac84484336583285cefdd6d4e3b') > 2014-07-18 02:58:39.267 MSK ERROR: query returned no rows > 2014-07-18 02:58:39.267 MSK CONTEXT: PL/pgSQL function "lookup_checksum" > line 23 at SQL statement > 2014-07-18 02:58:39.267 MSK STATEMENT: select lookup_checksum(E'sha256', > E'2781936d94b405f487dbbf8cdf3e551875621ac84484336583285cefdd6d4e3b') id from > dual > > Artem > > 18 июля 2014 г., в 2:49, Paul Robert Marino <prmari...@gmail.com> написал(а): > >> PostgreSQL closed the connection for some reason. look at the >> PostgreSQL logs for answers >> >> On Thu, Jul 17, 2014 at 6:32 PM, sirin <ar...@e-inet.ru> wrote: >>> hi, >>> >>> how i can fix this? >>> >>> ~]# rhnpush -v —channel=<channel-name> --server=http://<hostname>/APP >>> --dir=/mnt/Packages/ >>> >>> … >>> Waiting 3 seconds and trying again... >>> Uploading package /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm >>> Using POST request >>> Internal server error 500 Internal Server Error >>> Error pushing /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm: (500) >>> Waiting 4 seconds and trying again... >>> Uploading package /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm >>> Using POST request >>> Internal server error 500 Internal Server Error >>> Error pushing /mnt/Packages/cim-schema-2.22.0-2.1.el6.noarch.rpm: (500) >>> Waiting 4 seconds and trying again... >>> Giving up after 3 attempts >>> … >>> >>> from /var/log/httpd/error_log >>> >>> … >>> Fri Jul 18 02:22:40 2014] [error] Spacewalk 1530 2014/07/18 02:22:40 >>> +04:00: ("DATABASE CONNECTION TO 'rhnschema' LOST", "Exception information: >>> (99999, 'ERROR: current transaction is aborted, commands ignored until end >>> of transaction block', '', InternalError('current transaction is aborted, >>> commands ignored until end of transaction block\\\\n',))") >>> [Fri Jul 18 02:22:59 2014] [error] Spacewalk 1536 2014/07/18 02:22:59 >>> +04:00: ("DATABASE CONNECTION TO 'rhnschema' LOST", "Exception information: >>> (99999, 'ERROR: current transaction is aborted, commands ignored until end >>> of transaction block', '', InternalError('current transaction is aborted, >>> commands ignored until end of transaction block\\\\n',))") >>> >>> >>> [Fri Jul 18 02:26:03 2014] [error] Exception reported from spwalk-core1 >>> [Fri Jul 18 02:26:03 2014] [error] Time: Fri Jul 18 02:26:03 2014 >>> [Fri Jul 18 02:26:03 2014] [error] Exception type <class >>> 'spacewalk.server.rhnSQL.sql_base.SQLSchemaError'> >>> [Fri Jul 18 02:26:03 2014] [error] Exception while handling function >>> server.apacheUploadServer._wrapper >>> [Fri Jul 18 02:26:03 2014] [error] Request object information: >>> [Fri Jul 18 02:26:03 2014] [error] URI: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:03 2014] [error] Remote Host: spwalk-core1 >>> [Fri Jul 18 02:26:03 2014] [error] Server Name: spwalk-core1:80 >>> [Fri Jul 18 02:26:03 2014] [error] Headers passed in: >>> [Fri Jul 18 02:26:03 2014] [error] \tAccept-Encoding: identity >>> [Fri Jul 18 02:26:03 2014] [error] \tCONTENT_LENGTH: 1090724 >>> [Fri Jul 18 02:26:03 2014] [error] \tCONTENT_TYPE: application/x-rpm >>> [Fri Jul 18 02:26:03 2014] [error] \tDOCUMENT_ROOT: /var/www/html >>> [Fri Jul 18 02:26:03 2014] [error] \tGATEWAY_INTERFACE: CGI/1.1 >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_ACCEPT_ENCODING: identity >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_HOST: spwalk-core1 >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_USER_AGENT: rhnpush >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_AUTH_SESSION: >>> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM: >>> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM_TYPE: >>> sha256 >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_FORCE: 0 >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_ARCH: noarch >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_NAME: >>> cim-schema >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_RELEASE: >>> 2.1.el6 >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_VERSION: >>> 2.22.0 >>> [Fri Jul 18 02:26:03 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGING: rpm >>> [Fri Jul 18 02:26:03 2014] [error] \tHost: spwalk-core1 >>> [Fri Jul 18 02:26:03 2014] [error] \tPATH_INFO: >>> [Fri Jul 18 02:26:03 2014] [error] \tQUERY_STRING: >>> [Fri Jul 18 02:26:03 2014] [error] \tREMOTE_ADDR: 192.168.0.150 >>> [Fri Jul 18 02:26:03 2014] [error] \tREMOTE_PORT: 34568 >>> [Fri Jul 18 02:26:03 2014] [error] \tREQUEST_METHOD: POST >>> [Fri Jul 18 02:26:03 2014] [error] \tREQUEST_URI: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_FILENAME: >>> /usr/share/rhn/wsgi/package_push.py >>> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_NAME: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_URI: >>> http://spwalk-core1/PACKAGE-PUSH >>> [Fri Jul 18 02:26:03 2014] [error] \tSCRIPT_URL: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_ADDR: 192.168.0.150 >>> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_ADMIN: root@localhost >>> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_NAME: spwalk-core1 >>> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_PORT: 80 >>> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_PROTOCOL: HTTP/1.1 >>> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_SIGNATURE: <address>Apache >>> Server at spwalk-core1 Port 80</address> >>> [Fri Jul 18 02:26:03 2014] [error] >>> [Fri Jul 18 02:26:03 2014] [error] \tSERVER_SOFTWARE: Apache >>> [Fri Jul 18 02:26:03 2014] [error] \tUser-Agent: rhnpush >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Auth-Session: >>> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-File-Checksum: >>> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-File-Checksum-Type: sha256 >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Force: 0 >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Arch: noarch >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Name: cim-schema >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Release: 2.1.el6 >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Package-Version: 2.22.0 >>> [Fri Jul 18 02:26:03 2014] [error] \tX-RHN-Upload-Packaging: rpm >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_ssl.is_https: <built-in method >>> ssl_is_https of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_ssl.var_lookup: <built-in method >>> ssl_var_lookup of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.application_group: >>> 192.168.0.150|/package-push >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.callable_object: application >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.handler_script: >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.input_chunked: 0 >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.listener_host: >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.listener_port: 80 >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.process_group: >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.request_handler: wsgi-script >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.script_reloading: 1 >>> [Fri Jul 18 02:26:03 2014] [error] \tmod_wsgi.version: (3, 2) >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.errors: <mod_wsgi.Log object at >>> 0x7f9ddeb46bf0> >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.file_wrapper: <built-in method >>> file_wrapper of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.input: <mod_wsgi.Input object at >>> 0x7f9ddee71870> >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.multiprocess: True >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.multithread: False >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.run_once: False >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.url_scheme: http >>> [Fri Jul 18 02:26:03 2014] [error] \twsgi.version: (1, 1) >>> [Fri Jul 18 02:26:03 2014] [error] >>> [Fri Jul 18 02:26:03 2014] [error] Exception Handler Information >>> [Fri Jul 18 02:26:03 2014] [error] Traceback (most recent call last): >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/apacheUploadServer.py", >>> line 100, in _wrapper >>> [Fri Jul 18 02:26:03 2014] [error] ret = function(req) >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/share/rhn/upload_server/handlers/package_push/package_push.py", line >>> 124, in handler >>> [Fri Jul 18 02:26:03 2014] [error] relative_path=self.rel_package_path, >>> org_id=self.org_id) >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnPackageUpload.py", >>> line 143, in push_package >>> [Fri Jul 18 02:26:03 2014] [error] importer.run() >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", >>> line 649, in run >>> [Fri Jul 18 02:26:03 2014] [error] self.fix() >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >>> line 299, in fix >>> [Fri Jul 18 02:26:03 2014] [error] ChannelPackageSubscription.fix(self) >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >>> line 74, in fix >>> [Fri Jul 18 02:26:03 2014] [error] >>> self.backend.lookupChecksums(self.checksums) >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", >>> line 505, in lookupChecksums >>> [Fri Jul 18 02:26:03 2014] [error] h.execute(ctype=ctype, csum=csum) >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", >>> line 147, in execute >>> [Fri Jul 18 02:26:03 2014] [error] return >>> self._execute_wrapper(self._execute, *p, **kw) >>> [Fri Jul 18 02:26:03 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", >>> line 292, in _execute_wrapper >>> [Fri Jul 18 02:26:03 2014] [error] raise >>> sql_base.SQLSchemaError(error_code, e.pgerror, e) >>> [Fri Jul 18 02:26:03 2014] [error] SQLSchemaError: (99999, 'ERROR: query >>> returned no rows', 'CONTEXT: PL/pgSQL function "lookup_checksum" line 23 >>> at SQL statement\\n', InternalError('query returned no rows\\nCONTEXT: >>> PL/pgSQL function "lookup_checksum" line 23 at SQL statement\\n',)) >>> [Fri Jul 18 02:26:03 2014] [error] >>> [Fri Jul 18 02:26:03 2014] [error] Spacewalk 1527 2014/07/18 02:26:03 >>> +04:00: ('Unhandled exception',) >>> [Fri Jul 18 02:26:09 2014] [error] Exception reported from spwalk-core1 >>> [Fri Jul 18 02:26:09 2014] [error] Time: Fri Jul 18 02:26:09 2014 >>> [Fri Jul 18 02:26:09 2014] [error] Exception type <class >>> 'spacewalk.server.rhnSQL.sql_base.SQLSchemaError'> >>> [Fri Jul 18 02:26:09 2014] [error] Exception while handling function >>> server.apacheUploadServer._wrapper >>> [Fri Jul 18 02:26:09 2014] [error] Request object information: >>> [Fri Jul 18 02:26:09 2014] [error] URI: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:09 2014] [error] Remote Host: spwalk-core1 >>> [Fri Jul 18 02:26:09 2014] [error] Server Name: spwalk-core1:80 >>> [Fri Jul 18 02:26:09 2014] [error] Headers passed in: >>> [Fri Jul 18 02:26:09 2014] [error] \tAccept-Encoding: identity >>> [Fri Jul 18 02:26:09 2014] [error] \tCONTENT_LENGTH: 1090724 >>> [Fri Jul 18 02:26:09 2014] [error] \tCONTENT_TYPE: application/x-rpm >>> [Fri Jul 18 02:26:09 2014] [error] \tDOCUMENT_ROOT: /var/www/html >>> [Fri Jul 18 02:26:09 2014] [error] \tGATEWAY_INTERFACE: CGI/1.1 >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_ACCEPT_ENCODING: identity >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_HOST: spwalk-core1 >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_USER_AGENT: rhnpush >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_AUTH_SESSION: >>> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM: >>> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_FILE_CHECKSUM_TYPE: >>> sha256 >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_FORCE: 0 >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_ARCH: noarch >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_NAME: >>> cim-schema >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_RELEASE: >>> 2.1.el6 >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGE_VERSION: >>> 2.22.0 >>> [Fri Jul 18 02:26:09 2014] [error] \tHTTP_X_RHN_UPLOAD_PACKAGING: rpm >>> [Fri Jul 18 02:26:09 2014] [error] \tHost: spwalk-core1 >>> [Fri Jul 18 02:26:09 2014] [error] \tPATH_INFO: >>> [Fri Jul 18 02:26:09 2014] [error] \tQUERY_STRING: >>> [Fri Jul 18 02:26:09 2014] [error] \tREMOTE_ADDR: 192.168.0.150 >>> [Fri Jul 18 02:26:09 2014] [error] \tREMOTE_PORT: 34570 >>> [Fri Jul 18 02:26:09 2014] [error] \tREQUEST_METHOD: POST >>> [Fri Jul 18 02:26:09 2014] [error] \tREQUEST_URI: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_FILENAME: >>> /usr/share/rhn/wsgi/package_push.py >>> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_NAME: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_URI: >>> http://spwalk-core1/PACKAGE-PUSH >>> [Fri Jul 18 02:26:09 2014] [error] \tSCRIPT_URL: /PACKAGE-PUSH >>> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_ADDR: 192.168.0.150 >>> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_ADMIN: root@localhost >>> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_NAME: spwalk-core1 >>> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_PORT: 80 >>> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_PROTOCOL: HTTP/1.1 >>> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_SIGNATURE: <address>Apache >>> Server at spwalk-core1 Port 80</address> >>> [Fri Jul 18 02:26:09 2014] [error] >>> [Fri Jul 18 02:26:09 2014] [error] \tSERVER_SOFTWARE: Apache >>> [Fri Jul 18 02:26:09 2014] [error] \tUser-Agent: rhnpush >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Auth-Session: >>> 4xf2318ca8e94f5e4a6d83c483e87cf4d2b63f7b964a4a72e82df026c633d06da2 >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-File-Checksum: >>> bc3ce457534370535c3e3e9410c0106b09fcefd7aa1e3babb2d8ac835bb02b2e >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-File-Checksum-Type: sha256 >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Force: 0 >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Arch: noarch >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Name: cim-schema >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Release: 2.1.el6 >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Package-Version: 2.22.0 >>> [Fri Jul 18 02:26:09 2014] [error] \tX-RHN-Upload-Packaging: rpm >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_ssl.is_https: <built-in method >>> ssl_is_https of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_ssl.var_lookup: <built-in method >>> ssl_var_lookup of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.application_group: >>> 192.168.0.150|/package-push >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.callable_object: application >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.handler_script: >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.input_chunked: 0 >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.listener_host: >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.listener_port: 80 >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.process_group: >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.request_handler: wsgi-script >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.script_reloading: 1 >>> [Fri Jul 18 02:26:09 2014] [error] \tmod_wsgi.version: (3, 2) >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.errors: <mod_wsgi.Log object at >>> 0x7f9dc794dbf0> >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.file_wrapper: <built-in method >>> file_wrapper of mod_wsgi.Adapter object at 0x7f9dc7b98a80> >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.input: <mod_wsgi.Input object at >>> 0x7f9ddee548b0> >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.multiprocess: True >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.multithread: False >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.run_once: False >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.url_scheme: http >>> [Fri Jul 18 02:26:09 2014] [error] \twsgi.version: (1, 1) >>> [Fri Jul 18 02:26:09 2014] [error] >>> [Fri Jul 18 02:26:09 2014] [error] Exception Handler Information >>> [Fri Jul 18 02:26:09 2014] [error] Traceback (most recent call last): >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/apacheUploadServer.py", >>> line 100, in _wrapper >>> [Fri Jul 18 02:26:09 2014] [error] ret = function(req) >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/share/rhn/upload_server/handlers/package_push/package_push.py", line >>> 124, in handler >>> [Fri Jul 18 02:26:09 2014] [error] relative_path=self.rel_package_path, >>> org_id=self.org_id) >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnPackageUpload.py", >>> line 143, in push_package >>> [Fri Jul 18 02:26:09 2014] [error] importer.run() >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/importLib.py", >>> line 649, in run >>> [Fri Jul 18 02:26:09 2014] [error] self.fix() >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >>> line 299, in fix >>> [Fri Jul 18 02:26:09 2014] [error] ChannelPackageSubscription.fix(self) >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/packageImport.py", >>> line 74, in fix >>> [Fri Jul 18 02:26:09 2014] [error] >>> self.backend.lookupChecksums(self.checksums) >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/importlib/backend.py", >>> line 505, in lookupChecksums >>> [Fri Jul 18 02:26:09 2014] [error] h.execute(ctype=ctype, csum=csum) >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/sql_base.py", >>> line 147, in execute >>> [Fri Jul 18 02:26:09 2014] [error] return >>> self._execute_wrapper(self._execute, *p, **kw) >>> [Fri Jul 18 02:26:09 2014] [error] File >>> "/usr/lib/python2.6/site-packages/spacewalk/server/rhnSQL/driver_postgresql.py", >>> line 292, in _execute_wrapper >>> [Fri Jul 18 02:26:09 2014] [error] raise >>> sql_base.SQLSchemaError(error_code, e.pgerror, e) >>> [Fri Jul 18 02:26:09 2014] [error] SQLSchemaError: (99999, 'ERROR: query >>> returned no rows', 'CONTEXT: PL/pgSQL function "lookup_checksum" line 23 >>> at SQL statement\\n', InternalError('query returned no rows\\nCONTEXT: >>> PL/pgSQL function "lookup_checksum" line 23 at SQL statement\\n',)) >>> [Fri Jul 18 02:26:09 2014] [error] >>> [Fri Jul 18 02:26:10 2014] [error] Spacewalk 1534 2014/07/18 02:26:10 >>> +04:00: ('Unhandled exception’,) >>> … >>> >>> Artem >>> >>> >>> _______________________________________________ >>> Spacewalk-list mailing list >>> Spacewalk-list@redhat.com >>> https://www.redhat.com/mailman/listinfo/spacewalk-list >> >> _______________________________________________ >> Spacewalk-list mailing list >> Spacewalk-list@redhat.com >> https://www.redhat.com/mailman/listinfo/spacewalk-list > > > _______________________________________________ > Spacewalk-list mailing list > Spacewalk-list@redhat.com > https://www.redhat.com/mailman/listinfo/spacewalk-list _______________________________________________ Spacewalk-list mailing list Spacewalk-list@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-list