How to run Lua code once with lua_code_cache off?

vperetokin · 2016-03-29T10:38:42+00:00

On Fri, Apr 15, 2016 at 12:54 PM David Birdsong <david....@gmail.com> wrote:On Fri, Apr 15, 2016 at 12:16 PM Yichun Zhang (agentzh) <age...@gmail.co...

How to run Lua code once with lua_code_cache off?

vperetokin

I'd like to use Lua to do some database setup, and init_by_lua is an almost perfect fit for this, but unfortunately it is run every time when lua_code_cache is off - and having it off is real nice for development. Are there any other hooks I can use that'll run Lua code just once even with lua_code_cache off?

rpaprocki

I don't believe any such mechanism exists. Perhaps some sentinel flag that could examine your schema and signal if it's appropriate to run would be appropriate?

Curious as to what sort of environment would make database initialization appropriate for an http server? If it's truly a one-time action, would not a simple sql file work?

On Mar 28, 2016, at 19:38, Vadim Peretokin <vper...@gmail.com> wrote:

I'd like to use Lua to do some database setup, and init_by_lua is an almost perfect fit for this, but unfortunately it is run every time when lua_code_cache is off - and having it off is real nice for development. Are there any other hooks I can use that'll run Lua code just once even with lua_code_cache off?

.

vperetokin

I could have a once-off separate action that initializes the database, but then it's one more step people have to do and one more way it can be stuffed up. Unless there's a strong reason against it, I've gotten the auto-initialisation to work as I'd like - just having this issue finding a right hook.

On Tuesday, March 29, 2016 at 12:54:54 PM UTC+10, rpaprocki wrote:

I don't believe any such mechanism exists. Perhaps some sentinel flag that could examine your schema and signal if it's appropriate to run would be appropriate?

Curious as to what sort of environment would make database initialization appropriate for an http server? If it's truly a one-time action, would not a simple sql file work?

On Mar 28, 2016, at 19:38, Vadim Peretokin <vpere...@gmail.com> wrote:

I'd like to use Lua to do some database setup, and init_by_lua is an almost perfect fit for this, but unfortunately it is run every time when lua_code_cache is off - and having it off is real nice for development. Are there any other hooks I can use that'll run Lua code just once even with lua_code_cache off?

.

rpaprocki

Not that there's not a reason, just that there's not a built-in mechanism for it. There simply isn't a run-only-once hook in nginx. You'll need to do a bit of work there on your own. I would imagine some sort of pre-flight check as part of your initialization to look for an existing scheme and bail if it looks like your schema exists. Shouldn't be more than a few lines of code :)

On Mar 28, 2016, at 21:34, Vadim Peretokin <vper...@gmail.com> wrote:

I could have a once-off separate action that initializes the database, but then it's one more step people have to do and one more way it can be stuffed up. Unless there's a strong reason against it, I've gotten the auto-initialisation to work as I'd like - just having this issue finding a right hook.

On Tuesday, March 29, 2016 at 12:54:54 PM UTC+10, rpaprocki wrote:
I don't believe any such mechanism exists. Perhaps some sentinel flag that could examine your schema and signal if it's appropriate to run would be appropriate?

Curious as to what sort of environment would make database initialization appropriate for an http server? If it's truly a one-time action, would not a simple sql file work?

On Mar 28, 2016, at 19:38, Vadim Peretokin <vpere...@gmail.com> wrote:

I'd like to use Lua to do some database setup, and init_by_lua is an almost perfect fit for this, but unfortunately it is run every time when lua_code_cache is off - and having it off is real nice for development. Are there any other hooks I can use that'll run Lua code just once even with lua_code_cache off?

.

andre.rauh

IIRC the shared memory does NOT get reset on a "nginx -s reload". So you could just set a flag there and check it.

On Tuesday, March 29, 2016 at 4:38:43 AM UTC+2, Vadim Peretokin wrote:

I'd like to use Lua to do some database setup, and init_by_lua is an almost perfect fit for this, but unfortunately it is run every time when lua_code_cache is off - and having it off is real nice for development. Are there any other hooks I can use that'll run Lua code just once even with lua_code_cache off?

vperetokin

Thanks, that's what I've done and it works. For anyone else reading this in the future, this is essentially what I've done:

http {

include mime.types;

lua_shared_dict blah 12k;

init_by_lua_block {

local initialised = ngx.shared.blah("initialised")

if initialised then return end

local saved, err = ngx.shared.shared:set("initialised", true)

On Tuesday, March 29, 2016 at 3:41:44 PM UTC+10, Andre R wrote:

IIRC the shared memory does NOT get reset on a "nginx -s reload". So you could just set a flag there and check it.

On Tuesday, March 29, 2016 at 4:38:43 AM UTC+2, Vadim Peretokin wrote:
I'd like to use Lua to do some database setup, and init_by_lua is an almost perfect fit for this, but unfortunately it is run every time when lua_code_cache is off - and having it off is real nice for development. Are there any other hooks I can use that'll run Lua code just once even with lua_code_cache off?