[Mailman-Developers] "Address already exists" when creating users, but it creates a new user anyway

[Andrew Stuart]

After executing the curl command:

curl -X POST --data "email=mailmanadmin at example.org" --header "authorization: Basic cmVzdGFkbWluOnJlc3RwYXNz" http://localhost:8001/3.0/users

The log file adds the following:

Feb 04 11:30:05 2015 (17776) BEGIN (implicit)
Feb 04 11:30:05 2015 (17776) SELECT count(*) AS count_1
FROM (SELECT uid.id AS uid_id, uid.uid AS uid_uid
FROM uid
WHERE uid.uid = ?) AS anon_1
Feb 04 11:30:05 2015 (17776) ('57fdf5a214334b388d6efc3c375dc392',)
Feb 04 11:30:05 2015 (17776) INSERT INTO uid (uid) VALUES (?)
Feb 04 11:30:05 2015 (17776) ('57fdf5a214334b388d6efc3c375dc392',)
Feb 04 11:30:05 2015 (17776) SELECT count(*) AS count_1
FROM (SELECT user.password AS user_password, user.id AS user_id, user.display_name AS user_display_name, user._user_id AS user__user_id, user._created_on AS user__created_on, user._preferred_address_id AS user__preferred_address_id, user.preferences_id AS user_preferences_id
FROM user
WHERE user._user_id = ?) AS anon_1
Feb 04 11:30:05 2015 (17776) ('57fdf5a214334b388d6efc3c375dc392',)
Feb 04 11:30:05 2015 (17776) INSERT INTO preferences (acknowledge_posts, hide_address, preferred_language, receive_list_copy, receive_own_postings, delivery_mode, delivery_status) VALUES (?, ?, ?, ?, ?, ?, ?)
Feb 04 11:30:05 2015 (17776) (None, None, None, None, None, None, None)
Feb 04 11:30:05 2015 (17776) INSERT INTO user (display_name, password, _user_id, _created_on, _preferred_address_id, preferences_id) VALUES (?, ?, ?, ?, ?, ?)
Feb 04 11:30:05 2015 (17776) ('', None, '57fdf5a214334b388d6efc3c375dc392', '2015-02-04 11:30:05.112836', None, 7)
Feb 04 11:30:05 2015 (17776) SELECT count(*) AS count_1
FROM (SELECT address.verified_on AS address_verified_on, address.id AS address_id, address.email AS address_email, address._original AS address__original, address.display_name AS address_display_name, address.registered_on AS address_registered_on, address.user_id AS address_user_id, address.preferences_id AS address_preferences_id
FROM address
WHERE address.email = ?) AS anon_1
Feb 04 11:30:05 2015 (17776) ('mailmanadmin at example.org',)
Feb 04 11:30:05 2015 (17776) SELECT address.verified_on AS address_verified_on, address.id AS address_id, address.email AS address_email, address._original AS address__original, address.display_name AS address_display_name, address.registered_on AS address_registered_on, address.user_id AS address_user_id, address.preferences_id AS address_preferences_id
FROM address
WHERE address.email = ?
 LIMIT ? OFFSET ?
Feb 04 11:30:05 2015 (17776) ('mailmanadmin at example.org', 1, 0)
Feb 04 11:30:05 2015 (17776) COMMIT