Post reply

Table not returning any result

  • June 26, 2014 at 12:22 am

    #287161

    I am trying to run queries on a table (table has zero rows). Inspite of giving 0 rows returned the query keeps on running and I have to cancel it.I tried inserting a dummy row into the table but even the insert operation is taking too long.Every query which I hit on the table just keeps on running without giving any result.

    But this is not the case with other tables in the database.They are all running fine giving proper results.But this one table is behaving funny.

    Can anyone suggest what might be the error?\

    Thanks in advance.

  • June 26, 2014 at 1:18 am

    #1724922

    did you check any transaction on this table ?

  • June 26, 2014 at 2:35 am

    #1724953

    Indeed ..an insert operation was on.

    Thanks

  • June 26, 2014 at 3:35 am

    #1724975

    Okay, Glad to help. Old DEV mistake. Should be in the checklist from now on :-P.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply