PostgreSQL: "Object not in prerequisite state" error when trying to create a user [#1807356]

When I want to create user, I'm getting an error:

PDOException: SQLSTATE[55000]: Object not in prerequisite state: 7 ERROR: currval of sequence "subscriptions_sid_seq" is not yet defined in this session: INSERT INTO subscriptions (module, field, value, send_interval, author_uid, send_updates, send_comments, recipient_uid) SELECT s.module AS module, s.field AS field, s.value AS value, s.send_interval AS send_interval, s.author_uid AS author_uid, s.send_updates AS send_updates, s.send_comments AS send_comments, 94 AS recipient_uid FROM subscriptions s WHERE (s.recipient_uid IN (:db_condition_placeholder_0)) ; Array ( ) v subscriptions_user_insert() (riadok 336 z .....modules/subscriptions/subscriptions.module).

I'm using Drupal 7.15, last dev version of Subscriptions.

Comment	File	Size	Author
#8	1807356-8-user-insert-query.patch	526 bytes	karleberts
#8
#6	1807356-6-user-insert-query.patch	439 bytes	karleberts
#6

Support from Acquia helps fund testing for Drupal Acquia logo

Comments

Comment #1

salvis

he/his

CreditAttribution: salvis commented 10 October 2012 at 05:37

Title:	Can't create user - subscriptions module error on PostgreSQL	» PostgreSQL: "Object not in prerequisite state" error when trying to create a user
Priority:	Critical	» Normal

PostgreSQL quirks are not critical.

Any PostgreSQL gurus out there?

Comment #2

salvis

he/his

CreditAttribution: salvis commented 26 October 2012 at 20:55

Status:

Active

» Postponed (maintainer needs more info)

Sorry, no one seems to know how to fix this.

Comment #3

salvis

he/his

CreditAttribution: salvis commented 30 October 2012 at 23:52

Issue tags:

+PostgreSQL

According to the PostgreSQL documentation, the subselect returning nothing should not be a problem.

I've tried listing the ->fields() and I've tried ->useDefaults(), both without success (resulting in MySQL errors).

Comment #4

ecomundo CreditAttribution: ecomundo commented 13 November 2012 at 09:19

We have the same issue here. Many of the admin actions returns the error : PDOException: SQLSTATE[55000]: Object not in prerequisite state: 7 ERROR: currval of sequence "sequence_name" is not yet defined in this session.

According to our research, the currval function return the last nextval executed with the active database session. The lastval function returning the last nexval for all database session. So both of this functions are not define if no nextval has been executed.

Comment #5

salvis

he/his

CreditAttribution: salvis commented 13 November 2012 at 23:14

Subscriptions does not deal with currval/nextval/etc. at all. Apparently, this happens in the database layer, but I have no idea why and what for.

Comment #6

karleberts CreditAttribution: karleberts commented 11 March 2013 at 18:48

Status:

Postponed (maintainer needs more info)

» Needs review

File	Size
1807356-6-user-insert-query.patch	439 bytes

The problem seems to be when a new user is created the subselect returns nothing, so the insert doesn't actually insert anything either. By default, db_insert returns the id of the row by calling PDO::lastInsertId (which seems to just call currval() on the sequence), hence the error when nothing is inserted.

Modifying the options to db_insert to not return the id allows this step to be skipped; the return value for the insert isn't used anyway.