Użytkownik Ed Leafe napisał: >> Here is log content before restart: >> Database Activity Log: Sun Nov 08 13:24:45 2009: FAILED SQL: >> select >> * from users >> Database Activity Log: Sun Nov 08 13:24:46 2009: FAILED SQL: >> select >> * from limit 1 >> > I wonder how this last query got in: it's missing the table name in > the FROM clause. > >> And this is after restart: >> Database Activity Log: Mon Nov 09 01:42:16 2009: SQL: select * >> from users >>
Another strange thing is that second query didn't appear in log after the change. > > It sounds like the Dabo connection was holding open a transaction, > and needed a rollback() to clear it. If you run into this again, > please post the log entries for it and maybe we'll find a clue. > I think, that backend should rollback open transactions automatically when client closes/breaks connection, so when Dabo application process ends, there should be no open connections and transactions. Next time I check it in network monitor. I hope there will be no next time with riddle like this ;-) Thanks Ed. -- Regards Jacek Kałucki _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users Searchable Archives: http://leafe.com/archives/search/dabo-users This message: http://leafe.com/archives/byMID/[email protected]
