log for fas issue#146

gistfile1.txt

2016-03-03 07:44:20,070 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_cursor_execute:1192] SELECT CAST('test plain returns' AS VARCHAR(60)) AS anon_1
2016-03-03 07:44:20,070 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_cursor_execute:1193] ()
2016-03-03 07:44:20,070 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_cursor_execute:1192] SELECT CAST('test unicode returns' AS VARCHAR(60)) AS anon_1
2016-03-03 07:44:20,070 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_cursor_execute:1193] ()
2016-03-03 07:44:20,071 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,073 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,074 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/sqlalchemy/sql/sqltypes.py:562: SAWarning: Dialect sqlite+pysqlite does *not* support Decimal objects natively, and SQLAlchemy must convert from floating point - rounding errors and other issues may occur. Please consider storing Decimal numbers as strings or integers on this platform for lossless storage.
  'storage.' % (dialect.name, dialect.driver))
2016-03-03 07:44:20,089 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,090 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,090 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,092 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT license_agreement.id AS license_agreement_id, license_agreement.name AS license_agreement_name, license_agreement.status AS license_agreement_status, license_agreement.content AS license_agreement_content, license_agreement.comment AS license_agreement_comment, license_agreement.enabled_at_signup AS license_agreement_enabled_at_signup, license_agreement.creation_timestamp AS license_agreement_creation_timestamp, license_agreement.update_timestamp AS license_agreement_update_timestamp 
FROM license_agreement
2016-03-03 07:44:20,092 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] ()
2016-03-03 07:44:20,098 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,102 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT groups.id AS groups_id, groups.name AS groups_name, groups.display_name AS groups_display_name, groups.description AS groups_description, groups.status AS groups_status, groups.avatar AS groups_avatar, groups.web_link AS groups_web_link, groups.mailing_list AS groups_mailing_list, groups.mailing_list_url AS groups_mailing_list_url, groups.irc_channel AS groups_irc_channel, groups.irc_network AS groups_irc_network, groups.owner_id AS groups_owner_id, groups.group_type AS groups_group_type, groups.parent_group_id AS groups_parent_group_id, groups.private AS groups_private, groups.self_removal AS groups_self_removal, groups.need_approval AS groups_need_approval, groups.requires_sponsorship AS groups_requires_sponsorship, groups.requires_ssh AS groups_requires_ssh, groups.invite_only AS groups_invite_only, groups.join_msg AS groups_join_msg, groups.apply_rules AS groups_apply_rules, groups.bound_to_github AS groups_bound_to_github, groups.license_sign_up AS groups_license_sign_up, groups.certificate AS groups_certificate, groups.created AS groups_created, groups.updated AS groups_updated 
FROM groups, group_membership, people 
WHERE group_membership.group_id = groups.id AND group_membership.people_id = people.id AND group_membership.status = ? AND people.username IS NULL
2016-03-03 07:44:20,102 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (<EnumValue: MembershipStatus.APPROVED [value=1]>,)
2016-03-03 07:44:20,113 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,116 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT groups.id AS groups_id, groups.name AS groups_name, groups.display_name AS groups_display_name, groups.description AS groups_description, groups.status AS groups_status, groups.avatar AS groups_avatar, groups.web_link AS groups_web_link, groups.mailing_list AS groups_mailing_list, groups.mailing_list_url AS groups_mailing_list_url, groups.irc_channel AS groups_irc_channel, groups.irc_network AS groups_irc_network, groups.owner_id AS groups_owner_id, groups.group_type AS groups_group_type, groups.parent_group_id AS groups_parent_group_id, groups.private AS groups_private, groups.self_removal AS groups_self_removal, groups.need_approval AS groups_need_approval, groups.requires_sponsorship AS groups_requires_sponsorship, groups.requires_ssh AS groups_requires_ssh, groups.invite_only AS groups_invite_only, groups.join_msg AS groups_join_msg, groups.apply_rules AS groups_apply_rules, groups.bound_to_github AS groups_bound_to_github, groups.license_sign_up AS groups_license_sign_up, groups.certificate AS groups_certificate, groups.created AS groups_created, groups.updated AS groups_updated 
FROM groups, group_membership, people 
WHERE group_membership.group_id = groups.id AND group_membership.people_id = people.id AND group_membership.status = ? AND people.username IS NULL
2016-03-03 07:44:20,116 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (<EnumValue: MembershipStatus.APPROVED [value=1]>,)
2016-03-03 07:44:20,125 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,127 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT groups.id AS groups_id, groups.name AS groups_name, groups.display_name AS groups_display_name, groups.description AS groups_description, groups.status AS groups_status, groups.avatar AS groups_avatar, groups.web_link AS groups_web_link, groups.mailing_list AS groups_mailing_list, groups.mailing_list_url AS groups_mailing_list_url, groups.irc_channel AS groups_irc_channel, groups.irc_network AS groups_irc_network, groups.owner_id AS groups_owner_id, groups.group_type AS groups_group_type, groups.parent_group_id AS groups_parent_group_id, groups.private AS groups_private, groups.self_removal AS groups_self_removal, groups.need_approval AS groups_need_approval, groups.requires_sponsorship AS groups_requires_sponsorship, groups.requires_ssh AS groups_requires_ssh, groups.invite_only AS groups_invite_only, groups.join_msg AS groups_join_msg, groups.apply_rules AS groups_apply_rules, groups.bound_to_github AS groups_bound_to_github, groups.license_sign_up AS groups_license_sign_up, groups.certificate AS groups_certificate, groups.created AS groups_created, groups.updated AS groups_updated 
FROM groups, group_membership, people 
WHERE group_membership.group_id = groups.id AND group_membership.people_id = people.id AND group_membership.status = ? AND people.username IS NULL
2016-03-03 07:44:20,128 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (<EnumValue: MembershipStatus.APPROVED [value=1]>,)
2016-03-03 07:44:20,136 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,137 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,245 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,308 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,312 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,314 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,318 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,319 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,322 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,323 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,324 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,325 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,326 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,327 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,327 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,348 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,349 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,349 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,350 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,350 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,350 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,351 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,352 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,352 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,353 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,353 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,354 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,368 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,368 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,373 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,374 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,374 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,375 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,379 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,380 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,381 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,392 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,392 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,393 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,394 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,394 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,394 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,395 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,399 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,399 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,544 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,546 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,546 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,556 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,556 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,558 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,559 ERROR [waitress:21776][pyramid_debugtoolbar][toolbar_tween:209] Exception at http://0.0.0.0:6543/settings/captcha/Z0FBQUFBQlcxMTYwU0NVOGNBVTZ4TkRUT3FjTEhuVFlEV0xXclpySUMyT2pSc0l6YUFkTnBEY1hjQnRBYXBOcXMxVW1RVXpHU1k3anVxbk5JSlZHV2kzZUQ2dzlSMEtmMEE9PQ%3D%3D
traceback url: http://0.0.0.0:6543/_debug_toolbar/exception?token=1d19ec2740606bdc40d7&tb=139781220868304
Traceback (most recent call last):
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid_debugtoolbar/toolbar.py", line 192, in toolbar_tween
    response = _handler(request)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid_debugtoolbar/panels/performance.py", line 57, in resource_timer_handler
    result = handler(request)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid/tweens.py", line 20, in excview_tween
    response = handler(request)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 101, in tm_tween
    reraise(*exc_info)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid_tm/__init__.py", line 83, in tm_tween
    response = handler(request)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid/router.py", line 145, in handle_request
    view_name
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid/view.py", line 541, in _call_view
    response = view_callable(context, request)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid/config/views.py", line 377, in rendered_view
    context)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid/renderers.py", line 450, in render_view
    return self.render_to_response(response, system, request=request)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid/renderers.py", line 473, in render_to_response
    result = self.render(value, system_values, request=request)
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/pyramid/renderers.py", line 469, in render
    result = renderer(value, system_values)
  File "/home/rlerch/Source/fas/fas/renderers.py", line 31, in render
    return data.tostring('jpeg', 'RGB')
  File "/home/rlerch/.virtualenvs/fas-python2.7/lib/python2.7/site-packages/PIL/Image.py", line 695, in tostring
    "Please call tobytes() instead.")
