Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

2016-07-21 Thread Yihong Zhan
the name does not include any slashes (“/“) there would be no problem. Thanks From: Quan Yong Zhai <q...@msn.com<mailto:q...@msn.com>> Date: Tuesday, July 19, 2016 at 23:56 To: Yihong Zhan <yhz...@cadence.com<mailto:yhz...@cadence.com>>, "sqlite-users@mailinglists.sqlite.org&

Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

2016-07-20 Thread Yihong Zhan
the name does not include any slashes (“/“) there would be no problem. So I think it probably be a bug in sqlite library? Thanks From: Quan Yong Zhai <q...@msn.com<mailto:q...@msn.com>> Date: Tuesday, July 19, 2016 at 23:56 To: Yihong Zhan <yhz...@cadence.com<mailto:yhz.

Re: [sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

2016-07-20 Thread Yihong Zhan
ot include any slashes (“/“) there would be no problem. Thanks From: Quan Yong Zhai <q...@msn.com<mailto:q...@msn.com>> Date: Tuesday, July 19, 2016 at 23:56 To: Yihong Zhan <yhz...@cadence.com<mailto:yhz...@cadence.com>>, "sqlite-users@mailinglists.sqlite.org<mailto:sq

[sqlite] In what case will the online backup api hang for acquiring the Btree lock of the destination on-disk file?

2016-07-19 Thread Yihong Zhan
Hi sqlite experts, I am currently incorporating the sqlite online backup API (version 3.8.0.2) into our product. I meet a tricky problem, where the sqlite3_backup_step hangs at acquiring the BTree’s lock of the destination file. Specifically, I am backing up in-memory database to NFS disk

[sqlite] Why the back-up database file does not shrink as the source database shrink?

2016-05-13 Thread Yihong Zhan
Hi sqlite experts, I am using sqlite back up API of the latest sqlite version. I find an issue that the target database seems not shrink when the source shrinks. Here are my steps: The source database is an in-memory database 1. Open the source database and preserve the connection for