another truncate logical error fixed

1 files changed, 5 insertions, 3 deletions

diff --git a/pgsql.c b/pgsql.c
index 4932810..e42a6cf 100644
--- a/pgsql.c
+++ b/pgsql.c
@@ -745,6 +745,8 @@ int psql_truncate( PGconn *conn, const size_t block_size, const int64_t id, cons
 	param1 = htobe64( id );
 	param2 = htobe64( info.to_block );
 	
+	syslog( LOG_ERR, "TRUNC: %"PRIu64", block %jd", id, info.to_block );
+	
 	/* delete superflous blocks */
 	dbres = PQexecParams( conn, "DELETE FROM data WHERE dir_id=$1::bigint AND block_no>$2::bigint",
 		2, NULL, values, lengths, binary, 1 );
@@ -776,9 +778,9 @@ int psql_truncate( PGconn *conn, const size_t block_size, const int64_t id, cons
 		return -EIO;
 	}
 	
-	if( atoi( PQcmdTuples( dbres ) ) != 1 ) {
-		syslog( LOG_ERR, "Expecting COUNT(1) in psql_truncate in file '%s' and padded block '%jd'. Data consistency problems!",
-			path, info.to_block );
+	if( atoi( PQcmdTuples( dbres ) ) > 1 ) {
+		syslog( LOG_ERR, "Expecting COUNT(0/1) in psql_truncate in file '%s' and padded block '%jd'. Data consistency problems (%s)!",
+			path, info.to_block, sql );
 		PQclear( dbres );
 		return -EIO;
 	}