Exception: tostring() has been removed. Please call tobytes() instead.
2016-03-03 07:44:20,561 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,562 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,562 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,572 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,572 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,595 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,596 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,597 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,600 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,602 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,606 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,606 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,654 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,654 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,655 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,658 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,661 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,661 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,672 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,672 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,673 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,673 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,674 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,674 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,675 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,675 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,676 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,676 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,677 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,682 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,695 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,696 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,697 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,700 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,701 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,701 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,711 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,712 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,712 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,713 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,713 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,713 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,727 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,728 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,728 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,738 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,738 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,738 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:20,871 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:20,873 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:20,873 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:20,887 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,888 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:20,889 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
2016-03-03 07:44:21,074 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_begin_impl:646] BEGIN (implicit)
2016-03-03 07:44:21,076 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1097] SELECT people.id AS people_id, people.username AS people_username, people.password AS people_password, people.fullname AS people_fullname, people.ircnick AS people_ircnick, people.avatar AS people_avatar, people.avatar_id AS people_avatar_id, people.introduction AS people_introduction, people.postal_address AS people_postal_address, people.country_code AS people_country_code, people.locale AS people_locale, people.birthday AS people_birthday, people.birthday_month AS people_birthday_month, people.telephone AS people_telephone, people.facsimile AS people_facsimile, people.affiliation AS people_affiliation, people.bio AS people_bio, people.timezone AS people_timezone, people.gpg_fingerprint AS people_gpg_fingerprint, people.ssh_key AS people_ssh_key, people.email AS people_email, people.recovery_email AS people_recovery_email, people.bugzilla_email AS people_bugzilla_email, people.email_token AS people_email_token, people.unverified_email AS people_unverified_email, people.security_question AS people_security_question, people.security_answer AS people_security_answer, people.login_attempt AS people_login_attempt, people.password_token AS people_password_token, people.old_password AS people_old_password, people.certificate_serial AS people_certificate_serial, people.status AS people_status, people.status_change AS people_status_change, people.privacy AS people_privacy, people.email_alias AS people_email_alias, people.blog_rss AS people_blog_rss, people.latitude AS people_latitude, people.longitude AS people_longitude, people.fas_token AS people_fas_token, people.github_token AS people_github_token, people.twitter_token AS people_twitter_token, people.last_logged AS people_last_logged, people.date_created AS people_date_created, people.date_updated AS people_date_updated 
FROM people 
WHERE people.username IS NULL
 LIMIT ? OFFSET ?
2016-03-03 07:44:21,076 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_execute_context:1100] (1, 0)
2016-03-03 07:44:21,085 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:21,086 DEBUG [waitress:21776][fas][_log:51] pyramid.authentication.AuthTktAuthenticationPolicy.authenticated_userid: call to unauthenticated_userid returned None; returning None
2016-03-03 07:44:21,086 INFO  [waitress:21776][sqlalchemy.engine.base.Engine][_rollback_impl:666] ROLLBACK
Starting subprocess with file monitor
^C caught in monitor process