Socorro Testing - Revision history

Talad at 18:30, 10 December 2013

2013-12-10T18:30:02Z

← Older revision		Revision as of 18:30, 10 December 2013
Line 420:		Line 420:
	INSERT INTO os_versions (major_version,minor_version,os_name,os_version_id,os_version_string) values (0,0,'Unknown',76,'Unknown');		INSERT INTO os_versions (major_version,minor_version,os_name,os_version_id,os_version_string) values (0,0,'Unknown',76,'Unknown');

			''' crontabber - unicode not permitted error '''

			If you receive this error means your database is not UTF8 (it was part of the install commands):

			Unicode escape for code points higher than U+007F not permitted in non-UTF8 encoding

			You can see the encoding with this command:

			> psql -l

			If you see SQL_ASCII then it's wrong.

			You then have to convert your 'breakpad' database to UTF-8 (others can stay ascii):

			> /etc/init.d/supervisor stop
			> su - postgres
			> pg_dump breakpad -U planeshift > db.sql
			> psql

			# ALTER DATABASE breakpad RENAME TO breakpad_ascii
			# CREATE DATABASE breakpad WITH OWNER = breakpad_rw TEMPLATE = template0 ENCODING = 'UTF-8';
			# GRANT ALL ON DATABASE breakpad to socorro;
			# GRANT ALL ON DATABASE breakpad to breakpad_rw; (unsure about this one, but I did it anyway)
			# GRANT ALL ON DATABASE breakpad to planeshift; (unsure about this one, but I did it anyway)

			> iconv --from-code ISO8859-1 --to-code UTF8 db.sql > db_utf8.sql

			Edit db_utf8.sql and change this line to UTF-8:
			SET client_encoding = 'UTF-8';

			> psql -U planeshift -d breakpad
			# \i db_utf8.sql

			> /etc/init.d/supervisor start

	''' problems with tcbs and home graph '''		''' problems with tcbs and home graph '''

2013-12-07T12:12:11Z

Troubleshooting

← Older revision		Revision as of 12:12, 7 December 2013
Line 419:		Line 419:
	INSERT INTO os_names (os_name,os_short_name) VALUES('Unknown','unk');		INSERT INTO os_names (os_name,os_short_name) VALUES('Unknown','unk');
	INSERT INTO os_versions (major_version,minor_version,os_name,os_version_id,os_version_string) values (0,0,'Unknown',76,'Unknown');		INSERT INTO os_versions (major_version,minor_version,os_name,os_version_id,os_version_string) values (0,0,'Unknown',76,'Unknown');

	~~THIS WORKAROUND IS PROBABLY NOT THE BEST, SEE PREVIOUS ONE~~

	~~Edited /data/socorro/application/socorro/external/postgresql/raw_sql/procs/001_update_reports_clean.sql~~
	~~Changed this query at line 273 adding also os_version:~~

	~~UPDATE reports_clean_buffer SET os_name = 'Unknown',~~
	~~major_version = 0, minor_version = 0,~~
	~~os_version_id = 0~~
	~~WHERE os_name IS NULL OR os_name NOT IN ( SELECT os_name FROM os_names );~~

2013-12-05T22:58:10Z

Troubleshooting

← Older revision		Revision as of 22:58, 5 December 2013
Line 413:		Line 413:
	select * from reports where signature like 'EMPTY%';		select * from reports where signature like 'EMPTY%';
	select * from reports where uuid='5abb16a3-31f1-413c-9d72-46aa62131126';		select * from reports where uuid='5abb16a3-31f1-413c-9d72-46aa62131126';


			The base dataset is not having the Unknown os name and version, so you need to add it:

			INSERT INTO os_names (os_name,os_short_name) VALUES('Unknown','unk');
			INSERT INTO os_versions (major_version,minor_version,os_name,os_version_id,os_version_string) values (0,0,'Unknown',76,'Unknown');

			THIS WORKAROUND IS PROBABLY NOT THE BEST, SEE PREVIOUS ONE

	Edited /data/socorro/application/socorro/external/postgresql/raw_sql/procs/001_update_reports_clean.sql		Edited /data/socorro/application/socorro/external/postgresql/raw_sql/procs/001_update_reports_clean.sql

