View Issue Details [ Jump to Notes ] [ Print ]
IDProjectCategoryView StatusDate SubmittedLast Update
0012979CDash(No Category)public2012-02-18 17:552012-02-19 05:48
ReporterMarco Craveiro 
Assigned ToJulien Jomier 
PrioritynormalSeveritymajorReproducibilityalways
StatusresolvedResolutionfixed 
PlatformAppleOSMac OS XOS Version10.8.0
Product Version1.8 
Target VersionFixed in Version2.0 
Summary0012979: Compressed data in PostgreSQL 9.x is not retrieved correctly
DescriptionA change in escaping was done as part of Postgres 9.x series:

http://www.postgresql.org/docs/9.1/static/datatype-binary.html [^]

The short of it is that the default behaviour of escaping has changed, and pg_escape_bytea/pg_unescape_bytea no longer work as advertised. As far as CDash is concerned, the symptoms are an inability to see binary data such as the project logo etc as well as any other compressed binary data such as outputs of tests. In my case I just got a page without any test output. This page explains how to resolve the issue:

http://www.php.net/manual/en/function.pg-unescape-bytea.php [^]

Basically just run the following on your postgres database:

ALTER USER username SET bytea_output = 'escape';

replacing username with the CDash database username.
Steps To ReproduceUsing any version of postgres from the 9.x series, upload test output to the database; then try to see the output from CDash.
Additional InformationCan we please add the SQL commands to the CDash schema if running on Postgres 9.x:

ALTER USER username SET bytea_output = 'escape';
TagsPostgreSQL
Attached Files

 Relationships

  Notes
(0028633)
Julien Jomier (manager)
2012-02-19 05:48

 The following has already been added to CDash 2.0:

  ALTER DATABASE ".$CDASH_DB_NAME." SET bytea_output TO 'escape'"

Feel free to reopen if that doesn't solve the problem.

 Issue History
Date Modified Username Field Change
2012-02-18 17:55 Marco Craveiro New Issue
2012-02-18 17:58 Marco Craveiro Tag Attached: PostgreSQL
2012-02-19 05:48 Julien Jomier Assigned To => Julien Jomier
2012-02-19 05:48 Julien Jomier Status new => assigned
2012-02-19 05:48 Julien Jomier Note Added: 0028633
2012-02-19 05:48 Julien Jomier Status assigned => resolved
2012-02-19 05:48 Julien Jomier Fixed in Version => 2.0
2012-02-19 05:48 Julien Jomier Resolution open => fixed

Copyright © 2000 - 2018 MantisBT Team