Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

alter table ... exceptions fails #1874

Closed
sanikolaev opened this issue Feb 22, 2024 · 2 comments
Closed

alter table ... exceptions fails #1874

sanikolaev opened this issue Feb 22, 2024 · 2 comments
Assignees
Labels
bug rel::6.3.0 Released in 6.3.0

Comments

@sanikolaev
Copy link
Collaborator

In Manticore 6.2.13 00864701e@24021421 dev alter table ... exceptions= fails like this:

➜  ~ mysql -P9315 -h0 -e "drop table if exists t; create table t(f text);"

➜  ~ ls -la data/t
total 24
drwx------  6 sn  staff  192 22 Feb 17:07 .
drwxr-xr-x@ 9 sn  staff  288 22 Feb 17:07 ..
-rw-------  1 sn  staff    0 22 Feb 17:07 t.lock
-rw-------  1 sn  staff  521 22 Feb 17:07 t.meta
-rw-------  1 sn  staff   20 22 Feb 17:07 t.ram
-rw-------  1 sn  staff    3 22 Feb 17:07 t.settings

➜  ~ cat /tmp/exc
AT&T => AT&T

➜  ~ mysql -P9315 -h0 -e "alter table t exceptions='/tmp/exc'"
ERROR 1064 (42000) at line 1: 't' failed to create tokenizer, error ''synonyms': failed to open data/t/exc: No such file or directory'

Config:

➜  ~ cat configless.conf
searchd {
    listen = 9315:mysql
    log = searchd.log
    pid_file = searchd.pid
    data_dir = data
}
@sanikolaev
Copy link
Collaborator Author

Now it fails differently, but still fails:

mysql> alter table t exceptions='/tmp/exc';
ERROR 1064 (42000): 't' failed to create tokenizer, error ''synonyms': failed to open /var/lib/manticore/t/exc: No such file or directory'

@tomatolog you recently had to deal with external files and may be the best candidate to address this issue, so I'm reassigning this to you.

@tomatolog
Copy link
Contributor

should be fixed at 83733d1 now all external files will be handled properly on alter table

@sanikolaev sanikolaev added the rel::upcoming Upcoming release label May 3, 2024
@sanikolaev sanikolaev added rel::6.3.0 Released in 6.3.0 and removed rel::upcoming Upcoming release labels May 23, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
bug rel::6.3.0 Released in 6.3.0
Projects
None yet
Development

No branches or pull requests

3 participants