2013-12-04T10:42:53Z

Troubleshooting

← Older revision		Revision as of 10:42, 4 December 2013
Line 419:		Line 419:
	UPDATE reports_clean_buffer SET os_name = 'Unknown',		UPDATE reports_clean_buffer SET os_name = 'Unknown',
	major_version = 0, minor_version = 0,		major_version = 0, minor_version = 0,
	~~os_version~~ = 0		os_version_id = 0
	WHERE os_name IS NULL OR os_name NOT IN ( SELECT os_name FROM os_names );		WHERE os_name IS NULL OR os_name NOT IN ( SELECT os_name FROM os_names );

2013-12-04T10:40:18Z

Troubleshooting

← Older revision		Revision as of 10:40, 4 December 2013
Line 414:		Line 414:
	select * from reports where uuid='5abb16a3-31f1-413c-9d72-46aa62131126';		select * from reports where uuid='5abb16a3-31f1-413c-9d72-46aa62131126';

	~~NO SOLUTION FOUND YET~~		Edited /data/socorro/application/socorro/external/postgresql/raw_sql/procs/001_update_reports_clean.sql
			Changed this query at line 273 adding also os_version:

			UPDATE reports_clean_buffer SET os_name = 'Unknown',
			major_version = 0, minor_version = 0,
			os_version = 0
			WHERE os_name IS NULL OR os_name NOT IN ( SELECT os_name FROM os_names );


	''' problems with tcbs and home graph '''		''' problems with tcbs and home graph '''

2013-12-04T10:25:24Z

Troubleshooting

@@ Line 391: / Line 391: @@
    /data/socorro/application/socorro/external/postgresql/raw_sql/procs/update_signatures.sql
    /data/socorro/application/socorro/external/postgresql/raw_sql/procs/update_nightly_builds.sql
 ''' problems with tcbs and home graph '''
@@ Line 403: / Line 427: @@
    queries reports_clean table, expecting data
    populated by /data/socorro/application/socorro/external/postgresql/raw_sql/procs/001_update_reports_clean.sql
 == References ==

2013-11-22T21:18:39Z

@@ Line 253: / Line 253: @@
    select * from tcbs_build where product_version_id>16;
 '''Generates signatures manually'''
@@ Line 402: / Line 391: @@
    /data/socorro/application/socorro/external/postgresql/raw_sql/procs/update_signatures.sql
    /data/socorro/application/socorro/external/postgresql/raw_sql/procs/update_nightly_builds.sql
 == References ==

2013-11-22T20:53:33Z

← Older revision		Revision as of 20:53, 22 November 2013
Line 38:		Line 38:
	vi /data/socorro/application/socorro/processor/processor.py		vi /data/socorro/application/socorro/processor/processor.py

	and add these functions at the end of the file:		and add [[socorro_add_code\|these functions]] at the end of the file.

	~~TODO TOFIX~~


	'''(Workaround) Generating a crash manually'''		'''(Workaround) Generating a crash manually'''

2013-11-22T18:24:26Z

← Older revision		Revision as of 18:24, 22 November 2013
Line 32:		Line 32:
	To create a transformation rule you need to add this:		To create a transformation rule you need to add this:

	INSERT INTO transform_rules VALUES (1, 'processor.json_rewrite',1,'json_PlaneShift_transform_action','','','json_PlaneShift_transform_predicate','','');		INSERT INTO transform_rules VALUES (1, 'processor.json_rewrite',1,'socorro.processor.processor.json_PlaneShift_transform_action','','','socorro.processor.processor.json_PlaneShift_transform_predicate','','');

	Then edit		Then edit
Line 38:		Line 38:
	vi /data/socorro/application/socorro/processor/processor.py		vi /data/socorro/application/socorro/processor/processor.py

	TOFIX ~~TODO~~		and add these functions at the end of the file:

			TODO TOFIX


	'''(Workaround) Generating a crash manually'''		'''(Workaround) Generating a crash manually'''

2013-11-22T15:26:31Z

@@ Line 27: / Line 27: @@
 * Version : the version, example '0.6.0', should match product_versions.release_version
 * BuildID : the build id , example '201305051111', should match product_versions.build_date
 '''(Workaround) Generating a crash manually'''